002 What Hot Models Look Like – For the Love of Data

Summary: Hot models...data models that is. A survey of many of the most popular data modeling approaches in the news today. Third Normal Form, Anchor Modeling, Data Vault, Data Lakes, Data Swamps. What do they do well, what do they do badly, and which is the one true data model to rule them all? (Hint: it depends, as usual.) Third Normal Form (3NF) (a.k.a. Naomi Sims) History: E.F. Codd defined 3NF in 1971 while working at IBM. Basic Concept: "The Key, the Whole Key, and Nothing but the K...
More