Methods, systems and computer program products for self-generation of a data warehouse from an enterprise data model of an EAI/BPI infrastructure

• US 20040236786A1
• Filed: 05/22/2003
• Published: 11/25/2004
• Est. Priority Date: 05/22/2003
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Medicke, John A., Russell, Feng-Wei Chen
• Granted Patent: US 7,487,173 B2
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

A data warehouse is generated by incorporating data warehouse information in business objects to provide subscribed business objects and generating star-schema tables of the data warehouse from the subscribed business objects. Data from subscribed business objects may be logged when an event of the subscribed business objects is processed, for example, by an integration node, and the logged data incorporated into the star-schema tables of the data warehouse.

Claims

1. A method of generating a data warehouse, comprising:

incorporating data warehouse information as part of business objects to provide subscribed business objects; and

generating star-schema tables of the data warehouse from the subscribed business objects.

2. The method of claim 1, further comprising:

logging data from the subscribed business objects when an event of the subscribed business objects is processed; and

incorporating the logged data into the star-schema tables of the data warehouse.

3. The method of claim 1, wherein incorporating data warehouse information as part of business objects comprises incorporating log formation, primary key information, foreign key information, fact table foreign key information, and/or fact table measure information.

4. The method of claim 1, wherein generating star-schema tables comprises:

generating a dimension table from data warehouse information of a subscribed business object; and

generating a fact table from data warehouse information of a subscribed business object.

5. The method of claim 1, wherein generating star-schema tables comprises:

categorizing subscribed business objects as transactional business objects or informational business objects;

generating a dimension table from data warehouse information of a subscribed business object categorized as an informational business object; and

generating a fact table from data warehouse information of a subscribed business object categorized as a transaction business object.

6. The method of claim 4, wherein generating a dimension table and generating a fact table comprise:

generating a data definition language (DDL) description of the dimension table from the data warehouse information of a subscribed business object;

then

generating a DDL description of the fact table from the data warehouse information of a subscribed business object; and

then

executing the DDL descriptions of the dimension table and the fact table to generate the dimension table and the fact table.

7. The method of claim 4, wherein generating star-schema tables further comprises generating a predefined dimension table.

8. The method of claim 7, wherein generating star-schema tables further comprises populating a dimension branch table associated with the predefined dimension table.

9. The method of claim 2, wherein logging data from subscribed business objects comprises:

determining if an integration node event associated with a subscribed business object has occurred; and

extracting data from the subscribed business object if the integration node event associated with the subscribed business object has occurred.

10. The method of claim 9, wherein logging data from subscribed business objects further comprises storing the extracted data in a staging database and/or a flat file.

11. The method of claim 10, further comprising:

defining mapping rules that map data from business objects to star-schema tables of the data warehouse; and

wherein incorporating the logged data into the star-schema tables of the data warehouse comprises;

transforming the data in the staging database and/or flat file based on the mapping rules; and

loading the transformed data into the star-schema tables of the data warehouse.

12. A system for generating a data warehouse, comprising:

a business object designer configured to incorporate data warehouse information in business objects so as to provide subscribed business objects; and

a star-schema manager configured to generate star-schema tables of the data warehouse based on the incorporated data warehouse information of the subscribed business objects.

13. The system of claim 12, further comprising:

an audit log engine configured to extract information from subscribed business objects and store the extracted information in an audit log; and

a transformer/loader configured to load the information stored in the audit log into the data warehouse by populating the star-schema tables of the data warehouse with the information stored in the audit log.

14. The system of claim 12, wherein the data warehouse information incorporated in the business objects comprises log formation, primary key information, foreign key information, fact table foreign key information, and/or fact table measure information.

15. The system of claim 12, wherein the star-schema manager is further configured to generate a dimension table from data warehouse information of a subscribed business object and to generate a fact table from data warehouse information of a subscribed business object.

16. The system of claim 12, wherein subscribed business objects are categorized as transactional business objects or informational business objects;

and

wherein the star-schema manager is further configured generate a dimension table from data warehouse information of a subscribed business object categorized as an informational business object and to generate a fact table from data warehouse information of a subscribed business object categorized as a transactional business object.

17. The system of claim 15, wherein the star-schema manager is further configured to generate a data definition language (DDL) description of the dimension table from the data warehouse information of a subscribed business object, then generate a DDL description of the fact table from the data warehouse information of a subscribed business object and then execute the DDL descriptions to generate the dimension table and the fact table.

18. The system of claim 15, wherein the star-schema manager is further configured to generate a predefined dimension table.

19. The system of claim 18, wherein the star-schema manager is further configured to populate a dimension branch table associated with the predefined dimension table.

20. The system of claim 13, wherein the audit log engine is further configured to determine if an integration node event associated with a subscribed business object has occurred and to extract data from the subscribed business object if the integration node event associated with the subscribed business object has occurred.

21. The system of claim 20, wherein the audit log engine is further configured to store the extracted data in a staging database and/or a flat file.

22. The system of claim 21, wherein mapping rules map data from business objects to star-schema tables of the data warehouse;

and

wherein the transformer/loader is further configured to transform the data in the staging database and/or the flat file based on the mapping rules and to load the transformed data into the star-schema tables of the data warehouse.

23. A system for generating a data warehouse, comprising:

means for incorporating data warehouse information as part of business objects to provide subscribed business objects; and

means for generating star-schema tables of the data warehouse from the subscribed business objects.

24. The system of claim 23, further comprising:

means for logging data from the subscribed business objects when an event of the subscribed business objects is processed; and

means for incorporating the logged data into the star-schema tables of the data warehouse.

25. A computer program product for generating a data warehouse, comprising:

a computer readable medium having computer readable program code embodied therein, the computer readable program code comprising;

computer readable program code configured to incorporate data warehouse information as part of business objects to provide subscribed business objects; and

computer readable program code configured to generate star-schema tables of the data warehouse from the subscribed business objects.

26. The computer program product of claim 25, further comprising:

computer readable program code configured to log data from subscribed business objects when an event of the subscribed business objects is processed; and

computer readable program code configured to incorporate the logged data into the star-schema tables of the data warehouse.