Fresh Food Distribution Decision-making Platform Based On Data Warehouse And OLAP Technology

The pace of urbanization in China is steadily moving forward,and the demand for fresh produce by urban residents in food is also increasing.With the development of the Internet,more and more urban residents tend to purchase fresh products online.Limited by the traditional logistics mode and the special nature of fresh products,how to ensure the timeliness and quality of fresh products is the key to the development of the fresh food quick delivery service.Most of the fresh-selling companies which are not profitable are often not very satisfied with the customer's demand preferences,resulting in poor business.In small and medium companies because of lack of scientific management,this problem is particularly serious.The key to solving above problems is to understand the amount and preference of customers in various regions for their products,establish warehouses and distributed stations in various places,and optimize transportation and distribution,so as to gradually improve the fresh product distributed decisions in time and accuracy,based on the collation and analysis of a large amount of historical data by extracting useful conclusions drawn from them,and making the decision-making behavior more standardized.In the past,the traditional database obviously cannot achieve this objective.Therefore,we need to improve the way of using data including storing and processing historical data in the form of data warehouse,and utilizing OLAP technology to make decision analysis of data from multiple angles,in order to build a fresh food delivery decision-making platform for small and medium companies.Company managers are assisted in making decisions and planning solutions on such a platform,in order to promote the whole process more scientifically and accurately.This article firstly analyzes the needs of various departments in the company and clarifies the platform construction goals;and then accomplishes the design of theme selection,granularity division,dimension modeling,and slow transformation dimension design according to the design process of data warehouse;and then selects the appropriate ETL tools to fulfill the data integration operation.At last,through the online analytical processing technology,the integrated data are analyzed and performed.On this basis,the construction of the fresh food delivery decision-making platform is accomplished.The data are analyzed in multi-dimensionally and displayed in the form of reports and graphs,and the export and print functions of the chart are realized,so that the decision-makers and top managers in fresh-keeping enterprises can have a distinct understanding of the current market demands,and ultimately achieve the purpose of assisted decision-making.At the end of this article,the platform is functionally tested,and the availability of the system is also verified by appropriate test cases,which ensure the integrity and reliability of system functions.