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
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com