Device and method for quickly comparing table data in active-active database

Abstract

The invention discloses a device and method for quickly comparing table data in an active-active database. and the device comprises an extraction module which is used for extracting the table data ofto-be-compared data tables in a source end database and a target end database, and transmitting the extracted table data to-be-compared table data organized according to a preset comparison statementrule to a comparison control module; a comparison pool used for distinguishing and storing inconsistent table data in to-be-compared data tables of the source end database and the target end database; a comparison control module used for analyzing the content of the obtained to-be-compared table data, judging a data source of the to-be-compared table data, traversing data records opposite to thedata source in the comparison pool according to a judgment result, matching the data records, and inserting or deleting the data records of the to-be-compared table data in the comparison pool according to a matching result; and a comparison result output module used for outputting and displaying the remaining records of the comparison pool after the comparison control module compares all to-be-compared table data of the source end database with all to-be-compared table data of the target end database.

Description

technical field [0001] The invention relates to the field of active-active backup and disaster recovery of a database management system, in particular to a device and method for quickly comparing table data in an active-active database. Background technique [0002] With the rapid development of information technology, information systems have become the key to maintaining business operations. Enterprises urgently need to improve the availability of information systems, ensure business continuity, and minimize losses caused by disasters or failures. On the other hand, diversified business types have led to increasingly complex data access requirements, and the sharp increase in data volume has also caused the database server to be overwhelmed. Enterprises also urgently need to improve the operating efficiency of information systems. At present, the disaster recovery solution of the active-active data center is commonly used to solve the system disaster recovery problem to im...

AI Technical Summary

Problems solved by technology

[0005] When unexpected events occur, such as insufficient monitoring technology, unhealthy system platform, and interruption of network fluctuations in the two data centers, the business system integrated with the two data centers will split into two independent data centers, making users It is difficult to tell which data center's data is correct; when data synchronization fails or is lost, check the out-of-sync data or lost data in a large amount of data according to the current log troubleshooting method, the checking efficiency is low and accurate lower sex

Images