智能电网调度控制系统中历史数据服务优化方案
|
摘要
在智能电网调度控制系统中,历史数据存储规模呈爆发式增长态势,海量历史数据的冲击,影响了数据访问效率,为满足历史数据高效访问的需求,针对历史数据服务提出了全新的解决方案。文中提出增加历史数据缓冲区,缓存管理电网热点数据,提高数据处理效率,减轻历史库负载;优化任务分配器,协调数据缓存区与关系库分工作业,对历史数据服务进行有效的管理和调度;设计历史数据会话监听机制,实时监视数据库会话状态,保障历史数据服务的安全性和稳定性。实践证明,基于缓存的历史数据服务能够满足爆发式海量数据场景下的数据访问需求,保障电网调度控制系统的安全稳定运行。
In the smart grid dispatching and control system,the explosive growth of historical data storage scale and the onrush of massive historical data affect the efficiency of historical data access.To meet the demand for efficient access to historical data,an all-new solution for historical data service is proposed.The addition of historical data buffers is intended for buffer management of hot grid data to improve data processing efficiency and reduce historical database load.The task allocator is optimized for work coordination between data cache and historical database to effectively manage and schedule historical data services.The session monitoring mechanism of historical data is designed for real-time monitoring of database session state,to ensure the security and stability of historical data service.Practice has peroved that the cache based historical data service is able to meet the data access demand in the explosive mass data scenarios,while protecting the safety and stable operation of the power grid dispatching and control system.
In the smart grid dispatching and control system,the explosive growth of historical data storage scale and the onrush of massive historical data affect the efficiency of historical data access.To meet the demand for efficient access to historical data,an all-new solution for historical data service is proposed.The addition of historical data buffers is intended for buffer management of hot grid data to improve data processing efficiency and reduce historical database load.The task allocator is optimized for work coordination between data cache and historical database to effectively manage and schedule historical data services.The session monitoring mechanism of historical data is designed for real-time monitoring of database session state,to ensure the security and stability of historical data service.Practice has peroved that the cache based historical data service is able to meet the data access demand in the explosive mass data scenarios,while protecting the safety and stable operation of the power grid dispatching and control system.
引文
[1]刘纯,黄越辉,张楠,等.基于智能电网调度控制系统基础平台的新能源优化调度[J].电力系统自动化,2015,39(1):159-163.DOI:10.7500/AEPS20141008018.LIU Chun,HUANG Yuehui,ZHANG Nan,et al.Renewable energy dispatching based on smart grid dispatching and control system platform[J].Automation of Electric Power Systems,2015,39(1):159-163.DOI:10.7500/AEPS20141008018.
[2]马韬韬,郭创新,曹一家,等.电网智能调度自动化系统研究现状及发展趋势[J].电力系统自动化,2010,34(9):7-11.MA Taotao,GUO Chuangxin,CAO Yijia,et al.Current status and development trend of intelligent dispatching automation system of power system[J].Automation of Electric Power Systems,2010,34(9):7-11.
[3]孙玉娇,周勤勇,申洪.未来中国输电网发展模式的分析与展望[J].电网技术,2013,37(7):1929-1935.SUN Yujiao,ZHOU Qinyong,SHEN Hong.Analysis and prospect on development patterns of China’s power transmission network in future[J].Power System Technology,2013,37(7):1929-1935.
[4]汪际峰,沈国荣.大电网调度智能化的若干关键技术问题[J].电力系统自动化,2012,36(1):10-16.WANG Jifeng,SHEN Guorong.Some key technical issues on intelligent power dispatching of bulk power grid[J].Automation of Electric Power Systems,2012,36(1):10-16.
[5]辛耀中,石俊杰,周京阳,等.智能电网调度控制系统现状与技术展望[J].电力系统自动化,2015,39(1):2-8.DOI:10.7500/AEPS20141008024.XIN Yaozhong,SHI Junjie,ZHOU Jingyang,et al.Technology development trends of smart grid dispatching and control systems[J].Automation of Electric Power Systems,2015,39(1):2-8.DOI:10.7500/AEPS20141008024.
[6]王恒,辛耀中,尚学伟,等.智能电网调度控制系统数据总线技术[J].电力系统自动化,2015,39(1):9-13.DOI:10.7500/AEPS20140930019.WANG Heng,XIN Yaozhong,SHANG Xuewei,et al.A new data bus technology for smart grid dispatching control system[J].Automation of Electric Power Systems,2015,39(1):9-13.DOI:10.7500/AEPS20140930019.
[7]黄河清,宋晓华,张哲,等.一种面向多安全区的新型调度服务总线互联技术[J].电网技术,2011,35(11):218-221.HUANG Heqing,SONG Xiaohua,ZHANG Zhe,et al.A new dispatching interconnecting technology for multiple security zones based on service bus[J].Power System Technology,2011,35(11):218-221.
[8]张海梁,袁荣湘,孙婉胜.数据库访问中间件技术在SCADA数据库系统中的应用[J].电网技术,2005,29(17):58-62.ZHANG Hailiang,YUAN Rongxiang,SUN Wansheng.Application of database access middleware technology in SCADA database system[J].Power System Technology,2005,29(17):58-62.
[9]赵俊化,胡金霞.LRU页面置换算法的改进与实现[J].计算机工程,2012,38(17):24-27.ZHAO Junhua,HU Jinxia.Improvement and implementation of LRU page replacement algorithm[J].Computer Engineering,2012,38(17):24-27.
[10]王涛,朱怡安,黄姝娟.基于改进LRU替换策略的共享Cache划分[J].微电子学与计算机,2012,29(1):80-83.WANG Tao,ZHU Yian,HUANG Shujuan.Shared Cache partition based on improved LRU replacement policy[J].Microelectronics &Computer,2012,29(1):80-83.
[11]闪鑫,戴则梅,张哲,等.智能电网调度控制系统综合智能告警研究及应用[J].电力系统自动化,2015,39(1):65-72.DOI:10.7500/AEPS20140930016.SHAN Xin,DAI Zemei,ZHANG Zhe,et al.Research on and application of integrated smart alarm based on smart grid dispatching and control systems[J].Automation of Electric Power Systems,2015,39(1):65-72.DOI:10.7500/AEPS20140930016.
[12]梅华威,米增强,吴广磊.基于MapReduce模型的间歇性能源海量数据处理技术[J].电力系统自动化,2014,38(15):76-80.DOI:10.7500/AEPS20131215006.MEI Huawei,MI Zengqiang,WU Guanglei.Massive data processing of intermittent energy based on MapReduce model[J].Automation of Electric Power Systems,2014,38(15):76-80.DOI:10.7500/AEPS20131215006.
[13]潘国伟,宋玮,王相南,等.发布/订阅模式消息中间件在SCADA系统中的应用[J].电网技术,2008,32(18):77-81.PAN Guowei,SONG Wei,WANG Xiangnan,et al.Research on application of message oriented middleware based on publish/subscribe model in SCADA system[J].Power System Technology,2008,32(18):77-81.
[14]侯昉,黄承慧,陆寄远.时间与空间局部性强弱的量化方法[J].微电子学与计算机,2014,31(6):48-52.HOU Fang,HUANG Chenghui,LU Jiyuan.Quantitative approaches to temporal and spatial locality strength[J].Microelectronics &Computer,2014,31(6):48-52.
[2]马韬韬,郭创新,曹一家,等.电网智能调度自动化系统研究现状及发展趋势[J].电力系统自动化,2010,34(9):7-11.MA Taotao,GUO Chuangxin,CAO Yijia,et al.Current status and development trend of intelligent dispatching automation system of power system[J].Automation of Electric Power Systems,2010,34(9):7-11.
[3]孙玉娇,周勤勇,申洪.未来中国输电网发展模式的分析与展望[J].电网技术,2013,37(7):1929-1935.SUN Yujiao,ZHOU Qinyong,SHEN Hong.Analysis and prospect on development patterns of China’s power transmission network in future[J].Power System Technology,2013,37(7):1929-1935.
[4]汪际峰,沈国荣.大电网调度智能化的若干关键技术问题[J].电力系统自动化,2012,36(1):10-16.WANG Jifeng,SHEN Guorong.Some key technical issues on intelligent power dispatching of bulk power grid[J].Automation of Electric Power Systems,2012,36(1):10-16.
[5]辛耀中,石俊杰,周京阳,等.智能电网调度控制系统现状与技术展望[J].电力系统自动化,2015,39(1):2-8.DOI:10.7500/AEPS20141008024.XIN Yaozhong,SHI Junjie,ZHOU Jingyang,et al.Technology development trends of smart grid dispatching and control systems[J].Automation of Electric Power Systems,2015,39(1):2-8.DOI:10.7500/AEPS20141008024.
[6]王恒,辛耀中,尚学伟,等.智能电网调度控制系统数据总线技术[J].电力系统自动化,2015,39(1):9-13.DOI:10.7500/AEPS20140930019.WANG Heng,XIN Yaozhong,SHANG Xuewei,et al.A new data bus technology for smart grid dispatching control system[J].Automation of Electric Power Systems,2015,39(1):9-13.DOI:10.7500/AEPS20140930019.
[7]黄河清,宋晓华,张哲,等.一种面向多安全区的新型调度服务总线互联技术[J].电网技术,2011,35(11):218-221.HUANG Heqing,SONG Xiaohua,ZHANG Zhe,et al.A new dispatching interconnecting technology for multiple security zones based on service bus[J].Power System Technology,2011,35(11):218-221.
[8]张海梁,袁荣湘,孙婉胜.数据库访问中间件技术在SCADA数据库系统中的应用[J].电网技术,2005,29(17):58-62.ZHANG Hailiang,YUAN Rongxiang,SUN Wansheng.Application of database access middleware technology in SCADA database system[J].Power System Technology,2005,29(17):58-62.
[9]赵俊化,胡金霞.LRU页面置换算法的改进与实现[J].计算机工程,2012,38(17):24-27.ZHAO Junhua,HU Jinxia.Improvement and implementation of LRU page replacement algorithm[J].Computer Engineering,2012,38(17):24-27.
[10]王涛,朱怡安,黄姝娟.基于改进LRU替换策略的共享Cache划分[J].微电子学与计算机,2012,29(1):80-83.WANG Tao,ZHU Yian,HUANG Shujuan.Shared Cache partition based on improved LRU replacement policy[J].Microelectronics &Computer,2012,29(1):80-83.
[11]闪鑫,戴则梅,张哲,等.智能电网调度控制系统综合智能告警研究及应用[J].电力系统自动化,2015,39(1):65-72.DOI:10.7500/AEPS20140930016.SHAN Xin,DAI Zemei,ZHANG Zhe,et al.Research on and application of integrated smart alarm based on smart grid dispatching and control systems[J].Automation of Electric Power Systems,2015,39(1):65-72.DOI:10.7500/AEPS20140930016.
[12]梅华威,米增强,吴广磊.基于MapReduce模型的间歇性能源海量数据处理技术[J].电力系统自动化,2014,38(15):76-80.DOI:10.7500/AEPS20131215006.MEI Huawei,MI Zengqiang,WU Guanglei.Massive data processing of intermittent energy based on MapReduce model[J].Automation of Electric Power Systems,2014,38(15):76-80.DOI:10.7500/AEPS20131215006.
[13]潘国伟,宋玮,王相南,等.发布/订阅模式消息中间件在SCADA系统中的应用[J].电网技术,2008,32(18):77-81.PAN Guowei,SONG Wei,WANG Xiangnan,et al.Research on application of message oriented middleware based on publish/subscribe model in SCADA system[J].Power System Technology,2008,32(18):77-81.
[14]侯昉,黄承慧,陆寄远.时间与空间局部性强弱的量化方法[J].微电子学与计算机,2014,31(6):48-52.HOU Fang,HUANG Chenghui,LU Jiyuan.Quantitative approaches to temporal and spatial locality strength[J].Microelectronics &Computer,2014,31(6):48-52.