the.com/denormalization
deliberately duplicating data so your database stops thinking and starts answering.
means restructuring a database to add redundant copies of data, trading storage and update-safety for faster reads.
from coined as the reverse move to normalization, the relational-database discipline codd formalized in the 1970s to eliminate redundancy; engineers later found that eliminating it too well made queries painfully slow.
opposite ofnormalization, its tidy, redundancy-hating sibling
common triggerjoins across five tables killing performance
famous usersanalytics warehouses, read-heavy apps, reporting dashboards
hidden costupdate anomalies, since duplicates can drift out of sync