US6161103A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for creating aggregates for use in a datamart
Assignee: Comdisco Inc
•
Filing: 1998-05-06
•
Granted: 2000-12-12
•
Expires: 2018-05-06
Abstract
Abstract A method for automatically defining aggregates for use in a datamart is described. The datamart includes fact and dimension tables. The method comprises accessing a schema description and an aggregates description for the datamart. The schema description specifies a schema, which in turn, defines the relationships between the fact tables and dimension tables of the datamart. The aggregates description specifies the aggregates, which define, from the schema definition, which aggregate tables are to be created from the fact tables and dimension tables in the datamart. The data in the aggregates correspond to the pre-computed results of specific types of queries. In response to a query, the aggregates can be searched to determine an appropriate aggregate to use in response to that query. The schema description is used to create a first set of commands to create and populate the fact and dimension tables. Additionally, a second set of commands to create, populate and access, the aggregates are also created from the aggregates description. Some of the commands of the first set of commands are executed causing the creation and population of the tables. Some of the commands of the second set of commands are executed causing the creation of the aggregate tables. Some of the remaining commands of the second set of commands are executed to populate the aggregate tables from the populated fact and dimension tables.
Inventors
- 👤 Allon Rauer
- 👤 Gregory Vincent Walsh
- 👤 John P. McCaskey
- 👤 Craig David Weissman
- 👤 Jeremy A. Rassen
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-23 14:58
CPC Classifications
G; G06; G06Q; G06Q30/00; G06Q30/02; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 14
Claim 1
Independent Claim
104 words
A method of generating a datamart having aggregates using a computer system, the method comprising: accessing a schema definition which describes a schema for the datamart; accessing a description of a set of aggregates to be generated in the datamart; generating a set of commands from the schema definition, including, generating a set of table creation commands, and generating a set of table access and manipulation commands, the set of table access and manipulation commands corresponding to the semantic meaning of the schema; generating a set of generate aggregates commands; and generating a set of aggregate tables using the set of generate aggregates commands.
Claim 2
Independent Claim
104 words
A method of generating a datamart having aggregates using a computer system, the method comprising: accessing a schema definition which describes a schema for the datamart; accessing a description of a set of aggregates to be generated in the datamart; generating a set of commands from the schema definition, including, generating a set of table creation commands, and generating a set of table access and manipulation commands, the set of table access and manipulation commands corresponding to the semantic meaning of the schema; generating a set of generate aggregates commands; and generating a set of aggregate tables using the set of generate aggregates commands.
Claim 3
Dependent Claim
32 words
The method of claim 1 further comprising accessing data in the datamart, the description of the schema, and the description of the set of aggregates to populate the set of aggregate tables.
Claim 4
Dependent Claim
42 words
The method of claim 1 wherein the description of the set of aggregates is stored in a set of aggregate description tables, and wherein the generating the set of aggregate commands includes performing a query on the set of aggregate description tables.
Claim 5
Dependent Claim
19 words
The method of claim 1 wherein the description of the set of aggregates defines a group of related aggregates.
Claim 6
Dependent Claim
23 words
The method of claim 1 wherein the description of the set of aggregates defines a set of fact tables that share an aggregate.
Claim 7
Dependent Claim
25 words
The method of claim 1 wherein the description of the set of aggregates defines an aggregate type for each dimension that corresponds to an aggregate.
Claim 8
Independent Claim
81 words
A method of querying a datamart comprising: accessing a definition of a schema for the datamart and a definition of a set of aggregates for the datamart; generating the set of aggregates for the datamart from the definition of the schema and the definition of the aggregates; determining at least an aggregate of the set of aggregates that most closely corresponds to the query, the query corresponding to the schema definition; querying the datamart for the data corresponding to the aggregate.
Claim 9
Independent Claim
81 words
A method of querying a datamart comprising: accessing a definition of a schema for the datamart and a definition of a set of aggregates for the datamart; generating the set of aggregates for the datamart from the definition of the schema and the definition of the aggregates; determining at least an aggregate of the set of aggregates that most closely corresponds to the query, the query corresponding to the schema definition; querying the datamart for the data corresponding to the aggregate.
Claim 10
Dependent Claim
52 words
The method of claim 7 wherein the definition of the set of aggregates is stored in a set of tables in a database, and wherein determining the aggregate includes performing a view on the set of tables to determine a possible set of aggregates that can be used to answer the query.
Claim 11
Dependent Claim
17 words
The method of claim 7 wherein determining the aggregate includes time navigation of the set of aggregates.
Claim 12
Dependent Claim
34 words
The method of claim 7 wherein the query corresponds to a backlog query and wherein determining the aggregate includes determining a subset of the aggregates that can be combined to generate a backlog result.
Claim 13
Independent Claim
124 words
A system for generating a datamart having aggregates, the system comprising: a data store for storing a description of a schema for the datamart; a first program for accessing a description of a set of aggregates to be generated in the datamart, the first program further for generating a set of commands from the schema definition, the first program further for generating a set of table creation commands, and for generating a set of table access and manipulation commands, the set of table access and manipulation commands corresponding to the semantic meaning of the schema; a second program for generating a set of generate aggregates commands, and the second program for generating a set of aggregate tables using the set of generate aggregates commands.
Claim 14
Independent Claim
124 words
A system for generating a datamart having aggregates, the system comprising: a data store for storing a description of a schema for the datamart; a first program for accessing a description of a set of aggregates to be generated in the datamart, the first program further for generating a set of commands from the schema definition, the first program further for generating a set of table creation commands, and for generating a set of table access and manipulation commands, the set of table access and manipulation commands corresponding to the semantic meaning of the schema; a second program for generating a set of generate aggregates commands, and the second program for generating a set of aggregate tables using the set of generate aggregates commands.
References Cited (Backward Citations)
US5386556A
Cited
US5659724A
Cited
US5806060A
Cited
US5550971A
Cited
US5675785A
Cited
US5995958A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-12-12 | 2004-06-12 | 2004-12-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-12-12 | 2008-06-12 | 2008-12-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-12-12 | 2012-06-12 | 2012-12-12 | $7700.00 | Window Closed / Lapsed |