Active caching for multi-dimensional data sets in relational database management system
First Claim
Patent Images
1. 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 a cache;
(c) determining whether 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) aggregating the multi-dimensional data stored in the cache in order to answer at least the portion of the second query, when it is has been determined that it is possible to answer at least the portion of the second portion by aggregating the multi-dimensional data stored in the cache.
2 Assignments
0 Petitions
Accused Products
Abstract
An “active cache”, for use by On-Line Analytic Processing (OLAP) systems, that can not only answer queries that match data stored in the cache, but can also answer queries that require aggregation or other computation of the data stored in the cache.
-
Citations
15 Claims
-
1. 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 a cache;
(c) determining whether 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) aggregating the multi-dimensional data stored in the cache in order to answer at least the portion of the second query, when it is has been determined that it is possible to answer at least the portion of the second portion by aggregating the multi-dimensional data stored in the cache. - View Dependent Claims (2, 3, 4, 5)
selecting from among a plurality of aggregation paths to answer the portion of the second query 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.
-
-
6. An on-line analytical processing (OLAP) system that caches multi-dimensional data sets, comprising:
-
(a) a computer system;
(b) logic, performed by the computer system, for;
(1) accessing multi-dimensional data from a relational database management system (PDBMS) in order to answer at least a portion of a first query;
(2) storing the multi-dimensional data in a cache;
(3) determining whether it is possible to answer at least a portion of a second query by aggregating the multi-dimensional data stored in the cache; and
(4) aggregating the multi-dimensional data stored in the cache in order to answer at least the portion of the second query, when it is has been determined that it is possible to answer at least the portion of the second portion by aggregating the multi-dimensional data stored in the cache. - View Dependent Claims (7, 8, 9, 10)
selecting from among a plurality of aggregation paths to answer the portion of the second query 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.
-
-
11. An article of manufacture embodying logic 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 a cache;
(c) determining whether 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) aggregating the multi-dimensional data stored in the cache in order to answer at least the portion of the second query, when it is has been determined that it is possible to answer at least the portion of the second portion by aggregating the multi-dimensional data stored in the cache. - View Dependent Claims (12, 13, 14, 15)
selecting from among a plurality of aggregation paths to answer the portion of the second query 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.
-
Specification