And here is a first draft of the autoimport-feature, and a pic of the resulting nodespace ... http://wiki.neo4j.org/content/Neo_-_SQL_importer#Auto-import_insert_statements_into_Neo4j
/peter GTalk: neubauer.peter Skype peter.neubauer Phone +46 704 106975 LinkedIn http://www.linkedin.com/in/neubauer Twitter http://twitter.com/peterneubauer http://www.neo4j.org - New Energy for Data - The Graph Database. http://www.ops4j.org - New Energy for OSS Communities - Open Participation Software. http://www.oredev.org - Where Good Geeks Grok. On Mon, Jun 15, 2009 at 7:45 AM, Peter Neubauer<[email protected]> wrote: > Hi Folks, > over the weekend I have been playing with an SQL Importer utility, > feel free to check it out and improve it at > https://svn.neo4j.org/laboratory/users/peter/sqlimport/. > > Basically, you give the DDL in the form of instructions for importing > tables and joining them with relationships. After that, the importer > will run your import by first sucking up all the INSERT INTO- records > into Neo, optimize the LuceneIndex for primary-key-lookup, and after > that traverse the nodes from each table and create the foreign keys as > relationships between nodes. > > Right now, there is (not) > - no support for parsing DDL automagically > - no cleanup to remove imported nodes and fields that in Neo4j are > obsolete, e.g. nodes created to hold the M2M relationship tables from > the RDBMS and the ID-fields imported > - only one layout supported with root->subref_books->book-1 style > aggregation between nodes in one table. > > The testcase is not yet going through clean, but I will do more > refactoring and documentation (like a NeoClipse pretty picture of the > resulting nodespace). > > Feel free to check it out and get back with comments, who knows - it > might end up as a component further down the road ... > /peter > > GTalk: neubauer.peter > Skype peter.neubauer > Phone +46 704 106975 > LinkedIn http://www.linkedin.com/in/neubauer > Twitter http://twitter.com/peterneubauer > > http://www.neo4j.org - New Energy for Data - The Graph Database. > http://www.ops4j.org - New Energy for OSS Communities - Open > Participation Software. > http://www.oredev.org - Where Good Geeks Grok. > Sent from Malmo, Skåne, Sweden > _______________________________________________ Neo mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
