research-article

Incremental Export of Relational Database Contents into RDF Graphs

Authors:

Nikolaos Konstantinou,

Dimitris Kouis,

Nikolas MitrouAuthors Info & Claims

WIMS '14: Proceedings of the 4th International Conference on Web Intelligence, Mining and Semantics (WIMS14)

Article No.: 33, Pages 1 - 8

https://doi.org/10.1145/2611040.2611082

Published: 02 June 2014 Publication History

Abstract

In addition to tools offering RDF views over databases, a variety of tools exist that allow exporting database contents into RDF graphs; tools proven that in many cases demonstrate better performance than the former. However, in cases when database contents are exported into RDF, it is not always optimal or even necessary to dump the whole database contents every time. In this paper, the problem of incremental generation and storage of the resulting RDF graph is investigated. An implementation of the R2RML standard is used in order to express mappings that associate tuples from the source database to triples in the resulting RDF graph. Next, a methodology is proposed that enables incremental generation and storage of an RDF graph based on a source relational database, and it is evaluated through a set of performance measurements. Finally, a discussion is presented regarding the authors' most important findings and conclusions.

References

[1]

Villazon-Terrazas, B., Vila-Suero, D., Garijo, D., Vilches-Blazquez, L.M., Poveda-Villalon, M., Mora, J., Corcho, O., Gomez-Perez, A. 2012. Publishing Linked Data - There is no One-Size-Fits-All Formula. In Proceedings of the European Data Forum

[2]

