Enterprise information integration platform

• US 20060167856A1
• Filed: 04/15/2005
• Published: 07/27/2006
• Est. Priority Date: 01/25/2005
• Status: Active Grant

• Current Assignee: SemEO Services GmbH, Software AG
• Original Assignee: Ontoprise GmbH, Software AG
• Inventors: Brauel, Bjorn, Schoning, Harald, Harbarth, Jurgen, Winkler, Kay, Angele, Jurgen, Waterfeld, Walter
• Granted Patent: US 7,293,010 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A system for enterprise information integration is described. The system is based on different layers: the data sources, source ontologies corresponding to the data schema of the data sources, an integration ontology integrating the different source ontologies, a level of query input, preferably in the form of a web service. Between the levels, mapping rules are used. These mapping rules and the entire system are based on predicate logic. The queries are answered with the help of the rules using inference based on predicate logic.

Claims

1. A system for unified querying of distributed data sources conforming to different data schema comprising:

a) a plurality of data sources conforming each to a given data schema,

a1) each data schema having constructs for organizing the data and

a2) each data schema having a data schema query language associated therewith;

b) a plurality of source ontologies (100, 102, 104, 106), each corresponding to one data source,

b1) whereby each source ontology comprises a group of constructs,

c) a mapping between each data source and its corresponding source ontology,

c1) wherein constructs of the data schema of the data source are mapped to constructs of the source ontology, and

c2) wherein the mapping comprises means for querying the data source with the data schema query language of the data source, and

c3) wherein the mapping between each data source and its corresponding source ontology is accomplished using a declarative system of rules based on predicate logic;

d) an integration ontology (108),

d1) whereby the integration ontology comprises a group of constructs,

e) a mapping between each source ontology and the integration ontology,

e1) wherein constructs of the source ontologies are mapped to constructs of the integration ontology, and

e2) wherein the mapping between the source ontologies and the integration ontology is accomplished using a declarative system of rules based on predicate logic;

f) query means for inputting a query related to the data of the data sources; and

g) at least one inference unit (110) based on predicate logic for evaluating the query with the help of the rules.

2. System according to claim 1 comprising

means for automatically generating a source ontology (100, 102, 104, 106) corresponding to a data source and its data schema.

3. System according to claim 1 comprising

means for automatically generating the mapping between a source ontology and its corresponding data source.

4. System according to claim 1 comprising

means for enabling the inference unit (110) to dynamically access the rules and the structure of the ontologies during the evaluation of a query.

5. System according to claim 1

whereby the integration ontology has an ontology query language associated therewith;

and

the system comprising means for translating the query into the ontology query language of the integration ontology.

6. System according to claim 1 characterized by

at least one of the ontologies being complemented by a declarative system of rules based on predicate logic for expressing additional information.

7. System according to claim 1 characterized by

the query means comprising at least one query unit in the form of a web service for inputting a query related to the data of the data sources.

8. System according to claim 1 comprising

means for identifying queries or rules or combinations of rules that can be combined into a complex query in the data schema query language of the data source, and

means for translating these queries or rules or combinations of rules into a complex query in the data schema query language of the data source.

9. System according to claim 1 comprising

means for dynamically filtering those data or rules or queries which cannot have an impact on answering the query posed on the web service level.

10. System according to claim 1 comprising

a plurality of integration ontologies, integrating different data sources or integrating identical data sources and representing each a different view on the data.

11. A method for unified querying of distributed data sources conforming to different data schema comprising the steps:

a) choosing a plurality of data sources conforming each to a given data schema,

a1) each data schema having constructs for organizing the data and

a2) each data schema having a data schema query language associated therewith;

b) creating a plurality of source ontologies (100, 102, 104, 106), each corresponding to one data source,

b1) whereby each source ontology comprises a group of constructs,

c) defining a mapping between each data source and its corresponding source ontology,

c1) wherein constructs of the data schema of the data source are mapped to constructs of the source ontology, and

c2) wherein the mapping comprises means for querying the data source with the data schema query language of the data source, and

c3) wherein the mapping between each data source and its corresponding source ontology is accomplished using a declarative system of rules based on predicate logic;

d) defining an integration ontology (108),

d1) whereby the integration ontology comprises a group of constructs,

e) defining a mapping between each source ontology and the integration ontology,

e1) wherein constructs of the source ontologies are mapped to constructs of the integration ontology, and

e2) wherein the mapping between the source ontologies and the integration ontology is accomplished using a declarative system of rules based on predicate logic;

f) inputting a query related to the data of the data sources; and

g) evaluating the query with the help of the rules using at least one inference unit (110) based on predicate logic.

12. A computer loadable data structure, that is adapted to perform the method according to claim 11 while the data structure is being executed on a computer.

13. Computer program, wherein the computer program is adapted to perform the method according to claim 11 while the computer program is being executed on a computer.

14. Computer program comprising program means for performing the method according to claim 11 while the computer program is being executed on a computer or on a computer network.

15. Computer program comprising program means according to claim 11, wherein the program means are stored on a storage medium readable to a computer.

16. A storage medium, wherein a data structure is stored on the storage medium and wherein the data structure is adapted to perform the method according to claim 11 after having been loaded into a main and/or working memory of a computer or of a computer network.

17. Computer program product having program code means, wherein the program code means can be stored or are stored on a storage medium, for performing the method of claim 11, if the program code means are executed on a computer or on a computer network.

18. At least one of an operating system, a computer readable medium having stored thereon a plurality of computer-executable instructions, a co-processing device, a computing device and a modulated data signal carrying computer executable instructions for performing the method of claim 11.