Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Define "flatten database" ?

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@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.

Received on Sat Feb 12 2005 - 08:07:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US