Protection action defect data processing method and device, electronic equipment and medium

Abstract

The invention discloses a protection action defect data processing method and device, electronic equipment and a medium. The method comprises the following steps: identifying and reading protection action defect data of relay protection equipment to obtain protection action information and protection action details; determining equipment basic information corresponding to the protection action information, and determining the equipment fault condition of each substation according to the protection action information and the equipment basic information; and carrying out statistical analysis on the protection action information to determine the protection action condition of each substation, and taking the protection action details, the equipment fault condition and the protection action condition as processing results of protection action defect data. According to the technical scheme provided by the embodiment of the invention, the protection action information can be automatically reported, meanwhile, the comprehensiveness of the processing result of the protection action defect data can be ensured, and powerful support is provided for fault analysis, equipment maintenance and safety management of a power system.

Description

Technical Field

[0001] The present application relates to the field of electric power technology, and in particular to a protection action defect data processing method, device, electronic equipment and medium. Background Art

[0002] As the business and service scope of power companies continue to expand, the frequency and types of accidents within the company continue to increase. If the accident management personnel can grasp the fault information in a timely and effective manner, it will play a key role in the judgment, processing and recovery of the system. Relay protection equipment is an important part of the power system and an important guarantee for the safe and stable operation of the power system. At present, managers need to report protection action information and statistics on protection action conditions through the operation and management of the OMS system and the management and control system, so as to ensure the effective and timely operation of the professional management of relay protection, so as to achieve safe and stable operation of the power grid. However, in the prior art, when reporting protection action information on the OMS system, the management personnel need to manually modify the table in the date format, which is cumbersome. In addition, the management and control system needs to obtain the protection action information from the OMS system before it can perform statistical analysis on the protection action information, but the interface between the OMS system and the management and control system is unstable, resulting in the management and control system failing to obtain the protection action information in the OMS system, resulting in data loss. Summary of the invention

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

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

[0005] Identify and read the protection action defect data of the relay protection equipment to obtain the protection action information and protection action details;

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

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

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

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

[0010] A fault condition determination module, used to determine basic equipment information corresponding to the protection action information, and determine the equipment fault condition of each substation according to 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 use the protection action details, the equipment failure status and the protection action status as the processing result of the protection action defect data.

[0012] According to another aspect of the present 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 executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the protection action defect data processing method described in any embodiment of the present invention.

[0016] According to another aspect of the present application, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the protection action defect data processing method described in any embodiment of the present invention when executed.

[0017] The technical solution of the embodiment of the present application identifies and reads the protection action defect data of the relay protection equipment to obtain protection action information and protection action details; determines the basic information of the equipment corresponding to the protection action information, and determines the equipment fault conditions of each substation based on the protection action information and the basic information of the equipment; statistically analyzes the protection action information to determine the protection action conditions of each substation, and uses the protection action details, the equipment fault conditions, and the protection action conditions as the processing results of the protection action defect data. The technical solution of the embodiment of the present application automatically identifies and reads the protection action defect data to obtain protection action information and protection action details, thereby realizing automatic reporting of the protection action information, and then using the protection action details and the equipment fault conditions and protection action conditions obtained by analyzing and processing the protection action information as the processing results of the protection action defect data, which can ensure the comprehensiveness of the processing results of the protection action defect data and provide strong support for fault analysis, equipment maintenance, and safety management of the power system.

[0018] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. 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 creative work.

[0020] Figure 1 is a flow chart of a protection action defect data processing method provided according to Embodiment 1 of the present application;

[0021] Figure 2 is a flow chart of a protection action defect data processing method provided according to Embodiment 2 of the present application;

[0022] Figure 3 It is a schematic diagram of the action details of a protection action table provided according to the second embodiment of the present application;

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

[0024] Figure 5 It is a schematic diagram of a substation and a global corresponding protection action statistical table provided according to the second embodiment of the present application;

[0025] Figure 6 It is a structural schematic diagram of a protection action defect data processing device provided according to Embodiment 3 of the present application;

[0026] Figure 7 It is a structural schematic diagram of an electronic device that implements the protection action defect data processing method of an embodiment of the present application. DETAILED DESCRIPTION

[0027] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work 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 and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0029] Embodiment 1

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

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

[0032] Among them, relay protection equipment refers to equipment used to monitor current, voltage and other parameters in the power system, detect whether there are abnormal conditions (such as short circuit, overcurrent, etc.), and when a fault is detected, quickly determine the fault location according to preset protection action conditions, and output signals to circuit breakers or other switching devices to isolate the fault.

