Re: Separate PK in Jxn Tbl?

From: David Cressey <>
Date: Tue, 29 Jan 2008 15:04:36 GMT
Message-ID: <8gHnj.525$4f.510_at_trndny08>

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> wrote in message news:%23Cj52$SYIHA.220_at_TK2MSFTNGP04.phx.gbl...
> But many of them seem to write as if contents as determined by
ddress .
> The content is not determined by the address and in fact, for those who
> using surrogate keys, the exact value of an address inside the database
> zero importance.

You misunderstand my point. A great many people use surrogate keys as if they were surrogate addresses. They then use foreign keys that reference surrogate keys as if they were surrogate pointers.

If this mimicry of pointers is pushed far enough, it can reduce a relational or SQL database to an inferior imitation of the old network databases. You lose the inherent advantages of content based addressing, but retain all the extra overhead. Received on Tue Jan 29 2008 - 16:04:36 CET

Original text of this message