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: Normalisation

Re: Normalisation

From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Sun, 03 Jul 2005 13:59:21 GMT
Message-ID: <ZaSxe.136291$Ql.7257205@phobos.telenet-ops.be>


Jon Heggland wrote:
> In article <iCCxe.135818$lx6.7272566_at_phobos.telenet-ops.be>,
> jan.hidders_at_REMOVETHIS.pandora.be says...
>

>>>Well, the "atomicity" definition doesn't hold up under scrutiny, and the 
>>>"you shouldn't have more than one column about the same thing" 
>>>definition is too informal.
>>
>>Yeah, that's what Date claims. Many disagree, including me.

>
> How do you define atomicity?

Roughly, I would say that it means that all your data manipulation can be expressed as operations over a signature that consists only of (1) domains described by an abstract data type and (2) relations that contain in their fields only values from these domains.

An unnest operation, for example, cannot be described in that way.

Received on Sun Jul 03 2005 - 08:59:21 CDT

Original text of this message

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