Tutorial—Oracle Database 11g Release 2 Semantic Technologies

Semantic Indexing for DocumentsOctober 2009

This tutorial shows how to use the Semantic Technologies features of the Oracle Spatial Option to semantically index documents stored in relational tables and search for these documents using SPARQL-based document search criteria. The OpenCalais semantic metadata extraction service from Thomson Reuters is used to extract information from the documents for indexing in Oracle Database.

An Efficient SQL-based RDF Querying Scheme—Proceedings of the 31st VLDB Conference, Trondheim, Norway, 2005—This VLDB Conference paper proposes a SQL based scheme for querying RDF data. Specifically, the RDF_MATCH table function is introduced with the ability to perform pattern-based match against RDF data (graph). The expectation is that providing RDF querying capability as part of SQL will enable a database system to support a wider range of applications and facilitate building semantically rich applications. (PDF 154KB)

Supporting Ontology-based Semantic Matching in RDMS—By Souripriya Das, Eugene Inseok Chong, George Eadon, Jagannathan Srinivasan, Proceedings of the 30th VLDB Conference, Toronto, Canada. 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. The 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. (PDF 97KB)

Applying Semantic Web Technologies to Drug Safety Determination—Identifying signals of events that lead to undesirable outcomes is historically one of the most challenging aspects of determining drug safety, both during the drug discovery and development process and once a drug is released to the market....The Semantic Web provides new capabilities for data integration that exploits explicit semantics and well-defined ontologies...The Oracle RFD Data model integrated with Cerebra Server is a composite solution that addresses the complexities of mediating information in drug safety. A use case illustrates the situation and how the composite solution might help. (PDF 166KB)