What is 'Denormalization'?

What is 'Denormalization'?

Approach: Explain adding redundancy to speed up reads.

The process of combining tables or adding redundant data to a database to reduce the number of joins and improve read performance at the cost of write complexity.

Follow-up: In which type of system is this most common (OLTP or OLAP)?

Key concepts: joins, latency.