3 ms·
Yes "denormalization" was the word for that. Is that still a thing?
by erikb 10y ago
Yes "denormalization" was the word for that. Is that still a thing?
- lostcolony 10y agoIt's a term used frequently in NoSQL land, to explain a key difference to people coming from SQL. In SQL land, normalizing your data is still the canonical thing to do, and I don't recall anyone in academia officially talking about denormalizing ever having its place...but in industry, the realities of use cases and performance have meant its usage. But I don't know that it's a standard tool given out to graduating software devs and DBAs.
- baakss 10y agoThe link I posted above is a common SQL land usage. Dimensional modeling in a star schema is very widely used in BI projects. There's actually two competing philosophies on data warehousing (Inmon and Kimball), but I've only ever used Kimball's method, which favors denormalization. http://www.computerweekly.com/tip/Inmon-vs-Kimball-Which-approach-is-suitable-for-your-data-warehouse http://www.computerweekly.com/tip/Inmon-vs-Kimball-Which-app...
- gaius 10y agoOf course they do, that's why there are the Normal Forms. Since like the 1970s people have been talking about this stuff. It's actual maths.
- baakss 10y agoYes, especially in business intelligence / data warehousing. Here is an excellent resource if you're interested in this sort of thing: https://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247 https://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimen...
- spudlyo 10y agoCan verify, still a thing. There is even a fun saying that goes with it. "Normalize until it hurts, denormalize until it works."
- MustardTiger 10y agoYes, and almost always used as pre-emptive optimization that didn't need to be done. Often times even making things slower because the person doing it didn't understand what they were doing, they just heard "denormalizing makes it fast".