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: dbdebunk 'Quote of Week' comment

Re: dbdebunk 'Quote of Week' comment

From: Tony Andrews <andrewst_at_onetel.com>
Date: 19 Aug 2005 04:12:12 -0700
Message-ID: <1124449932.517124.221680@o13g2000cwo.googlegroups.com>


David Cressey wrote:
> And that's what I don't like about dogmatic responses. They tend to assume
> that design judgements fall on a simple linear scale from badness to
> goodness. Goodness is not a one dimensional measure. And that's why I stay
> way from dbdebunk.
> At a deeper level, they don't get it.

But at dbdebunk they DO NOT dogmatically say avoid surrogates - e.g. here:

http://www.dbdebunk.com/page/page/857309.htm

"We do not recommend the use of surrogate keys as a rule, but only in some rare circumstances and for very specific reasons. Chapter 3 in my book gives ah explanation of the criteria for choosing keys, which also help determining when those special circumstances apply."

It is the "quote of the week" that is dogmatic: "Don't use primary keys that have meaning for the end user..." Received on Fri Aug 19 2005 - 06:12:12 CDT

Original text of this message

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