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

Method, device and system for restoring data

A recovery method and data technology, applied in the database field, can solve problems such as the inability to meet the needs of heterogeneous database disaster recovery systems, and achieve the effects of reducing the amount of operation log transmission, reducing the burden, and improving the speed of data recovery.

Inactive Publication Date: 2011-08-17
NAT UNIV OF DEFENSE TECH
View PDF5 Cites 55 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] In view of this, the present invention provides a data recovery method, device and system to overcome the problem that various data replication methods in the prior art cannot meet the requirements of heterogeneous database disaster recovery systems

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, device and system for restoring data
  • Method, device and system for restoring data
  • Method, device and system for restoring data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] For reference and clarity, descriptions, abbreviations or abbreviations of technical terms used in the following text are summarized as follows:

[0057] Transaction: refers to a program execution unit that accesses and possibly updates various data items in the database, usually caused by the execution of user programs written in advanced database manipulation languages ​​or programming languages ​​(such as SQL, C++ or Java);

[0058] SQL: Structured Query Language, Structured Query Language;

[0059] Commit: Commit the current transaction;

[0060] Rollback: abort the current transaction;

[0061] Cache: cache;

[0062] Export Process: transfer process;

[0063] Import Process: import process;

[0064] Queue: Queue.

[0065] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodimen...

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 discloses a method, a device and a system for restoring data. The method comprises the following steps of: acquiring all user operation requests, and storing the user operation requests into a restoring log in the form of operation logs; extracting reading operation records in the restoring log and analyzing the reading operation records so as to obtain operation sentences for updating a target disaster tolerant node database; receiving and combining the operation sentences belonging to the same work, gathering by a unit of the work, acquiring submittable work packets and transmitting the submittable work packets; and receiving the work packets sequentially and loading the work packets to the target disaster tolerant node database so as to restore the data. By the method, the problems that the consistency and the completeness of data recovery among disaster tolerant nodes of a heterogeneous database are poor are solved, the burdening on the network due to log transmission is relieved, and ineffective inquiring operation is avoided; therefore, the work packet loading efficiency is higher, and the data restoring speed of the target disaster tolerant node database is increased.

Description

technical field [0001] The present invention relates to the database field, and more specifically, relates to a method, device and system for data recovery based on operation log redo in a heterogeneous database disaster recovery system. Background technique [0002] Such as figure 1 As shown, the structure of the heterogeneous database-based disaster recovery system in the prior art consists of several data processing centers (disaster recovery nodes) distributed in the network, disaster recovery management system middleware and application clients. The disaster recovery system refers to an environment that can cope with various disasters provided for the computer information system. When the computer system suffers from irresistible natural disasters, as well as man-made disasters such as computer crimes, viruses, and human errors, the disaster recovery system will ensure the security of user data (data disaster recovery) and provide uninterrupted application services (ap...

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/14G06F17/30
Inventor 杨树强罗荣凌王怀民吴泉源贾焰周斌韩伟红滕猛陈志坤赵辉金松昌舒琦王凯
Owner NAT UNIV OF DEFENSE TECH
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