Re: A new approach to storing ordered hierarchical data in RDBs.

goran wrote:
> Hello!
>
> I've discovered a new approach to storing ordered hierarchical data in
> RDBs. As far as I know there is no similar model out there and it
> differs significantly from traditional models (such as adjacency list,
> materialized path or the nested sets approach). A brief article
> describing the model (with accompanying sql code) can be found at
> http://orangebeta.blogspot.com/2006/11/on-storing-ordered-hierarchies-in-sql.html

Please make sure you use terms correctly. What you have meant by "lineage" is "transitive closure". This article http://www.sqlteam.com/item.asp?ItemID=8866 uses the term "lineage" in the sense of "materialized path". Received on Tue Nov 21 2006 - 17:57:00 CET