US6434544B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Stand-alone cartridge-style data aggregation server providing data aggregation for OLAP analyses
Assignee: HYPEROLL ISRAEL Ltd
•
Filing: 2000-02-28
•
Granted: 2002-08-13
•
Expires: 2020-02-28
Abstract
Abstract An improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB) realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional OLAP systems to achieve significant improvements in system performance. In accordance with the principals of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distributed data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. The stand-alone aggregation server of the present invention can be used to realize (i) an improved MDDB for supporting on-line analytical processing (OLAP) operations, (ii) an improved Internet URL Directory for supporting on-line information searching operations by Web-enabled client machines, as well as (iii) diverse types of MDDB-based systems for supporting real-time control of processes in response to complex states of information reflected in the MDDB.
Inventors
- 👤 Reuven Bakalash
- 👤 Guy Shaked
- 👤 Joseph Caspi
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 22:54
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2455; G06F16/24553; G06F16/24554; G06F16/24556; G06F16/28; G06F16/283; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 19
Claim 1
Independent Claim
132 words
A stand-alone data aggregation server for use with any one of a plurality of different OLAP servers that each provide an application layer and presentation layer through which multiple users perform OLAP analyses via interaction with client machines operably coupled thereto, the data aggregation server comprising: an aggregation engine that is integrated with a multidimensional data store and an interface, the aggregation engine performing data aggregation operations on data loaded from, database and storing the resultant aggregated data in a multidimensional datastore; and the interface receiving requests communicated from any one of said plurality of differer; OLAP servers, accessing the aggregation engine to retrieve from the multidimensional datastore aggregated data pertaining to said requests, and communicating the aggregated data corresponding to said requests to said one OLAP server that communicated said requests.
Claim 2
Dependent Claim
132 words
A stand-alone data aggregation server for use with any one of a plurality of different OLAP servers that each provide an application layer and presentation layer through which multiple users perform OLAP analyses via interaction with client machines operably coupled thereto, the data aggregation server comprising: an aggregation engine that is integrated with a multidimensional data store and an interface, the aggregation engine performing data aggregation operations on data loaded from, database and storing the resultant aggregated data in a multidimensional datastore; and the interface receiving requests communicated from any one of said plurality of differer; OLAP servers, accessing the aggregation engine to retrieve from the multidimensional datastore aggregated data pertaining to said requests, and communicating the aggregated data corresponding to said requests to said one OLAP server that communicated said requests.
Claim 3
Dependent Claim
27 words
The stand-alone data aggregation server of claim 1 , wherein the plurality of different OLAP servers comprise a plurality of different OLAP servers distributed by different vendors.
Claim 4
Dependent Claim
19 words
The stand-alone data aggregation server of claim 1 , wherein the interface implements a standard protocol for accessing data.
Claim 5
Dependent Claim
22 words
The stand-alone data aggregation server of claim 3 , wherein the standard protocol comprises one of OLDB, OLE-DB, ODBC, SQL, and JDBC.
Claim 6
Dependent Claim
23 words
The stand-alone data aggregration server of claim 1 , wherein computational tasks performed by the aggregation engine is restricted to data aggregation operations.
Claim 7
Dependent Claim
64 words
The stand-alone data aggregation server of claim 1 , wherein said interface extracts dimensions from the received requests and forwards the dimensions to a storage management module, and wherein the storage management module accesses locations of the multidimensional datastore based upon the forwarded dimensions and returns the retrieved data back to the interface for communication to the one OLAP server that communicated said requests.
Claim 8
Dependent Claim
68 words
The stand-alone data aggregation server of claim 1 , further comprising control logic that, upon determining that multidimensional datastore does not contain aggregated data required to service at least one given request, controls the aggregation engine to perform aggregation operations to thereby generate the required aggregated data and return the required aggregated data back to the interface for communication to said one OLAP server that communicated said requests.
Claim 9
Dependent Claim
33 words
The stand-alone data aggregation server of claim 7 , wherein the control logic controls a storage management module to store the required aggregation data generated by the aggregation engine in the multidimensional database.
Claim 10
Dependent Claim
61 words
The stand-alone data aggregation server of claim 1 , wherein data stored in the multidimensional datastore is logically partitioned into N dimensions, wherein the aggregation engine performs a first stage of aggregation operations along a first dimension, and performs and second stage of aggregation operations for a given slice in the first dimension along N−1 dimensions other than the first dimension.
Claim 11
Dependent Claim
45 words
The stand-alone data aggregation server of claim 9 , wherein the aggregation engine stores the resultant data of aggregration operations for the given slice as a record in a data file, wherein location of the record in the data file is stored in a directory.
Claim 12
Dependent Claim
34 words
The stand-alone data aggregation server of claim 10 , wherein the directory stores, for a given record, a start address and end address of the record and a physical address of the data file.
Claim 13
Dependent Claim
29 words
The stand-alone data aggregation server of claim 1 , wherein time delay in responding to said requests is equivalent to accessing a local datastore of the one OLAP server.
Claim 14
Dependent Claim
72 words
An on-line analytical processing (OLAP) system comprising: a plurality of client machines communicating with an OLAP server over a network; the OLAP server including OLAP analysis logic and presentation logic to enable user-directed OLAP analysis on data; and the stand-alone aggregation server of claim 1 that operably communicates with the OLAP server to perform data aggregation operations on the data, and store and manage such data for access by the OLAP server.
Claim 15
Dependent Claim
16 words
The OLAP system of claim 13 , wherein the network includes the infrastructure of the Internet.
Claim 16
Dependent Claim
22 words
The OLAP system of claim 14 , wherein said client machines include a web-browser-based user interface that enables said user-directed OLAP analysis.
Claim 17
Dependent Claim
69 words
A decision support system operable within an enterprise, the system comprising: a plurality of client machines communicating with a first server over a network; the first server including support for user-directed analysis of data; and the stand-alone aggregation server of claim 1 that operably communicates with the first server to perform data aggregation operations on the data, and store and manage such data for access by the first server.
Claim 18
Dependent Claim
17 words
The decision support system of claim 16 , wherein the network includes the infrastructure of the Internet.
Claim 19
Dependent Claim
22 words
The decision support system of claim 17 , wherein said client machines include a web-browser-based user interface that enables said user-directed analysis.
References Cited (Backward Citations)
US5805885A
Cited
US6064999A
Cited
US6208975B1
Cited
US5822751A
Cited
US6182061B1
Cited
US5794246A
Cited
US6115705A
Cited
US6151601A
Cited
US6161103A
Cited
US6212515B1
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-08-12 | 2006-02-11 | 2006-08-13 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-08-12 | 2010-02-11 | 2010-08-13 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-08-12 | 2014-02-11 | 2014-08-13 | $7700.00 | Window Closed / Lapsed |