Materialized views

Materialized views

A materialized view is a stored summary containing precomputes results (originating from an SQL select statement).
As the data is precomputed, materialized views allow for (seemingly) faster data ware query answers

Types of materialized views

There are three types of materialized views:

· Read only materialized view
· Updateable materialized view
· Writeable materialized view

Read only materialized views

Advantages:
· There is no possibility for conflicts as they cannot be updated.
· Complex materialized views are supported

Updateable materialized views

Advantages:
Can be updated even when disconnected from the master site or master materialized view site.
Requires fewer resources than multimaster replication.
Are refreshed on demand. Hence the load on the network might be reduced compared to using multimaster replication because multimaster replication synchronises changes at regular intervals