Method and system for e-commerce transaction data accounting

摘要

Method and system for e-commerce transaction data accounting are disclosed. A method comprises: a second server receiving transaction data from a first server; the second server analyzing the received transaction data to identify a classification of the received transaction data; the second server obtaining historical transaction data from a second database based on the classification of the received transaction data, wherein the second database obtains transaction data that meet a preset condition from a data warehouse system and compares the transaction data that meet the preset condition with previously obtained transaction data to update inconsistency in the transaction data that meet the preset condition; and the second server combining the received transaction data and the historical transaction data to produce current transaction data.

主权项

1. A method comprising:
receiving one or more asynchronous messages comprising transaction data from a first server of an e-commerce (electronic commerce) transaction system, the e-commerce transaction system comprising the first server and a first database that stores the transaction data, wherein the one or more asynchronous messages are unreliable and are prone to data loss; analyzing the received transaction data to identify a classification of the received transaction data, the analyzing comprising extracting a keyword from the received transaction data and finding the classification of the received transaction data from a correlation relationship between keywords and classifications based on the keyword; obtaining historical transaction data from a second database based at least in part on the classification of the received transaction data, wherein the historical data comprises transaction data that conforms to a preset condition and is obtained by inquiring a data warehouse system which is different from the e-commerce transaction system for every passage of a predetermined time interval in response to the one or more asynchronous messages being unreliable, wherein the transaction data that meets the preset condition comprises transaction data that varied during a most recent time interval; and comparing the transaction data received from the first server with the historical transaction data received from the second database to update inconsistency in the received transaction data and produce current transaction data.