A read-only materialized view contains a complete or partial copy of a target master table from a single point in time. A partial copy can include a subset of row, a subset of columns, or both.
Read-only materialized views can provide read-only access to the master table's data. Applications can query data from read-only materialized views to avoid network access to the master database, regardless of network availability. However, applications throughout the system must access data at the master database to perform data manipulation language changes (DML). Figure 35-1 illustrates basic, read-only replication.
Figure 35-1 Read-Only Materialized View
Description of "Figure 35-1 Read-Only Materialized View"
Materialized views provide the following benefits:
Enable local access, which improves response times and availability
When the materialized view is in a different database than its source, offload queries from the master database, because users can query the local materialized view instead
Increase data security by enabling you to replicate only a selected subset of the target master's data set
Users can synchronize (refresh) read-only materialized views on demand. When users refresh read-only materialized views, they receive any changes that happened on the master table since the last refresh.
Parent topic: Read-Only Materialized View Concepts
