My friend André Cardoso has just posted a link list about this modeling dilemma.
Though I'm a surrogate key myself, I can't overlook some some natural key advantages. To me, the problem of natural keys is that it is hard to ensure them to be natural - at least over time. Also for normalization and implementation reasons, I adopt surrogate keys to most of my design. Even on N-M tables...
Friday, September 14, 2007
Surrogate Key vs Natural Key
Posted by Mário Romano at Friday, September 14, 2007
Labels: architecture, Database, Development
Subscribe to:
Post Comments (Atom)
Development Catharsis :: Copyright 2006 Mário Romano
No comments:
Post a Comment