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: Surrogate Keys: an Implementation Issue

Re: Surrogate Keys: an Implementation Issue

From: Craig Alexander Morrison <cam_at_microsoft.newsgroups.public.com>
Date: Thu, 27 Jul 2006 13:53:02 +0100
Message-ID: <44c8b72e@212.67.96.135>


> What about compound keys? Compound keys are much more likely to change.
> What if there is more than one candidate key? If the identity changes
> when the key value changes, then what if only one candidate key value
> changes?

> The fact remains that a natural key, however unlikely, can change. If you
> build software around the assumption that it won't, you're going to get
> burned.
>

If one designs a relational database around the assumption that the PK won't change they are a moron.

-- 
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Brian Selzer" <brian_at_selzer-software.com> wrote in message 
news:tc2yg.75877$Lm5.74940_at_newssvr12.news.prodigy.com...
snipped all this 'stuff' 
Received on Thu Jul 27 2006 - 07:53:02 CDT

Original text of this message

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