A transaction locking method, device, equipment, medium and product in a database
By acquiring and creating logical lock chains and physical locks, the problem of sequential locking during parallel database transactions is solved, enabling concurrent execution of multiple threads and improving transaction concurrency efficiency.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- SHANGHAI DAMENG DATABASE
- Filing Date
- 2026-06-01
- Publication Date
- 2026-07-17
AI Technical Summary
When database transactions are executed in parallel, the sequential execution of multiple threads due to the need to access the same lock chain can lead to a locking problem, which affects the efficiency of concurrent transaction execution.
By acquiring the logical lock chain and the current locking mode, it is determined whether the first physical lock exists as a lock of the specified type. If it does not exist, the specified physical lock is searched for or created in the global lock resources, and the corresponding logical lock is created for the thread to avoid locking through the transaction critical section.
It implements concurrent execution blocking of multiple transaction threads, avoiding mutual blocking between threads and improving the efficiency of concurrent transaction execution.
Smart Images
Figure CN122412431A_ABST