research-article

Converting relational to graph databases

Authors:

Roberto De Virgilio,

Antonio Maccioni,

Riccardo TorloneAuthors Info & Claims

GRADES '13: First International Workshop on Graph Data Management Experiences and Systems

Article No.: 1, Pages 1 - 6

https://doi.org/10.1145/2484425.2484426

Published: 23 June 2013 Publication History

Get Access

Abstract

Graph Database Management Systems provide an effective and efficient solution to data storage in current scenarios where data are more and more connected, graph models are widely used, and systems need to scale to large data sets. In this framework, the conversion of the persistent layer of an application from a relational to a graph data store can be convenient but it is usually an hard task for database administrators. In this paper we propose a methodology to convert a relational to a graph database by exploiting the schema and the constraints of the source. The approach supports the translation of conjunctive SQL queries over the source into graph traversal operations over the target. We provide experimental results that show the feasibility of our solution and the efficiency of query answering over the target database.

References

[1]

R. Angles and C. Gutiérrez. Survey of graph database models. ACM Comput. Surv., 40(1), 2008.

Digital Library

Google Scholar

[2]

P. Atzeni, P. Cappellari, R. Torlone, P. A. Bernstein, and G. Gianforme. Model-independent schema translation. VLDB J., 17(6):1347--1370, 2008.

Digital Library

Google Scholar

[3]

C. Bizer. D2r map - a database to rdf mapping language. In WWW (Posters), 2003.

Google Scholar

[4]

C. Bizer and A. Schultz. The berlin sparql benchmark. Int. J. Semantic Web Inf. Syst., 5(2):1--24, 2009.

Crossref

Google Scholar

[5]

F. Cerbah. Learning highly structured semantic repositories from relational databases:. In ESWG, pages 777--781, 2008.

Digital Library

Google Scholar

[6]

J. Coffman and A. C. Weaver. A framework for evaluating database keyword search strategies. In CIKM, pages 729--738, 2010.

Digital Library

Google Scholar

[7]

S. B. et al. Keyword search over relational databases: a metadata approach. In SIGMOD, pages 565--576, 2011.

Digital Library

Google Scholar

[8]

M. Hert, G. Reif, and H. C. Gall. A comparison of rdb-to-rdf mapping languages. In I-SEMANTICS, pages 25--32, 2011.

Digital Library

Google Scholar

[9]

F. Holzschuher and R. Peinl. Performance of graph query languages - comparison of cypher, gremlin and native access in neo4j. In EDBT/IGDT Workshops, pages 195--204, 2013.

Digital Library

Google Scholar

[10]

W. Hu and Y. Qu. Discovering simple mappings between relational database Schemas and ontologies. In ISWC/ASWC, pages 225--238, 2007.

Digital Library

Google Scholar

[11]

J. B. Rodríguez and A. Gómez-Pérez. Upgrading relational legacy data to the semantic web. In WWW, pages 1069--1070, 2006.

Digital Library

Google Scholar

[12]

M. A. Rodriguez and P. Neubauer. Constructions from dots and lines. CoRR, abs/1006.2361, 2010.

Google Scholar

[13]

J. Sequeda, M. Arenas, and D. P. Miranker. On directly mapping relational databases to rdf and owl. In WWW, pages 649--658, 2012.

Digital Library

Google Scholar

[14]

P. T. Wood. Query languages for graph databases. SIGMOD Record, 41(1):50--60, 2012.

Digital Library

Google Scholar

Cited By

View all

Ehlers JMonga MLonati VBarendsen ESheard JPaterson J(2024)Teaching Multiple Data Models and Query LanguagesProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653628(234-240)Online publication date: 3-Jul-2024
https://dl.acm.org/doi/10.1145/3649217.3653628
Farouzi AZhou XBellatreche LMalki MOrdonez C(2024)Balanced parallel triangle enumeration with an adaptive algorithmDistributed and Parallel Databases10.1007/s10619-023-07437-x42:1(103-141)Online publication date: 1-Mar-2024
https://dl.acm.org/doi/10.1007/s10619-023-07437-x
Manouvrier MBelhajjame K(2024)PG-FD: Mapping Functional Dependencies to the Future Property Graph Schema StandardAdvances in Databases and Information Systems10.1007/978-3-031-70626-4_4(45-59)Online publication date: 28-Aug-2024
https://dl.acm.org/doi/10.1007/978-3-031-70626-4_4
Show More Cited By

Recommendations

Converting relational to object-oriented databases

As object-oriented model becomes the trend of database technology, there is a need to convert relational to object-oriented database system to improve productivity and flexibility. The changeover includes schema translation, data conversion and program ...
Querying relational databases through XSLT

