A method and system for checking data consistency between multiple platforms

Abstract

The invention discloses a method and system for consistency verification of data among multiple platforms. The method comprises the steps of collecting platform data mutual information of a first platform within a preset time period, extracting first characteristic parameter information from the platform data mutual information and writing the first characteristic parameter information into a first information sheet; respectively calculating total quantities of first interactive data corresponding to second platform marks; receiving first platform relevant data information collected from a second platform within the corresponding time periods, extracting second characteristic parameter information from the first platform relevant data information and writing the first platform relevant data information into a second information sheet; respectively comparing the total quantities of the first interactive data and total quantities of second interactive data corresponding to the same second platform mark, and judging whether data between the first platform and the second platform are consistent according to comparison results. The method and system for consistency verification of the data among the multiple platforms are used for improving verification efficiency of the data among the multiple platforms, consistency of the data among the multiple platforms is protected, and robustness of services among the multiple platforms is guaranteed.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and system for checking data consistency between multiple platforms. Background technique [0002] At present, the process of electronic payment through online banking is that the user enters the payment page from the product page of the merchant, selects the payment method and enters the corresponding online banking page, completes the payment, and returns to the payment page. [0003] When the payment is completed, the banking system platform will not immediately settle each transaction to the merchant, but at a fixed time point of the day, the amount of all successful transactions that occurred in a certain period of time before (such as a natural day) Batch settlement to merchants. Therefore, there are three states for a transaction on the merchant side, waiting for the transaction, successful transaction, and successful liquidation. [0004] Among them, wa...

AI Technical Summary

Problems solved by technology

In addition, the consistency of the completed transaction status between the two sets of tables is evened out. Since the collection table is very large, the synchronization time is too long

[0009] In addition, merchant business personnel need to frequently check how many transactions are already in the "transaction successful" state, but the bank has not cleared them, and count the total and total amount; they also need to check how many transactions are in "waiting transactions" to calculate the potential The business churn rate, which needs to retrieve the collection table (the transaction table cannot be retrieved, because, first, the transaction table does not have an index design that facilitates the retrieval; second, the transaction table is not easy to distinguish which ones have reached the liquidation date, because The transactions that occurred on the same day did not reach the settlement day), the retrieval work is very large, and with the increase of the amount of collected data, the retrieval work will become slower and slower, and there will be certain inaccurate factors in the retrieval

Images