A deadlock checkpointing scheme for multidatabase systems

A multidatabase system (MDBS) is a software package that integrates a number of pre-existing, autonomous and heterogeneous local database systems (LDBS). Deadlock detection and resolution in MDBS is much more difficult than in traditional distributed database systems due to the autonomy requirement which implies that LDBSs cannot exchange any control information. The authors present an efficient periodic deadlock detection and resolution scheme for MDBS which allows for the concurrent execution of global transactions at multiple sites. The authors scheme employs a depth-first search of a bipartite graph called the transaction-block-at site graph (TBSG).<<ETX>>

[1]  Amit P. Sheth,et al.  On serializability of multidatabase transactions through forced local conflicts , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[2]  Rajeev Rastogi,et al.  Non-serializable executions in heterogeneous distributed database systems , 1991, [1991] Proceedings of the First International Conference on Parallel and Distributed Information Systems.

[3]  Radu Popescu-Zeletin,et al.  Transaction management in distributed heterogeneous database management systems , 1986, Inf. Syst..

[4]  Peter Scheuermann,et al.  A deadlock detection and resolution algorithm for sequential transaction processing with multiple lock modes , 1991, [1991] Proceedings The Fifteenth Annual International Computer Software & Applications Conference.

[5]  Weimin Du,et al.  Effects of local autonomy of global concurrency control in heterogeneous distributed database systems , 1989, Proceedings. Second International Conference on Data and Knowledge Systems for Manufacturing and Engineering.

[6]  Weimin Du,et al.  Quasi Serializability: a Correctness Criterion for Global Concurrency Control in InterBase , 1989, VLDB.

[7]  K. Mani Chandy,et al.  A distributed algorithm for detecting resource deadlocks in distributed systems , 1982, PODC '82.

[8]  Abraham Silberschatz,et al.  Deadlock problems in a multidatabase environment , 1991, COMPCON Spring '91 Digest of Papers.

[9]  Abraham Silberschatz,et al.  Reliable transaction management in a multidatabase system , 1990, SIGMOD '90.

[10]  Abraham Silberschatz,et al.  Multidatabase update issues , 1988, SIGMOD '88.

[11]  Weimin Du,et al.  Maintaining quasi serializability in multidatabase systems , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[12]  Ron Obermarck,et al.  Distributed deadlock detection algorithm , 1982, TODS.