Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Question on Primary Keys

Re: Question on Primary Keys

From: Jan Lenders <J.Lenders_at_Betuwe.net>
Date: Mon, 16 Oct 2000 12:11:52 GMT
Message-ID: <8sera4$888$1@nnrp1.deja.com>

There are database "gurus" who claim that you should never ever use class attributes as primary key.
Instead you add a DBMS-generated primary key value column to each and every table. They even claim that these keys should be unique within the database; if a Client_Num value 12345 exists, you should not use Order_Num 12345.
The reason was that primary key values may never change (agree) and that an object might become of a different class sometime (disagree; I've never seen Clients who became an Order).

(I burned this book, I must add)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 07:11:52 CDT

Original text of this message

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