Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
6 Assignments
0 Petitions
Accused Products
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 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.
-
Citations
57 Claims
-
1-34. -34. (canceled)
-
35. A relational database management system (RDBMS) comprising:
-
a view mechanism;
a relational data store storing fact data;
an aggregation module, operatively coupled to said relational data store, for aggregating said fact data and storing the resultant aggregated data in a non-relational multi-dimensional data store;
a query servicing mechanism, operatively coupled to said aggregation module, for servicing query statements generated in response to user input, said query servicing mechanism comprising;
a reference generating mechanism enabled by using said view 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 to retrieve portions of aggregated fact data pointed to by said reference that are relevant to said given query statement. - View Dependent Claims (36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46)
-
-
47. In a relational database management system (RDBMS) comprising a view mechanism and 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 said 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, using said view mechanism to generate a reference to aggregated fact data generated by said integrated aggregation module and stored in said non-relational multi-dimensional data store; and
processing a given query statement generated in response to user input, wherein, upon identifying that the given query statement is on said reference, retrieving from said integrated aggregation module portions of aggregated fact data pointed to by said reference that are relevant to said given query statement. - View Dependent Claims (48, 49, 50, 51, 52, 53, 54, 55, 56, 57)
-
Specification