DEV Community

Discussion on: ELI5: Database Normalization?

Collapse
 
rolfstreefkerk profile image
Rolf Streefkerk

Perhaps a bit outside of the scope of this discussion, but the reason for data normalization and SQL is because of an outdated paradigm. Data storage used to be really expensive and storing redundant information is therefore cost prohibitive. These days, storage is cheap and we're CPU bound more so than disk space bound.

To cut a long story short some data redundancy isn't a bad thing and in fact if you look at NoSQL engines they actually prefer data redundancy as a means to increased query performance.

The answer here is, it depends how relevant normalization is with respect to its context.