materialised view

A stored table of results computed from other data, kept so queries do not have to recompute them.

In more detail

It must be refreshed or rebuilt when the source data changes. Because it is derived, it can always be thrown away and rebuilt from the source.

Examples

The course folds a Kafka stream of orders into totals per customer.
PostgreSQL: CREATE MATERIALIZED VIEW ..., then REFRESH MATERIALIZED VIEW to update it.
SQLite has no materialised views; a table kept up to date by application code plays the same role.

Related terms

Taught in

References

Certification courses