[0033] Among them, the protection action defect data refers to the defect data related to the protection action generated during the completion of the protection action of the relay protection device. In the embodiment of the present application, the protection action defect data is usually in the form of a table, and the specific content of the table needs to be filled in and reviewed by the staff according to the corresponding items. The protection action information includes date, plant name, voltage level, faulty equipment, fault type, etc. The protection action details include protection name, protection type, action element, function classification, action time, etc.

[0034] In an embodiment of the present application, after obtaining the Excel table corresponding to the protection action defect data, the table can be directly imported into the processing platform, and the processing platform automatically identifies and reads the protection action defect data to obtain the protection action information and protection action details, thereby realizing automatic reporting of the protection action information. In an embodiment of the present application, the processing platform can support the processing of Excel tables in multiple formats, such as xls format, xlsx format, etc. By identifying and reading the protection action information and protection action details in the protection action defect data, the specific situation and details of the protection action can be understood, providing basic data for subsequent analysis and processing.

[0035] S120: Determine basic equipment information corresponding to the protection action information, and determine equipment fault conditions of each substation according to the protection action information and the basic equipment information.

[0036] Among them, the basic information of the equipment includes dispatch scope, unit name, asset ownership, equipment type, voltage level, primary equipment maintenance scope, secondary equipment maintenance scope, etc.

[0037] In an embodiment of the present application, basic equipment information corresponding to the protection action information can be input by manual entry, and after obtaining the basic equipment information corresponding to the protection action information, the protection action information and the basic equipment information are combined to analyze the cause and nature of the equipment failure, generate equipment failure details, and then determine the equipment failure status of each substation based on the equipment failure details, so as to provide guidance for fault handling and repair of each substation and improve the efficiency of fault handling.

[0038] S130, statistically analyzing the protection action information to determine the protection action status of each substation, and taking the protection action details, equipment failure status and protection action status as the processing result of the protection action defect data.

[0039] In an embodiment of the present application, after the protection action information is extracted from the protection action defect data, the protection action information can be statistically analyzed, such as the number of protection actions, types, success rates, etc., 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 of each substation can be evaluated, thereby ensuring the overall stability and safety of the power system. Afterwards, the protection action details, equipment failure conditions, and protection action conditions can be used as the processing results of the protection action defect data to ensure the comprehensiveness of the processing results of the protection action defect data, so as to provide strong support for fault analysis, equipment maintenance, and safety management of the power system through the processing results. Optionally, after the protection action details, equipment failure conditions, and protection action conditions are used 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 the embodiment of the present application identifies and reads the protection action defect data of the relay protection equipment to obtain protection action information and protection action details; determines the basic information of the equipment corresponding to the protection action information, and determines the equipment fault conditions of each substation based on the protection action information and the basic information of the equipment; statistically analyzes the protection action information to determine the protection action conditions of each substation, and uses the protection action details, equipment fault conditions and protection action conditions as the processing results of the protection action defect data. The technical solution of the embodiment of the present application automatically identifies and reads the protection action defect data to obtain protection action information and protection action details, realizes automatic reporting of the protection action information, and then uses the protection action details and the equipment fault conditions and protection action conditions obtained by analyzing and processing the protection action information as the processing results of the protection action defect data, which can ensure the comprehensiveness of the processing results of the protection action defect data and provide strong support for fault analysis, equipment maintenance and safety management of the power system.

[0041] Embodiment 2

[0042] Figure 2 This is a flowchart of a method for processing protection action defect data provided in the second embodiment of the present application. The present embodiment is optimized based on the above embodiment. For solutions not described in detail in the present embodiment, please refer to the above embodiment. Figure 2 As shown, the method includes:

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

[0044] Among them, the target format is a format that can be operated through the table processing PHPExcel object. The PHPExcel object is a very important entity when processing Excel files. It represents the entire Excel workbook. Through the PHPExcel object, users can perform various operations, such as reading, writing, and modifying data in Excel files, as well as setting file properties and styles.

[0045] In an embodiment of the present application, the file format of the protection action table containing the protection action defect data can be in xls format or xlsx format, and both formats of the protection action table can be loaded through the PHPExcel_IOFactory::load() method based on the PHPExcel class library. After loading the protection action table, the processing platform can automatically select a suitable parser according to the file format of the loaded protection action table, parse the binary structure of the protection action table, and convert it into a format that can be operated by the PHPExcel object.

