Denormalization

Learn the deliberate repeat scenario.

Denormalization adds deliberately copied columns to a normalized table to speed up reads. Writes get more costly but read queries simplify.

-- orders tablosuna customer_name ekle
-- JOIN gereği azalır, okuma hızlanır

Denormalization speeds up reads.

Denormalization — details

Denormalization helps in reporting and OLAP workloads. In OLTP systems it is used with care due to write anomaly risk.

Add a customer_name TEXT column to orders for denormalization.

Show example solution

ALTER TABLE orders
ADD COLUMN customer_name TEXT;

Add a column to the table

ALTER TABLE orders ADD COLUMN ____ TEXT

Show answer

ALTER TABLE orders ADD COLUMN customer_name TEXT