https://wiki.openmod-initiative.org/index.php?title=Materialised_view&feed=atom&action=historyMaterialised view - Revision history2024-03-29T06:44:15ZRevision history for this page on the wikiMediaWiki 1.19.7https://wiki.openmod-initiative.org/index.php?title=Materialised_view&diff=10907&oldid=prevLilly Schoen: Created page with "{{GlossaryTermTemp |SubtermOf=view, table |Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of ot..."2017-11-03T09:18:14Z<p>Created page with "{{GlossaryTermTemp |SubtermOf=view, table |Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of ot..."</p>
<p><b>New page</b></p><div>{{GlossaryTermTemp<br />
|SubtermOf=view, table<br />
|Definition=1. A materialized view is defined as a table which is actually physically stored on disk, but is really just a view of other database tables. In PostgreSQL, like many database systems, when data is retrieved from a traditional view it is really executing the underlying query or queries that build that view.<br />
2. A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Using materialized views against remote tables is the simplest way to achieve replication of data between sites.<br />
|Sources=http://www.revsys.com/blog/2006/jan/03/when-to-use-a-materialized-view-in-postgresql/ (1.); https://oracle-base.com/articles/misc/materialized-views (2.)<br />
}}<br />
Author: Tim Röder</div>Lilly Schoen