|
|
| Master vs.
Materialized View |
|
| Replication |
|
| Multimaster |
| Materialized
View |
|
|
| • | Server-to-Server |
|
|
| • | Mass Deployment |
|
|
|
| • | Large number of small |
|
| remote sites |
||
|
|
|
| • | HQ and regional offices |
|
|
|
|
|
| • | Continuous, near real- |
||
| time data
propagation |
|||
|
|
| • | Periodic Bulk Transfer |
|
|
|
| • | Final Values of Changed |
|
| Rows Only |
||
|
|
|
|
| • | Updates per |
||
| transaction |
|||
|
|
| • | Full Copies |
|
|
| • | Subsets or Full Copies |