Re: Modelling hierarchy in the relational database
Date: Tue, 04 Sep 2001 06:51:16 GMT
Message-ID: <ER_k7.2904$4z.4167_at_www.newsranger.com>
In article <4aUf7.7166$2u.55372_at_www.newsranger.com>, Mikito Harakiri says...
>
>Paul Brown wrote:
>PB> I used Joe's scheme and the one you describe here for years. In
>PB> fact, my first effort at this used the tree scheme from the Celko
>PB> book (which is kind of cool). But this scheme
>
>
>('1.0')
>/ | \
>/ | \
>/ | \
>/ | \
>('1.1') ('1.2') ('1.3')
>/ \ / \ |
>/ | / \ |
>('1.1.1') ('1.1.2') ('1.2.1')('1.2.2')('1.3.1')
>
>PB>works better for most things.
>
>Such as? Insertion speed is the only one obvious to me.
In "Materialised paths" approach the solution is trivial: we just substitute node indexes with names so that 1.2.3, for example, becomes /KING/BLAKE/MARTIN. Received on Tue Sep 04 2001 - 08:51:16 CEST