Design And Implementation Of Data Management And Analysis System For Express Industry

With the rapid development of information industry,the Internet has become an important carrier in many industries,e-commerce has therefore been booming.The current emerging e-commerce businesses,courier industry is a key factor in the development of e-commerce,quality of service delivery industry has gradually become the major e-commerce sites to enhance their industry competitiveness and an important factor in increasing the adhesion of the user^[1].21st century ushered in the rapid development of e-commerce,online spending has been extremely widespread,express delivery industry patterns greatly facilitate the people.However,due to the courier industry itself varies greatly,lost cargo,damaged,etc.when there appeared outstanding foreign courier companies to enter the domestic market has brought great impact to the courier industry,domestic frequent drug package,parcel bombs,also to the courier industry development cast a shadow.In this paper,this clock situation,based on the data warehouse^[2],ETL^[3],the data partition stores^[4],to build a dynamic model^[5]technology,design and implement a data management and analysis system based on the courier industry.The system of the courier company's data collection,standardization and import,the companies will have data for statistical,express delivery industry,data analysis,generate industry forecast,while warning of suspicious packages,and promptly contact the police department SMS,powerful maintain the stable development of the courier industry.The main work includes the following aspects:1.The system of analysis needs.For this system,we analyze the objectives,functional and performance requirements of the system,etc.,a clear structure and requirements of the system.2.Detailed analysis of the system to achieve the management and analysis of key technologies.This paper from the technical level and application level has been studied and discussed,and how to apply these techniques to the practical application of this system were studied.Technical aspects which contains data warehouse,ETL,data normalization^[6],data storage and dynamic models partition structures,such as technology and its practical application in the management and analysis system;the application level of the system is a data acquisition,data standardization,data import,analysis features and specific needs of early warning data,data query and data analysis.3.The system design and implementation.Analysis of the overall design of the system,data acquisition module,data analysis module functions and composition and implementation of the database,a detailed discussion of the data acquisition module and data analysis module workflows and implementation.4.Test and Verification.Functionality and performance of the system to be tested and verified,respectively,the test results show,we use the data warehouse and build a dynamic model realization of delivery of data processing.Research on this topic explored the data standardization,data warehousing and dynamic model building techniques,and these techniques in data cleansing,specific functional implementation of data storage and business processes were discussed and application design.