raghu@dark-factory :~/kb/materialized-view $ cat

Materialized view

A query result physically precomputed and stored so repeated reads are cheap, kept fresh by incremental or scheduled refresh.

grounded in: HN trend theme 'Database & backend performance engineering' (measurable perf wins in the data layer); a classic, lasting precompute technique absent from the existing storage/query concepts

Connected concepts

Query planner, Storage engine, Columnar storage

Explore it live in the knowledge graph →