[AccessD] Surrogate keys suck

Heenan, Lambert Lambert.Heenan at aiuholdings.com
Tue Jul 21 10:37:42 CDT 2009


Well naturally! :-)

Any piece of data that means something is subject to the wholly illogical whims of users who might change its meaning at any time. Less than ideal for a key. 

Now it's always possible to have surrogate surrogate keys: the user thinks they are looking at the key value, but it's just faked to keep them happy. :-)

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, July 21, 2009 10:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Surrogate keys suck

Oooops, I forgot, I use surrogate keys.

Natural keys suck and should NEVER be used.

John W. Colby
www.ColbyConsulting.com


jwcolby wrote:
> And should never be used.  EVER!
> 
> ;)
> 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list