Data Architect. Author of Minimum Viable SQL Patterns. Where others teach tactics I teach timeless principles and patterns
1 added to My Authors
May 17 • 10 tweets • 4 min read
I didn’t really get Kimball’s dimensional modeling (DM) until I read an early article by him comparing DM to the ER model.
In the process I answered the question of whether dimensional modeling is still valid today.
Early in the article Kimball states that ERs are nearly impossible for business users to query and use, hinting that DMs are used as the report delivery mechanism.
The equivalent of a DM these days are wide tables which are still valid for reporting/ BI tools to use.
May 17 • 4 tweets • 1 min read
Finally started reading Bill Kent’s Data and Reality. It’s a shame this book is out of print and not very popular.
These are some of my favorite quotes:
At its core, modeling is representing / mapping reality into the digital world therefore it is not very precise. Our maps of reality are by design incomplete and all models are wrong but some are useful.
May 15 • 4 tweets • 1 min read
Data modeling is easy to understand but really hard to put into practice. Why?
Because it’s fundamentally an opinionated design process.
The fundamental purpose of data modeling is to reduce redundancy in data so that updates, inserts and deletes are easy to and cause no anomalies or inconsistencies.