Showing posts with label graph. Show all posts
Showing posts with label graph. Show all posts

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.