An Approach to Ensuring Serializability of Concurrent Execution of Transactions in a Multidatabase System

In a multidatabase system composed of local databases with high autonomy,both global and local transactions interfere with each other.This adds new difficulty to transaction management. In this paper,we propose a simple approach to this problem,and show that,as long as the local DBMS’s obey 2PL protocol by making all the subtransactions of a global transaction release their resources only after all their operations have been done,the serializability of concurrent execution of transactions in the multidatabase system can be ensured.Also discussed are the undetectable global deadlock and its handling.