US6189004B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for creating a datamart and for creating a query structure for the datamart
Assignee: Comdisco Inc
•
Filing: 1998-05-06
•
Granted: 2001-02-13
•
Expires: 2018-05-06
Abstract
Abstract A method for automatically defining a query interface for a datamart is described. The datamart includes fact and dimension tables. The method comprises accessing a schema description and a query interface 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 query interface description specifies the fields, related to the schema description, that can be used in a query and the way in which results are to be presented to the user. The fields correspond to columns and rows in the fact tables. 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 the query interface is created. Some commands of the first set of commands are executed causing the creation and population of the tables. Some commands of the second set of commands are executed causing the creation of a user interface. A query is generated using the user interface. The query is sent to the system for processing. The results of the query are presented to the user according the second set of commands.
Inventors
- 👤 Jeremy A. Rassen
- 👤 Emile Litvak
- 👤 abhi a. shelat
- 👤 John P. McCaskey
- 👤 Allon Rauer
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 08:02
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; G06F16/24; G06F16/242; G06F16/2423; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 11
Claim 1
Independent Claim
129 words
A method of generating a datamart from a plurality of sources having a query mechanism interface using a computer system, the method comprising: accessing a schema definition which describes a schema for the datamart, the schema defined using a number of semantic meanings describing transformations of data between the plurality of sources and the datamart; accessing a description of the query mechanism interface 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; and generating the query mechanism interface from the query mechanism description and the description of the schema.
Claim 2
Independent Claim
129 words
A method of generating a datamart from a plurality of sources having a query mechanism interface using a computer system, the method comprising: accessing a schema definition which describes a schema for the datamart, the schema defined using a number of semantic meanings describing transformations of data between the plurality of sources and the datamart; accessing a description of the query mechanism interface 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; and generating the query mechanism interface from the query mechanism description and the description of the schema.
Claim 3
Dependent Claim
21 words
The method of claim 1 wherein the query mechanism description defines a set of measures for use the query mechanism interface.
Claim 4
Dependent Claim
33 words
The method of claim 2 wherein a measure in the set of measures includes a set of operations to be performed on data in one or more tables of the set of tables.
Claim 5
Dependent Claim
36 words
The method of claim 3 wherein the set of operations includes an ordered list of operations and wherein an operation in the ordered list of operations includes an arithmetic operation and a Reverse Polish Notation operation.
Claim 6
Dependent Claim
40 words
The method of claim 2 wherein each measure in the set of measures corresponds to a table in the set of tables and wherein the definition of the set of measures defines the correspondence using the definition of the schema.
Claim 7
Dependent Claim
56 words
The method of claim 1 wherein the query mechanism description defines a query form, the query mechanism description defining a set of columns to be displayed on the query form, each column of the set of columns corresponding to a queryable field, the set of columns allowing an user to define a query for the datamart.
Claim 8
Dependent Claim
30 words
The method of claim 1 wherein the query mechanism description defines a query form, the query mechanism description defining a set of filters to be displayed on the query form.
Claim 9
Independent Claim
95 words
A system for querying a datamart, the system comprising: the datamart; a schema definition defining the schema of the datamart; a query interface description defining a user interface for querying the datamart, the query interface description being defined using the schema definition, the schema defined using a number of semantic meanings describing the schema in terms of the meanings of data; and a first program for accessing the query interface description, generating a query form from the query interface description, receiving a query corresponding to the query form and issuing the query to the datamart.
Claim 10
Independent Claim
95 words
A system for querying a datamart, the system comprising: the datamart; a schema definition defining the schema of the datamart; a query interface description defining a user interface for querying the datamart, the query interface description being defined using the schema definition, the schema defined using a number of semantic meanings describing the schema in terms of the meanings of data; and a first program for accessing the query interface description, generating a query form from the query interface description, receiving a query corresponding to the query form and issuing the query to the datamart.
Claim 11
Dependent Claim
53 words
The system of claim 8 wherein first program further comprises a web server and wherein the query form comprises an HTML formatted web page, wherein the query corresponding to the query form corresponds to an HTTP request, and wherein issuing the query includes converting the HTTP request into one or more SQL queries.
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) | 2004-02-13 | 2004-08-14 | 2005-02-13 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-02-13 | 2008-08-14 | 2009-02-13 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-02-13 | 2012-08-14 | 2013-02-13 | $7700.00 | Window Closed / Lapsed |