Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
First Claim
1. A stand-alone data aggregation server comprising:
- an aggregation engine that is integrated with a multidimensional datastore and an interface;
the aggregation engine performing data aggregation operations on data loaded from a database and storing the resultant aggregated data in the multidimensional datastore; and
the interface receiving requests communicated from any one of a plurality of different computing systems, 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 computing system that communicated said requests.
6 Assignments
0 Petitions
Accused Products
Abstract
Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In one aspect of the present invention, the apparatus is 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 improments in system performance. In accordance with the principles 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 distribute 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. In another aspect of the present invention, the apparatus is integrated within a database management system (DBMS). The improved DBMS 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 DBMS 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, operational database system, or the like.
-
Citations
151 Claims
-
1. A stand-alone data aggregation server comprising:
-
an aggregation engine that is integrated with a multidimensional datastore and an interface;
the aggregation engine performing data aggregation operations on data loaded from a database and storing the resultant aggregated data in the multidimensional datastore; and
the interface receiving requests communicated from any one of a plurality of different computing systems, 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 computing system that communicated said requests. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 149, 150, 151)
-
-
16-148. -148. (canceled)
Specification