Materialised view
type: Ontology
creation date: 2026-08-06T07:58:27+02:00
imports: http://semantic-mediawiki.org/swivt/1.0

Materialised view
type: Subject
type: Category:Glossary
page: https://wiki.openmod-initiative.org/wiki/Materialised_view
wiki namespace: 0
glossary 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.
glossary definition: 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.
glossary 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.)
glossary subterm of: View
glossary subterm of: Table
wiki page creation date: 2017-11-03T09:18:14Z
creation date#aux: 2458060.887662
wiki page last editor: User:Lilly Schoen
wiki page modification date: 2017-11-03T09:18:14Z
modification date#aux: 2458060.887662
wiki page is new: true
wiki page sort key: Materialised view