Data descriptions in a database system

• US 6,317,737 B1
• Filed: 10/17/1997
• Issued: 11/13/2001
• Est. Priority Date: 10/18/1996
• Status: Expired due to Term

• Current Assignee: Group 1 Software Inc. (Böwe Systec AG)
• Original Assignee: Sagent Technology, Inc. (Böwe Systec AG)
• Inventors: Zicker, John E., Engelhardt, Nicholas F., Powers, Craig R., Gorelik, Vladimir
• Primary Examiner(s): Breene, John
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/951,092
• Time in Patent Office: 1,488 Days
• Field of Search: 707/2, 707/10, 707/102, 707/202, 707/4, 707/3, 707/100, 707/1, 345/334, 345/335, 705/30
• US Class Current: 715/781
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

One embodiment of the invention includes data descriptions of data in a database. The data descriptions include baseviews and metaviews. The baseviews reference specific portions of the actual database schema while the metaviews provide descriptions of baseviews. Each baseview includes specific references to specific columns in tables stored in the database.

Claims

1. A method of accessing data in a data source using a computer system:

accessing a metaview, the metaview referencing one or more baseviews, the metaview not including a reference to the schema of said data source;

accessing each of the one or more baseviews, said each of the one or more baseviews not including a data source specific instruction for accessing said data from said data source, said each of the one or more baseviews including at least a reference to the schema of said data source; and

retrieving the data from the data source using said each of the one or more baseviews by generating a data source specific instruction from said each of the one or more baseviews and transmitting said data source specific instruction to the data source.

2. The method of claim 1 wherein the metaview defines a group of data descriptions, said each of the one or more baseviews being in said group of data descriptions, said group of data descriptions representing a group of data representing a business query.

3. The method of claim 2 wherein the business query corresponds to revenue estimation.

4. The method of claim 1 wherein the metaview corresponds to a part, wherein the part corresponds to any of the one or more baseviews.

5. The method of claim 4 wherein the part is a simple part.

6. The method of claim 4 wherein the part is a computed part, the computed part representing a combination of a plurality of columns into a computational expression.

7. The method of claim 4 wherein the part has constraint such that when the part is used in a query, the result is constrained by the part'"'"'s constraint.

8. The method of claim 1 wherein the metaview corresponds to a join group, wherein the join group defines paths to join at least portions of at least two or more tables from the data source.

9. The method of claim 8 wherein if the join group does not exist at the time of a query, the computer system automatically creates the join group.

10. The method of claim 1 wherein each of the one or more baseviews includes a column reference corresponding to a column of a table in the data source.

11. The method of claim 1 wherein any of the one or more baseviews includes a table alias representing a join not found in the data source.

18. The system of claim 5 wherein a first baseview in the set of baseviews includes a column reference corresponding to a column of a table in the first data source.

12. A system for accessing data comprising:

a first database having data arranged according to a first schema;

a second database having data arranged according to a second schema;

a data retrieval system storing data from the first database and the second database;

a computer having a program storing references to at least a first metaview and a set of baseviews, the metaview referencing the set of baseviews while not including a reference to any of the first schema and second schema, the set of baseviews describing the location of first data in the first schema and the location of second data in the second schema, the program for causing a data source specific instruction to be generated to retrieve data from the data retrieval system that corresponds to the metaview.

13. The system of claim 12 wherein the program stores a reference to a second metaview, the second metaview corresponding to a simple part, wherein the simple part corresponds to a first baseview in the set of baseviews.

14. The system of claim 13 wherein the simple part has a constraint such that when the part is used in a query, the result is constrained by the constraint.

15. The system of claim 12 wherein the first metaview corresponds to a computed part using a first baseview and a second baseview from the set of baseviews in a combination of data corresponding to the first schema and the second schema.

16. The system of claim 12 wherein the first metaview corresponds to a join group, wherein the join group defines paths using a first baseview and a second baseview from the set of baseviews to join data corresponding to the first schema and the second schema.

17. The system of claim wherein if the join group does not exist at the time of a query, the computer automatically creates the join group.

19. A system comprising:

means for accessing a metaview, the metaview referencing one ore more baseviews, the metaview not including references to the schema of said data source;

means for accessing each of the one or more baseviews, said each of the one or more baseviews not including a data source specific instruction for accessing said data from said data source, and said each of the one or more baseviews including at least a reference to the schema of said data source; and

means for retrieving the data from the data source using said each of the one or more baseviews by generating a data source specific instruction from said each of the one or more baseviews and transmitting said data source specific instruction to the data source.

20. A computer readable medium that provides instructions, which when executed on a processor, cause said processor to perform operations comprising:

accessing a metaview, the metaview referencing one or more baseviews, the metaview not including a reference to the schema of said data source;

accessing each of the one or more baseviews, said each of the one or more baseviews not including a data source specific instruction for accessing said data from said data source, said each of the one or more baseviews including at least a reference to the schema of said data source; and

retrieving the data from the data source using said each of the one or more baseviews by generating a data source specific instruction from said each of the one or more baseviews and transmitting said data source specific instruction to the data source.