Transformer substation and converter station point table generation method based on typical interval point table

Abstract

The invention relates to a typical interval point table-based substation and converter station point table generation method. The method comprises the following steps of defining point table attributes according to a historical point table of a substation or a converter station, and respectively constructing typical interval point table templates of different types of intervals; classifying attributes of typical interval point table templates of different interval types based on historical point tables of different types of intervals, and setting different replacement strategies for different types of attributes; collecting a real-time signal name in the current transformer substation or converter station and carrying out standardization processing on the real-time signal name; performing similarity calculation on the names of the real-time signals after standardization processing and the names of the signals in the typical interval point table templates of the corresponding intervals, and selecting signal data with the highest similarity to construct an initial point table of the real-time signals; and replacing the different types of attribute values in the initial point table through corresponding replacement strategies according to the actual configuration information of the transformer substation or the converter station to obtain a point table of the current signal.

Description

Technical Field

[0001] The invention relates to a method for generating a transformer substation and converter station table based on a typical interval point table, and belongs to the technical field of power system automation. Background Art

[0002] Substations and converter stations are crucial nodes in the power system, responsible for the transmission, distribution and control of electric energy.

[0003] As a core component of the automation system of substations and converter stations, the point meter records the signal information of each interval. The accuracy and completeness of the point meter directly affect the monitoring, protection and dispatching capabilities of substations and converter stations.

[0004] The existing method of compiling point tables usually involves manually filling in each point table, which has the following shortcomings:

[0005] Inefficiency: Point tables must be compiled manually, one by one, which is particularly time-consuming and labor-intensive in large-scale substations and converter stations. For example, a typical 220kV substation may have tens of thousands of point tables, making compilation a tremendous workload.

[0006] Error-prone: Manual operations are prone to omissions and errors. For example, incorrect signal names or device models may cause the monitoring system to be unable to correctly identify the signal, thus affecting the normal operation of the system.

[0007] Poor consistency: There is a lot of similarity in the point table information at different intervals, and it is difficult to ensure consistency through manual filling and review.

[0008] Difficulty in maintenance: When the substation configuration changes, the point table needs to be updated. Manually modifying each one is not only tedious but also prone to omissions, resulting in the point table not matching the actual configuration. Summary of the Invention

[0009] In order to solve the above problems existing in the prior art, the present invention proposes a method for generating a substation and converter station table based on a typical interval point table.

[0010] The technical solutions of the present invention are as follows:

[0011] In one aspect, the present invention provides a method for generating a substation and converter station table based on a typical interval point table, comprising the following steps:

[0012] Define point table attributes according to the historical point table of the substation or converter station, build typical interval point table templates for different types of intervals of the substation or converter station based on the point table attributes, and standardize all typical interval point table templates;

[0013] Based on the historical point tables of different types of intervals in the substation or converter station, the attributes of the typical interval point table templates corresponding to different interval types are classified, and different replacement strategies are set for different types of attributes;

[0014] Collect the real-time signal names in the current substation or converter station and standardize the real-time signal names;

[0015] Calculate the similarity between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval, select the signal data with the highest similarity as the initial template of the real-time signal, and construct the initial point table of the real-time signal based on the initial template;

[0016] According to the actual configuration information of the substation or converter station, different types of attribute values in the initial point table of the real-time signal are replaced by the corresponding replacement strategy to obtain the point table of the current signal. After the above processing is performed on each signal in each interval of the substation or converter station, the full station table is obtained.

[0017] Preferably, the point table attributes include voltage level, interval type, scheduling name, signal name, sending device name and model, receiving device name and model, signal type, whether to send for control, whether to invert, delay, and whether AVC is locked.

[0018] Preferably, similarity calculation is performed between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval based on the Sentence-BERT model.

[0019] Preferably, the attribute types include undifferentiated attributes, differentiated attributes, and partially differentiated attributes;

[0020] The indifferent attribute means that all intervals have the same attribute value, and no replacement is required;

[0021] The difference attribute represents an attribute that needs to be set with different attribute values in different intervals, and its replacement strategy is: replace according to the configuration information of the current interval;

[0022] The partially different attributes represent attributes with partially identical attribute values in different intervals. The replacement strategy is to extract the attribute values in the initial interval point table, delete the different parts of the attribute values, extract the corresponding data from the configuration information of the current interval, and then splice and replace them with the remaining indifferent parts of the attribute values.

[0023] On the other hand, the present invention also provides a substation and converter site table generation system based on a typical interval point table, comprising a typical interval point table template design module, a point table attribute classification module, a signal preprocessing module, a signal matching module, and a full site table generation module;

[0024] The typical interval point table template design module is used to define point table attributes according to the historical point table of the substation or converter station, construct typical interval point table templates for different types of intervals of the substation or converter station based on the point table attributes, and standardize all typical interval point table templates;

[0025] The point table attribute classification module classifies the attributes of the typical interval point table templates corresponding to different interval types based on the historical point tables of different types of intervals of the substation or converter station, and sets different replacement strategies for different types of attributes;

[0026] The signal preprocessing module is used to collect the real-time signal names in the current substation or converter station and perform standardization processing on the real-time signal names;

[0027] The signal matching module is used to calculate the similarity between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval, select the signal data with the highest similarity as the initial template of the real-time signal, and construct the initial point table of the real-time signal based on the initial template;

[0028] The full-site table generation module is used to replace different types of attribute values in the initial point table of the real-time signal through the corresponding replacement strategy according to the actual configuration information of the substation or converter station to obtain the point table of the current signal, and to obtain the full-site table after performing the above processing on each signal of each interval of the substation or converter.

[0029] Preferably, the point table attributes include voltage level, interval type, scheduling name, signal name, sending device name and model, receiving device name and model, signal type, whether to send for control, whether to invert, delay, and whether AVC is locked.

[0030] Preferably, similarity calculation is performed between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval based on the Sentence-BERT model.

[0031] Preferably, the attribute types include undifferentiated attributes, differentiated attributes, and partially differentiated attributes;

[0032] The indifferent attribute means that all intervals have the same attribute value, and no replacement is required;

[0033] The difference attribute represents an attribute that needs to be set with different attribute values in different intervals, and its replacement strategy is: replace according to the configuration information of the current interval;

[0034] The partially different attributes represent attributes with partially identical attribute values in different intervals. The replacement strategy is to extract the attribute values in the initial interval point table, delete the different parts of the attribute values, extract the corresponding data from the configuration information of the current interval, and then splice and replace them with the remaining indifferent parts of the attribute values.

[0035] On the other hand, the present invention further provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method described in any embodiment of the present invention when executing the program.

[0036] In another aspect, the present invention further provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the method as described in any embodiment of the present invention.

[0037] The present invention has the following beneficial effects:

[0038] 1. This invention realizes the efficient and accurate generation of substation and converter station tables through standardized typical interval point table template design, intelligent semantic matching and automatic replacement strategy, which significantly improves the efficiency and consistency of point table compilation and is suitable for the design and operation and maintenance of large-scale substations and converter stations. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 Flow chart of the method of the present invention. DETAILED DESCRIPTION

[0040] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0041] It should be understood that the step numbers used herein are only for convenience of description and are not intended to limit the order in which the steps are to be executed.

[0042] It should be understood that the terms used in the present specification are only for the purpose of describing specific embodiments and are not intended to limit the present invention. As used in the present specification and the appended claims, the singular forms "a", "an" and "the" are intended to include the plural forms unless the context clearly indicates otherwise.

[0043] The terms “include” and “comprising” indicate the presence of described features, integers, steps, operations, elements and / or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or groups thereof.

[0044] The term "and / or" refers to and includes any and all possible combinations of one or more of the associated listed items.

[0045] Example 1:

[0046] See also Figure 1 A method for generating a substation and converter station table based on a typical interval point table comprises the following steps:

[0047] Define point table attributes based on the historical point table of the substation or converter station. Build typical interval point table templates for different types of bays in the substation or converter station based on the point table attributes. Standardize all typical interval point table templates (ensuring that the format and naming rules of the typical interval point table are consistent).

[0048] Optionally, when constructing a point table template for a typical interval, an extension field is reserved to meet future expansion requirements of the point table information, for example, "spare field 1" and "spare field 2" are added to record newly added signal attributes;

[0049] Based on the historical point tables of different types of intervals of the substation or converter station, the attributes of the typical interval point table template corresponding to the interval type are classified, and different replacement strategies are set for different types of attributes;

[0050] Collect the real-time signal names in the current substation or converter station and standardize the real-time signal names;

[0051] Since the signal contents of different substations / converter stations vary, and monitoring personnel usually have standardized requirements for monitoring point tables, such as some key signals cannot be missing, and some unimportant signals do not need to be sent to avoid signal flooding, signal names need to be defined according to standardized templates. This requires that the signal names of actual projects need to match the standard signal names. Therefore, the actual signal names of the current substation or converter station need to be standardized. For example, the "line 1271_protection action signal" is removed from the interval name "line 1" and the dispatch number "271" to generate the "protection action signal";

[0052] Calculate the similarity between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval, select the signal data with the highest similarity as the initial template of the real-time signal, and construct the initial point table of the real-time signal based on the initial template;

[0053] According to the actual configuration information of the substation or converter station, different types of attribute values in the initial point table of the real-time signal are replaced by the corresponding replacement strategy to obtain the point table of the current signal. After the above processing is performed on each signal in each interval of the substation or converter station, the full station table is obtained.

