Method and system for generating master station monitoring information point table based on information template

Abstract

The invention discloses a master station monitoring information point table generation method and system based on an information template, and belongs to the technical field of electric power automation control. The method specifically comprises the following steps: making an information point table template file according to a master station monitoring information related standard file; loading the template file, and analyzing and reading information in the template file; reading database information of each secondary device in the station; configuring a mapping relation between a primary interval and secondary equipment in the transformer substation and the type of the secondary equipment; on the basis of each equipment information point in the template file, sequentially matching information points meeting the requirements in the template from each secondary equipment database in the station; and automatically generating an output information point table file, and realizing the generation of the master station monitoring information point table based on the information template. According to the method, all the information points meeting the requirements are automatically selected from the database of the whole station based on the formulated point table template file, the purpose of automatically generating the standard information point table file is achieved, the efficiency of designing and manufacturing the monitoring information point table of the main station is improved, and the labor cost input is reduced.

Description

Technical Field

[0001] The present invention belongs to the technical field of electric power automation control, and more specifically, relates to a method and system for generating a master station monitoring information point table based on an information template. Background Art

[0002] With the continuous advancement of electrical automation technology, the scale of the power grid has gradually expanded, the amount of information that can be collected in the station has gradually increased, and the amount of monitoring information at the master station has also increased accordingly. The master station side relies on manually designed methods to issue dispatch information point tables, which gradually reveal the disadvantage of not matching the speed of the development of the scale of power grid information. The traditional way of issuing information point tables is that the design institute screens the information points collected in the station according to the relevant specification documents of the monitoring information, writes the required information points under each interval in the substation into the point table, and forms the final point table after review by professional departments, modification by the design institute, and final confirmation. This process relies on manual work and experience, and has problems such as being time-consuming and prone to errors.

[0003] With the rapid increase in the amount of information in the power grid, the manual point table method has been exhausted to cope with the massive amount of information. It is necessary to use automated software technology to improve the efficiency and standardization of generating information point tables. Under the premise of gradually standardizing the monitoring information of the master station and the station model, the process of manually issuing point tables is algorithmized, and the automated process replaces the manual process to solve the problem of automatic generation of substation monitoring information point tables. Therefore, a method for quickly generating substation monitoring information point tables is proposed.

[0004] Prior art document 1 (CN106505731B) discloses a system and method for intelligent generation of test cases for smart substation and dispatching. Its shortcoming is that it only solves the problem of manual point-to-point in the substation and dispatching point-to-point scenario by using keyword library files, and does not solve the problem from the source of dispatching monitoring information.

[0005] Prior art document 2 (CN110737752B) discloses a method, device and system for identifying power monitoring information, but its shortcoming is that it only solves the problem of standardization verification of the master station monitoring information point table. Summary of the invention

[0006] In order to solve the deficiencies in the prior art, the present invention provides a method for generating a master station monitoring information point table based on an information template. The method formulates an information template file according to a monitoring information point table specification file, and automatically selects all information points that meet the requirements from the full data point table in the station by analyzing and matching the 61850 path and description of the information point, generates a standardized master station monitoring information table, and improves the efficiency of issuing the master station information point table.

[0007] The present invention adopts the following technical solution.

[0008] A first aspect of the present invention provides a method for generating a master station monitoring information point table based on an information template, comprising the following steps:

[0009] According to the relevant specification documents of the master station monitoring information, make the information point table template file;

[0010] Load the information point table template file, parse and read the information in the template file;

[0011] Read the database information of each secondary device in the station, including 61850 path keywords and description keyword information;

[0012] Configure the mapping relationship between the primary bay in the substation and the secondary equipment in the read station-wide database information and configure the type of the secondary equipment to obtain the mapping relationship between the primary bay and the secondary equipment and the type of the secondary equipment;

[0013] According to the mapping relationship between the primary interval and the secondary equipment and the type of the secondary equipment, the corresponding template is determined from the information in the read template file, and the information points that meet the requirements in the corresponding template are matched from the secondary equipment databases in the station in turn to obtain the matching results;

[0014] According to the matching results, the secondary equipment point table information points are selected into the main station information point table, and the main station information point table file is automatically generated and output, so as to realize the generation of the main station monitoring information point table based on the information template.

