Translating SQL Applications to the Semantic Web

Abstract. The content of most Web pages is dynamically derived from an underlying relational database. Thus, the success of the Semantic Web hinges on enabling access to relational databases and their content by semantic methods. We define a system for automatic transformation of SQL DDL schemas into OWL DL ontologies. This system goes further than earlier efforts in that the entire system is expressed in first-order logic. We leverage the formal approach to show the system is complete with respect to a space of the possible relations that can be formed among relational tables as a consequence of primary and foreign key combinations. The full set of transformation rules is stratified, thus the system can be executed directly by a Datalog interpreter.

• Type: Conference
• Year: 2008
• Where: DEXA
• Authors: Syed Hamid Tirmizi, Juan Sequeda, Daniel P. Miranker
• Keywords: Database, DEXA 2008, OWL DL Ontologies, Relational Databases, SQL DDL Schemas