Re: Objects and Relations
From: Roy Hann <specially_at_processed.almost.meat>
Date: Wed, 14 Feb 2007 15:14:41 -0000
Message-ID: <HqedneJnhYb-uk7YnZ2dnUVZ8tqqnZ2d_at_pipex.net>
Date: Wed, 14 Feb 2007 15:14:41 -0000
Message-ID: <HqedneJnhYb-uk7YnZ2dnUVZ8tqqnZ2d_at_pipex.net>
"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
news:2aFAh.6379$R71.96054_at_ursa-nb00s0.nbnet.nb.ca...
>> And that's it. That's how we work everyday. If we ever have to do deal
>> with items that are indistinguishable by anything but physical
>> location (or any characteristic we can't keep track of), we tag them
>> with a surrogate identifier to represent their unique nature. It's
>> just common sense really.
>>
>> As an addendum, once implemented a surrogate key becomes a natural
>> key. I find this fascinating - it seems somehow analagous to "Nature
>> abhoring a vacuum".
>
> I think it has more to do with the human drive to communicate.
Roy Received on Wed Feb 14 2007 - 16:14:41 CET