A protection action defect data processing method and device, electronic equipment and medium

Abstract

This application discloses a method, apparatus, electronic device, and medium for processing protection action defect data. The method includes: identifying and reading protection action defect data from relay protection equipment to obtain protection action information and protection action details; determining the basic equipment information corresponding to the protection action information, and determining the equipment fault status of each substation based on the protection action information and the basic equipment information; statistically analyzing the protection action information to determine the protection action status of each substation, and using the protection action details, equipment fault status, and protection action status as the processing results of the protection action defect data. The technical solution of this application embodiment can achieve automatic reporting of protection action information, and at the same time, can ensure the comprehensiveness of the processing results of protection action defect data, providing strong support for power system fault analysis, equipment maintenance, and safety management.

Description

Technical Field

[0001] This application relates to the field of power technology, and in particular to a method, apparatus, electronic device and medium for processing protection action defect data. Background Technology

[0002] As power companies expand their business operations and service scope, the frequency and types of accidents within these companies are increasing. Timely and effective fault information management plays a crucial role in fault diagnosis, handling, and system recovery. Relay protection equipment is a vital component of the power system and a critical guarantee for its safe and stable operation. Currently, management personnel need to use the Operation Management System (OMS) and control system to report protection action information and statistically analyze protection actions, thereby ensuring the effective and timely operation of relay protection management and achieving safe and stable power grid operation. However, in existing technologies, reporting protection action information on the OMS system requires manual modification of tables to a date format, which is cumbersome. Furthermore, the control system needs to obtain protection action information from the OMS system before it can perform statistical analysis; however, the interface between the OMS and control systems is unstable, leading to the control system's inability to obtain protection action information from the OMS system, resulting in data loss. Summary of the Invention

[0003] This application provides a method, apparatus, electronic device, and medium for processing protection action defect data, which can realize the automatic reporting of protection action information and ensure the comprehensiveness of the processing results of protection action defect data, providing strong support for fault analysis, equipment maintenance, and safety management of power systems.

[0004] According to one aspect of this application, a method for processing protective action defect data is provided, the method comprising:

[0005] The defective data of protection actions of relay protection equipment are identified and read to obtain protection action information and protection action details;

[0006] Determine the basic equipment information corresponding to the protection action information, and determine the equipment fault status of each substation based on the protection action information and the basic equipment information;

[0007] The protection action information is statistically analyzed to determine the protection action status of each substation. The protection action details, equipment fault status, and protection action status are used as the processing results of the protection action defect data.

[0008] According to another aspect of this application, a protective action defect data processing device is provided, the device comprising:

[0009] The data identification and reading module is used to identify and read the defective data of the protection action of the relay protection equipment to obtain protection action information and protection action details;

[0010] The fault condition determination module is used to determine the basic equipment information corresponding to the protection action information, and to determine the equipment fault condition of each substation based on the protection action information and the basic equipment information.

[0011] The processing result determination module is used to perform statistical analysis on the protection action information to determine the protection action status of each substation, and to use the protection action details, the equipment fault status, and the protection action status as the processing result of the protection action defect data.

[0012] According to another aspect of this application, an electronic device is provided, the electronic device comprising:

[0013] At least one processor; and

[0014] A memory communicatively connected to the at least one processor; wherein,

[0015] The memory stores a computer program that can be executed by the at least one processor, which enables the at least one processor to perform the protection action defect data processing method according to any embodiment of the present invention.

[0016] According to another aspect of this application, a computer-readable storage medium is provided, the computer-readable storage medium storing computer instructions for causing a processor to execute and implement the protection action defect data processing method according to any embodiment of the present invention.

[0017] The technical solution of this application embodiment identifies and reads protection action defect data of relay protection equipment to obtain protection action information and protection action details; determines the basic equipment information corresponding to the protection action information, and determines the equipment fault status of each substation based on the protection action information and the basic equipment information; performs statistical analysis on the protection action information to determine the protection action status of each substation, and uses the protection action details, the equipment fault status, and the protection action status as the processing result of the protection action defect data. The technical solution of this application embodiment, by automatically identifying and reading protection action defect data to obtain protection action information and protection action details, realizes automatic reporting of protection action information, and then uses the protection action details and the equipment fault status and protection action status obtained from the analysis and processing of the protection action information as the processing result of the protection action defect data. This ensures the comprehensiveness of the processing result of the protection action defect data and provides strong support for fault analysis, equipment maintenance, and safety management of power systems.

