Ontology harmonization and mediation systems and methods

• US 9,189,531 B2
• Filed: 11/30/2012
• Issued: 11/17/2015
• Est. Priority Date: 11/30/2012
• Status: Active Grant

• Current Assignee: Contiem Incorporated
• Original Assignee: Orbis Technology
• Inventors: Joshi, Sameer, Whitley, Zachery
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): BUI, THUY T
• Application Number:
  US13/691,655
• Publication Number:
  US 20140156638A1
• Time in Patent Office: 1,082 Days
• Field of Search: 707/722
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 40/30 Semantic analysis

Abstract

A method and system for harmonizing and mediating ontologies to search across large data sources is disclosed. The method comprises receiving a query targeting a first ontology. The method further comprises translating the query into one or more translated queries, each translated query targeting a respective ontology different from the first ontology. For each of the queries, issuing the query to a respective database organized according to the respective ontology of the query, and receiving a respective result set for the query, wherein the respective result set corresponds to the respective ontology of the query. The method further comprises translating the respective result set into a translated result set corresponding to the first ontology, aggregating the result sets into an aggregated result set corresponding to the first ontology, and returning the aggregated results set corresponding to the first ontology.

Claims

1. A method of servicing a multi-database query, the method comprising:

receiving, by a computer, a query targeting a first ontology, wherein the first ontology comprises a user analytic ontology specified by a user;

translating, by a computer, the query into one or more translated queries, each translated query targeting a respective ontology different from the first ontology;

for each of the translated queries;

issuing the translated query, by a computer, to a respective database organized according to the respective ontology of the translated query, and

receiving, by a computer, a respective result set for the translated query, wherein the respective result set corresponds to the respective ontology of the translated query;

for each of the respective result sets;

translating, by a computer, the respective result set into a translated result set corresponding to the first ontology;

aggregating, by a computer, the translated result sets into an aggregated result set corresponding to the first ontology;

returning, by a computer, the aggregated results set corresponding to the first ontology;

maintaining, by a computer, a plurality of ontologies and ontology alignments and mappings associated with said databases through versioning and governance of metadata of said databases;

describing, by a computer, each database by a database schema;

overlaying, by a computer, one or more database ontologies to each of said database schemas;

mapping, by a computer, said database ontologies to a plurality of small domain ontologies; and

combining, by a computer, said plurality of small domain ontologies to create system ontologies.

2. The method of claim 1, further comprising:

mapping, by a computer, a target ontology to a plurality of source ontologies.

3. The method of claim 2, wherein said first ontology comprises a target ontology, and said respective ontology different from the first ontology comprises a source ontology mapped to said target ontology.

4. The method of claim 3, wherein the said translated result set corresponds to the target ontology.

5. The method of claim 1 wherein said database comprises data being stored in its native data format.

6. The method of claim 5, further comprising:

adapting, by a computer, the data stored in said databases to a standard RDF format.

7. The method of claim 6, further comprising:

configuring, by a computer, said databases with a semantic web enabled layer.

8. The method of claim 7, wherein said semantic web enabled layer comprises a SPARQL endpoint.

9. The method of claim 1, further comprising:

mediating, by a computer, a plurality of ontologies.

10. The method of claim 9, wherein said plurality of ontologies are mediated to a central ontology in a star configuration.

11. The method of claim 9 wherein said mediating a plurality of ontologies is performed using open standards comprising OWL, RDF, and EDOAL.

12. The method of claim 9, wherein said mediating a plurality of ontologies comprises:

mapping, by a computer, a plurality of ontologies using defined mappings, wherein said defined mappings comprise formal semantic language.

13. The method of claim 9 where mediating, by a computer, a plurality of ontologies comprises:

defining, using a computer, custom mappings of ontology instances from one format to another.

14. The method of claim 9 where mediating, by a computer, a plurality of ontologies comprises:

storing, by a computer, data associated with data in said database for entity correlation and disambiguation.