[0015] Preferably, the information point table template file extracts the interval type and point table information of each type of interval according to the specifications of the master station monitoring information. The point table information of the interval includes the secondary equipment type and keyword information. The keyword information includes 61850 path keywords and description keyword information. The keywords include synonyms, required words, optional words and banned words.

[0016] Preferably, the database information of each secondary device in the station is imported from an SCD file or read from a table file.

[0017] Preferably, configuring the mapping relationship between the primary bay in the substation and the secondary equipment in the read full database information in the substation and configuring the type of the secondary equipment includes:

[0018] According to the actual primary bay content of the substation site, configure the mapping between the primary bay and all secondary devices obtained from the read full-station database, and configure the primary bay description information and secondary device types corresponding to all secondary devices obtained from the read full-station database.

[0019] Preferably, the corresponding template is determined from the information in the read template file according to the mapping relationship between the primary interval and the secondary device and the type of the secondary device, and the information points that meet the requirements in the corresponding template are matched from the secondary device databases in the station in turn, including:

[0020] First, use the 61850 path key information to match the information points that meet the requirements of the corresponding template from the secondary equipment database in the station. If no information point is matched, use the keyword information of the description to match the information point that meets the requirements, or combine the two to match. When matching, determine whether the words used for matching contain required words and do not contain prohibited words before and after the synonym replacement. If so, match again. After the match is successful under the same conditions, select the matching information containing optional words.

[0021] Preferably, from the secondary equipment point table of each secondary equipment database in the station, the information point that matches the template point table is matched, and whether the text s of the secondary equipment point table contains the word x of the template meter information point is expressed by the following formula:

[0022]

[0023] In the formula,

[0024] B(s,x) indicates whether the text s contains the word x.

[0025] Preferably, the text s of the secondary device point table satisfies the matching result R of the keyword requirement of the template point table. s , expressed as follows:

[0026]

[0027] Where:

[0028] E(x) represents the synonyms of word x,

[0029] M represents the set of required words for the currently matched template information point.

[0030] T represents the set of banned words,

[0031] P represents a set of optional words,

[0032] represents the empty set,

[0033] R s Indicates the matching result.

[0034] Preferably, when R s When ≥1, the information point in the secondary equipment point table matches the information point in the template point table successfully, and the information point in the secondary equipment point table is selected into the main station information point table. Otherwise, the information point in the secondary equipment point table fails to match the information point in the template point table and is not selected.

[0035] Preferably, the secondary device description in the information description in the information point table of the master station is automatically replaced with the primary interval description information, and the point numbers in the information point table are automatically generated in sequence.

[0036] The second aspect of the present invention provides a master station monitoring information point table generation system based on an information template, which runs the master station monitoring information point table generation method based on an information template described in the first aspect, comprising:

[0037] Template configuration and loading module: used to create information point table template files according to the relevant specification files of the master station monitoring information, load the information point table template files, and parse and read the information in the template files;

[0038] Full data point table import module: used to read the database information of each secondary device in the station, including 61850 path keywords and description keyword information;

[0039] Primary-secondary relationship configuration module: used to configure the mapping relationship between the primary bay in the substation and the secondary equipment in the read station-wide database information and configure the type of the secondary equipment, so as to obtain the mapping relationship between the primary bay and the secondary equipment and the type of the secondary equipment;

[0040] Information point matching solution module: used to determine the corresponding template from the information in the read template file according to the mapping relationship between the primary interval and the secondary equipment and the type of the secondary equipment, and to match the information points that meet the requirements of the corresponding template from the secondary equipment database in the station in turn to obtain the matching result;

[0041] Point table output module: selects the secondary equipment point table information points to the main station information point table according to the matching results, automatically generates and outputs the main station information point table file, and realizes the generation of the main station monitoring information point table based on the information template.

[0042] Compared with the prior art, the beneficial effects of the present invention include at least the following: when a substation is newly built or renovated, when an information point table is required for the master station to access the plant station information, all information points that meet the requirements are matched from the full data point table based on a template file, so as to achieve the purpose of automatically generating a standardized information point table, improve the efficiency of designing and making the master station monitoring information point table, and reduce the manpower cost investment; the present invention completes the work of issuing the information point table in an automated manner based on the monitoring information specification, and in this process records the path information of the access side information point, and records the corresponding relationship between the master and substation information, ensuring that no points are missed or wrong; when formulating a scheduling monitoring point table file, the technology of the present invention is used to directly generate a standardized point table file, which improves the work efficiency of the master station side in issuing the standardized information point table, and is further beneficial to improving the work efficiency of the substation configuration forwarding point table and the master-substation point-to-point. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 It is a schematic diagram of the process of a method for generating a master station monitoring information point table based on an information template according to an embodiment of the present invention;

