Abstract
For integrating relational databases (RDBs) into semantic web applications, the W3C RDB2RDF Working Group recommended two approaches, Direct Mapping (DM) and R2RML. The DM provides a set of mapping rules according to RDB schema, while the R2RML allows users to manually define mappings according to existing target ontology. The major problem to use R2RML is the effort for creating R2RML mapping documents manually. This may lead to appearance of many mistakes in the R2RML documents and requires domain experts. In this paper, we propose and implement an approach to generate an R2RML mapping documents automatically from RDB schema. The R2RML mapping reflects the behavior of the DM specification and allows any R2RML parser to generate a set of RDF triples from relational data. The input of generating approach is DBsInfo class that automatically generated from relational schema. An experimental prototype is developed and shows the effectiveness of our approach algorithms.
Keywords
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
References
Shadbolt, N., Hall, W., Berners-Lee, T.: The semantic web revisited. IEEE Intell. Syst. 21(3), 96–101 (2006)
Manola, F., Miller, E., McBride, B.: RDF 1.1 Primer. W3C Working Group Note, 24 June 2014 (2014)
He, B., Patel, M., Zhang, Z., Chang, K.C.-C.: Accessing the deep web. Commun. ACM 50(5), 94–101 (2007)
Arenas, M., Bertails, A., Prud, E., Sequeda, J.: A direct mapping of relational data to RDF. W3C Recommendation, 27 September 2012. http://www.w3.org/TR/rdb-direct-mapping/
Souripriya Das, O., Seema Sundara, O., Cyganiak, R.: R2RML: RDB to RDF mapping language. W3C. http://www.w3.org/TR/r2rml/
Hazber, M.A.G., Li, R., Zhang, Y., Xu, G.: An approach for mapping relational database into ontology. In: Proceedings of the 12th Web Information System and Application Conference (WISA 2015), Jinan, Shangdong, China, pp. 120–125 (2015)
Priyatna, F., Corcho, O., Sequeda, J.: Formalisation and experiences of R2RML-based SPARQL to SQL query translation using morph. In: Proceedings of the 23rd International Conference on World Wide Web (WWW 2014), New York, USA, pp. 479–490 (2014)
Konstantinou, N., Kouis, D., Mitrou, N.: Incremental export of relational database contents into RDF graphs. In: Proceedings of the 4th International Conference on Web Intelligence, Mining and Semantics (WIMS 2014), Thessaloniki, Greece, p. 33 (2014)
Michel, F., Montagnat, J., Faron-Zucker, C.: A survey of RDB to RDF translation approaches and tools. Research Report. I3S (2014). https://hal.inria.fr/hal-00903568
Villazn-Terrazas, B., Hausenblas, M.: RDB2RDF Implementation Report. W3C Working Group Note, 14 August 2012. http://www.w3.org/TR/rdb2rdf-implementations/
Sahoo, S.S., Halb, W., Hellmann, S., Idehen, K., Thibodeau Jr., T., Auer, S., Sequeda, J., Ezzat, A.: A survey of current approaches for mapping of relational databases to rdf. W3C RDB2RDF XG Incubator Report W3C (2009)
Mohamed, H., Jincai, Y., Qian, J.: Towards integration rules of mapping from relational databases to semantic web ontology. In: 2010 International Conference on Web Information Systems and Mining (WISM), Sanya, China, pp. 335–339 (2010)
Vavliakis, K.N., Grollios, T.K., Mitkas, P.A.: RDOTE publishing relational databases into the semantic web. J. Syst. Softw. 86(1), 89–99 (2013)
Sequeda, J.F., Arenas, M., Miranker, D.P.: On directly mapping relational databases to RDF and OWL. In: Proceedings of the 21st international conference on World Wide Web (WWW 2012), Lyon, France, pp. 649–658 (2012)
Hazber, M.A.G., Li, R., Gu, X., Xu, G., Li, Y.: Semantic SPARQL query in a relational database based on ontology construction. In: Proceedings of the 11th International Conference on Semantics, Knowledge and Grids (SKG 2015). Beijing, China (2015)
Čerāns, K., Būmans, G.: RDB2OWL: a language and tool for database to ontology mapping. In: Proceedings of the CAiSE 2015 Forum at the 27th International Conference on Advanced Information Systems Engineering (CAiSE 2015), Kista, Sweden, pp. 81–88 (2015)
Barrasa, J., Corcho, Ó., Gómez-Pérez, A.: R2O, an extensible and semantically based database-to-ontology mapping language. In: Second Workshop on Semantic Web and Databases(SWDB 2004), pp. 1069–1070 (2004)
Auer, S., Dietzold, S., Lehmann, J., Hellmann, S., Aumueller, D.: Triplify: light-weight linked data publication from relational databases. In: : Proceedings of the 18th International Conference on World Wide Web (WWW 2009), pp. 621–630 (2009)
Bizer, C., Cyganiak, R.: D2R server-publishing relational databases on the semantic web. In: Presented at the 5th International Semantic Web Conference (ISWC 2006), Athens, GA, USA (2006)
OpenLink Virtuoso Universal Server. http://virtuoso.openlinksw.com
Sequeda, J.F., Tirmizi, S.H., Corcho, O., Miranker, D.P.: Survey of directly mapping sql databases to the semantic web. Knowl. Eng. Rev. 26(4), 445–486 (2011)
de Medeiros, L.F., Priyatna, F., Corcho, O.: MIRROR: automatic R2RML mapping generation from relational databases. In: Cimiano, P., Frasincar, F., Houben, G.-J., Schwabe, D. (eds.) ICWE 2015. LNCS, vol. 9114, pp. 326–343. Springer, Heidelberg (2015)
Dimou, A., Vander Sande, M., Colpaert, P., Verborgh, R., Mannens, E., Van de Walle, R.: RML: a generic language for integrated RDF mappings of heterogeneous data. In: Proceedings of the 7th Workshop on Linked Data on the Web (LDOW 2014), Seoul, Korea (2014)
Neto, L.E.T., Vidal, V.M.P., Casanova, M.A., Monteiro, J.M.: R2RML by assertion: a semi-automatic tool for generating customised R2RML mappings. In: Cimiano, P., Fernández, M., Lopez, V., Schlobach, S., Völker, J. (eds.) ESWC 2013. LNCS, vol. 7955, pp. 248–252. Springer, Heidelberg (2013)
Pequeno, V.M., Vidal, V.M., Casanova, M.A., Neto, L.E.T., Galhardas, H.: Specifying complex correspondences between relational schemas and RDF models for generating customized R2RML mappings. In: Proceedings of the 18th International Database Engineering & Applications Symposium, Porto, Portugal, pp. 96–104 (2014)
Prud’hommeaux, E., Carothers, G., Beckett, D., Berners-Lee, T.: RDF 1.1 Turtle: terse RDF triple language. World Wide Web Consortium. http://www.w3.org/TR/turtle/. Accessed 24 Dec 2014
Acknowledgments
This work is supported by National Natural Science Foundation of China under grants 61572221, 61173170, 61300222, 61370230, 61433006 and U1401258, Innovation Fund of Huazhong University of Science and Technology under grants 2015TS069 and 2015TS071, Science and Technology Support Program of Hubei Province under grant 2014BCH270 and 2015AAA013, and Science and Technology Program of Guangdong Province under grant 2014B010111007.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer Science+Business Media Singapore
About this paper
Cite this paper
Hazber, M.A.G., Li, R., Xu, G., Alalayah, K.M. (2016). An Approach for Automatically Generating R2RML-Based Direct Mapping from Relational Databases. In: Che, W., et al. Social Computing. ICYCSEE 2016. Communications in Computer and Information Science, vol 623. Springer, Singapore. https://doi.org/10.1007/978-981-10-2053-7_15
Download citation
DOI: https://doi.org/10.1007/978-981-10-2053-7_15
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-2052-0
Online ISBN: 978-981-10-2053-7
eBook Packages: Computer ScienceComputer Science (R0)