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

Database backup and recovery method, apparatus and system

A database and data technology that applies redundancy in computing to data error detection and response error generation, and can solve problems such as long time intervals, unrecoverable data, and insecurity

Active Publication Date: 2016-03-30
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD +1
View PDF5 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when there is a problem with the database and the database needs to be restored, the above-mentioned database backup and restoration method can only restore the state of the database to the state of the latest full database backup time point before the target time point of database restoration. It takes a long time and consumes a lot of resources, so the time interval between two adjacent full backups is relatively long, and when a database recovery requirement occurs during the full backup, the latest complete database full backup data that can be obtained has been a long time ago, often As a result, a large amount of data from the database recovery target time point to the last database full backup time point before the database recovery target time point cannot be recovered, so the full backup method has many defects and unsafe factors

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
  • Database backup and recovery method, apparatus and system
  • Database backup and recovery method, apparatus and system
  • Database backup and recovery method, apparatus and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0085] An embodiment of the present invention provides a database backup and recovery system, the system includes: a full backup module, a record data generation module, a determination module, a full backup acquisition module and a recovery module, wherein,

[0086] The full backup module is used to perform a full backup of the database at each full backup time point according to the full backup time point of the database;

[0087] The record data generation module is used to generate record data between the time points of two adjacent full backups of the database, or to record the modification of the database throughout the process;

[0088] A determination module, configured to receive a database recovery instruction, and determine a recovery target time point of the database to be recovered;

[0089] A full backup acquisition module, configured to acquire full backup data at the latest full backup time of the database to be restored before the recovery target time point; ...

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

Embodiments of the present invention disclose a database backup and recovery method, apparatus and system. When recovering a to-be-recovered database, data recovery is performed on the to-be-recovered database by using full backup data of the last full backup time of the to-be-recovered database and record data of the to-be recovered database between the last full backup time and a recovery target time point. By applying the method, apparatus and system disclosed by the embodiments of the present invention, it is avoided that the data between the database recovery target time point and the last database full backup time point before the database recovery target time point is lost as when being recovered, the database is recovered by using only data of the last database full backup before the database recovery target time point when performing recovery on a database, only the last database full backup data before the database recovering target time point is used, the loss of the data between the database recovering target time point and the last database full backup time point before the database recovering target time point is avoided.

Description

technical field [0001] The invention relates to the technical field of computer information security, in particular to a database backup and recovery method, device and system. Background technique [0002] With the development of computer technology and Internet technology, the importance of information security is becoming more and more obvious. As an important content of information security, database is also paid more and more attention. A database is an organized and shareable collection of data stored in a computer for a long time. If the database is not backed up, then when an error occurs in the database, the database cannot be restored, resulting in the loss of database data, and the loss caused at this time is irreparable. [0003] A database backup and recovery method commonly used in the prior art is to pre-set the time point of full database backup. Full backup refers to a complete backup of the entire database. When there is a problem with the database, use...

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
IPC IPC(8): G06F11/14
Inventor 符玲亭
Owner BEIJING KINGSOFT CLOUD NETWORK 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