Data query and location through a central ontology model

• US 7,475,084 B2
• Filed: 05/20/2005
• Issued: 01/06/2009
• Est. Priority Date: 05/25/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Schreiber, Marcel Zvi, Marchant, Hayden, Edelstein, Joseph, Meir, Rannen
• Primary Examiner(s): Woo; Isaac M
• Application Number:
  US11/134,725
• Publication Number:
  US 20050216500A1
• Time in Patent Office: 1,327 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A data query method including a data schema having a data schema query language associated therewith, including an ontology model including classes and properties, the ontology model having an ontology query language associated therewith, wherein constructs of the database schema are mapped to corresponding classes, properties or compositions of properties of the ontology model, and an ontology query generating a query expressed in the data schema query language corresponding to a specified query expressed in the ontology query language.

Claims

1. A method for data query comprising:

providing a data schema having a data schema query language associated therewith;

providing an ontology model including classes and properties, the ontology model having an ontology query language associated therewith, wherein constructs of the data schema are mapped to corresponding classes, properties or compositions of properties of the ontology model;

providing a query expressed in the ontology language;

generating a query expressed in the data schema query language corresponding to the query expressed in the ontology query language;

providing an additional data schema having an additional data schema query language associated therewith, wherein constructs of the additional data schema are also mapped to corresponding classes, properties or compositions of properties of the ontology model; and

generating a query expressed in the additional data schema query language corresponding to the query expressed in the ontology query language.

2. The method of claim 1 further comprising:

providing at least one data source conforming to the data schema; and

executing the query expressed in the data schema language on the at least one data source.

3. The method of claim 1 wherein the query expressed in the ontology query language includes a clause indicating at least one subject class to which the query applies.

4. The method of claim 1 wherein the query expressed in the ontology language includes at least one property or composition of properties defined on the at least one subject class, values of which are to be displayed.

5. The method of claim 4 wherein at least one of the at least one property or composition of properties defined on the at least one subject class, are inherited from at least one property or composition of properties defined on a superclass of the subject class.

6. The method of claim 1 wherein the query expressed in the ontology language includes at least one condition that must be satisfied by at least one value of a property or composition of properties defined on the at least one subject class.

7. The method of claim 6 wherein the property or composition of properties defined on the at least one subject class, is inherited from a property or composition of properties defined on a superclass of the subject class.

8. The method of claim 1 further comprising generating a query expressed in the ontology language.

9. The method of claim 8 wherein said generating a query comprises specifying at least one subject class to which a query applies.

10. The method of claim 9 wherein said generating a query comprises specifying at least one property or composition of properties defined on the at least one subject class, values of which are to be displayed.

11. The method of claim 10 wherein at least one of the at least one property or composition of properties defined on the at least one subject class, are inherited from at least one property or composition of properties defined on a superclass of the subject class.

12. The method of claim 9 wherein said generating a query comprises specifying at least one condition that must be satisfied by at least one value of a property or composition of properties defined on the at least one subject class.

13. The method of claim 12 wherein the property or composition of properties defined on the at least one subject class, is inherited from a property or composition of properties defined on a superclass of the subject class.

14. The method of claim 1 wherein the data schema is a relational database schema, the constructs of which are tables and fields, and wherein the data schema query language is SQL.

15. The method of claim 1 wherein the data schema is an XML schema, the constructs of which are complex types, elements and attributes, and wherein the data schema query language is XQuery.

16. The method of claim 1 wherein the data schema is a COBOL Copy Book, the constructs of which are group items and elementary items.

17. The method of claim 1 wherein the data schema is an entity-relationship model.

18. The method of claim 1 further comprising generating a visual display of the query expressed in the data schema query language.

19. The method of claim 18 wherein the visual display includes a display of the query expressed in the ontology query language.

20. The method of claim 1 wherein the additional data schema is the same as the data schema, and wherein the additional data schema query language is the same as the data schema query language.

21. The method of claim 1 wherein the additional data schema is different from the data schema, and wherein the additional data schema query language is different from the data schema query language.

22. The method of claim 1 wherein the data schema is a relational database schema and wherein the additional data schema is an XML schema.