Patent ID: 6763357
Filing Date: 2004-07-13
Classification: G06F,Y10S

Abstract:
A method for caching multi-dimensional data sets for an on-line analytical processing (OLAP) system, comprising:(a) accessing multi-dimensional data from a relational database management system (RDBMS) in order to answer at least a portion of a first query; (b) storing the multi-dimensional data in an active cache; (c) determining when it is possible to answer at least a portion of a second query by aggregating the multi-dimensional data stored in the cache; and (d) selecting from among a plurality of aggregation paths and answering the portion of the second query by aggregating the multi-dimensional data stored in the cache using the selected aggregation path, after it has been determined that it is possible to answer the portion of the second query by aggregating the multi-dimensional data stored in the cache.