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.
- 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.
- 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.
- 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.
RELATED APPLICATIONS
This application relates to, and incorporates by reference, the following applications:
“Data Descriptions in a Database System,” having the inventors Vladimir Gorelik, Craig R. Powers, John E. Zicker, and Nicholas F. Engelhardt, having Ser. No. 60/028,640, and filing date Oct. 18, 1996;
“Database Repository With Deferred Transactions,” having the inventors Craig R. Powers, Terris, J. Linenbach, Vladimir Gorelik, Tana C. Netsch, Robert E. Powers, and having U.S. Pat. No. 5,930,794 and filing date Nov. 26, 1996; and,
“Extensible Database Retrieval and Viewing Architecture,” having the inventors of Craig R. Powers, and Vladimir Gorelik having Ser. No. 60/028,725, and filing data Oct. 18, 1996.
US Referenced Citations (22)
Non-Patent Literature Citations (6)
Entry |
Shu, N.C. et al., “Express: A Data EXtraction, Processing, and REStructing System”, ACM Transactions on Database Systems, vol.2, No. 2, Jun. 1977, pp. 134-174. |
Shu, N.C., et al. “Convert: A High Level Translation Definition Language for Data Conversion”, Communications of the ACM, vol. 18, No. 10, Oct. 1975, pp. 557-567. |
Lum, V. Y. et al., “A General Methoology for Data Conversion and Restructuring”, IBM J. Res. Develop., Sep. 1976, pp. 483-497. |
Birss, Edward W. et al., “Generalized software for translating data”, AFIPS Conference Proceedings, 1976 National Computer Conference, Jun. 7-10, 1976 New York, NY, pp. 889-897. |
Rin, N. Adam et al., “An Overview of a System for Automatic Generation of File Conversion Programs”, Software —Practice and Experience, vol. 5, John Wiley & Sons, Ltd. (1975), pp. 193-202. |
Zloof, M. et al., “The System for Business Automation (SBA): Programming Language”, Communications of the ACM, vol. 20, No. 6, Jun. 1977, pp. 385-396. |
Provisional Applications (1)
|
Number |
Date |
Country |
|
60/028640 |
Oct 1996 |
US |