Electric power carbon emission flow looped network topology calculation method and system

Abstract

The invention discloses an electric power carbon emission flow looped network topology calculation method and system. The method comprises the following steps: acquiring a data file; the content of the data file comprises a static archive data section, a topological information data section and an operation power data section; carrying out database storage on the data file; data integration is performed on the warehousing data, and two loop problems, namely a two-station multi-loop carbon flow route scene and a single-loop carbon flow route scene, are solved by comparing the integrated data; the endless loop in the carbon flow calculation process can be effectively avoided, and the stability and accuracy of the calculation process are ensured. And through loop processing, the carbon flow calculation does not have an endless loop.

Description

Technical Field

[0001] The present invention belongs to the field of electric power, and in particular relates to a method and system for calculating the topology of an electric power carbon emission flow ring network. Background Art

[0002] In power network analysis, the direction of the power flow determines the existence of a closed loop consisting of multiple sites, that is, the flow starts from a certain site, passes through a series of sites and finally flows back to the starting site, forming a loop. In the power transmission network, multiple sites (such as substations and power plants) are interconnected by multiple lines, allowing power to be transmitted on multiple paths, which increases the complexity of the power network and the number of loop scenarios.

[0003] In the power transmission network, the loop scenario is a common complex network structure. At present, with the expansion of the scale of the power transmission network, that is, the number of sites (such as substations, power plants) and lines has increased dramatically, resulting in a gradual increase in the number of multi-loop scenarios. For this scenario, the traditional carbon flow calculation method may be difficult to fully and accurately simulate the complex interactions and influences between multiple sites, multiple lines and multiple loops in the power network. With the increase in the complexity of the power network, the traditional calculation model may not be able to capture all the key variables and relationships, resulting in inaccurate calculation results. At the same time, the traditional carbon flow calculation method may face the challenge of a sharp increase in calculation amount, which not only increases the calculation time, but may also have an adverse effect on the real-time and stability of the power system.

[0004] Carbon flow calculation in power system mainly refers to the process of quantitative analysis of carbon emissions generated in the process of power production and transmission during the operation of power system. This process involves multiple aspects of power system, including but not limited to power generation, transmission, distribution and final power consumption. Carbon flow calculation is usually carried out on the basis of power flow calculation of power system. Power flow calculation is a method to analyze the steady-state operation of power system. It can determine the voltage, phase angle and power flow of each node in the power system under given operating conditions. Carbon flow calculation introduces the factor of carbon emission into power flow calculation, so as to focus not only on the flow of electric energy but also on the flow of carbon emission. Related literature on carbon flow calculation: Preliminary study on calculation method of carbon emission flow in power system [J]. Zhou Tianrui; Kang Chongqing; Xu Qianyao; Chen Qixin. Automation of Electric Power Systems, 2012(11); Research on optimization of carbon flow calculation in power system based on graphical model [J]. Qiu Bidan; Zheng Yiqiu; Huang Longjie; Peng Bin; Xiang Zouxiang. Big Data, 2024(10).

[0005] Smart grid dispatching and control system is an existing intelligent management system in the power grid system, including the dispatching D5000 system. The dispatching D5000 system is an advanced power grid dispatching and management system that can monitor and control the operation of the power grid in real time. The system is widely used in dispatching centers at all levels of the State Grid and is currently a widely used power grid dispatching and control system in the domestic power industry. The D5000 system adopts a distributed architecture and consists of multiple subsystems. The subsystems communicate through the network to achieve data sharing and coordination. The system can collect, process and store a large amount of power grid data in real time, such as voltage, current, power and other indicators. The dispatching D5000 system contains a variety of data files, some of which are stored in the CIME file format. It has functions such as multi-link acquisition, multi-protocol, load balancing, multi-source data acquisition, and data forwarding, and plays an important role in improving the stability, reliability, economy and reducing labor costs of the power grid. Summary of the invention

[0006] The purpose of the present invention is to solve the huge challenges that the existing technology may face in solving the loop problem. In modern power transmission networks, with the expansion of the scale of power transmission networks, that is, the number of sites (such as substations, power plants) and lines has increased dramatically, making loops (including multiple loops and single loops) become a common complex network structure, which may cause the carbon flow calculation process to fall into an infinite loop.

[0007] In order to solve the above problems, the present invention provides a method for calculating the topology of a power carbon emission flow ring network, comprising the following steps:

[0008] S1: Get raw data;

[0009] S1-1: The smart grid dispatching control system exports data files offline. The data file content includes: static archive data section, topology information data section, and operating power data section;

[0010] Static archive data nodes include: substation archive data node, generator set archive data node, load archive data node;

[0011] The topology information data section includes: substation connection file data section;

[0012] The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment;

[0013] S2: Raw data integration;

[0014] S2-1: File data is entered into the database;

[0015] Extract the data information of the substation archive data section, create a new substation archive table TableA, and record the data information of the substation's unique identifier, substation name, substation type and reference voltage field in TableA;

[0016] Extract the data information of the generator set archive data section, create a new generator set archive table TableB, and record the data information of the generator set's unique identifier, generator set name, voltage level, substation unique identifier, power generation and data date in TableB;

[0017] Extract the data information of the load archive data section, create a new load archive table TableC, and maintain the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table;

[0018] Extract the data information of the substation connection file data section, and create a new substation connection file table TableD, in which TableD records the data information of the line's unique identifier, line name, line start station identifier, line end station identifier, voltage level and data date;

[0019] Extract the data information of the active power value data node of the unique line associated with the metering point device and the substation, create a new active power management table TableE of the unique line associated with the metering point device and the substation, and record the data information of the unique device identifier at one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date in the data table;

[0020] S2-2: Data integration;

[0021] S2-2-1: Create a new raw data integration table TableG to record data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields;

[0022] S2-2-2: Get all data records of a certain date from TableD, and insert them into TableG in sequence. Compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA. Compare the terminal station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the terminal station name field value in TableG data to the substation name field value in TableA. The segment value is compared with the substation unique identifier field value of TableE. If the two are the same, the starting station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the starting end power field value of TableG data is modified to the power field value of TableE; the terminal station unique identifier field value in the new data just inserted into TableG is compared with the substation unique identifier field value of TableE. If the two are the same, the terminal station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the terminal power field value of TableG data is modified to the power field value of TableE;

[0023] S3: Two-station multi-loop carbon flow route scenario;

[0024] S3-1: In TableA, take any two substation name field data records, record them as RA and RB respectively, record the substation unique identifier field value of data record RA as MA, and record the substation unique identifier field value of data record RB as MB;

[0025] S3-2: In TableG, when the unique identification field of the starting station is MA and the unique identification field value of the terminal station is MB, or when the unique identification field of the starting station is MB and the unique identification field value of the terminal station is MA and the positive and negative signs of the power field values ​​of the starting end and the power field values ​​of the terminal end are different, it is considered that a two-station multi-ring scenario occurs, and a two-station multi-ring substation (A, B) can be obtained. In the substation (A, B), A represents the starting end of the substation, and B represents the end of the substation;

[0026] S3-3: In TableG, when there are two records with the starting station unique identification field value of MA and the terminal station unique identification field value of MB, the following are as follows: one record is the starting end power P1(A, R1(A, B)) and the terminal power P1(B, R1(A, B)) of R1(A, B), and the other record is the starting end power P1(A, R2(A, B)) and the terminal power P1(B, R2(A, B)) of the starting station R2(A, B); when there is a record with the starting station unique identification field value of MB and the terminal station unique identification field value of MA, the following is as follows: one record is the starting end power P1(B, R1(B, A)) and the terminal power P1(A, R1(B, A)) of R1(B, A);

[0027] S3-4: Compare the starting power values ​​of the above data records. Take the data record with the smallest starting power and perform the following processing:

[0028] S3-4-1: Assume that the starting-end power P1(B,R1(B,A)) of R1(B,A) is the smallest, subtract P1(B,R1(B,A)) from the starting-end power of R1(A,B) and R2(A,B) respectively, and add P1(B,R1(B,A)) to the end-end power.

[0029] S3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0.

[0030] S3-4-3: Eliminate data records where both the starting power and the ending power are 0, and repeat steps S3-4-1 and S3-4-2 for the remaining data records until only one data record is left. When there is only one line between the two stations with power at both ends not equal to 0, only this data is used in the carbon flow calculation process, so that the carbon flow calculation will not fall into an infinite loop.

[0031] S4: single-loop carbon flow route scenario;

[0032] S4-1: In TableG, the set of all line data on the loop is recorded as set RL = {RL1, RL2, RL3...};

[0033] S4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL:

[0034] Compare the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value; the following takes the starting power field value of RL1 as an example for processing:

[0035] When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0. When the line data of a single loop has a line with power of 0 at both ends, this data is not used in the carbon flow calculation process, and the single-loop carbon flow route scenario will not exist, and the carbon flow calculation will not fall into an infinite loop.

[0036] A power carbon emission flow ring network topology calculation system, comprising: a data acquisition module, a data integration module, and a comparison module;

[0037] M1: Get the original data;

[0038] The data acquisition module exports data files offline from the smart grid dispatching and control system. The data file contents include: static archive data section, topology information data section, and operating power data section;

[0039] Static archive data nodes include: substation archive data node, generator set archive data node, load archive data node;

[0040] The topology information data section includes: substation connection file data section;

[0041] The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment;

[0042] M2: Raw data integration;

[0043] M2-1: file data is entered into the database;

[0044] The data integration module extracts data information of the substation archive data section, creates a new substation archive table TableA, and records data information of the substation's unique identifier, substation name, substation type, and reference voltage field in TableA;

[0045] The data integration module extracts the data information of the generator set archive data section, and creates a new generator set archive table Table B, which records the data information of the generator set's unique identifier, generator set name, voltage level, unique identifier of the substation to which it belongs, power generation and data date;

[0046] The data integration module extracts the data information of the load archive data section, creates a new load archive table TableC, and maintains the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table;

[0047] The data integration module extracts data information of the substation connection file data section, and creates a new substation connection file table TableD, which records the data information of the line's unique identifier, line name, line start station identifier, line end station identifier, voltage level and data date;

[0048] The data integration module extracts the data information of the active power value data node of the unique line associated with the metering point device and the substation, and creates a new active power management table Table E of the unique line associated with the metering point device and the substation. The data table records the data information of the unique device identifier at one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date;

[0049] M2-2: Data integration;

[0050] M2-2-1: The data integration module creates a new raw data integration table TableG, which records the data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields;

[0051] M2-2-2: Get all data records of a certain date from TableD, and insert them into TableG in sequence. Compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA. Compare the terminal station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the terminal station name field value in TableG data to the substation name field value in TableA. The segment value is compared with the substation unique identifier field value of TableE. If the two are the same, the starting station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the starting end power field value of TableG data is modified to the power field value of TableE; the terminal station unique identifier field value in the new data just inserted into TableG is compared with the substation unique identifier field value of TableE. If the two are the same, the terminal station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the terminal power field value of TableG data is modified to the power field value of TableE;

[0052] M3: Two-station multi-loop carbon flow route scenario;

[0053] M3-1: In TableA, the comparison module takes any two substation data records, which are recorded as RA and RB respectively, and records the substation unique identifier field value of data record RA as MA, and the substation unique identifier field value of data record RB as MB;

[0054] M3-2: In TableG, when the unique identification field of the starting station is MA and the unique identification field value of the terminal station is MB, or when the unique identification field of the starting station is MB and the unique identification field value of the terminal station is MA and the positive and negative signs of the power field values ​​of the starting end and the power field values ​​of the terminal end are different, it is considered that a two-station multi-ring scenario occurs, and a two-station multi-ring substation (A, B) can be obtained;

[0055] M3-3: In TableG, when there are two records with the starting station unique identification field value of MA and the terminal station unique identification field value of MB, they are as follows: one record is the starting end power P1(A, R1(A, B)) and the terminal power P1(B, R1(A, B)) of R1(A, B), and the other record is the starting end power P1(A, R2(A, B)) and the terminal power P1(B, R2(A, B)) of the starting station R2(A, B); when there is a record with the starting station unique identification field value of MB and the terminal station unique identification field value of MA, it is as follows: one record is the starting end power P1(B, R1(B, A)) and the terminal power P1(A, R1(B, A)) of R1(B, A);

[0056] M3-4: Compare the starting power values ​​of the above three records, and take the data record with the smallest starting power for the following processing:

[0057] M3-4-1: Assume that the starting-end power P1(B,R1(B,A)) of R1(B,A) is the smallest, subtract P1(B,R1(B,A)) from the starting-end power of R1(A,B) and R2(A,B) respectively, and add P1(B,R1(B,A)) to the end-end power.

[0058] M3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0;

[0059] M3-4-3: Eliminate the data records whose starting power and ending power are both 0, and repeat steps M3-4-1 and M3-4-2 for the remaining data records until only one data record remains.

[0060] M4: single-loop carbon flow route scenario;

[0061] M4-1: In TableG, the set of all data records on the loop is recorded as set RL = {RL1, RL2, RL3...};

[0062] M4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL:

[0063] The comparison module compares the starting power field values ​​of each line data RLi in RL one by one, and finds the line data record with the minimum starting power field value; the following takes the starting power field value of RL1 as an example for processing:

[0064] When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0.

[0065] The beneficial effects of the present invention are as follows: by eliminating data records whose starting end power and terminal power are all 0, and cyclically repeating steps S3-4-1 and S3-4-2 for the remaining data records until only one data record is left, when there is only one line between the two stations whose power at both ends is not 0, only this data is used to participate in the calculation in the carbon flow calculation process, thereby solving the problem that the carbon flow calculation will not fall into an infinite loop; by subtracting the starting end power field value of RL1 from the starting end power field value of each data record other than RL1, and adding the terminal power field value of RL1 to the terminal power field value, and then modifying the starting end power field value and the terminal power field value of RL1 to 0, this data is not used to participate in the carbon flow calculation process in the carbon flow calculation process, thereby solving the problem of the occurrence of an infinite loop phenomenon in the carbon flow calculation process caused by the emergence of multi-loop scenarios and single-loop scenarios in modern power transmission networks, thereby ensuring the stable progress of the calculation process. BRIEF DESCRIPTION OF THE DRAWINGS

[0066] Figure 1 It is a schematic diagram of the implementation process of the present invention. DETAILED DESCRIPTION

[0067] The specific implementation process is described below with reference to the accompanying drawings:

[0068] S1: Get raw data;

[0069] S1-1: The smart grid dispatching control system exports data files offline. The data file content includes: static archive data section, topology information data section, and operating power data section;

[0070] Static archive data nodes include: substation archive data node, generator set archive data node, load archive data node;

[0071] The topology information data section includes: substation connection file data section;

[0072] The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment;

[0073] S2: Raw data integration;

[0074] S2-1: File data is entered into the database;

[0075] Extract the data information of the substation archive data section, create a new substation archive table TableA, and record the data information of the substation's unique identifier, substation name, substation type and reference voltage field in TableA;

[0076] Extract the data information of the generator set archive data section, create a new generator set archive table TableB, and record the data information of the generator set's unique identifier, generator set name, voltage level, substation unique identifier, power generation and data date in TableB;

[0077] Extract the data information of the load archive data section, create a new load archive table TableC, and maintain the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table;

[0078] Extract the data information of the substation connection file data section, and create a new substation connection file table TableD, in which TableD records the data information of the line's unique identifier, line name, line start station identifier, line end station identifier, voltage level and data date;

[0079] Extract the data information of the active power value data node of the unique line associated with the metering point device and the substation, create a new active power management table TableE of the unique line associated with the metering point device and the substation, and record the data information of the unique device identifier at one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date in the data table;

[0080] S2-2: Data integration;

[0081] S2-2-1: Create a new raw data integration table TableG to record data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields;

[0082] S2-2-2: Get all data records of a certain date from TableD, and insert them into TableG in sequence. Compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA. Compare the terminal station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the terminal station name field value in TableG data to the substation name field value in TableA. The segment value is compared with the substation unique identifier field value of TableE. If the two are the same, the starting station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the starting end power field value of TableG data is modified to the power field value of TableE; the terminal station unique identifier field value in the new data just inserted into TableG is compared with the substation unique identifier field value of TableE. If the two are the same, the terminal station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the terminal power field value of TableG data is modified to the power field value of TableE;

[0083] S3: Two-station multi-loop carbon flow route scenario;

[0084] The following is an example of a two-station multi-loop carbon flow route scenario consisting of two substations, Changre Plant and New Materials Plant;

[0085] S3-1: First, record the Changre Plant as substation A and the New Materials Plant as substation B, so a two-station multi-ring substation (A, B) can be obtained. The two records with the starting station as substation A and the terminal station as substation B are as follows: one record records the starting power P1(A, R1(A, B)) and the terminal power P1(B, R1(A, B)) of R1(A, B), and the other record records the starting power P1(A, R2(A, B)) and the terminal power P1(B, R2(A, B)) of the starting station R2(A, B). When the starting station is substation B and the terminal station is substation A, one record is as follows: one record records the starting power P1(B, R1(B, A)) and the terminal power P1(A, R1(B, A)) of R1(B, A);

[0086] S3-2: Compare the starting power values ​​of the above data records. Take the data record with the smallest starting power and do the following processing:

[0087] S3-2-1: Assume that the starting-end power P1(B,R1(B,A)) of R1(B,A) is the smallest, subtract P1(B,R1(B,A)) from the starting-end power of R1(A,B) and R2(A,B) respectively, and add P1(B,R1(B,A)) to the end-end power.

[0088] S3-2-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0.

[0089] S3-2-3: Eliminate data records whose starting power and ending power are both 0, and repeat steps S1-2-1 and S1-2-2 for the remaining data records until only one data record remains.

[0090] S4: single-loop carbon flow route scenario;

[0091] The following is an example of a two-station single-loop (i.e., the simplest single-loop) carbon flow route scenario consisting of the two substations of Lugang Station and Nanguanling Station:

[0092] S4-1: In TableG, the set of all data records on the loop is recorded as set RL = {RL1, RL2, RL3...}.

[0093] S4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL:

[0094] Compare the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value; the following takes the starting power field value of RL1 as an example for processing:

[0095] When the starting power field value of RL1 is the smallest, first, subtract the starting power field value of RL1 from the starting power field value of each data record in the set RL except RL1, and add the end power field value of RL1 to the end power field value, and then, modify both the starting power field value and the end power field value of RL1 to 0.

[0096] The present invention is calculated through specific use with data from Dalian City, Liaoning Province on July 1, 2024. Through actual verification, the present invention calculates that the multi-loop power modification value composed of Changre Plant and New Materials Station is 77.506004, and the single-loop power modification value composed of Lugang Station and Nanguanling Station is 70.425499. After the power value is modified, the loop electric energy is eliminated, and it is actually measured that the dead loop phenomenon in each loop disappears, the power in the circuit returns to normal, and the carbon flow emission value calculated by the power value of each loop is closer to the actual working environment value.

[0097] The above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that they can still modify or replace the technical solution of the present invention with equivalents, and these modifications or equivalent replacements cannot cause the modified technical solution to deviate from the spirit and scope of the technical solution of the present invention.

Claims

1. A method for calculating the topology of a power carbon emission flow ring network, characterized in that: The steps include: S1: Get raw data; S1-1: The smart grid dispatching control system exports data files offline. The data file content includes: static archive data section, topology information data section, and operating power data section; Static archive data nodes include: substation archive data node, generator set archive data node, load archive data node; The topology information data section includes: substation connection file data section; The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment; S2: Raw data integration; S2-1: file data is entered into the database; Extract the data information of the substation archive data section, create a new substation archive table TableA, and record the data information of the substation's unique identifier, substation name, substation type and reference voltage field in TableA; Extract the data information of the generator set archive data section, create a new generator set archive table TableB, and record the data information of the generator set's unique identifier, generator set name, voltage level, substation unique identifier, power generation and data date in TableB; Extract the data information of the load archive data section, create a new load archive table TableC, and maintain the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table; Extract the data information of the substation connection file data section, and create a new substation connection file table TableD, in which TableD records the data information of the line's unique identifier, line name, line start station identifier, line end station identifier, voltage level and data date; Extract the data information of the active power value data node of the unique line associated with the metering point device and the substation, create a new active power management table TableE of the unique line associated with the metering point device and the substation, and record the data information of the unique device identifier at one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date in the data table; S2-2: Data integration; S2-2-1: Create a new raw data integration table TableG to record data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields; S2-2-2: Get all data records of a certain date from TableD, and insert them into TableG in sequence. Compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA. Compare the terminal station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the terminal station name field value in TableG data to the substation name field value in TableA. The segment value is compared with the substation unique identifier field value of TableE. If the two are the same, the starting station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the starting end power field value of TableG data is modified to the power field value of TableE; the terminal station unique identifier field value in the new data just inserted into TableG is compared with the substation unique identifier field value of TableE. If the two are the same, the terminal station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the terminal power field value of TableG data is modified to the power field value of TableE; S3: Two-station multi-loop carbon flow route scenario; S3-1: In TableA, take any two substation name field data records, record them as RA and RB respectively, record the substation unique identifier field value of data record RA as MA, and record the substation unique identifier field value of data record RB as MB; S3-2: In TableG, when the unique identification field of the starting station is MA and the unique identification field value of the terminal station is MB, or when the unique identification field of the starting station is MB and the unique identification field value of the terminal station is MA and the positive and negative signs of the power field values ​​of the starting end and the power field values ​​of the terminal end are different, it is considered that a two-station multi-ring scenario occurs, and a two-station multi-ring substation (A, B) can be obtained. In the substation (A, B), A represents the starting end of the substation, and B represents the end of the substation; S3-3: In TableG, when there are two records with the starting station unique identification field value of MA and the terminal station unique identification field value of MB, the following are as follows: one record is the starting end power P1(A, R1(A, B)) and the terminal power P1(B, R1(A, B)) of R1(A, B), and the other record is the starting end power P1(A, R2(A, B)) and the terminal power P1(B, R2(A, B)) of the starting station R2(A, B); when there is a record with the starting station unique identification field value of MB and the terminal station unique identification field value of MA, the following is as follows: one record is the starting end power P1(B, R1(B, A)) and the terminal power P1(A, R1(B, A)) of R1(B, A); S3-4: Compare the starting power values ​​of the above data records, and take the data record with the smallest starting power for the following processing: S3-4-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest, subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B), and add P1(B,R1(B,A)) to the end power; S3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0; S3-4-3: Eliminate data records where both the starting power and the ending power are 0, and repeat steps S3-4-1 and S3-4-2 for the remaining data records until only one data record is left; when there is only one line between the two stations with power at both ends not 0, only this data is used in the carbon flow calculation process to complete the creation of a single loop; S4: single-loop carbon flow route scenario; S4-1: In TableG, the set of all line data on the loop is recorded as set RL = {RL1, RL2, RL3...}; S4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL: Compare the starting power field values ​​of each line data RLi in RL one by one to find the line data record with the minimum starting power field value; the following takes the starting power field value of RL1 as an example for processing: When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0; when the line data of a single loop has a line with power at both ends of 0, this data is excluded from the carbon flow calculation process to complete the creation of multiple loops.

2. A power carbon emission flow ring network topology calculation system, characterized in that: include: Data acquisition module, data integration module, comparison module; M1: Get the original data; The data acquisition module exports data files offline from the smart grid dispatching and control system. The data file contents include: static archive data section, topology information data section, and operating power data section; Static archive data nodes include: substation archive data node, generator set archive data node, load archive data node; The topology information data section includes: substation connection file data section; The operating power data section includes: the active power value data section of the unique line and substation associated with the metering point equipment; M2: Raw data integration; M2-1: file data is entered into the database; The data integration module extracts data information of the substation archive data section, creates a new substation archive table TableA, and records data information of the substation's unique identifier, substation name, substation type, and reference voltage field in TableA; The data integration module extracts the data information of the generator set archive data section, and creates a new generator set archive table Table B, which records the data information of the generator set's unique identifier, generator set name, voltage level, substation unique identifier, power generation and data date; The data integration module extracts the data information of the load archive data section, creates a new load archive table TableC, and maintains the data information of the load's unique identifier, load name, substation unique identifier, load power and data date in the data table; The data integration module extracts data information of the substation connection file data section, and creates a new substation connection file table TableD, which records the data information of the line's unique identifier, line name, line start station identifier, line end station identifier, voltage level and data date; The data integration module extracts the data information of the active power value data node of the unique line associated with the metering point device and the substation, and creates a new active power management table Table E of the unique line associated with the metering point device and the substation. The data table records the data information of the unique device identifier at one end of the line of the metering point, the line name, the unique identifier of the substation to which it belongs, the unique identifier of the line, the power and the data date; M2-2: Data integration; M2-2-1: The data integration module creates a new raw data integration table TableG, which records the data date, line unique identifier, line name, starting station unique identifier, starting station name, terminal station unique identifier, terminal station name, voltage level, starting station metering point unique identifier, starting terminal power, terminal station metering point unique identifier and terminal power related fields; M2-2-2: Get all data records of a certain date from TableD, and insert them into TableG in sequence. Compare the starting station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the starting station name field value of TableG data to the substation name field value in TableA. Compare the terminal station unique identification field value in the newly inserted data of TableG with the substation unique identifier field value in TableA one by one. If the two are the same, modify the terminal station name field value of TableG data to the substation name field value in TableA. The segment value is compared with the substation unique identifier field value of TableE. If the two are the same, the starting station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the starting end power field value of TableG data is modified to the power field value of TableE; the terminal station unique identifier field value in the new data just inserted into TableG is compared with the substation unique identifier field value of TableE. If the two are the same, the terminal station metering point unique identifier field value of TableG data is modified to the line end unique device identifier field value of TableE, and the terminal power field value of TableG data is modified to the power field value of TableE; M3: Two-station multi-loop carbon flow route scenario; M3-1: In TableA, the comparison module takes any two substation data records, which are recorded as RA and RB respectively, and records the substation unique identifier field value of data record RA as MA, and the substation unique identifier field value of data record RB as MB; M3-2: In TableG, when the unique identification field of the starting station is MA and the unique identification field value of the terminal station is MB, or when the unique identification field of the starting station is MB and the unique identification field value of the terminal station is MA and the positive and negative signs of the power field values ​​of the starting end and the power field values ​​of the terminal end are different, it is considered that a two-station multi-ring scenario occurs, and a two-station multi-ring substation (A, B) can be obtained; M3-3: In TableG, when there are two records with the starting station unique identification field value of MA and the terminal station unique identification field value of MB, they are as follows: one record is the starting end power P1(A, R1(A, B)) and the terminal power P1(B, R1(A, B)) of R1(A, B), and the other record is the starting end power P1(A, R2(A, B)) and the terminal power P1(B, R2(A, B)) of the starting station R2(A, B); when there is a record with the starting station unique identification field value of MB and the terminal station unique identification field value of MA, it is as follows: one record is the starting end power P1(B, R1(B, A)) and the terminal power P1(A, R1(B, A)) of R1(B, A); M3-4: Compare the starting power values ​​of the above three records, and take the data record with the smallest starting power for the following processing: M3-4-1: Assume that the starting power P1(B,R1(B,A)) of R1(B,A) is the smallest, subtract P1(B,R1(B,A)) from the starting power of R1(A,B) and R2(A,B), and add P1(B,R1(B,A)) to the end power; M3-4-2: Change the starting power P1(B,R1(B,A)) and the ending power P1(A,R1(B,A)) of R1(B,A) to 0; M3-4-3: Eliminate data records with both the start-end power and the end-end power being 0, and repeat steps M3-4-1 and M3-4-2 for the remaining data records until only one data record remains, thus completing the creation of the multi-loop; M4: single-loop carbon flow route scenario; M4-1: In TableG, the set of all data records on the loop is recorded as set RL = {RL1, RL2, RL3...}; M4-2: Perform the following processing on each line data RLi (i∈N+) in the line data information set RL: The comparison module compares the starting power field values ​​of each line data RLi in RL one by one, and finds the line data record with the minimum starting power field value; the following takes the starting power field value of RL1 as an example for processing: When the starting power field value of RL1 is the smallest, the starting power field value of each data record in the set RL except RL1 is subtracted from the starting power field value of RL1, and the end power field value is added to the end power field value of RL1, and then the starting power field value and the end power field value of RL1 are all modified to 0.

Images