一种使多库系统事务可串行化的方法

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

在多库系统中,各局部数据库高度自治,全局事务与局部事务相互影响,使事务管理面临新的挑战。本文提出一种子事务统一释放资源方法,并证明只要局部DBMS遵守两段封锁协议,这种方法可以保证多库系统中的事务可串行化,同时还讨论不可检测的全局死锁问题及其处理。

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.