Data recovering method and device

A data recovery technology, applied in the field of data processing, can solve problems such as occupation, increased number of disk reads and writes, and low response speed of the database

Active Publication Date: 2013-11-27
HUAWEI CLOUD COMPUTING TECH CO LTD
View PDF3 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the above-mentioned data recovery, the inventor finds that there are at least the following problems in the prior art: according to the log, the data files in the disk need to be accessed once for the data pages involved in the log file. The number of reads and writes of the disk,

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0089] 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 embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0090] At present, in the database recovery technology, the most commonly used recovery technology is based on the write-ahead logging (WAL for short) log. It can be applied to other transaction processing systems based on data pages and using physical log redo, and the present invention is not particularly limited.

[0091] The embodiment of the present invention provides a method for data recovery, and the method is applied in a server with database management fu...

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 data recovering method and device, which can solve the problem that the performance of a database is low as a data file is frequently read from a magnetic disk in a database recovering process, and the problem that a database recovering speed is slow as continuous logs correspond to discontinuous data pages. The method comprises the following steps: obtaining at least one log from a recovering starting point in a log file; generating a virtual data page according to each Redo log in the at least one log, wherein the virtual data page is used for representing a data page obtained by redoing according to the Redo logs; and combining each virtual data page with a corresponding original data page to be recovered in the magnetic disk according to a storage sequence of the original data page to be recovered to obtain the recovered original data page. The data recovering method and device disclosed by the invention are mainly applied to the database recovering process.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data recovery method and device. Background technique [0002] At present, the database has been widely used. During the operation of the database, the database may be shut down unexpectedly due to unexpected reasons such as power outages and crashes. At this time, the database needs to be restored. [0003] In the prior art, when an operation is performed on a data file of a database, the operation is recorded to form a log and stored in the log file. Log files are stored on disk together with data files (data pages). The modification of the data file according to the operation instruction is performed in the memory. After the memory processes the data page according to the operation instruction, a dirty page will be generated. The dirty page is a data page that has been modified but not yet stored in the disk. The operation of storing the log file to the disk is pri...

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 HUAWEI CLOUD COMPUTING TECH 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