[0018] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of the present invention, nor is it intended to limit the scope of the invention. Other features of the invention will become readily apparent from the following description. Attached Figure Description

[0019] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0020] Figure 1 This is a flowchart of a method for processing protective action defect data according to Embodiment 1 of this application;

[0021] Figure 2 This is a flowchart of a method for processing protective action defect data according to Embodiment 2 of this application;

[0022] Figure 3 This is a schematic diagram of the action details portion of a protection action table provided according to Embodiment 2 of this application;

[0023] Figure 4 This is a schematic diagram of a user interface for inputting basic device information according to Embodiment 2 of this application;

[0024] Figure 5 This is a schematic diagram of a substation and a corresponding global protection action statistics table provided according to Embodiment 2 of this application;

[0025] Figure 6 This is a schematic diagram of a protective action defect data processing device according to Embodiment 3 of this application;

[0026] Figure 7 This is a schematic diagram of the structure of an electronic device that implements the protection action defect data processing method of the embodiments of this application. Detailed Implementation

[0027] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0028] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0029] Example 1

[0030] Figure 1 This application provides a flowchart of a protection action defect data processing method according to Embodiment 1. This embodiment is applicable to processing protection action defect data of relay protection equipment. The method can be executed by a protection action defect data processing device, which can be implemented in hardware and / or software and can be configured in an electronic device. Figure 1 As shown, the method includes:

[0031] S110. Identify and read the defective data of the protection action of the relay protection equipment to obtain protection action information and protection action details.

[0032] Among them, relay protection equipment refers to equipment used to monitor parameters such as current and voltage in power systems, detect whether abnormal conditions (such as short circuits, overcurrents, etc.) occur, and when a fault is detected, quickly determine the fault location according to preset protection action conditions and output a signal to the circuit breaker or other switching device to isolate the fault.

[0033] Among them, protection action defect data refers to defect data related to the protection action generated during the completion of the protection action of the relay protection equipment. In the embodiments of this application, protection action defect data is usually presented in tabular form, and the specific content of the table needs to be filled in and reviewed by staff according to the corresponding items. Protection action information includes date, substation name, voltage level, faulty equipment, fault type, etc., and protection action details include protection name, protection type, operating element, functional classification, and operation time, etc.

[0034] In this embodiment, after obtaining the Excel spreadsheet corresponding to the protection action defect data, the spreadsheet can be directly imported into the processing platform. The processing platform automatically identifies and reads the protection action defect data to obtain protection action information and details, thus achieving automatic reporting of protection action information. In this embodiment, the processing platform supports processing Excel spreadsheets in various formats, such as xls and xlsx. By identifying and reading the protection action information and details from the protection action defect data, the specific situation and details of the protection actions can be understood, providing basic data for subsequent analysis and processing.

[0035] S120. Determine the basic equipment information corresponding to the protection action information, and determine the equipment fault status of each substation based on the protection action information and the basic equipment information.

[0036] The basic equipment information includes the dispatching scope, unit name, asset ownership, equipment type, voltage level, primary equipment maintenance scope, and secondary equipment maintenance scope.

[0037] In this embodiment of the application, the basic equipment information corresponding to the protection action information can be manually entered. After obtaining the basic equipment information corresponding to the protection action information, the cause and nature of the equipment failure are analyzed by combining the protection action information and the basic equipment information to generate equipment failure details. Then, the equipment failure status of each substation is determined based on the equipment failure details to provide guidance for the fault handling and repair of each substation and improve the efficiency of fault handling.

[0038] S130. Statistical analysis of protection action information is performed to determine the protection action status of each substation, and the protection action details, equipment fault status, and protection action status are used as the processing results of protection action defect data.

