Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Natural Keys
Message
De
07/03/2015 12:53:47
 
 
À
02/03/2015 08:30:32
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
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:
01616402
Vues:
40
>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 "
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform