article

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

Authors:

Juan f. Sequeda,

Syed hamid Tirmizi,

Daniel p. MirankerAuthors Info & Claims

The Knowledge Engineering Review, Volume 26, Issue 4

Pages 445 - 486

https://doi.org/10.1017/S0269888911000208

Published: 01 December 2011 Publication History

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.

References

[1]

Aho, A., Lam, M., Sethi, R. & Ullman, J. 2006. Compilers: Principles, Techniques and Tools. Addison-Wesley.

Digital Library

[2]

An, Y., Borgida, A. & Mylopoulos, J. 2005. Inferring complex semantic mappings between relational tables and ontologies from simple correspondences. In Proceedings of On The Move to Meaninful Internet Systems (OTM'05): CoopIS, DOA, and ODBASE, Agia Napa, Cyprus. Springer Verlag.

[3]

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.

[4]

Arens, A., Chee, C. Y., Hsu, C. & Knoblock, C. 1993. Retrieving and integrating data from multiple information sources. International Journal on Intelligent and Cooperative Information Systems 2(2), 127-158.

[5]

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/.

[6]

Astrova, I. 2004. Reverse engineering of relational databases to ontologies. In Proceedings of 1st European Semantic Web Symposium (ESWS 2004), Crete, Greece. Springer.

[7]

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.

[8]

Barrasa, J. & Gomez-Perez, A. 2006. Upgrading relational legacy data to the semantic web. In Proceedings of 15th International World Wide Web Conference. ACM, 1069-1070.

[9]

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.

[10]

Bizer, C. & Seaborne, A. 2004. D2RQ--treating non-RDF databases as virtual RDF graphs. In Proceedings of 3rd International Semantic Web Conference, Hiroshima, Japan.

[11]

Bizer, C., Heath, T. & Berners-Lee, T. 2009. Linked data - the story so far. International Journal on Semantic Web and Information Systems 5(3), 1-22.

[12]

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/

[13]

Buccella, A., Penabad, M. R., Rodríguez, F. J., Fariña, A. & Cechich, A. 2004. From relational databases to OWL ontologies. In Proceedings of the 6th Russian Conference on Digital Libraries, Pushchino, Rusia.

[14]

Ceri, S. & Widom, J. 1993. Managing semantic heterogeneity with production rules and persistent queues. In Proceedings of 19th Very Large Databases Conference, Dublin, Ireland.

[15]

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.

[16]

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.

[17]

Collet, C., Huhns, M. N., Hsu, C. & Shen, W. 1991. Resource integration using a large knowledge base in Carnot. Computer 12(24), 55-62.

Digital Library

[18]

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/

[19]

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/

[20]

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.

[21]

Drummond, N. & Shearer, R. 2006. The Open World Assumption. eSI Workshop: The Closed World of Databases meets the Open World of the Semantic Web.

[22]

Du, H. & Wery, L. 1999. Micro: a normalization tool for relational database engineers. Journal of Network and Computer Applications 22(4), 215-232.

Digital Library

[23]

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.

[24]

Garcia-Molina, H., Ullman, J. & Widom, J. 2009. Database Systems: The Complete Book. Pearson Prentice Hall.

[25]

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.

[26]

Hayes, P. (ed.) 2004. RDF Semantics. Retrieved February 5, 2009, from W3C Recommendation. http:// www.w3.org/TR/rdf-mt/

[27]

He, B., Patel, M., Zhang, Z. & Chang, K. 2007. Accessing the deep web. Communications of the ACM 50(5), 94-101.

Digital Library

[28]

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/

[29]

Korotkiy, M. & Top, J. 2004. From Relational Data to RDFS models. In Proceedings of the 2004 International Conference on Web Engineering, Munich, Germany.

[30]

Kogut, P., Cranefield, S., Hart, L., Dutra, M., Baclawski, K., Kokar, M. & Smith, J. 2002. UML for ontology development. Knowledge Engineering Review 12(1), 61-64.

[31]

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ízke Tatry, Slovaki.

[32]

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.

[33]

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.

[34]

Lutz, C., Areces, C., Horricks, I. & Satler, U. 2004. Keys, nominals, and concrete domains. Journal of Artificial Intelligence Research 23, 667-726.

Digital Library

[35]

Meier, D. 1983. The Theory of Relational Databases. Computer Science Press.

[36]

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.

[37]

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.

[38]

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/

[39]

Pratt, P. J. 1990. A Guide to SQL. Boyd & Fraser Publishing Company.

[40]

Pratt, P. J. 1995. A Guide to SQL, 3rd edn. Boyd & Fraser Publishing Company.

[41]

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/

[42]

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.

[43]

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.

[44]

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.

[45]

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.

[46]

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/

[47]

SQL3 (ISO-ANSI Working Draft). (n.d.). Retrieved February 5, 2009, from http://www.inf.fuberlin. de/lehre/SS94/einfdb/SQL3/sqlindex.html

[48]

Stonebraker, M. 1986. Triggers and inference in database systems. In On Knowledge Base Management Systems: Integrating Artificial Intelligence and Database Technologies, Brodie, M. L. & Mylopoulos, J. (eds). Springer Topics in Information Systems. Springer-Verlag, 297-314.

[49]

Stojanovic, L., Stojanovic, N. & Volz, R. 2002a. Migrating data-intensive web sites into the Semantic Web. In Proceedings of the 2002 ACM Symposium on Applied Computing, SAC'02, Madrid, Spain, March 11-14, 2002, ACM, 1100-1107.

Digital Library

[50]

Stojanovic, L., Stojanovic, N. & Volz, R. 2002b. A reverse engineering approach for migrating data-intensive web sites to the Semantic Web. In Proceedings of the IFIP 17th World Computer Congress--Tc12 Stream on Intelligent Information Processing, August 25-30, 2002, Musen, M. A., Neumann, B., & Studer, R. (eds). IFIP Conference Proceedings, Kluwer B. V., Deventer, the Netherlands, 221, 141-154.

[51]

Svihla, M. & Jelinek, I. 2004. Two Layer Mapping from Database to RDF. In Proceedings of Electronic Computers and Informatics (ECI). Slovakia, Kosice.

[52]

Tirmizi, S. H., Sequeda, J. F. & Miranker, D. P. 2008. Translating SQL applications to the semantic web. In Proceedings of the 19th International Conference on Database and Expert Systems Applications, September 01-05, 2008, Turin, Italy, Bhowmick, S. S., Küng, J. & Wagner, R. (eds). Lecture Notes in Computer Science. Springer-Verlag, 5181, 450-464.

[53]

Tirmizi, S. H., Aitken, S., Moreira, D., Mungall, C., Sequeda, J. F., Shah, N. H. & Miranker, D. P. 2011. Mapping between the OBO and OWL ontology languages. Journal of Biomedical Semantics 2(Suppl 1), S3.

[54]

Vrandecic, D. & Sure, Y. 2008. How to design better ontology metrics. In Proceedings of the 4th European Conference on Semantic Web: Research and Applications, Innsbruck, Austria, June 03-07, 2007, Franconi, E., Kifer, M. & May, W. (eds), Lecture Notes In Computer Science. Springer-Verlag, 4519, 311-325.

Digital Library

[55]

Wang, S., Shen, J. & Hong, T. 2000. Mining fuzzy functional dependencies from quantitative data. IEEE International Conference on Systems, Man and Cybernetics 5, 3600-3606.

[56]

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/

[57]

Xu, Z., Zhang, S. & Dong, Y. 2006. Mapping between Relational Database Schema and OWL Ontology for Deep Annotation. In Proceedings of the 2006 IEEE/WIC/ACM International Conference on Web intelligence. IEEE Computer Society, 548-552.

Digital Library

Cited By

Natarajan SVairavasundaram STeekaraman YKuppusamy RRadhakrishnan A(2021)Schema-Based Mapping Approach for Data Transformation to Enrich Semantic WebWireless Communications & Mobile Computing10.1155/2021/85678942021Online publication date: 10-Nov-2021
https://dl.acm.org/doi/10.1155/2021/8567894
Mansfield MTamma VGoddard PCoenen FGentile AGonçalves R(2021)Capturing Expert Knowledge for Building Enterprise SME Knowledge GraphsProceedings of the 11th Knowledge Capture Conference10.1145/3460210.3493569(129-136)Online publication date: 2-Dec-2021
https://dl.acm.org/doi/10.1145/3460210.3493569
Mountantonakis MTzitzikas Y(2019)Large-scale Semantic Integration of Linked DataACM Computing Surveys10.1145/334555152:5(1-40)Online publication date: 13-Sep-2019
https://dl.acm.org/doi/10.1145/3345551
Show More Cited By

Review: survey of directly mapping sql databases to the semantic web
1. Information systems
  1. Data management systems

Recommendations

On directly mapping relational databases to RDF and OWL
WWW '12: Proceedings of the 21st international conference on World Wide Web

Mapping relational databases to RDF is a fundamental problem for the development of the Semantic Web. We present a solution, inspired by draft methods defined by the W3C where relational databases are directly mapped to RDF and OWL. Given a relational ...
Towards Integration Rules of Mapping from Relational Databases to Semantic Web Ontology
WISM '10: Proceedings of the 2010 International Conference on Web Information Systems and Mining - Volume 01

This paper points towards the integration rules of mapping from relational database such as SQL DDL, schema and data into the semantic web ontology such as OWL which build on top of RDF using vocabulary RDFS and XML schema data type. From the study, ...
RDOTE - Publishing Relational Databases into the Semantic Web

A necessary step for the evolution of the traditional Web into a Semantic Web is the transformation of the vast quantities of data, currently residing in Relational Databases into semantically aware data. In addition, in cases where new ontology ...

Comments

Information & Contributors

Information

Published In

cover image The Knowledge Engineering Review

The Knowledge Engineering Review Volume 26, Issue 4

December 2011

155 pages

ISSN:0269-8889

Issue’s Table of Contents

Publisher

Cambridge University Press

United States

Publication History

Published: 01 December 2011

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

18
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 23 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Natarajan SVairavasundaram STeekaraman YKuppusamy RRadhakrishnan A(2021)Schema-Based Mapping Approach for Data Transformation to Enrich Semantic WebWireless Communications & Mobile Computing10.1155/2021/85678942021Online publication date: 10-Nov-2021
https://dl.acm.org/doi/10.1155/2021/8567894
Mansfield MTamma VGoddard PCoenen FGentile AGonçalves R(2021)Capturing Expert Knowledge for Building Enterprise SME Knowledge GraphsProceedings of the 11th Knowledge Capture Conference10.1145/3460210.3493569(129-136)Online publication date: 2-Dec-2021
https://dl.acm.org/doi/10.1145/3460210.3493569
Mountantonakis MTzitzikas Y(2019)Large-scale Semantic Integration of Linked DataACM Computing Surveys10.1145/334555152:5(1-40)Online publication date: 13-Sep-2019
https://dl.acm.org/doi/10.1145/3345551
Xiao GCalvanese DKontchakov RLembo DPoggi ARosati RZakharyaschev M(2018)Ontology-based data accessProceedings of the 27th International Joint Conference on Artificial Intelligence10.5555/3304652.3304791(5511-5519)Online publication date: 13-Jul-2018
https://dl.acm.org/doi/10.5555/3304652.3304791
Pinkel CBinnig CJiménez-Ruiz EKharlamov EMay WNikolov ASasa Bastinos ASkjæveland MSolimando ATaheriyan MHeupel CHorrocks IZaveri AKontokostas DHellmann SUmbrich J(2018)RODISemantic Web10.3233/SW-1702689:1(25-52)Online publication date: 1-Jan-2018
https://dl.acm.org/doi/10.3233/SW-170268
Sequeda JMiranker D(2017)A Pay-As-You-Go Methodology for Ontology-Based Data AccessIEEE Internet Computing10.1109/MIC.2017.4621:2(92-96)Online publication date: 1-Mar-2017
https://dl.acm.org/doi/10.1109/MIC.2017.46
(2017)Ontology Based Data Access in StatoilWeb Semantics: Science, Services and Agents on the World Wide Web10.1016/j.websem.2017.05.00544:C(3-36)Online publication date: 1-May-2017
https://dl.acm.org/doi/10.1016/j.websem.2017.05.005
Khalefa MEl-Atawy S(2016)Demonstrating KDBMSProceedings of the 28th International Conference on Scientific and Statistical Database Management10.1145/2949689.2949714(1-4)Online publication date: 18-Jul-2016
https://dl.acm.org/doi/10.1145/2949689.2949714
Lim KJun HKim H(2015)Semantics preserving MapReduce process for RDB to RDF transformationInternational Journal of Metadata, Semantics and Ontologies10.1504/IJMSO.2015.07474410:4(229-239)Online publication date: 1-Feb-2015
https://dl.acm.org/doi/10.1504/IJMSO.2015.074744
Medeiros LPriyatna FCorcho O(2015)MIRRORProceedings of the 15th International Conference on Engineering the Web in the Big Data Era - Volume 911410.1007/978-3-319-19890-3_21(326-343)Online publication date: 23-Jun-2015
https://dl.acm.org/doi/10.1007/978-3-319-19890-3_21
Show More Cited By

View Options

View options

Media

Figures

Other

Tables

View Issue’s Table of Contents