[0039] In this embodiment, after extracting protection action information from the protection action defect data, statistical analysis can be performed on the protection action information, such as counting the number, type, and success rate of protection actions, to determine the protection action status of each substation. By statistically analyzing the protection action information to determine the protection action status of each substation, the performance and reliability of the relay protection equipment in each substation can be evaluated, thereby ensuring the overall stability and security of the power system. Subsequently, the protection action details, equipment fault conditions, and protection action status can be used as the processing results of the protection action defect data, ensuring the comprehensiveness of the processing results and providing strong support for power system fault analysis, equipment maintenance, and safety management. Optionally, after using the protection action details, equipment fault conditions, and protection action status as the processing results of the protection action defect data, detailed reports and charts can be generated based on the processing results to facilitate subsequent analysis and decision-making.

[0040] The technical solution of this application embodiment identifies and reads protection action defect data of relay protection equipment to obtain protection action information and protection action details; determines the basic equipment information corresponding to the protection action information, and determines the equipment fault status of each substation based on the protection action information and the basic equipment information; statistically analyzes the protection action information to determine the protection action status of each substation, and uses the protection action details, equipment fault status, and protection action status as the processing results of protection action defect data. The technical solution of this application embodiment, by automatically identifying and reading protection action defect data to obtain protection action information and protection action details, realizes automatic reporting of protection action information, and then uses the protection action details and the equipment fault status and protection action status obtained from the analysis and processing of the protection action information as the processing results of protection action defect data. This ensures the comprehensiveness of the processing results of protection action defect data and provides strong support for fault analysis, equipment maintenance, and safety management of power systems.

[0041] Example 2

[0042] Figure 2 This is a flowchart illustrating a method for processing protection action defect data, provided in Embodiment 2 of this application. This embodiment is an optimization based on the above embodiments; solutions not described in detail in this embodiment are found in the above embodiments. Figure 2 As shown, the method includes:

[0043] S210. Convert the format of the protection action table containing protection action defect data to the target format for operation using a table processing object.

[0044] The target format is one that can be manipulated using the PHPExcel object, a crucial entity in Excel file processing. It represents the entire Excel workbook, allowing users to perform various operations such as reading, writing, and modifying data within the Excel file, as well as setting file attributes and styles.

[0045] In this embodiment, the file format of the protection action table containing protection action defect data can be either xls or xlsx. Both formats can be loaded using the PHPExcel library via the PHPExcel_IOFactory::load() method. After loading the protection action table, the processing platform can automatically select a suitable parser based on the file format to parse the binary structure of the protection action table and convert it into a format that can be manipulated by the PHPExcel object.

[0046] S220. Under the target format, extract protection action information from the protection action table using a cell iterator, and extract protection action details from the protection action table using a row iterator.

[0047] Cell iterators are tools or methods used to iterate through cells in a spreadsheet (such as Excel), while row iterators are tools or methods used to iterate through rows in a spreadsheet. Using cell and row iterators simplifies access to and manipulation of spreadsheet data, enabling efficient processing of large amounts of data.

[0048] In this embodiment, the worksheet containing protection action defect data can be obtained from the protection action table using the getSheet() method under the target format. Generally, the worksheet containing protection action defect data is usually the first worksheet in the Excel file corresponding to the protection action table. Then, protection action information can be extracted from the protection action table using a cell iterator, and protection action details can be extracted from the protection action table using a row iterator.

[0049] Optionally, extracting the protection action information from the protection action table using a cell iterator and extracting the protection action details from the protection action table using a row iterator includes: traversing all cells in the protection action table using the cell iterator and extracting the content of the corresponding cells according to preset cell coordinates as the protection action information; traversing all rows in the protection action table using the row iterator and extracting the content of the row between the first target row and the second target row as the protection action details; wherein the first target row is the row containing the first preset field, and the second target row is the row containing the second preset field.

