Reservable transactions: An approach for reliable multidatabase transaction management

Ahmed Khalifa Elmagarmid, Jin Jing, James G. Mullen, Jamshid Sharif-Askary

Research output: Book/ReportCommissioned reportpeer-review

Abstract

Atomically committing global transactions in a multidatabase system is difficult because of local system autonomy. Traditional transaction management methods, such as two phase commit (2PC), are often not possible, since many database systems do not support a (visible) prepare-to-commit state. And, even where the local database systems of a multidatabase do provide such support, the potential blocking and long delays of 2PC can severly degrade local execution autonomy. Transaction models that use compensation (such as Sagas), can avoid some of these problems, however these methods are only appropriate for certain cases. This paper presents reservable transactions, which contain a reservation phase that utilizes data semantics to ensure that
a transaction can commit, without completely blocking the data that the transaction accesses. The method presented can handle cases where compensation is not applicable. In addition, the reservation concept can be used to increase the cases where compensation is applicable.
Original languageEnglish
Publication statusPublished - 1992
Externally publishedYes

Fingerprint

Dive into the research topics of 'Reservable transactions: An approach for reliable multidatabase transaction management'. Together they form a unique fingerprint.

Cite this