neo4j-contrib / neoclipse

Graph Database Tool
218 stars 136 forks source link

Create Graph from Exported Json and XML #20

Open nrkkalyan opened 12 years ago

nrkkalyan commented 12 years ago

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 commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/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 commented 12 years ago

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 commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3477738

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 commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3477738

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3481836

Thanks and Regards N Radhakrishna Kalyan

peterneubauer commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3477738

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3481836

Thanks and Regards N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3486600

nrkkalyan commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3477738

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3481836

Thanks and Regards N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3486600


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3486683

Thanks and Regards N Radhakrishna Kalyan

peterneubauer commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3477738

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3481836

Thanks and Regards N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3486600


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3486683

Thanks and Regards N Radhakrishna Kalyan


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3504351

nrkkalyan commented 12 years ago

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 commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3555882

nrkkalyan commented 12 years ago

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 commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3571996

nrkkalyan commented 12 years ago

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: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3571996


Reply to this email directly or view it on GitHub: https://github.com/neo4j/neoclipse/issues/20#issuecomment-3574945

Thanks and Regards N Radhakrishna Kalyan