[0050] In this embodiment, all cells in the protection action table can be traversed using a cell iterator (getCellIterator()), and the content of the corresponding cells can be extracted according to preset cell coordinates, such as B2, D2, F2, etc., as protection action information. Optionally, while extracting the protection action information, the date values ​​in the protection action table can be converted into PHP date and time objects using the PHPExcel_Shared_Date::ExcelToPHP() method, and then formatted for output. Simultaneously, all rows in the protection action table can be traversed using a row iterator (getRowIterator()), identifying the rows containing the first preset field and the second preset field, and extracting the content of the row between the first and second target rows as protection action details. The first and second preset fields can be set according to actual needs, and this embodiment does not limit this. For example, Figure 3 A schematic diagram of the action details section of a protective action form is shown, such as... Figure 3 As shown, when extracting the details of protection actions from the protection action table, the first preset field can be "protection name" and the second preset field can be "total exit".

[0051] S230: Receive basic device information related to protection action information input by the user through the user interface.

[0052] In this embodiment of the application, a user interface for content input can be provided to the user, allowing the user to input basic device information related to protection action information. For example, Figure 4 A schematic diagram of a user interface for inputting basic device information is shown.

[0053] S240. Determine the protection action information table corresponding to the protection action information and the equipment basic information table corresponding to the equipment basic information, and determine the equipment fault status of each substation based on the protection action information table and the equipment basic information table.

[0054] In this embodiment of the application, after determining the basic equipment information related to the protection action information, a protection action information table can be generated based on the protection action information, and a basic equipment information table can be generated based on the basic equipment information. Then, by combining the protection action information table and the basic equipment information table, the equipment fault status of each substation can be determined.

[0055] Optionally, determining the equipment fault status of each substation based on the protection action information table and the equipment basic information table includes: querying the protection action information table and the equipment basic information table together; filtering target protection action information data from the protection action information table according to preset rules; and filling the target protection action information data into a preset table template in rows to obtain an equipment fault details table, thereby determining the equipment fault status of each substation.

[0056] In this embodiment, the protection action information table and the equipment basic information table can be linked and queried first. Target protection action information data can be filtered from the protection action information table according to preset rules. These preset rules can be adjusted as needed. For example, protection action information conforming to 110kV in the protection action information table can be filtered and organized into target protection action information data according to the required exported field values. Then, the target protection action information data can be filled into a preset table template row by row to obtain an equipment fault details table, thus determining the equipment fault status of each substation. Specifically, a new Excel object can be created, and the preset Excel template file can be loaded using the PHPExcel_IOFactory::load() method. The target protection action information data can then be filled into the preset table template row by row using the fromArray() method to obtain the equipment fault details table. Optionally, after obtaining the equipment fault details table, the style of the cells in the fault details table can be set using the applyFromArray() method, including font, color, border, alignment, etc., and the set fault details table can be output to the browser for download via file stream.

[0057] S250. Determine the substation corresponding to the protection action information based on the substation name in the protection action information.

[0058] In this embodiment of the application, the substation corresponding to the protection action information can be determined according to the substation name in the protection action information, so as to realize the statistical analysis of the protection action information corresponding to each substation, and then evaluate the performance of the relay protection equipment in each substation.

[0059] S260. According to the preset statistical rules, the protection action information of each substation is statistically analyzed to obtain the protection action status of each substation.

[0060] In this embodiment, the protection action information of each substation can be statistically analyzed according to preset statistical rules to obtain the protection action status of each substation, and the performance and reliability of the relay protection equipment in each substation can be evaluated, thereby ensuring the overall stability and security of the power system. The preset statistical rules can be dynamically adjusted according to actual needs.

[0061] Optionally, the protection action information of each substation is statistically analyzed according to preset statistical rules to obtain the protection action status of each substation, including: for each substation, determining the monthly protection action count, annual protection action count, false trip count, and action accuracy rate of the substation based on the protection action information corresponding to the substation; and compiling the monthly protection action count, the annual protection action count, the false trip count, and the action accuracy rate into a protection action statistics table to obtain the protection action status of each substation.

