Data association method, system and device for data table redundancy storage and medium

Abstract

The invention discloses a data association method, system and device for data table redundancy storage and a medium. The method comprises the steps that a data processing state table is constructed; when the distribution service manager receives a data updating request sent by original data, a first-level distribution device and a second-level distribution device are started; first-level distribution is started based on the first-level distribution device, a first-level distribution record is registered and a corresponding processing state is generated; when the first-level distribution device receives a first-level distribution request sent by the distribution service manager, a processing state corresponding to a first-level distribution record is updated, second-level distribution devices are called in sequence based on the first-level distribution device to start second-level distribution, second-level distribution records are registered, and a corresponding processing state is generated; and when the second-level distribution device receives a second-level distribution request sent by the first-level distribution device, the processing state corresponding to the second-level distribution record is updated, and the associated data is updated. The method not only ensures that the original data processing performance is not affected, but also ensures that the redundant data is quickly and reliably updated.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a processing method, system, device and medium for associated data redundantly stored in a data table. Background technique [0002] In various information systems and their integration processes, some data in a data table is redundantly stored in multiple other data tables. Taking accounting documents as an example, a field is specially set in the data table of many documents to store the corresponding accounting document number. However, when the original data changes, how to update the data of the redundantly stored associated data table becomes a difficult problem. Still taking the accounting document as an example, we need to consider how to update the data of each document when the document number of the accounting document changes The document number stored redundantly in the table. [0003] In the current method, two methods are widely used to update the...

AI Technical Summary

Problems solved by technology

[0003] In the current method, two methods are widely used to update the associated data in redundant storage: 1) synchronously modify the associated data in redundant storage during the process of updating the original data. The method may cause the database transaction to be too large and affect the operation efficiency of the original data; 2) After the original data update is completed, the associated data stored in the redundant storage is updated through the message queue. This method is suitable for unstable environments such as the network , may cause problems such as failure to perform compensation operations after updating the associated data in redundant storage, and affect the accuracy of associated data. Therefore, in order to solve the above problems, it is urgent to propose a fast and reliable redundant data update method

Images