Method and system for monitoring data consistency between plurality of databases

Abstract

The invention discloses a method for monitoring the data consistency between a plurality of databases, which comprises the following steps of: receiving verification request information submitted for the data consistency of a service data between the plurality of databases, wherein the request information comprises a service type identifier of the service data and the key field information for the association of the service data between the plurality of databases; reading the configuration information corresponding to the service type identifier according to the request information, wherein the configuration information comprises a data processing rule for the service type and accessed database information; acquiring the corresponding service data from the database accessed by the present service according to the key field information; and verifying whether the service meets a consistency requirement or not according to the data processing rule forthe present service and obtaining a verification result. The invention provides a mechanism which can monitor the data consistency between the plurality of databases without labor resources, effectively save cost and improve monitoring efficiency.

Description

technical field [0001] The invention relates to the field of online data interaction of multiple databases, in particular to a method for monitoring data consistency among multiple databases and a system for monitoring data consistency between multiple databases. Background technique [0002] Strictly speaking, a database is "a warehouse that organizes, stores and manages data according to the data structure". In the daily work of economic management, it is often necessary to put some relevant data into such a "warehouse" and perform corresponding processing according to the needs of management. 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 ...

AI Technical Summary

Problems solved by technology

This method may lead to data inconsistency for a long time, so that when the system needs to call the wrong data when processing other transactions, it will cause a series of data processing errors. Since the time of risk existence cannot be controlled, the entire online transaction system impact

Therefore, this method is labor-intensive, time-consuming, and inefficient

Images