Re: matrix encoding IS adjacency list

"Vadim Tropashko" <vadimtro_invalid_at_yahoo.com> wrote in message news:1127234496.491580.228310_at_g49g2000cwa.googlegroups.com...

> At the risk being annoying, formally, materialized path is not an
> adjacency relation. For one thing, materialized path schema design
>
> table (
> path varchar(1000)
> )
>
> has only one column,

Oops! It looks like my understanding of "materialized path" was incorrect.

In that case, my comment about using materialized path in a star schema dimension table
was incorrect, as a consequence.

What I was thinking of as "materialized path" was a design where each of the levels of the hierarchy has its own column.

I wonder what the name of that design is. Received on Wed Sep 21 2005 - 14:19:51 CEST