电网调控系统集群分布式实时数据库关键技术  

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)

机构地区：[1]上海思源弘瑞自动化有限公司,上海200240

出　　处：《电气技术》2023年第1期91-95,100,共6页Electrical Engineering

摘　　要：随着特高压和新能源项目的建设,需要监控的数据点数急剧增多,对电网监控系统的数据库容量和实时性要求日益提高。传统只是作为关系库缓存、查找完全依赖Hash算法的实时数据库因存在数据库下装、查找速度均随数据点数增多而变慢的问题而面临较大挑战。本文分析电网调控系统中实时数据库的实时性和一致性这两个核心问题,通过对象线性转换定位、指针级紧耦合访问等方案解决实时性的问题,通过增加数据版本、支持增量和全量同步等方案解决一致性的问题。在包含60多个计算机节点、200多万监控数据点的地区级配电网主站项目的工程实践中验证了上述方案的可行性。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.

关 键 词：实时性 紧耦合 分布式 一致性 数据库管理系统(DBMS) 

分 类 号：TM73[电气工程—电力系统及自动化] TP311.13[自动化与计算机技术—计算机软件与理论]