Re: dbdebunk 'Quote of Week' comment

From: Frank_Hamersley <>
Date: Fri, 19 Aug 2005 13:33:33 GMT
Message-ID: <NclNe.4651$>

"-CELKO-" <> wrote
> The fact that this question is being considered is a sign that we have
> a lot of really bad SQL programmers. By definition a relational key is
> a subset of attributes of an entity or relationship being modeled in
> the schema. This is absolute foundations of the Relational Model kind
> of stuff.
[..] (or I would have top posted).

I understand all the points and concerns they generate...but in my own personal toolkit of techniques I have found I can use surrogate keys and suffer none of the grief you attribute to them.

I guess I should declare 27 years of involvement with gadgets starting in the age of PDP-8/11's, Altairs, Alpha Micro, CDC Cybers (what a machine that was) might have taught me a few tricks in this regard. So all you pups searching for gems should prolly accord 80 in an 80/20 measure of Joes dissertation.

Cheers, Frank. Received on Fri Aug 19 2005 - 15:33:33 CEST

Original text of this message