Re: Hierachical structures - an overview

>> I have an app I need a hierachical structure for. There seem to be
3 ways of implementing this, as far as I can see: <<

I have a whole book on "Trees & Hierarchy in SQL" in production now, which is due out in April 2004. There are several variations on these three basic methods.

For example, Vadim T. has a modified Nested Sets model, the "Nested Intervals" that uses (a,b) pairs of integers to represent rational numbers so that you can do frequent insertions.

I am obligated to defend the nested sets model, since I made it popular in SQL FOR SMARTIES. Received on Sun Jan 04 2004 - 12:54:38 CST