Method and system for matching centralized monitoring information point tables of transformer substation
By building a substation equipment monitoring information point table library and using regular expressions and two-way maximum word participle matching algorithm for information matching, problems such as large workload and error-prone matching of substation monitoring information point table matching are solved, and efficient and accurate information matching and system interoperability are achieved.
Patent Information
- Application Number
- CN202411733338.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-29
- Publication Date
- 2025-03-21
AI Technical Summary
In the prior art, the matching work of substation monitoring information point tables relies on manual sorting and analysis, resulting in large workload, easy errors, poor compatibility, lack of automation tools and complex change management.
A standard data structure is used to build a substation equipment monitoring information point table library, and a regular expression and a two-way maximum word participle matching algorithm are used to extract and match substation equipment alarm information to realize automatic identification, classification, matching and verification of information point tables.
It realizes data standardization and interconnection, improves system interoperability and compatibility, reduces the difficulty and cost of device integration, enhances the stability and reliability of the system, and supports unified data management and analysis.
Smart Images

Figure CN119669780A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of power transmission and transformation engineering design, and in particular to a method and system for matching a centralized monitoring information point table of a substation. Background Art
[0002] In modern power systems, the automation level of substations is constantly improving. One of the core functions is to achieve real-time monitoring and control of the operating status of substation equipment through monitoring systems. With the rapid development of smart grid and digital substation technologies, the complexity of substation monitoring systems and the demand for data interaction have increased significantly. In this context, how to efficiently and accurately match the substation monitoring information point table has become a key technology.
[0003] The substation monitoring information point table is a core data table that describes the substation equipment operating status, alarm signals, control signals and communication configuration. The point table is directly related to the following aspects:
[0004] The effectiveness of the communication between the monitoring system and the equipment. The point table defines the data interface between the monitoring system and the field equipment, so that data collection and control operations have clear standards.
[0005] The comprehensiveness and accuracy of information, the point table content needs to cover all important equipment and their monitoring points in the substation to ensure the comprehensive collection of operating status and alarm information.
[0006] System interoperability,Point table is an important basis for system integration, ensuring the compatibility between equipment and monitoring systems of different manufacturers.
[0007] Traditional substation information point table matching usually relies on manual sorting and analysis, facing the following major challenges:
[0008] 1) Large workload: There are many types of substation equipment, and the number of monitoring points for each type of equipment may reach hundreds or even thousands, which makes manual processing inefficient.
[0009] 2) Error-prone: The formats of point tables are diverse and complex, and the naming rules between different devices and manufacturers may not be unified, which increases the probability of errors in data matching.
[0010] 3) Compatibility issues: Due to differences in communication protocols among equipment from different manufacturers, the point table format is difficult to standardize, resulting in the need for frequent adjustments to the matching work.
[0011] 4) Lack of automated tools: Existing automated point list processing tools are limited, and in most cases manual comparison and verification are still required.
[0012] 5) Complex change management: With the dynamic changes in the operating status of the substation, the information point table needs to be updated regularly, which further increases the maintenance workload.
[0013] Currently, no effective solution has been proposed for the problems in the related technologies. Summary of the invention
[0014] In view of the problems in the related art, the present invention proposes a method and system for matching a centralized monitoring information point table of a substation to overcome the above technical problems existing in the existing related art.
[0015] To this end, the specific technical solution adopted by the present invention is as follows:
[0016] According to one aspect of the present invention, a method for matching a substation centralized monitoring information point table is provided, and the information meter matching method comprises the following steps:
[0017] S1. Use standard data structure to store substation equipment monitoring information point table into the database to build substation equipment monitoring information point table database, and obtain real-time control data, substation equipment alarm information and the corresponding relationship between real-time control data and substation equipment alarm information;
[0018] S2. Extract the real-time control data elements of the real-time control data, analyze and filter the substation equipment alarm information by using the information definition rules based on regular expressions, obtain the substation equipment alarm information elements, and match and identify the substation equipment alarm information in combination with the real-time control data elements;
[0019] S3. Construct a dictionary table based on the common attributes of information in the substation equipment monitoring information point table library, and use a two-way maximum word segmentation matching algorithm to identify and match substation equipment alarm information;
[0020] S4. Based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, the bidirectional maximum word segmentation matching algorithm is used to verify and compare the matching similarity of the substation equipment alarm information.
[0021] Optionally, the extracting of the real-time control data elements of the real-time control data, analyzing and screening the substation equipment alarm information by using the information definition rule based on the regular expression, obtaining the substation equipment alarm information elements, and matching and identifying the substation equipment alarm information in combination with the real-time control data elements includes the following steps:
[0022] S21. Acquire control real-time data and substation equipment alarm information based on the substation monitoring information point table library, extract control real-time data elements from the control real-time data, and filter the substation equipment alarm information according to the information definition rules;
[0023] S22. For the substation equipment alarm information that meets the information definition rules, analyze the substation equipment alarm information elements according to the information definition rules, and enter the rule information comparison and matching process in combination with the real-time control data elements;
[0024] S23. For the substation equipment alarm information that does not conform to the information definition rules, the irregular information matching and identification process is entered in combination with the real-time control data elements.
[0025] Optionally, the step of constructing a dictionary table according to the common attributes of information in the substation equipment monitoring information point database and identifying and matching the substation equipment alarm information in combination with a bidirectional maximum word segmentation matching algorithm comprises the following steps:
[0026] S31, constructing a dictionary table according to the common attributes of information in the substation equipment monitoring information point table library, and filtering out pre-configured dictionary keywords based on the dictionary table;
[0027] S32, based on the dictionary keywords, the longest character number of the longest keyword is obtained, and the substation equipment alarm information is screened and matched in combination with the dictionary table. If a matching word appears in the dictionary table, the match is successful, and the successfully matched word is segmented;
[0028] S33, if there is no matching word in the dictionary table, repeatedly use the forward maximum matching method and the reverse maximum matching method to segment the substation equipment alarm information until a match is successful;
[0029] S34, temporarily storing the word segmentation that successfully matches in a single round as a result, and repeating steps S31 to S33 until the alarm information of the substation equipment is completely matched;
[0030] S35. Compare the matching result using the forward maximum matching method and the matching result using the reverse maximum matching method to obtain a final matching result.
[0031] Optionally, the comparing the matching result using the forward maximum matching method with the matching result using the reverse maximum matching method to obtain the final matching result comprises the following steps:
[0032] S351, comparing the matching result using the forward maximum matching method and the matching result using the reverse maximum matching method;
[0033] S352. If the word segmentation results are the same, select one matching result;
[0034] S353. If the number of segmented words is the same, then the matching result using the reverse maximum matching method is selected;
[0035] S354. If the number of segmented words is different, the matching result with the smaller number of segmented words is selected.
[0036] Optionally, based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, using a bidirectional maximum word segmentation matching algorithm, verifying and comparing the matching similarity of the substation equipment alarm information includes the following steps:
[0037] S41. Construct a substation equipment alarm information set based on the substation equipment monitoring information point table, obtain real-time substation equipment alarm information, and match the substation equipment alarm information that meets the information definition rules with the substation equipment alarm information set;
[0038] S42, matching the substation equipment alarm information that does not conform to the information definition rules according to the dictionary table and the two-way maximum word segmentation matching algorithm;
[0039] S43, comparing the matching results of the real-time substation equipment alarm information to calculate the similarity, and setting a threshold based on the similarity to filter and process the matching results of the substation equipment alarm information.
[0040] Optionally, the real-time substation equipment alarm information includes substation equipment alarm information defined in the substation equipment monitoring information point table and substation equipment alarm information reported in real time.
[0041] Optionally, the step of constructing a substation equipment alarm information set based on the substation equipment monitoring information point table, acquiring real-time substation equipment alarm information, and matching the real-time substation equipment alarm information with the substation equipment alarm information set includes the following steps:
[0042] S411, constructing a substation equipment alarm information set into memory based on the substation equipment monitoring information point table, and obtaining real-time substation equipment alarm information;
[0043] S412: Match the real-time substation equipment alarm information that complies with the information definition rule with the substation equipment alarm information set.
[0044] Optionally, matching the substation equipment alarm information that does not conform to the information definition rule according to the dictionary table and the bidirectional maximum word segmentation matching algorithm includes the following steps:
[0045] S421, loading pre-configured characters into the memory through the dictionary table;
[0046] S422, performing text preprocessing on the real-time substation equipment alarm information according to punctuation marks;
[0047] S423, extracting identical characters from the real-time substation equipment alarm information based on the characters pre-configured in the memory, and performing word segmentation matching in combination with a bidirectional maximum word segmentation matching algorithm, and temporarily storing the matching results in the memory.
[0048] Optionally, the matching results of the real-time substation equipment alarm information are compared and calculated for similarity, and a threshold is set based on the similarity, and the matching result screening process of the substation equipment alarm information includes the following steps:
[0049] S431, comparing the matching results of the substation equipment alarm information reported in real time with the matching results of the substation equipment alarm information defined in the substation equipment monitoring information point table, calculating the similarity, and sorting and selecting from high to low similarity;
[0050] S432, setting a similarity threshold, if the matching result of the substation equipment alarm information reaches or exceeds the set threshold, the match is successful and filed in the successful matching library;
[0051] S433: If the matching result of the substation equipment alarm information does not reach the set threshold, the matching is unsuccessful, and the matching failure information is stored in the unsuccessful matching library.
[0052] According to another aspect of the present invention, there is also provided a substation centralized monitoring information point table matching system, the information point table matching system comprising: an information point table library module, a regular expression module, a two-way word segmentation matching module and a similarity verification module;
[0053] The information point table library module is used to store the substation equipment monitoring information point table using a standard data structure to build a substation equipment monitoring information point table library, obtain the real-time control data, substation equipment alarm information and the corresponding relationship between the real-time control data and the substation equipment alarm information;
[0054] A regular expression module is used to extract the real-time data elements of the real-time data, analyze and filter the substation equipment alarm information by using the information definition rules based on regular expressions, obtain the alarm information elements of the substation equipment, and match and identify the alarm information of the substation equipment in combination with the real-time data elements;
[0055] The two-way word segmentation matching module is used to construct a dictionary table based on the common attributes of the information in the substation equipment monitoring information point table library, and to identify and match the substation equipment alarm information in combination with the two-way maximum word segmentation matching algorithm;
[0056] The verification similarity module is used to verify and compare the matching similarity of the substation equipment alarm information based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, using the two-way maximum word segmentation matching algorithm.
[0057] The beneficial effects of the present invention are:
[0058] 1. The present invention ensures data standardization and interconnection, realizes seamless connection between devices and systems, thereby improving the interoperability and compatibility of systems, reducing the difficulty and cost of equipment integration, enhancing the stability and reliability of the system, supporting unified management and analysis of data, and providing decision support.
[0059] 2. The present invention ensures efficient processing of massive data and can process more monitoring points and alarm information than traditional substations. The point table matching has efficient data processing capabilities. Through standardized data structure and efficient matching algorithm, the response speed and processing efficiency of the system are improved, ensuring the stable operation of the system under high load.
[0060] 3. The present invention ensures the accuracy and consistency of the point table matching results, avoids abnormal monitoring system due to data errors, improves the accuracy and reliability of data processing through standardized data structure and precise matching algorithm, and ensures the stable operation and efficient management of the monitoring system.
[0061] 4. The present invention realizes the automatic identification, classification, matching and verification of the information point table, improves the automation and intelligence level of data processing, reduces manual intervention, improves the operating efficiency and reliability of the system, and ensures the efficient and stable operation of the substation monitoring system. BRIEF DESCRIPTION OF THE DRAWINGS
[0062] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0063] Figure 1 is a flow chart of a method for matching a substation centralized monitoring information point table according to an embodiment of the present invention;
[0064] Figure 2 The invention is a principle block diagram of a substation centralized monitoring information point table matching system according to an embodiment of the present invention.
[0065] In the figure:
[0066] 1. Information point table library module; 2. Regular expression module; 3. Bidirectional word segmentation matching module; 4. Verification similarity module. DETAILED DESCRIPTION
[0067] To further illustrate each embodiment, the present invention provides drawings, which are part of the disclosure of the present invention and are mainly used to illustrate the embodiments and can be used in conjunction with the relevant descriptions in the specification to explain the operating principles of the embodiments. With reference to these contents, ordinary technicians in the field should be able to understand other possible implementations and advantages of the present invention. The components in the figures are not drawn to scale, and similar component symbols are generally used to represent similar components.
[0068] According to an embodiment of the present invention, a method and system for matching a centralized monitoring information point table of a substation are provided.
[0069] The present invention is further described with reference to the accompanying drawings and specific embodiments. Figure 1 As shown, according to one embodiment of the present invention, a method for matching a substation centralized monitoring information point table is provided, and the information meter matching method comprises the following steps:
[0070] S1. The substation equipment monitoring information point table is stored in the database using a standard data structure to construct a substation equipment monitoring information point table database, and the real-time control data, substation equipment alarm information and the corresponding relationship between the real-time control data and the substation equipment alarm information are obtained.
[0071] It should be explained that the equipment monitoring information point table is the main basis for completing the centralized monitoring information access of the substation. It mainly includes real-time control data and equipment alarm information, and contains the correspondence between the two types of information. All equipment monitoring information point tables are stored in a standard data structure to form an equipment monitoring information point table library, which is the basis for matching and identifying centralized monitoring information. The matching and identification of centralized monitoring information is mainly through the key elements of the acquired real-time control data and alarm direct transmission information, matching with the equipment monitoring information point table, establishing the association between the real-time reporting information and the equipment monitoring information point table, and verifying the correspondence between the real-time control data and the alarm direct transmission information, so as to achieve the purpose of centralized monitoring information identification, screening and filtering.
[0072] Real-time control data is the main data source for the application of integrated control and dispatching functions, and requires timeliness, accuracy and reliability. Real-time control data can be divided into three categories: power grid operation data, power grid fault signals, and equipment monitoring data. It can also be divided into telemetry, telesignaling, and remote control (dispatching) information. It is directly collected and sent by the telecontrol communication workstation at the plant end, and data transmission is realized using DL / T634.5101 and DL / T634.5104 communication protocols. It is directly related to the power grid structure equipment model, real-time database and graphic screen of the dispatching master station system. The point number of real-time control data is unique. By obtaining its information point number, key elements such as the plant, voltage, interval, and equipment can be obtained.
[0073] Substation equipment alarm information is the main focus of equipment monitoring business. With a single event or comprehensive analysis result of the substation monitoring system as the information source, after standardized processing, a standard alarm clause is generated. The standardized processing of the alarm clause is completed by the substation monitoring system, and is directly transmitted to the dispatching master station and the equipment operation and maintenance station in text format via the graphic gateway (or telecontrol workstation), and is displayed in the corresponding alarm window and stored in the alarm record file. This type of information is also called alarm direct transmission information. The alarm direct transmission information refers to the syslog format. The standard alarm clause is described in five sections: "level, time, equipment, event, and reason", and each section is separated by a space. The format is: "<level> time equipment event reason". The full path naming structure of "equipment" is "grid. plant line / voltage. interval. equipment / component. attribute". Among them, the forward slash " / " is the positioning separator, and the decimal point "." is the level separator. In the actual production process, the alarm direct transmission information and the real-time control data are reported at the same time, which can more effectively and intuitively reflect the abnormalities and failures of the equipment, but the existing system does not have the function of matching the two. Standard alarm direct transmission information can analyze its text to obtain key information elements through the established standard format, and achieve the purpose of matching with the real-time control data through identification and matching, but the alarm direct transmission information is usually defined by different manufacturers and personnel. There are inherent deviations in the process of standard implementation, resulting in a large amount of non-standard information and the inability to extract its key elements.
[0074] S2. Extract the real-time control data elements of the real-time control data, use the information definition rules based on regular expressions to analyze and screen the substation equipment alarm information, obtain the substation equipment alarm information elements, and match and identify the substation equipment alarm information in combination with the real-time control data elements.
[0075] Optionally, the extracting of the real-time control data elements of the real-time control data, analyzing and screening the substation equipment alarm information by using the information definition rule based on the regular expression, obtaining the substation equipment alarm information elements, and matching and identifying the substation equipment alarm information in combination with the real-time control data elements includes the following steps:
[0076] S21. Acquire control real-time data and substation equipment alarm information based on the substation monitoring information point table library, extract control real-time data elements from the control real-time data, and filter the substation equipment alarm information according to the information definition rules;
[0077] S22. For the substation equipment alarm information that meets the information definition rules, analyze the substation equipment alarm information elements according to the information definition rules, and enter the rule information comparison and matching process in combination with the real-time control data elements;
[0078] S23. For the substation equipment alarm information that does not conform to the information definition rules, the irregular information matching and identification process is entered in combination with the real-time control data elements.
[0079] It should be explained that the analysis process of real-time centralized monitoring information is as follows using regular expression-based information definition rules:
[0080] 1) First, obtain the reported real-time control data and alarm direct transmission information, extract the key elements of the real-time control data, and check whether the format of the alarm direct transmission information conforms to the rules described by the regular expression.
[0081] 2) For the alarm direct transmission information that meets the rules, decompose the information according to the rules, obtain the content such as "equipment" and "event", combine it with the key elements of real-time control data, and enter the rule information comparison and matching process.
[0082] 3) For irregular alarm direct transmission information, combined with the key elements of real-time control data, enter the irregular information matching and identification process.
[0083] S3. Construct a dictionary table based on the common attributes of the information in the substation equipment monitoring information point table library, and use the bidirectional maximum word segmentation matching algorithm to identify and match the substation equipment alarm information.
[0084] Optionally, the step of constructing a dictionary table according to the common attributes of information in the substation equipment monitoring information point database and identifying and matching the substation equipment alarm information in combination with a bidirectional maximum word segmentation matching algorithm comprises the following steps:
[0085] S31, constructing a dictionary table according to the common attributes of information in the substation equipment monitoring information point table library, and filtering out pre-configured dictionary keywords based on the dictionary table;
[0086] S32, based on the dictionary keywords, the longest character number of the longest keyword is obtained, and the substation equipment alarm information is screened and matched in combination with the dictionary table. If a matching word appears in the dictionary table, the match is successful, and the successfully matched word is segmented;
[0087] S33, if there is no matching word in the dictionary table, repeatedly use the forward maximum matching method and the reverse maximum matching method to segment the substation equipment alarm information until a match is found;
[0088] S34, temporarily storing the word segmentation that successfully matches in a single round as a result, and repeating steps S31 to S33 until the alarm information of the substation equipment is completely matched;
[0089] S35. Compare the matching result using the forward maximum matching method and the matching result using the reverse maximum matching method to obtain a final matching result.
[0090] Optionally, the comparing the matching result using the forward maximum matching method with the matching result using the reverse maximum matching method to obtain the final matching result comprises the following steps:
[0091] S351, comparing the matching result using the forward maximum matching method and the matching result using the reverse maximum matching method;
[0092] S352, if the word segmentation results are the same, select one matching result;
[0093] S353. If the number of segmented words is the same, then the matching result using the reverse maximum matching method is selected;
[0094] S354. If the number of segmented words is different, the matching result with the smaller number of segmented words is selected.
[0095] It should be explained that in order to further improve the efficiency of centralized monitoring information matching and identification, the common attributes of information in the information point table library are extracted to establish a "Dictionary Table", including "plant station", "interval", "equipment full path name" and "reason", among which "equipment full path name" includes voltage level, equipment name, components (if any), attributes (if any), etc. The establishment of the "Dictionary Table" can be divided into one-time and multiple times. The controlled substation and interval are completed at one time, and the equipment, components and reasons are supplemented and improved multiple times through word segmentation. In the relational database method, the "Dictionary Table" is the process of classified storage by field in the form of table structure.
[0096] In the non-relational database mode, the "Dictionary Table" is in text form and is divided into two parts. One part stores the address index and the other part stores the text. It is stored in address form, and the address pointer points to the plant, interval, equipment, etc., that is, a chain storage structure.
[0097] In addition, the basic idea of the forward maximum matching method is: assuming that the longest entry in the automatic word segmentation dictionary contains m Chinese characters, then take the first m characters in the current string sequence of the processed material as the matching field, and search the word segmentation dictionary. If there is such an m-character word in the dictionary, the match is successful, and the matching field is segmented as a word. If such an m-character word cannot be found in the dictionary, the match fails, the last Chinese character is removed from the matching field, and the remaining characters are used as the new matching field for matching again, and this process is continued until the match is successful.
[0098] The reverse maximum matching method has the same idea as the forward method, but it starts from the end of the sentence (or article), and removes the previous Chinese character each time the match fails. Its word segmentation accuracy is higher than the forward method.
[0099] This aspect adopts a bidirectional maximum word segmentation matching algorithm to identify and match the alarm direct transmission information, and the process is as follows.
[0100] Step 101: Filter out dictionary keywords under a certain plant station and a certain interval in the "Dictionary Table".
[0101] Step 102: Assuming that the longest keyword filtered out has i Chinese characters, the first i characters of the alarm direct transmission information are used as matching fields to search the dictionary. If such an i-character word exists in the dictionary, the match is successful and the matching field is segmented as a word.
[0102] Step 103: If such an i-character word cannot be found, the forward maximum matching method and the reverse maximum matching method are used for word segmentation, and the process is repeated until the match is successful, that is, a word is segmented or the length of the remaining string is zero.
[0103] Step 104, complete a round of matching and temporarily store a result of this round of word segmentation, then take the next i-word string and return to step 101 for matching processing until the alarm direct transmission information is scanned.
[0104] Step 105: When the two algorithms complete the matching process, the forward maximum matching method and the reverse maximum matching method are compared. If the segmentation results are the same, one of the segmentation results is selected. If the number of segmented words is the same, the reverse maximum matching method segmentation result is selected. If the number of segmented words is different, the result with the smaller number of segmented words is selected.
[0105] S4. Based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, the bidirectional maximum word segmentation matching algorithm is used to verify and compare the matching similarity of the substation equipment alarm information.
[0106] Optionally, based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, using a bidirectional maximum word segmentation matching algorithm, verifying and comparing the matching similarity of the substation equipment alarm information includes the following steps:
[0107] S41. Construct a substation equipment alarm information set based on the substation equipment monitoring information point table, obtain real-time substation equipment alarm information, and match the substation equipment alarm information that meets the information definition rules with the substation equipment alarm information set.
[0108] Optionally, the real-time substation equipment alarm information includes substation equipment alarm information defined in the substation equipment monitoring information point table and substation equipment alarm information reported in real time.
[0109] Optionally, the step of constructing a substation equipment alarm information set based on the substation equipment monitoring information point table, acquiring real-time substation equipment alarm information, and matching the real-time substation equipment alarm information with the substation equipment alarm information set includes the following steps:
[0110] S411, constructing a substation equipment alarm information set into memory based on the substation equipment monitoring information point table, and obtaining real-time substation equipment alarm information;
[0111] S412: Match the real-time substation equipment alarm information that complies with the information definition rule with the substation equipment alarm information set.
[0112] S42. Match the substation equipment alarm information that does not conform to the information definition rules according to the dictionary table and the two-way maximum word segmentation matching algorithm.
[0113] Optionally, matching the substation equipment alarm information that does not conform to the information definition rule according to the dictionary table and the bidirectional maximum word segmentation matching algorithm includes the following steps:
[0114] S421, loading pre-configured characters into the memory through the dictionary table;
[0115] S422, performing text preprocessing on the real-time substation equipment alarm information according to punctuation marks;
[0116] S423, extracting identical characters from the real-time substation equipment alarm information based on the characters pre-configured in the memory, and performing word segmentation matching in combination with a bidirectional maximum word segmentation matching algorithm, and temporarily storing the matching results in the memory.
[0117] S43, comparing the matching results of the real-time substation equipment alarm information to calculate the similarity, and setting a threshold based on the similarity to filter and process the matching results of the substation equipment alarm information.
[0118] Optionally, the matching results of the real-time substation equipment alarm information are compared and calculated for similarity, and a threshold is set based on the similarity, and the matching result screening process of the substation equipment alarm information includes the following steps:
[0119] S431, comparing the matching results of the substation equipment alarm information reported in real time with the matching results of the substation equipment alarm information defined in the substation equipment monitoring information point table, calculating the similarity, and sorting and selecting from high to low similarity;
[0120] S432, setting a similarity threshold, if the matching result of the substation equipment alarm information reaches or exceeds the set threshold, the match is successful and filed in the successful matching library;
[0121] S433: If the matching result of the substation equipment alarm information does not reach the set threshold, the matching is unsuccessful, and the matching failure information is stored in the unsuccessful matching library.
[0122] It needs to be explained that the centralized monitoring information analysis process is a process that uses the real-time control data reported in real time and the time when the alarm direct transmission information occurs, combined with the "Equipment Monitoring Information Point Table" and "Dictionary Table", and uses the two-way maximum word segmentation matching algorithm to compare the matching similarity and finally determine whether the match is successful.
[0123] Step 201, obtain the alarm direct transmission information. The alarm direct transmission information at this stage is divided into two categories. One category is the alarm direct transmission information defined in the "Information Point Table". The plant station and interval corresponding to the optical word information can be directly obtained through the real-time optical word signal, and then the alarm direct transmission information set S{1, 2, ..., n} corresponding to the optical word information is found in the "Information Point Table" and stored in the memory; the other category is the real-time alarm direct transmission signal, which is filtered by the plant station to find the alarm direct transmission information with a similar time to the optical word report (such as N seconds above and below the optical word time) and store it in the memory.
[0124] Step 202: if the real-time alarm direct transmission information that meets the rules directly corresponds to and matches the information S{1, 2, ..., n} in the alarm direct transmission information set, jump to step 207; otherwise, proceed to the next step.
[0125] Step 203, loading the "dictionary table" stage. The "dictionary table" is stored in the physical relational database, and based on the known step 201, the corresponding plant station and interval data are loaded into the memory.
[0126] Step 204, text preprocessing stage. In this stage, the two types of alarm direct transmission information in step 201 are subjected to text preprocessing. According to the text characteristics of the alarm direct transmission, the two types of alarm direct transmission signals can be subjected to text preprocessing and word segmentation according to punctuation marks "." and " / ".
[0127] Step 205, word segmentation stage. Combined with the "Dictionary Table" and "Corpus" in step 203, before the two-way maximum word segmentation, search whether the alarm direct transmission signal is in the same "equipment", "component", and "reason" fields, and extract if they exist. The extracted two types of alarm direct transmission signals are word segmented according to the maximum matching algorithm, and the word segmentation results are temporarily stored in the memory.
[0128] Step 206, word segmentation result processing stage. After the two types of alarm direct transmission word segmentation, the real-time alarm direct transmission word segmentation results are compared with the multiple alarm direct transmission word segmentation results in the point table to calculate the similarity. The similarities are sorted and selected from high to low.
[0129] Step 207: Set a threshold of similarity. If the threshold is reached or exceeded, the match is successful and the information is saved in a successful match database. If the information is unsuccessful, the information is saved in an unsuccessful match database for statistical feedback.
[0130] According to another aspect of the present invention, a substation centralized monitoring information point table matching system is also provided. Figure 2 As shown, the information point table matching system includes: an information point table library module 1, a regular expression module 2, a two-way word segmentation matching module 3 and a similarity verification module 4;
[0131] The information point table library module 1 is used to store the substation equipment monitoring information point table in a standard data structure to build a substation equipment monitoring information point table library, obtain the real-time control data, the substation equipment alarm information and the corresponding relationship between the real-time control data and the substation equipment alarm information;
[0132] Regular expression module 2 is used to extract the real-time control data elements of the real-time control data, analyze and filter the substation equipment alarm information by using the information definition rules based on regular expressions, obtain the substation equipment alarm information elements, and match and identify the substation equipment alarm information in combination with the real-time control data elements;
[0133] Bidirectional word segmentation matching module 3, used to construct a dictionary table according to the common attributes of information in the substation equipment monitoring information point table library, and identify and match the substation equipment alarm information in combination with the bidirectional maximum word segmentation matching algorithm;
[0134] The similarity verification module 4 is used to verify and compare the matching similarity of the substation equipment alarm information based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, using the two-way maximum word segmentation matching algorithm.
[0135] In summary, with the help of the above technical solutions of the present invention, the present invention ensures data standardization and interconnection, realizes seamless connection of equipment and systems, thereby improving the interoperability and compatibility of the system, reducing the difficulty and cost of equipment integration, enhancing the stability and reliability of the system, supporting unified management and analysis of data, and providing decision support; the present invention ensures efficient processing of massive data, can process more monitoring points and alarm information than traditional substations, and the point table matching has efficient data processing capabilities. Through standardized data structures and efficient matching algorithms, the response speed and processing efficiency of the system are improved, ensuring the stable operation of the system under high load; the present invention ensures the accuracy and consistency of the point table matching results, avoids abnormal monitoring system due to data errors, and improves the accuracy and reliability of data processing through standardized data structures and precise matching algorithms, ensuring the stable operation and efficient management of the monitoring system; the present invention realizes automatic identification, classification, matching and verification of information point tables, improves the automation and intelligence level of data processing, reduces manual intervention, improves the operating efficiency and reliability of the system, and ensures the efficient and stable operation of the substation monitoring system.
[0136] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims
1. A method for matching a centralized monitoring information point table of a substation, characterized in that: The information meter matching method comprises the following steps: S1. Use standard data structure to store substation equipment monitoring information point table into the database to build substation equipment monitoring information point table database, and obtain real-time control data, substation equipment alarm information and the corresponding relationship between real-time control data and substation equipment alarm information; S2. Extract the real-time control data elements of the real-time control data, analyze and filter the substation equipment alarm information by using the information definition rules based on regular expressions, obtain the substation equipment alarm information elements, and match and identify the substation equipment alarm information in combination with the real-time control data elements; S3. Construct a dictionary table based on the common attributes of information in the substation equipment monitoring information point table library, and use a two-way maximum word segmentation matching algorithm to identify and match substation equipment alarm information; S4. Based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, the bidirectional maximum word segmentation matching algorithm is used to verify and compare the matching similarity of the substation equipment alarm information.
2. A method for matching a substation centralized monitoring information point table according to claim 1, characterized in that: The extracting of the real-time control data elements of the real-time control data, using the information definition rules based on regular expressions, analyzing and screening the substation equipment alarm information, obtaining the substation equipment alarm information elements, and matching and identifying the substation equipment alarm information in combination with the real-time control data elements include the following steps: S21. Acquire control real-time data and substation equipment alarm information based on the substation monitoring information point table library, extract control real-time data elements from the control real-time data, and filter the substation equipment alarm information according to the information definition rules; S22. For the substation equipment alarm information that meets the information definition rules, analyze the substation equipment alarm information elements according to the information definition rules, and enter the rule information comparison and matching process in combination with the real-time control data elements; S23. For the substation equipment alarm information that does not conform to the information definition rules, the irregular information matching and identification process is entered in combination with the real-time control data elements.
3. A method for matching a substation centralized monitoring information point table according to claim 1, characterized in that: The method of constructing a dictionary table according to the common attributes of information in the substation equipment monitoring information point table library and identifying and matching the substation equipment alarm information by combining a bidirectional maximum word segmentation matching algorithm comprises the following steps: S31, constructing a dictionary table according to the common attributes of information in the substation equipment monitoring information point table library, and filtering out pre-configured dictionary keywords based on the dictionary table; S32, based on the dictionary keywords, the longest character number of the longest keyword is obtained, and the substation equipment alarm information is screened and matched in combination with the dictionary table. If a matching word appears in the dictionary table, the match is successful, and the successfully matched word is segmented; S33, if there is no matching word in the dictionary table, repeatedly use the forward maximum matching method and the reverse maximum matching method to segment the substation equipment alarm information until a match is found; S34, temporarily storing the word segmentation that successfully matches in a single round as a result, and repeating steps S31 to S33 until the alarm information of the substation equipment is completely matched; S35. Compare the matching result using the forward maximum matching method and the matching result using the reverse maximum matching method to obtain a final matching result.
4. A method for matching a substation centralized monitoring information point table according to claim 3, characterized in that: The step of comparing the matching result using the forward maximum matching method with the matching result using the reverse maximum matching method to obtain the final matching result comprises the following steps: S351, comparing the matching result using the forward maximum matching method and the matching result using the reverse maximum matching method; S352. If the word segmentation results are the same, select one matching result; S353. If the number of segmented words is the same, then the matching result using the reverse maximum matching method is selected; S354. If the number of segmented words is different, the matching result with the smaller number of segmented words is selected.
5. A method for matching a substation centralized monitoring information point table according to claim 1, characterized in that: The method of verifying and comparing the matching similarity of the substation equipment alarm information based on the occurrence time of the real-time control data and the substation equipment alarm information, combining the substation equipment monitoring information point table and the dictionary table, and using the bidirectional maximum word segmentation matching algorithm includes the following steps: S41. Construct a substation equipment alarm information set based on the substation equipment monitoring information point table, obtain real-time substation equipment alarm information, and match the substation equipment alarm information that meets the information definition rules with the substation equipment alarm information set; S42, matching the substation equipment alarm information that does not conform to the information definition rules according to the dictionary table and the two-way maximum word segmentation matching algorithm; S43, comparing the matching results of the real-time substation equipment alarm information to calculate the similarity, and setting a threshold based on the similarity to filter and process the matching results of the substation equipment alarm information.
6. A method for matching a substation centralized monitoring information point table according to claim 5, characterized in that: The real-time substation equipment alarm information includes the substation equipment alarm information defined in the substation equipment monitoring information point table and the substation equipment alarm information reported in real time.
7. A method for matching a substation centralized monitoring information point table according to claim 5, characterized in that: The step of constructing a substation equipment alarm information set based on the substation equipment monitoring information point table, obtaining real-time substation equipment alarm information, and matching the real-time substation equipment alarm information with the substation equipment alarm information set includes the following steps: S411, constructing a substation equipment alarm information set into memory based on the substation equipment monitoring information point table, and obtaining real-time substation equipment alarm information; S412: Match the real-time substation equipment alarm information that complies with the information definition rule with the substation equipment alarm information set.
8. A method for matching a substation centralized monitoring information point table according to claim 5, characterized in that: The matching of the substation equipment alarm information that does not conform to the information definition rules according to the dictionary table and the bidirectional maximum word segmentation matching algorithm comprises the following steps: S421, loading pre-configured characters into the memory through the dictionary table; S422, performing text preprocessing on the real-time substation equipment alarm information according to punctuation marks; S423, extracting identical characters from the real-time substation equipment alarm information based on the characters pre-configured in the memory, and performing word segmentation matching in combination with a bidirectional maximum word segmentation matching algorithm, and temporarily storing the matching results in the memory.
9. A method for matching a substation centralized monitoring information point table according to claim 5, characterized in that: The matching results of the real-time substation equipment alarm information are compared and calculated for similarity, and a threshold is set based on the similarity, and the matching result screening process of the substation equipment alarm information includes the following steps: S431, comparing the matching results of the substation equipment alarm information reported in real time with the matching results of the substation equipment alarm information defined in the substation equipment monitoring information point table, calculating the similarity, and sorting and selecting from high to low similarity; S432, setting a similarity threshold, if the matching result of the substation equipment alarm information reaches or exceeds the set threshold, the match is successful and filed in the successful matching library; S433: If the matching result of the substation equipment alarm information does not reach the set threshold, the matching is unsuccessful, and the matching failure information is stored in the unsuccessful matching library.
10. A substation centralized monitoring information point table matching system, used to implement a substation centralized monitoring information point table matching method according to any one of claims 1 to 9, characterized in that: The information point table matching system includes: an information point table library module, a regular expression module, a two-way word segmentation matching module and a similarity verification module; The information point table library module is used to store the substation equipment monitoring information point table in a standard data structure to build a substation equipment monitoring information point table library, obtain the real-time control data, substation equipment alarm information and the corresponding relationship between the real-time control data and the substation equipment alarm information; A regular expression module is used to extract the real-time control data elements of the real-time control data, analyze and filter the substation equipment alarm information by using the information definition rules based on regular expressions, obtain the substation equipment alarm information elements, and match and identify the substation equipment alarm information in combination with the real-time control data elements; The two-way word segmentation matching module is used to construct a dictionary table based on the common attributes of the information in the substation equipment monitoring information point table library, and combine the two-way maximum word segmentation matching algorithm to identify and match the substation equipment alarm information; The verification similarity module is used to verify and compare the matching similarity of the substation equipment alarm information based on the occurrence time of the real-time control data and the substation equipment alarm information, combined with the substation equipment monitoring information point table and the dictionary table, using the two-way maximum word segmentation matching algorithm.