[0044] Figure 2It is a schematic diagram of a template definition file generated by a master station monitoring information point table based on an information template provided in an embodiment of the present invention;

[0045] Figure 3 It is a schematic diagram of the detailed process of the method for generating a master station monitoring information point table based on an information template provided in accordance with an embodiment of the present invention. DETAILED DESCRIPTION

[0046] In order to make the purpose, technical scheme and advantages of the present invention clearer, the technical scheme of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. The described embodiments are only embodiments of a part of the present invention, not all embodiments. Based on the spirit of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work belong to the protection scope of the present invention.

[0047] like Figure 1 As shown, embodiment 1 of the present invention provides a method for generating a master station monitoring information point table based on an information template, comprising the following steps:

[0048] Step 1: Create an information point table template file based on the master station monitoring information related specification documents. The file content includes the secondary device type, 61850 path keywords and description keyword information of each table information.

[0049] In a preferred but non-restrictive embodiment of the present invention, in step 1, the information point table template file is formulated according to the specification of the master station monitoring information, and the content includes the interval type, the point table information required for each type of interval (such as transformer protection, transformer high-voltage side measurement and control, line protection, line measurement and control, etc.), the point table information includes the secondary equipment type, and keyword information, the keyword information includes 61850 path keywords and description keyword information, and the keywords are divided into synonyms, required words, optional words, and prohibited words, such as Figure 2 shown.

[0050] Figure 2 In the figure, type and device of the IED node indicate the interval type. The point table information will be different for different interval types. The type field of the Table node indicates the point table type. desc indicates the specification description information. refer indicates the 61850 path keyword. word indicates the description keyword. Required words are separated by "&", synonyms are separated by "|", "!" indicates prohibited words, "[]" indicates optional words, and "()" indicates a whole (which is helpful for program parsing).

[0051] Step 2, load the template file created in step 1, and parse and read the information in the template file;

[0052] Step 3, read the database information of each secondary device in the station, and obtain the path and description of each data 61850;

[0053] In a preferred but non-limiting embodiment of the present invention, in step 3, there are various ways to read the information of the database of each secondary device in the station, such as importing from an SCD file or reading from a table file.

[0054] Step 4, configure the mapping relationship between the primary bay in the substation and the secondary equipment in the secondary equipment database information in the station read in step 3, and the type of the secondary equipment.

[0055] In a preferred but non-limiting implementation of the present invention, in step 4, the primary interval description information corresponding to all secondary devices and the type of secondary devices, such as transformer high-voltage side measurement and control, transformer protection, etc., are configured in units of secondary devices.

[0056] Step 4 is to manually configure the mapping relationship between the primary bay and all the secondary devices obtained from the whole station database read in step 3 according to the actual primary bay situation at the substation site.

[0057] Step 5, determine the corresponding template from the information in the template file read in step 2 according to the mapping relationship between the primary interval and the secondary device and the secondary device type obtained in step 4, and match the information points that meet the requirements in the corresponding template from the device model database in the station in turn to obtain the matching result.

[0058] Step 5 determines the interval point table in the template corresponding to each secondary device according to the mapping relationship, and then selects all the information points that meet the requirements from the secondary device point table in turn according to the information template in the template.

[0059] In a preferred but non-restrictive implementation of the present invention, the 61850 path keyword information is preferentially used to match the information points that meet the requirements in the secondary equipment database within the station. If no information point is matched, the keyword information of the description is used to match the information point that meets the requirements, or a combination of the two is used for matching. During the matching, it is determined whether the conditions of containing required words and not containing prohibited words are met before and after replacing synonyms. Under the same conditions, those containing optional words are selected first.

[0060] like Figure 3 As shown, starting from i=0, the template point table corresponding to the i-th secondary device type is obtained, starting from j=0, the j-th information point in the template point table is obtained, and the information points that match the template point table are matched from the point table of the i-th secondary device, and the matching is performed in sequence until S e All information points in the template point table are matched with the corresponding information points in the secondary equipment point table.

