Re: Define "flatten database" ?
From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Sat, 12 Feb 2005 14:07:21 GMT
Message-ID: <t4oPd.9870$ny3.637992_at_phobos.telenet-ops.be>
Date: Sat, 12 Feb 2005 14:07:21 GMT
Message-ID: <t4oPd.9870$ny3.637992_at_phobos.telenet-ops.be>
Alan wrote:
> [...] All flattening of a
> relational database is denormalizing. Show me an example that proves
> otherwise, and I'll happily have learned something.
Assume a a binary relation with an atomic first column and a nested second column, and also assume that the first columns is a a candidate key. In that case unnesting the second column does not introduce redundancy.
- Jan Hidders