My experience with database normalization: Look at my beautiful normalized data model! Day 1 of prod load: OMG I can’t maintain this constraint without purging daily non-aggregate data without it taking more than a day. Also my joins are killing page caching. Denormalize now!
-
-
-
Those sentences almost made sense. Production is a battle, normalization is a battle plan, and it rarely survives the first shot. — note that my experience is with real time analytics based on transactions.
- 2 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.