Reliable transaction management in a multidatabase system

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

  • Affiliations:
  • Dept of Computer Science, University of Kentucky, Lexington, KY;Dept. of Computer Science, University of Texas, Austm, TX;Amoco Production Company, P 0 Box3385, Tulsa, OK

  • Venue:
  • SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
  • Year:
  • 1990

Quantified Score

Hi-index 0.02

Visualization

Abstract

A model of a multidatabase system is defined in which each local DBMS uses the two-phase locking protocol Locks are released by a global transaction only after the transaction commits or aborts at each local site. Failures may occur during the processing of transactions. We design a fault tolerant transaction management algorithm and recovery procedures that retain global database consistency. We also show that our algorithms ensure freedom from global deadlocks of any kind.