SQL2Cypher: Automated Data and Query Migration from RDBMS to GDBMS
Shunyang Li, Zhengyi Yang, Xianhang Zhang, Wenjie Zhang, Xuemin Lin
International Conference on Web Information Systems Engineering (WISE)
RAIDS Lab Authors
Details
Research Area
Tags
Resources
Abstract
There are many real-world application domains where data can be naturally modelled as a graph, such as social networks and computer networks. Relational Database Management Systems (RDBMS) find it hard to capture the relationships and inherent graph structure of data and are inappropriate for storing highly connected data; thus, graph databases have emerged to address the challenges of high data connectivity. As the performance of querying highly connected data in relational query statements is usually worse than that in the graph database. Transforming data from a relational database to a graph database is imperative for improving the performance of graph queries. In this paper, we demonstrate SQL2Cypher, a system for migrating data from a relational database to a graph database automatically. This system also supports translating SQL queries into Cypher queries. SQL2Cypher is open-source (https://github.com/UNSW-database/SQL2Cypher) to allow researchers and programmers to migrate data efficiently. Our demonstration video can be found here: https://www.youtube.com/watch?v=eGaeBrVTJws.
Author Affiliations
BibTeX
@inproceedings{li2021sql2cypher,
title = {SQL2Cypher: Automated Data and Query Migration from RDBMS to GDBMS},
author = {Li, Shunyang and Yang, Zhengyi and Zhang, Xianhang and Zhang, Wenjie and Lin, Xuemin},
editor = {Zhang, Wenjie and Zou, Lei and Maamar, Zakaria and Chen, Lu},
booktitle = {Web Information Systems Engineering -- WISE 2021},
year = {2021},
publisher = {Springer International Publishing},
address = {Cham},
pages = {510--517},
isbn = {978-3-030-91560-5}
}