Enterprise information unification

• US 7,673,282 B2
• Filed: 11/22/2002
• Issued: 03/02/2010
• Est. Priority Date: 05/25/2001
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Fox, Joshua, Amaru, Ruth M., Cavenor, David, Hazan-Fuchs, Ahuva, Halberstadt, Benjamin, Meir, Rannen, Schreiber, Zvi, Marchant, Hayden, Melamed, Boris, Hellman, Ziv, Edelstein, Joseph, Yitzhaki, Guy
• Primary Examiner(s): CHAVIS, JOHN Q
• Application Number:
  US10/302,370
• Publication Number:
  US 20030177481A1
• Time in Patent Office: 2,657 Days
• Field of Search: 717/104
• US Class Current: 717/104
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/84 Mapping; Conversion

Abstract

An enterprise information unification system including an information modeler for modeling business entities and their properties as an information model, the information model being comprised of business constructs, a data rationalizer for generating mappings from physical data assets to the information model, the physical data assets being comprised of data asset constructs, and a data thesaurus for automating tasks of data management based on the mappings. A method is also described and claimed.

Claims

1. An enterprise information unification system comprising:

a memory for storing a plurality of components; and

a processor for executing the plurality of components, the plurality of components comprising;

an information modeler for modeling business entities and their properties as an information model, the information model comprising business constructs, wherein the business constructs include business rules identifying relationships among class properties, wherein the information modeler generates the information model using a plurality of physical data assets as inputs, and wherein the information modeler further comprises;

a model simulator for simulating the information model, wherein a test instance generator populates data that simulates actual enterprise data; and

a model validator for validating a simulation of the information model;

a data rationalizer for generating mappings from the plurality of physical data assets to the information model, the plurality of physical data assets comprising data asset constructs, wherein the data rationalizer describes to which business constructs the data asset constructs relate, and wherein the data rationalizer further comprises;

a synchronizer for synchronizing updates to at least one physical data asset of the plurality of physical data assets with the information model; and

a data thesaurus for automating tasks of data management based on the mappings, wherein the data thesaurus translates business instructions for the information model into corresponding data processing instructions for the plurality of physical data assets, and wherein the data thesaurus translates the business instructions based on the mappings.

2. The enterprise information unification system of claim 1 wherein the information model is an ontology model and wherein the business constructs include ontology classes and properties of ontology classes.

3. The enterprise information unification system of claim 2 wherein the business constructs include ontology class inheritance relationships.

4. The enterprise information unification system of claim 1 wherein the business rules include user defined functions.

5. The enterprise information unification system of claim 1 wherein the business rules include look-up tables for relating values of a plurality of class properties.

6. The enterprise information unification system of claim 1 wherein the information modeler generates descriptors for the business constructs, wherein the descriptors are metadata used to catalog the data asset constructs.

7. The enterprise information unification system of claim 1 wherein the plurality of physical data assets include at least one relational database schema.

8. The enterprise information unification system of claim 1 wherein the plurality of physical data assets include at least one XML schema.

9. The enterprise information unification system of claim 1 further comprising a model navigator for interactively viewing the information model.

10. The enterprise information unification system of claim 1 further comprising a test instance exporter for exporting instances of business constructs into at least one XML document that is valid with respect to an XML schema for the information model.

11. The enterprise information unification system of claim 1 wherein the model validator comprises a test instance validator for validating instances of the business constructs against requirements of the information model.

12. The enterprise information unification system of claim 11 wherein the requirements of the information model include data type requirements.

13. The enterprise information unification system of claim 11 wherein the requirements of the information model include relationships among the business constructs.

14. The enterprise information unification system of claim 1 wherein the data rationalizer comprises a programming interface for generating the mappings from the plurality of physical data assets into the information model.

15. The enterprise information unification system of claim 1 wherein the data rationalizer generates the mappings based on a corresponding schema of each specific physical data asset in the plurality of physical data assets.

16. The enterprise information unification system of claim 1 wherein the data rationalizer generates mappings from the data asset constructs to corresponding business constructs.

17. The enterprise information unification system of claim 16 wherein the data rationalizer comprises a reverse modeler for automatically inferring at least a portion of the information model corresponding to the at least one physical data asset of the plurality of physical data assets, and for automatically generating mappings from the data asset constructs to corresponding business constructs.

