Power grid topology connection relation generation method based on structured language

Abstract

The invention discloses a power grid topology connection relation generation method based on a structured language, the method aims to find a rapid topology connection relation generation method to meet topology analysis work in a power grid application scenario, according to the method, a structured query language is utilized, and a basic connection relation table, a point table, a line table, a transformer table and the like are used, so that the topology analysis work in a power grid application scenario is completed. A power grid topology connection relation is automatically constructed by establishing a view template and establishing an intermediate table according to the view template in combination with judgment of data integrity.

Description

Technical Field

[0001] The invention relates to the field of digital application technology, and in particular to a method for generating power grid topology connection relations based on structured language. Background Art

[0002] The topological relationship used in the power business is mainly the connection relationship between point devices and line devices. Representative point devices include: circuit breakers, disconnectors, fuses, etc.; line devices include overhead wires, cables, down conductors, etc. When the power grid is in operation, the power consumption will change over time, and the current flow direction in the line will also change accordingly. If the operation and maintenance personnel want to know the instantaneous flow direction of the current, they need to perform a power flow analysis on the power grid; when a planned power outage is required for maintenance, the customer service staff needs to know which users will be affected after the power outage at the maintenance point, and traceability analysis will be used; these analysis functions are inseparable from the topological connection relationship between devices. The traditional application method of topological relationships is convenient for program storage and analysis, but not for multi-system exchange and manual reading. Therefore, it is necessary to find a form that is convenient for multi-system exchange and manual reading, and can ensure a clear generation logic to solve the problem, so as to meet both the exchange between systems and the possible connection errors that can be checked by manual reading. Summary of the invention

[0003] The purpose of the present invention is to solve the shortcomings of the prior art and propose a method for generating power grid topology connection relationships based on structured language, aiming to find a fast topology connection relationship generation method to meet the topology analysis work in power grid application scenarios. The method uses structured query language, basic connection relationship tables, point tables, line tables, transformer tables, etc., and automatically constructs power grid topology connection relationships by creating view templates and creating intermediate tables according to the view templates, combined with judging data integrity.

[0004] The present invention discloses a method for generating a topological connection relationship of a power grid based on a structured language, comprising the following steps:

[0005] S1. Collect basic information of power grid equipment using mobile devices;

[0006] S2. Create a view Topo_view based on the district table district, switch table switch, low-voltage distribution box table distribution, line table line, point table point, connection relationship table connection table, and user set table user, and use the view Topo_view to create a topology table t_topocol;

[0007] S3. Create a view Topo_view_1 based on the topology table t_topocol, and use the view Topo_view_1 to create a topology table t_topocol_1;

[0008] S4. Create view Topo_view_2 based on topology table t_topocol_1, and create topology table t_topocol_2 using view Topo_view_2;

[0009] S5. Create view Topo_view_3 based on topology table t_topocol_2;

[0010] S6. Use Topo_view, t_topocol, t_topocol_1, Topo_view_1, t_topocol_2, Topo_view_2, and Topo_view_3 to iteratively generate the final topological connection relationship table topotable;

[0011] S7. Export the topological connection relationship table topotable to a table file format.

[0012] Preferably, the basic information of the power grid equipment in S1 includes: a district table, a switch table, a low-voltage distribution box table, a line table, a point table, and a connection relationship table.

[0013] Preferably, the iterative steps in S6 are:

[0014] S6.1: delete from t_topocol;

[0015] INSERT INTO t_topocol select*from Topo_view;

[0016] delete from t_topocol_1;

[0017] INSERT INTO t_topocol_1select*from Topo_view_1;

[0018] S6.2: delete from t_topocol_2;

[0019] INSERT INTO t_topocol_2select*from Topo_view_2;

[0020] delete from t_topocol_1;

[0021] INSERT INTO t_topocol_1select*from Topo_view_3;

[0022] S6.3: select count(*) empty line number from t_topocol_1t where t.tqid = the station area identifier to be generated and t.dyxlmc ISNULL;

[0023] If the number of empty lines > 0 and the number of empty lines changes twice, then go to the second step;

[0024] Then generate the topological connection relationship table topotable based on the t_topocol_1 table.

[0025] The advantages and technical effects of the present invention are:

[0026] (1) The topology relationship generation method fully utilizes the inherent parallel computing advantages of the database, and the query method supports parallel topology detection, which effectively avoids the algorithm dead loop problem caused by loops when the contact switch state is incorrect.

[0027] (2) The topological relationship generation method adopts an architectural design method that separates the basic data table generation and the topological relationship table generation logic. This allows the mobile data collection software to focus on data collection implementation, while the database is responsible for topological relationship table generation. It breaks down complex and large logic into weakly related simple logic, which is beneficial to software design, effectively reduces the defects caused by design complexity, and improves operational reliability.

[0028] (3) The database side of the topological relationship generation method can be implemented in the local file database on the mobile side or on the server side, which increases flexibility, facilitates the coordination of computing power, and improves algorithm efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 The topological relationship generation process in the present invention;