[0054] As a preferred implementation scheme of this embodiment, the point table attributes include voltage level, interval type, scheduling name, signal name, sending device name and model, receiving device name and model, signal type, whether to send for control, whether to invert, delay, and whether AVC is locked.

[0055] As a preferred implementation method of this embodiment, the similarity calculation is performed on the standardized real-time signal name and the signal name in the typical interval point table template of its corresponding interval based on the Sentence-BERT model. At the same time, a weight mechanism is introduced in the similarity calculation to give higher weights to key signals (such as protection action signals and telesignaling signals) to ensure their matching priority.

[0056] As a preferred implementation of this embodiment, the attribute types include non-differentiated attributes, differentiated attributes, and partially differentiated attributes;

[0057] The non-differentiated attributes refer to attributes (e.g., voltage level and bay type) that are set to the same attribute value for all bays and do not need to be replaced;

[0058] The difference attributes represent attributes that need to be set with different attribute values in different intervals (for example, scheduling name, sending device model, receiving device model, etc.), and the replacement strategy is: replace according to the configuration information of the current interval;

[0059] The partially different attributes represent attributes with partially identical attribute values set in different intervals (for example, the signal name may contain a dispatch number, a device model, etc., where the dispatch numbers are different but the signal content is the same). The replacement strategy is: extract the attribute values in the initial interval point table, delete the different parts in the attribute values, and then extract the corresponding data from the configuration information of the current interval and splice the remaining non-differential parts in the attribute values before replacing them (for example, the signal name "Line 1 271_Protection Action Signal" is replaced with "Line 2 272_Protection Action Signal").

[0060] Example 2:

[0061] A substation and converter station table generation system based on a typical interval point table includes a typical interval point table template design module, a point table attribute classification module, a signal preprocessing module, a signal matching module, and a full station table generation module;

[0062] The typical interval point table template design module is used to define point table attributes according to the historical point table of the substation or converter station, construct typical interval point table templates for different types of intervals of the substation or converter station based on the point table attributes, and standardize all typical interval point table templates;

[0063] The point table attribute classification module classifies the attributes of the typical interval point table template corresponding to the interval type based on the historical point tables of different types of intervals of the substation or converter station, and sets different replacement strategies for different types of attributes;

[0064] The signal preprocessing module is used to collect the real-time signal names in the current substation or converter station and perform standardization processing on the real-time signal names;

[0065] The signal matching module is used to calculate the similarity between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval, select the signal data with the highest similarity as the initial template of the real-time signal, and construct the initial point table of the real-time signal based on the initial template;

[0066] The full-site table generation module is used to replace different types of attribute values in the initial point table of the real-time signal through the corresponding replacement strategy according to the actual configuration information of the substation or converter station to obtain the point table of the current signal. After performing the above processing on each signal of each interval of the substation or converter, the full-site table is obtained, and supports output in multiple formats such as Excel and XML.

[0067] As a preferred implementation scheme of this embodiment, the point table attributes include voltage level, interval type, scheduling name, signal name, sending device name and model, receiving device name and model, signal type, whether to send for control, whether to invert, delay, and whether AVC is locked.

[0068] As a preferred implementation of this embodiment, similarity calculation is performed between the normalized real-time signal names and the signal names in the typical interval point table template of the corresponding intervals based on the Sentence-BERT model.

[0069] As a preferred implementation of this embodiment, the attribute types include non-differentiated attributes, differentiated attributes, and partially differentiated attributes;

[0070] The indifferent attribute means that all intervals have the same attribute value, and no replacement is required;

[0071] The difference attribute represents an attribute that needs to be set with different attribute values in different intervals, and its replacement strategy is: replace according to the configuration information of the current interval;

[0072] The partially different attributes refer to attributes with partially identical attribute values in different intervals. The replacement strategy is as follows: extract the attribute values in the initial interval point table, delete the different parts of the attribute values, extract the corresponding data from the configuration information of the current interval, and concatenate them with the remaining unchanged parts of the attribute values before replacing them.

[0073] This system is used to implement the method in Example 1 and will not be described in detail here.

[0074] Example 3:

[0075] This embodiment provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the method described in any embodiment of the present invention is implemented.

[0076] Example 4:

[0077] This embodiment provides a computer-readable storage medium having a computer program stored thereon. When the program is executed by a processor, the method described in any embodiment of the present invention is implemented.

[0078] In the embodiments of the present application, "at least one" refers to one or more, and "more" refers to two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can represent the existence of A alone, the existence of A and B at the same time, and the existence of B alone. Among them, A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following" and similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one of a, b and c can represent: a, b, c, a and b, a and c, b and c or a and b and c, where a, b, c can be single or multiple.

[0079] Those skilled in the art will appreciate that the various units and algorithm steps described in the embodiments disclosed herein can be implemented using a combination of electronic hardware, computer software, and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.

[0080] Those skilled in the art will clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0081] In the several embodiments provided in this application, if any function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in each embodiment of this application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory; hereinafter referred to as: ROM), random access memory (Random Access Memory; hereinafter referred to as: RAM), magnetic disk or optical disk, and other media that can store program code.

[0082] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention's description and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for generating a substation and converter station table based on a typical interval point table, characterized in that: The following steps are involved: Define point table attributes according to the historical point table of the substation or converter station, build typical interval point table templates for different types of intervals of the substation or converter station based on the point table attributes, and standardize all typical interval point table templates; Based on the historical point tables of different types of intervals in the substation or converter station, the attributes of the typical interval point table templates corresponding to different interval types are classified, and different replacement strategies are set for different types of attributes; Collect the real-time signal names in the current substation or converter station and standardize the real-time signal names; Calculate the similarity between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval, select the signal data with the highest similarity as the initial template of the real-time signal, and construct the initial point table of the real-time signal based on the initial template; According to the actual configuration information of the substation or converter station, different types of attribute values in the initial point table of the real-time signal are replaced by the corresponding replacement strategy to obtain the point table of the current signal. After the above processing is performed on each signal in each interval of the substation or converter station, the full station table is obtained.

2. A method for generating a substation and converter station table based on a typical interval point table according to claim 1, characterized in that: The point table attributes include voltage level, interval type, scheduling name, signal name, sending device name and model, receiving device name and model, signal type, whether to send for control, whether to invert, delay, and whether AVC is locked.

3. The method for generating a substation and converter station table based on a typical interval point table according to claim 1, characterized in that: Based on the Sentence-BERT model, the similarity between the standardized real-time signal names and the signal names in the typical interval point table template of their corresponding intervals is calculated.

4. The method for generating a substation and converter station table based on a typical interval point table according to claim 1, characterized in that: The attribute types include undifferentiated attributes, differentiated attributes, and partially differentiated attributes; The indifferent attribute means that all intervals have the same attribute value, and no replacement is required; The difference attribute represents an attribute that needs to be set with different attribute values in different intervals, and its replacement strategy is: replace according to the configuration information of the current interval; The partially different attributes represent attributes with partially identical attribute values in different intervals. The replacement strategy is to extract the attribute values in the initial interval point table, delete the different parts of the attribute values, extract the corresponding data from the configuration information of the current interval, and then splice and replace them with the remaining indifferent parts of the attribute values.

5. A system for generating a substation and converter station table based on a typical interval point table, characterized in that: It includes a typical interval point table template design module, a point table attribute classification module, a signal preprocessing module, a signal matching module, and a full site table generation module; The typical interval point table template design module is used to define point table attributes according to the historical point table of the substation or converter station, construct typical interval point table templates for different types of intervals of the substation or converter station based on the point table attributes, and standardize all typical interval point table templates; The point table attribute classification module classifies the attributes of the typical interval point table templates corresponding to different interval types based on the historical point tables of different types of intervals of the substation or converter station, and sets different replacement strategies for different types of attributes; The signal preprocessing module is used to collect the real-time signal names in the current substation or converter station and perform standardization processing on the real-time signal names; The signal matching module is used to calculate the similarity between the normalized real-time signal name and the signal name in the typical interval point table template of the corresponding interval, select the signal data with the highest similarity as the initial template of the real-time signal, and construct the initial point table of the real-time signal based on the initial template; The full-site table generation module is used to replace different types of attribute values in the initial point table of the real-time signal through the corresponding replacement strategy according to the actual configuration information of the substation or converter station to obtain the point table of the current signal, and to obtain the full-site table after performing the above processing on each signal of each interval of the substation or converter.

6. A system for generating a substation and converter station table based on a typical interval point table according to claim 5, characterized in that: The point table attributes include voltage level, interval type, scheduling name, signal name, sending device name and model, receiving device name and model, signal type, whether to send for control, whether to invert, delay, and whether AVC is locked.

7. A system for generating a substation and converter station table based on a typical interval point table according to claim 5, characterized in that: Based on the Sentence-BERT model, the similarity between the standardized real-time signal names and the signal names in the typical interval point table template of their corresponding intervals is calculated.

8. A system for generating a substation and converter station table based on a typical interval point table according to claim 5, characterized in that: The attribute types include undifferentiated attributes, differentiated attributes, and partially differentiated attributes; The indifferent attribute means that all intervals have the same attribute value, and no replacement is required; The difference attribute represents an attribute that needs to be set with different attribute values in different intervals, and its replacement strategy is: replace according to the configuration information of the current interval; The partially different attributes represent attributes with partially identical attribute values in different intervals. The replacement strategy is to extract the attribute values in the initial interval point table, delete the different parts of the attribute values, extract the corresponding data from the configuration information of the current interval, and then splice and replace them with the remaining indifferent parts of the attribute values.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the method according to any one of claims 1 to 4 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.

Images