Re: Trend towards artificial keys (GUIDs) sez my textbook...is AI next?
From: raylopez99 <raylopez99_at_yahoo.com>
Date: Mon, 17 Dec 2007 06:58:10 -0800 (PST)
Message-ID: <3dff5f4f-fa62-4721-b887-1229ffdf1388_at_w40g2000hsb.googlegroups.com>
Date: Mon, 17 Dec 2007 06:58:10 -0800 (PST)
Message-ID: <3dff5f4f-fa62-4721-b887-1229ffdf1388_at_w40g2000hsb.googlegroups.com>
On Dec 16, 3:00 pm, Hugo Kornelis
> >So, from this passage, I think the author does a good job disclaiming
<h..._at_perFact.REMOVETHIS.info.INVALID> wrote
> >the slavish use of GUIDs without understanding their drawbacks, even
> >after the author said he's a "big fan" of such GUIDs.
>
> True. But in the rest of his book, he adds a surrogate key (either GUID
> or IDENTITY) to every entity before and without considering whether one
> is needed. I believe that logical design should be done completely
> without surrogate keys. They MIGHT be introduced during physical design,
> but not before.
RL Received on Mon Dec 17 2007 - 15:58:10 CET