Power Grid Topology Analysis Method and System

Abstract

This application discloses a method and system for power grid topology analysis, including the following steps: establishing and storing the relationships between power collection points and gateway tables, gateway tables and devices, and devices in a first database; acquiring real-time power collection information and storing it in a second database according to time; a topology analysis module retrieving the relationships in the first database to construct a topology graph; selecting a device, the first database retrieving the associated devices of that device, the device itself, and the gateway tables corresponding to the associated devices, and outputting this information to the topology analysis module, while outputting the power collection point set information to the second database; the second database matching a set of real-time power collection information containing the power collection point set, and outputting this information to the topology analysis module; and the topology analysis module receiving the real-time power collection information set, analyzing and processing it, and displaying the results. The beneficial effects of this application are: significantly improving the efficiency of storing, querying, and analyzing massive amounts of power grid power data.

Description

Technical Field

[0001] This application relates to the field of power grid data acquisition and analysis, specifically to power grid topology analysis methods and systems. Background Technology

[0002] In its development, the power industry must utilize various advanced technologies and plan power grid construction effectively to maintain its competitive advantage and ensure a reliable energy supply for daily life and social production activities, thereby guaranteeing the healthy and stable development of the power industry. During power grid operation, the quality of grid regulation and control directly affects the power supply quality and its ability to meet daily production demands. Storing and processing big data from grid regulation and control can provide valuable data for the stable operation of the power grid system, further improving its power supply quality. This underscores the importance of researching technologies for storing and processing big data from grid regulation and control.

[0003] Related technologies utilize the power grid structure and electrical connection methods, adhere to the principles of independent, interconnected, and reliable operation, and set certain boundary conditions (closed-loop construction of the power grid and open-loop operation of dispatching) to simplify the massive and complex power grid structure into several stable electrical connection areas. For the power supply and demand situation of each area, the load situation of the power grid structure in the area needs to be further analyzed to facilitate the development of reasonable plans for power grid adjustment and construction, so as to ensure the safe and stable operation of the power grid.

[0004] The primary characteristic of the big data generated by the power grid is its sheer scale. As the power grid continues to develop, the number of load nodes and generators will increase, and the bidirectional interaction between the grid and loads will further amplify the volume of grid data. Consequently, the amount of data generated and requiring storage will also increase dramatically. The storage and retrieval of massive amounts of data are prerequisites for big data analysis, and how to efficiently and flexibly access and store such data has become a key challenge. Traditional relational databases serve as storage support, but their theoretical models and architectures are limited, making it difficult to meet the performance and scalability requirements of big data scenarios. Non-relational databases can address these issues better, but their functionality is often relatively simple, with limited support for complex queries and transaction management. Furthermore, they lack standardized query languages ​​or interfaces, making them incompatible with SQL-based query logic and posing significant challenges for technology migration.

[0005] Chinese patent "A Power Consumption Information Collection System and Method Based on Big Data Technology", publication number CN106651633A, publication date: October 9, 2016, specifically discloses a dual-link storage mechanism for data collection and storage. One link saves low-frequency collected data to a relational database, while the other saves all collected data to cloud storage on a cloud platform. This solution reduces the pressure on the main database through the cloud platform. However, during system operation, this solution reads incremental archive update data from the relational database and updates the data in real time to the distributed file storage on the cloud platform, providing accurate basic information for distributed stream computing and offline computing. In other words, the cloud platform effectively handles all the data content, and the storage pressure on the cloud platform is not improved.

[0006] Chinese patent "A Multi-Database Hybrid Storage Method and System Based on Power Control Big Data", publication number: CN 109582667A, publication date: April 5, 2019, specifically discloses a categorized storage method: data collected in the power control system is divided into different types, and different basic databases are selected for data storage based on the data characteristics and business needs of different data types. However, this solution tends to classify data according to business needs, and the data storage pressure of a single basic database is still very high. Summary of the Invention

[0007] This application addresses the problem that existing technologies suffer from massive amounts of power grid data, where traditional relational databases cannot meet the demands of big data, and using multiple relational databases for categorized storage can lead to complex data retrieval, chaotic data classification, and disorganized storage, making it impossible to intuitively display the real-time power status of the current power grid structure to users. It provides a power grid power topology analysis method and a system for implementing this method. By storing the correlation information of all data in a first database and the power data in a second database, a heterogeneous database cluster is constructed. This separates the storage of massive amounts of information and their correlation relationships, avoiding the impact of correlation relationships on information storage capacity while ensuring accurate querying of the current power status. Furthermore, by constructing a topology map of equipment, gateway tables, and power collection points through these correlation relationships, the power loss of equipment within the current power supply area can be intuitively displayed, facilitating users to analyze and adjust real-time power consumption.

