How should I generate a primary key?

#81

"Gene Wirchenko" <genew (AT) ocis (DOT) net> wrote

Quote:

"Tony Rogerson" <tonyrogerson (AT) sqlserverfaq (DOT) com> wrote:

It seems to me that you are overstressing an obvious point: Every
*word* in every language is a surrogate for *the real thing*: bread,
brot, pain, pane, pan, panis ...

Its the point celko keeps avoiding and until he actually acknowledges it
I
won't shut up.

You keep doing the same thing and expect a different result? Some
people use that as a definition for insanity.

Instead of trying to bludgeon him on the point, why not just give
up on the idea that he is going to change his mind? After all, you
probably are not going to change your mind either.

He thinks the logical and physical models are the same and you don't need
to
add surrogates when moving frmo the logical to the physical.

I do not believe that. I think Mr. Celko believes that with
intelligent key choice, it may be possible to avoid using surrogates
in many cases.

Actually, if we take the word "surrogate" in its strictest sense, it's
always possible to avoid the use of surrogates.
The question is whether it's always advisable.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How should I generate a primary key?

comp.databases comp.databases

Re: How should I generate a primary key? - 11-30-2006 , 03:20 PM