Create Graph from Exported Json and XML #20

Open
nrkkalyan opened this Issue Jan 10, 2012 · 12 comments

Projects

None yet

2 participants

@nrkkalyan
Contributor

From the cypher editor one can export the results to json or xml.
It would be good if the reverse is also possible.
I mean to convert the exported json or xml files back to a graph db.

Need to find how to select all nodes using cypher. (Select * from Table) (SQL Equivalent).
If the json or xml contains all nodes then create the entire graph.
If json or xml is incomplete then create graph with the available data and node information (Need to see if it provide a proper results).

@peterneubauer
Contributor

I would suggest looking at GEOFF to import the graph, maybe even as an
export format? There is a JSON and plain test format, see the neo4j-Geoff
component tests at http://github.com/neo4j in the Geoff component. This
format even handles index lookups, so it is more powerful than GraphML.

WDYT?

On Tuesday, January 10, 2012, Radhakrishna Kalyan <
reply@reply.github.com>
wrote:

From the cypher editor one can export the results to json or xml.
It would be good if the reverse is also possible.
I mean to convert the exported json or xml files back to a graph db.

Need to find how to select all nodes using cypher. (Select * from Table)
(SQL Equivalent).
If the json or xml contains all nodes then create the entire graph.
If json or xml is incomplete then create graph with the available data
and node information (Need to see if it provide a proper results).


Reply to this email directly or view it on GitHub:
#20

Cheers,

/peter neubauer

Google: neubauer.peter
Skype: peter.neubauer
Phone: +46 704 106975
LinkedIn: http://www.linkedin.com/in/neubauer
Twitter: @peterneubauer
Tungle: tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

@nrkkalyan
Contributor

One more sub requirement:

After done with GEOFF to import the graph, focus on creating a bridge between RDBMS and Graph DB so that one can export data from a mysql/sqllite (for a start) database to GraphDb.
Take a look at batch insertion an issue raised in the neo4j group.

@peterneubauer
Contributor

That sounds great!

When doing that, I think it would be most valuable if that component is
standalone, so it can be used even outside Neoclipse. I think there is more
interst in this, so making this good would be fantastic.

/Peter

On Friday, January 13, 2012, Radhakrishna Kalyan <
reply@reply.github.com>
wrote:

One more sub requirement:

After done with GEOFF to import the graph, focus on creating a bridge
between RDBMS and Graph DB so that one can export data from a mysql/sqllite
(for a start) database to GraphDb.
Take a look at batch insertion an issue raised in the neo4j group.


Reply to this email directly or view it on GitHub:
#20 (comment)

Cheers,

/peter neubauer

Google: neubauer.peter
Skype: peter.neubauer
Phone: +46 704 106975
LinkedIn: http://www.linkedin.com/in/neubauer
Twitter: @peterneubauer
Tungle: tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

@nrkkalyan
Contributor

Sure, I will do this as its own standalone plugin.

On Fri, Jan 13, 2012 at 5:10 PM, Peter Neubauer <
reply@reply.github.com

wrote:

That sounds great!

When doing that, I think it would be most valuable if that component is
standalone, so it can be used even outside Neoclipse. I think there is more
interst in this, so making this good would be fantastic.

/Peter

On Friday, January 13, 2012, Radhakrishna Kalyan <
reply@reply.github.com>
wrote:

One more sub requirement:

After done with GEOFF to import the graph, focus on creating a bridge
between RDBMS and Graph DB so that one can export data from a mysql/sqllite
(for a start) database to GraphDb.
Take a look at batch insertion an issue raised in the neo4j group.


Reply to this email directly or view it on GitHub:
#20 (comment)

Cheers,

/peter neubauer

Google: neubauer.peter
Skype: peter.neubauer
Phone: +46 704 106975
LinkedIn: http://www.linkedin.com/in/neubauer
Twitter: @peterneubauer
Tungle: tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan

@peterneubauer
Contributor

Yes,
or as a standalone JAR without RCP dependencies, let's see how it works out.

