基于排序的避免死锁的方法

An approach to avoid a deadlock database by batch updating records

针对多数据库事务下批量更新记录时产生死锁的问题,提出了一种新的数据更新方法。这种处理方法采用预先对要批量更新的记录进行排序,使所有的记录都能按某一个固定的顺序被更新,从而避免产生数据库死锁。

An avoiding dead lock method for updating a set of records under multi events for a database is presented.To avoid the dead lock in database,this method firstly sequences those records that need to be updated,then updates such records upon this sequencing and It works well.