While reading the documentation, I learned that there are a way to make
some sort of light weight edges when no edge variables are required. For a
one to many relation, it is done by placing a record list on one side and a
record reference on the other side. For example, let say you have 2 tables
where 1 hold record A and B while the second table hold record 1-5.
In a relational database you would proceed this way
table 1
A
B
Table 2
1A
2A
3A
4B
5B
In other words you add the ID of the linked record. But in orient DB you
would proceed this way
Table 1
A {1,2,3}
B{4,5}
Table 2
1A
2A
3A
4B
5B
This make sure that in either direction, you have direct access to the
linked record.
Now from the documentation, they explained how to create the fields, but I
have no idea how to establish the relation between those fields. Of course
I could manage it manually but that is rather complex because links must be
recorded in both tables. Each time a new entry is added in table 2, the
record list in table 1 needs to be updated. I would have expected that
orient DB would manage such modifications.
Else how do you query using those relations. Can you use the EXPAND command
like for edges, are you restricted to use TRAVERSE, again did not found any
information about it.
--
---
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.
