Re: Sequence Numbers as Primary Keys

From: Jack Carter <jcarter_at_nt.com>
Date: 1995/10/18
Message-ID: <3084F18C.7D00_at_nt.com>#1/1

This debate has gone on forever and will contiue, but neither and both are correct. A system generated primary key is convenient and provides advantages for OLTP systems. If this is used in conjunction with a secondary unique identifier that makes sense to the users of the data all aspects are satisfied.

-- 
  __________ /    __      __/______  |Jack C. Carter,  Systems Architect
    / _  _  /_   / ' _  _  /  _  _   |Cap Gemini America - Consulting
 \_/ (/ (_ /|   /_, (/ /' /, (' /'   |EMAIL jack.carter_at_nt.com
 ----------------------------------- |PHONE: (214) 933-4313

Received on Wed Oct 18 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Mike Morgan: "Re: Column name MOD causing problem"
Previous message: Gordon E. Hooker: "Page Numbers in OPO Reports"
Maybe in reply to: Ed Bruce: "Re: Sequence Numbers as Primary Keys"
Next in thread: Tom Cooke: "RE: Oracle as a back-end for MS Access?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message