[0061] From the secondary equipment point table of each secondary equipment database in the station, match the information point that matches the template point table. Whether the text s of the secondary equipment point table contains the word x of the template meter information point is expressed by the following formula:

[0062]

[0063] In the formula,

[0064] B(s,x) indicates whether the text s contains word x.

[0065] The calculation expression for whether the text s of the secondary equipment point table meets the keyword requirements of the template point table is as follows:

[0066]

[0067] Where:

[0068] E(x) represents the synonyms of word x,

[0069] M represents the set of required words for the currently matched template information point;

[0070] T represents the set of banned words;

[0071] P represents a set of optional words;

[0072] s represents the text content of the currently matched information point;

[0073] represents the empty set;

[0074] R s Indicates the matching result.

[0075] Step 6: According to the matching result of step 5, the output master station information point table file is automatically generated to realize the generation of the master station monitoring information point table based on the information template.

[0076] In step 6, when R s ≥1, the secondary device point table information point matches the template point table information point successfully, and the secondary device point table information point is selected into the master station information point table, otherwise it is not selected. According to the mapping relationship, the secondary device description information can be replaced with the primary interval description information when the final result is generated. The secondary device description in the information description of the master station information point table is automatically replaced with the primary interval description information, the point number in the information point table is automatically generated in sequence, and the master station information point table is output.

[0077] The beneficial effects of the present invention include at least: when a new substation is newly built or renovated, when an information point table is required for the master station to access the plant station information, all information points that meet the requirements are matched from the full data point table based on a template file, so as to achieve the purpose of automatically generating a standardized information point table, improve the efficiency of designing and making the master station monitoring information point table, and reduce the manpower cost investment; the present invention completes the work of issuing the information point table in an automated manner based on the monitoring information specification, and in this process records the path information of the access side information point, and records the corresponding relationship between the main and substation information, ensuring that no points are missed or wrong; when formulating a scheduling monitoring point table file, the technology of the present invention is used to directly generate a standardized point table file, which improves the work efficiency of the master station side in issuing the standardized information point table, and is further beneficial to improving the work efficiency of the substation configuration forwarding point table and the master-substation point-to-point.

[0078] Embodiment 2 of the present invention provides a master station monitoring information point table generation system based on information templates, and runs a master station monitoring information point table generation method based on information templates described in embodiment 1, including:

[0079] Template configuration and loading module: used to create information point table template files according to the relevant specification files of the master station monitoring information, load the information point table template files, and parse and read the information in the template files;

[0080] Full data point table import module: used to read the database information of each secondary device in the station, including 61850 path keywords and description keyword information;

[0081] Primary-secondary relationship configuration module: used to configure the mapping relationship between the primary bay in the substation and the secondary equipment in the read station-wide database information and configure the type of the secondary equipment, so as to obtain the mapping relationship between the primary bay and the secondary equipment and the type of the secondary equipment;

[0082] Information point matching solution module: used to determine the corresponding template from the information in the read template file according to the mapping relationship between the primary interval and the secondary equipment and the type of the secondary equipment, and to match the information points that meet the requirements of the corresponding template from the secondary equipment database in the station in turn to obtain the matching result;

[0083] Point table output module: selects the secondary equipment point table information points to the main station information point table according to the matching results, automatically generates and outputs the main station information point table file, and realizes the generation of the main station monitoring information point table based on the information template.

[0084] The present disclosure may be a system, a method and / or a computer program product. The computer program product may include a computer-readable storage medium carrying computer-readable program instructions for causing a processor to implement various aspects of the present disclosure.

[0085] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents, and any modifications or equivalent replacements that do not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

Claims

1. A method for generating a master station monitoring information point table based on an information template, characterized in that: The following steps are involved: According to the relevant specification documents of the master station monitoring information, make the information point table template file; Load the information point table template file, parse and read the information in the template file; Read the database information of each secondary device in the station, including 61850 path keywords and description keyword information; Configure the mapping relationship between the primary bay in the substation and the secondary equipment in the read station-wide database information and configure the type of the secondary equipment to obtain the mapping relationship between the primary bay and the secondary equipment and the type of the secondary equipment; According to the mapping relationship between the primary interval and the secondary equipment and the type of the secondary equipment, the corresponding template is determined from the information in the read template file, and the information points that meet the requirements in the corresponding template are matched from the secondary equipment databases in the station in turn to obtain the matching results; According to the matching results, the secondary equipment point table information points are selected into the main station information point table, and the main station information point table file is automatically generated and output, so as to realize the generation of the main station monitoring information point table based on the information template.

