List of Figures

• 1-1 Multimaster Replication
• 1-2 Read-Only Materialized View Replication
• 1-3 Updatable Materialized View Replication
• 1-4 Hybrid Configuration
• 1-5 Advanced Replication Interface in Enterprise Manager
• 2-1 Multimaster Replication
• 2-2 Multimaster Replication Supporting Multiple Points of Update Access
• 2-3 Each Arrow Represents a Database Link
• 2-4 Master Group hr_mg Contains Same Replication Objects at All Sites
• 2-5 Master Groups Are Identical at Each Master Site
• 2-6 Asynchronous Data Replication Mechanisms
• 2-7 Synchronous Data Replication Mechanisms
• 2-8 Propagating Changes Using Synchronous Row-Level Replication
• 2-9 Selecting a Propagation Mode
• 2-10 Ordering Considerations
• 3-1 Materialized View Connected to a Single Master Site
• 3-2 Comparison of Simple and Complex Materialized Views
• 3-3 Row Subsetting with Many to One Subqueries
• 3-4 Row Subsetting with One to Many Subqueries
• 3-5 Row Subsetting with Many to Many Subqueries
• 3-6 Row Subsetting with Subqueries and Unions
• 3-7 Multitier Materialized Views
• 3-8 Levels of Materialized Views
• 3-9 Master Materialized Views
• 3-10 Materialized View Replication Objects
• 3-11 Master Site and Master Materialized View Site Objects
• 3-12 Materialized View Groups Correspond with Master Groups
• 3-13 Refresh Groups Can Contain Objects from Multiple Materialized View Groups
• 3-14 Fast Refresh of a Materialized View
• 4-1 Deployment Template View Relationships
• 4-2 Deployment Template Elements Added to Template
• 4-3 Online Instantiation
• 4-4 Offline Instantiation
• 4-5 Checking for Parameters During Online Instantiation
• 4-6 Replicate Column-Subsetted Data
• 4-7 Product/Warehouse Relationship
• 4-8 The Different Needs of Salespersons and Customer Support Technicians
• 5-1 Conflict Resolution and Multitier Materialized Views
• 5-2 Using Priority Groups
• 5-3 Column Groups and Data Propagation
• 6-1 Recommended Schema and Database Link Configuration
• 6-2 Flowchart for Creating Materialized Views
• 6-3 Survivability Methods: Replication Or Oracle Real Application Clusters