Design On Cigarette Sale DSS Based On Data Warehouse

In the tobacco system, the computerized processing has taken initial shape.But, these systems are business processing system, Mainly as quickly meet the needs of business operations.It is difficult to achieve that comprehensive and overall for the analysis. Technically,lacking of an effective Data Warehouse system to management the information.This system will put up and use the data which between the various application systems. And transforming a large amount data into useful information. To use these information to provide more effective decision support for our leaders.All of these become the major problems that we are facing today.This paper uses the data warehouse, Online Analytical Processing and Data Mining to solve the problems above.On the theory, first to introduced the basic concept of decision support system, system structure and develop process. Second to introduced the data storehouse technology, on-line analysis processing and data excavation technology, and making deep analyse for its important part and key technology.In the decision, first carries out the comprehensive description for the service flow of this enterprise, then combine with management request and the tobacco profession characteristic, thorough careful has carried out the demand analysis, has given the system structure. Second to designs the software of system and the hardware platform and the network environment. For the database and date warehouse of system there carries out plan and foundation design, and for data model of system there carries out design and elaborate the ELT process. Final, carries out display for how to use OLAP technology and data excavation technology in decision support system.