使用触发器的特殊乐观并发控制方法

Using Triggers Special Optimistic Concurrency Control Methods

针对传统的乐观并发方法在实际应用中,存在较多的事务撤销与重启,造成系统资源的浪费,提出了一种新的并发控制纠错方法,通过对访问数据库的过程进行监控和调整,以达到当有两个进程对数据库产生读写冲突时,通过此纠错方法使进程有较大概率不必重启也能使对数据的修改保持正确的目的。此纠错方法与网站的耦合度较高,监控和调整的过程依赖于触发器和表结构,主要用于应对多进程并发时造成丢失修改类数据的错误。

Optimistic concurrency method in practical applications and restart the revocation matters more waste of resources caused by the system,we propose a new concurrency control error correction method,through the process of accessing the database to monitor and adjust to achieve when there are two a process of making the database read-write conflicts generated through this correction method allows a greater probability of having to restart the process also enables modification of data to maintain the correct purposes.This error correction method with a high degree of coupling sites,monitor and adjust the process depends on the triggers and table structure,mainly used to address more complicated process caused by missing modify the class errors.