Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data rollback method, system and equipment and computer readable storage medium

A data rollback and data technology, applied in the database field, can solve problems such as low performance of database rollback

Pending Publication Date: 2019-07-16
金篆信科有限责任公司
View PDF8 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved by the present invention is to provide a data rollback method, system, device and computer-readable storage medium to overcome the problem of low rollback performance of databases participating in distributed transactions in the prior art

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
  • Data rollback method, system and equipment and computer readable storage medium
  • Data rollback method, system and equipment and computer readable storage medium
  • Data rollback method, system and equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0083] In the first embodiment of the present invention, a data rollback method, such as figure 1 shown, including the following specific steps:

[0084] Step S101 , if any database data operation corresponding to the transaction fails, all transaction logs corresponding to the transaction are acquired according to the pre-generated transaction log index information corresponding to the transaction.

[0085] Among them, transaction (Transaction) is a program execution unit (unit) that operates various data in the database; transaction is usually performed through advanced database manipulation language or programming language (for example: SQL (Structured Query Language, structured query language), C++ or Java ) set of program statements written; transactions include: a set of all program statements executed between the start of a transaction (begintransaction) and the end of a transaction (end transaction).

[0086] In some embodiments of the present invention, the data oper...

no. 2 example

[0095] In the second embodiment of the present invention, a data rollback method, such as figure 1 shown, including the following specific steps:

[0096] Step S101 , if any database data operation corresponding to the transaction fails, all transaction logs corresponding to the transaction are acquired according to the pre-generated transaction log index information corresponding to the transaction.

[0097] Optionally, step S101 includes:

[0098] When any database data operation corresponding to the transaction fails, or a data rollback instruction corresponding to the transaction is received, all transaction logs corresponding to the transaction are obtained according to the pre-generated transaction log index information corresponding to the transaction.

[0099] In some embodiments of the present invention, according to the pre-generated transaction log index information corresponding to the transaction, the ways to obtain all transaction logs corresponding to the trans...

no. 3 example

[0148] In the third embodiment of the present invention, a data rollback system, such as figure 2 shown, including the following components:

[0149] The transaction manager 100 is configured to send a data rollback request to the resource manager 200 when any data operation of any database 300 corresponding to the transaction fails.

[0150] Optionally, the transaction manager 100 is configured to send a data rollback request to the resource manager 200 when the data operation of any database 300 corresponding to the transaction fails, or a data rollback instruction corresponding to the transaction is received.

[0151] The resource manager 200 is configured to obtain all transaction logs corresponding to the transaction according to the transaction log index information corresponding to the transaction generated in advance when receiving the data rollback request sent by the transaction manager 100; according to all transaction logs corresponding to the transaction, The ro...

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 data rollback method which comprises the following steps: under the condition that any database data operation corresponding to a transaction fails, obtaining all transactionlogs corresponding to the transaction according to pre-generated transaction log index information corresponding to the transaction; and according to all transaction logs corresponding to the transaction, concurrently executing a rollback operation of submitting data of all databases corresponding to the transaction. The invention further discloses a data rollback system and device and a computerreadable storage medium, and by implementing the scheme, the rollback speed and the rollback efficiency of the data in the database can be effectively improved; and meanwhile, by binding variables, the security of the data, the rollback speed of the data and the rollback efficiency of the data can be effectively improved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a data rollback method, system, device and computer-readable storage medium. Background technique [0002] Distributed transaction processing involves multiple databases distributed in different places, but for the operation of databases participating in the transaction, all databases must be submitted or rolled back. As long as the operation of any database fails, all databases participating in the transaction will be A rollback is required. Existing distributed transaction processing mainly includes the following two types: [0003] A rollback method based on the XA protocol. The XA protocol is the interface standard between the resource manager and the transaction manager. The XA protocol includes: application program (AP, Application Program), transaction manager (TM, Transaction Manager) and resource manager (RM , Resource Manager). Wherein, the application prog...

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): G06F16/172G06F16/17G06F16/176
CPCG06F16/1734G06F16/172G06F16/1767G06F16/27G06F16/2365
Inventor 干荣亮张鹏郭龙波
Owner 金篆信科有限责任公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products