A design technique that deliberately combines normalized tables, tolerating duplicate data to avoid the need for joins.
It's done to prioritize read performance by reducing the number of JOINs needed. Because data duplication raises the risk of inconsistency on update, it's often chosen for read-heavy, infrequently updated use cases such as a data warehouse.
© 2026 ITBGM