Re: More pain and sufferring with Tropashko's materialized path...
Date: Tue, 11 Nov 2003 11:13:10 -0800
Message-ID: <HGasb.25$Up4.55_at_news.oracle.com>
Mikito Harakiri wrote:
> I just noticed a curious identity:
>
> SUBSTR(LPAD('', SUBSTR(PATH,1,1 NUMER DENOM
> --------------- --------------- ---------- ----------
> KING .1 3 2
> CLARK .1.3 19 16
> MILLER .1.3.1 39 32
> BLAKE .1.3.1.1 79 64
> TUR .1.3.1.1.4 1251 1024
> MAR .1.3.1.1.3 627 512
> WAR .1.3.1.1.2 315 256
> ALL .1.3.1.1.1 159 128
> JONES .1.1 7 4
> FORD .1.1.2 27 16
> SMITH .1.1.2.1 55 32
> SCOTT .1.1.1 15 8
> ADAMS .1.1.1.1 31 16
>
> Sum of the numbers in the materialized path is the power of DENOM!
And NUMER = DENOM + 2^LEVEL - 1.
Therefore, <LEVEL, LOG(2, DENOM)> is yet another encoding?
(We are back to the very first message that suggested encoding that used LEVEL:-) Received on Tue Nov 11 2003 - 20:13:10 CET