Konstantinou, N, Spanos, D.E., Mitrou, N. 2013. Transient and Persistent RDF Views over Relational Databases in the Context of Digital Repositories. In Proceedings of the 7th Metadata and Semantics Research Conference (MTSR'13), Thessaloniki, Greece

[3]

Dougherty, E., Laplante, P. 1995. Introduction to Real-Time Imaging, chapter What is Real-Time Processing?, pp. 1--9. Wiley-IEEE Press

[4]

Sahoo, S., Halb, W., Hellmann, S., Idehen, K., Thibodeau, T., Auer, S., Sequeda, J., Ezzat, A. 2009. A Survey of Current Approaches for Mapping of Relational Databases to RDF. Available at http://www.w3.org/2005/Incubator/rdb2rdf/RDB2RDF_SurveyReport.pdf, accessed on February 28th 2014

[5]

Konstantinou, N., Spanos, D.E., Mitrou, N. 2008. Ontology and Database Mapping: A Survey of Current Implementations and Future Directions. In J. Web Engineering, 7, 1, 1--24

Digital Library

[6]

Bakkas, J., Bahaj, M. 2013. Generating of RDF graph from a relational database using Jena API. International Journal of Engineering and Technology, 5, 2, 1970--1975

[7]

De Virgilio, R., Maccioni, A., Torlone, R. 2013. Converting Relational to Graph Databases. In First International Workshop on Graph Data Management Experiences and Systems (GRADES '13), pp. 1--6, New York, New York, USA, ACM Press

Digital Library

[8]

Arenas, M., Bertails, A., Prud'hommeaux, E., Sequeda, J. 2012. A Direct Mapping of Relational Data to RDF. W3C Recommendation. Available online at http://www.w3.org/TR/rdb-direct-mapping/

[9]

Sequeda, J., Arenas, M., Miranker, D. 2012. On Directly Mapping Relational Databases to RDF and OWL. In Proceedings of the 21st World Wide Web Conference, Lyon, France

Digital Library

[10]

Rodriguez-Muro, M., Kontchakov, R., Zakharyaschev, M. 2013. Ontology-Based Data Access: Ontop of Databases. In Proceedings of the 12th International Semantic Web Conference (ISWC'13), Sydney, Australia

Digital Library

[11]

Vavliakis, K. N., Grollios, T. K., Mitkas, P. A. 2013. RDOTE -- Publishing Relational Databases into the Semantic Web. In Journal of Systems and Software, 86, 1, 89--99

Digital Library

[12]

Chebotko, A., Lu, S., and Fotouhi, F. 2009. Semantics Preserving SPARQL-to-SQL Translation. In Data & Knowledge Engineering, 68, 10, 973--1000

Digital Library

[13]

Cyganiak, R. 2005. A Relational Algebra for SPARQL, Technical Report HPL 2005-170

[14]

Bizer, C., Schultz, A. 2009. The Berlin SPARQL Benchmark. In International Journal On Semantic Web and Information Systems, 5, 2, 1--24

[15]

Bizer, C., Cyganiak, R. 2006. D2R Server - Publishing Relational Databases on the Semantic Web. In Proceedings of the 5th International Semantic Web Conference

[16]

Erling, O., Mikhailov, I. 2007. RDF support in the Virtuoso DBMS. Proceedings of the 1st Conference on Social Semantic Web, Leipzig, Germany, 59--68

[17]

Blakeley, C. 2007. Virtuoso RDF Views Getting Started Guide. Available online at http://www.openlinksw.co.uk/virtuoso/Whitepapers/pdf/Virtuoso_SQL_to_RDF_Mapping.pdf accessed on February 28th 2014

[18]

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

[19]

Spanos, D.-E., Stavrou, P., Mitrou, N. 2012. Bringing Relational Databases into the Semantic Web: A Survey. In Semantic Web Journal, 3, 2, 169--209

Digital Library

[20]

Konstantinou, N., Spanos, D.-E., Houssos, N., Mitrou, N. 2014. Exposing Scholarly Information as Linked Open Data: RDFizing DSpace contents. In The Electronic Library, in press

[21]

Auer, S, Dietzold, S., Lehmann, J., Hellmann, S., Aumueller, D. 2009. Triplify -- Light-Weight Linked Data Publication from Relational Databases. In Proceedings of the 18th international conference on World Wide Web, New York, NY, USA, 621--630

Digital Library

[22]

Vidal, V. M. P., Casanova, M. A., Cardoso, D. S. 2013. Incremental Maintenance of RDF Views of Relational Data. In On the Move to Meaningful Internet Systems (OTM 2013 Conferences), Lecture Notes in Computer Science, Volume 8185, 572--587

[23]

Pu, X., Wang, J., Luo, P., Wang, M. 2011. AWETO: Efficient Incremental Update and Querying in RDF Storage System. In Proceedings of the 20th ACM International Conference on Information and Knowledge Management (CIKM '11), New York, New York, USA

Digital Library

[24]

Das, S., Sundara, S., Cyganiak, R. 2012. R2RML: RDB to RDF Mapping Language. W3C Recommendation. Available online at http://www.w3.org/TR/r2rml/, accessed on February 28th 2014

[25]

Carroll, J., Dickinson, I., Dollin, C., Reynolds, D., Seaborne, A., Wilkinson, K. 2004. Jena: Implementing the Semantic Web Recommendations. In Proceedings of the 13th World Wide Web Conference, New York, New York, USA

Digital Library

Cited By

Asfand-E-Yar MAli R(2020)Semantic Integration of Heterogeneous Databases of Same Domain Using OntologyIEEE Access10.1109/ACCESS.2020.29886858(77903-77919)Online publication date: 2020
https://doi.org/10.1109/ACCESS.2020.2988685
Dongo IChbeir R(2019)S-RDF: A New RDF Serialization Format for Better Storage Without Losing Human ReadabilityOn the Move to Meaningful Internet Systems: OTM 2019 Conferences10.1007/978-3-030-33246-4_16(246-264)Online publication date: 11-Oct-2019
https://doi.org/10.1007/978-3-030-33246-4_16
Benmahria BChaker IZahi A(2019)Validation and Evaluation of the Mapping Process for Generating Ontologies from Relational DatabasesNew Knowledge in Information Systems and Technologies10.1007/978-3-030-16181-1_32(337-350)Online publication date: 27-Mar-2019
https://doi.org/10.1007/978-3-030-16181-1_32
Show More Cited By

Index Terms

Incremental Export of Relational Database Contents into RDF Graphs
1. Information systems
  1. Data management systems
    1. Database management system engines
  2. Information storage systems
    1. Record storage systems
      1. Record storage alternatives

Recommendations

RDB2RDF: completed transformation from relational database into RDF ontology
ICUIMC '14: Proceedings of the 8th International Conference on Ubiquitous Information Management and Communication

One of the most advantages of the Semantic Web is to augment the data with a well-defined meaning and linking between data by using the RDF ontology language. Today most of data are stored in relational databases. In order to reuse and infer this data ...
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 ...
Relational database to RDF mapping patterns
WOP'12: Proceedings of the 3rd International Conference on Ontology Patterns - Volume 929

In order to integrate relational databases into Semantic Web applications, relational databases need to be mapped to RDF. The W3C RDB2RDF Working Group is in the process of ratifying two standards to map relational databases to RDF: Direct Mapping and ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

WIMS '14: Proceedings of the 4th International Conference on Web Intelligence, Mining and Semantics (WIMS14)

June 2014

506 pages

ISBN:9781450325387

DOI:10.1145/2611040

Copyright © 2014 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

In-Cooperation

Aristotle University of Thessaloniki

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 02 June 2014

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article
Research
Refereed limited

Conference

WIMS '14

WIMS '14: 4th International Conference on Web Intelligence, Mining and Semantics

June 2 - 4, 2014

Thessaloniki, Greece

Acceptance Rates

WIMS '14 Paper Acceptance Rate 41 of 90 submissions, 46%;

Overall Acceptance Rate 140 of 278 submissions, 50%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

9
Total Citations
View Citations
199
Total Downloads

Downloads (Last 12 months)7
Downloads (Last 6 weeks)1

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

Asfand-E-Yar MAli R(2020)Semantic Integration of Heterogeneous Databases of Same Domain Using OntologyIEEE Access10.1109/ACCESS.2020.29886858(77903-77919)Online publication date: 2020
https://doi.org/10.1109/ACCESS.2020.2988685
Dongo IChbeir R(2019)S-RDF: A New RDF Serialization Format for Better Storage Without Losing Human ReadabilityOn the Move to Meaningful Internet Systems: OTM 2019 Conferences10.1007/978-3-030-33246-4_16(246-264)Online publication date: 11-Oct-2019
https://doi.org/10.1007/978-3-030-33246-4_16
Benmahria BChaker IZahi A(2019)Validation and Evaluation of the Mapping Process for Generating Ontologies from Relational DatabasesNew Knowledge in Information Systems and Technologies10.1007/978-3-030-16181-1_32(337-350)Online publication date: 27-Mar-2019
https://doi.org/10.1007/978-3-030-16181-1_32
Hazber MLi RXu GAlalayah K(2016)An Approach for Automatically Generating R2RML-Based Direct Mapping from Relational DatabasesSocial Computing10.1007/978-981-10-2053-7_15(151-169)Online publication date: 31-Jul-2016
https://doi.org/10.1007/978-981-10-2053-7_15
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
Moldovan DAntal MValea DPop CCioara TAnghel ISalomie I(2015)Tools for mapping ontologies to relational databases: A comparative evaluation2015 IEEE International Conference on Intelligent Computer Communication and Processing (ICCP)10.1109/ICCP.2015.7312609(77-83)Online publication date: Sep-2015
https://doi.org/10.1109/ICCP.2015.7312609
Wardani DKung J(2015)An Attributed Predicate RDF2015 IEEE International Conference on Computer and Information Technology; Ubiquitous Computing and Communications; Dependable, Autonomic and Secure Computing; Pervasive Intelligence and Computing10.1109/CIT/IUCC/DASC/PICOM.2015.58(410-416)Online publication date: Oct-2015
https://doi.org/10.1109/CIT/IUCC/DASC/PICOM.2015.58
Konstantinou NSpanos DKonstantinou NSpanos D(2015)Deploying Linked Open Data: Methodologies and Software ToolsMaterializing the Web of Linked Data10.1007/978-3-319-16074-0_3(51-71)Online publication date: 2015
https://doi.org/10.1007/978-3-319-16074-0_3
Wardani DKiing J(2014)Semantic mapping relational to graph model2014 International Conference on Computer, Control, Informatics and Its Applications (IC3INA)10.1109/IC3INA.2014.7042620(160-165)Online publication date: Oct-2014
https://doi.org/10.1109/IC3INA.2014.7042620

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents