Research And Development Of The Decision Analysis Systems For Commercial Enterprise Based On Data Warehouse

Based on this the author developed a decision analysis system,this system built a decision analysis subsystem which was suitable for commercial enterprise.This system was based on the original ERP systems,comprehensively applying the advanced technology of data warehouse,OLAP,data mining,HTML5 web design as well as the modern business management theories and models,in order to provide companies for decisions support.The implementation of the system would contribute to change the limitations of the original enterprise ERP in centralized data management mode so that the enterprise could grasp the state of its business deeper.The administrators came up with effective business decisions on that basis,thereby enhancing their market competitiveness and profit maximization.The latest developments of the data warehouse,OLAP and data mining technology have been studied.Based on that,this system established a framework of decision-making support system of commercial enterprises through the general use of data warehouse technology and supply chain management.The data mining and online analytical processing that the system demands were based on data warehouse technology,and came out from the research on the system data warehouse and model library.Through the integrated system of data warehouse,OLAP technology and association rule data-excavating Aporiori algorithm,system excavated massive business data such as commodity procurement information,goods store information,sales and customer relations information,and applied the results by HTML5.Through the practical system of commercial enterprises,it has been contrapuntally improved in some problems found out in system.It would better fit the needs of companies,and enhance analysis and decision-making abilities of the commercial enterprises.The query function of the system was improved rapidly by taking a series of measures such as aggregate tables,view index and interface asynchronous execution.Projects were even increased more than 1000%.In terms of architecture,this system sufficiently considered multi places of business in commercial enterprises,and added data buffer to improve the performance of the data warehouse.It also increased the common metadata layer,ETL servers and intermediate databases,and performed distributed pretreatment on the servers of each place of business.They also greatly enhanced the performance of the system.Moreover,this system succeeded to solve problems about cross topic domain query.The query came true by means of dimensional mapping with careful analysis.With system of the regulations that the system excavated,commercial enterprises could develop an appropriate purchasing,sales and warehousing strategies.The system could effectively analyze the data of sales and purchase of goods as well as the customers purchase behavior,which would have practical guidance in subdividing customers,warehouse management and formulating promotion policy.Implementation of the system has greatly enhanced the decision-making efficiency of the enterprises.For example,companies need to spend a whole day previously on making stocking decisions.By using data provided by the system analysis,the decision time would be shortened in an hour to be completed.