I have never done any serious SQL design before. Anyways I have to store a hierarchical data structure, similar to a tree in a SQL database. Right now I simply add a "parent_id" column in each of the ...
A database organization method that is structured in a hierarchy. All access to data starts at the top of the hierarchy and moves downward; for example, from customer to orders, vendor to purchases, ...
Joe Celko works with trees in SQL on O'Reilly. "There are many different ways to represent trees in SQL and this short article discusses one of them." ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results