Survey of directly mapping SQL databases to the Semantic Web

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.

[1]  Tim Berners-Lee,et al.  Linked Data - The Story So Far , 2009, Int. J. Semantic Web Inf. Syst..

[2]  Asunción Gómez-Pérez,et al.  Upgrading relational legacy data to the semantic web , 2006, WWW '06.

[3]  Raphael Volz,et al.  Migrating data-intensive web sites into the Semantic Web , 2002, SAC '02.

[4]  Alfred V. Aho,et al.  Compilers: Principles, Techniques, and Tools , 1986, Addison-Wesley series in computer science / World student series edition.

[5]  Stefan Conrad,et al.  Relational.OWL - A Data and Schema Representation Format Based on OWL , 2005, APCCM.

[6]  Deborah L. McGuinness,et al.  Owl web ontology language guide , 2003 .

[7]  John Mylopoulos,et al.  Inferring Complex Semantic Mappings Between Relational Tables and Ontologies from Simple Correspondences , 2005, OTM Conferences.

[8]  Rudi Studer,et al.  Proceedings of the IFIP 17th World Computer Congress - TC12 Stream on Intelligent Information Processing , 2002 .

[9]  Mitesh Patel,et al.  Accessing the deep web , 2007, CACM.

[10]  York Sure-Vetter,et al.  How to Design Better Ontology Metrics , 2007, ESWC.

[11]  Veda C. Storey,et al.  Extracting Domain Semantics for Knowledge Discovery in Relational Databases , 1994, KDD Workshop.

[12]  Hongbo Du,et al.  Micro: A normalization tool for relational database designers , 1999, J. Netw. Comput. Appl..

[13]  Philip J. Pratt,et al.  A Guide to SQL , 1990 .

[14]  Christine Collet,et al.  Resource integration using a large knowledge base in Carnot , 1991, Computer.

[15]  Daniel P. Miranker,et al.  A Bootstrapping Architecture for Integration of Relational Databases to the Semantic Web , 2008, SEMWEB.

[16]  Jeff Z. Pan,et al.  Towards Populating and Querying the Semantic Web , 2006 .

[17]  Jan L. Top,et al.  From Relational Data to RDFS Models , 2004, ICWE.

[18]  John Mylopoulos,et al.  Building Semantic Mappings from Databases to Ontologies , 2006, AAAI.

[19]  Ian Horrocks,et al.  Keys, Nominals, and Concrete Domains , 2003, IJCAI.

[20]  Daniel P. Miranker,et al.  Translating SQL Applications to the Semantic Web , 2008, DEXA.

[21]  Boris Motik,et al.  Bridging the gap between OWL and relational databases , 2007, WWW '07.

[22]  Sergio Tessaris,et al.  Automatic Extraction of Ontologies Wrapping Relational Data Sources , 2009, DEXA.

[23]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[24]  Michael Stonebraker,et al.  Triggers and inference in data base systems , 1985, ACM '85.

[25]  Man Li,et al.  Learning ontology from relational database , 2005, 2005 International Conference on Machine Learning and Cybernetics.

[26]  Irina Astrova,et al.  Reverse Engineering of Relational Databases to Ontologies , 2004, ESWS.

[27]  Stefan Conrad,et al.  Database to Semantic Web Mapping Using RDF Query Languages , 2006, ER.

[28]  Jennifer Widom,et al.  Database Systems: The Complete Book , 2001 .

[29]  Daniel P. Miranker,et al.  Databases are a Moving Target Position Paper for W 3 C Workshop on RDF Access to Relational Databases , 2007 .

[30]  Zhaohui Wu,et al.  Towards a Semantic Web of Relational Databases: A Practical Semantic Toolkit and an In-Use Case from Traditional Chinese Medicine , 2006, SEMWEB.

[31]  Raphael Volz,et al.  A Reverse Engineering Approach for Migrating Data-intensive Web Sites to the Semantic Web , 2002, Intelligent Information Processing.

[32]  Asunción Gómez-Pérez,et al.  R2O, an extensible and semantically based database-to-ontology mapping language , 2004 .

[33]  N. Korda,et al.  Rule-Based Transformation of SQL Relational Databases to OWL Ontologies , 2007 .

[34]  Jennifer Widom,et al.  Managing Semantic Heterogeneity with Production Rules and Persistent Queues , 1993, VLDB.

[35]  Shichao Zhang,et al.  Mapping between Relational Database Schema and OWL Ontology for Deep Annotation , 2006, 2006 IEEE/WIC/ACM International Conference on Web Intelligence (WI 2006 Main Conference Proceedings)(WI'06).

[36]  Michael L. Brodie.  On knowledge base management systems: integrating artificial intelligence and database technologies , 2011, Topics in information systems.

[37]  Sergio Tessaris,et al.  Extracting Ontologies from Relational Databases , 2007, Description Logics.

[38]  Arvind Malhotra,et al.  XML Schema Part 2: Datatypes Second Edition , 2004 .

[39]  Daniel P. Miranker,et al.  OBO & OWL: Roundtrip Ontology Transformations , 2009, SWAT4LS.

[40]  Oscar Corcho,et al.  Overcoming database heterogeneity to facilitate social networks: the Colombian displaced population as a case study , 2009, WWW 2009.

[41]  Craig A. Knoblock,et al.  Retrieving and Integrating Data from Multiple Information Sources , 1993, Int. J. Cooperative Inf. Syst..

[42]  Stephen Cranefield,et al.  UML for ontology development , 2002, The Knowledge Engineering Review.

[43]  Daniel P. Miranker,et al.  Mapping between the OBO and OWL ontology languages , 2011, J. Biomed. Semant..

[44]  Tzung-Pei Hong,et al.  Mining fuzzy functional dependencies from quantitative data , 2000, Smc 2000 conference proceedings. 2000 ieee international conference on systems, man and cybernetics. 'cybernetics evolving to systems, humans, organizations, and their complex interactions' (cat. no.0.

[45]  Laura M. Haas,et al.  Schema Mapping as Query Discovery , 2000, VLDB.

[46]  Christian Bizer,et al.  Executing SPARQL Queries over the Web of Linked Data , 2009, SEMWEB.

[47]  Xiaodong Zhu,et al.  Research on the Rules of Mapping from Relational Model to OWL , 2006, OWLED.