Selection of a Suitable Partitioning Strategy for Multidimensional Database
Main Article Content
Abstract
Taking into consideration the business and practical point of view, a partitioning strategy is normally recognized with a practical goal-seeking perspective. Therefore it needs to be mapped to an Oracle partitioning technical recommendation or specific partitioning strategy matching those business requirements, regulatory compliance, or systems platform. A persisting challenge is the determination of a suitable number of partitions in each dimension. Assumptions and limitations of current data partitioning and placement in database machines have been discussed. A new formula defining the number of partitions accessed by range queries in a single dimension when the number of partitions is small has been derived. A model relating analytics savings due to partitioning and the resultant costs to transaction processing from the partitioning has been presented which shows how to determine the columns to partition, and to what level. Both single and multi-column partitioning has been considered.
Â
Keywords: Partitioning Strategies, performance, partitioning, interval partitioning, range partitioning, hash partitioning, database performance experiments.
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.