2. The method for generating a master station monitoring information point table based on an information template according to claim 1, characterized in that: The information point table template file extracts the interval type and point table information of each type of interval according to the specifications of the master station monitoring information. The point table information of the interval includes the secondary equipment type and keyword information. The keyword information includes 61850 path keywords and description keyword information. The keywords include synonyms, required words, optional words and prohibited words.

3. The method for generating a master station monitoring information point table based on an information template according to claim 1, characterized in that: Import the database information of each secondary device in the station from the SCD file or read it from the table file.

4. The method for generating a master station monitoring information point table based on an information template according to claim 1, characterized in that: Configure the mapping relationship between the primary bay in the substation and the secondary equipment in the read station-wide database information and configure the type of secondary equipment, including: According to the actual primary bay content of the substation site, configure the mapping between the primary bay and all secondary devices obtained from the read full-station database, and configure the primary bay description information and secondary device types corresponding to all secondary devices obtained from the read full-station database.

5. The method for generating a master station monitoring information point table based on an information template according to claim 1, characterized in that: According to the mapping relationship between the primary interval and the secondary equipment and the type of the secondary equipment, the corresponding template is determined from the information in the template file read, and the information points that meet the requirements of the corresponding template are matched from the secondary equipment database in the station in turn, including: First, use the 61850 path key information to match the information points that meet the requirements of the corresponding template from the secondary equipment database in the station. If no information point is matched, use the keyword information of the description to match the information point that meets the requirements, or combine the two to match. When matching, determine whether the words used for matching contain required words and do not contain prohibited words before and after the synonym replacement. If so, match again. After the match is successful under the same conditions, select the matching information containing optional words.

6. A method for generating a master station monitoring information point table based on an information template according to claim 5, characterized in that: From the secondary equipment point table of each secondary equipment database in the station, match the information point that matches the template point table. Whether the text s of the secondary equipment point table contains the word x of the template meter information point is expressed by the following formula: In the formula, B(s,x) indicates whether the text s contains the word x.

7. A method for generating a master station monitoring information point table based on an information template according to claim 6, characterized in that: Whether the text s of the secondary device point table meets the matching result R of the keyword requirements of the template point table s , expressed as follows: Where: E(x) represents the synonyms of word x, M represents the set of required words for the currently matched template information point. T represents the set of banned words, P represents a set of optional words, represents the empty set, R s Indicates the matching result.

8. A method for generating a master station monitoring information point table based on information template according to claim 7, characterized in that: When R s When ≥1, the information point in the secondary equipment point table matches the information point in the template point table successfully, and the information point in the secondary equipment point table is selected into the main station information point table. Otherwise, the information point in the secondary equipment point table fails to match the information point in the template point table and is not selected.

9. A method for generating a master station monitoring information point table based on information template according to claim 8, characterized in that: Automatically replace the secondary device description in the information description in the master station information point table with the primary interval description information, and automatically generate the point numbers in the information point table in sequence.

10. A master station monitoring information point table generation system based on information template, running a master station monitoring information point table generation method based on information template according to any one of claims 1 to 9, characterized in that: Template configuration and loading module: used to create information point table template files according to the relevant specification files of the master station monitoring information, load the information point table template files, and parse and read the information in the template files; Full data point table import module: used to read the database information of each secondary device in the station, including 61850 path keywords and description keyword information; Primary-secondary relationship configuration module: used to configure the mapping relationship between the primary bay in the substation and the secondary equipment in the read station-wide database information and configure the type of the secondary equipment, so as to obtain the mapping relationship between the primary bay and the secondary equipment and the type of the secondary equipment; Information point matching solution module: used to determine the corresponding template from the information in the read template file according to the mapping relationship between the primary interval and the secondary equipment and the type of the secondary equipment, and to match the information points that meet the requirements of the corresponding template from the secondary equipment database in the station in turn to obtain the matching result; Point table output module: selects the secondary equipment point table information points to the main station information point table according to the matching results, automatically generates and outputs the main station information point table file, and realizes the generation of the main station monitoring information point table based on the information template.

Images