Hi all. I'm trying to import a csv file with information about financial
transactions to a graph database. The csv file has the following structure:
TransactionID Date Value Currency Office ProdType
TransactionType AccountID AccountHolderIDType AccountHolderID
PlaceCode AccountHolderName CounterpartIDType CounterpartID
CounterpartName
194 29/12/1984 37081 100 235 10
8 4556353 161 99347644358
374040 Nombre7229 136 75994470492 Nombre2853
195 20/12/1984 38751 100 280 10
5 2243499 161 99347647398
374040 Nombre7231 136 66241286961 Nombre265
196 28/12/1984 40000 100 239 10
5 3065782 161
99347647889 374040 Nombre7232 136
79079592681 Nombre4491
197 23/12/1984 40212 100 239 311
8 1394271 161 99347647889
374040 Nombre7232 136 79052675438 Nombre4437
In this data, a counterpart (which is a person) does a transaction that
affects a financial product, which in turn is owned by an account holder
(which is a person). So, I want to have classes *person*, *transaction *and
*account*, as vertices, and classes *makes*, *affects* and *ownes*, as
edges. Taking the first line of the data:
(Counterpart with id: 75994470492) -[makes]-> (transaction with id: 194)
-[affects]-> (account with id: 4556353) <-[ownes]- (AccountHolder with id:
99347644358)
Also, person class has properties id, id type, name; transaction class has
properties id, date, value, currency, office and place code; account class
has properties id and type.
I'll like to import directly this information to a graph database, using
the ETL tool, without having to break it between tables for each of the
classes. I've been Reading the documentation but the examples I found seem
to be too simplistic, and also asume information is separated in tables by
class.
Can anyonw help me with this? Any help will be greatly appreciated.
Best regards,
Nicolás
--
---
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.
