Database transaction management method and device and database transaction recovery method and device
A transaction management and database technology, applied in the field of automatic program design, can solve the problems of large transaction log data volume and long transaction recovery time, and achieve the effect of reducing data volume and fast transaction recovery
Pending Publication Date: 2022-01-28
CCB FINTECH CO LTD
View PDF0 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] This article is used to solve the problem that there is a large amount of data in the transaction log in the prior art, and when the database fails and the data is restored based on the transaction log, there is a problem that transaction recovery takes a long time
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
[0099] The following will clearly and completely describe the technical solutions in the embodiments herein in conjunction with the accompanying drawings in the embodiments herein. Obviously, the described embodiments are only some of the embodiments herein, not all of them. Based on the embodiments herein, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts fall within the scope of protection herein.
[0100] It should be noted that the terms "first" and "second" in the description and claims herein and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments herein described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", as well as any variations ...
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 invention provides a database transaction management method and device and a database transaction recovery method and device. The database transaction management method comprises the steps of when a current read transaction is processed, determining a virtual identifier of a current read transaction according to a latest transaction identifier of the current read transaction and a first preset identifier generation rule, wherein the virtual identifier of the current read transaction comprises a latest write transaction identifier and a sub-identifier of the current read transaction; scanning each write transaction record in a transaction log, determining whether the write transaction record is visible to the current read transaction according to the write transaction identifier in the write transaction record, the virtual identifier of the current read transaction and the isolation level of the current read transaction, and if the write transaction record is visible to the current read transaction, reading a data block corresponding to the write transaction record from a database. According to the present invention, the data volume of the transaction log is reduced to a great extent, and when the database fails, the transaction can be quickly recovered by scanning the transaction log.
Description
technical field [0001] This article relates to the field of automatic program design, in particular to a database transaction management method and device, and a recovery method and device. Background technique [0002] A transaction is an important concept in a database system. A transaction in a database system is a collection of operations that constitute a single logical unit of work. It can contain one or more operations, and these operations are logically integrated. These database operations are either all Execute successfully, or none at all. A database transaction is a sequence of one or more operations distributed across corresponding nodes in the network. [0003] In actual use, a distributed database system may encounter a series of unexpected failures, which may make the transaction unable to commit (Commit) or roll back (Rollback), these failures usually include: 1) such as power failure, CPU, etc. System failures including hardware failures, operating system...
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 Applications(China)
IPC IPC(8): G06F16/2455G06F16/23G06F16/27
CPCG06F16/24552G06F16/23G06F16/27
Inventor 洪毅清吕文栋王一洲蔡淑莲
Owner CCB FINTECH CO LTD