Forum Discussion
object with multiple relations to other objects
Hi, i have a table "Object"with unique ID. They have a relation to other object with is defined in a seperate table "Relations" now i want to make insigts how the object are related to each ot...
Is your data representing a true hierarchical tree graph or a direct acyclical graph ? Can an employee have more than one manager?
Hi lbendlin
In practice, it will come down to me that it is an acyclical model.
Don't have a solution but here is an article that may interest you.
https://www.sqlservercentral.com/articles/dijkstras-algorithm