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

Method and system for checking consistency of records in master and backup databases

A verification method and consistency technology, applied in the database field, can solve the problems of inaccurate verification and low verification efficiency, and achieve the effect of low cost and easy implementation

Inactive Publication Date: 2012-02-15
NAT COMP NETWORK & INFORMATION SECURITY MANAGEMENT CENT
View PDF3 Cites 37 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The technical problem to be solved by the present invention is to propose a kind of accurate verification and high verification efficiency for the record consistency of the primary and backup databases in view of the existing problems of either inaccurate verification or low verification efficiency in the prior art Calibration method and system

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 and system for checking consistency of records in master and backup databases
  • Method and system for checking consistency of records in master and backup databases
  • Method and system for checking consistency of records in master and backup databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments.

[0035] The first embodiment of the present invention provides a method for verifying the consistency of records in the primary and standby databases, such as figure 1 As shown, in this embodiment, the primary and secondary database record consistency verification method of the present invention specifically includes the following steps:

[0036] Step 101, before data backup, add an identification code field and a verification code field to each record, wherein the identification code field is the number of the record, which is used to identify the uniqueness of the record, and the verification code field is used to identify the characteristics of the record value . In this embodiment, a data table including these two fields can be added separately, as shown in Table 1.

[0037] Table 1. A data table containing an identification code...

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 for checking the consistency of records in master and backup databases. The method comprises the following steps of: adding an identification code field and a check code field into each record before data backup, wherein the identification code field is a recorded serial number of the record, and the check code field is used for identifying the character of a recording value; dividing the records into M segments within an inspection time slot, and calculating a check code in each segment, wherein M is a natural number; performing consistency check on the corresponding segments in the master and backup databases one by one; and if the checking is passed, determining that the records in the segments are consistent, and if the checking is not passed, checking the consistency of the records in the segments one by one to find the inconsistent records. By the method, the checking is accurate and the checking efficiency is high; and the method has the advantages of simple technical scheme, low cost and the like. The invention also discloses a system for checking the consistency of the records in the master and backup databases correspondingly. The system comprises a field addition module, a segment module and a consistency checking module.

Description

technical field [0001] The invention belongs to the technical field of databases, and in particular relates to a method and system for checking the consistency of records in a master database and a standby database. Background technique [0002] Database backup mainly solves the data security problem when the primary database fails. The backup program needs to synchronize the records in the primary database to the backup database according to the policy. According to the design of the backup system, the records in the primary and standby databases should be consistent. However, in practical applications, due to failures of the network, backup software, computer hardware or operating system, the records in the backup database may be inconsistent with the records in the main database, so it is necessary to check the records of the main and standby databases , to find inconsistent records in the primary and backup databases and repair them. [0003] In the prior art, the metho...

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/08G06F17/30
Inventor 徐倩华夏光升马捷李小标张鸿郝振江樊冬进
Owner NAT COMP NETWORK & INFORMATION SECURITY MANAGEMENT CENT
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com