Design Good Schemas - Get a Better Database

This session explains how to design relational database schemas that support application performance, maintainability, and change. It covers modeling and mapping, data types, denormalization, keys, ORMs, and migration scripts.

Syllabus

Introduction
Design good schemas
Fitness criteria
Model vs Schema
Design vs Schema
Model
Schema
Regrets
Impact of change
Data types
How to fix data types
Denormalization
Multientity table
Catalog item example
How to fix this
Abnormal Form
References
Sequential Keys
Primary Keys
ORM
RMS
Adhoc DDL
Migration scripts
Summary