View (SQL): Difference between revisions

Revision as of 02:37, 23 December 2020

Revision as of 21:25, 20 March 2022

Line 24:

Various [[database management system]]s have extended the views from read-only subsets of [[data]], particularly [[materialized view]]s: pre-executed, non-virtual views commonly used in [[Data warehouse|data warehousing]]. They give a static snapshot of the data and may include data from remote sources. The accuracy of a materialized view depends on the frequency of trigger mechanisms behind its updates.

Materialized views were introduced by [[Oracle Database]], while [[IBM DB2Db2]] provides so-called "materialized query tables" (MQTs) for the same purpose. [[Microsoft SQL Server]] introduced in its 2000 version indexed views which only store a separate index from the table, but not the entire data. [[PostgreSQL]] implemented materialized views in its 9.3 release.

== Equivalence ==