Selection of a Suitable Partitioning Strategy for Multidimensional Database

Main Article Content

Vaibhav Khanna
Dr Anil Rajput,Kshmasheel Mishra, Purushottam sharma

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

Download data is not yet available.

Article Details

Section
Articles