18. The enterprise information unification system of claim 17 wherein the synchronizer describes to a user the updates to the at least one physical data asset of the plurality of physical data assets.

19. The enterprise information unification system of claim 18 wherein the synchronizer comprises an impact analyzer for determining the impact of the updates to the at least one physical data asset of the plurality of physical data assets on the mapping of the at least one physical data asset of the plurality of physical data assets into the information model.

20. The enterprise information unification system of claim 19 wherein the reverse modeler automatically updates the information model corresponding to the updates to the at least one physical data asset of the plurality of physical data assets.

21. The enterprise information unification system of claim 1 wherein said information modeler comprises a model importer for importing a logical data model.

22. The enterprise information unification system of claim 21 wherein the logical data model is an ontology model.

24. The enterprise information unification system of claim 1 wherein said information modeler comprises a model editor for editing the information model.

25. The enterprise information unification system of claim 24 further comprising an impact analyzer for determining an impact of a candidate modification to the information model on the business constructs and the mappings.

26. The enterprise information unification system of claim 24 wherein the impact analyzer determines an impact of a candidate modification to the plurality of physical data assets on the mappings.

27. The enterprise information unification system of claim 25 wherein said information modeler designates business constructs as being in an undefined state when said impact analyzer determines that such constructs are no longer well-defined, in response to a user performing the candidate modification to the information model.

28. The enterprise information unification system of claim 27 wherein said model editor further modifies the information model so as to repair at least one business construct designated as being in the undefined state, in response to which said information modeler no longer designates the at least one business construct as being in the undefined state.

29. The enterprise information unification system of claim 1 further comprising a publisher for exporting the information model to a presentation.

30. The enterprise information unification system of claim 29 wherein said publisher also exports the plurality of physical data assets to the presentation.

31. The enterprise information unification system of claim 30 wherein said publisher also exports the mappings from the plurality of physical data assets to the information model.

32. The enterprise information unification system of claim 31 wherein the presentation is a web presentation including linked HTML pages.

33. The enterprise information unification system of claim 32 wherein the linked HTML pages include informational pages corresponding to business constructs and information pages corresponding to data asset constructs, and wherein the linked HTML pages are linked in accordance with the mappings between the plurality of physical data assets and the information model.

34. The enterprise information unification system of claim 29 wherein the presentation is formatted in XML documents.

35. The enterprise information unification system of claim 1 further comprising an exporter for exporting the information model according to an industry standard format.

36. The enterprise information unification system of claim 35 wherein the exporter exports the information model in DAML+OIL format.

37. The enterprise information unification system of claim 35 wherein the exporter exports the information model in Resource Description Framework (RDF) format.

38. The enterprise information unification system of claim 1 wherein said information modeler comprises a query builder for generating queries on the information model.

39. The enterprise information unification system of claim 38 wherein said data thesaurus comprises a query generator for translating queries on the information model into corresponding queries on at least one of the plurality of physical data assets.

40. The enterprise information unification system of claim 1 wherein said data thesaurus comprises a transformation generator for generating transformation scripts to convert data from at least one of the plurality of physical data assets to at least one other of the plurality of physical data assets.

41. The enterprise information unification system of claim 1 wherein said data thesaurus comprises a data locator for identifying and locating data asset constructs that correspond to prescribed business constructs.

42. The enterprise information unification system of claim 41 wherein said data locator also identifies formats of the data asset constructs that correspond to the prescribed business constructs.

43. The enterprise information unification system of claim 41 further comprising a data access controller for associating at least one data access privilege with the data asset constructs that correspond to the prescribed business constructs, based on a data access policy associated with the information model.

44. The enterprise information unification system of claim 1 further comprising a transmitter for transmitting data processing instructions for the plurality of physical data assets to a query engine capable of querying across at least one physical data asset.

45. The enterprise information unification system of claim 1 further comprising a transmitter for transmitting data processing instructions for the plurality of physical data assets to an enterprise application integration system.

46. The enterprise information unification system of claim 45 wherein said transmitter transmits the data processing instructions just in time, as the enterprise application integration system encounters messages that require translation.

47. The enterprise information unification system of claim 45 further comprising an interface to the enterprise integration system that is a web service.