On Fri, Jan 13, 2012 at 10:30 PM, Radhakrishna Kalyan
reply@reply.github.com
wrote:

Sure, I will do this as its own standalone plugin.

On Fri, Jan 13, 2012 at 5:10 PM, Peter Neubauer <
reply@reply.github.com

wrote:

That sounds great!

When doing that, I think it would be most valuable if that component is
standalone, so it can be used even outside Neoclipse. I think there is more
interst in this, so making this good would be fantastic.

/Peter

On Friday, January 13, 2012, Radhakrishna Kalyan <
reply@reply.github.com>
wrote:

One more sub requirement:

After done with GEOFF to import the graph, focus on creating a bridge
between RDBMS and Graph DB so that one can export data from a mysql/sqllite
(for a start) database to GraphDb.
Take a look at batch insertion an issue raised in the neo4j group.


Reply to this email directly or view it on GitHub:
#20 (comment)

Cheers,

/peter neubauer

Google:    neubauer.peter
Skype:     peter.neubauer
Phone:     +46 704 106975
LinkedIn:  http://www.linkedin.com/in/neubauer
Twitter:    @peterneubauer
Tungle:    tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub:
#20 (comment)

@nrkkalyan
Contributor

Ok I will create a stand alone jar file with few command line inputs from
the user, and once that works perfect then will focus on RCP may be
extending existing sqlexplorer plugin.

Kalyan

On Fri, Jan 13, 2012 at 10:36 PM, Peter Neubauer <
reply@reply.github.com

wrote:

Yes,
or as a standalone JAR without RCP dependencies, let's see how it works
out.

On Fri, Jan 13, 2012 at 10:30 PM, Radhakrishna Kalyan
reply@reply.github.com
wrote:

Sure, I will do this as its own standalone plugin.

On Fri, Jan 13, 2012 at 5:10 PM, Peter Neubauer <
reply@reply.github.com

wrote:

That sounds great!

When doing that, I think it would be most valuable if that component is
standalone, so it can be used even outside Neoclipse. I think there is
more
interst in this, so making this good would be fantastic.

/Peter

On Friday, January 13, 2012, Radhakrishna Kalyan <
reply@reply.github.com>
wrote:

One more sub requirement:

After done with GEOFF to import the graph, focus on creating a bridge
between RDBMS and Graph DB so that one can export data from a
mysql/sqllite
(for a start) database to GraphDb.
Take a look at batch insertion an issue raised in the neo4j group.


Reply to this email directly or view it on GitHub:
#20 (comment)

Cheers,

/peter neubauer

Google: neubauer.peter
Skype: peter.neubauer
Phone: +46 704 106975
LinkedIn: http://www.linkedin.com/in/neubauer
Twitter: @peterneubauer
Tungle: tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub:
#20 (comment)


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan

@peterneubauer
Contributor

Very cool!

You should consider coming to Malmö one of the next Fridays for labday!

On Mon, Jan 16, 2012 at 12:32 AM, Radhakrishna Kalyan
reply@reply.github.com
wrote:

Ok I will create a stand alone jar file with few command line inputs from
the user, and once that works perfect then will focus on RCP may be
extending existing sqlexplorer plugin.

Kalyan

On Fri, Jan 13, 2012 at 10:36 PM, Peter Neubauer <
reply@reply.github.com

wrote:

Yes,
or as a standalone JAR without RCP dependencies, let's see how it works
out.

On Fri, Jan 13, 2012 at 10:30 PM, Radhakrishna Kalyan
reply@reply.github.com
wrote:

Sure, I will do this as its own standalone plugin.

On Fri, Jan 13, 2012 at 5:10 PM, Peter Neubauer <
reply@reply.github.com

wrote:

That sounds great!

When doing that, I think it would be most valuable if that component is
standalone, so it can be used even outside Neoclipse. I think there is
more
interst in this, so making this good would be fantastic.

/Peter

On Friday, January 13, 2012, Radhakrishna Kalyan <
reply@reply.github.com>
wrote:

One more sub requirement:

