Optimal Savepoint in a Loosely-Coupled Resilient Database System

느슨히 결합된 데이타베이스 시스템에서 최적의 저장점 유도

  • 최재화 (단국대학교 경영학과) ;
  • 김성언 (대구효성가톨릭대학교 경영학과)
  • Published : 1996.06.30

Abstract

This paper investigates the performance improvement opportunities through a resiliency mechanism in the distributed primary/backup database system. Recognizing that a distributed transaction executes at several servers during its lifetime, we propose a resiliency mechanism which allows continuous transaction processing in distributed database server systems in the presence of a server failure. In order to perform continuous transaction processing despite failures, every state change of a transaction processing can be saved in the backup server. Obviously, this pessimistic synchronization may give more burdens than benefits to the system. Thus, the tracking needs not be done synchronously with the transaction progress. Instead, the state of all transaction processing in a system is saved periodically. This activity is referred to as a savepoint. Then, the question is how often the savepoint has to be done. We derive the optimal savepoint to identify the optimization parameters for the resilient transaction processing system.

Keywords