48. The enterprise information unification system of claim 45 wherein said transmitter transmits the data processing instructions for the plurality of physical data assets to a message broker for the enterprise application integration system.

49. The enterprise information unification system of claim 1 further comprising a transmitter for transmitting data processing instructions for the plurality of physical data assets to an extraction transformation and loading (ETL) system for a data warehousing system.

50. The enterprise information unification system of claim 1 further comprising a transmitter for transmitting data processing instructions for the plurality of physical data assets to a data cleansing system.

51. The enterprise information unification system of claim 1 further comprising a transmitter for transmitting data processing instructions for the plurality of physical data assets to a data mining system.

23. The enterprise information unification system of 21 wherein the logical data model is an entity-relationship diagram.

52. A method, implemented in a data processing system, for enterprise information unification, the method comprising:

a plurality of software instructions stored in a memory, the plurality of software instructions adapted to cause a processor of a computer to perform the steps of;

modeling business entities and their properties as an information model comprising business constructs, wherein the business constructs include business rules identifying relationships among class properties, wherein the information model is generated using a plurality of physical data assets as inputs, further comprising;

simulating the information model;

populating data that simulates actual enterprise data; and

validating a simulation of the information model;

generating mappings from the plurality of physical data assets to the information model, the plurality of physical data assets comprising data asset constructs, further comprising;

describing to which business constructs the data asset constructs relate; and

synchronizing updates to at least one physical data asset of the plurality of physical data assets with the information model; and

automating tasks of data management based on the mappings, further comprising;

translating business instructions for the information model into corresponding data processing instructions for the plurality of physical data assets, based on the mappings.

53. The method of claim 52 wherein the information model is an ontology model and wherein the business constructs include ontology classes and properties of ontology classes.

54. The method of claim 53 wherein the business constructs include ontology class inheritance relationships.

55. The method of claim 52 wherein the business rules include user defined functions.

56. The method of claim 52 wherein the business rules include lookup tables for relating a plurality of class properties.

57. The method of claim 52 wherein the step of modeling business entities and their properties comprises generating descriptors for the business constructs, wherein the descriptors are metadata used to catalog the data asset constructs.

58. The method of claim 52 wherein the plurality of physical data assets include at least one relational database.

59. The method of claim 52 wherein the plurality of physical data assets include at least one XML document.

60. The method of claim 52 further comprising interactively viewing the information model.

61. The method of claim 52 wherein said modeling business entities and their properties comprises exporting instances of business constructs into at least one XML document that is valid with respect to an XML schema for the information model.

62. The method of claim 52 wherein the validating step comprises validating instances of business constructs against requirements of the information model.

63. The method of claim 62 wherein the requirements of the information model include data type requirements.

64. The method of claim 62 wherein the requirements of the information model include relationships among business constructs.

65. The method of claim 52 wherein the step of generating mappings is performed using a programming interface.

66. The method of claim 52 wherein the step of generating mappings is based on a corresponding schema of each specific physical data asset in the plurality of physical data assets.

67. The method of claim 52 wherein the step of generating mappings generates mappings from the data asset constructs to corresponding business constructs.

68. The method of claim 67 wherein the step of generating mappings further comprises:

automatically inferring at least a portion of the information model corresponding to the at least one physical data asset of the plurality of physical data assets; and

automatically generating mappings from the data asset constructs to corresponding business constructs.

69. The method of claim 68 wherein the step of synchronizing updates comprises describing to a user the updates to the at least one physical data asset of the plurality of physical data assets.

70. The method of claim 69 wherein the step of synchronizing updates comprises determining an impact of the updates to the at least one physical data asset of the plurality of physical data assets on the mapping of the at least one physical data asset of the plurality of physical data assets into the information model.

71. The method of claim 70 wherein the step of automatically inferring at least a portion of the information model comprises automatically updating the information model corresponding to the updates to the at least one physical data asset of the plurality of physical data assets.

72. The method of claim 52 wherein said modeling business entities and their properties comprises importing a logical data model.

73. The method of claim 72 wherein the logical data model is an ontology model.

75. The method of claim 52 wherein said modeling business entities and their properties comprises editing the information model.