[0008] To achieve the aforementioned technical objectives, as a first aspect of this application, a power grid topology analysis method is provided, comprising the following steps: S1: Acquiring information on various devices, power collection points, and gate meter information in the power grid system, establishing and storing the relationships between power collection points and gate meters, gate meters and devices, and devices in a first database; S2: Establishing a second database, acquiring real-time power collection information, and storing it in the second database according to time; S3: The topology analysis module retrieves the relationships in the first database to construct a topology graph; S4: Selecting a device, the topology analysis module outputs the device information to the first database, and the first database retrieves the device information... The system retrieves the associated devices, the corresponding gateway table for each device, and matches power collection points according to the gateway table to obtain a power collection point set. It then outputs the associated device information, gateway table information, and power collection point set information to the topology analysis module, and outputs the power collection point set information to the second database. S5: The second database receives the power collection point set, matches it with a set of real-time power collection information containing that set within the most recent time period, and outputs it to the topology analysis module. S6: The topology analysis module receives the associated device information, gateway table information, power collection point set information, and real-time power collection information set, analyzes and processes them, and displays the results.

[0009] Furthermore, real-time power consumption information includes at least the time of collection, the power consumption point, and the real-time power consumption.

[0010] Furthermore, the first database also has a time correlation relationship. When the topology analysis module outputs a historical data request, the first database retrieves the time correlation relationship, and the second database retrieves the historical power consumption information according to the time interval corresponding to the time correlation relationship.

[0011] Furthermore, the second database also stores real-time power information related to the meter.

[0012] Furthermore, the topology analysis module receives the device and gateway table, the gateway table and power collection point set, and the association relationship between devices output by the first database, and receives the real-time power information output by the second database. It integrates the association relationship and the real-time power information, outputs a real-time power diagram, and automatically highlights the association relationship.

[0013] Furthermore, based on the power supply area, the topology map is divided into several topology islands, each corresponding to a power supply area of ​​the power grid.

[0014] Furthermore, the first database stores the relationships between storage devices, gateway meters, power collection points, and power supply areas.

[0015] Furthermore, the first database also stores the current flow direction between devices, gate meters, and power collection points.

[0016] Furthermore, the first database also stores the power thresholds associated with the topological island.

[0017] As a second aspect of this application, a power grid topology analysis system is provided to implement the power grid topology analysis method described above, comprising: a first database for storing the relationships between devices, between devices and gate meters, and between gate meters and power collection points; a second database for storing real-time power collection information collected by power collection points; and a topology analysis module for retrieving and displaying data information from the first and second databases.

[0018] The beneficial effects of this application are as follows: By storing the association relationships in the first database and the power data in the second database, the power data in the second database can be retrieved according to the association relationships in the first database. This makes the second database free from association relationship restrictions, i.e., without any transactions or complex query tables. While expanding the data storage capacity of the second database, it is still possible to accurately retrieve the corresponding real-time power information as needed and display it to the user through the topology diagram. This significantly improves the efficiency of storing, querying, and analyzing massive amounts of power grid power data, helps users monitor and analyze the power grid power within the topology island, and assists users in providing auxiliary analysis on the stability and security of the grid structure, so as to ensure high reliability of the power grid and stable power supply. Attached Figure Description

[0019] Figure 1 This is a flowchart illustrating a power grid topology analysis method according to one embodiment of this application.

[0020] Figure 2 This is a schematic diagram of the power grid topology analysis system according to another embodiment of this application. Detailed Implementation

[0021] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description of this application is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely one preferred embodiment of this application and are only used to explain this application. They do not limit the scope of protection of this application. All other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0022] like Figure 1 As shown, this application provides a power grid topology analysis method, including the following steps:

[0023] S1: Obtain information on various devices, power collection points, and gate meters in the power grid system, and establish and store the relationships between power collection points and gate meters, gate meters and devices, and devices in the first database;

[0024] S2: Build a second database, obtain real-time power consumption information, and store it in the second database according to time.

[0025] S3: The topology analysis module retrieves the relationships in the first database to construct a topology graph;

[0026] S4: Select a device, the topology analysis module outputs the device information to the first database, the first database retrieves the associated devices of the device, the device and the corresponding gateway table of the associated devices, and obtains the power collection point set by matching the power collection points according to the gateway table, and outputs the associated device information, gateway table information and power collection point set information to the topology analysis module, and outputs the power collection point set information to the second database;

[0027] S5: The second database receives the set of power collection points, matches the set of real-time power collection information containing the set of power collection points in the most recent time period, and outputs it to the topology analysis module;

[0028] S6: The topology analysis module receives associated device information, gateway table information, power collection point set information, and real-time power collection information set, analyzes and processes them, and displays them on the topology map.

[0029] Specifically, real-time power consumption information includes at least the collection time point, power consumption collection point, and real-time power consumption. When an operator needs the real-time power consumption of a certain device, selecting that device will retrieve the corresponding associated devices, gateway tables, and power consumption collection point sets from the first database's relational relationships. The power consumption collection point set will then be used as the matching value to match the power consumption collection information in the second database, thus obtaining the real-time power consumption information corresponding to that device. By using the first database as a relational database and the second database as a non-relational database to store relational information and data information respectively, the power consumption data storage is improved while ensuring the relevance of power consumption queries in the power grid system and enhancing analysis efficiency. Meanwhile, since power consumption data is collected based on power consumption collection points, but in actual applications, power consumption collection points are not set up for every device, but rather multiple devices share a single power consumption collection point. In this case, the real-time power consumption information collected by the power consumption collection point is actually the real-time power consumption information resulting from the combined action of multiple devices. Therefore, this application establishes a topology analysis module through the association relationships between power consumption collection points and gateway tables, gateway tables and devices, and devices themselves. When an operator selects a device, the module displays the associated devices, gateway tables, and power consumption collection points, and retrieves the corresponding real-time power consumption data for display. At this point, the operator can intuitively understand which devices in the power grid system are contributing to the displayed real-time power consumption, and it also helps determine whether the location settings of gateway tables and power consumption collection points meet actual usage requirements. It is understood that in this application, "devices in the power grid system" refers to the electrical components that constitute the power grid lines in the power grid system, and the association relationships between devices can be electrical connection methods.

[0030] Preferably, since the collection time of each power collection point is different, if each time point is stored as a schema, a large amount of collection time information will inevitably be stored and associated, which will result in an excessive amount of data. The already massive amount of power information will cause excessive storage space occupation after adding the collection time. Therefore, this application sets a fixed time interval to establish a schema, that is, all real-time power collection information collected within a certain period of time is stored in the same schema. When it is necessary to display the real-time power of the current device, the schema of the time period closest to the selected time is judged and matched for application, thereby reducing the need to build too many architectures due to a large number of collection time points and causing a larger data burden on the database.

[0031] Optionally, for ease of referencing, a reference is defined at each schema level, that is, a reference key is defined in the schema. This reference key information includes at least the feature information of the reference schema. In this embodiment, the reference key information is a time interval.

[0032] Furthermore, when retrieving the power consumption of a certain device, it is necessary not only to retrieve the power consumption of related devices, but also the historical power consumption information of that device. That is, real-time power consumption information and historical power consumption information are displayed together to facilitate the analysis of the load situation of the power grid in the region. Therefore, a time correlation relationship is set in the first database. When the topology analysis module outputs a historical data request, the first database retrieves the time correlation relationship, that is, it determines which time intervals the historical data request includes, and then references the corresponding schema according to the corresponding time interval. Then, it retrieves the real-time power consumption in the schema according to the power collection point information. That is, the second database retrieves the historical power consumption information according to the time intervals corresponding to the time correlation relationship, integrates and outputs it to the topology analysis module to realize the historical power consumption information display function, so that operators can intuitively obtain historical power consumption information.

[0033] A gate meter, also known as a master meter, is a meter that controls a specific point in the power supply chain. Its configuration is typically determined by the power supply characteristics of the feeder. Therefore, the second database also stores real-time power information from these gate meters. When a device is selected, the topology analysis module outputs device information to the first database. The first database retrieves the corresponding associated devices, gate meters, and power collection point sets based on the device and outputs them to the topology analysis module. It also outputs the gate meters and power collection point sets to the second database. The second database then matches the real-time power information from the gate meters and power collection points to the topology analysis module for display.

[0034] Specifically, the selected devices and associated devices usually correspond to a general gateway table. At this time, the subordinate power collection point set is called according to the general gateway table. The first database also receives the time when the topology analysis module requests data, retrieves the time correlation relationship, and outputs the time interval. The second database receives the time interval as the reference key to retrieve the corresponding schema, and then matches the real-time power information stored in the schema with the power collection point set and the gateway table.

[0035] The topology analysis module receives the device and gateway table, the gateway table and power collection point set, and the association relationship between devices output by the first database, and receives the real-time power information output by the second database. It integrates the association relationship and the real-time power information, outputs a real-time power diagram, and automatically highlights the association relationship.

