Luca, I love OrientDB and would like to help more people use it as well. I think a killer app for Orient would be a small utility that could migrate a traditional RDMS solution into OrientDB. For example, addressing the problem in this thread to take a table and to store the records into an OrientDB class. The current approaches are not user-friendly. Even if such a utility could only migrate a single table at a time, it would be a huge help.
I am trying to recommend OrientDB to a Fortune 500 company for use. However, they have tons of data in Oracle. Data migration is the biggest challenge with any consideration of adoption. Even if the data wasn't structured well for graph, just getting it into OrientDB in any form would be a huge win. Thanks, Ronnie On Wednesday, August 28, 2013 7:53:20 AM UTC-4, Josep Martínez Vilà wrote: > > Hello, > > I'm want to test OrientDB and to do it I want to populate OrientDB > database with data from Oracle, where some tables has > 200 milion rows. > I've read the documentation and some posts and I'm not sure how I should > do a batch/bulk insert. > > There is a post about Batch insert using the console > <https://groups.google.com/forum/embed/?place=forum/orient-database&showsearch=true&showpopout=true&showtabs=false&hideforumtitle=true&theme=compact#!searchin/orient-database/bulk$20insert/orient-database/ccBx4tSyyuU/n-QGIkkEUdwJ>and > > a wiki > <https://github.com/orientechnologies/orientdb/wiki/Import-From-RDBMS>explaining > > how to do it. I like this method because I can export the tables I need > using TOAD, import them with console and then do the link (CREATE LINK...). > But I found that TOAD do the INSERTs in multiple line and this is not > allowed as I've seen a read it here > <https://groups.google.com/forum/embed/?place=forum/orient-database&showsearch=true&showpopout=true&showtabs=false&hideforumtitle=true&theme=compact#!searchin/orient-database/console/orient-database/MFTYGFR8fqU/6_nhlHksiZIJ>, > > at the moment. I also get an error executing it in Windows: > > OrientDB console v.1.5.0 (build @BUILD@) www.orientechnologies.com > Type 'help' to display all the commands supported. > > Installing extensions for GREMLIN language v.2.4.0-SNAPSHOT > Connecting to database [local:/temp/orientdb-graphed-1.5.0/data] with user > 'admin'...OK > Exception in thread "main" java.lang.StackOverflowError > at java.util.regex.Pattern$GroupHead.match(Pattern.java:4168) > at java.util.regex.Pattern$Loop.match(Pattern.java:4295) > at java.util.regex.Pattern$GroupTail.match(Pattern.java:4227) > at java.util.regex.Pattern$BmpCharProperty.match(Pattern.java:3366) > at java.util.regex.Pattern$Curly.match0(Pattern.java:3782) > at java.util.regex.Pattern$Curly.match(Pattern.java:3744) > at java.util.regex.Pattern$BmpCharProperty.match(Pattern.java:3366) > at java.util.regex.Pattern$Curly.match0(Pattern.java:3782) > at java.util.regex.Pattern$Curly.match(Pattern.java:3744) > at java.util.regex.Pattern$GroupHead.match(Pattern.java:4168) > at java.util.regex.Pattern$Loop.match(Pattern.java:4295) > at java.util.regex.Pattern$GroupTail.match(Pattern.java:4227) > at java.util.regex.Pattern$BmpCharProperty.match(Pattern.java:3366) > > > In this post > <https://groups.google.com/forum/embed/?place=forum/orient-database&showsearch=true&showpopout=true&showtabs=false&hideforumtitle=true&theme=compact#!searchin/orient-database/bulk$20insert/orient-database/wYT5lAlRXow/AMBzOBV3hC8J>, > > you talk about using Tinker Pop BatchGraph. With this, I should write a > Java app to read from Oracle and write to OrientDB, which would be more > work. > > But before starting to work on it, I would like to know what's the best > way to deal with it: massive insert with console, if you could help me to > deal with the exception, or the Java with BatchGraph? > I've seen that the project is progressing a lot and I'm not sure if posts > posted half a year ago are valid today. > > Another thing I haven't found in the documentation is the machine > specifications (CPUs, disk, memory) based on a number of > nodes/edges/properties estimated. Just to have a clue. > And also, do you have a performance benchmark comparing Windows and Linux? > > > Thank you, > > Josep > > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
