Supporting Ontology-Based Semantic matching in RDBMS

Ontologies are increasingly being used to build applications that utilize domain-specific knowledge. This paper addresses the problem of supporting ontology-based semantic matching in RDBMS. Specifically, 1) A set of SQL operators, namely ONT_RELATED, ONT_EXPAND, ONT_DISTANCE, and ONT_PATH, are introduced to perform ontology-based semantic matching, 2) A new indexing scheme ONT_INDEXTYPE is introduced to speed up ontology-based semantic matching operations, and 3) System-defined tables are provided for storing ontologies specified in OWL. Our approach enables users to reference ontology data directly from SQL using the semantic match operators, thereby opening up possibilities of combining with other operations such as joins as well as making the ontology-driven applications easy to develop and efficient. In contrast, other approaches use RDBMS only for storage of ontologies and querying of ontology data is typically done via APIs. This paper presents the ontology-related functionality including inferencing, discusses how it is implemented on top of Oracle RDBMS, and illustrates the usage with several database applications.

[1]  Mike Uschold,et al.  A Framework for Understanding and Classifying Ontology Applications , 1999 .

[2]  Bob J. Wielinga,et al.  Using explicit ontologies in KBS development , 1997, Int. J. Hum. Comput. Stud..

[3]  Sherry Marcus,et al.  Graph-based technologies for intelligence analysis , 2004, CACM.

[4]  Ying Hu,et al.  Supporting ancillary values from user defined functions in Oracle , 2003, Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405).

[5]  James A. Hendler,et al.  The Semantic Web" in Scientific American , 2001 .

[6]  Yuval Shahar,et al.  A Component-Based Architecture for Automation of Protocol-Directed Therapy , 1995, AIME.

[7]  Carlos Alberto Heuser,et al.  Integrating Biological Databases , 2003, SBBD.

[8]  Samuel DeFazio,et al.  Extensible indexing: a framework for integrating domain-specific indexing schemes into Oracle8i , 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073).

[9]  Frederico T. Fonseca,et al.  Ontology-driven geographic information systems , 1999, GIS '99.

[10]  Boris Motik,et al.  A Conceptual Modeling Approach for Semantics-Driven Enterprise Applications , 2002, OTM.

[11]  Wei Wu,et al.  Industrial Strength Ontology Management , 2001, The Emerging Semantic Web.

[12]  Jayanta Banerjee,et al.  Oracle8i Index-Organized Table and Its Application to New Domains , 2000, VLDB.

[13]  L. Stein,et al.  OWL Web Ontology Language - Reference , 2004 .

[14]  Craig A. Knoblock,et al.  Building Agents for Internet-based Supply Chain Integration , 1999 .

[15]  Takahiro Kawamura,et al.  Semantic Matching of Web Services Capabilities , 2002, SEMWEB.

[16]  Enrico Motta,et al.  myPlanet: an ontology-driven Web-based personalized news service , 2001, OIS@IJCAI.