Title :
On the impossibility of atomic commitment in multidatabase systems
Author :
Mullen, James G. ; Elmagarmid, Ahmed K. ; Kim, Won ; Sharif-Askary, Jamshid
Author_Institution :
Dept. of Comput. Sci., Purdue Univ., West Lafayette, IN, USA
Abstract :
Examines the problem of performing the atomic commitment of global transactions in multi-database system environments, where autonomous local database systems are integrated into a global database system. It is shown, that if the autonomy of the local database systems is preserved, it is impossible to perform atomic commitment in general, even under the assumption that there are no system failures. It is also shown that even when it is assumed that all local database systems use strict two phase locking (an assumption useful for performing global concurrency control), atomic commitment is impossible if even a single system failure can occur
Keywords :
concurrency control; database theory; distributed databases; transaction processing; atomic commitment; autonomous local database systems; global concurrency control; global database system; global transactions; multidatabase systems; strict two phase locking; system failure; Concurrency control; Concurrent computing; Data engineering; Database systems; Distributed databases; NASA; Petroleum; Protocols; Transaction databases; Voting;
Conference_Titel :
Systems Integration, 1992. ICSI '92., Proceedings of the Second International Conference on
Conference_Location :
Morristown, NJ
Print_ISBN :
0-8186-2697-6
DOI :
10.1109/ICSI.1992.217268