|
|
|
| Key technologies of cluster based distributed real-time database for power dispatching and control system |
| ZHANG Shaobo, YAO Yangchun, ZHAN Feng |
| Shanghai SHR Automation Co., Ltd, Shanghai 200240 |
|
|
|
|
Abstract With the construction of ultra-high voltage and new energy projects, the number of data points that need to be monitored has increased dramatically, and the database capacity and real-time requirements of the power grid monitoring system are increasing. The problem that the real-time database, which is only used as the relational database cache and relies entirely on the Hash algorithm, is installed under the database and the search speed slows down with the increase of data points, is faced with greater challenges. This paper analyzes the real-time and consistency of the real-time database in the power grid regulation and control system. The real-time problem is solved by means of object linear transformation and positioning, pointer level tight coupling access and other solutions, and the consistency problem is solved by adding data versions, supporting incremental and full synchronization. The feasibility of the above scheme have been verified in the engineering practice of the regional distribution network master station project, which includes more than 60 computer nodes and more than 2 million monitoring data points.
|
|
Received: 03 November 2022
|
|
|
|
| Cite this article: |
|
ZHANG Shaobo,YAO Yangchun,ZHAN Feng. Key technologies of cluster based distributed real-time database for power dispatching and control system[J]. Electrical Engineering, 2023, 24(1): 91-95.
|
|
|
|
| URL: |
|
http://dqjs.cesmedia.cn/EN/Y2023/V24/I1/91
|
[1] 刘士亚, 郭静, 岑钊华. 城市电网监控应急系统的设计[J]. 电气技术, 2021, 22(2): 11-16.
[2] 李静, 马超, 黄镜宇, 等. 跨平台信息系统数据迁移技术研究与实现[J]. 电气技术, 2019, 20(10): 70-74.
[3] 刘广一, 戴仁昶, 路轶, 等. 基于图计算的能量管理系统实时网络分析应用研发[J]. 电工技术学报, 2020, 35(11): 2339-2348.
[4] 孔令国, 蔡国伟, 李龙飞, 等. 风光氢综合能源系统在线能量调控策略与实验平台搭建[J]. 电工技术学报, 2018, 33(14): 3371-3384.
[5] 辛耀中, 石俊杰, 周京阳, 等. 智能电网调度控制系统现状与技术展望[J]. 电力系统自动化, 2015, 39(1): 2-8.
[6] 陆杏全. 能量管理系统的实时数据库技术[J]. 电力系统自动化, 2003, 27(6): 1-4.
[7] 姚建国, 杨胜春, 单茂华. 面向未来互联电网的调度技术支持系统架构思考[J]. 电力系统自动化, 2013, 37(21): 52-59.
[8] 吴庆曦, 彭晖, 王瑾, 等. 电网调控集群分布式实时数据库的设计与关键技术[J]. 电力系统自动化, 2017, 41(22): 89-95.
[9] 王宁, 叶锋, 许文庆, 等. 支持CIM的实时对象数据库管理系统[J]. 电力系统自动化, 2006, 30(16): 93-96, 101.
[10] 朱涛, 郭进伟, 周欢, 等. 分布式数据库中一致性与可用性的关系[J]. 软件学报, 2018, 29(1): 131-149.
[11] 王嘉豪, 蔡鹏, 钱卫宁, 等. 集群数据库系统的日志复制和故障恢复[J]. 软件学报, 2017, 28(3): 476-489.
[12] 赵春扬, 肖冰, 郭进伟, 等. 一致性协议在分布式数据库系统中的应用[J]. 华东师范大学学报(自然科学版), 2018(5): 91-106. |
|
|
|
2023, Vol. 24 
