{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,8]],"date-time":"2026-05-08T15:51:41Z","timestamp":1778255501235,"version":"3.51.4"},"reference-count":57,"publisher":"Maximum Academic Press","issue":"4","license":[{"start":{"date-parts":[[2011,12,1]],"date-time":"2011-12-01T00:00:00Z","timestamp":1322697600000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/www.cambridge.org\/core\/terms"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["The Knowledge Engineering Review"],"published-print":{"date-parts":[[2011,12]]},"abstract":"<jats:title>Abstract<\/jats:title>\n                  <jats:p>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.<\/jats:p>","DOI":"10.1017\/s0269888911000208","type":"journal-article","created":{"date-parts":[[2011,11,25]],"date-time":"2011-11-25T06:28:33Z","timestamp":1322202513000},"page":"445-486","source":"Crossref","is-referenced-by-count":56,"title":["Survey of directly mapping SQL databases to the Semantic Web"],"prefix":"10.48130","volume":"26","author":[{"given":"Juan F.","family":"Sequeda","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Syed Hamid","family":"Tirmizi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Oscar","family":"Corcho","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Daniel P.","family":"Miranker","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"27968","published-online":{"date-parts":[[2011,12,1]]},"reference":[{"key":"S0269888911000208_ref57","unstructured":"Biron P. V. , Permanente K. , Malhotra A. (ed.). 2004. XML Schema Part 2: Datatypes, 2nd edn. Retrieved February 5, 2009, from W3C Recommendation. http:\/\/www.w3.org\/TR\/xmlschema-2\/"},{"key":"S0269888911000208_ref56","doi-asserted-by":"crossref","first-page":"3600","DOI":"10.1109\/ICSMC.2000.886568","article-title":"Mining fuzzy functional dependencies from quantitative data","volume":"5","author":"Wang","year":"2000","journal-title":"IEEE International Conference on Systems, Man and Cybernetics"},{"key":"S0269888911000208_ref55","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-72667-8_23"},{"key":"S0269888911000208_ref53","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-85654-2_40"},{"key":"S0269888911000208_ref52","volume-title":"Proceedings of Electronic Computers and Informatics (ECI)","author":"Svihla","year":"2004"},{"key":"S0269888911000208_ref30","doi-asserted-by":"crossref","unstructured":"Korotkiy M. , Top J. 2004. From Relational Data to RDFS models. In Proceedings of the 2004 International Conference on Web Engineering, Munich, Germany.","DOI":"10.1007\/978-3-540-27834-4_52"},{"key":"S0269888911000208_ref7","unstructured":"Astrova I. , Korda N. , Kalja A. 2007. Rule-based transformation of SQL relational databases to OWL ontologies. In Proceedings of 2nd International Conference on Metadata & Semantic Research, Corfu Island, Greece."},{"key":"S0269888911000208_ref51","first-page":"141","volume-title":"Proceedings of the IFIP 17th World Computer Congress\u2014Tc12 Stream on Intelligent Information Processing","volume":"221","author":"Stojanovic","year":"2002b."},{"key":"S0269888911000208_ref29","unstructured":"Klyne G. , Carroll J. J. (ed.) 2004. Resource Description Framework (RDF): concepts and abstract syntact. Retrieved February 17, 2011, from W3C Recommendation. http:\/\/www.w3.org\/TR\/rdf-concepts\/"},{"key":"S0269888911000208_ref43","unstructured":"Sequeda J. F. , Tirmizi S. H. , Miranker D. P. 2007. SQL databases are a moving target. Position Paper for W3C Workshop on RDF Access to Relational Databases, Cambridge, MA, USA."},{"key":"S0269888911000208_ref22","unstructured":"Drummond N. , Shearer R. 2006. The Open World Assumption. eSI Workshop: The Closed World of Databases meets the Open World of the Semantic Web."},{"key":"S0269888911000208_ref54","doi-asserted-by":"publisher","DOI":"10.1186\/2041-1480-2-S1-S3"},{"key":"S0269888911000208_ref40","volume-title":"A Guide to SQL","author":"Pratt","year":"1990"},{"key":"S0269888911000208_ref16","doi-asserted-by":"crossref","unstructured":"Chen H. , Wang Y. , Wang H. , Mao Y. , Tang J. , Zhou C. , et al. 2006. Towards a semantic web of relational databases: a practical semantic toolkit and an in-use case from traditional chinese medicine. In Proceedings of the 5th International Semantic Web Conference, Athens, GA, USA.","DOI":"10.1007\/11926078_54"},{"key":"S0269888911000208_ref50","doi-asserted-by":"publisher","DOI":"10.1145\/508791.509008"},{"key":"S0269888911000208_ref58","first-page":"548","volume-title":"Proceedings of the 2006 IEEE\/WIC\/ACM International Conference on Web intelligence","author":"Xu","year":"2006"},{"key":"S0269888911000208_ref1","volume-title":"Compilers: Principles, Techniques and Tools","author":"Aho","year":"2006"},{"key":"S0269888911000208_ref25","volume-title":"Database Systems: The Complete Book","author":"Garcia-Molina","year":"2009"},{"key":"S0269888911000208_ref15","unstructured":"Chiang R. H. L. , Barron T. M. , Storey V. C. 1994. Extracting domain semantics for knowledge discovery in relational databases. In Knowledge Discovery in Databases: Papers from the 1994 AAAI Workshop, Seattle, Washington, July 1994. Technical Report WS-94-03, AAAI Press, ISBN 0-929280-73-3, 473."},{"key":"S0269888911000208_ref5","unstructured":"Arenas M. , Prud'hommeaux E. , Sequeda J. (ed.) 2010. A direct mapping of relational data to RDF. Retrieved February 17, 2011, from W3C Working Draft, 18 November 2010. http:\/\/www.w3.org\/TR\/rdb-direct-mapping\/."},{"key":"S0269888911000208_ref41","volume-title":"A Guide to SQL","author":"Pratt","year":"1995"},{"key":"S0269888911000208_ref18","unstructured":"Das S. , Sundara S. , Cyganiak R. (ed.) 2010. R2RML: RDB to RDF Mapping Language. Retrieved February 17, 2011, from W3C Working Draft, 28 October 2010. http:\/\/www.w3.org\/TR\/r2rml\/"},{"key":"S0269888911000208_ref14","unstructured":"Ceri S. , Widom J. 1993. Managing semantic heterogeneity with production rules and persistent queues. In Proceedings of 19th Very Large Databases Conference, Dublin, Ireland."},{"key":"S0269888911000208_ref6","doi-asserted-by":"crossref","unstructured":"Astrova I. 2004. Reverse engineering of relational databases to ontologies. In Proceedings of 1st European Semantic Web Symposium (ESWS 2004), Crete, Greece. Springer.","DOI":"10.1007\/978-3-540-25956-5_23"},{"key":"S0269888911000208_ref12","unstructured":"Brickley D. , Guha R. V. (ed.). 2004. RDF Vocabulary Description Language 1.0: RDF Schema. Retrieved February 17, 2011, from W3C Recommendation. http:\/\/www.w3.org\/TR\/rdf-schema\/"},{"key":"S0269888911000208_ref11","first-page":"1","article-title":"Linked data \u2013 the story so far","volume":"5","author":"Bizer","year":"2009","journal-title":"International Journal on Semantic Web and Information Systems"},{"key":"S0269888911000208_ref33","unstructured":"Li M. , Du X. , Wang S. 2005. Learning ontology from relational database. In Proceedings of the 4th International Conference on Machine Learning and Cybernetics, Guangzhou, China."},{"key":"S0269888911000208_ref8","first-page":"1069","volume-title":"Proceedings of 15th International World Wide Web Conference","author":"Barrasa","year":"2006"},{"key":"S0269888911000208_ref13","unstructured":"Buccella A. , Penabad M. R. , Rodr\u00edguez F. J. , Fari\u00f1a A. , Cechich A. 2004. From relational databases to OWL ontologies. In Proceedings of the 6th Russian Conference on Digital Libraries, Pushchino, Rusia."},{"key":"S0269888911000208_ref24","unstructured":"Duo D. , Pan J. , Qin H. , LePendu P. 2006. Towards populating and querying the Semantic Web. In Proceedings of the 2nd International workshop on Scalable Semantic Web Knowledge Base Systems (SSWS 2006), Athens, GA, USA."},{"key":"S0269888911000208_ref31","doi-asserted-by":"crossref","first-page":"61","DOI":"10.1017\/S0269888902000358","article-title":"UML for ontology development","volume":"12","author":"Kogut","year":"2002","journal-title":"Knowledge Engineering Review"},{"key":"S0269888911000208_ref28","doi-asserted-by":"publisher","DOI":"10.1145\/1230819.1241670"},{"key":"S0269888911000208_ref4","doi-asserted-by":"publisher","DOI":"10.1142\/S0218215793000071"},{"key":"S0269888911000208_ref39","doi-asserted-by":"crossref","unstructured":"Motik B. , Horrocks I. , Sattler U. 2007. Bridging the gap between OWL and relational databases. In Proceedings of the 16th International Conference on World Wide Web, Banff, Canada.","DOI":"10.1145\/1242572.1242681"},{"key":"S0269888911000208_ref49","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4612-4980-1_25"},{"key":"S0269888911000208_ref2","volume-title":"Proceedings of On The Move to Meaninful Internet Systems (OTM'05): CoopIS, DOA, and ODBASE, Agia Napa, Cyprus","author":"An","year":"2005"},{"key":"S0269888911000208_ref3","unstructured":"An Y. , Mylopoulos J. , Borgida A. 2006. Building semantic mappings from databases to ontologies. In Proceedings of the 21th National Conference on Artificial Intelligence (AAAI-06) Nectar Track, Boston, MA, USA."},{"key":"S0269888911000208_ref38","unstructured":"Miller R. , Haas L. , Hernandez M. 2000. Schema mapping as query discovery. In Proceedings of the 26th International Conference on Very Large Database, Cairo, Egypt."},{"key":"S0269888911000208_ref9","unstructured":"Barrasa J. , Corcho O. , Gomez-Perez A. 2004. R2O, an extensible and semantically based database-to-ontology mapping language. In Proceedings of 2nd Workshop on Semantic Web and Databases, Toronto, Canada."},{"key":"S0269888911000208_ref10","unstructured":"Bizer C. , Seaborne A. 2004. D2RQ\u2014treating non-RDF databases as virtual RDF graphs. In Proceedings of 3rd International Semantic Web Conference, Hiroshima, Japan."},{"key":"S0269888911000208_ref17","doi-asserted-by":"publisher","DOI":"10.1109\/2.116889"},{"key":"S0269888911000208_ref19","unstructured":"Dean M. , Schreiber G. (ed.) 2004. OWL Web Ontological Language Reference. Retrieved February 5, 2009, from W3C Recommendation. http:\/\/www.w3.org\/TR\/owl-ref\/"},{"key":"S0269888911000208_ref42","unstructured":"Prud'hommeaux E. , Seaborne E. (eds) 2008. SPARQL Query Language for RDF. Retrieved February 17, 2011 from W3C Recommendation. http:\/\/www.w3.org\/TR\/rdf-sparql-query\/"},{"key":"S0269888911000208_ref20","unstructured":"de Laborda C. P. , Conrad S. 2005. Relational. OWL: a data and schema representation format based on OWL. In Proceedings of the 2nd Asia-Pacific Conference on Conceptual Modelling, Newcastle, Australia."},{"key":"S0269888911000208_ref23","doi-asserted-by":"publisher","DOI":"10.1006\/jnca.1999.0096"},{"key":"S0269888911000208_ref26","doi-asserted-by":"crossref","unstructured":"Hartig O. , Bizer C. , Freytag J. C. 2009. Executing SPARQL queries over the web of Linked Data. In Proceedings of the 8th International Semantic Web Conference (ISWC2009), Chantilly, VA, USA.","DOI":"10.1007\/978-3-642-04930-9_19"},{"key":"S0269888911000208_ref27","unstructured":"Hayes P. (ed.) 2004. RDF Semantics. Retrieved February 5, 2009, from W3C Recommendation. http:\/\/www.w3.org\/TR\/rdf-mt\/"},{"key":"S0269888911000208_ref32","unstructured":"Laclavik M. 2006. RDB2Onto: Relational Database Data to Ontology Individual Mapping. In Proceedings of Tools for Acquisition, Organisation and Presenting of Information and Knowledge, N\u00edzke Tatry, Slovaki."},{"key":"S0269888911000208_ref35","doi-asserted-by":"crossref","unstructured":"Lubyte L. , Tessaris S. 2009. Automatic extraction of ontologies wrapping relational data sources. In Proceedings of the 20th Database and Expert Systems Applications (DEXA2009), Linz, Austria.","DOI":"10.1007\/978-3-642-03573-9_10"},{"key":"S0269888911000208_ref36","first-page":"667","article-title":"Keys, nominals, and concrete domains","volume":"23","author":"Lutz","year":"2004","journal-title":"Journal of Artificial Intelligence Research"},{"key":"S0269888911000208_ref37","volume-title":"The Theory of Relational Databases","author":"Meier","year":"1983"},{"key":"S0269888911000208_ref59","unstructured":"Noy N. , Rector A. (ed.) 2006. Defining N-ary Relations on the Semantic Web. W3C Working Group Note. http:\/\/www.w3.org\/TR\/swbp-n-aryRelations\/"},{"key":"S0269888911000208_ref44","unstructured":"Sequeda J. F. , Tirmizi S. H. , Miranker D. P. 2008. A bootstrapping architecture for integration of relational databases to the Semantic Web. In Proceedings of the Poster and Demonstration Session at the 7th International Semantic Web Conference, Karlsruhe, Germany."},{"key":"S0269888911000208_ref45","unstructured":"Sequeda J. F. , Garcia-Castro A. , Corcho O. , Tirmizi S. H. , Miranker D. P. 2009. Overcoming database heterogeneity to facilitate social networks: the Colombian displaced population as a case study. In Proceedings of the 18th International Conference on World Wide Web Ibero-America Track, Madrid, Spain."},{"key":"S0269888911000208_ref46","unstructured":"Shen G. , Huang Z. , Zhu X. , Zhao X. 2006. Research on the rules of mapping from relational model to OWL. In Proceedings of the Workshop on OWL: Experiences and Directions, Athens, GA, USA."},{"key":"S0269888911000208_ref47","unstructured":"Smith M. K. , Welty C. , McGuinness D. L. (ed.) 2004. OWL web ontology language guide. Retrieved February 5, 2009, from W3C Recommendation. http:\/\/www.w3.org\/TR\/owl-guide\/"},{"key":"S0269888911000208_ref48","unstructured":"SQL3 (ISO-ANSI Working Draft). (n.d.). Retrieved February 5, 2009, from http:\/\/www.inf.fu-berlin.de\/lehre\/SS94\/einfdb\/SQL3\/sqlindex.html"}],"container-title":["The Knowledge Engineering Review"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.cambridge.org\/core\/services\/aop-cambridge-core\/content\/view\/S0269888911000208","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,1,5]],"date-time":"2026-01-05T14:44:03Z","timestamp":1767624243000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.cambridge.org\/core\/product\/identifier\/S0269888911000208\/type\/journal_article"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2011,12]]},"references-count":57,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2011,12]]}},"alternative-id":["S0269888911000208"],"URL":"https:\/\/doi.org\/10.1017\/s0269888911000208","relation":{},"ISSN":["0269-8889","1469-8005"],"issn-type":[{"value":"0269-8889","type":"print"},{"value":"1469-8005","type":"electronic"}],"subject":[],"published":{"date-parts":[[2011,12]]}}}