A Novel Approach to Transform Relational Database into Graph Database using Neo4j

Abstract

Nowadays, many companies rely on cloud services to meet their data storage requirements. Cloud does not support traditional relational databases because of scalability. Therefore, data needs to be migrated from relational to cloud databases. Graph Databases are one of the cloud databases which have been invented for fast traversal of millions of nodes that are interconnected via number of relations. They are becoming popular and efficient choice for storing and querying highly interconnected data. Traversal queries in SQL which require many joins to query relational database can be easily and quickly traversed using graph databases. Graph Databases have applications in many domains such as social network, organization management, banking, insurance, fraud detection, etc. Data migration is becoming a topic of interest these days because of increase in need of various data exchange formats. In this paper an approach has been suggested to convert relational database to graph database. An example database of auto-insurance has been used for the experiment. Experimental results have been presented to show feasibility of the proposed methodology. Query translation is done from SQL to Cypher query language. Query execution efficiency comparison is done on source and target databases