Design Good Schemas - Get a Better Database

Discover how to design effective table schemas for relational databases in this NDC Oslo 2023 conference talk. Learn why proper schema design is crucial for application performance and maintainability, especially in CI/CD environments. Explore the concept of adopting a relational mentality, covering aspects of modeling, mapping models to tables, and delving into data types and fields. Gain insights on fitness criteria, the differences between models and schemas, and the impact of changes. Address common pitfalls such as over-normalization, improper use of indexes, and relying solely on ORMs. Examine practical examples, including catalog item scenarios, and learn techniques to fix data types, handle denormalization, and implement effective primary keys. Understand the importance of migration scripts and adhering to best practices in database design for improved application flexibility and performance.

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