[0036] Preferably, when the first database outputs the association relationships between devices, between devices and gate tables, and between gate tables and sets of power collection points to the topology analysis module, the topology analysis module highlights the corresponding devices, gate tables, and sets of power collection points. In this embodiment, the topology analysis module is a display module used to achieve visualization and interaction with operators. Initially, it outputs a topology map of the power grid system based on the association relationships of all devices, gate tables, and power collection points recorded in the first database. The topology map includes all devices, gate tables, and power collection points, and displays their electrical connections through lines. That is, operators can intuitively obtain the topology map of the power grid system through the topology analysis module.

[0037] Optionally, since power grid systems are generally too large, existing compatible displays cannot directly show the entire power grid system in a unified manner, which would make it difficult for operators to query. Therefore, based on the power grid power supply area division topology map, the topology map is divided into several topology islands. Each topology island corresponds to a power grid power supply area. That is, when the operator selects the corresponding power supply area, the topology analysis module outputs the corresponding topology island for display, avoiding the impact of too many complex power grid architectures and electrical connection relationships on the operator's query and analysis.

[0038] Specifically, the first database stores the relationships between devices, gateway tables, power collection points, and power supply areas. When an operator selects a power supply area, the system retrieves the devices, gateway tables, and power collection points associated with that power supply area from the first database and outputs the relationships between the devices, gateway tables, and power collection points to the topology analysis module to construct the corresponding topology island.

[0039] Optionally, a device can be selected in the topology analysis module, and the devices, gateway tables, and power collection points associated with that device in the first database can be retrieved. The device can then be used as the center point of the topology island, and the corresponding topology island can be constructed radiating outwards from the device, associated devices, gateway tables, and power collection points.

[0040] Optionally, the setting of the gate meter is usually determined by the power supply nature of the feeder. That is to say, under normal circumstances, there is only one gate meter in a power supply area, i.e., a power supply feeder. Therefore, the gate meter information can also be displayed in the topology analysis module. The operator selects a gate meter, retrieves the corresponding equipment, power collection point and corresponding relationship from the first database, and outputs it to the topology analysis module to construct the corresponding topology island.

[0041] Preferably, the relationships between devices, between devices and gate meters, and between gate meters and power collection points at least include the direction of current flow; that is, the first database also stores the current flow direction between devices, gate meters, and power collection points. After the topology island is output, the second database also receives the data request from the first database to retrieve power information and output it to the topology analysis module. At this time, the topology analysis module draws a power line graph based on the current flow and outputs it for display. Taking a topology island with only one gate meter and several power collection points as an example, the power collection point x1 closest to the current input end is taken as the first point of the x-axis of the line graph, and the real-time power y1 of the power collection point is taken as the first point of the y-axis of the line graph. The first point of the line graph is (x1, y1). Several points of the line graph are obtained sequentially according to the current flow. The gate meter and the real-time power of the gate meter are taken as the last point of the line graph. Connecting all the points can intuitively display the power usage in the entire power supply area, which is convenient for operators to analyze the power loss.

[0042] Preferably, the value of the power sampling point can be determined by the number of devices separated from the previous sampling point. For example, if there are two devices between the first power sampling point and the current input terminal, then x1 = 0 + 2 = 2; if there are three devices between the second power sampling point and the first power sampling point, then x2 = x1 + 3 = 5. That is, the coordinates of each power sampling point are (x n y n ), y n Let x be the real-time electricity consumption of the nth electricity collection point. The coordinates of the nth electricity collection point are known to be (x, y). n y n If there are m devices between the gate meter and the nth power collection point, then the coordinates of the gate meter are (x...). n +m,y'), where y' is the real-time battery level of the gate meter.

[0043] Considering that there may be no equipment between the power collection points, only the coordinates of the latter collection point are recorded on the line graph. At the same time, the real-time power difference between the two collection points is calculated and output as a line power loss indicator.

[0044] Preferably, the first database also stores power thresholds associated with the topology island. While constructing the topology island by outputting the association relationship, the first database also outputs the associated power thresholds. The topology analysis module compares the power thresholds with the real-time power of the gate table output by the second database. When the real-time power of the gate table exceeds the power threshold, the topology analysis module activates the alarm program to issue an alarm and associates the alarm information with the real-time power information of the gate table and stores it in the first database.

[0045] More preferably, the first database also stores fluctuation thresholds and alarm frequency thresholds. The fluctuation thresholds and alarm thresholds are related. When the alarm frequency exceeds the alarm frequency threshold, it is considered that the currently set power threshold does not conform to the actual situation. The fluctuation threshold is retrieved to adjust the power threshold fluctuation, thereby adapting to the power usage in different time periods.

[0046] Optionally, the second database is OpenTSDB.

