1:00 PM Sunday
Town Square B
Silicon Valley Code Camp : October 7 & 8, 2017session

Where did I leave my (primary) Keys???

Ever wondered why so many tables have ID fields used as primary keys? Is it a 'design pattern', or an unfortunate misunderstanding that got rooted? If you have never gave it a second thought - this session is for you...

About This Session

You will be surprised how far reaching implications arise from the keys that you choose... 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.

Time: 1:00 PM Sunday    Room: Town Square B 

The Speaker(s)

undefined undefined

Ami Levin

Data tier architect , Self Employed

Senior data tier architect, data modeler, database designer and SQL developer.