Global Transaction Termination Rules in Composite Database Systems

In composite database systems, global transactions are decomposed by the global transaction manager into several global subtransactions that are executed at the corresponding component database systems. This paper shows that the execution and termination of a global transaction depend on the specified extensional assertions on the local classes as well as on the given kinds of global requests. In some cases, a global transaction is supposed to be successful if exactly one global subtransaction is successfully executed. In other cases, all global subtransactions have to be successful in order to commit the global transaction. We discuss various termination rules for global transactions and thus provide new insights into a complex problem.

[1]  Jim Gray,et al.  Notes on Data Base Operating Systems , 1978, Advanced Course: Operating Systems.

[2]  Amit P. Sheth,et al.  Using Tickets to Enforce the Serializability of Multidatabase Transactions , 1994, IEEE Trans. Knowl. Data Eng..

[3]  Gunter Saake,et al.  Integrating Execution Dependencies into the Transaction Closure Framework , 1999, Int. J. Cooperative Inf. Syst..

[4]  Gunter Saake,et al.  Extending Transaction Closures by N-ary Termination Dependencies , 1998, ADBIS.

[5]  Ahmed K. Elmagarmid,et al.  Global Committability in Multidatabase Systems , 1996, IEEE Trans. Knowl. Data Eng..

[6]  Bruce G. Lindsay,et al.  Transaction management in the R* distributed database management system , 1986, TODS.

[7]  Ingo Schmitt,et al.  Considering Integrity Constraints During Federated Database Design , 1998, BNCOD.

[8]  Thomas C. Rakow,et al.  Atomic commitment for integrated database systems , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[9]  J.G. Mullen,et al.  On the impossibility of atomic commitment in multidatabase systems , 1992, Proceedings of the Second International Conference on Systems Integration.

[10]  Gunter Saake,et al.  Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration , 1999, ADBIS.

[11]  A. Elmagarmid.  Database transaction models for advanced applications , 1992 .

[12]  Brian Randell,et al.  Operating Systems, An Advanced Course , 1978 .

[13]  Rajeev Rastogi,et al.  Ensuring transaction atomicity in multidatabase systems , 1992, PODS.

[14]  Abraham Silberschatz,et al.  Failure-resilient transaction management in multidatabase , 1991, Computer.

[15]  Jari Veijalainen,et al.  Prepare and commit certification for decentralized transaction management in rigorous heterogeneous multidatabases , 1992, [1992] Eighth International Conference on Data Engineering.