Metadata model

• US 6,662,188 B1
• Filed: 09/01/2000
• Issued: 12/09/2003
• Est. Priority Date: 09/03/1999
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Cognos Incorporated (International Business Machines Corporation)
• Inventors: Cazemier, Henk, Rasmussen, Glenn D.
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): Mahmoudi, Hassan
• Application Number:
  US09/653,035
• Time in Patent Office: 1,194 Days
• Field of Search: 707/4, 707/10, 707/100, 707/102, 707/201, 707/514, 707/3, 707/5, 707/104.1, 707/103.Y, 707/531, 709/204, 709/315, 709/201, 705/1, 717/108, 717/113, 717/114, 717/100, 717/120
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A metadata model defines model objects to represent one or more data sources. The metadata model comprises a data access layer, a business layer and a package layer. The data access layer contains data access model objects. The data access model objects include a data access model object that describes how to retrieve data from the data sources. The business layer contains business model objects. The business model objects include a business model object that describes a business view of data in the data sources. The package layer contains package model objects which reference subsets of business model objects.

Claims

1. A metadata model defining model objects to represent one or more data sources, the metadata model comprising:

a data access layer containing one or more data access model objects that describe how to retrieve data from the sources;

a business layer containing one or more business model objects that represent the structure of the business to be used in business intelligence environments and;

a package layer containing one or more package model objects which reference subsets of business model objects.

2. The metadata model as claimed in claim 1, wherein the data access model objects include one or more data access model object that are constructed from metadata in the data sources.

3. The metadata model as claimed in claim 1, wherein the business model objects include one or more business model object that are imported form a metadata repository.

4. The metadata model as claimed in claim 1, wherein the business model objects include one or more business model objects that describe business rules.

5. The metadata model as claimed in claim 4, wherein the business model objects that describe business rules include one or more calculations that use a combination of other business model objects.

6. The metadata model as claimed in claim 4, wherein the business model objects that describe business rules include one or more filters that limit a scope of data retrieval through one or more selected business data objects.

7. The metadata model as claimed in claim 4, wherein the business model objects that describe business rules include one or more prompts.

8. The metadata model as claimed in claim 1, wherein the business model objects further include one or more business model objects describing display rules.

9. The metadata model as claimed in claim 8, wherein one of the business model objects that describe display rules is a display style.

10. The metadata model as claimed in claim 1, wherein the package model objects include one or more package model objects that are imported from a metadata repository.

11. The metadata model as claimed in claim 1, wherein the data sources include one or more databases that contains one or more tables having columns;

the data access model objects include table objects that describe definition so of the tables contained in the data sources, and column objects that describe definitions of the tables contained in the data sources; and

the business model objects further include entities that are constructed based on the table objects in the data access layer, and attributes that are constructed based on the column objects in the data access layer.

12. The metadata model as claimed in claim 1, wherein the data sources include one or more files;

the data access model objects include file objects that describe definitions of the files contained in the data sources; and

the business model objects further include entities that are constructed based on the file objects in the data access layer.

13. The metadata model as claimed in claim 1, wherein the data sources include one or more cubes;

the data access model objects include cube objects that describe definitions of the cubes contained in the data sources; and

the business model objects further include entities that are constructed based on the cube objects in the data access layer.

14. The metadata model as claimed in claim 1, wherein the business layer further contains one or more business model objects that describe a business view of data in the data sources.

15. The metadata model as claimed in claim 14, wherein the business model objects that describe a business view are transformed from the data access object.

16. A metadata model containing model objects representing on or more data sources, the data sources containing tables having columns, the metadata model comprising:

a data access layer containing data access model objects, the data access model objects including table objects that describe definitions of the tables contained in the data sources, and column objects that describe definitions of the columns of the tables contained in the data sources;

a business layer containing entities hat are constructed based on the table objects in the data access layer, and attributes that are constructed based on the column objects in the data access layer, and one or more business model objects that represent structure of the business to be used in business intelligence environments; and

a package layer containing one or more package model objects that define subsets of the business model objects.

17. The metadata model as claimed in claim 16, wherein the data access model objects further include one or more data access joins that describe relationship between multiple table objects.

18. The metadata model as claimed in claim 16, wherein the data access model objects further include one or more data access keys, each data access key being a collection of columns whose composite value is distinct for all rows in a table in the data sources.

19. The metadata model as claimed in claim 18, wherein the business model objects further include one or more business keys that are constructed based on the data access keys.

20. The metadata model as claimed in claim 16, wherein the business model objects further include one or more business joins that describe relationship between multiple entities.

21. The metadata model as claimed in claim 20, wherein the business joins include one or more a containment joins, each representing a strong relationship between entities.

22. The metadata model as claimed in claim 20, wherein the business joins include one or more reference joins, each representing a relationship between entities, one of which entities functions as a look-up table.

23. The metadata model as claimed in claim 16, wherein the business model objects that represent structure of the business further include one or more subtype relationships that define an inheritance relationship between two business entities.

24. The metadata model as claimed in claim 16, wherein the data sources further include one or more views, and

the data access layer contains table objects that are created based on definitions of the views and a list of columns that is obtained from the views included in the data sources.

25. The metadata model as claimed in claim 16, wherein the data sources further include one or more stored procedures, and

the data access layer contains a list of columns that is obtained from the stored procedures included in the data sources.

26. The metadata model as claimed in claim 16, wherein the business model objects that represent the structure of the business describe business rules.

27. The metadata model as claimed in claim 26, wherein the business model objects that describe business rules include one or more calculations that use a combination of attributes.

28. The metadata model as claimed in claim 26, wherein the business model objects that describe business rules include one or more filters that limit a scope of data retrieval through one or more selected entities and/or attributes.

29. The metadata model as claimed in claim 27, wherein the business model objects that describe business rules include one or more prompts.

30. The metadata model as claimed in claim 16, wherein the business model objects further include one or more business model objects describing display rules.

31. The metadata model as claimed in claim 30, wherein one of the business model objects that describe display rules is a display style.