A Data Consistency Checking Method for Cross-Computer Room Databases

A database and consistency technology, applied in the field of online data interaction of multiple databases, can solve the problems of repeated query data, automatic timing check without data, and stay consistency check, etc., to improve the resolution speed, improve automation and customization , the effect of small cost
CN107832383BActive Publication Date: 2019-02-05FOCUS TECH
9 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN ยท China
Patent Type
Patents(China)
Current Assignee / Owner
FOCUS TECH
Publication Date
2019-02-05

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

A method for data consistency verification across a computer room database, comprising: 1: setting of a consistency verification environment, specifically: deploying a master node database and a subnode database in computer rooms in various regions, and each database is provided with The same table structure; 2) Configure the verification task information. The verification task information includes the frequency of verification execution, the database tables with verification requirements, and the table fields with verification requirements; 3) According to the frequency of verification execution, each After a fixed period of time, the master node database actively triggers the verification task; 4) After each subnode database receives the verification task information, it extracts the database, data table and table field information instructions in the information; 5) The master node database keeps receiving the information The status of the data sent by each sub-node database, while receiving the verification results, compare the verification results, and determine whether the verification results of each sub-node are consistent.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention belongs to the field of online data interaction of multiple databases, and in particular relates to a data consistency verification method for cross-computer room databases. Background technique

[0002] With the development of the B2B e-commerce industry, there are more and more Internet service businesses, and the user base is also increasing. In order to ensure the reliability, the website will be deployed in computer rooms in different regions, and the database system will be deployed in each computer room. , and provide a complete website service, and the data between the databases of each computer room is copied to each other to ensure that each computer room has a complete set of data. However, the biggest challenge of multi-computer rooms is the data update delay caused by network delay between the computer rooms, which eventually leads to data inconsistency between the databases of each computer room. In the existing master-stan...

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