Capturing global transactions from multiple recovery log files in a partitioned database system

Authors:
Chengfei Liu;Bruce G. Lindsay;Serge Bourbonnais;Elizabeth B. Hamel;Tuong C. Truong;Jens Stankiewitz
Affiliations:
University of South Australia, Adelaide, Australia;IBM Almaden Research Center, San Jose, CA;IBM Silicon Valley Laboratory, San Jose, CA;IBM Silicon Valley Laboratory, San Jose, CA;IBM Silicon Valley Laboratory, San Jose, CA;Viterra Informationssyeme GmbH, Bochum, Germany
Venue:
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Year:
2003

Citing 10
Cited 2

Concurrency control and recovery in database systems

Concurrency control and recovery in database systems
The dangers of replication and a solution

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Replication, consistency, and practicality: are these mutually exclusive?

SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Update propagation protocols for replicated databates

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Time, clocks, and the ordering of events in a distributed system

Communications of the ACM
A new approach to developing and implementing eager database replication protocols

ACM Transactions on Database Systems (TODS)
An Argument in Favour of Presumed Commit Protocol

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Fast Algorithms for Maintaining Replica Consistency in Lazy Master Replicated Databases

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Don't Be Lazy, Be Consistent: Postgres-R, A New Way to Implement Database Replication

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
From Total Order to Database Replication

ICDCS '02 Proceedings of the 22 nd International Conference on Distributed Computing Systems (ICDCS'02)

Lazy Database Replication with Ordering Guarantees

ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Middleware based data replication providing snapshot isolation

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Quantified Score

Hi-index	0.00

Visualization

Abstract

DB2 DataPropagator is one of the IBM's solutions for asynchronous replication of relational data by two separate programs Capture and Apply. The Capture program captures changes made to source data from recovery log files into staging tables, while the Apply program applies the changes from the staging tables to target data. Currently the Capture program only supports capturing changes made by local transactions in a single database log file. With the increasing deployment of partitioned database systems in OLTP environments there is a need to replicate the operational data from the partitioned systems. This paper introduces a system called CaptureEEE which extends the Capture program to capture global transactions executed on partitioned databases supported by DB2 Enterprise-Extended Edition. The architecture and the components of CaptureEEE are presented. The algorithm for merging log entries from multiple recovery log files is discussed in detail.