Database Normalization: Abnormal Forms
This video covers a variety of topics, effectively wrapping up the series on normalization. We look at data warehousing, including why the Kimball-style star schema is a really bad design in theory but a perfectly reasonably design in practice. We cover the chimera of "overnormalization" and I throw out a hot take. And we finally slag on denormalization.
LINKS AND INFO
Catallaxy Services -- https://www.catallaxyservices.com
Perfectly Normal (the talk) -- https://www.catallaxyservices.com/pre...
Database Design and Relational Theory, 2nd Edition -- https://link.springer.com/book/10.100...
Pro SQL Server Relational Database Design and Implementation -- https://link.springer.com/book/10.100...
Louis Davidson speaking at Data Architecture Day -- • Data Architecture Day - Louis Davidso...
Handbook of Relational Database Design -- https://www.amazon.com/Handbook-Relat...
