Hello, We love the concept of OrientDB, however have been struggling with uploading our graph data (with a massiveinsert operation).
*Background* We would like to migrate OrientDB away from an RDBMS. In RDBMS, we had 3 tables: Person, School, and Education. We successfully imported data from these three tables into OrientDB, however are struggling with linking them together by with creating (Person <-- [Education] --> School) edges in OrientDB. Here are details of the original RDBMS tables: *Person:* Fields: Id (int), Name (string) Record Count: 28M *School:* Fields: Id (int), Name (string) Record Count: 7M *Education:* Fields: Id (int), PersonId_FK, SchoolId_FK Record Count: 35M *OrientDB release?* orientdb-community-1.7-rc2-SNAPSHOT *What steps will reproduce the problem?* 1. We followed the tutorial https://github.com/orientechnologies/orientdb/wiki/Import-From-RDBMS connect remote:localhost/db admin admin DECLARE INTENT massiveinsert DROP CLASS Person CREATE CLASS Person DROP CLASS School CREATE CLASS School DROP CLASS Education CREATE CLASS Education INSERT INTO Person(Id, Name) VALUES (1, 'John Doe') .. INSERT INTO School(Id, Name) VALUES (1, 'State University') .. INSERT INTO Education(Id, PersonId, SchoolId) VALUES (1, 1, 1) ... *>>Successfully imported all Person, School, and Education records in respective OrientDB classes!* 2. After successfully loading the raw data in OrientDB Classes, we are unable to create Edge links in bulk. CREATE LINK schools TYPE linkset FROM Education.PersonId To Person.id INVERSE *>> Created 0 link(s) in 342.528992 sec(s).* CREATE LINK students TYPE linkset FROM Education.SchoolId To School.id INVERSE *>> Created 0 link(s) in 348.332344 sec(s).* NOTE: We are expecting to build the graph from our data, so that we can use .in() and .out() calls on edges and vertices. We have doubts that CREATE LINK operation builds proper graph linkages, because based on the documentation that we read CREATE LINK does not create a bidirectional Edge link. *If you're using custom settings please provide them below* We are not using any custom settings for the OrientDB server or JVM *What is the expected output? What do you see instead?* Our expected output is a proper graph compiled from our data, stored in OrientDB. Instead, we are unable to create 2-way Education edges between Person and School vertices. Just to reiterate, all three classes are successfully populated, but we are unable to establish edge links. *Additional notes:* After import, the current DB size is 20GB Indexes have not been created Currently, we are attempting this operation on a Mac with the following specs 1.7 GHz Intel Core i7 8GB 1600 MHz DDR3 RAM 500GB SSD HD Please help, Sandro -- --- 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/groups/opt_out.
