Friday 15 August 2014

Is it possible to connect to an existing relational database (Postgresql) using Neo4j? -



Is it possible to connect to an existing relational database (Postgresql) using Neo4j? -

as explained in previous posts have postgresql relational database 10m rows. connect neo4j straight existing database if it's possible , define nodes beingness specific columns. tried different solutions: first of used batch importer csv file of database, created flexible script groovy (again using csv file). these methods work imply creation of csv file isn't ideal in case. there possibiliy connect db straight neo4j ? thanks

to link node in neo4j row in relational database typically store row's primary key property on node. other way link relational db graph node create unique identifier node, store property , create index on it. store identifier in relational database.

in case need client side logic when going on db boundaries. e.g. graph traversal, homecoming primary keys stored in node properties. run select pk in relational db.

martin fowler's nosql destilled has chapter on polyglott persistence.

in neo4j can write unmanaged extension might deed integration point.

database neo4j connect relational

No comments:

Post a Comment