Distributed transaction management for database systems with multiversioning
A distributed transaction and transaction management technology, applied in database distribution/replication, other database retrieval, structured data retrieval, etc.
Active Publication Date: 2014-07-23
MICROSOFT TECH LICENSING LLC
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
However, none of the proposed solutions for distributed databases with multiversioning can address all of the above needs, and such solutions are expected to significantly improve the performance of distributed database systems
[0005] The above-mentioned shortcomings of today's distributed transaction management technologies are only intended to provide an overview of some of the problems of conventional systems and are not intended to be exhaustive
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0026] overview
[0027] By way of introduction, a database system can facilitate the management of various associated data items through operations such as, but not limited to, data creation and maintenance, information retrieval, data access via search or other mechanisms, and the like. In some embodiments, a database system may provide various mechanisms to ensure the recoverability and integrity of associated data. For example, a database system may manage operations performed within the system (eg, associated with each transaction performed by the database system) to ensure that such operations produce correct results. By way of example and not limitation, a database system may include concurrency control mechanisms to ensure that transactions executed concurrently by the database system do not interfere with each other. Additionally, database systems may include various other mechanisms to ensure proper operation. As a non-limiting example, a database system may utiliz...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The present invention relates to distributed transaction management with multi-versioned database systems. The present invention relates to distributed transaction management techniques that ensure synchronization among participating nodes in global or distributed database transactions. The technique utilizes a commit protocol that uses local clocks at each participating node. Participants in a global transaction are configured to utilize the same commit timestamp and logical read time, and may advance their respective local clocks to establish this synchronization. In one embodiment, the distributed commit utilizes a modified version of the two-phase commit that includes an additional stage of collecting commit timestamp votes from participants. Additionally, the heartbeat mechanism can be used to establish loose synchronization between nodes. In another embodiment, a node responds to a remote transaction request by returning a list of nodes involved in generating the transaction result and the type of access used by those nodes, in addition to the transaction result itself.
Description
technical field [0001] The present invention relates to transaction management in database systems, and more particularly, to the handling of distributed transactions in database systems using multiversioning. Background technique [0002] Database systems can implement various mechanisms to ensure that transactions performed on the database system produce correct results. Specifically, the database system can implement a concurrency control mechanism to isolate multiple concurrently executing transactions from each other, and / or prevent these transactions from interfering with each other. However, while concurrency control mechanisms are useful for correctness, they add overhead and negatively affect system performance (eg, throughput and response time). A class of concurrency control mechanisms designed for systems with multiversioning, ie, database systems that can store multiple versions of a record, with different versions having non-overlapping validity intervals. ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F17/30371G06F17/30575G06F16/1865G06F16/27G06F16/275G06F16/951G06F16/2322G06F16/2365
Inventor P-A·拉森M·茨维林C·迪亚科努
Owner MICROSOFT TECH LICENSING LLC