[0047] Preferably, the query method of Mybatis is enhanced by Spring AOP for the first database. In the data persistence layer module, through aspect-oriented programming, queries of the first and second databases can be implemented simultaneously in a single interface call. The query results of the first database (i.e., the relational database) drive the query of OpenTSDB, and finally return the standard query results according to the interface definition. This achieves loose coupling between modules without modifying the code of related frameworks or databases, and does not affect the upper-layer business logic. It has good compatibility and greatly reduces the difficulty of technology migration.

[0048] More preferably, the first database also stores the relationships between topological islands. By constructing a power grid topology map through these relationships, the power grid structure can be visualized, allowing operators to clearly understand the current load status of the grid and providing assistance for power grid construction.

[0049] like Figure 2 As shown, this application also provides a power grid topology analysis system, comprising:

[0050] The first database is used to store the relationships between devices, between devices and gate meters, and between gate meters and power collection points;

[0051] The second database is used to store real-time power collection information collected by power collection points;

[0052] The topology analysis module is used to retrieve and display data information from the first and second databases.

[0053] The threshold update module is used to retrieve the fluctuation threshold based on the alarm frequency threshold and update the power consumption threshold based on the fluctuation threshold.

[0054] Specifically, the threshold update module periodically retrieves alarm information and alarm frequency thresholds stored in the first database according to a set time. When the number of alarm occurrences exceeds the alarm frequency threshold, it retrieves the fluctuation frequency threshold and the current power consumption threshold, calculates the actual power consumption threshold, and updates the power consumption threshold stored in the first database. This scheme allows the power grid system to have different power consumption thresholds at different times, thus adapting to power grid use during peak periods and extreme weather conditions.

[0055] The specific embodiments described above are preferred embodiments of the power grid topology analysis method and system of this application, and are not intended to limit the specific scope of this application. The scope of this application includes but is not limited to the specific embodiments described above. All equivalent changes made in accordance with the shape and structure of this application are within the protection scope of this application.

Claims

1. A method for analyzing the topology of power grid electricity, characterized in that: Includes the following steps: S1: Obtain information on various devices, power collection points, and gate meters in the power grid system, and establish and store the relationships between power collection points and gate meters, gate meters and devices, and devices in the first database; S2: Build a second database, obtain real-time power consumption information, and store it in the second database according to time. S3: The topology analysis module retrieves the relationships in the first database to construct a topology graph; S4: Select a device, the topology analysis module outputs the device information to the first database, the first database retrieves the associated devices of the device, the device and the corresponding gateway table of the associated devices, and obtains the power collection point set by matching the power collection points according to the gateway table, and outputs the associated device information, gateway table information and power collection point set information to the topology analysis module, and outputs the power collection point set information to the second database; S5: The second database receives the set of power collection points, matches the set of real-time power collection information containing the set of power collection points in the most recent time period, and outputs it to the topology analysis module; S6: The topology analysis module receives associated device information, gateway table information, power collection point set information, and real-time power collection information set, analyzes and processes them, and displays them. Real-time power consumption information should include at least the time of collection, the power consumption point, and the real-time power consumption. The second database also stores real-time power information related to the meter. The topology analysis module receives the device and gateway table, the gateway table and the power collection point set, and the relationship between devices output from the first database. It also receives the real-time power information output from the second database, integrates the relationship and the real-time power information, outputs a real-time power diagram, and automatically highlights the relationship.

2. The power grid topology analysis method as described in claim 1, characterized in that: The first database also contains time-related relationships. When the topology analysis module outputs a historical data request, the first database retrieves the time-related relationships, and the second database retrieves historical power consumption information based on the time interval corresponding to the time-related relationships.

3. The power grid topology analysis method as described in claim 1, characterized in that: Based on the power supply area division topology map, the topology map is divided into several topology islands, and each topology island corresponds to a power supply area of ​​the power grid.

4. The power grid topology analysis method as described in claim 3, characterized in that: The first database stores the relationships between storage devices, gateway tables, and power collection points and power supply areas.

5. The power grid topology analysis method as described in claim 4, characterized in that: The first database also stores the current flow direction between devices, gate meters, and power collection points.

6. The power grid topology analysis method as described in claim 5, characterized in that: The first database also stores the power thresholds associated with the topological island.

7. A power grid topology analysis system, used to implement the power grid topology analysis method as described in any one of claims 1 to 6, characterized in that: include: The first database is used to store the relationships between devices, between devices and gate meters, and between gate meters and power collection points; The second database is used to store real-time power collection information collected by power collection points; The topology analysis module is used to retrieve and display data information from the first and second databases.

Images