MECHANISMS FOR MERGING INDEX STRUCTURES IN MOLAP WHILE PRESERVING QUERY CONSISTENCY

摘要

Novel methods are described herein to provide an OLAP database system that performs lock-less bulk insertion while maintaining high query performance and minimizing additional storage requirements. Aspects of the claimed subject matter include novel methods for merging two index structures while maintaining query consistency without the use of a versioning scheme by using copies of vertical segments of an index tree page; a method to prepare and merge two index structures that operates within storage constraints; and a method to execute queries concurrently while index maintenance is in progress while still producing consistent results. According to an aspect of the present disclosure, a flexible index merge mechanism is provided that merges data from incremental indices to a primary data index in three phases: a load phase, a copy phase, and a replace phase.

主权项

1. A method for multi-dimensional online analytical processing in a relational database, the method comprising:
loading incoming data into a plurality of data cubes; incrementally merging the plurality of data cubes in response to a first event; and merging a first data cube of the plurality of data cubes into a main data cube in response to a second event, wherein the main data cube comprises a principal collection of data for the relational database.