Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines
First Claim
1. A relational database management system (RDBMS) comprising:
- a query interface adapted to receive query statements from one or more client machines, and generating one or more query requests by disintegrating the query statement so that each said query request specifies a set of dimensions;
a query processing mechanism for processing each query request received from said query interface;
a query handling mechanism for handling said query requests;
a relational data store having relational tables for storing fact data, and a meta-data store for storing a dictionary containing dimension data; and
a multi-dimensional database (MDDB) for storing aggregated fact data in a multi-dimensional data structure;
wherein query statements from said one or more client machines are serviced by a method comprising the steps of;
(a) loading said meta-data and said fact data from said relational data store into said MDDB;
(b) calculating aggregated fact data from the fact data according to a multi-dimensional data aggregation process, and storing aggregated fact data in said MDDB;
(c) transmitting a query statement from said one or more client machines to said query interface, and generating one or more query requests by disintegrating the query statement so that each said query request specifies a set of dimensions;
(d) said query handling mechanism(i) receiving each query request,(ii) extracting the set of dimensions associated with said query request,(iii) using said dimensions to retrieve aggregated fact data from said MDDB, and(iv) forwarding retrieved aggregated fact data to said query processing mechanism for subsequent processing, if needed; and
(e) said query processing mechanism processing said one or more query requests, and(i) when said query processing mechanism determines that servicing said one or more query requests requires data stored in said relational tables of said relational data store, then said query handling mechanism automatically routes said one or more query requests to said relational data tables, so that data is accessed from said relational tables and forwarded to said query processing mechanism for use in servicing said one or more query requests, in a manner transparent to said client machine, and(ii) when said query processing mechanism determines that servicing said one or more query requests requires aggregated data stored in said MDDB, then said query handling mechanism automatically routes said one or more query requests to said MDDB, so that aggregated data can be accessed from said MDDB and forwarded to said query processing mechanism for use in servicing said one or more query requests, in a manner transparent to said client machine.
10 Assignments
0 Petitions
Accused Products
Abstract
A relational database management system (RDBMS) for servicing query statements from one or more client machines, using a relational data store and a multi-dimensional database (MDDB). The RDBMS includes a query interface which is adapted to receive query statements from the client machines, and to generate one or more query requests. The RDBMS includes a query handling mechanism which receives each request from the query interface, extracts a set of dimensions associated with the request, uses the dimensions to retrieve aggregated fact data from the MDDB, and forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism of the RDBMS determines that servicing one or more query requests requires data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. When the query processing mechanism determines that servicing one or more query requests requires aggregated data from the MDDB, then the query handling mechanism automatically routes the requests to the MDDB, so that data can be accessed from the MDDB and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine.
-
Citations
15 Claims
-
1. A relational database management system (RDBMS) comprising:
-
a query interface adapted to receive query statements from one or more client machines, and generating one or more query requests by disintegrating the query statement so that each said query request specifies a set of dimensions; a query processing mechanism for processing each query request received from said query interface; a query handling mechanism for handling said query requests; a relational data store having relational tables for storing fact data, and a meta-data store for storing a dictionary containing dimension data; and a multi-dimensional database (MDDB) for storing aggregated fact data in a multi-dimensional data structure; wherein query statements from said one or more client machines are serviced by a method comprising the steps of; (a) loading said meta-data and said fact data from said relational data store into said MDDB; (b) calculating aggregated fact data from the fact data according to a multi-dimensional data aggregation process, and storing aggregated fact data in said MDDB; (c) transmitting a query statement from said one or more client machines to said query interface, and generating one or more query requests by disintegrating the query statement so that each said query request specifies a set of dimensions; (d) said query handling mechanism (i) receiving each query request, (ii) extracting the set of dimensions associated with said query request, (iii) using said dimensions to retrieve aggregated fact data from said MDDB, and (iv) forwarding retrieved aggregated fact data to said query processing mechanism for subsequent processing, if needed; and (e) said query processing mechanism processing said one or more query requests, and (i) when said query processing mechanism determines that servicing said one or more query requests requires data stored in said relational tables of said relational data store, then said query handling mechanism automatically routes said one or more query requests to said relational data tables, so that data is accessed from said relational tables and forwarded to said query processing mechanism for use in servicing said one or more query requests, in a manner transparent to said client machine, and (ii) when said query processing mechanism determines that servicing said one or more query requests requires aggregated data stored in said MDDB, then said query handling mechanism automatically routes said one or more query requests to said MDDB, so that aggregated data can be accessed from said MDDB and forwarded to said query processing mechanism for use in servicing said one or more query requests, in a manner transparent to said client machine. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
Specification