What is denationalization and when would you go for it? | SQL DBA

As the name indicates, denationalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.