The Application Of Data Warehouse Technology In The Electricity Decision Support System

Along with supply and demand relations changing in power supply market and the reform of electric power industry market speeding up, the condition of electric power monopoly management will change, The establishment of competitive electric power market is inevitable. The traditional electric power marketing idea is experiencing the transformation. Power supply enterprise leaders need to make reasonable marketing decision under the complex marketing environment. Power supply enterprise's business has its own characteristics and involves in many aspects. There are many kinds of business data and the data size is very large. Under this condition, it is the hotspot for power supply enterprise decision marker how to organize these business data and extract useful information. Combing the technology of DW and OLAP can improve the support ability of the power supply enterprise's business.Power-Supply Marketing DSS based on DW and DSS theory is built in this thesis, using IBM DW development kit. Firstly, this thesis analyzes the research and development status of DSS, DW and OLAP, as well as the requirement to Power-Supply Marketing DSS under the development of power supply market, and points out the background and method of the researching task. Secondly, it discusses the technologies related to DW, OLAP and DSS separately. Then, according to the practical project of Jinan Power-Supply Bureau, this thesis illustrates how to build a data warehouse to support Power-Supply Marketing DSS and manipulate data analysis to meet requirements of decision-making process. Lastly, this thesis summarizes the whole work, views the development of Power-Supply Marketing DSS in the future.The main contributions of this thesis are researching on Decision Support System based on the data warehouse technology, using advanced data warehouse development kit to implementing a Power-Supply Marketing DSS according to DW and DSS theory, and realizing the analysis of electric quantity sold in Jinan Power-Supply Bureau,which can be done from diferent angles and sides.