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

Home -> Community -> Usenet -> c.d.o.server -> Re: Surrogate Key vs Production Key

Re: Surrogate Key vs Production Key

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 21 Oct 2004 13:14:52 -0500
Message-ID: <uacug3pue.fsf@standardandpoors.com>


On 21 Oct 2004, ed.prochak_at_magicinterface.com wrote:

> wizofoz2k_at_yahoo.com.au (Noons) wrote in message

>> > Why because that is not relationship between the Surrogate
>> > key value and the data it is supposed to connect. It is
>> > often just a value
>>
>> This is where your examples and arguments are completely
>> wrong. If you do not establish a referential integrity
>> constraint between ANY two PK and FK keys (natural or not is
>> COMPLETELY immaterial), then you WILL have the potential for
>> wrong data.

So, what if the multiple sources of your data have different natural keys?

-- 
Galen Boyer
Received on Thu Oct 21 2004 - 13:14:52 CDT

Original text of this message

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