Pattern 55 / QUERY

Materialized View

Use this when Serving expensive read shapes without recomputing them on every request.

Pressure
Serving expensive read shapes without recomputing them on every request
Mechanism
Precompute query-specific views from source data or event streams
Toll
Views lag source-of-truth data and need rebuild/replay procedures
Architecture plate55
Diagram for Materialized View
Executive brief

Materialized View fits when Serving expensive read shapes without recomputing them on every request. Mechanism: Precompute query-specific views from source data or event streams. Use it for Dashboards, feeds, search summaries, account overviews. The toll: Views lag source-of-truth data and need rebuild/replay procedures.

Use when

Dashboards, feeds, search summaries, account overviews.

Example

Use materialized view when dashboards, feeds, search summaries, account overviews..

Review framing

Describe the pressure first, then the mechanism, then the cost. That keeps the design grounded.

Same pressure family

Data / Query

56CQRS Projection
← 5456 →