在多层结构中利用事务处理保证数据的一致性

Utilizing Transaction to Realize Data Consistency in Multi-tier Architecture

先分析了数据库管理系统中的事务处理,接着分析了多层结构及其在Delphi中的实现,最后以SQL SERVER和Delphi为例讨论如何在多层结构的各个层次上利用事务处理来实现数据的一致,既分别在客户端如何利用显式事务处理、在中间层如何利用隐式事务处理、在远程数据库服务器层如何利用触发器事务处理来实现数据一致。

It is firstly analyzed the transaction in database management system, and then analyzed multi-tier architecture and the realization of multi-tier architecture in Delphi. Finally it is discussed how to realize the consistency of data by utilizing the transaction in each tier of multi-tier architecture, that is, to realize the consistency of data, how to obviously utilize the transaction in client tier and how to secretly utilize the transaction in middle tier and how to utilize the transaction of trigger in remote database server.