76. The method of claim 75 further comprising determining an impact of a candidate modification to the information model on the business constructs and the mappings.

77. The method of claim 75 further comprising determining an impact of a candidate modification to the plurality of physical data assets on the mappings.

78. The method of claim 76 wherein, in response to a user performing the candidate modification to the information model, said modeling business entities and their properties further comprises designating business constructs as being in an undefined state when such constructs are no longer well-defined.

79. The method of claim 78 wherein said editing the information model comprises further modifying the information model so as to repair at least one business construct designated as being in the undefined state, in response to which the at least one business construct is no longer designated as being in the undefined state.

80. The method of claim 52 further comprising exporting the information model to a presentation.

81. The method of claim 80 further comprising exporting the plurality of physical data assets to the presentation.

82. The method of claim 81 further comprising exporting the mappings from the plurality of physical data assets to the information model.

83. The method of claim 82 wherein the presentation is a web presentation including linked HTML pages.

84. The method of claim 83 wherein the linked HTML pages include informational pages corresponding to business constructs and information pages corresponding to data asset constructs, and wherein the linked HTML pages are linked in accordance with the mappings between the plurality of physical data assets and the information model.

85. The method of claim 80 wherein the presentation is formatted in XML documents.

86. The method of claim 52 further comprising exporting the information model according to an industry standard format.

87. The method of claim 86 further comprising exporting the information model in DAML+OIL format.

88. The method of claim 86 further comprising exporting the information model in Resource Description Framework (RDF) format.

89. The method of claim 52 wherein said modeling business entities and their properties comprises generating queries on the information model.

90. The method of claim 89 wherein said automating tasks comprises translating queries on the information model into corresponding queries on at least one of the plurality of physical data assets.

91. The method of claim 52 wherein said automating tasks comprises generating transformation scripts to convert data from at least one of the plurality of physical data assets to at least one other of the plurality of physical data assets.

92. The method of claim 52 wherein said automating tasks comprises:

identifying data asset constructs that correspond to prescribed business constructs; and

locating the data asset constructs that correspond to the prescribed business constructs.

93. The method of claim 92 wherein said identifying data asset constructs comprises identifying formats of the data asset constructs that correspond to the prescribed business constructs.

94. The method of claim 92 further comprising associating at least one data access privilege with the data asset constructs that correspond to the prescribed business constructs, based on a data access policy associated with the information model.

95. The method of claim 52 further comprising transmitting the data processing instructions for the plurality of physical data assets to a query engine capable of querying across at least one physical data asset.

96. The method of claim 52 further comprising transmitting the data processing instructions for the plurality of physical data assets to an enterprise application integration system.

97. The method of claim 96 wherein said transmitting is performed just in time, as the enterprise application integration system encounters messages that require translation.

98. The method of claim 96 wherein said transmitting comprises transmitting the data processing instructions for the plurality of physical data assets to a message broker for the enterprise application integration system.

99. The method of claim 52 further comprising transmitting the data processing instructions for the plurality of physical data assets to an extraction transformation and loading (ETL) system for a data warehousing system.

100. The method of claim 52 further comprising transmitting the data processing instructions for the plurality of physical data assets to a data cleansing system.

101. The method of claim 52 further comprising transmitting the data processing instructions for the plurality of physical data assets to a data mining system.

74. The method of 72 wherein the logical data model is an entity relationship diagram.

102. A computer program product, in a computer readable storage medium, for enterprise information unification, the computer program product comprising:

a plurality of instructions stored in the computer readable storage medium, wherein the plurality of instructions are adapted to cause a processor of a computer to perform the steps of;

modeling business entities and their properties as an information model comprising business constructs, wherein the business constructs include business rules identifying relationships among class properties, wherein the information model is generated using a plurality of physical data assets as inputs, further comprising;

simulating the information model;

populating data that simulates actual enterprise data; and

validating a simulation of the information model;

generating mappings from the plurality of physical data assets to the information model, the plurality of physical data assets comprising data asset constructs, further comprising;

describing to which business constructs the data asset constructs relate; and

synchronizing updates to at least one physical data asset of the plurality of physical data assets with the information model; and

automating tasks of data management based on the mappings, further comprising;

translating business instructions for the information model into corresponding data processing instructions for the plurality of physical data assets, based on the mappings.