Moving and selling data storage method and system, electronic equipment and storage medium

Abstract

The invention discloses a transaction data storage method, system and device and a medium. The method comprises steps of obtaining transaction data to be stored and storing the transaction data to bestored in a temporary storage layer; determining a service form type corresponding to the data through a preset service form identification rule; and judging whether the business form type is a form type which is specified in advance and needs to be stored or not, and if so, respectively generating a data dimension table, a data detail table and a data summary table corresponding to each businessform type according to the marketing data, and writing the tables into a database for storage. After the to-be-stored transaction data is obtained, the business form type corresponding to the transaction data is determined, and if the type needs to be stored, the data dimension table, the data detail table and the data summary table of the corresponding form type are generated and stored in the database, so the data warehouse is compatible with the data of different business forms, and data storage efficiency is improved; fusion management of multi-business-form marketing data is realized, sointegrity of the data and efficiency of subsequent data query are improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and more specifically, relates to a method and system for storing dynamic marketing data, an electronic device, and a computer-readable storage medium. Background technique [0002] The market layout and strategy of dairy companies are closely related to data such as sales, inventory, finance, and members. Dynamic sales data, namely dynamic sales data, is one of the most important data that dairy companies need to master. The product sales groups involve infants, children, adults, the elderly and other age groups, and the product series involve liquid milk, milk powder, cheese, nutritional products, etc., and the multi-dimensional attributes of products of different age groups and different product series cross each other. It is defined as the diversification of the business form of the enterprise. [0003] At present, large-scale dairy companies generally have the commonality ...

AI Technical Summary

Problems solved by technology

[0003] At present, large-scale dairy companies generally have the commonality of diversified business forms and massive sales data. Traditional and mature technologies can be used to process dynamic sales data of a single business form. However, for dynamic sales data of multiple business forms, the data sources and calculation rules Compared with the data of a single business form, the complexity of the data is doubled

Images