working with relational databases as a graph database

[Ahmed Osama]

Hi,

A newbie question :)

is it possible to work with an existing relational database as a graph DB. that is to put a modeling layer on top of it so we can define existing tables as entities or links then we can query usual business data like customers and invoices as entities and links,

thanks

[Daniel Kuppitz]

Hi Ahmed,

graph databases have their own storage format. But often it's quite easy to convert existing data sources into a graph database. See the blog posts Powers of Ten - Part I and Part II to get some inspiration.

Cheers,

Daniel

--
You received this message because you are subscribed to the Google Groups "Gremlin-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gremlin-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stephen Mallette]

Also worth looking at: 

http://sql2gremlin.com/

to see how the classic Northwind model looks as a graph.

Stephen

[Ahmed Osama]

Thanks Daniel,

What if the data is so huge and is currently in HBase tables and the investment to move it to a graph DB is not possible, is there any mapping layer or some way to have gremlin talk to it where it is.

[Stephen Mallette]

Ahmed, there is no such mapping layer other than to say that Blueprints is that layer.  Gremlin only talks over Blueprints interfaces.  So you would need to physically transform your data into a graph model that uses Blueprints for Gremlin to work with it.  I doubt that trying to write a Blueprints implementation over your relational model would work too well.

Stephen