Independent data partitioning in Oracle databases

Marcin Kaleta, Janusz Chwastowski, Krzysztof Czajkowski

Abstract


Data partitioning plays an important role in the designing and implementation of advanced database solutions. Due to the performance, protection and flexibility in administration, such a solution has very wide applications in databases and data warehouses. This option exists in many servers, but in the case of commercial systems it is available only in the most expensive versions. In this paper, the authors’ implementation of partitioning is presented. This implementation can be used in the version of database servers that do not offer a native partitioning option.

Keywords


database; data partitioning; tuning

Full Text:

PDF (Polski)

References


Oracle® Database VLDB and Partitioning Guide 11g Release 2 (11.2).

Database Partitioning, Table Partitioning, and MDC for DB2 9. International Technical Support Organization, 2007.

Talmage R.: Partitioned Table and Index Strategies Using SQL Server 2008. SQL Server Technical Article, 2008.

MySQL Reference Manual, Chapter 17. Partitioning: http://dev.mysql.com/doc/refman/5.6/en/partitioning.html.

PostgreSQL, Documentation, 5.9. Partitioning: http://www.postgresql.org/docs/current/static/ddl-partitioning.html.

Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2).

Lightstone S., Teorey T., Nadeau T.: Physical Database Design: the database professional’s guide to exploiting indexes, views, storage, and more. Morgan Kaufmann Publishers, 2007.

Feuerstein S., Beresniewicz J., Dawes C.: Oracle PL/SQL. Pakiety i funkcje. Leksykon kieszonkowy. Helion, Gliwice 2001.




DOI: http://dx.doi.org/10.21936/si2013_v34.n2B.56