Silicon Valley Code Camp : October 3rd and 4th 2015session
Where did I put my (primary) keys?
Ever wondered why so many tables have ID fields used as primary keys? If you have not - this session is for you...
About This Session
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.