Re: bind sequences to columns

From: Pablo Sanchez <pablo_at_dev.null>
Date: 18 Oct 2002 16:23:50 -0500
Message-ID: <Xns92AB9D8B567AEpingottpingottbah@209.189.89.243>

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in news:3db076d0_2_at_mk-nntp-1.news.uk.worldonline.com:

>
> And I think it would be a good idea to consider whether surrogate
> keys are really necessary in the first place. Sometimes they are,
> sometimes not. But IMHO we should always check to see whether a
> natural key is available. My 2c.

Seems to me that one can always use surrogate keys to build the abstraction between the app and the business. This doesn't mean that we throw away the natural keys, we still use them to support the business requirements (e.g. cust_no's are unique)

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Fri Oct 18 2002 - 16:23:50 CDT