Order data processing method and device, equipment and storage medium

Abstract

The invention discloses an order data processing method, device and equipment and a storage medium, and is applied to a data warehouse, and the method comprises the steps: obtaining first data in a charging system database and second data in a business system database, and carrying out the preprocessing of the first data and the second data to obtain an order data set; wherein the first data is data of a charging rule of a configuration service stored in a charging system database, and the second data is data of a service transaction order stored in a service system database; splitting different types of orders in the order data set according to commodity dimensions, storing the split order data into corresponding temporary tables, and then collecting the data in different temporary tables to obtain target data; and matching the target data with the charging rule and determining commission data according to a matching result. Through the technical scheme of the invention, the coupling between systems can be reduced, and the docking and maintenance cost can be reduced; the system stability is improved, and the problem of commission data loss is solved.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to an order data processing method, device, equipment and storage medium. Background technique [0002] With the development of Internet technology, more and more workers choose to complete related labor work through Internet intermediaries. The major e-commerce platforms draw a part of the transaction amount on the platform according to certain rules as technical service fees, and With the growth of the platform, there are more and more business models, and the platform transactions are growing rapidly. In the prior art, when an Internet intermediary platform calculates different fees for different businesses and obtains different data, it is mainly completed by two modules, such as figure 1 As shown, the specific process is as follows: 1. User transactions are in various business systems, and the charging system is responsible for the calculation of commissions fo...

AI Technical Summary

Problems solved by technology

[0003] However, there are several problems in this system: 1. The coupling between various business systems is serious, and the cost of docking and maintenance is high

With the continuous increase of business models, each additional fee-based business requires product managers to import requirements, front-end and back-end development of both sides of the business to invest in R&D, and testers to test and accept. The cost of manpower and time is very high.

Moreover, the business systems depend on each other. For example, the charging center relies on the MQ message sent by the upstream business to calculate the commission, and the content of the MQ message body of the upstream business party depends on the charging rules configured by the charging center. Changes by any party require the cooperation of the other party. With the continuous increase of business, the maintenance cost increases exponentially

2. Insufficient system stability, resulting in loss of commission amount

Due to the rapid development of the platform business, the rapid growth of transaction volume, and the lack of system stability during the peak transaction period, the loss of MQ messages and abnormal consumption of MQ often result in the loss of some transaction orders, resulting in commission losses.

[0004] To sum up, how to reduce the coupling between systems, reduce the cost of docking and maintenance, improve the stability of the system, and solve the loss of commission data are currently unresolved problems

Images