Re: Nested Sets vs. Nested Intervals

From: vc <boston103_at_hotmail.com>
Date: 9 Nov 2005 05:04:28 -0800
Message-ID: <1131541468.409287.239210_at_g44g2000cwa.googlegroups.com>


amado.alves_at_netcabo.pt wrote:
> Oops... you want to count the descendants. Sorry, browser problem. Ok,
> to count the descendants, I see you've already got good answers for SQL
> systems. Personally I would use a non SQL system, but that's another
> story.
>
> /* Namely the story of graph-based vs. relational systems. "Relational
> atabases are universally conceived of as an advance over their
> predecessors network and hierarchical models." (Vadim on dbazine.com)
> This is probably true in the historical context of Ingres vs. Codasyl
> etc. but mostly a myth. Unfortunately Codasyl's demise is (incorrectly)
> perceived as a weakness of *all* graph-based data systems. (But why are
> file systems still hierarchical today?) */

Is it another case of a "read a book or something" ? Codd's "A Relational Model of Data for Large Shared Databanks" may be a good start in order to understand why "graph-based systems" are not a good approach to managing data. Received on Wed Nov 09 2005 - 14:04:28 CET

Original text of this message