Where did I put my keys?

2011

TL; DR

If you want to see DBAs fight - ask them what is better: using IDs or native keys? This old debate has been troubling database designers since the days of Dr. Codd and Chris Date. Are you ready to hear the "truth"?

Session Details

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.

3 things you'll get out of this session

Speaker

Ami Levin's previous sessions

Data loading at warp speeds - 2013

A heap of clusters - 2012

Where did I put my keys? - 2011

Physical Join Operators - 2010