Re: Looking for a discussion about generic datamodels
From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 2 Sep 2005 11:39:13 -0700
Message-ID: <1125686353.113814.59200_at_g49g2000cwa.googlegroups.com>
> This becomes the moot point with PIVOT/UNPIVOT operators. Translating
> complex queries is straightforward: take EAV "schema", unpivot it into
> the proper relational schema, query it, pivot the result back.
Date: 2 Sep 2005 11:39:13 -0700
Message-ID: <1125686353.113814.59200_at_g49g2000cwa.googlegroups.com>
Mikito Harakiri wrote:
>
> This becomes the moot point with PIVOT/UNPIVOT operators. Translating
> complex queries is straightforward: take EAV "schema", unpivot it into
> the proper relational schema, query it, pivot the result back.
Interesting. I take it this is some sort of transposition, such
that the attribute name becomes a column name and the attribute
value becomes the value of that column. How do entities work
into it? Tables?
Can you point me at any further reading about this? I'm
*very* interested.
Marshall