Method of internal data base main-spare synchronous

A database and memory technology, applied in synchronization devices, digital transmission systems, electrical components, etc., can solve problems such as wasting space and losing data, and achieve the effect of avoiding dropped calls and improving operating speed

Inactive Publication Date: 2005-01-05
ZTE CORP
View PDF1 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The technical solution described in this patent writes all the changed data into the buffer when the master and backup are synchronized. It is quite large, and the buffer is equally large, which will undoubtedly waste space; if the size of the buffer is smaller than the database, there will be a possibility of data loss

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 of internal data base main-spare synchronous
  • Method of internal data base main-spare synchronous
  • Method of internal data base main-spare synchronous

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The present invention will be further described in detail below with reference to the drawings and embodiments.

[0030] Fig. 1 is the main flow chart of the technical scheme of the present invention. As shown in Figure 1, the method for synchronization between master and backup of a memory database proposed by the present invention includes the following steps: (1) Initialize the out-of-step image registration area, out-of-step image area, out-of-step queue and transmission data control area of ​​the database. In the present invention, the following data structure is created:

[0031] Out-of-sync image registration area: used to record all the relevant attributes and operation methods of the tables that may be synchronized;

[0032] Out-of-step image area: It is composed of out-of-step flag and segmentation label fields. The out-of-step flag is used to store the type of record change in the table. When the record is modified, the segmentation label is used to store the cha...

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

This invention discloses a method for synchnizing master and backup in a memory data bases including: initializing the database, registering lists being synchronized in the database in an out-of-step image registration region and initializing the corresponding out-of-step image region and queues, writing the vary number of the wary list into corresponding out-of-step queue of related lists and register the varlance in a related out-of-stop, bundling and sending the out-of-step registration to the receive end data base and canceling the related registration in the out-of-step image region and out-of-step queue. The receive end data base receives data and refreshes related list register to return back the answered information to continue synchronizing other out-of-step data.

Description

Technical field [0001] The invention relates to database backup technology, in particular to a method for synchronously recovering a database. Background technique [0002] The main technique for dealing with catastrophic failures is database backup. Normally, all databases and logs are periodically backed up on cheap storage media. When the system encounters a catastrophic failure, you can reload the database from the most recent backup and start the system. [0003] In order to avoid losing all updates since the last backup, it is usually necessary to back up the system log to a backup storage medium at a higher frequency. Since the system log is much smaller than the database, it can be backed up more frequently. In this way, the user will not lose all the transactions since the last backup. The database can be restored to the state at the time of the crash by recovering all committed transactions in the log. In addition, a new log must be started every time the database is ba...

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 Applications(China)
IPC IPC(8): H04B1/74H04L7/00
Inventor 肖旸周晶陈于锋
Owner ZTE CORP
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