Research & Application Of Data Warehouse And Data Mining In Tobacco Industry CRM

MIS and WEB technology is widely used. This brings data flood in all kind of system. How to effectively use these company data is becoming the hot spot in IT study field. On that background the theory of CRM emerged. Data warehouse and data mining are useful in creating the predictable model of a company. The models are used to extract useful company data and support management strategy.We look up to the files to understood the present condition of local parts of industries, such as the finance, telecommunication, retail trade, in data warehouse and data mining. In recent years, tobacco industry makes use of IT to produce and collect step-by-step rise of the data ability, ten million data base study of science and the project are developed quilt being used to manage, being handling official business. How the high-effect field makes use of information resources, reserves the now available customer opening up the new marketplace, mentions tobacco enterprise core competition, become the information construction of tobacco industry core problem.The paper introduces the latest development situation and basic principle of data warehouse and data mining, discussing the data warehouse technology application significance in tobacco industry; Theory and method forming data warehouse system on system basis in CRM has carried out thorough investigation and discussion on tobacco industry , has provided the theory basis and the realization method to the data warehouse application in tobacco industry; According to tobacco industry data characteristic and business need, have suggested that tobacco industry data warehouse system gets the population frame, have gone deep into the environment ETL technology, the data warehouse having structured tobacco industry having discussed that the business system data arrives at the data warehouse. The paper researches designing and actualizing tobacco industry CRM system based on data warehouse, and the application of On-Line Analytical Processing and data mining in tobacco industry CRM system.This article analyses the demand of the field of integration of information system of tobacco industry enterprises at present of our country on the foundation, combines the advantage of the classical solution, above all, realize conformity in datum layer, and designs the basic frame work of suiting integration of information system of tobacco industry enterprise of our country. In this framework is realized, Analyses the technological demand of the data centre of enterprises first, and then from the technological framework, the database is designed, data modeling, data change several key field describe realization Enterprise Data Center System. In data modeling, consider dirty data, different to construct data source problem make corresponding design, have guaranteed the validity and accuracy of the data.The designing thought and correlative research in this paper are also significant for other industries' BI in theory and practice.