Ami Levin
Data tier architect, Self Employed
Senior data tier architect, data modeler, database designer and SQL developer.
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.
The Speaker(s)