[0030] Figure 2 is an information table used in the present invention;

[0031] Figure 3 The topology connection relationship file format used in the present invention;

[0032] Figure 4 Topo_view is the view used in the present invention;

[0033] Figure 5 It is the view Topo_view_1 used in the present invention;

[0034] Figure 6 It is the view Topo_view_2 used in the present invention;

[0035] Figure 7 This is the view Topo_view_3 used in the present invention. DETAILED DESCRIPTION

[0036] The embodiments of the invention are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the invention, and cannot be understood as limiting the invention.

[0037] The present invention discloses a method for generating a topological connection relationship of a power grid based on a structured language, which comprises at least the following steps:

[0038] 1. Use mobile devices to collect basic information of power grid equipment, including district table, switch table, low-voltage distribution box table, line table, point table, and connection relationship table.

[0039] 2. Create the view Topo_view based on the district table district, switch table switch, low-voltage distribution box table distribution, line table line, point table point, connection relationship table connection table, and user set table user, and use the view Topo_view to create the topology table t_topocol.

[0040] 3. Create view Topo_view_1 based on topology table t_topocol, and use view Topo_view_1 to create topology table t_topocol_1.

[0041] 4. Create view Topo_view_2 based on topology table t_topocol_1, and use view Topo_view_2 to create topology table t_topocol_2.

[0042] 5. Create view Topo_view_3 based on topology table t_topocol_2.

[0043] 6. Use Topo_view, t_topocol, t_topocol_1, Topo_view_1, t_topocol_2, Topo_view_2, Topo_view_3 to iteratively generate the final topological connection relationship table topotable. The steps are as follows:

[0044] first step:

[0045] delete from t_topocol;

[0046] INSERT INTO t_topocol select*from Topo_view;

[0047] delete from t_topocol_1;

[0048] INSERT INTO t_topocol_1select*from Topo_view_1;

[0049] Step 2:

[0050] delete from t_topocol_2;

[0051] INSERT INTO t_topocol_2select*from Topo_view_2;

[0052] delete from t_topocol_1;

[0053] INSERT INTO t_topocol_1select*from Topo_view_3;

[0054] Step 3:

[0055] select count(*) empty line number from t_topocol_1t where t.tqid = the area ID to be generated and t.dyxlmc ISNULL;

[0056] If the number of empty lines > 0 and the number of empty lines changes twice, then go to the second step;

[0057] Then generate the topological connection relationship table topotable based on the t_topocol_1 table.

[0058] 7. Export the topological connection relationship table topotable to a table file format.

[0059] Finally, all the parts of the invention not fully described adopt mature products and mature technical means in the existing technology.

[0060] In the description of this specification, reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in the embodiment or example of the invention.

[0061] Although embodiments of the invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the invention, and that the scope of the invention is defined by the claims and their equivalents.

Claims

1. A method for generating a power grid topology connection relationship based on a structured language, characterized in that: The following steps are involved: S1. Collect basic information of power grid equipment using mobile devices; S2. Create a view Topo_view based on the district table district, switch table switch, low-voltage distribution box table distribution, line table line, point table point, connection relationship table connection table, and user set table user, and use the view Topo_view to create a topology table t_topocol; S3. Create a view Topo_view_1 based on the topology table t_topocol, and use the view Topo_view_1 to create a topology table t_topocol_1; S4. Create view Topo_view_2 based on topology table t_topocol_1, and create topology table t_topocol_2 using view Topo_view_2; S5. Create view Topo_view_3 based on topology table t_topocol_2; S6. Use Topo_view, t_topocol, t_topocol_1, Topo_view_1, t_topocol_2, Topo_view_2, and Topo_view_3 to iteratively generate the final topological connection relationship table topotable; S7. Export the topological connection relationship table topotable to a table file format.

2. The method for generating a power grid topology connection relationship based on a structured language according to claim 1, characterized in that: The basic information of the power grid equipment in S1 includes: a district table, a switch table, a low-voltage distribution box table, a line table, a point table, and a connection relationship table.

3. The method for generating a power grid topology connection relationship based on a structured language according to claim 1, characterized in that: The iterative steps in S6 are: S6.1: delete from t_topocol; INSERT INTO t_topocol select*from Topo_view; delete from t_topocol_1; INSERT INTO t_topocol_1select*from Topo_view_1; S6.2: delete from t_topocol_2; INSERT INTO t_topocol_2select*from Topo_view_2; delete from t_topocol_1; INSERT INTO t_topocol_1select*from Topo_view_3; S6.3: select count(*) empty line number from t_topocol_1t where t.tqid = the area ID to be generated and t.dyxlmc ISNULL; If the number of empty lines > 0 and the number of empty lines changes twice, then go to the second step; Then generate the topological connection relationship table topotable based on the t_topocol_1 table.

Images