The presentation below by Lorenzo Alberton is one of the best references I've seen on how to model a tree in a relational database:
It is perfectly known that relational databases are not the best repository for tree-like (or even graph-like) data structures, but there are many times that you have no other chance, so it's good to know your options.
No comments:
Post a Comment