Normalization / Query Performance
Kind: tension
Record: tension:normalization-query-performance
Canonical: Schema
The source of truth is normalized into one canonical store with no duplication. Derived read models, or projections, are denormalized for query performance, and the canonical store never is, so the two live in separate scopes: the system of record and the read projection.
Listed in Tensions, after Single Source of Truth / Decentralization and before Normalization / Denormalized Read Models.