–Full transactional consistency
–Efficient, batch-oriented refresh
lScheduled or on demand
lRefresh groups preserve master-detail relationships
–Updatable materialized views use deferred transactions to push changes to master
Architectural Overview
Materialized Views
SELECT…
FROM...
network
Master table
log
Materialized View
lUpdatable or read-only copy of a table, or portion of a table, at a point in time