Re: Trend towards artificial keys (GUIDs) sez my AI next?

From: raylopez99 <>
Date: Sun, 16 Dec 2007 03:13:12 -0800 (PST)
Message-ID: <>

On Dec 15, 2:30 pm, Hugo Kornelis
<> wrote:

> If this is the book I think it is (Pro SQL Server 2005 yadda yadda),
> then please do me -or rather yourself- a favor and stop trying to learn
> database theory from it. There are a lot of things that Louis and I
> agree on, but database theory is definitely not among them. Parts of his
> book are useful, the art is figuring out which parts.
> Best, Hugo

Hugo are you famous? "Louis and I"? I should start hanging out here more often!

In defense of Louis Davidson, his book is OK for beginners IMO (from what I've seen on the net) in that he uses similar examples to what I've seen elsewhere. If anything, the book is too plodding for me.

Specifically on artificial keys, on p. 151 Davidson says (ironically or perhaps intentionally when discussing Boyce-Codd Normal Forms, where all attributes are fully dependent on a key):

"Depending on the choice of primary key this [this choice, of using a key for BCNF] can be a great distinction. There's a massive movement [note!-RL] towards using meaningless surrogate keys (of which I'm a big fan). [that's the author talking--RL] If you don't deal with the case of more than one key, it's easy to forget that the important keys are the natural keys of the entity, and normalization should take them into consideration. Too often when answering newsgroup posts [this means us; in other parts of the book Louis says he sometimes posts in Usenet groups, perhaps or in particular even this one--RL], the problem of poor key choices for a table has to be solved before solving the problem at hand".

So, from this passage, I think the author does a good job disclaiming the slavish use of GUIDs without understanding their drawbacks, even after the author said he's a "big fan" of such GUIDs.

RL Received on Sun Dec 16 2007 - 12:13:12 CET

Original text of this message