[0062] In this embodiment, for each substation, the monthly protection action count, annual protection action count, number of false trips, and action accuracy rate can be determined based on the protection action information corresponding to that substation. Specifically, 1. The number of correct protection actions in the corresponding protection action information for each month is retrieved as the monthly protection action count; 2. The number of correct protection actions in the corresponding protection action information for each year is retrieved as the annual protection action count; 3. The number of rapid protection actions to be evaluated and the number of actual rapid actions in the corresponding protection action information for each year are retrieved as the annual protection action count, and the number of false trips is obtained by subtracting the number of rapid protection actions to be evaluated; 4. The action accuracy rate is calculated according to the formula: Action accuracy rate = Number of protection actions / (Number of protection actions + Number of false trips). Optionally, after calculating the monthly and annual protection action counts, the year-on-year data corresponding to the monthly protection action count and the year-on-year data corresponding to the annual protection action count can be calculated separately. Next, the monthly protection action count, annual protection action count, number of false trips, and action accuracy rate can be compiled into a protection action statistics table to obtain the protection action status of each substation. Optionally, the year-on-year data corresponding to the monthly protection action count and the year-on-year data corresponding to the annual protection action count can be added to the protection action statistics table. Optionally, after obtaining the protection action status of each substation, the protection action status of each substation can be summarized to obtain the global protection action status, and a protection action statistics table corresponding to the global protection action status can be generated. For example, Figure 5 A schematic diagram of a substation and its corresponding global protection action statistics table is shown.

[0063] S270. The details of protection actions, equipment failure status, and protection action status are used as the processing results of protection action defect data.

[0064] In this embodiment of the application, the details of protection actions, equipment fault conditions, and protection action conditions can be used as the processing results of protection action defect data to ensure the comprehensiveness of the processing results of protection action defect data, so as to provide strong support for fault analysis, equipment maintenance and safety management of power systems through the processing results.

[0065] The technical solution of this application embodiment converts the format of the protection action table containing protection action defect data into a target format for operation using a table processing object; in the target format, protection action information is extracted from the protection action table through a cell iterator, and protection action details are extracted from the protection action table through a row iterator; basic equipment information related to protection action information is received from the user through the user interface; the protection action information table corresponding to the protection action information and the basic equipment information table corresponding to the basic equipment information are determined respectively, and the equipment fault status of each substation is determined according to the protection action information table and the basic equipment information table; the substation corresponding to the protection action information is determined according to the substation name in the protection action information; the protection action information of each substation is statistically analyzed according to preset statistical rules to obtain the protection action status of each substation; and the protection action details, equipment fault status, and protection action status are used as the processing results of protection action defect data. The technical solution of this application embodiment obtains protection action information and protection action details by automatically identifying and reading protection action defect data, realizes automatic reporting of protection action information, and then uses the protection action details and the equipment fault status and protection action status obtained by analyzing and processing the protection action information as the processing result of protection action defect data. This can ensure the comprehensiveness of the processing result of protection action defect data and provide strong support for fault analysis, equipment maintenance and safety management of power systems.

[0066] Example 3

[0067] Figure 6 This is a schematic diagram of a protective action defect data processing device provided in Embodiment 3 of this application. Figure 6 As shown, the device includes:

[0068] The data identification and reading module 310 is used to identify and read the protection action defect data of the relay protection equipment to obtain protection action information and protection action details;

[0069] The fault condition determination module 320 is used to determine the basic equipment information corresponding to the protection action information, and to determine the equipment fault condition of each substation based on the protection action information and the basic equipment information.

[0070] The processing result determination module 330 is used to perform statistical analysis on the protection action information to determine the protection action status of each substation, and to use the protection action details, the equipment fault status, and the protection action status as the processing result of the protection action defect data.

[0071] Optionally, the data recognition and reading module 310 includes:

[0072] The target format conversion unit is used to convert the format of the protection action table containing the protection action defect data into a target format that is operated on using a table processing object;

[0073] The data identification and reading unit is used to extract the protection action information from the protection action table through a cell iterator and extract the protection action details from the protection action table through a row iterator under the target format.

[0074] Optionally, the data identification and reading unit includes:

[0075] The protection action information extraction subunit is used to traverse all cells in the protection action table through the cell iterator and extract the content in the corresponding cell according to the preset cell coordinates as the protection action information;

[0076] The protection action detail extraction subunit is used to traverse all rows in the protection action table through the row iterator and extract the content of the row between the first target row and the second target row as the protection action detail; wherein, the first target row is the row containing the first preset field, and the second target row is the row containing the second preset field.

