Design And Implementation Of Csl Decision Support System Base On Data Warehouse And Decision Tree

This dissertation based on the business analysis of China Sports Lottery(CSL) Technology Development Co., and the various features of sports lottery sales in different provinces, to make improvements of current "WEI SHENG" decision support system, so that the existing system is no longer a simple data collection and table printing, but also showing a data analysis capabilities with data mining algorithms, and promote sales finally, as well as raise core competitiveness of CSL.The main contents of the paper is using data mining techniques to improve the company’s ability of decision-making support system. The establish of data warehouse, data analysis and mining, decision support systems, are based on SQL SERVER 2008 database to interpret. Paper contains the following parts: first, introduces the core part of the new "WEI SHENG" system, which includes the data warehouse, OLAP and data mining. Second, is the introduction of the architecture of decision support system. Next, is how to build sports lottery data warehouse by using SQL SERVER 2008 R2, and OLAP analysis. The chart display system is fulfilled by MICROSOFT SHARE POINT SERVER 2007 support. Fourth, through the company’s history data screening and integration, the CSL Data Mining Decision Support System is roll out by decision tree classification.