[0046] S220. In the target format, the protection action information is extracted from the protection action table through the cell iterator, and the protection action details are extracted from the protection action table through the row iterator.

[0047] Among them, a cell iterator is a tool or method used to traverse cells in a worksheet when processing a spreadsheet (such as Excel), and a row iterator is a tool or method used to traverse rows in a worksheet when processing a spreadsheet. Through cell iterators and row iterators, you can simplify access to and operation of spreadsheet data to efficiently process large amounts of data.

[0048] In the embodiment of the present application, the worksheet containing the protection action defect data in the protection action table can be obtained through the getSheet() method in the target format. Generally speaking, the worksheet containing the protection action defect data is usually the first worksheet in the Excel file corresponding to the protection action table. After that, the protection action information can be extracted from the protection action table through the cell iterator, and the protection action details can be extracted from the protection action table through the row iterator.

[0049] Optionally, the protection action information is extracted from the protection action table through a cell iterator, and the protection action details are extracted from the protection action table through a row iterator, including: traversing all cells in the protection action table through the cell iterator, and extracting the contents in the corresponding cells according to preset cell coordinates as the protection action information; traversing all rows in the protection action table through the row iterator, and extracting the contents in 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 where the first preset field is located, and the second target row is the row where the second preset field is located.

[0050] In an embodiment of the present application, all cells in the protection action table can be traversed through a cell iterator (getCellIterator()), and the content in the corresponding cell can be extracted as protection action information according to preset cell coordinates, such as B2, D2, F2, etc. Optionally, while extracting the protection action information, the date value in the protection action table can be converted into a PHP date and time object through the PHPExcel_Shared_Date::ExcelToPHP() method, and then formatted and output. At the same time, all rows in the protection action table can be traversed through a row iterator (getRowIterator()), the row where the first preset field is located and the row where the second preset field is located can be identified, and the content in the row between the first target row and the second target row can be extracted as protection action details. Among them, the first preset field and the second preset field can be set according to actual needs, and the implementation of the present application is not limited to this. For example, Figure 3 A schematic diagram of the action details of a protection action table is shown. Figure 3 As shown, when extracting the protection action details from the protection action table, the first preset field may be "protection name" and the second preset field may be "total exit".

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

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

[0053] S240, respectively determine a protection action information table corresponding to the protection action information and an equipment basic information table corresponding to the equipment basic information, and determine the equipment fault status of each substation according to the protection action information table and the equipment basic information table.

[0054] In an embodiment of the present application, after determining the basic information of the equipment related to the protection action information, a protection action information table can be generated according to the protection action information, and a basic equipment information table can be generated according to the basic information of the equipment. Then, the protection action information table and the basic equipment information table can be combined to determine the equipment fault status of each substation.

[0055] Optionally, the equipment fault conditions of each substation are determined according to the protection action information table and the equipment basic information table, including: associating the query of the protection action information table and the equipment basic information table, filtering out target protection action information data from the protection action information table according to preset rules; filling the target protection action information data into a preset table template in rows to obtain an equipment fault list to determine the equipment fault conditions of each substation.

[0056] In an embodiment of the present application, the protection action information table and the equipment basic information table can be first associated and queried, and the target protection action information data can be filtered out from the protection action information table according to preset rules. Among them, the preset rules can be adjusted according to actual needs. Exemplarily, the protection action information that meets 110kV in the protection action information table can be filtered and sorted into target protection action information data according to the field values ​​to be exported. Afterwards, the target protection action information data can be filled into the preset table template in units of lines to obtain an equipment fault detailed table to determine the equipment fault conditions of each substation. Specifically, a new Excel object can be created first, and the preset Excel template file can be loaded using the PHPExcel_IOFactory::load() method, and the target protection action information data can be filled into the preset table template in units of lines through the fromArray() method to obtain an equipment fault detailed table. Optionally, after obtaining the equipment fault detail table, the style of the cells in the fault detail table, including font, color, border, alignment, etc., can be set through the applyFromArray() method, and the set fault detail table can be output to the browser for download through file stream.

[0057] S250. Determine the substation corresponding to the protection action information according to the plant station name in the protection action information.

[0058] In an embodiment of the present application, the substation corresponding to the protection action information can be determined based on the plant name in the protection action information, so as to implement 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. Collect statistics on the protection action information of each substation according to a preset statistical rule to obtain the protection action status of each substation.

