# Denormalization

> The same data is copied into one wide table. Reads get much faster.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** Denormalisation, Denormalized Table

## Think of it like

It is like writing a friend's phone number in each book you own. It takes more ink, but you find it fast.

## Definition

Denormalization puts copies of data back into one table on purpose. A normalized design keeps each fact in one place and joins tables to read it. Joins cost time on big data. So for reports, you copy the needed fields into one wide table. Reads get much faster, but each copy must be kept up to date.

## Example

An orders table also keeps the buyer's city and the product name. A report of sales by city then needs no joins.

## Why it matters

Most analytics tables are denormalized. It is the main trick that makes big reports fast.

## Common mistake

Doing it in the app's own database. There, the copies drift apart and cause bugs.

## Three principles

- **Copy on purpose.** The same fact sits in many rows.
- **Fewer joins.** One wide table answers the question.
- **Harder to update.** Every copy must change together.

## Related terms

- [Database Normalization](https://learn.benibix.com/term/development/normalization)
- [SQL Join](https://learn.benibix.com/term/development/join)
- [Data Model](https://learn.benibix.com/term/data/data-model)
- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [One Big Table (OBT)](https://learn.benibix.com/term/data/one-big-table)

## Taught in

- [OLTP, OLAP and HTAP](https://learn.benibix.com/learn/data-foundations/oltp-olap-and-htap): Data Engineering Basics, 11/11

---

Source: https://learn.benibix.com/term/data/denormalization
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
