Web based ETL Approach to Transform Relational Database to Graph Database
Keywords:
GDBMS, NoSQL, TRDBAbstract
Data size is growing exponentially, it is coming in more and more connected form. Graph Database Management System (GDBMS) provides efficient solution to data storage in current scenarios. Nowadays, many companies rely on cloud services where you pay as per your need basis and most of the cloud platforms supports non-relational database to avoid scalability issues. Graph Databases have applications in many domains such as social network, organization management, banking, insurance, fraud detection, etc. Therefore there is need to migrate data from relational to non-relational database. Also many companies shifting from traditional relational database to NoSQL databases to avoid scalability issues. In this paper a web based ETL approach has been suggested to convert a Relational Database to Graph Database. Experimental results have been presented to show feasibility of the proposed methodology. Also query execution comparison is done on source and target databases.
References
Kimball R, Caserta J, “The data warehouse ETL toolkit: practical techniques for extracting, cleaning, conforming, and delivering data”, Wiley.
E.F. Codd,“A Relational Model of Data for Large Shared Data Banks, Communications of the ACM.
Relational-databases-sandbox-handout (doc.gold.ac.uk).
K. Kaur and R. Rani, “Modeling and Querying Data in NoSQL Databases”,IEEE International Conference on Big Data, pp. 7, 6-9, Oct. 2013.
C. Strauch, “NoSQL Databases”, ACM.
https://en.wikipedia.org/wiki/NoSQL.
http://highscalability.com/neo4j-graph-database-kicks-Buttox.
Neotechnology. (http://www.neotechnology.com/ebay-walmart-adopt-neo4j-graph-transforming retail/)
Rob McColl, David Ediger, “A Brief Study of Open Source Graph Databases”.
A Brief Study of Open Source Graph Databases.
Mohammed Shafeeq Ahmed, “Data Warehousing Applications: An Analytical Tool for Decision Support System”, International Journal of Computer Science and Informatics.
Relational-databases-sandbox-handout.
https://en.wikipedia.org/wiki/NoSQL.
Database (http://neo4j.com/developer/graph-database).
Arora and R.R. Aggarwal, “An Algorithm for Transformation of Data from MySQL to NoSQL (MongoDB)”, International Journal of Advanced Studies in Computer Science and Engineering (IJASCSE).
Roberto De Virgilio, Antonio Maccioni Riccardo Torlone, “Converting Relational to Graph Databases”, 2013 ACM.
Downloads
Published
How to Cite
Issue
Section
License

This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.
