Denormalization
ELI5 — The Vibe Check
Denormalization is the intentional opposite of normalization — you duplicate data to make queries faster. Instead of JOINing three tables, you store the user's name right in the orders table. You trade storage and update complexity for read speed.
Real Talk
Denormalization is the process of intentionally introducing redundancy into a database schema to improve read performance. It reduces the need for expensive JOINs by storing derived or related data together. Common in analytics, data warehouses, and high-read systems like Elasticsearch or materialized views.
When You'll Hear This
"We denormalized the reporting table to avoid JOIN overhead." / "Denormalization trades write complexity for read speed."
Related Terms
N+1 Query
N+1 is when your code runs 1 query to get a list of things, then runs 1 more query for EACH thing on the list.
Normalization
Normalization is the process of organizing your database to reduce data duplication.
Query Optimization
Query optimization is the art of making slow database queries fast. Add an index here, rewrite that subquery as a JOIN, fetch only the columns you need.
Schema
A database schema is the blueprint of your database — which tables exist, what columns they have, what types they are, and how they relate to each other.