Data flashback method and apparatus for database
A database and data technology, applied in the database field, can solve the problems of long time, low database recovery efficiency, and recovery time affecting users' access to the database, etc., and achieve the effect of high recovery efficiency and short time
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0060] Reference figure 1 , Shows a flowchart of the steps of a method for flashback of database data provided in the first embodiment of the present invention, which may specifically include:
[0061] Step S110: Receive a data recovery request; the data recovery request includes the first time corresponding to the misoperation of the database.
[0062] The embodiments of the present invention can be applied to restore data or tables for database misoperation. The database misoperation can be that a certain table in the database is deleted by mistake, or the data in a certain table is deleted by mistake, or some data is mistakenly added to the wrong table, etc. The embodiment of the present invention can be applied to a MySQL database.
[0063] Of course, the system structure of the embodiment of the present invention may include the architecture of a back-end database server and various front-end application service servers. Each application business developer can deploy their app...
Embodiment 2
[0124] Reference figure 2 , Shows a flowchart of the steps of a method for flashback of database data provided in the second embodiment of the present invention, which may specifically include:
[0125] Step S210: Receive a data recovery request; the data recovery request includes the first time corresponding to the misoperation of the database.
[0126] Step S220: Start a first process, the first process simulates the slave library of the database, and informs the database to return the operation record log corresponding to the misoperation part at the first time.
[0127] In the embodiment of the present invention, after receiving the data recovery request, the first process is started, and the first process simulates the slave database of the database according to the protocol of the master database (Master) and the database slave database (Slave) to slave the database The main library obtains the operation record log corresponding to the first misoperation part.
[0128] The slav...
Embodiment 3
[0143] Reference image 3 , Shows a schematic structural diagram of a database data flashback device provided in the third embodiment of the present invention, which may specifically include:
[0144] The recovery request receiving module 310 is adapted to receive a data recovery request; the data recovery request includes the first time corresponding to the misoperation of the database;
[0145] The operation record log obtaining module 320 is adapted to obtain the operation record log corresponding to the misoperation part of the first time from the operation record log of the database; the operation record log records non-query operations on the database in a row format ;
[0146] The parsing module 330 is adapted to analyze each line of operation corresponding to the misoperation from the operation record log;
[0147] The reverse operation module 340 is adapted to perform a reverse operation corresponding to the misoperation on the database starting from the last line of each lin...
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