Tobacco Marketing Decision Support System Based-on Data Warehouse Technology

With the deepening of the system reform of tobacco, and the acceleration of the market-oriented paces of the tobacco supply enterprise, the request to management is more and more strict in every part of tobacco companies, more and more information need be managed by advanced technology. Conventional management ways can't deal scientifically with information collected and Lack of the ability to analyze synthetically and forecast the trends of future development because of the limit of technique. This thesis researches and designs the system of the decision support in accordance with the problems during the information management of tobacco marketing. The following bellow is the main content of the article:(1) The theory and skill about data warehouse are researched and the use of data warehouse technique is discussed in the system of the decision support.(2) The relationship between activities and data of tobacco marketing is analyzed. According to system request, data structures and logic models of data warehouse are designed.(3) This thesis researches the use of association rules analysis in data mining and decision tree classification algorithm during tobacco marketing .It researches on the application of association rules and decision tree classify method in tobacco marketing decision, and offers revised Apriori algorithm based on SQL SERVER database and decision tree DM algorithm, improving executing speed and efficiency, having realized in system, achieving better forecasting effect.(4) Structure of the tobacco marketing decision support system is constructed on the basis of the detailed analysis to the requirement of the tobacco marketing system. It also designs the data warehouse in the system, OLAP and data mining and has valuable meaning for reference to the development of the tobacco marketing decision support system to some extent.