I am trying to move an oracle database to orientdb. I have 3 reference tables and a mapping table that maps one of the ref tables (data_category) to 2 of the ref tables (data_type and platform) to define to what data_category a file belongs if it is from one data type and one platform. A data_catagory can be comprised of more than one combinations of data_set and platform So it goes something like this: data_category_id = 1 data_type_id = 5 platform_id = 12
data_category_id =1 data_Type_id = 17 platform_id = 3 So that if I have a file with data_type_id 17 and platform_id 3 I can do a join to find what data_catagory it belongs to. Having the mapping table allows me to change mapping on the fly (if needed) without have to change anything in the file table. I am not sure how to represent this relationship table in Orientdb. Seems an edge only relates one field to one other field. Thanks in advance for your help... -- --- 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.
