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

From: Aloha Kakuikanu <aloha.kakuikanu_at_yahoo.com>
Date: 21 Nov 2006 08:57:00 -0800
Message-ID: <1164128220.823492.151280@m7g2000cwm.googlegroups.com>

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 - 10:57:00 CST