[0060] In the embodiment of the present application, the protection action information of each substation can be counted according to the preset statistical rules to obtain the protection action status of each substation, evaluate the performance and reliability of the relay protection equipment in each substation, and thus ensure the overall stability and safety 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 counted according to preset statistical rules to obtain the protection action status of each substation, including: for each substation, determining the monthly protection action number, annual protection action number, false action number and action accuracy rate of the substation according to the protection action information corresponding to the substation; and arranging the monthly protection action number, annual protection action number, false action number and action accuracy rate into a protection action statistical table to obtain the protection action status of each substation.

[0062] In an embodiment of the present application, for each substation, the monthly protection action number, annual protection action number, false action number and action accuracy rate of the substation can be determined according to the protection action information corresponding to the substation. Specifically, 1. Taking the month as the unit, query the number of correct protection actions in the protection action information corresponding to each month as the monthly protection action number; 2. Taking the year as the unit, query the number of correct protection actions in the protection action information corresponding to each year as the annual protection action number; 3. Taking the year as the unit, query the number of rapid protection evaluations and the actual number of rapid actions in the protection action information corresponding to each year, and subtract the actual number of rapid actions from the number of rapid protection evaluations to obtain the number of false actions; 4. According to the calculation formula, action accuracy rate = protection action number / (protection action number + false action number), the action accuracy rate is calculated. Optionally, after counting the monthly protection action number and the annual protection action number, the year-on-year data corresponding to the monthly protection action number and the year-on-year data corresponding to the annual protection action number can be calculated respectively. Afterwards, the monthly protection action times, annual protection action times, false action times, and action accuracy rates can be organized into a protection action statistical table to obtain the protection action status of each substation. Optionally, the year-on-year data corresponding to the monthly protection action times and the year-on-year data corresponding to the annual protection action times can be added to the protection action statistical 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 statistical table corresponding to the global protection action status can be generated. Exemplarily, Figure 5 A schematic diagram of a substation and a corresponding global protection action statistical table is shown.

[0063] S270. Use the protection action details, equipment failure conditions, and protection action conditions as the processing result of the protection action defect data.

[0064] In an embodiment of the present application, protection action details, equipment fault conditions, and protection action conditions can be used as 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 the power system through the processing results.

[0065] The technical solution of the embodiment of the present application converts the format of a protection action table containing protection action defect data into a target format for operation using a table processing object; in the target format, extracts protection action information from the protection action table through a cell iterator, and extracts protection action details from the protection action table through a row iterator; receives basic equipment information related to the protection action information input by a user through a user interface; respectively determines a protection action information table corresponding to the protection action information and an equipment basic information table corresponding to the equipment basic information, and determines the equipment fault condition of each substation according to the protection action information table and the equipment basic information table; determines the substation corresponding to the protection action information according to the plant name in the protection action information; counts the protection action information of each substation according to preset statistical rules to obtain the protection action condition of each substation; and uses the protection action details, equipment fault condition and protection action condition as the processing result of the protection action defect data. The technical solution of the embodiment of the present application obtains protection action information and protection action details by automatically identifying and reading protection action defect data, thereby realizing automatic reporting of protection action information, and then using the protection action details and the equipment fault conditions and protection action conditions obtained by analyzing and processing the protection action information as the processing results of the protection action defect data, thereby ensuring the comprehensiveness of the processing results of the protection action defect data and providing strong support for fault analysis, equipment maintenance and safety management of the power system.

[0066] Embodiment 3

[0067] Figure 6 This is a schematic diagram of the structure of a protection action defect data processing device provided in Embodiment 3 of the present application. Figure 6 As shown, the device comprises:

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

[0069] A fault condition determination module 320 is used to determine basic equipment information corresponding to the protection action information, and determine the equipment fault condition of each substation according to 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 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 identification and reading module 310 includes:

[0072] A target format conversion unit, used for converting the format of the protection action table containing the protection action defect data into a target format for operation 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 to extract the protection action details from the protection action table through a row iterator in the target format.

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

[0075] A protection action information extraction subunit, 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 details extraction sub-unit is used to traverse all rows in the protection action table through the row iterator, and extract the content in 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 where the first preset field is located, and the second target row is the row where the second preset field is located.

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

[0078] A device basic information determination unit, configured to receive basic device information related to the protection action information input by a user through a user interface;

[0079] The fault condition determination unit is used to respectively 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 condition of each substation according to the protection action information table and the equipment basic information table.

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

[0081] A target data screening subunit, used for associating and querying the protection action information table and the device basic information table, and screening target protection action information data from the protection action information table according to a preset rule;

