Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
AssigneeHyperroll Israel, Ltd.
InventorsReuven Bakalash, Guy Shaked, Joseph Caspi
Life of this patent
Estimating the term…
Abstract
Improved method of and apparatus for joining and aggregating data elements integrated within a relational database management system (RDBMS) using a non-relational multi-dimensional data structure (MDD). The improved RDBMS system of the present invention can be used to realize achieving a significant increase in system performance (e.g. [deceased] decreased access/search time), user flexibility and ease of use. The improved RDBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system or the like.
Claims27
A relational database management system (RDBMS) comprising:
- a relational data store storing fact data;
- an aggregation module, operatively coupled to the relational data store, for aggregating the fact data and storing the resultant aggregated data in a non-relational multi-dimensional data store;
- a query servicing mechanism, operatively coupled to the aggregation module, for servicing query statements generated in response to user input, said query servicing mechanism comprising:
- a reference generating mechanism for generating a user-defined reference to aggregated fact data generated by the aggregation module;
- and
- a query processing mechanism for processing a given query statement, wherein, upon identifying that the given query statement is on said user-defined reference, communicates with said aggregation module over an interface therebetween to retrieve portions of aggregated fact data pointed to by said reference that are relevant to said given query statement.
In a relational database management system (RDBMS) comprising a relational data store storing fact data, a method for aggregating the fact data and providing query access to the aggregated data comprising the steps of:
- providing an integrated aggregation module, operatively coupled to the relational data store, for aggregating the fact data and storing the resultant aggregated data in a non-relational multi-dimensional data store;
- in response to user input, generating a reference to aggregated fact data generated by the aggregation module;
- and
- processing a given query statement generated in response to user input, wherein, upon identifying that the given query statement is on said reference, communicating with said integrated aggregation module over an interface operably coupled thereto to retrieve [retrieving] from the integrated aggregation module portions of aggregated fact data pointed to by said reference that are relevant to said given query statement.
Dependencies are inferred from the claim text.