Re: A new approach to storing ordered hierarchical data in RDBs.
From: paul c <toledobythesea_at_oohay.ac>
Date: Wed, 22 Nov 2006 00:41:33 GMT
Message-ID: <11N8h.350355$R63.3390_at_pd7urf1no>
>> Lennart wrote:
>>
>>> Aloha Kakuikanu wrote:
>>> [...]
>>>
>>>> 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".
>>>
>>>
>>>
>>>
>>> I especially liked the phrase "Don't worry about the loop" :-)
>>>
>>> /Lennart
>>>
>>
>> I especially laughed at the phrase "XML handles hierarchical ... quite
>> well". How the dickens does XML per se calculate transitive closure
>> or depth from an adjency list or an adjaceny list from a tree? It
>> seems to me that XML by itself only allows adhoc solutions that are
>> just as non-declarative as various SQL versions. For that matter,
>> the original relational model seems to requires similar adhoc
>> additions. I don't have a solution, but it seems to me that all three
>> are lacking and it is irresponsible, ignorant and cavalier to use the
>> adverb "well" regarding accomplishing closure with any of them.
>>
>> p
Date: Wed, 22 Nov 2006 00:41:33 GMT
Message-ID: <11N8h.350355$R63.3390_at_pd7urf1no>
paul c wrote:
> paul c wrote: >
>> Lennart wrote:
>>
>>> Aloha Kakuikanu wrote:
>>> [...]
>>>
>>>> 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".
>>>
>>>
>>>
>>>
>>> I especially liked the phrase "Don't worry about the loop" :-)
>>>
>>> /Lennart
>>>
>>
>> I especially laughed at the phrase "XML handles hierarchical ... quite
>> well". How the dickens does XML per se calculate transitive closure
>> or depth from an adjency list or an adjaceny list from a tree? It
>> seems to me that XML by itself only allows adhoc solutions that are
>> just as non-declarative as various SQL versions. For that matter,
>> the original relational model seems to requires similar adhoc
>> additions. I don't have a solution, but it seems to me that all three
>> are lacking and it is irresponsible, ignorant and cavalier to use the
>> adverb "well" regarding accomplishing closure with any of them.
>>
>> p
> > > sorry about the spelling, mine is going down-hill as fast as my opinions > are ossifying, i guess it should be adjacency but sooner or later some > marketing type will spell it 'agency list'. > > p
... and yet another wild-goose chase will ensue.
p Received on Wed Nov 22 2006 - 01:41:33 CET