一种分布式多数据库系统结构的提交缓冲设计

The Committing Buffer Design of A Distributed Multidatabase System Architecture

首先给出了一种分布式多数据库系统结构的事务提交流程 ,其次对数据通讯的发送缓冲和接收缓冲进行了数据库设计 ,对其中的关系进行了描述。对于发送缓冲 ,它以事务、节点和SQL语序的顺序排序并传输 ,接收缓冲以同样的顺序存放并以子事务为基本单位执行。对构造回滚SQL做了语法分析和举例说明 ,最后简述了本系统所使用的通讯协议和调用方式。

This paper first provides the transaction committing flow chart of a distributed multidatabase system architecture. Then it gives the database design of the sending buffer and receiving buffer, and describes the relations among the tables. The data in the sending buffer is sorted by global transaction, site and SQL order; and the data in the receiving buffer is stored as the same order and is packed to execute under the basic unit the sub-transaction of the physical site. It also presents the ways of building rollback SQL and some examples. Finally it simply describes the communication protocol and the way to use.