US6385604B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
Assignee: HYPEROLL ISRAEL Ltd
•
Filing: 2000-08-09
•
Granted: 2002-05-07
•
Expires: 2020-08-09
Abstract
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.
Inventors
- 👤 Reuven Bakalash
- 👤 Guy Shaked
- 👤 Joseph Caspi
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 17:03
CPC Classifications
C; C03; C03B; C03B37/00; C03B37/01; C03B37/02; C03B37/025; C03B37/027; C03B37/02718; G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; C03B2203/00; C03B2203/36; C03B2205/00; C03B2205/42; C03B2205/55; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99935; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
137 words
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.
Claim 2
Dependent Claim
137 words
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.
Claim 3
Dependent Claim
49 words
The RDBMS of claim 1 , wherein said aggregation module includes a query handling mechanism for receiving query statements, and wherein communication between said query processing mechanism and said query handling mechanism is accomplished by forwarding the given query statement to the query handling mechanism of the aggregation module.
Claim 4
Dependent Claim
60 words
The RDBMS of claim 2 , wherein said query handling mechanism extracts dimensions from the received query statement and forwards the dimensions to the storage handler, and wherein the storage handler accesses locations of the non-relational multi-dimensional data store based upon the forwarded dimensions and returns the retrieved data back to the query servicing mechanism for communication to the user.
Claim 5
Dependent Claim
54 words
The RDBMS of claim 1 , wherein said aggregation module includes a data loading mechanism for loading at least fact data from the relational data store, an aggregation engine for aggregating the fact data and an storage handler for storing the fact data and resultant aggregated fact data in the non-relational multi-dimensional data store.
Claim 6
Dependent Claim
75 words
The RDBMS of claim 4 , wherein said aggregation module includes control logic that, upon determining that the non-relational multi-dimensional data store does not contain data required to service the given query statement, controls the data loading mechanism and aggregation engine to aggregate at least fact data required to service the given query statement and controls the aggregation module to return the aggregated data back to the query servicing mechanism for communication to the user.
Claim 7
Dependent Claim
18 words
The RDBMS of claim 1 , in combination with a data analysis engine to realize an OLAP system.
Claim 8
Dependent Claim
14 words
The RDBMS of claim 6 , wherein said OLAP system is a ROLAP system.
Claim 9
Dependent Claim
23 words
The RDBMS of claim 1 , for use as an enterprise wide data warehouse that interfaces to a plurality of information technology systems.
Claim 10
Dependent Claim
17 words
The RDBMS of claim 1 , for use as a database store in an informational database system.
Claim 11
Dependent Claim
16 words
The RDBMS of claim 9 , wherein said informational database system is a spreadsheet modeling program.
Claim 12
Dependent Claim
30 words
The RDBMS of claim 1 , wherein said query statements are generated by a query interface in response to communication of a natural language query communicated from a client machine.
Claim 13
Dependent Claim
24 words
The RDBMS of claim 11 , wherein said client machine comprises a web-enabled browser to communicate said natural language query to the query interface.
Claim 14
Dependent Claim
25 words
The RDBMS of claim 1 , wherein said interface that provides communication between said query processing mechanism and said aggregation module comprises a standard interface.
Claim 15
Dependent Claim
22 words
The RDBMS of claim 13 , wherein said standard interface is selected from the group consisting of OLDB, OLE-DB, ODBC, SQL, JDBC.
Claim 16
Dependent Claim
142 words
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.
Claim 17
Dependent Claim
142 words
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.
Claim 18
Dependent Claim
40 words
The method of claim 15 , further comprising the step of extracting dimensions from the given query statement, accessing locations of the non-relational multi-dimensional data store based upon the extracted dimensions, and returning the retrieved data back to the user.
Claim 19
Dependent Claim
54 words
The method of claim 15 , wherein said aggregation module includes a data loading mechanism for loading at least fact data from the relational data store, an aggregation engine for aggregating the fact data and an storage handler for storing the fact data and resultant aggregated fact data in the non-relational multi-dimensional data store.
Claim 20
Dependent Claim
64 words
The method of claim 17 , wherein said aggregation module, upon determining that the non-relational multi-dimensional data store does not contain data required to service the given query statement, controls the data loading mechanism and aggregation engine to aggregate at least fact data required to service the given query statement and controls the aggregation module to return the aggregated data back to the user.
Claim 21
Dependent Claim
25 words
The method of claim 15 , further comprising the step of performing data analysis operations on the retrieved data as part of an OLAP system.
Claim 22
Dependent Claim
19 words
The method of claim 19 , RDBMS of claim 6 , wherein said OLAP system is a ROLAP system.
Claim 23
Dependent Claim
26 words
The method of claim 15 , wherein said RDBMS is used as an enterprise wide data warehouse that interfaces to a plurality of information technology systems.
Claim 24
Dependent Claim
20 words
The method of claim 15 , wherein said RDBMS is uses as a database store in an informational database system.
Claim 25
Dependent Claim
16 words
The method of claim 22 , wherein said informational database system is a spread-sheet modeling program.
Claim 26
Dependent Claim
30 words
The method of claim 15 , wherein said query statements are generated by a query interface in response to communication of a natural language query communicated from a client machine.
Claim 27
Dependent Claim
24 words
The method of claim 24 , wherein said client machine comprises a web-enabled browser to communicate said natural language query to the query interface.
Claim 28
Dependent Claim
21 words
The method of claim 25 , wherein said interface that is operably coupled to said aggregation module comprises a standard interface.
Claim 29
Dependent Claim
22 words
The method of claim 26 , wherein said standard interface is selected from the group consisting of OLDB, OLE-DB, ODBC, SQL, JDBC.
References Cited (Backward Citations)
US5257365A
Cited
US5379419A
Cited
US5745764A
Cited
US5805885A
Cited
US5781896A
Cited
US5832475A
Cited
US5864857A
Cited
US5857184A
Cited
US5799300A
Cited
US5822751A
Cited
US5850547A
Cited
US5926820A
Cited
US5978788A
Cited
US6182060B1
Cited
US5890151A
Cited
US5987467A
Cited
US6003029A
Cited
US6141655A
Cited
US6023695A
Cited
US6151601A
Cited
US6161103A
Cited
US6108647A
Cited
US6324533B1
Cited
US5991754A
Cited
US6173310B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-05-06 | 2005-11-05 | 2006-05-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-05-06 | 2009-11-05 | 2010-05-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-05-06 | 2013-11-05 | 2014-05-07 | $7700.00 | Window Closed / Lapsed |