Transaction management issues in a failure-prone multidatabase system environment

  • Authors:
  • Yuri Breitbart;Avi Silberschatz;Glenn R. Thompson

  • Affiliations:
  • University of Kentucky, Lexington, KY;University of Texas, Austin, TX;Amoco Production Company, Tulsa, OK

  • Venue:
  • The VLDB Journal — The International Journal on Very Large Data Bases
  • Year:
  • 1992

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper is concerned with the problem of integrating a number of existing, off-the-shelf local database systems into a multidatabase system that maintains consistency in the face of concurrency and failures. The major difficulties in designing such systems stem from the requirements that local transactions be allowed to execute outside the multidatabase system control, and that the various local database systems cannot participate in the execution of a global commit protocol. A scheme based on the assumption that the component local database systems use the strict two-phase locking protocol is developed. Two major problems are addressed: How to ensure global transaction atomicity without the provision of a commit protocol, and how to ensure freedom from global deadlocks.