[0082] The fault condition determination subunit is used to fill the target protection action information data into a preset table template in line units to obtain an equipment fault detailed list to determine the equipment fault conditions of each substation.

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

[0084] A substation determining unit, configured to determine the substation corresponding to the protection action information according to the plant station name in the protection action information;

[0085] The protection action status determination unit is used to collect statistics on the protection action information of each substation according to a preset statistical rule to obtain the protection action status of each substation.

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

[0087] A protection action information statistics subunit is used to determine, for each substation, the monthly protection action number, annual protection action number, false action number and action accuracy rate of the substation according to the protection action information corresponding to the substation;

[0088] The protection action status determination subunit is used to organize the monthly protection action times, the annual protection action times, the false action times and the action accuracy rate into a protection action statistical table to obtain the protection action status of each substation.

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

[0090] Embodiment 4

[0091] Figure 7A schematic diagram of an electronic device 10 that can be used to implement an embodiment of the present 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 processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

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

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

[0094] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 executes 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, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the protection action defect data processing method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to execute the protection action defect data processing method in any other appropriate manner (e.g., by means of firmware).

[0096] Various implementations 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 chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0097] The computer programs for implementing the methods of the present 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, so that when the computer programs are executed by the processor, the functions / operations specified in the flow charts and / or block diagrams are implemented. The computer programs may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

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

[0099] To provide interaction with a user, the systems and techniques described herein may 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 a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0100] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0101] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0102] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps recorded in this application can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document is not limited here.

[0103] The above specific implementations do not constitute a limitation on the protection scope of this application. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of this application.

Claims

1. A method for processing protection action defect data, characterized in that: The method comprises: Identify and read the protection action defect data of the relay protection equipment to obtain the protection action information and protection action details; Determine the basic information of the equipment corresponding to the protection action information, and determine the equipment fault status of each substation according to the protection action information and the basic information of the equipment; The protection action information is statistically analyzed to determine the protection action status of each substation, and the protection action details, the equipment failure status and the protection action status are used as the processing result of the protection action defect data.

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

3. The method according to claim 2, characterized in that Extracting the protection action information from the protection action table through a cell iterator, and extracting the protection action details from the protection action table through a row iterator, including: Traversing all cells in the protection action table through the cell iterator, and extracting the content in the corresponding cell according to the preset cell coordinates as the protection action information; All rows in the protection action table are traversed through the row iterator, and the content in the row between the first target row and the second target row is extracted as the protection action details; wherein the first target row is the row where the first preset field is located, and the second target row is the row where the second preset field is located.

4. The method according to claim 1, characterized in that: Determining basic equipment information corresponding to the protection action information, and determining equipment fault conditions of each substation according to the protection action information and the basic equipment information, including: Receiving basic device information related to the protection action information input by a user through a user interface; A protection action information table corresponding to the protection action information and an equipment basic information table corresponding to the equipment basic information are determined respectively, and the equipment fault conditions of each substation are determined according to the protection action information table and the equipment basic information table.

5. The method according to claim 4, characterized in that Determining the equipment fault conditions of each substation according to the protection action information table and the equipment basic information table includes: Associatively querying the protection action information table and the device basic information table, and filtering out target protection action information data from the protection action information table according to a preset rule; The target protection action information data is filled into a preset table template in line units to obtain a detailed equipment fault list to determine the equipment fault conditions of each substation.

6. The method according to claim 1, characterized in that Statistical analysis is performed on the protection action information to determine the protection action status of each substation, including: Determine the substation corresponding to the protection action information according to the plant station name in the protection action information; The protection action information of each substation is counted according to the preset statistical rules to obtain the protection action status of each substation.

7. The method according to claim 6, characterized in that The protection action information of each substation is counted according to the preset statistical rules to obtain the protection action status of each substation, including: For each substation, determine the monthly protection action number, annual protection action number, false action number and action accuracy rate of the substation according to the protection action information corresponding to the substation; The monthly protection action times, the annual protection action times, the false action times and the action accuracy rate are sorted into a protection action statistical table to obtain the protection action status of each substation.

8. A protection action defect data processing device, characterized in that: The device comprises: A data identification and reading module is used to identify and read the protection action defect data of the relay protection equipment to obtain the protection action information and protection action details; A fault condition determination module, used to determine basic equipment information corresponding to the protection action information, and determine the equipment fault condition of each substation according to 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 use the protection action details, the equipment failure status and the protection action status as the processing result of the protection action defect data.

9. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the protection action defect data processing method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the protection action defect data processing method according to any one of claims 1 to 7 when executed.

Images