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.
张少波, 姚阳春, 湛锋. 电网调控系统集群分布式实时数据库关键技术[J]. 电气技术, 2023, 24(1): 91-95.
ZHANG Shaobo, YAO Yangchun, ZHAN Feng. Key technologies of cluster based distributed real-time database for power dispatching and control system. Electrical Engineering, 2023, 24(1): 91-95.
2023, Vol. 24 
