Optimization method, device and system for target end concurrency in database synchronization
By using a thread ID array in database synchronization to determine and resolve concurrent conflicts at table entry operation locations, the conflict problem of concurrent execution between target transactions is resolved, thus improving the performance and efficiency of database synchronization.
CN119066081BActive Publication Date: 2026-06-23WUHAN DAMENG DATABASE
View PDF 2 Cites 0 Cited by
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- WUHAN DAMENG DATABASE
- Filing Date
- 2024-09-02
- Publication Date
- 2026-06-23
AI Technical Summary
Technical Problem
In database synchronization, conflicts can arise from concurrent execution of transactions on the target side, leading to performance degradation and deadlock issues that are difficult to handle effectively with existing technologies.
Method used
An array of thread IDs is used to represent the thread operating on the table entry and its operation position. By determining whether the operation position is occupied, accurate concurrency conflict judgment is achieved, and other threads are waited for or rolled back to resolve the conflict when necessary.
Benefits of technology
It improves the concurrent execution efficiency of the target side, reduces deadlocks, and enhances the performance of database synchronization.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN119066081B_ABST
Abstract
The present application relates to the technical field of database, and provides a method, device and system for optimizing target end concurrency in database synchronization, which comprises: setting a thread ID array for each table item, the thread ID array being used to represent threads operating the corresponding table item and operation positions in the table item operated by the threads; before a first thread executes a first operation on a first table item, judging whether the first operation position of the first table item is occupied by other threads according to the thread ID array of the first table item; wherein the first operation position is the operation position corresponding to the first operation; if the first operation position of the first table item is occupied by other threads, waiting for the first operation position to be released before executing the first operation. The present application accurately judges the position of the conflict of concurrent execution, i.e. each operation position in the table item, so as to solve the conflict problem of concurrent execution on the basis of improving the efficiency of thread concurrent execution.
Need to check novelty before this filing date? Find Prior Art