Asynchronous Transaction Commitment in Federated Database Systems

• Main Authors: HWANG, San-Yih, LIM, Ee Peng, SRIVASTAVA, Jaideep
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1993
• Subjects: Databases and Information Systems; Numerical Analysis and Scientific Computing
• Online Access: https://ink.library.smu.edu.sg/sis_research/909; https://ink.library.smu.edu.sg/context/sis_research/article/1908/viewcontent/AsychronousTransactionCommitmentFedDB_1993.pdf
• Institution: Singapore Management University

We propose a new (and restricted) model for global transactions which allows asynchronous commitment of subtransactions. Our model requires each global transaction to have a fixed structure with update to the data in at most one database. Based on this transaction model, we present two concurrency control algorithms, namely Asynchronous Site Graph and Asynchronous VirtGlobalSG, which employ asynchronous commitment and achieve global serializability. Compared to other proposed algorithms, our algorithms employ asynchronous commitment so as to increase transaction performance. Furthermore, our algorithms do not put restrictions on transaction data access or local histories.