XML has been accepted as a universal format for data interchange and publication. It can be applied in the applications in which the data of a database needs to be viewed in XML format so that the data being viewed takes more semantics and is easily ...
Converting Relational Database into XML Document
DEXA '01: Proceedings of the 12th International Workshop on Database and Expert Systems Applications

Abstract: XML (eXtensible Markup Language) has emerged and is gradually accepted as the standard for data interchange in the Internet world. XML databases are packaged by the key Relational Database Vendors in the market as the extender or cartridge to ...

Comments

Information & Contributors

Information

Published In

GRADES '13: First International Workshop on Graph Data Management Experiences and Systems

June 2013

101 pages

ISBN:9781450321884

DOI:10.1145/2484425

Conference Chairs:
Peter Boncz
CWI
,
Thomas Neumann
TU Munich

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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 23 June 2013

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Research-article

Conference

SIGMOD/PODS'13

Sponsor:

SIGMOD

SIGMOD/PODS'13: International Conference on Management of Data

June 23, 2013

New York, New York

Acceptance Rates

Overall Acceptance Rate 29 of 61 submissions, 48%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

42
Total Citations
View Citations
984
Total Downloads

Downloads (Last 12 months)81
Downloads (Last 6 weeks)3

Reflects downloads up to 25 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Ehlers JMonga MLonati VBarendsen ESheard JPaterson J(2024)Teaching Multiple Data Models and Query LanguagesProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653628(234-240)Online publication date: 3-Jul-2024
https://dl.acm.org/doi/10.1145/3649217.3653628
Farouzi AZhou XBellatreche LMalki MOrdonez C(2024)Balanced parallel triangle enumeration with an adaptive algorithmDistributed and Parallel Databases10.1007/s10619-023-07437-x42:1(103-141)Online publication date: 1-Mar-2024
https://dl.acm.org/doi/10.1007/s10619-023-07437-x
Manouvrier MBelhajjame K(2024)PG-FD: Mapping Functional Dependencies to the Future Property Graph Schema StandardAdvances in Databases and Information Systems10.1007/978-3-031-70626-4_4(45-59)Online publication date: 28-Aug-2024
https://dl.acm.org/doi/10.1007/978-3-031-70626-4_4
Palagashvili AStupnikov S(2023)Reversible Mapping of Relational and Graph DatabasesPattern Recognition and Image Analysis10.1134/S105466182302009833:2(113-121)Online publication date: 3-Jul-2023
https://doi.org/10.1134/S1054661823020098
Sunuwar DSingh M(2023)Comparative Analysis of Relational and Graph Databases for Data Provenance: Performance, Queries, and Security Considerations2023 World Conference on Communication & Computing (WCONF)10.1109/WCONF58270.2023.10235151(1-7)Online publication date: 14-Jul-2023
https://doi.org/10.1109/WCONF58270.2023.10235151
Queiroz JFalcão TFurtado PSoares FSouza TCleis PSantos FGiuntini F(2022)AMANDA: A Middleware for Automatic Migration between Different Database ParadigmsApplied Sciences10.3390/app1212610612:12(6106)Online publication date: 16-Jun-2022
https://doi.org/10.3390/app12126106
Schäfer JTang MLuu DBergmann AWiese L(2022)Graph4Med: a web application and a graph database for visualizing and analyzing medical databasesBMC Bioinformatics10.1186/s12859-022-05092-023:1Online publication date: 12-Dec-2022
https://doi.org/10.1186/s12859-022-05092-0
Feng HHuang M(2022)An Approach to Converting Relational Database to Graph Database: from MySQL to Neo4j2022 IEEE 2nd International Conference on Power, Electronics and Computer Applications (ICPECA)10.1109/ICPECA53709.2022.9719151(674-680)Online publication date: 21-Jan-2022
https://doi.org/10.1109/ICPECA53709.2022.9719151
Ha MShichkina Y(2022)Translating a Distributed Relational Database to a Document DatabaseData Science and Engineering10.1007/s41019-022-00181-97:2(136-155)Online publication date: 3-Mar-2022
https://doi.org/10.1007/s41019-022-00181-9
Boudaoud AMahfoud HChikh A(2022)Towards a Complete Direct Mapping from Relational Databases to Property GraphsModel and Data Engineering10.1007/978-3-031-21595-7_16(222-235)Online publication date: 19-Nov-2022
https://doi.org/10.1007/978-3-031-21595-7_16
Show More Cited By

View Options

Login options

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

Cited By

Recommendations

Converting relational to object-oriented databases

Querying relational databases through XSLT

Converting Relational Database into XML Document

Comments

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Conference

Acceptance Rates

Other Metrics

Article Metrics

Other Metrics

Cited By

Login options

Full Access

PDF

eReader

Abstract

References

Cited By

Recommendations

Converting relational to object-oriented databases

Querying relational databases through XSLT

Converting Relational Database into XML Document

Comments

Information

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations