On August 13th, 2006 Todd Farmer (not verified) says:
I think there are two different schools of thought on whether primary keys should have business value or not - we seem to be on opposite sides of the fence. Nothing wrong with that - I've just been burnt so many times by changing business data requirements causing changes that have to be cascaded down the data model and the application that depends on it that I don't go there any more. I think http://www.bcarter.com/intsurr1.htm does a good job of representing the pros and cons of either surrogate or intelligent/business primary keys.
I think there are two
I think there are two different schools of thought on whether primary keys should have business value or not - we seem to be on opposite sides of the fence. Nothing wrong with that - I've just been burnt so many times by changing business data requirements causing changes that have to be cascaded down the data model and the application that depends on it that I don't go there any more. I think http://www.bcarter.com/intsurr1.htm does a good job of representing the pros and cons of either surrogate or intelligent/business primary keys.