Survey of directly mapping SQL databases to the Semantic Web

Juan F. Sequeda; Syed Hamid Tirmizi; Oscar Corcho; Daniel P. Miranker; Juan F. Sequeda; Syed Hamid Tirmizi; Oscar Corcho; Daniel P. Miranker

doi:10.1017/S0269888911000208

2011 Volume 26

Article Contents

Next Previous

RESEARCH ARTICLE Open Access

Survey of directly mapping SQL databases to the Semantic Web

1.
Department of Computer Sciences
2.
Ontology Engineering Group

More Information

Corresponding authors: Juan F. Sequeda ; Syed Hamid Tirmizi ; Oscar Corcho ; Daniel P. Miranker

Published online: 01 December 2011
The Knowledge Engineering Review 26, Article number: 10.1017/S0269888911000208 (2011) | Cite this article

Abstract

Abstract: The Semantic Web anticipates integrated access to a large number of information sources on the Internet represented as Resource Description Framework (RDF). Given the large number of websites that are backed by SQL databases, methods that automate the translation of those databases to RDF are crucial. One approach, taken by a number of researchers, is to directly map the SQL schema to an equivalent Web Ontology Language (OWL) or RDF Schema representation, which in turn, implies an RDF representation for the relational data. This paper reviews this research, and derives a consolidated, overarching set of translation rules expressible as a stratified Datalog program. We present all the possible key combinations in an SQL schema and consider their implied semantic properties. We review the approaches and characterize them with respect to the scope of their coverage of SQL constructs.
Rights and permissions
Copyright © Cambridge University Press 20112011Cambridge University Press

References

Google Scholar

About this article

Cite this article

Juan F. Sequeda, Syed Hamid Tirmizi, Oscar Corcho, Daniel P. Miranker. 2011. Survey of directly mapping SQL databases to the Semantic Web. The Knowledge Engineering Review. 26:8 doi: 10.1017/S0269888911000208

Juan F. Sequeda, Syed Hamid Tirmizi, Oscar Corcho, Daniel P. Miranker. 2011. Survey of directly mapping SQL databases to the Semantic Web. The Knowledge Engineering Review. 26:8 doi: 10.1017/S0269888911000208

Download PDF

Article Metrics

Article views(15) PDF downloads(100)

Survey of directly mapping SQL databases to the Semantic Web

1.
Department of Computer Sciences
2.
Ontology Engineering Group

Corresponding authors: Juan F. Sequeda ; Syed Hamid Tirmizi ; Oscar Corcho ; Daniel P. Miranker

Published online: 01 December 2011

The Knowledge Engineering Review 26, Article number: 10.1017/S0269888911000208 (2011) | Cite this article

Abstract: Abstract: The Semantic Web anticipates integrated access to a large number of information sources on the Internet represented as Resource Description Framework (RDF). Given the large number of websites that are backed by SQL databases, methods that automate the translation of those databases to RDF are crucial. One approach, taken by a number of researchers, is to directly map the SQL schema to an equivalent Web Ontology Language (OWL) or RDF Schema representation, which in turn, implies an RDF representation for the relational data. This paper reviews this research, and derives a consolidated, overarching set of translation rules expressible as a stratified Datalog program. We present all the possible key combinations in an SQL schema and consider their implied semantic properties. We review the approaches and characterize them with respect to the scope of their coverage of SQL constructs.

HTML

Acknowledgments

This research is funded in part by the National Science Foundation Grant IIS-0531767, DBI-0851052, National Science Foundation Graduate Research Fellowship and the Spanish fundamental R&D Project myBigData.

http://esw.w3.org/SweoIG/TaskForces/CommunityProjects/LinkingOpenData

http://www.w3.org/2001/sw/sweo/

http://www.w3.org/2009/08/rdb2rdf-charter.html

Rights and permissions

References (57)

About this article

Cite this article

DownLoad: Full-Size Img PowerPoint

Return

{{lists.name}}

Survey of directly mapping SQL databases to the Semantic Web

Abstract