I need to store a large amount of information about the relationships between objects. For example объект1 -> объект65
One object can have many relationships with other objects (in other words we have a directed graph).
I want to store this in a table with keys obj1 / obj2
So something like
объект1 -> объект65
объект1 -> объект100
objet2 -> объект65
объект1 -> objet2
объект5 -> объект13
Will look at the first column is not unique, and duplicate
is There a DBMS (mysql or PostgreSQL) tools more advanced than simple exercise key and is there any command PRELIMINARY sorting of the values in the table by the first column for faster searching for her in the process??PS:
May You suggest other ways of graph storage and RDF triples in database. While the relationship between the objects only of the type "see also" and "includes", but in the future it is possible expansion to full-fledged RDF.