Olap System Design And Optimization Based On Sales Theme Of Enterprise-level

The thesis mainly discusses the necessity and process of the establishment of the enterprise data warehouse, and it is introduced from the requirements analysis, data transmission, the technical route and technology application. A new type solution of decision making management information system is put forward, and the scheme of the enterprise information construction is designed.The thesis presents a set of OLAP system design and optimization program based on sales topics, taking the ROLAP technology as the main core of research, which is against different aspects of the shortcomings of OLAP technology in the operation of the business and management conditions of the OLAP technology in the process of abstraction and generation.First of all, the paper gives the analysis of the OLAP system and the related terms and explains in detail the system design and implementation in the example of the marketing theme. It builds a set of optimized logic on enterprise fixed analysis model based on the optimization of the data organization structure.The OLAP system design has been significantly optimized compared to traditional ERP. The system update strategy gets more perfect combining a variety of methods to improve efficiency. And it analyses another innovation to the module pretreatment optimization reaching the expected vision of the system design. So the research of the thesis can provide the scientific decision and analysis supports to the policy makers in enterprises.