15. The method of claim 9 where mediating, by a computer, a plurality of ontologies comprises:

storing, by a computer, source specific statistics and metadata describing the content of said database both qualitatively and quantitatively.

16. The method of claim 1, further comprising:

storing, by a computer, data associated with data in said databases for entity correlation and disambiguation.

17. The method of claim 1, further comprising:

storing, by a computer, source specific statistics and metadata describing the data in said databases both qualitatively and quantitatively.

18. The method of claim 1, further comprising:

displaying, by a computer, results in a virtual unified view.

19. The method of claim 1, further comprising:

mediating between the plurality of databases using a plurality of rules.

20. A system comprising:

two or more databases;

one or more computer processing cores; and

one or more memories coupled to the computer processing cores and storing program instructions executable by the processing cores to implement an ontology harmonization and mediation engine configured to issue a query across said two or more databases by;

maintaining a plurality of ontologies and ontology alignments and mappings associated with said databases through versioning and governance of metadata of said databases;

describing each said database by a database schema;

overlaying one or more database ontologies to each of said database schemas;

mapping said database ontologies to a plurality of small domain ontologies;

combining said plurality of small domain ontologies to create system ontologies;

receiving a query targeting a first ontology, wherein the first ontology comprises a user analytic ontology specified by a user;

translating the query into one or more translated queries, each translated query targeting a respective ontology different from the first ontology;

for each of the translated queries;

issuing the translated query to a respective said database organized according to the respective ontology of the translated query, and

receiving a respective result set for the translated query, wherein the respective result set corresponds to the respective ontology of the translated query;

for each of the respective result sets;

translating the respective result set into a translated result set corresponding to the first ontology;

aggregating the result sets into an aggregated result set corresponding to the first ontology; and

returning the aggregated results set corresponding to the first ontology.

21. The system of claim 20 further comprising:

mapping a target ontology to a plurality of source ontologies.

22. The system of claim 21, wherein said first ontology comprises a target ontology, and said respective ontology different from the first ontology comprises a source ontology mapped to said target ontology.

23. The system of claim 20 wherein said two or more databases comprise data being stored in its native data format.

24. The system of claim 23, further comprising:

adapting the data stored in said databases to a standard RDF format.

25. The system of claim 24, further comprising:

configuring said databases with a semantic web enabled layer.

26. The system of claim 23, wherein said semantic web enabled layer comprises a SPARQL endpoint.

27. The system of claim 20, further comprising:

mediating a plurality of ontologies.

28. The system of claim 27, wherein said plurality of ontologies are mediated to a central ontology in a star configuration.

29. The system of claim 27, wherein said mediating a plurality of ontologies is performed using open standards comprising OWL, RDF, and EDOAL.

30. The system of claim 27, wherein said mediating a plurality of ontologies comprises:

mapping a plurality of ontologies using defined mappings, wherein said defined mappings comprise formal semantic language.

31. The system of claim 27, wherein the said translated result set corresponds to the target ontology.

32. The system of claim 27 where mediating a plurality of ontologies comprises:

defining custom mappings of ontology instances from one format to another.

33. The system of claim 27 where mediating a plurality of ontologies comprises:

storing, in said one or more memories, data associated with data in said database for entity correlation and disambiguation.

34. The system of claim 27 where mediating a plurality of ontologies comprises:

storing, in said one or more memories, source specific statistics and metadata describing the content of said database both qualitatively and quantitatively.

35. The system of claim 20, further comprising:

storing, in said one or more memories, data associated with data in said databases for entity correlation and disambiguation.

36. The system of claim 20, further comprising:

storing, in said one or more memories, source specific statistics and metadata describing the data in said databases both qualitatively and quantitatively.

37. The system of claim 20, further comprising:

a video display interface, wherein said video display interface is coupled to said one or more computer processing cores and is configured to;

display said query results in a virtual unified view.