Data backup and recovery methods and devices

A data backup and backup technology, applied in the computer field, can solve the problems of incompetent fast recovery of data services and slow recovery, and achieve the effect of speeding up and improving efficiency

Active Publication Date: 2014-11-26
TENCENT CLOUD COMPUTING BEIJING CO LTD
View PDF2 Cites 36 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Existing database technology realizes data recovery by serially executing SQL (Structured Query Language, Structured Query Language) statements in the backup file, so the recovery speed is very slow in big data scenarios and cannot be used for fast data recovery. service needs

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 backup and recovery methods and devices
  • Data backup and recovery methods and devices
  • Data backup and recovery methods and devices

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0040] see image 3 , image 3 It is a flow chart of the data backup method provided by the first embodiment of the present invention. This embodiment can be applied to figure 1 shown in the application environment, by figure 1 The server 100 shown implements database-based data backup. Such as image 3 As shown, the data backup method provided in this embodiment includes:

[0041] Step S11, obtaining the size and total number of rows of tables not backed up in the database;

[0042] A table (or data table) is one of the most important components of a database. The database is just a framework, and the data table is its substance. According to the classification of information, a database may contain several data tables. In a data table, each column is a field, each row is a record, and each record contains all the information in this row.

[0043] In this embodiment, a database (Database) is preset in the server 100, and the server 100 regularly backs up data in the ...

no. 2 example

[0057] see Figure 4 , Figure 4 It is a flow chart of the data backup method provided by the second embodiment of the present invention. This embodiment can be applied to figure 1 shown in the application environment, by figure 1 The server 100 shown implements database-based data backup. Such as Figure 4 As shown, the data backup method provided in this embodiment includes:

[0058] Step S201, reading preset command line options;

[0059] A table (or data table) is one of the most important components of a database. The database is just a framework, and the data table is its substance. According to the classification of information, a database may contain several data tables. In a data table, each column is a field, each row is a record, and each record contains all the information in this row.

[0060] In this embodiment, a database (Database) is preset in the server 100, and the server 100 regularly backs up data in the database according to a preset backup polic...

no. 3 example

[0143] see Figure 8 , Figure 8It is a flow chart of the data recovery method provided by the third embodiment of the present invention. This example can be applied to figure 1 shown in the application environment, by figure 1 The server 100 shown implements database-based data recovery. Such as Figure 8 As shown, the data recovery method provided in this embodiment includes:

[0144] Step S31, obtaining the backup metadata file;

[0145] In this embodiment, the backup metadata file may be stored in the storage of the server 100, or may be stored in the storage server 200 in the form of a compressed package. The server 100 obtains the compressed package of the backup metadata file from the storage server 200, and decompresses the compressed package to obtain multiple backup metadata files contained therein.

[0146] Specifically, the backup metadata file may include, as a logical backup medium: a target fragment backup file corresponding to each fragment of a table in...

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 backup method. The data backup method comprises the steps that the size and the total line number of a table not backed up in a database are obtained; the target line number of given structural query language sentences contained in each fragment of the table which is not backed up is calculated according to the total line number and the value of a preset first instruction line option; when the size of the table not backed up is larger than or equal to the value of a preset second instruction line option, the table not backed up is divided into a plurality of fragments according to the total line number and the target line number, and a fragment backup file of each fragment is generated and output. The invention further provides a data recovery method, a data backup device and a data recovery device. The data backup and recovery methods and devices can improve the speed of data recovery and improve the efficiency of data processing.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data backup and recovery method and device. Background technique [0002] With the popularization and application of computers, people are becoming more and more accustomed to obtaining information and processing information through computers, and at the same time saving their most important information in the form of data files in computers. In order to manage these data files effectively, database technology emerges as the times require. Data backup and recovery is an important part of database technology. Among them, data backup refers to the process of copying all or part of the data set from the hard disk or array running the database instance to other storage media. The data set includes but not limited to table content, table structure, table function, view, trigger, Stored procedures, etc. Data recovery refers to a form of using data backup to import data into the ...

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
Inventor 张晨陈福荣唐祖州康中良梁飞龙崔玉明韩全安
Owner TENCENT CLOUD COMPUTING BEIJING CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap