Method and system for verification of consistency of backup data of host database and backup database

A database and consistency technology, applied in the field of computer information, can solve problems such as unfavorable data security audit, no backup operation record table, etc., and achieve the effect of benefiting security audit, improving verification speed, and improving efficiency

Active Publication Date: 2014-09-03
ZHENGZHOU IMAN TECH DEV +1
View PDF5 Cites 34 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method does not use a quick search method when performing verification and verification, and is not suitable for massive data consistency verific

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 verification of consistency of backup data of host database and backup database
  • Method and system for verification of consistency of backup data of host database and backup database
  • Method and system for verification of consistency of backup data of host database and backup database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] A method for checking and backing up data consistency of primary and secondary databases, comprising the following steps:

[0034] ①. Read the data in the active database and the standby database, and use the MD5 information digest algorithm to hash the data in the active database and the standby database one by one.

[0035] Such as figure 1 As shown, determine the business primary key of the resource object according to the business, read each record in the primary database in turn, extract its business primary key value and the value of the entire record, and use the MD5 information digest algorithm to compare the business primary key value with its corresponding The value of the entire record is converted into an MD5 hash value, which is stored in the main database business primary key value string array TS1 and the entire record value string array TS2 of the active database;

[0036] Using the same data reading method as above, store the MD5 hash value in the stan...

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

A method for verification of consistency of backup data of a host database and a backup database comprises the steps of (1) reading the data of the host database and the backup database, and hashing the data in the host database and the backup database one by one by means of the MD5 informative abstract algorithm; (2) comparing the MD5 hashed value of the data in the host database with the MD5 hashed value of the data in the backup database by means of the quick search algorithm, and generating a comparison result LOG file by means of the labeling method; (3) acquiring corresponding service data in the host database according to the comparison result LOG file, and updating the service data to the comparison result LOG file; (4) achieving incremental backup of the backup database and updating of a backup operation LOG sheet of the backup database simultaneously according to the LOG file. According to the method, by conducting MD5 hashing on the host database and the backup database and comparing the two MD5 hashed values by means of the binary quick search algorithm, verification efficiency is improved, and mass backup data consistency verification efficiency is improved.

Description

technical field [0001] The invention relates to the field of computer information technology, in particular to a method for checking and backing up data consistency of master and backup databases. Background technique [0002] With the wide application of information technology, various institutions or units have established multiple IT systems. Due to the division of management of these IT systems or different integration manufacturers, many key business data often exist for audit considerations. The same data needs to be stored on the master side and the replica side respectively. The business data of the master side (i.e. the master database) is usually used by the IT system of the business data producer, while the business data of the copy side (i.e. the backup database) ) is usually owned by the IT system of the consumer of business data, and the backup database needs to be consistent with the main database on a regular basis to maintain the correctness of the business ...

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): G06F17/30G06F11/14
CPCG06F11/1448G06F16/2365
Inventor 石瑞生段现辉石瑞军秦英岳修垒范文明
Owner ZHENGZHOU IMAN TECH DEV
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