Data mart generation and use in association with an operations intelligence platform

• US 20060031250A1
• Filed: 08/02/2005
• Published: 02/09/2006
• Est. Priority Date: 08/06/2004
• Status: Active Grant

• Current Assignee: Siemens AG
• Original Assignee: Siemens AG
• Inventors: DeMesa, Jesse G., Henigman, Timothy James
• Granted Patent: US 7,840,607 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G05B 2219/31323 Database for CIM
• CPC Class Codes: G05B 2219/31485 Verify and update all related data in relational database
• CPC Class Codes: G05B 2219/32404 Scada supervisory control and data acquisition
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y02P 90/02 Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/957 Multidimensional

Abstract

Some embodiments include determination and storage of a plurality of relational database tables based on class model representing tag-based data and non-tag-based data and on a plurality of objects instantiated based on the class model. Also included are reception of a selection of one object of the objects as a dimension of a logical model, reception of a first indication of a first plurality of members of the selected object to be associated with dimension data of the logical model, reception of a second indication of a second plurality of members of the selected object to be associated with fact data of the logical model, to create a dimension table associated with the selected object and including columns corresponding to the first plurality of members, and creation of a fact table including a foreign key column corresponding to the dimension table and including a column corresponding to each of the second plurality of members.

Claims

1. A method comprising:

determining a plurality of relational database tables based on a class model representing tag-based data and non-tag-based data and on a plurality of objects instantiated based on the class model;

receiving a selection of one object of the objects as a dimension of a logical model;

receiving a first indication of a first plurality of members of the selected object to be associated with dimension data of the logical model;

receiving a second indication of a second plurality of members of the selected object to be associated with fact data of the logical model;

creating a dimension table associated with the selected object and including columns corresponding to the first plurality of members; and

creating a fact table including a foreign key column corresponding to the dimension table and including a column corresponding to each of the second plurality of members.

2. A method according to claim 1, further comprising:

receiving a second selection of a second object of the objects as a second dimension of a logical model;

receiving a third indication of a first plurality of members of the second object to be associated with dimension data of the logical model;

receiving a fourth indication of a second plurality of members of the second object to be associated with fact data of the logical model; and

creating a second dimension table associated with the second object and including columns corresponding to the first plurality of members of the second object,

wherein the fact table includes a second foreign key column corresponding to the second dimension table and a column corresponding to each of the second plurality of members of the second object.

3. A method according to claim 2, further comprising:

determining a mapping between at least one members of the selected object and at least one member of the second object.

4. A method according to claim 2, further comprising:

determining a list of objects based on the selected object and the plurality of relational database tables,

wherein the second object is selected from the list.

5. A method according to claim 1, wherein the dimension table includes a primary key column, and further comprising:

creating a function to receive values of one or more columns of the dimension table and to output a value of the primary key column of the dimension table, wherein the value identifies a row of the dimension table including the received values.

6. A method according to claim 1, further comprising:

receiving a second selection of a second object of the objects as the dimension of the logical model; and

receiving a third indication of a third plurality of members of the second object to be associated with the dimension data of the logical model,

wherein the dimension table is associated with the second object and includes columns corresponding to the third plurality of members.

7. A method according to claim 1, further comprising:

determining, based on the plurality of relational database tables, a second object that is related to all other objects represented in the logical model; and

presenting the second object to the user as a primary data source for the fact data.

8. A method according to claim 1, further comprising:

determining, based on the plurality of relational database tables, a second object that is related to a greatest number of all other objects represented in the logical model; and

presenting the second object to the user as a primary data source for the fact data.

9. A method according to claim 1, wherein the class model represents assets and geographies of a manufacturing organization.

10. A method according to claim 1, wherein the tag-based data and non-tag-based data are derived from an industrial process.

11. A method according to claim 10, wherein the industrial process comprises a continuous process.

12. A method according to claim 10, wherein the industrial process comprises operations of facilities involved in at least one of manufacturing, assembly, natural resource procurement, natural resource refinement, chemical synthesis, water treatment, power generation, power transmission, food processing, beverage processing, raw materials processing, agricultural processing, and materials processing.

13. A method according to claim 12, wherein the natural resource comprises at least one of oil and natural gas.

14. A system comprising:

an operations platform to provide a class-based model representing tag-based data and non-tag-based data and a plurality of objects instantiated based on the class model;

a database device to determine and store a plurality of relational database tables based on the class model and on the plurality of objects instantiated based on the class model; and

a schema generating device to receive a selection of one object of the objects as a dimension of a logical model, to receive a first indication of a first plurality of members of the selected object to be associated with dimension data of the logical model, to receive a second indication of a second plurality of members of the selected object to be associated with fact data of the logical model, to create a dimension table associated with the selected object and including columns corresponding to the first plurality of members, and to create a fact table including a foreign key column corresponding to the dimension table and including a column corresponding to each of the second plurality of members.

15. A system according to claim 14, the schema generating device to receive a second selection of a second object of the objects as a second dimension of a logical model, to receive a third indication of a first plurality of members of the second object to be associated with dimension data of the logical model, to receive a fourth indication of a second plurality of members of the second object to be associated with fact data of the logical model, and to create a second dimension table associated with the second object and including columns corresponding to the first plurality of members of the second object,

wherein the fact table includes a second foreign key column corresponding to the second dimension table and a column corresponding to each of the second plurality of members of the second object.

16. A system according to claim 15, the schema generating device to determine a mapping between at least one members of the selected object and at least one member of the second object.

17. A system according to claim 15, the schema generating device to determine a list of objects based on the selected object and the plurality of relational database tables,

wherein the second object is selected from the list.

18. A system according to claim 14, wherein the dimension table includes a primary key column, and

wherein the schema generating device is to create a function to receive values of one or more columns of the dimension table and to output a value of the primary key column of the dimension table, wherein the value identifies a row of the dimension table including the received values.

19. A system according to claim 14, wherein the class model represents assets and geographies of a manufacturing organization.

20. A system according to claim 14, the schema generating device to receive a second selection of a second object of the objects as the dimension of the logical model, and to receive a third indication of a third plurality of members of the second object to be associated with the dimension data of the logical model,

wherein the dimension table is associated with the second object and includes columns corresponding to the third plurality of members.

21. A system according to claim 14, the schema generating device to determine, based on the plurality of relational database tables, a second object that is related to all other objects represented in the logical model, and to present the second object to the user as a primary data source for the fact data.

22. A system according to claim 14, the schema generating device to determine, based on the plurality of relational database tables, a second object that is related to a greatest number of all other objects represented in the logical model, and to present the second object to the user as a primary data source for the fact data.

23. A system according to claim 14, wherein the tag-based data and non-tag-based data are derived from an industrial process.

24. A system according to claim 23, wherein the industrial process comprises a continuous process.

25. A system according to claim 23, wherein the industrial process comprises operations of facilities involved in at least one of manufacturing, assembly, natural resource procurement, natural resource refinement, chemical synthesis, water treatment, power generation, power transmission, food processing, beverage processing, raw materials processing, agricultural processing, and materials processing.

26. A system according to claim 25, wherein the natural resource comprises at least one of oil and natural gas.