Method, device and storage medium for checking consistency of business data in multiple databases

Abstract

The present invention discloses a method, device and storage medium for checking the consistency of business data in multiple databases. The method includes: using a first independent thread to sequentially search in the first database for the business dimension information of a certain business dimension of each company. Record information of preset conditions, write the record information into the first storage space; use the second independent thread to obtain the latest record information in the first storage space according to the preset frequency, and obtain it from the second database The record information with the same company and the same business dimension as the latest record information is written into the second storage space; a third independent thread is used to obtain the result record, and the result record is written into the third storage space. Compared with the prior art, the inspection method of the present invention can quantify the inspection results of data consistency, monitor and manage fluctuations in data consistency in real time, and provide a basis for discovering systematic problems.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method, device and storage medium for checking the consistency of business data of multiple databases. Background technique [0002] A database is "a warehouse that organizes, stores and manages data according to its data structure". In daily work, it is often necessary to put some relevant data into such a "warehouse" and perform corresponding processing according to management needs. For example, the personnel department of an enterprise or institution often needs to store the basic information of its employees (employee number, name, age, gender, place of origin, salary, resume, etc.) in a table, and this table can be regarded as a database . With this "data warehouse", you can check the basic situation of a certain employee at any time as needed, and you can also check the number of employees whose salary is within a certain range, etc. [0003] A relatively complete d...

AI Technical Summary

Problems solved by technology

This data inconsistency may be caused by systemic problems, such as network congestion, equipment failure, or problems with the program itself that writes to the database.

[0005] However, the inconsistency information detected by existing inconsistency inspection tools cannot be quantified, so these inconsistencies cannot be used to find systemic problems

Images