Partitioning Retail Database for Performance Improvement
Main Article Content
Abstract
Retail data analysts have a challenging task to analyze large datasets relating to retail stores. With the advent of materialized views, a database administrator creates one or more materialized views to expedite query results. This requires a proactive decision making on the right partitioning strategy during the logical design phase and the same should be implemented in the physical database schema. This in turn requires experimentation with various alternative strategies for measured performance improvements before suggesting these strategies as standard data models. This paper outlines the performance improvement techniques relating to table partitioning experiments conducted on retail sample data set. The partitioning strategies were initially applied on a representative subset of the real data (10K and 100K records). Then the experiments were conducted to measure performance improvements on the entire model data (10 lakh records). Significant performance benefits were achieved in the experiments conducted during this study using right partitioning strategy. These strategies can positively contribute towards improving the overall user satisfaction.
Â
Keywords: Multidimensional databases, 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.