Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Natural Keys
Message
De
09/03/2015 06:58:59
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
À
07/03/2015 12:53:47
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01616073
Message ID:
01616476
Vues:
41
>>Here at my job we have a database modeler in our group. He is insistent that all tables use 'Natural Keys' and not surrogate keys.
>
>Politics can be hard.
>
>Perhaps an appeal to authority may help?
>
>Here is the SQL guru Joe Celko discussing the issue - with references back to Codd:
>
>http://www.informationweek.com/software/information-management/celko-on-sql-natural-artificial-and-surrogate-keys-explained/d/d-id/1059246?
>
>We all know this, but here is the kernel of the argument - the article says it better than I can:
> "If users can get to the surrogate key, they will screw up the data integrity "

Michael,
Thanks for the link. I will read it after a bit this morning.
Timothy Bryan
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform