Open Access   Article Go Back

Web based ETL Approach to Transform Relational Database to Graph Database

Sonali D. Chaure1 , M. U. Kulkarni2 , Pankaj M. Jadhav3

Section:Research Paper, Product Type: Journal Paper
Volume-3 , Issue-7 , Page no. 92-97, Jul-2015

Online published on Jul 30, 2015

Copyright © Sonali D. Chaure, M. U. Kulkarni , Pankaj M. Jadhav . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: Sonali D. Chaure, M. U. Kulkarni , Pankaj M. Jadhav, “Web based ETL Approach to Transform Relational Database to Graph Database,” International Journal of Computer Sciences and Engineering, Vol.3, Issue.7, pp.92-97, 2015.

MLA Style Citation: Sonali D. Chaure, M. U. Kulkarni , Pankaj M. Jadhav "Web based ETL Approach to Transform Relational Database to Graph Database." International Journal of Computer Sciences and Engineering 3.7 (2015): 92-97.

APA Style Citation: Sonali D. Chaure, M. U. Kulkarni , Pankaj M. Jadhav, (2015). Web based ETL Approach to Transform Relational Database to Graph Database. International Journal of Computer Sciences and Engineering, 3(7), 92-97.

BibTex Style Citation:
@article{Chaure_2015,
author = {Sonali D. Chaure, M. U. Kulkarni , Pankaj M. Jadhav},
title = {Web based ETL Approach to Transform Relational Database to Graph Database},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {7 2015},
volume = {3},
Issue = {7},
month = {7},
year = {2015},
issn = {2347-2693},
pages = {92-97},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=581},
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=581
TI - Web based ETL Approach to Transform Relational Database to Graph Database
T2 - International Journal of Computer Sciences and Engineering
AU - Sonali D. Chaure, M. U. Kulkarni , Pankaj M. Jadhav
PY - 2015
DA - 2015/07/30
PB - IJCSE, Indore, INDIA
SP - 92-97
IS - 7
VL - 3
SN - 2347-2693
ER -

VIEWS PDF XML
2636 2345 downloads 2348 downloads
  
  
           

Abstract

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.

Key-Words / Index Term

GDBMS, NoSQL, TRDB

References

[1] Kimball R, Caserta J, “The data warehouse ETL toolkit: practical techniques for extracting, cleaning, conforming, and delivering data”, Wiley.
[2] E.F. Codd,“A Relational Model of Data for Large Shared Data Banks, Communications of the ACM.
[3] Relational-databases-sandbox-handout (doc.gold.ac.uk).
[4] K. Kaur and R. Rani, “Modeling and Querying Data in NoSQL Databases”,IEEE International Conference on Big Data, pp. 7, 6-9, Oct. 2013.
[5] C. Strauch, “NoSQL Databases”, ACM.
[6] https://en.wikipedia.org/wiki/NoSQL.
[7] http://highscalability.com/neo4j-graph-database-kicks-Buttox.
[8] Neotechnology. (http://www.neotechnology.com/ebay-walmart-adopt-neo4j-graph-transforming retail/)

[9] Rob McColl, David Ediger, “A Brief Study of Open Source Graph Databases”.
[10] A Brief Study of Open Source Graph Databases.
[11] Mohammed Shafeeq Ahmed, “Data Warehousing Applications: An Analytical Tool for Decision Support System”, International Journal of Computer Science and Informatics.
[12] Relational-databases-sandbox-handout.
[13] https://en.wikipedia.org/wiki/NoSQL.
[14] Database (http://neo4j.com/developer/graph-database).
[15] 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).
[16] Roberto De Virgilio, Antonio Maccioni Riccardo Torlone, “Converting Relational to Graph Databases”, 2013 ACM.