Database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) for servicing query statements in a manner transparent to client machine
First Claim
1. :
- A database management system (DBMS) for servicing query statements through one or more client machines, said DBMS comprising;
a query interface adapted to receive query statements from said one or more client machines;
a query processing mechanism for processing each query statement received from 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;
a query handling mechanism operably coupled to said single query interface; and
a relational data store having relational tables for storing fact data, and a meta-data store for storing a dictionary containing dimension data;
a multi-dimensional database (MDDB) for storing aggregated fact data in a multi-dimensional data structure;
a data loading mechanism for loading said meta-data and said fact data into said MDDB;
an aggregation engine for calculating aggregated fact data from the fact data according to a multi-dimensional data aggregation process;
a data handling mechanism for storing aggregated fact data in said MDDB and retrieving aggregated fact data from said MDDB;
wherein said query handling mechanism (i) receives each query request, (ii) extracts a set of dimensions associated with said query request, (iii) uses said dimensions to retrieve aggregated fact data from said MDDB, and (iv) forwards retrieved aggregated fact data to said query processing mechanism for subsequent processing, if needed; and
wherein when said query processing mechanism determines that servicing of one or more query requests require data stored in said relational tables of said relational data store, then said query processing mechanism automatically routes said one or more query requests to said relational data tables, so that data can be 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
wherein when said query processing mechanism determines that servicing of one or more query requests require aggregated data stored in said MDDB, then said query processing 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.
9 Assignments
0 Petitions
Accused Products
Abstract
A database management system (DBMS) for servicing query statements through one or more client machines. The DBMS comprises a query interface adapted to receive query statements from the client machines. The query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from a multi-dimensional database (MDDB), and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query processing 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.
-
Citations
15 Claims
-
1. :
- A database management system (DBMS) for servicing query statements through one or more client machines, said DBMS comprising;
a query interface adapted to receive query statements from said one or more client machines; a query processing mechanism for processing each query statement received from 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; a query handling mechanism operably coupled to said single query interface; and a relational data store having relational tables for storing fact data, and a meta-data store for storing a dictionary containing dimension data; a multi-dimensional database (MDDB) for storing aggregated fact data in a multi-dimensional data structure; a data loading mechanism for loading said meta-data and said fact data into said MDDB; an aggregation engine for calculating aggregated fact data from the fact data according to a multi-dimensional data aggregation process; a data handling mechanism for storing aggregated fact data in said MDDB and retrieving aggregated fact data from said MDDB; wherein said query handling mechanism (i) receives each query request, (ii) extracts a set of dimensions associated with said query request, (iii) uses said dimensions to retrieve aggregated fact data from said MDDB, and (iv) forwards retrieved aggregated fact data to said query processing mechanism for subsequent processing, if needed; and wherein when said query processing mechanism determines that servicing of one or more query requests require data stored in said relational tables of said relational data store, then said query processing mechanism automatically routes said one or more query requests to said relational data tables, so that data can be 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 wherein when said query processing mechanism determines that servicing of one or more query requests require aggregated data stored in said MDDB, then said query processing 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)
- A database management system (DBMS) for servicing query statements through one or more client machines, said DBMS comprising;
Specification