Review: survey of directly mapping sql databases to the semantic web

  • Authors:

  • Juan f. Sequeda;Syed hamid Tirmizi;Oscar Corcho;Daniel p. Miranker

  • Affiliations:

  • Department of computer sciences, the university of texas at austin, austin, tx, usa/ e-mail: jsequeda@cs.utexas.edu, hamid@cs.utexas.edu, miranker@cs.utexas.edu;Department of computer sciences, the university of texas at austin, austin, tx, usa/ e-mail: jsequeda@cs.utexas.edu, hamid@cs.utexas.edu, miranker@cs.utexas.edu;Ontology engineering group, universidad politecnica de madrid, madrid, spain/ e-mail: ocorcho@fi.upm.es;Department of computer sciences, the university of texas at austin, austin, tx, usa/ e-mail: jsequeda@cs.utexas.edu, hamid@cs.utexas.edu, miranker@cs.utexas.edu

  • Venue:
  • The Knowledge Engineering Review
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

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.