Global Savepoint Queue for Distributed Database Transaction Coordination
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current technologies lack an efficient mechanism for transaction savepoint management in distributed databases, making it difficult to ensure simultaneous completion of logically-associated operations.
Innovation Solution
A transaction savepoint management apparatus and method that creates and maintains a global savepoint queue across multiple databases, coordinating local savepoints and reducing unnecessary rollback operations by associating and managing savepoints across the distributed system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Device complexity
If centralized database management is used, then transaction management is simple, but distributed database coordination is insufficient
Solution Approach 1:
The patent segments savepoint management into two levels: global savepoints managed by the transaction management device and local savepoints managed by individual databases. This segmentation allows distributed databases to maintain autonomous local control while coordinating through global savepoints, resolving the contradiction between management simplicity and coordination reliability.
Solution Approach 2:
The patent introduces a transaction management device as an intermediary that coordinates between multiple distributed databases. This intermediary maintains global savepoint queues and manages the association between global and local savepoints, enabling reliable distributed coordination without requiring complex peer-to-peer communication between all databases.
2Manufacturing precision
If local savepoints are created for each database operation, then savepoint granularity is fine, but system performance decreases due to excessive operations
Solution Approach 1:
The patent creates global savepoints in advance at the transaction management device before distributing them to local databases. This preliminary action reduces the need for frequent local savepoint creation operations, as local databases can associate with existing global savepoints rather than creating new local savepoints for every operation, thereby improving system performance while maintaining fine granularity where needed.
Solution Approach 2:
The patent merges multiple local savepoints into a single global savepoint representation in the transaction management device. By consolidating savepoint states across distributed databases into a unified global savepoint queue, the system reduces the total number of savepoint operations while preserving the ability to manage fine-grained local savepoints when necessary.
3Reliability
If global savepoint coordination is implemented across distributed databases, then transaction consistency is improved, but device complexity increases
Solution Approach 1:
The patent segments savepoint management responsibilities between the transaction management device (global savepoints) and individual databases (local savepoints). This segmentation reduces device complexity by distributing management functions rather than requiring a single centralized component to handle all savepoint operations across the distributed system.
Solution Approach 2:
The patent uses global savepoint information as a template or copy that is distributed to local databases. Instead of each database independently managing complex savepoint states, they receive and associate with standardized global savepoint representations, simplifying the overall management structure while ensuring transaction consistency across the distributed system.
Data Source
AI summary
Proposed are a transaction savepoint management apparatus and method, which may involve: creating, based on a transaction initiation request from a user terminal, a transaction, wherein the transaction includes a plurality of operation instructions, and subsequently accessing at least one of a plurality of databases so as to sequentially execute the plurality of operation instructions according to a time sequence; and if the plurality of operation instructions includes global savepoint establishment instruction, creating and maintaining a global savepoint queue to coordinate the plurality of databases and implement an operation for global savepoints, and based on the global savepoints, triggering a database, involved in this transaction, from among the plurality of databases to establish local savepoints and record an association relationship between each of the local savepoints and the global savepoints. The apparatus and method disclosed in the present invention can be used for transaction savepoint management for a distributed database.