基于OLAP的电力客户能效评估方法及应用
|
摘要
随着电网公司信息系统建设的不断完善，对电力客户电能使用信息的分析和使用提出了更高的要求。经过多年的数据采集，目前电网公司拥有了大量电力客户电能使用的相关历史数据，这些数据非常的杂乱，缺乏有效的组织体系，电网公司只对这些数据做一些简单的、局部的查询操作，缺少对这些数据的深入分析。因此研究如何更加有效地分析这些历史数据，从中提取出深层次的有价值的能效信息，已成为客观需要。
本文以联机分析处理(OLAP)技术为基础，针对电力客户设计了一套能效评估方法，并在能效综合评估系统的实际开发中予以应用。
论文分析、研究了联机分析处理(OLAP)技术的国内外现状，介绍了现有的联机分析处理(OLAP)技术的特点、相关概念、以及基本工作原理，并对其适合于电力客户能效评估的特性做了详细阐述。分析了联机分析处理(OLAP)技术的基本工作原理，并以此为基础，结合企业进行能效评估和节能潜力查找的特点，设计了一种基于联机分析处理(OLAP)的能效评估方法，对电力客户进行了能效评估、节能潜力查找以及能效状态评估，提高了查找企业能源使用问题的客观性。以电力客户能效指标体系为依据，结合联机分析处理(OLAP)技术的下钻与上卷操作分析，研究并利用SQL Server2000、VB等软件构建系统，实现了查找节能潜力，评估客户整体能效状态的功能。
最后将基于联机分析处理(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.
本文以联机分析处理(OLAP)技术为基础，针对电力客户设计了一套能效评估方法，并在能效综合评估系统的实际开发中予以应用。
论文分析、研究了联机分析处理(OLAP)技术的国内外现状，介绍了现有的联机分析处理(OLAP)技术的特点、相关概念、以及基本工作原理，并对其适合于电力客户能效评估的特性做了详细阐述。分析了联机分析处理(OLAP)技术的基本工作原理，并以此为基础，结合企业进行能效评估和节能潜力查找的特点，设计了一种基于联机分析处理(OLAP)的能效评估方法，对电力客户进行了能效评估、节能潜力查找以及能效状态评估，提高了查找企业能源使用问题的客观性。以电力客户能效指标体系为依据，结合联机分析处理(OLAP)技术的下钻与上卷操作分析，研究并利用SQL Server2000、VB等软件构建系统，实现了查找节能潜力，评估客户整体能效状态的功能。
最后将基于联机分析处理(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.
引文
[1]戴华良.面向企业能效评估的数据仓库技术的研究与应用[J].中国能源,2003,25(9):4-12.
[2]人民出版社.中华人民共和国国民经济和社会发展第十一个五年规划纲要
[M]．北京:人民出版社,2006.
[3]赵家荣．“十一五”十大重点节能工程实施意见读本[M].北京:中国发展出版社,2007.
[4]张思平.企业能源管理[M].重庆:重庆出版社,1988.
[5]唐克嶂.工厂能源管理[M].大连:人连理工大学出版社,1994.
[6]徐锭明.我国能源工业现状和能源政策[J].中国电力,2004,37(9):1-4
[7]王庆一．中国的能源效率与国际比较[J].节能与环保,2003(9).
[8]朱训．关于中国能源战略的辩证思考[J].中国能源,2003,25(10):4-12.
[9]万少飞.基于社保的数据关联处理方法[M].广东工业大学.2011.
[10]何玉洁，张俊超.数据仓库与OLAP实践教程[M].清华大学出版社.2008
[11]郭春梅.互联网环境下电子商务数据仓库技术的研究[M]北方工业大学.2003
[12]李越.数据仓库与决策支持[M]北京交通大学.2002
[13] E.F.Codd. On-Line Analytical Processing[Z]．M.I.S.GmbH,Darmstadt，1994
[14]王娟.数据仓库开发探索以及在社保领域的应用[D].成都:电子科技大学，2005
[15]周黎莎,于新华.基于网络层次分析法的电力客户满意度模糊综合评价[J].电网技术.2009.09.
[16]吴剑飞,姚建刚,陈华林,龚陈雄,李昀.电力客户能效状态模糊综合评估[J].电力系统与控制.2010.
[17]任慧.基于OLAP的能效评估方法研究与应用[D].上海,同济大学,2009.
[18]秦康寿.综合评估原理与应用[M].电子工业出版社,2003.
[19]张树奎,鲁子爱.基于AHP的港口环境资源生态性模糊评判方法研究[J].水运工程,2009,11(434):80-82.
[20]徐维祥,张全寿.一种基于灰色理论和模糊数学的综合集成算法[J].系统工程理论与实践,2001(10):114-119
[21]王珊.数据仓库技术与联机分析处理[M].科学出版社，1999
[22]林杰斌,刘明德,陈湘.数据挖掘与OLAP理论与实务[M]，清华大学出版社，2003.
[23]郭亚军.综合评估理论与方法[M].科学出版社,2002.
[24]许玖平,吴巍.多属性决策的理论与方法[M].清华大学出版社,2006.
[25]秦康寿,综合评估原理与应用[M],电子工业出版社,2003.
[26]徐维祥,张全寿.一种基于灰色理论和模糊数学的综合集成算法[J].系统工程理论与实践,2001(10):114-119.
[27]周勇达.电力客户能效综合评估指标体系研究[D].上海:同济大学,2008.
[28]崔岩.OLAP在社保数据中心系统中的应用[D].吉林:东北大学，2007.
[29]刘新才,曾鸣,黄琰.基于层次分析法的电力客户信用风险评价[J].电力需求侧管理.2005(6).
[30]杨俊.OLAP在决策支持系统中的研究与应用[D].南昌:南昌大学，2007.
[31]张宝,吴方根.电厂热力系统节能分析方法的现状与展望[J].节能.2004(6).
[32] Jesse Liberty,Brian MacDonald. Learning CSharp2005,2ndEdition.ORdlly,2006.
[33] Elamy A,Halim.Building data warehouses with incremental maintenance fordecision support.Canadian Conference on Electrical and Computer Engineering，2005.
[34] Hasan H,Hyland P.Using OLAP and multidimensional data for decisionmaking[J].JT Professional,2001.
[35] Campbell A T,Gomez J,Kim S,et al.Design,implementation and evaluation ofcellular IP[J].IEEE Personal Communications Magazine,2000,7.
[36] Presuhn R.RFC3418Management Information Base(MIB)for the SimpleNetwork Management Protocol(SNMP)[S].2002.
[37] Intanagonwiwat C,Govindan R,Estrin D.Directed diffusion:A scalable and robustcommunication paradigm for Sensor Networks[C]//Proceedings of the6thAnnual ACM/IEEE International Conference on Mobile Computing andNetworking(MobiCom00),Boston,MA,August2000.
[38] Campbell.A.T,Gomez.J,Kim S,et al.Design,implementation and evaluation ofcellular IP[J].IEEE Personal Communications Magazine2000,7.
[39]张妮娜.需求侧电能应用综合评估系统及相关算法的研究[D],南京:东南大学,2009.
[40]李江,卢毅勤.电力客户信用等级评价体系构建研究[J].华北电力大学学报(社会科学版),2007.
[41]李翔,杨淑霞,张红斌.供电服务质量评价方法研究[J].电网技术,2004.
[42]飞思科技产品研发中心.SQL Server2000OLAP服务设计与应用[M].电子工业出版社,2001.
[43]康博创作室.SQL Server2000数据仓库设计与使用指南[M].清华大学出版社.2000.
[44]战晓苏,吴云浩,皮人杰.数据仓库设计:现代原理与方法[M].清华大学出版社.2010.
[45]刘卫国,严晖.数据库技术与应用[M].清华大学出版社.2006.
[46]任慧,王坚.能效评估系统的应用研究[J].电脑知识与技术,2008,V01.4(2):260—262.
[47] Wayne w Eckerson,The Rise of Analytic Applications:Build or Buy? The DataWarehousing Institute,2002.
[48] Jananthan, R., Ameer,Sadam,Shiyamini,R.,Comparative Study of EnergyAssessmentfrom Apparel Industries. Industrial and Information Systems.FirstInternational Conference on8-ll Aug.2006Page(S):217—220.
[49] Gabbar,Hossam A.Enterprise energy management using Hybrid Energy SupplyUnit (HENSU),Systems,Man and Cybernetics,2007.ISIC.IEEE InternationalConference on7-10Oct.2007Page(s):2284—2289.
[2]人民出版社.中华人民共和国国民经济和社会发展第十一个五年规划纲要
[M]．北京:人民出版社,2006.
[3]赵家荣．“十一五”十大重点节能工程实施意见读本[M].北京:中国发展出版社,2007.
[4]张思平.企业能源管理[M].重庆:重庆出版社,1988.
[5]唐克嶂.工厂能源管理[M].大连:人连理工大学出版社,1994.
[6]徐锭明.我国能源工业现状和能源政策[J].中国电力,2004,37(9):1-4
[7]王庆一．中国的能源效率与国际比较[J].节能与环保,2003(9).
[8]朱训．关于中国能源战略的辩证思考[J].中国能源,2003,25(10):4-12.
[9]万少飞.基于社保的数据关联处理方法[M].广东工业大学.2011.
[10]何玉洁，张俊超.数据仓库与OLAP实践教程[M].清华大学出版社.2008
[11]郭春梅.互联网环境下电子商务数据仓库技术的研究[M]北方工业大学.2003
[12]李越.数据仓库与决策支持[M]北京交通大学.2002
[13] E.F.Codd. On-Line Analytical Processing[Z]．M.I.S.GmbH,Darmstadt，1994
[14]王娟.数据仓库开发探索以及在社保领域的应用[D].成都:电子科技大学，2005
[15]周黎莎,于新华.基于网络层次分析法的电力客户满意度模糊综合评价[J].电网技术.2009.09.
[16]吴剑飞,姚建刚,陈华林,龚陈雄,李昀.电力客户能效状态模糊综合评估[J].电力系统与控制.2010.
[17]任慧.基于OLAP的能效评估方法研究与应用[D].上海,同济大学,2009.
[18]秦康寿.综合评估原理与应用[M].电子工业出版社,2003.
[19]张树奎,鲁子爱.基于AHP的港口环境资源生态性模糊评判方法研究[J].水运工程,2009,11(434):80-82.
[20]徐维祥,张全寿.一种基于灰色理论和模糊数学的综合集成算法[J].系统工程理论与实践,2001(10):114-119
[21]王珊.数据仓库技术与联机分析处理[M].科学出版社，1999
[22]林杰斌,刘明德,陈湘.数据挖掘与OLAP理论与实务[M]，清华大学出版社，2003.
[23]郭亚军.综合评估理论与方法[M].科学出版社,2002.
[24]许玖平,吴巍.多属性决策的理论与方法[M].清华大学出版社,2006.
[25]秦康寿,综合评估原理与应用[M],电子工业出版社,2003.
[26]徐维祥,张全寿.一种基于灰色理论和模糊数学的综合集成算法[J].系统工程理论与实践,2001(10):114-119.
[27]周勇达.电力客户能效综合评估指标体系研究[D].上海:同济大学,2008.
[28]崔岩.OLAP在社保数据中心系统中的应用[D].吉林:东北大学，2007.
[29]刘新才,曾鸣,黄琰.基于层次分析法的电力客户信用风险评价[J].电力需求侧管理.2005(6).
[30]杨俊.OLAP在决策支持系统中的研究与应用[D].南昌:南昌大学，2007.
[31]张宝,吴方根.电厂热力系统节能分析方法的现状与展望[J].节能.2004(6).
[32] Jesse Liberty,Brian MacDonald. Learning CSharp2005,2ndEdition.ORdlly,2006.
[33] Elamy A,Halim.Building data warehouses with incremental maintenance fordecision support.Canadian Conference on Electrical and Computer Engineering，2005.
[34] Hasan H,Hyland P.Using OLAP and multidimensional data for decisionmaking[J].JT Professional,2001.
[35] Campbell A T,Gomez J,Kim S,et al.Design,implementation and evaluation ofcellular IP[J].IEEE Personal Communications Magazine,2000,7.
[36] Presuhn R.RFC3418Management Information Base(MIB)for the SimpleNetwork Management Protocol(SNMP)[S].2002.
[37] Intanagonwiwat C,Govindan R,Estrin D.Directed diffusion:A scalable and robustcommunication paradigm for Sensor Networks[C]//Proceedings of the6thAnnual ACM/IEEE International Conference on Mobile Computing andNetworking(MobiCom00),Boston,MA,August2000.
[38] Campbell.A.T,Gomez.J,Kim S,et al.Design,implementation and evaluation ofcellular IP[J].IEEE Personal Communications Magazine2000,7.
[39]张妮娜.需求侧电能应用综合评估系统及相关算法的研究[D],南京:东南大学,2009.
[40]李江,卢毅勤.电力客户信用等级评价体系构建研究[J].华北电力大学学报(社会科学版),2007.
[41]李翔,杨淑霞,张红斌.供电服务质量评价方法研究[J].电网技术,2004.
[42]飞思科技产品研发中心.SQL Server2000OLAP服务设计与应用[M].电子工业出版社,2001.
[43]康博创作室.SQL Server2000数据仓库设计与使用指南[M].清华大学出版社.2000.
[44]战晓苏,吴云浩,皮人杰.数据仓库设计:现代原理与方法[M].清华大学出版社.2010.
[45]刘卫国,严晖.数据库技术与应用[M].清华大学出版社.2006.
[46]任慧,王坚.能效评估系统的应用研究[J].电脑知识与技术,2008,V01.4(2):260—262.
[47] Wayne w Eckerson,The Rise of Analytic Applications:Build or Buy? The DataWarehousing Institute,2002.
[48] Jananthan, R., Ameer,Sadam,Shiyamini,R.,Comparative Study of EnergyAssessmentfrom Apparel Industries. Industrial and Information Systems.FirstInternational Conference on8-ll Aug.2006Page(S):217—220.
[49] Gabbar,Hossam A.Enterprise energy management using Hybrid Energy SupplyUnit (HENSU),Systems,Man and Cybernetics,2007.ISIC.IEEE InternationalConference on7-10Oct.2007Page(s):2284—2289.