Skip to content
/ rdb2graph Public

Transforms a relational database on-line to a property graph.

Notifications You must be signed in to change notification settings

s1ck/rdb2graph

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

73 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

rdb2graph - Relational Database To Property Graph Converter and Analysis Tool

rdb2graph can be used to convert a relational database on-line into a property graph model and store it in a graph database

The tool uses Apache DdlUtils to read the schema of a relational database. Based on table definitions and foreign key constraints, nodes and relationships are created. Link tables (n:m) have to be explicitly declared in a config file if they shall be converted into a single relation. Properties (table attributes) and some additional meta-data (origin, type, id) are stored at the nodes and relationships.

Currently, the tool supports MySQL as a source database system and Neo4j as a target system. The architecture is flexible and can be easily extended by implementing some predefined interfaces.

Build

  • clone rdb2graph project

git clone https://github.com/s1ck/rdb2graph

To run properly, ddl utils needed to be patched.

  • checkout ddlutils from their svn

svn co http://svn.apache.org/repos/asf/db/ddlutils/trunk ddlutils

cd ddlutils

  • apply patches

patch -p0 -i ../rdb2graph/doc/ddlutils_graphbi_patch/ddlutils_graphbi_2013-04-16.patch

patch -p0 --binary -i ../rdb2graph/doc/ddlutils_graphbi_patch/ddlutils_graphbi_2014-08-04.patch

  • build and install ddl utils

mvn clean install

  • build and install rdb2graph

cd ../rdb2graph

mvn clean install

Run

  • copy resources/sakila-sample-config.properties to resources/config.properties and look inside for details

  • list available options

mvn exec:exec -Dexec.executable="java"

  • apply your own config xml (default is resources/config.xml)

mvn exec:exec -Dexec.executable="java" -Dexec.args="-c config.xml"

  • extract the database schema into ddl.xml

mvn exec:exec -Dexec.executable="java" -Dexec.args="-e ddl.xml"

  • transform the relational database form source system to target system

mvn exec:exec -Dexec.executable="java" -Dexec.args="-t"

  • read the schema from a local file instead of the live database

mvn exec:exec -Dexec.executable="java" -Dexec.args="-r erpnext-sample-ddl.xml -t"

  • read the schema from a local file and analyze the graph for operation graphs

mvn exec:exec -Dexec.executable="java" -Dexec.args="-r erpnext-sample-ddl.xml -a opgraph"

About

Transforms a relational database on-line to a property graph.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages