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: Objects and Relations

Re: Objects and Relations

From: Cimode <cimode_at_hotmail.com>
Date: 14 Feb 2007 07:31:27 -0800
Message-ID: <1171467087.791595.186780@j27g2000cwj.googlegroups.com>


On Feb 14, 4:14 pm, "Roy Hann" <specia..._at_processed.almost.meat> wrote:
> "Bob Badour" <bbad..._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.
>
> I struggle with that. If, for some reason, I choose to say (just) that, "I
> have a tin of cat food, and its name shall be 1345235", what have I
> communicated? No one in the real world could ever point it out and say,
> "Hey! There goes 1345235." And nor could I.
In Practical Issues, Fabian Pascal stated that there is no such thing as a natural primary key. And even *a tin of catfood* was at some point in time a subjective choice to identify the object that is the *tin of catfood*. Instead of describing the object according to a unique combination of attributes, collective intelligence selected a term for that which constituted a surrogate key. Later on the name of the object is so familiar that people make it a natural key.

By extension, we could state that a any natural key was at some point in time a surrogate key. We could perceive a natural key as a succesfull surrogate key...

Synonyms are the proof that designation of things are a part of a selection process that may be faulty sometimes.

[Snipped]
> Roy
Received on Wed Feb 14 2007 - 09:31:27 CST

Original text of this message

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