Unlock instant, AI-driven research and patent intelligence for your innovation.

Data recovery method and device in database

A database and data technology, applied in the field of database storage, can solve the problems of time-consuming, complex operation, and low recovery efficiency, and achieve the effects of improving efficiency, reducing data volume, and shortening processing time.

Active Publication Date: 2019-03-01
BEIJING QIHOO TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In order to restore a piece of data, it is necessary to operate the entire amount of data. The operation is complex and time-consuming, and the recovery efficiency is extremely low.

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 recovery method and device in database
  • Data recovery method and device in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0023] figure 1 A schematic flowchart of a method for restoring data in a database according to an embodiment of the present invention is shown. This method is used to restore the data in the database based on the backup file of the database, such as figure 1 As shown, the method includes the following steps:

[0024] In step S101, the identifier of the table to which the data to be restored belongs is acquired.

[0025] This em...

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 invention discloses a method and apparatus for recovering data in a database. The method comprises the steps of obtaining identification of a table to which to-be-recovered data belong; copying a common metadata compressed file and a compressed file corresponding to the table from a backup file according to the identification of the table; decompressing the common metadata compressed file and the compressed file corresponding to the table, and obtaining a common metadata file and a table file; and reading the common metadata file and the table file, searching backup data corresponding to the to-be-recovered data, and storing the backup data into the database. Compared with the prior art, all data are not required to be copied and decompressed, only the compressed file of the table and the common metadata compressed file are required to be processed, processed data bulk is largely decreased, corresponding processing time is also largely shortened, and therefore data recovery efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of database storage, in particular to a method and device for restoring data in a database. Background technique [0002] Database backup is the basis of disaster recovery. It refers to the process of copying all or part of the data set from the hard disk or array of the application host to other storage media in order to prevent data loss caused by system operation errors or system failures. Especially in some industries that require high data reliability such as banking, securities, telecommunications, etc., if unexpected downtime or data loss occurs, the loss will be very heavy. For this reason, database administrators should formulate detailed database backup and disaster recovery strategies according to specific business requirements, and conduct strict tests on every possible situation by simulating faults. Only in this way can high availability of data be guaranteed. The backup of the database is a l...

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 Patents(China)
IPC IPC(8): G06F11/14G06F16/27
CPCG06F11/1448G06F16/27
Inventor 李丹
Owner BEIJING QIHOO TECH CO LTD