Okuzeka
Software Engineering vocabulary · Databases and Persistence

Materialized view

Meaning in software engineering, with examples

nounCommon term

In software engineering, materialized view means: Stored results of a query that can be read directly and refreshed when underlying data changes.

In Turkish: somutlaştırılmış görünüm

How it is used

Used to speed repeated expensive reads. Refresh timing determines how current the stored result is.

Example sentences

  1. The dashboard reads a materialized view instead of recalculating yearly totals on every visit.

    Previously computed results trade extra storage and refresh work for faster reads.

  2. The materialized view still showed yesterday's figures because the refresh job had failed.

    Stored query results can remain stale even though the underlying tables have changed.

Common collocations

  • refresh a materialized view
  • query a materialized view
  • viewA saved SELECT query that you can use like a table. It usually stores no data of its own and shows the current result of the query each time.
  • queryA request sent to a database to read or change data, usually written in SQL. As a verb, to query means to ask a database for data.

More terms: Databases and Persistence

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: