Lexicon

Duplicated Denormalized Columns

Kind: anti-pattern

Layer: Contracts Core

Record: lexicon:duplicated-denormalized-columns

Canonical: Lexicon

The same fact copied into many columns and rows, so updates must touch every copy or leave them inconsistent.

Listed in Lexicon terms, after Safe Use and before Functional Dependencies.

Category

  • Schema / Canonical Data / Semantics

Violates

  • Normalization
  • Database Normalization

Negated by

  • Database Normalization

Linked from

  • Schema / Canonical Data / Semantics