Data backup and recovery method and device

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: 2015-11-25
TENCENT CLOUD COMPUTING BEIJING CO LTD
View PDF2 Cites 0 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 it is not suitable for fast recovery of data services. need

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

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0040] See image 3 , image 3 This is a flowchart of the data backup method provided by the first embodiment of the present invention. This embodiment can be applied to figure 1 In the application environment shown, through 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 of the unbacked up table in the database and its total number of rows;

[0042] 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 essence. According to the classification of information, a database may contain several data tables. In the 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 is preset in the server 100, and according to a preset backup strategy, the server 100 regula...

no. 2 example

[0057] See Figure 4 , Figure 4 This is a flowchart of the data backup method provided by the second embodiment of the present invention. This embodiment can be applied to figure 1 In the application environment shown, through 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: Read preset command line options;

[0059] 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 essence. According to the classification of information, a database may contain several data tables. In the 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 is preset in the server 100, and according to a preset backup strategy, the server 100 regularly backs up the data in the database. Or the serv...

no. 3 example

[0143] See Figure 8 , Figure 8 This is a flowchart of the data recovery method provided by the third embodiment of the present invention. This embodiment can be applied to figure 1 In the application environment shown, through 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 a backup metadata file;

[0145] In this embodiment, the backup metadata file may be stored in the memory of the server 100, or may be stored in the storage server 200 in the form of a compressed package. The server 100 obtains a 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 the table in the d...

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 and processing information through computers, while storing their most important information in the form of data files in the computer. In order to effectively manage these data files, database technology came into being. Data backup and recovery are 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 of the running database instance to other storage media. The data set includes but is not limited to table content, table structure, table functions, views, triggers, Stored procedures, etc. Data recovery refers to a form of using data backup to import data into the database to restore the content...

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/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