Power Customer Energy Eiffciency Appraisal Method And Application Based On OLAP

As the construction of power grid Corporation information system continues toimprove, power on power customer use analysis and using of the information putforward higher requirements. After many years of data collection, currently has a lotof power grid company customers energy use of relevant historical data, these data arevery messy, lack of organization, power grid Corporation on these data only to dosome simple queries, local operations, lack of an in-depth analysis of these data.Study on how to more effectively analyze these historical data, to extract the valuableinformation on energy efficiency of deep, had become an objective need.In this paper, online analytical processing (OLAP) technology to design a set ofenergy efficiency assessment for electricity customers, and the actual development ofthe energy efficiency of a comprehensive assessment system to be applied.This paper analyses, studied the online analytical processing (OLAP) technologyresearch status at home and abroad, introduces the existing online analyticalprocessing (OLAP) technology, related concepts, characteristics and basic workingprinciple, and the suitable for electric power customers energy efficiency assessmentof characteristics described in detail.Analysis of online analytical processing (OLAP)technology, the basic working principle, and on this basis, combined with theenterprise energy efficiency assessment and energy saving potential of search features,based on the design of a online analytical processing (OLAP) of the energy efficiencyassessment methods, to electric power client for energy efficiency assessment,energy-saving potential of energy efficiency assessment to improve search and, theenterprise energy usage problems of objectivity.In order to electricity customersenergy efficiency index system as the basis, combined with online analyticalprocessing (OLAP) technology, and the upper operation analysis, research and the useof SQL Server2000, VB software system so as to realize the energy saving potentialevaluation of search, customer overall energy efficiency status function.Finally, based on online analytical processing (OLAP) of the energy efficiencyassessment method applied to electricity customers energy efficiency assessmentsystem, taking a corporate energy data as data source, realizes the enterprise overallenergy use and energy saving potential analysis of mining, after evaluation, systemassessment results reflect the power customer can use situation, the system has acertain practical value.