Design And Implementation Of Golf Decision Support System Based On Data Warehouse

The traditional decision support system has many problems when confronting the massive enterprise business data, such as insufficient capability to access the historical data, difficulties with integrating data from different data source, and lack of effective data analyzing tool and other issues. The function of the data warehouse is to provide the data for the further implementation in decision analysis, therefore, the design and implementation of the decision support system based on data warehouse is of great significance.In according with the existing problems in Reagle operation system, problems like un-unified query caliber, un-standardized classification of business process and the relatively weak function in business analysis query and data mining, and so on, this paper, build the golf data warehouse based on the operational data which exist in current golf operational system for making a unified data view, moreover, the golf decision support system based on the golf data warehouse is constructed, and in combination with the on-line analytical processing and reporting function to further lead support for sophisticated data graph and analysis. The following are the main focuses of this paper:Firstly, this paper introduces the generation, development process, the architecture and study of the status in decision support system, and further explains the application of decision support system based on data warehouse at domain and abroad, furthermore it demonstrates the feasibility of the project's implementation. And then the study of generation, development process, and architecture and design process of data warehouse as well as the architecture and function of the OLAP is also placed into enhanced practice.Secondly, the paper analyzes the requirement of system, and discusses the quality and effect of the data that system required, and the establishment of the data model of the system is also analyzed.Thirdly, this paper designs the architecture of the system and implements the system, designs and implements the golf data warehouse, proposed a design method of the taxonomy analysis of multidimensional data model, making the golf business data stored in the way of decision theme, actually proved that it can effectively support decision making. For ensuring the reliability of data, this paper deals with the golf data which has quality problems together with the ETL process, made the Decision-making analysis based on a unified data view. And for satisfying the requirement of the real-time data in decision-making the paper proposed a real-time data extraction method to ensure the comprehensiveness of the data for the decision-making.Finally, In the practical application of the system the paper carried out a number of multi-dimensional analyses for the business theme, and presented the results to the analysts in a intuitive and easily understanding way, which provided scientific reference for the company's decision-makers when they making decisions.