After done with GEOFF to import the graph, focus on creating a bridge
between RDBMS and Graph DB so that one can export data from a
mysql/sqllite
(for a start) database to GraphDb.
Take a look at batch insertion an issue raised in the neo4j group.


Reply to this email directly or view it on GitHub:
#20 (comment)

Cheers,

/peter neubauer

Google:    neubauer.peter
Skype:     peter.neubauer
Phone:     +46 704 106975
LinkedIn:  http://www.linkedin.com/in/neubauer
Twitter:    @peterneubauer
Tungle:    tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub:
#20 (comment)


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub:
#20 (comment)

@nrkkalyan
Contributor

Hi Peter,

I did some research on geoff and finally understood that one can use geoff only to Create/Update/Delete nodes ,relations ... in the GraphDb, but it is not possible to query.

And since I am thinking to export data from a RDBMS to GraphDb I dont need to query the feature.
All I need is read the data and create proper nodes with the data and relations between nodes.

Please correct me and if possible send me any example.

@peterneubauer
Contributor

Yes,
Sorry wouldn't geoff be a good export and import format?

/peter

Sent from my phone, please excuse typos and autocorrection.
On Jan 19, 2012 1:29 AM, "Radhakrishna Kalyan" <
reply@reply.github.com>
wrote:

Hi Peter,

I did some research on geoff and finally understood that one can use geoff
only to Create/Update/Delete nodes ,relations ... in the GraphDb, but it is
not possible to query.

And since I am thinking to export data from a RDBMS to GraphDb I dont need
to query the feature.
All I need is read the data and create proper nodes with the data and
relations between nodes.

Please correct me and if possible send me any example.


Reply to this email directly or view it on GitHub:
#20 (comment)

@nrkkalyan
Contributor

All I observed that importing data from RDBMS and exporting to neo4j could be done, need to do further analysis.
I don't know if exporting data from Neo4j to a plain text is possible

All I am analyzing how to manage the integrity constraints in RDBMS. Same time I am thinking to generate Dao objects and entity classes from RDBMS , I don't know which approach I will take.

I am working on this now. Please give me if you have any inputs at any point of time.

@peterneubauer
Contributor

Radhakrishna,
I think @rickardoberg has been doing some thinking around JDBC and
RDBMS goodness too, and maybe we could have a community discussion
about it ...

/peter

On Thu, Jan 19, 2012 at 7:49 PM, Radhakrishna Kalyan
reply@reply.github.com
wrote:

All I observed that importing data from RDBMS and exporting to neo4j could be done, need to do further analysis.
I don't know if exporting data from Neo4j to a plain text is possible

All I am analyzing how to manage the integrity constraints in RDBMS. Same time I am thinking to generate Dao objects and entity classes from RDBMS , I don't know which approach I will take.

I am working on this now. Please give me if you have any inputs at any point of time.


Reply to this email directly or view it on GitHub:
#20 (comment)

@nrkkalyan
Contributor

Ya true, I saw some code there. Thankyou I will surely look into jdbc
project.

Kalyan

On Thu, Jan 19, 2012 at 10:47 PM, Peter Neubauer <
reply@reply.github.com

wrote:

Radhakrishna,
I think @rickardoberg has been doing some thinking around JDBC and
RDBMS goodness too, and maybe we could have a community discussion
about it ...

/peter

On Thu, Jan 19, 2012 at 7:49 PM, Radhakrishna Kalyan
reply@reply.github.com
wrote:

All I observed that importing data from RDBMS and exporting to neo4j
could be done, need to do further analysis.
I don't know if exporting data from Neo4j to a plain text is possible

All I am analyzing how to manage the integrity constraints in RDBMS.
Same time I am thinking to generate Dao objects and entity classes from
RDBMS , I don't know which approach I will take.

I am working on this now. Please give me if you have any inputs at any
point of time.


Reply to this email directly or view it on GitHub:
#20 (comment)


Reply to this email directly or view it on GitHub:
#20 (comment)

Thanks and Regards
N Radhakrishna Kalyan

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment