Database execution error recovery method and device and database access method and device

An error recovery and database technology, applied in the computer field, to achieve the effect of quickly rolling back operations and ensuring atomicity

Active Publication Date: 2020-05-22
YUSUR TECH CO LTD
View PDF10 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the transaction satisfies atomicity, there are only two results in the end: one is that account A decreases by 100 yuan, account B increases by 100 yuan, and user A transfers 100 yuan to user B successfully; the other is that both A and B There is no change in the account, and user A fails to transfer 100 yuan to user B

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database execution error recovery method and device and database access method and device
  • Database execution error recovery method and device and database access method and device
  • Database execution error recovery method and device and database access method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0028] It should be noted in advance that the descriptions of the following embodiments or examples or the features mentioned therein can be combined with the features in other embodiments or examples in the same or similar manner, or replace the features in other embodiments or examples , to form a possible implementation. In addition, the term "comprising / comprising" used herein refers to the presence of features, elements, steps or components, but does not exclude the presence of one or more other features, elements, steps or components.

[0029] When the database...

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

No PUM Login to view more

Abstract

The invention provides a database execution error recovery method and device and a database access method and device, and the recovery method comprises the steps: searching a node, with the executivedegree being zero, in a calculation flow graph executed by a database when an error occurs in database execution; searching all executed nodes of an SQL statement to which the node of which the out-degree is zero belongs in the calculation flow graph executed by the database; modifying a node of the SQL statement according to the attribute of the SQL statement so as to eliminate the influence of the node executing the SQL statement on the database; and outputting a computational flow graph of the SQL statement after the node modification, so that the database realizes rollback by executing thecomputational flow graph of the SQL statement after the node modification. Through the scheme, the transaction atomicity of database operation can be ensured.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database execution error recovery method, a database access method and a device. Background technique [0002] Transactions have the characteristics of atomicity, consistency, isolation and durability. The so-called atomicity means that the entire process of the transaction is like an atomic operation, and eventually either all succeed or all fail. This atomicity is seen from the final result, and the whole process is indivisible from the final result. A transaction in a database refers to a batch of operations performed on the database. These operations will either all succeed or fail in the end, and there will be no partial success. [0003] For example, user A transfers 100 yuan to user B. The operation process includes debiting 100 yuan from account A and adding 100 yuan to account B. If the transaction satisfies atomicity, there are only two results in the end: one is...

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
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F16/242G06F16/2455
CPCG06F11/1469G06F11/1471G06F16/2433G06F16/2455
Inventor 鄢贵海陈宇豪龚施俊
Owner YUSUR TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products