Rapid data recovery method for memory database

A recovery method and memory data technology, which are applied in electrical digital data processing, special data processing applications, error detection of redundant data in operations, etc. time consuming effect

Inactive Publication Date: 2012-07-25
北京思特奇信息技术股份有限公司
View PDF2 Cites 32 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since the SQL statement itself needs to be parsed, and the records that need to be operated are searched again in the memory,

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
  • Rapid data recovery method for memory database
  • Rapid data recovery method for memory database
  • Rapid data recovery method for memory database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0017] The fast data recovery method of memory database of the present invention comprises the following steps:

[0018] Step 1: When the in-memory database is running normally, write all the in-memory data into full files at regular intervals;

[0019] Step 2: Every time the external application adds, deletes, or modifies the memory database, it immediately writes the operation log into the incremental file;

[0020] Step 3: Once the in-memory database stops abnormally, when the in-memory database restarts, first load the latest full amount of files into the memory;

[0021] Step 4: Then add all incremental log records after the time point of the full file to the memory one by one in order, and finally restore the...

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 relates to a rapid data recovery method for a memory database. All memory data are lost if the memory database is abnormally interrupted for various reasons. Firstly, when the memory database normally runs, all the memory data are written into a specified file (full file) at regular intervals (such as every one day or one hour); secondly, when an external application program adds or deletes the data for the memory database, operated flow logs are immediately written into an incremental file including a memory coordinate corresponding to each change record; thirdly, when in restart once the memory database abnormally stops, the most recently full file is loaded into a memory; and fourthly, all incremental log records after a time point of the full file are sequentially and additionally loaded into the memory one by one, and finally the data are restored into a state before abnormity. As the flow log operated by each record contains coordinate information, the record can be rapidly positioned in the memory, and rapid recovery is realized.

Description

technical field [0001] The invention relates to a fast data recovery method for a memory database, which is used to solve the problem that when the memory database is abnormal and the memory data is lost, the method can quickly restore data from a disk file to ensure that the data is not lost. Background technique [0002] With the continuous development of the telecommunications industry and the financial industry, the business expansion is getting wider and wider, various new services emerge in an endless stream, the data volume is also increasing, and the response speed requirements for data access are also getting higher and higher. A large amount of user profile data and user consumption data need to be stored in the memory database, but due to the non-persistence of the memory, once the memory database process or the host stops abnormally, all the data in the memory will be lost. After the in-memory database is restarted, how to ensure that the data can be restored to ...

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 北京思特奇信息技术股份有限公司
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