Design And Implementation For Precursor Chemicals Analysis System Based On Data Warehouse

At present,there are three regulatory systems for precursor chemicals in China,and the regulatory system for precursor chemicals has successfully been implemented online business applications and approvals,and met the business needs of the enterprises.The operational regulation system is stable and mature,but it is applicable to daily business processing operations and can not be conducted multi-angle and in-depth data mining and analysis on the large amount of historical data generated by business transactions.Therefore,the company named SBS decides to create the data warehouse which is based on the operational business data.Then the company could use the data warehouse to carry on the multi-dimensional and multi-level,cross-themed data analysis.The data warehouse will provide important data support for the decision-making of the enterprises and the supervision of the government departments.This project is based on the purchase theme,the chemical dimension,the organization dimension,the regional dimension and the implementation of simple ETL operations on these themes and dimensions.In this thesis,the main research work is as follows:(1)The dimensional modeling is improved.On the basis of familiar and comprehensive understanding of the business process of the regulatory system of precursor chemicals,the purchase theme is expanded,the themes of transportation,putting in storage,outbound,inventory and purchase return are added,the dimensions of warehouse and transportation tool are added,and the complete data warehouse dimension model of precursor chemicals is constructed.(2)The ETL subsystem is implemented.Based on the understanding of the operational system's data structure and the data requirements of the data warehouse,the ETL data processing subsystem has been implemented and it can be completed the data extraction,cleaning,transform and load.For the problems of the same province or different provinces,the corresponding solutions have been put forward and successfully implemented.Finally,the data filling work of the datawarehouse is completed and the high quality data is obtained.(3)The data multidimensional analysis and visual display are designed and implemented.The multi-dimensional and multi-level query of the data of the data warehouse is realized in a multi-level way,and the visualization of the data is presented in the form of reports and charts.Under each analysis theme,the basic query,horizontal ratio analysis,longitudinal ratio analysis,year-on-year analysis and sequential analysis are implemented.In addition,the cross-theme query operations are implemented,for example,the comprehensive analysis of the purchase theme and the purchase return theme,and it provides sufficient data support for the decision-making of the enterprise and the supervision of the government department.The precursor chemicals analysis system which is based on the data warehouse has provided high quality,high efficiency of the data support for the decision-making of the enterprise and the regulatory of the regulator.And it also has laid a solid foundation for better application of large data analysis in the regulatory field of precursor chemicals in China.