Power Marketing Decision Support System Based-on Data Warehouse Technology

With the deepening of the system reform of electric power, and the acceleration of the market-oriented paces of the power supply enterprise, the request to management is more and more strict in every part of power 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.After analyzing power marketing tasks, Power Marketing DSS based on DW theory and DSS theory are built in this paper. Firstly, The paper analyzes the present status of Power Marketing information system, expounds the present status of DW technology and the research on DSS based on DW method;it discusses DW theory knowledge, that is, the definition and characteristics of DW, the architecture of DW system,etc.Secondly, The business and data model of Power Marketing Data Warehouse are analyzed too, and data structure and logical model of DW are designed according to business demand. The paper researches on the application of association rules and decision tree classify method in power 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.Finally, the scheme design and realization of power marketing decision support system is presented.