3 ms·
> Oddly, I'd argue that normalization is often the "simplification" that is not accurate to how things are. Normalization is what makes sure that the data you
by marcosdumay 3y ago
> Oddly, I'd argue that normalization is often the "simplification" that is not accurate to how things are.
Normalization is what makes sure that the data you are storing matches exactly the model you have for it. Without it there isn't any meaning to talk about data model.
If the real data actually doesn't match the model, then yes, your model is inaccurate. That means your software is also probably buggy, and that if you didn't normalize your data structure, you wouldn't even know about it.
- taeric 3y agoMy point is that a lot of data in the real world is not normalized. Simple stuff like "branding" and "manufacturer." In a normalized world, you update the name of a product, and all units are magically updated. In a materialized world, they are what they were when they shipped. We may pencil over updates, but that has to be done on each "row," as it were.