Monday, January 25, 2010

Trees in Relational Databases

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.