Oracle 8i
Like SQL Server, can replicate updates to table fragments or stored proc calls at the master copy
Uses triggers to capture updates in a deferred queue
- Updates are row-oriented, identified by primary key
- Can optimize by sending keys and updated columns only
Group updates by transaction, which are propagated:
- Either serially in commit order or
- in parallel with some dependent transaction ordering: each read reads the “commit number” of the data item; updates are ordered by dependent commit number
Snapshots are updated in a batch refresh.
- Pushed from master to snapshots, using queue scheduler