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

Ami Levin's previous sessions

Data loading at warp speeds

Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…

A heap of clusters

An in-depth dive into physical table structures

Physical Join Operators

See how the optimiser chooses the operators it does through real world examples.