Главная
Study mode:
on
1
Introduction
2
Design good schemas
3
Fitness criteria
4
Model vs Schema
5
Design vs Schema
6
Model
7
Schema
8
Regrets
9
Impact of change
10
Data types
11
How to fix data types
12
Denormalization
13
Multientity table
14
Catalog item example
15
How to fix this
16
Abnormal Form
17
References
18
Sequential Keys
19
Primary Keys
20
ORM
21
RMS
22
Adhoc DDL
23
Migration scripts
24
Summary
Description:
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.

Design Good Schemas - Get a Better Database

NDC Conferences
Add to list