[0077] Optionally, the fault condition determination module 320 includes:

[0078] The device basic information determination unit is used to receive device basic information related to the protection action information input by the user through the user interface;

[0079] The fault condition determination unit is used to determine the protection action information table corresponding to the protection action information and the equipment basic information table corresponding to the equipment basic information, and to determine the equipment fault condition of each substation based on the protection action information table and the equipment basic information table.

[0080] Optionally, the fault condition determination unit includes:

[0081] The target data filtering subunit is used to query the protection action information table and the equipment basic information table together, and to filter the target protection action information data from the protection action information table according to preset rules.

[0082] The fault condition determination subunit is used to fill the target protection action information data into a preset table template in rows to obtain a detailed equipment fault table, so as to determine the equipment fault condition of each substation.

[0083] Optionally, the processing result determination module 330 includes:

[0084] The substation determination unit is used to determine the substation corresponding to the protection action information based on the substation name in the protection action information;

[0085] The protection action status determination unit is used to statistically analyze the protection action information of each substation according to preset statistical rules, and obtain the protection action status of each substation.

[0086] Optionally, the protection action determination unit includes:

[0087] The protection action information statistics subunit is used to determine the monthly number of protection actions, annual number of protection actions, number of false trips, and action accuracy rate of each substation based on the protection action information corresponding to the substation.

[0088] The protection action status determination subunit is used to compile the monthly protection action count, the annual protection action count, the number of false trips, and the action accuracy rate into a protection action statistics table to obtain the protection action status of each substation.

[0089] The protective action defect data processing device provided in this application embodiment can execute the protective action defect data processing method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the method execution.

[0090] Example 4

[0091] Figure 7A schematic diagram of an electronic device 10, which can be used to implement embodiments of this application, is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.

[0092] like Figure 7 As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) 12 or a random access memory (RAM) 13, communicatively connected to the at least one processor 11. The memory stores computer programs executable by the at least one processor. The processor 11 can perform various appropriate actions and processes based on the computer program stored in the ROM 12 or loaded from storage unit 18 into the RAM 13. The RAM 13 may also store various programs and data required for the operation of the electronic device 10. The processor 11, ROM 12, and RAM 13 are interconnected via a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0093] Multiple components in electronic device 10 are connected to I / O interface 15, including: input unit 16, such as keyboard, mouse, etc.; output unit 17, such as various types of displays, speakers, etc.; storage unit 18, such as disk, optical disk, etc.; and communication unit 19, such as network card, modem, wireless transceiver, etc. Communication unit 19 allows electronic device 10 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0094] Processor 11 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. Processor 11 performs the various methods and processes described above, such as the protection action defect data processing method.

[0095] In some embodiments, the protection action defect data processing method may be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on electronic device 10 via ROM 12 and / or communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the protection action defect data processing method described above may be performed. Alternatively, in other embodiments, processor 11 may be configured to perform the protection action defect data processing method by any other suitable means (e.g., by means of firmware).

[0096] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0097] Computer programs used to implement the methods of this application may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when executed by the processor, the computer programs cause the functions / operations specified in the flowcharts and / or block diagrams to be performed. The computer programs may be executed entirely on a machine, partially on a machine, or as a standalone software package, partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0098] In the context of this application, a computer-readable storage medium can be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device. A computer-readable storage medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium can be a machine-readable signal medium. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0099] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0100] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as data servers), or computing systems that include middleware components (e.g., application servers), or computing systems that include frontend components (e.g., user computers with graphical user interfaces or web browsers through which users can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., communication networks). Examples of communication networks include local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.

[0101] A computing system can include clients and servers. Clients and servers are generally located far apart and typically interact through communication networks. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a hosting product within the cloud computing service system to address the shortcomings of traditional physical hosts and VPS services, such as high management difficulty and weak business scalability.

[0102] It should be understood that the various forms of processes shown above can be used, with steps rearranged, added, or deleted. For example, the steps described in this application can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this invention can be achieved, and no limitation is imposed herein.

[0103] The specific embodiments described above do not constitute a limitation on the scope of protection of this application. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this application.

Claims

