首页>
外国专利>
CONCURRENCY CONTROL METHOD OF DATABASE TRANSACTION COMBINING OPTIMISTIC LOCK AND PESSIMISTIC LOCK
CONCURRENCY CONTROL METHOD OF DATABASE TRANSACTION COMBINING OPTIMISTIC LOCK AND PESSIMISTIC LOCK
展开▼
机译:数据库事务的并发控制方法结合乐观锁和悲观锁定
展开▼
页面导航
摘要
著录项
相似文献
摘要
A concurrency control method of database transaction combining an optimistic lock and a pessimistic lock includes: integrating a lock in each fragment in a storage range, using a lock table globally, and recording a lock status of the each fragment in the lock table; before reading a data object of a fragment in the storage range, first querying in the lock table whether the data object of the fragment is locked by other reading-writing transactions; if the data object of the fragment is locked by other reading-writing transactions, blocking the current reading operation, and repeating the current reading operation, and if the current reading operation is blocked for more than a given time limit, since the pessimistic lock is invalid, intervening by the optimistic lock, and continuing reading the single row data of the current fragment.
展开▼