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@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 Received on Fri Sep 02 2005 - 13:39:13 CDT