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

• US 7,840,607 B2
• Filed: 08/02/2005
• Issued: 11/23/2010
• Est. Priority Date: 08/06/2004
• Status: Expired due to Fees

• Current Assignee: Siemens AG
• Original Assignee: Siemens AG
• Inventors: DeMesa, Jesse G., Henigman, Timothy James
• Primary Examiner(s): Robinson; Greta L
• Assistant Examiner(s): Wilcox; James J
• Application Number:
  US11/195,439
• Publication Number:
  US 20060031250A1
• Time in Patent Office: 1,939 Days
• Field of Search: None
• US Class Current: 707/803
• 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;

after determining the plurality of relational database tables, 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, with a device, at least one dimension table after receiving the selection of the selected object, the at least one dimension table associated with the selected object and including a primary key column and columns corresponding to the first plurality of members;

creating a fact table after receiving the selection of the selected object, the fact table including a foreign key column corresponding to each of the at least one dimension table, such that a plurality of dimension tables would result in a corresponding plurality of foreign key columns in the fact table, the fact table additionally including a column corresponding to each of the second plurality of members; and

a primary key of the at least one dimension table being placed in a record of the fact table within the foreign key column corresponding to the at least one dimension table.

2. The 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. The 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. The 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. The 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. The 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. The 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. The 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. The method according to claim 1, wherein the class model represents assets and geographies of a manufacturing organization.

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

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

12. The 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. The method according to claim 12, wherein the natural resource comprises at least one of oil and natural gas.

27. The method of claim 1, wherein creating the dimension table after receiving the selection of the selected object comprises:

creating the dimension table after receiving the first indication of the first plurality of members.

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 operating to;

after the database device determines the plurality of relational database tables, receive a selection of one object of the objects as a dimension of a logical model,

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

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

create at least one dimension table after receiving the selection of the selected object, the at least one dimension table associated with the selected object and including a primary key column and columns corresponding to the first plurality of members, and

create a fact table after receiving the selection of the selected object, the fact table including a foreign key column corresponding to each of the at least one dimension table, such that a plurality of dimension tables would result in a corresponding plurality of foreign key columns in the fact table, the fact table additionally including a column corresponding to each of the second plurality of members, a primary key of the at least one dimension table being placed in a record of the fact table within the foreign key column corresponding to the at least one dimension table.

15. The 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. The 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. The 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. The 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. The system according to claim 14, wherein the class model represents assets and geographies of a manufacturing organization.

20. The 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. The 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. The 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. The system according to claim 14, wherein the tag-based data and non-tag-based data are derived from an industrial process.

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

25. The 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. The system according to claim 25, wherein the natural resource comprises at least one of oil and natural gas.