1. A method for processing protection action defect data, characterized in that, The method includes: The defective data of protection actions of relay protection equipment are identified and read to obtain protection action information and protection action details; Determine the basic equipment information corresponding to the protection action information, and determine the equipment fault status of each substation based on the protection action information and the basic equipment information; The protection action information is statistically analyzed to determine the protection action status of each substation, and the protection action details, equipment fault status, and protection action status are used as the processing results of the protection action defect data. Determine the basic equipment information corresponding to the protection action information, and determine the equipment fault status of each substation based on the protection action information and the basic equipment information, including: Receive basic device information related to the protection action information input by the user through the user interface; The protection action information table corresponding to the protection action information and the equipment basic information table corresponding to the equipment basic information are determined respectively, and the equipment fault status of each substation is determined according to the protection action information table and the equipment basic information table; The equipment fault status of each substation is determined based on the protection action information table and the equipment basic information table, including: The system performs a linked query on the protection action information table and the device basic information table, and filters out the target protection action information data from the protection action information table according to preset rules. The target protection action information data is filled into a preset table template in rows to obtain a detailed equipment fault table, so as to determine the equipment fault status of each substation.

2. The method according to claim 1, characterized in that, The protection action defect data is identified and read to obtain protection action information and protection action details, including: The format of the protection action table containing the protection action defect data is converted into the target format for operation using a table processing object; Under the target format, the protection action information is extracted from the protection action table using a cell iterator, and the protection action details are extracted from the protection action table using a row iterator.

3. The method according to claim 2, characterized in that, The protection action information is extracted from the protection action table using a cell iterator, and the protection action details are extracted from the protection action table using a row iterator, including: The cell iterator is used to traverse all cells in the protection action table and extract the content of the corresponding cell according to the preset cell coordinates, which is used as the protection action information. The row iterator traverses all rows in the protection action table and extracts the content of the row between the first target row and the second target row as the protection action details; wherein, the first target row is the row containing the first preset field and the second target row is the row containing the second preset field.

4. The method according to claim 1, characterized in that, Statistical analysis of the protection action information is performed to determine the protection action status of each substation, including: The substation corresponding to the protection action information is determined based on the substation name in the protection action information. The protection action information of each substation is statistically analyzed according to the preset statistical rules to obtain the protection action status of each substation.

5. The method according to claim 4, characterized in that, The protection action information of each substation is statistically analyzed according to preset statistical rules to obtain the protection action status of each substation, including: For each substation, the monthly number of protection actions, annual number of protection actions, number of false trips, and action accuracy rate of the substation are determined based on the protection action information corresponding to the substation. The monthly protection action count, the annual protection action count, the number of false trips, and the action accuracy rate are compiled into a protection action statistics table to obtain the protection action status of each substation.

6. A protective action defect data processing device, characterized in that, The device includes: The data identification and reading module is used to identify and read the defective data of the protection action of the relay protection equipment to obtain protection action information and protection action details; The fault condition determination module is used to determine the basic equipment information corresponding to the protection action information, and to determine the equipment fault condition of each substation based on the protection action information and the basic equipment information. The processing result determination module is used to perform statistical analysis on the protection action information to determine the protection action status of each substation, and to use the protection action details, the equipment fault status, and the protection action status as the processing result of the protection action defect data; The fault condition determination module includes: The device basic information determination unit is used to receive device basic information related to the protection action information input by the user through the user interface; The fault condition determination unit is used to determine the protection action information table corresponding to the protection action information and the equipment basic information table corresponding to the equipment basic information, and to determine the equipment fault condition of each substation based on the protection action information table and the equipment basic information table. The fault condition determination unit includes: The target data filtering subunit is used to query the protection action information table and the equipment basic information table together, and to filter the target protection action information data from the protection action information table according to preset rules. The fault condition determination subunit is used to fill the target protection action information data into a preset table template in rows to obtain a detailed equipment fault table, so as to determine the equipment fault condition of each substation.

7. An electronic device, characterized in that, The electronic device includes: At least one processor; and A memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the protection action defect data processing method according to any one of claims 1-5.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that, when executed by a processor, implement the protection action defect data processing method according to any one of claims 1-5.

Images