Normalization

Kind: technique

Layer: Contracts Core

Record: architecture:normalization

Severity: contextual

Scope: database, schema, data model

Canonical: Ontology

A technique for storing each fact once and referring to it by key wherever it is needed.

Listed in Architecture principles, after Single Source of Truth and before Semantic Consistency.

Requires

• Data Semantics

Reinforces

• Consistency
• Do Not Repeat Yourself (DRY)

Enables

• Reduced Redundancy

In tension with

• Query Performance
• Denormalized Read Models

Tensions

• Normalization / Query Performance
• Normalization / Denormalized Read Models

Violated by

• Duplicated Denormalized Columns

Refactored by

• Entity
• Database Normalization
• Name the Concept

Severity

• contextual

Category

• Schema / Canonical Data / Semantics

Reinforced by

• Canonical Data Model

Linked from

• Separate, trade, or mitigate
• The principle architecture
• Core Modular Design
• Schema / Canonical Data / Semantics
• Transactions / State / Concurrency
• Core Vocabulary
• Schema / Canonical Data / Semantics
• Severity levels
• The resolutions