Translating SQL Applications to the Semantic Web

Authors:
Syed Hamid Tirmizi;Juan Sequeda;Daniel Miranker
Affiliations:
Department of Computer Sciences, The University of Texas at Austin, USA;Department of Computer Sciences, The University of Texas at Austin, USA;Department of Computer Sciences, The University of Texas at Austin, USA
Venue:
DEXA '08 Proceedings of the 19th international conference on Database and Expert Systems Applications
Year:
2008

Citing 11
Cited 8

Micro: a normalization tool for relational database designers

Journal of Network and Computer Applications
Migrating data-intensive web sites into the Semantic Web

Proceedings of the 2002 ACM symposium on Applied computing
Schema Mapping as Query Discovery

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Relational.OWL: a data and schema representation format based on OWL

APCCM '05 Proceedings of the 2nd Asia-Pacific conference on Conceptual modelling - Volume 43
Upgrading relational legacy data to the semantic web

Proceedings of the 15th international conference on World Wide Web
Accessing the deep web

Communications of the ACM - ACM at sixty: a look back in time
Bridging the gap between OWL and relational databases

Proceedings of the 16th international conference on World Wide Web
SPHINX: Schema integration by example

Journal of Intelligent Information Systems
Towards a semantic web of relational databases: a practical semantic toolkit and an in-use case from traditional chinese medicine

ISWC'06 Proceedings of the 5th international conference on The Semantic Web
Inferring complex semantic mappings between relational tables and ontologies from simple correspondences

OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II
Database to semantic web mapping using RDF query languages

ER'06 Proceedings of the 25th international conference on Conceptual Modeling

LinkedGeoData: Adding a Spatial Dimension to the Web of Data

ISWC '09 Proceedings of the 8th International Semantic Web Conference
On the social dynamics of ontological commitments

OTM'10 Proceedings of the 2010 international conference on On the move to meaningful internet systems
Review: survey of directly mapping sql databases to the semantic web

The Knowledge Engineering Review
Theoretical foundations for enabling a web of knowledge

FoIKS'10 Proceedings of the 6th international conference on Foundations of Information and Knowledge Systems
On directly mapping relational databases to RDF and OWL

Proceedings of the 21st international conference on World Wide Web
Bringing relational databases into the semantic web: a survey

Semantic Web
Ultrawrap: SPARQL execution on relational data

Web Semantics: Science, Services and Agents on the World Wide Web
Bringing relational databases into the Semantic Web: A survey

Semantic Web - On real-time and ubiquitous social semantics

Quantified Score

Hi-index	0.00

Visualization

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.