What Is Materialized View Replication?

A materialized view contains a complete or partial copy of a target master from a single point in time. The target master can be either a master table at a master site or a master materialized view at a materialized view site. A master materialized view is a materialized view that functions as a master for another materialized view. A multitier materialized view is one that is based on another materialized view, instead of on a master table.

Materialized views provide the following benefits:

• Enable local access, which improves response times and availability

• Offload queries from the master site, because users can query the local materialized view instead

• Increase data security by allowing you to replicate only a selected subset of the target master's data set

A materialized view may be read-only, updatable, or writeable, and these types of materialized views provide benefits in addition to those listed previously.