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

Method and system for recovering failure data in database

A technology of fault data and recovery method, applied in the field of data processing, can solve the problems of large disk space occupation, low recovery efficiency, low efficiency of appending full change logs, etc., so as to shorten the time required for recovery and improve efficiency.

Active Publication Date: 2016-03-02
BEIJING BAIDU NETCOM SCI & TECH CO LTD
View PDF3 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the large amount of data in the database, the above method will have the following problems in restoring the database: ① Low efficiency. Due to the large amount of data in the database, it is very slow to restore the full amount of data, and the efficiency of appending the full amount of change logs is also low, and the recovery efficiency is very low. ;②The cost of recovery is high. Because the full amount of data needs to be restored, it takes up a lot of disk space. It is often necessary to use additional machine resources to complete data recovery, and the data recovery process requires the full participation of database maintenance personnel, and the recovery cost is relatively high; ③Recovering data The granularity is single, and only supports recovery of all data at one time, and data recovery cannot be completed for the faulty data part

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
  • Method and system for recovering failure data in database
  • Method and system for recovering failure data in database
  • Method and system for recovering failure data in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0030] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0031] figure 1 It shows an exemplary system architecture 100 to which the method for recovering faulty data in a database or the system for recovering faulty data in a database of the present application can be applied.

[0032] like figure 1 As shown, the system architec...

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 present application discloses a method and a system for recovering failure data in a database. A specific embodiment of the method comprises the following steps: receiving recovery request information about failure data, wherein the recovery request information about the failure data comprises identification information and target recovery time information about the failure data; obtaining a backup file of the failure data from a first snapshoot of the database based on the identification information of the failure data; obtaining an incremental log of the failure data, wherein the incremental log of the failure data comprises change information about the failure data between snapshoot time of the first snapshoot and target recovery time in the target recovery time information; and recovering the failure data based on the backup file of the failure data and the incremental log of the failure data. According to the embodiment, the database can be recovered to the target recovery time rapidly.

Description

technical field [0001] The present application relates to the field of data processing, in particular to a recovery method and system for faulty data in a database. Background technique [0002] With the advent of the big data era, databases have become increasingly important. However, with the increase of database business iterations, the failure probability of the database also increases. The failure of the database will have a great impact on the business, so when the database fails, how to quickly and effectively restore the database becomes particularly important. [0003] At present, the industry often implements database recovery through full snapshots and manual appending of change logs. However, due to the large amount of data in the database, the above method will have the following problems in restoring the database: ① Low efficiency. Due to the large amount of data in the database, it is very slow to restore the full amount of data, and the efficiency of append...

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/14
CPCG06F11/1458G06F2201/84
Inventor 赵承勇王宗瑞王建勋
Owner BEIJING BAIDU NETCOM SCI & TECH CO LTD
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

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