Power grid operation data processing system and method

Abstract

The invention discloses a power grid operation data processing system and method. The system comprises a user terminal used for acquiring operation information in a task operation interface matched with the user terminal, determining power distribution terminal information and task parameter information according to the operation information, and sending the power distribution terminal information and the task parameter information to a data processing platform; the data processing platform is used for receiving the power distribution terminal information and the task parameter information, determining a target power distribution terminal according to the power distribution terminal information and acquiring power grid operation data of the target power distribution terminal; and the data processing platform is used for generating a task execution result according to the power grid operation data and the task parameter information and feeding back the task execution result to the user terminal. According to the technical scheme, the problem of low processing efficiency of the power grid operation data is solved, the processing efficiency of the power grid operation data can be improved while automatic execution of different tasks is realized, manual intervention is avoided, and the error rate is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a system and method for processing power grid operation data. Background Art

[0002] At present, a large number of distribution terminals are configured in the power system to complete tasks such as data collection, equipment control, and equipment communication within the power grid. Distribution terminals require management by staff of various business types, such as calibration of distribution terminals and metering and statistics of power grid operation data collected by distribution terminals. The processing of power grid operation data within the power system is highly dependent on manual labor, and manual data processing is inefficient and difficult to ensure timeliness. Summary of the invention

[0003] The present invention provides a system and method for processing power grid operation data to solve the problem of low power grid operation data processing efficiency. While realizing the automated execution of different tasks, the processing efficiency of power grid operation data can be improved, manual intervention can be avoided, and the error rate can be reduced.

[0004] According to one aspect of the present invention, there is provided a system for processing power grid operation data, the system comprising a data processing platform, at least one power distribution terminal and at least one user terminal;

[0005] The user terminal is used to obtain operation information in the task operation interface matched by the user terminal, determine the power distribution terminal information and the task parameter information according to the operation information, and send the power distribution terminal information and the task parameter information to the data processing platform;

[0006] The data processing platform is used to receive the power distribution terminal information and the task parameter information, determine the target power distribution terminal according to the power distribution terminal information, and obtain the power grid operation data of the target power distribution terminal;

[0007] The data processing platform is used to generate task execution results according to the power grid operation data and the task parameter information, and feed back the results to the user terminal.

[0008] According to another aspect of the present invention, a method for processing power grid operation data is provided, the method being executed by a power grid operation data processing system, the power grid operation data processing system comprising a data processing platform, at least one power distribution terminal and at least one user terminal; the method comprising:

[0009] Acquiring operation information in the task operation interface matched by the user terminal through the user terminal, determining the power distribution terminal information and the task parameter information according to the operation information, and sending the power distribution terminal information and the task parameter information to the data processing platform;

[0010] Receiving power distribution terminal information and task parameter information through a data processing platform, determining a target power distribution terminal according to the power distribution terminal information, and acquiring power grid operation data of the target power distribution terminal;

[0011] The data processing platform generates the task execution result according to the power grid operation data and the task parameter information, and feeds back to the user terminal.

[0012] The technical solution of the embodiment of the present invention is to obtain the operation information in the task operation interface matched by the user terminal through the user terminal, determine the distribution terminal information and the task parameter information according to the operation information, and send the distribution terminal information and the task parameter information to the data processing platform; receive the distribution terminal information and the task parameter information through the data processing platform, determine the target distribution terminal according to the distribution terminal information, and obtain the power grid operation data of the target distribution terminal; generate the task execution result according to the power grid operation data and the task parameter information through the data processing platform, and feed it back to the user terminal. This solution solves the problem of low processing efficiency of power grid operation data, and can improve the processing efficiency of power grid operation data while realizing the automated execution of different tasks, avoid manual intervention, and reduce the error rate.

[0013] 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

[0014] 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.

[0015] Figure 1 is a structural diagram of a system for processing power grid operation data provided according to Embodiment 1 of the present invention;

[0016] Figure 2 This is a flow chart of a method for processing power grid operation data provided according to Embodiment 2 of the present invention. DETAILED DESCRIPTION

[0017] 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.

[0018] 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 interchangeable 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 of their variations 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. The acquisition, storage, use, processing, etc. of data in the technical solution of this application comply with the relevant provisions of national laws and regulations.

[0019] Embodiment 1

[0020] Figure 1 1 is a schematic diagram of a system for processing power grid operation data according to a first embodiment of the present invention. This embodiment is a system for processing power grid operation data. The system can be applied to a management scenario of a distribution terminal in a power system, such as Figure 1 As shown, the system includes a user terminal 110, a data processing platform 120 and a power distribution terminal 130;

[0021] The user terminal 110 is used to obtain operation information in the task operation interface matched by the user terminal 110, determine the power distribution terminal information and the task parameter information according to the operation information, and send the power distribution terminal information and the task parameter information to the data processing platform 120;

[0022] The data processing platform 120 is used to receive the power distribution terminal information and the task parameter information, determine the target power distribution terminal 130 according to the power distribution terminal information, and obtain the power grid operation data of the target power distribution terminal 130;

[0023] The data processing platform 120 is used to generate a task execution result according to the power grid operation data and the task parameter information, and feed the result back to the user terminal 110 .

[0024] In this solution, the user terminal 110 may be a business terminal of a power system worker, and may be a personal computer, a smart phone, a tablet computer, or other device. Different types of workers may have different task operation interfaces of their user terminals 110. The user may trigger the data processing platform 120 to automatically execute the data processing task set by the user terminal by selecting, clicking, and inputting on the task operation interface.

[0025] Specifically, the user terminal 110 can detect the operation information in the task operation interface, such as the input location, input content and other information of the input operation. According to the user's operation information obtained in the task operation interface, the user terminal 110 can extract the distribution terminal information and the task parameter information. Among them, the distribution terminal information can be the description information of the distribution terminal involved in the data processing task, for example, it can include the name, number, type, deployment location, network address, affiliated plant and power supply station of the distribution terminal. The task parameter information can be the task description information of the data processing task, for example, it can include the range limit, time limit, processing logic and statistical tools of the data. The user terminal 110 can send the distribution terminal information and the task parameter information to the data processing platform 120, so that the data processing platform 120 can perform the data processing task according to the distribution terminal information and the task parameter information.

[0026] The data processing platform 120 can receive the power distribution terminal information and task parameter information sent by the user terminal 110, determine the target power distribution terminal 130 according to the power distribution terminal information, and obtain the power grid operation data of the target power distribution terminal 130. The power grid operation data can be various electrical parameters in the distribution network. The power distribution terminal 130 can periodically collect power grid operation data and store the power grid operation data collected in each period locally in the power distribution terminal 130. The power distribution terminal 130 can also send the power grid operation data collected in each period to the data processing platform, and the database of the data processing platform manages the power grid operation data.

[0027] It can be understood that the distribution terminal 130 can be various monitoring and control units installed in the distribution network, such as feeder terminal (FTU, Feeder Terminal Unit), station terminal (DTU, Distribution Terminal Unit) and distribution transformer terminal (TTU, Transformer Terminal Unit). The distribution terminal 130 can be used to complete tasks such as data collection, control, and communication in the distribution network. The data collection task is mainly to collect various electrical parameters in the distribution network, such as electrical parameters such as voltage, current, and power. The control task is mainly to perform opening and closing operations on the switchgear to achieve fault identification and isolation of the feeder switch and restore power supply to the non-fault section. The communication task is mainly to exchange data with the data processing platform 120 through the communication interface to achieve remote monitoring and control. The feeder terminal is usually installed near the feeder switch to monitor outdoor pole switches, such as circuit breakers, load switches, and section switches. The station terminal is usually installed in locations such as switchgear, ring network cabinets, or small substations, collects data such as the location, voltage, and current of the switchgear, and performs fault identification and power restoration operations. The distribution transformer terminal usually monitors the operating conditions of the distribution transformer, records parameters such as voltage and current, and provides operating data and analysis basis for the data processing platform 120.

[0028] After acquiring the power grid operation data of the target power distribution terminal 130, the data processing platform 120 can execute the data processing task according to the power grid operation data and the task parameter information, generate the task execution result, and feed it back to the user terminal 110. Specifically, the data processing platform 120 can process the power grid operation data according to the task parameter information to complete the data processing task.

[0029] In a preferred solution, the task parameter information includes acquisition task parameters and processing task parameters;

[0030] The data processing platform 120 is further used to determine the collection task of the target power distribution terminal 130 according to the collection task parameters, and send the collection task matching the target power distribution terminal 130 to the target power distribution terminal 130;

[0031] The target power distribution terminal 130 is used to collect power grid operation data according to the collection task and send the power grid operation data to the data processing platform 120;

[0032] The data processing platform 120 is used to process the power grid operation data collected by the target power distribution terminal 130 according to the processing task parameters, generate a task execution result, and feed it back to the user terminal 110.

[0033] It is easy to understand that the data processing task may be a data processing task for real-time power grid operation data, or a data processing task with special requirements for power grid operation data. The task parameter information may include acquisition task parameters and processing task parameters, wherein the acquisition task parameters may be setting parameters for the power distribution terminal 130 to collect power grid operation data, for example, they may include parameters such as acquisition frequency, acquisition conditions, and data types collected. The processing task parameters may be setting parameters for the data processing task, for example, they may include parameters such as processing logic, calculation formula, and statistical view.

[0034] The data processing platform 120 can generate a collection task for the target power distribution terminal 130 according to the collection task parameters, and send the collection task matching the target power distribution terminal 130 to the target power distribution terminal 130. The collection task can be used to describe when and what type of power grid operation data the target power distribution terminal 130 collects. The target power distribution terminal 130 can collect power grid operation data according to the collection task, and send the power grid operation data obtained according to the collection task to the data processing platform 120. The data processing platform 120 can perform data processing on the power grid operation data collected by the target power distribution terminal 130 according to the processing task parameters, generate a task execution result, and feed it back to the user terminal 110.

[0035] This solution can set the collection tasks of the distribution terminal, improve the flexibility of power grid operation data collection, and help improve the efficiency of power grid operation data processing.

[0036] On the basis of the above solution, the data processing platform 120 is also used to perform content verification on the power grid operation data collected by the target power distribution terminal 130 and determine the content verification result;

[0037] If it is determined that the content verification is passed according to the content verification result, data processing is performed on the power grid operation data collected by the target distribution terminal 130 according to the processing task parameters, and a task execution result is generated and fed back to the user terminal 110.

[0038] In order to ensure the reliability of data processing, after receiving the power grid operation data collected by the target power distribution terminal 130, the data processing platform 120 can perform content verification on the power grid operation data to determine whether the power grid operation data collected by the target power distribution terminal 130 meets the requirements of the data processing task. The content verification result can be passed or failed. If the content verification passes, the data processing platform 120 can perform data processing on the power grid operation data collected by the target power distribution terminal 130 according to the processing task parameters to obtain the task execution result. If the content verification fails, the data processing platform 120 can determine the data content defects based on the power grid operation data collected by the target power distribution terminal 130, and then adjust the collection task parameters to re-acquire the power grid operation data that meets the requirements of the data processing task.

[0039] In a feasible solution, the data processing platform 120 is also used to obtain the operating status data of the power distribution terminal 130 in the target power grid according to a preset detection cycle, and update the power distribution terminal information registration table;

[0040] According to the power distribution terminal information registration table, the task operation interface matched by the user terminal 110 is refreshed.

[0041] The data processing platform 120 can detect the distribution terminal 130 in the target power grid according to the preset detection cycle, obtain the operating status data of the distribution terminal 130 in the target power grid, and use it to update the distribution terminal information registration table. Among them, the operating status data may include information such as whether the distribution terminal is online, whether it is normal, the cumulative online time, and the last online time. The data processing platform can set a distribution terminal information registration table to store the operating status data of the distribution terminal in the target power grid. When the user terminal 110 logs in, the data processing platform can refresh the task operation interface corresponding to the user terminal 110 according to the distribution terminal information registration table. For example, the distribution terminal A was running normally online in the last detection cycle, and is offline due to a fault in the current cycle. If the user terminal 110 is logged in online at the current moment, the data processing platform can delete the options involving the distribution terminal A in the task operation interface.

[0042] This solution can regularly monitor the operating status of the distribution terminal, which is conducive to timely discovering abnormalities of the distribution terminal, adjusting the data processing strategy, and ensuring the reliable and stable operation of the distribution network.

[0043] In this embodiment, the data processing platform 120 is further used to receive the power grid operation data sent by the power distribution terminal 130, and determine the software version screening result of the power distribution terminal 130 according to the power grid operation data;

[0044] The data processing platform 120 is further used to determine the power distribution terminal 130 to be optimized according to the software version screening result, and optimize the software version of the power distribution terminal 130 to be optimized based on a preset version optimization tool.

[0045] It is understandable that the software deployed in the distribution terminal 130 often needs to be upgraded regularly, and the data processing platform 120 can periodically upgrade the software version of the distribution terminal. In a feasible solution, the data processing platform can also determine whether the software version of the distribution terminal 130 needs to be upgraded and optimized based on the data attribute information such as the data format and data type of the power grid operation data when receiving the power grid operation data sent by the distribution terminal 130. For example, the previous version of software A saves the power grid operation data as a .txt file, and the latest version of software A saves the power grid operation data as a .CSV file. If the power grid operation data sent by the distribution terminal B is a .txt file, the data processing platform 120 can upgrade the version of software A in the distribution terminal B.

[0046] This solution can optimize the software of the distribution terminal in a timely and automatic manner, improving the management efficiency of the distribution terminal by the data processing platform.

[0047] The technical solution of the embodiment of the present invention is to obtain the operation information in the task operation interface matched by the user terminal through the user terminal, determine the distribution terminal information and the task parameter information according to the operation information, and send the distribution terminal information and the task parameter information to the data processing platform; receive the distribution terminal information and the task parameter information through the data processing platform, determine the target distribution terminal according to the distribution terminal information, and obtain the power grid operation data of the target distribution terminal; generate the task execution result according to the power grid operation data and the task parameter information through the data processing platform, and feed it back to the user terminal. This solution solves the problem of low processing efficiency of power grid operation data, and can improve the processing efficiency of power grid operation data while realizing the automated execution of different tasks, avoid manual intervention, and reduce the error rate.

[0048] Embodiment 2

[0049] Figure 2 It is a flowchart of a method for processing power grid operation data provided according to embodiment 2 of the present invention. This embodiment can be applicable to the management scenario of distribution terminals in the power system. The method can be executed by the processing system for power grid operation data provided by the embodiment of the present application. The processing system for power grid operation data includes a data processing platform, at least one distribution terminal and at least one user terminal.

[0050] like Figure 2 As shown, the method for processing power grid operation data includes:

[0051] S210, obtaining operation information in the task operation interface matched by the user terminal through the user terminal, determining the power distribution terminal information and the task parameter information according to the operation information, and sending the power distribution terminal information and the task parameter information to the data processing platform.

[0052] In this solution, the user terminal can be a business terminal of the power system staff, which can be a personal computer, smart phone, tablet computer and other devices. Different types of staff can have different task operation interfaces of their user terminals. The user can trigger the data processing platform to automatically execute the data processing tasks set by the user terminal by selecting, clicking and inputting on the task operation interface.

[0053] Specifically, the user terminal can detect the operation information in the task operation interface, such as the input location, input content and other information of the input operation. According to the user's operation information obtained in the task operation interface, the user terminal can extract the distribution terminal information and task parameter information. Among them, the distribution terminal information can be the description information of the distribution terminal involved in the data processing task, for example, it can include the name, number, type, deployment location, network address, affiliated plant and power supply station of the distribution terminal. The task parameter information can be the task description information of the data processing task, for example, it can include the range limit, time limit, processing logic and statistical tools of the data. The user terminal can send the distribution terminal information and task parameter information to the data processing platform, so that the data processing platform can perform the data processing task according to the distribution terminal information and task parameter information.

[0054] S220, receiving the power distribution terminal information and the task parameter information through the data processing platform, determining the target power distribution terminal according to the power distribution terminal information, and acquiring the power grid operation data of the target power distribution terminal.

[0055] The data processing platform can receive the distribution terminal information and task parameter information sent by the user terminal, determine the target distribution terminal according to the distribution terminal information, and obtain the power grid operation data of the target distribution terminal. The power grid operation data can be various electrical parameters in the distribution network. The distribution terminal can periodically collect the power grid operation data and store the power grid operation data collected in each period locally in the distribution terminal. The distribution terminal can also send the power grid operation data collected in each period to the data processing platform, and the database of the data processing platform manages the power grid operation data.

[0056] It can be understood that the distribution terminal can be various monitoring and control units installed in the distribution network, such as feeder terminals, station terminals, and distribution transformer terminals. The distribution terminal can be used to complete tasks such as data collection, control, and communication in the distribution network. The data collection task is mainly to collect various electrical parameters in the distribution network, such as voltage, current, and power. The control task is mainly to perform opening and closing operations on the switchgear to achieve fault identification and isolation of the feeder switch and restore power supply to the non-fault section. The communication task is mainly to exchange data with the data processing platform through the communication interface to achieve remote monitoring and control. The feeder terminal is usually installed near the feeder switch to monitor outdoor column switches, such as circuit breakers, load switches, and section switches. The station terminal is usually installed in locations such as switchgear, ring network cabinets, or small substations to collect data such as the location, voltage, and current of the switchgear, and perform fault identification and power restoration operations. The distribution transformer terminal usually monitors the operating conditions of the distribution transformer, records parameters such as voltage and current, and provides operating data and analysis basis for the data processing platform.

[0057] S230, generating a task execution result according to the power grid operation data and the task parameter information through a data processing platform, and feeding back the result to the user terminal.

[0058] After obtaining the grid operation data of the target distribution terminal, the data processing platform can execute the data processing task according to the grid operation data and task parameter information, generate the task execution result, and feed it back to the user terminal. Specifically, the data processing platform can process the grid operation data according to the task parameter information to complete the data processing task.

[0059] In a preferred solution, the task parameter information includes acquisition task parameters and processing task parameters;

[0060] The method further comprises:

[0061] Determine the collection task of the target power distribution terminal according to the collection task parameters through the data processing platform, and send the collection task matching the target power distribution terminal to the target power distribution terminal;

[0062] Collecting the power grid operation data according to the collection task through the target power distribution terminal, and sending the power grid operation data to the data processing platform;

[0063] The data processing platform processes the power grid operation data collected by the target distribution terminal according to the processing task parameters, generates task execution results, and feeds back to the user terminal.

[0064] It is easy to understand that the data processing task may be a data processing task for real-time power grid operation data, or a data processing task with special requirements for power grid operation data. Task parameter information may include acquisition task parameters and processing task parameters, wherein the acquisition task parameters may be setting parameters for the power distribution terminal to collect power grid operation data, for example, they may include parameters such as acquisition frequency, acquisition conditions, and data types collected. Processing task parameters may be setting parameters for data processing tasks, for example, they may include parameters such as processing logic, calculation formula, and statistical view.

[0065] The data processing platform can generate a collection task for the target distribution terminal according to the collection task parameters, and send the collection task matching the target distribution terminal to the target distribution terminal. The collection task can be used to describe when and what type of power grid operation data the target distribution terminal collects. The target distribution terminal can collect power grid operation data according to the collection task, and send the power grid operation data obtained according to the collection task to the data processing platform. The data processing platform can perform data processing on the power grid operation data collected by the target distribution terminal according to the processing task parameters, generate task execution results, and feed them back to the user terminal.

[0066] This solution can set the collection tasks of the distribution terminal, improve the flexibility of power grid operation data collection, and help improve the efficiency of power grid operation data processing.

[0067] On the basis of the above scheme, the data processing platform processes the power grid operation data collected by the target distribution terminal according to the processing task parameters, generates task execution results, and feeds back to the user terminal, including:

[0068] Conduct content verification on the power grid operation data collected by the target power distribution terminal and determine the content verification results;

[0069] If it is determined that the content verification has passed according to the content verification result, data processing is performed on the power grid operation data collected by the target distribution terminal according to the processing task parameters, and a task execution result is generated and fed back to the user terminal.

[0070] In order to ensure the reliability of data processing, after receiving the power grid operation data collected by the target power distribution terminal, the data processing platform can perform content verification on the power grid operation data to determine whether the power grid operation data collected by the target power distribution terminal meets the requirements of the data processing task. The content verification result can be passed or failed. If the content verification passes, the data processing platform can perform data processing on the power grid operation data collected by the target power distribution terminal according to the processing task parameters to obtain the task execution result. If the content verification fails, the data processing platform can determine the data content defects based on the power grid operation data collected by the target power distribution terminal, and then adjust the collection task parameters to re-acquire the power grid operation data that meets the requirements of the data processing task.

[0071] In a feasible solution, the method further includes:

[0072] Obtain the operating status data of the distribution terminals in the target power grid through the data processing platform according to the preset detection cycle, and update the distribution terminal information registration table;

[0073] According to the power distribution terminal information registration table, the task operation interface matched by the user terminal is refreshed.

[0074] The data processing platform can detect the distribution terminals in the target power grid according to the preset detection cycle, obtain the operating status data of the distribution terminals in the target power grid, and use it to update the distribution terminal information registration table. Among them, the operating status data may include information such as whether the distribution terminal is online, whether it is normal, the cumulative online time, and the last online time. The data processing platform can set up a distribution terminal information registration table to store the operating status data of the distribution terminals in the target power grid. When the user terminal logs in, the data processing platform can refresh the task operation interface corresponding to the user terminal according to the distribution terminal information registration table. For example, distribution terminal A was running online normally in the last detection cycle, and is offline due to a fault in the current cycle. If the user terminal is logged in online at the current moment, the data processing platform can delete the options involving distribution terminal A in the task operation interface.

[0075] This solution can regularly monitor the operating status of the distribution terminal, which is conducive to timely discovering abnormalities of the distribution terminal, adjusting the data processing strategy, and ensuring the reliable and stable operation of the distribution network.

[0076] In this embodiment, the method further includes:

[0077] Receiving the power grid operation data sent by the power distribution terminal through the data processing platform, and determining the software version screening result of the power distribution terminal according to the power grid operation data;

[0078] The data processing platform determines the power distribution terminal to be optimized according to the software version screening result, and optimizes the software version of the power distribution terminal to be optimized based on a preset version optimization tool.

[0079] It is understandable that the software deployed in the distribution terminal often needs to be upgraded regularly, and the data processing platform can periodically upgrade the software version of the distribution terminal. In a feasible solution, the data processing platform can also determine whether the software version of the distribution terminal needs to be upgraded and optimized based on the data attribute information such as the data format and data type of the power grid operation data when receiving the power grid operation data sent by the distribution terminal. For example, the previous version of software A saves the power grid operation data as a .txt file, and the latest version of software A saves the power grid operation data as a .CSV file. If the power grid operation data sent by distribution terminal B is a .txt file, the data processing platform can upgrade the version of software A in distribution terminal B.

[0080] This solution can optimize the software of the distribution terminal in a timely and automatic manner, improving the management efficiency of the distribution terminal by the data processing platform.

[0081] In a specific example, the data processing platform is a data processing platform built based on the Python language, which provides an input and output interface for the staff. According to the distribution terminal logic address and task parameter information input by the staff, combined with the system module operation sequence set in advance by the staff, it automatically obtains the current distribution terminal function verification process, automatically carries out background operations, and monitors the task execution status of different links in real time, and finally forms a real-time distribution terminal application scenario function verification status online dashboard. The specific execution steps are as follows:

[0082] Step 1: Initialize the software, load the UI file in the specified path to display the software interface, which includes the task distribution combo box, which contains the power supply unit drop-down selection box, the distribution terminal type drop-down selection box, the plant / user number input box, the plant / user name input box, the distribution terminal logical address input box, the distribution terminal asset number input box, the task selection drop-down selection box, and the process start button; the process monitoring box, including the power supply unit, power supply station, plant / user name, plant / user number, distribution terminal logical address, distribution terminal asset number, distribution terminal manufacturer, current execution process, execution status, failure reason analysis, and details query button; the comprehensive display combo box, including equipment Scenario function verification display box and equipment task process display box. The scenario function verification display box contains three labels: equipment distribution terminal category, online status, and task verification pass status. The task process display box contains three labels: task category, execution status, and manual verification ratio. The single device information combination box includes the equipment specific information box and the equipment task process box. The specific information box contains the distribution terminal software version, distribution terminal parameter information, collection task template, technical specification parameters, online status and message information. The task process box contains the task process flow chart. The export option combination box contains the data time setting box, the power supply unit drop-down selection box, the distribution terminal type drop-down selection box, and the export button.

[0083] Step 2: Respectively specify the contents of the drop-down boxes in the task distribution combo box and the power supply unit drop-down selection box in the export option combo box and the distribution terminal type drop-down selection box in step 1.

[0084] Step 3: Read the specified Excel configuration workbook, read the system permission table, distribution terminal information table, task content worksheet, message standard worksheet, and execution process worksheet data in the configuration workbook into the memory, and load the automated task process into the memory. The automated process includes six modules: version parameter screening, version parameter optimization, collection task distribution, message content verification, task process analysis, and distribution terminal operation monitoring.

[0085] Step 4: Read the specified storage database, read the device information labeled as process tracking in the database, load the information into the process monitoring combo box in step 1, load the corresponding information into the power supply unit, power supply station, plant / user name, plant / user number, distribution terminal logical address, distribution terminal asset number, distribution terminal manufacturer, current execution process, execution status, failure reason analysis, and open the details query button.

[0086] Step 5: Read the specified storage database, read the device information labeled as process tracking in the database, use Pandas to perform data statistics, classify the information according to the power supply unit, use Pycharts to count the distribution terminal category, online status, and task verification status, form a line chart, and load it into the device scenario function verification display box in the comprehensive display combo box in step 1; use Pycharts to count the task category, execution status, and manual verification ratio to form a discounted statistical chart, and load it into the task process display box in the comprehensive display combo box in step 1.

[0087] Step 6: Set the process start button click function in step 1 to read the distribution terminal information data, read the power supply unit drop-down selection box, distribution terminal type drop-down selection box, plant / user number input box, plant / user name input box, distribution terminal logical address input box, distribution terminal asset number input box, and task selection drop-down selection box in step 1 to obtain the power supply unit, distribution terminal type, plant / user number, plant / user name, distribution terminal logical address, distribution terminal asset number, and task template, and input them into the automation process.

[0088] Step 7: Set the detail query button click function in step 1 to read the task progress data, obtain the specified information row selected in the process monitoring combo box, obtain the power supply unit, power supply station, plant / user name, plant / user number, distribution terminal logical address, distribution terminal asset number, and input them into the task progress analysis module.

[0089] Step 8: The version parameter screening module uses Request to obtain the device software version, device parameter information, and upstream and downstream technical specifications based on the distribution terminal asset number and task template in step 7, traverses the task content worksheet, and uses Pandas to filter data. The distribution terminal information that does not meet the task template requirements is batch input into the version parameter optimization module, and the equipment that meets the requirements is batch input into the collection task delivery module.

[0090] Step 9: The version parameter optimization module uses the Playwright automation framework to batch optimize the distribution terminals according to the distribution terminal information output by the version parameter screening module. It automatically opens the browser, logs in to the business system, opens the specified function module, and remotely upgrades the distribution terminal version, issues remote debugging instructions for equipment parameters, and remotely modifies technical specification parameters according to the power supply unit, distribution terminal type, plant / user number, plant / user name, distribution terminal logical address, and distribution terminal asset number. It uses Selenium to obtain the execution results, and batch inputs the distribution terminal information with successful execution results into the collection task issuance module. At the same time, the execution information of all distribution terminals is sent to the task process analysis module.

[0091] Step 10: The task distribution module collects the distribution terminal information output by the version parameter screening module in step 9, sends the specified task template to the browser by submitting the task form, obtains the execution results by using Selenium, and inputs the distribution terminal information with successful execution results into the message content verification module in batches. At the same time, the execution information of all distribution terminals is sent to the task process analysis module.

[0092] Step 11: The message content verification module collects the distribution terminal information output by the task issuing module in step 10, matches the task template with the task content worksheet and the message standard worksheet to obtain the message sending time and message sending cycle, combines Abscheduler and Request for regular monitoring, and simplifies the message content in combination with the message standard worksheet to form parsed message content and message judgment results, which are input into the task process analysis module together with the distribution terminal information.

[0093] Step 12: The task process analysis module uses Pandas to integrate data based on the output content of the three modules in steps 9-11, and finally forms the power supply unit, distribution terminal type, plant / user number, plant / user name, distribution terminal logical address, distribution terminal asset number, task template, equipment software version, equipment parameter information, upstream and downstream technical specifications, message sending cycle, parsed message content, message judgment result, current task module, task execution status, and writes it into the database in the specified directory for data storage.

[0094] Step 13: When the distribution terminal operation monitoring module starts running, it reads the distribution terminal information stored in the database in the specified directory, crawls data using requests at regular intervals, updates the operating status of the distribution terminal, whether it is offline, and the last online time, and inputs the data acquisition results into the database for data update.

[0095] Step 14: The task process analysis module uses MySQL to obtain the task process information of the specified device in the database of the specified directory based on the power supply unit, power supply station, plant / user name, plant / user number, distribution terminal logical address, and distribution terminal asset number in step 7, and loads the corresponding information into the specific information box of the single device information combination box in step 1, including the distribution terminal software version, distribution terminal parameter information, collection task template, technical protocol parameters, online status, and message information; reads the task flow chart of the specified directory, loads it into the task process box in the device information combination box in step 1, and highlights the process according to the current task link of the specified device.

[0096] Step 15: Set the export button click function in step 1 to read the task progress information data, read the text content in the data time input box, power supply unit drop-down selection box, and distribution terminal type drop-down selection box in the export option combo box in step 1, use MySQL to read the database in the specified directory, obtain the task progress details of the specified data time, power supply unit, and distribution terminal type, generate an excel or csv file in the specified directory, and automatically open the file.

[0097] 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 described in the present invention 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 does not limit this.

[0098] The above specific implementations do not constitute a limitation on the protection scope of the present invention. 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 the present invention.

Claims

1. A system for processing power grid operation data, characterized in that: The power grid operation data processing system includes a data processing platform, at least one power distribution terminal and at least one user terminal; The user terminal is used to obtain operation information in the task operation interface matched by the user terminal, determine the power distribution terminal information and the task parameter information according to the operation information, and send the power distribution terminal information and the task parameter information to the data processing platform; The data processing platform is used to receive the power distribution terminal information and the task parameter information, determine the target power distribution terminal according to the power distribution terminal information, and obtain the power grid operation data of the target power distribution terminal; The data processing platform is used to generate task execution results according to the power grid operation data and the task parameter information, and feed back the results to the user terminal.

2. The system according to claim 1, characterized in that The task parameter information includes acquisition task parameters and processing task parameters; The data processing platform is further used to determine the collection task of the target power distribution terminal according to the collection task parameters, and send the collection task matching the target power distribution terminal to the target power distribution terminal; The target power distribution terminal is used to collect power grid operation data according to the collection task, and send the power grid operation data to the data processing platform; The data processing platform is used to process the power grid operation data collected by the target distribution terminal according to the processing task parameters, generate task execution results, and feed them back to the user terminal.

3. The system according to claim 2, characterized in that The data processing platform is also used to perform content verification on the power grid operation data collected by the target power distribution terminal and determine the content verification result; If it is determined that the content verification has passed according to the content verification result, data processing is performed on the power grid operation data collected by the target distribution terminal according to the processing task parameters, and a task execution result is generated and fed back to the user terminal.

4. The system according to claim 1, characterized in that The data processing platform is also used to obtain the operating status data of the power distribution terminal in the target power grid according to the preset detection cycle and update the power distribution terminal information registration table; According to the power distribution terminal information registration table, the task operation interface matched by the user terminal is refreshed.

5. The method according to claim 1, characterized in that The data processing platform is further used to receive the power grid operation data sent by the power distribution terminal, and determine the software version screening result of the power distribution terminal according to the power grid operation data; The data processing platform is also used to determine the power distribution terminal to be optimized according to the software version screening result, and optimize the software version of the power distribution terminal to be optimized based on a preset version optimization tool.

6. A method for processing power grid operation data, characterized in that: The method is performed by a processing system for power grid operation data, the processing system for power grid operation data comprising a data processing platform, at least one power distribution terminal and at least one user terminal; the method comprises: Acquire operation information in the task operation interface matched by the user terminal through the user terminal, determine the power distribution terminal information and the task parameter information according to the operation information, and send the power distribution terminal information and the task parameter information to the data processing platform; Receiving power distribution terminal information and task parameter information through a data processing platform, determining a target power distribution terminal according to the power distribution terminal information, and acquiring power grid operation data of the target power distribution terminal; The data processing platform generates the task execution result according to the power grid operation data and the task parameter information, and feeds back to the user terminal.

7. The method according to claim 6, characterized in that The task parameter information includes acquisition task parameters and processing task parameters; The method further comprises: Determine the collection task of the target power distribution terminal according to the collection task parameters through the data processing platform, and send the collection task matching the target power distribution terminal to the target power distribution terminal; Collecting the power grid operation data according to the collection task through the target power distribution terminal, and sending the power grid operation data to the data processing platform; The data processing platform processes the power grid operation data collected by the target distribution terminal according to the processing task parameters, generates task execution results, and feeds back to the user terminal.

8. The method according to claim 7, characterized in that The data processing platform processes the power grid operation data collected by the target power distribution terminal according to the processing task parameters, generates a task execution result, and feeds it back to the user terminal, including: Conduct content verification on the power grid operation data collected by the target power distribution terminal and determine the content verification results; If it is determined that the content verification has passed according to the content verification result, data processing is performed on the power grid operation data collected by the target distribution terminal according to the processing task parameters, and a task execution result is generated and fed back to the user terminal.

9. The method according to claim 6, characterized in that The method further comprises: Obtain the operating status data of the distribution terminals in the target power grid through the data processing platform according to the preset detection cycle, and update the distribution terminal information registration table; According to the power distribution terminal information registration table, the task operation interface matched by the user terminal is refreshed.

10. The method according to claim 6, characterized in that The method further comprises: Receiving the power grid operation data sent by the power distribution terminal through the data processing platform, and determining the software version screening result of the power distribution terminal according to the power grid operation data; The data processing platform determines the power distribution terminal to be optimized according to the software version screening result, and optimizes the software version of the power distribution terminal to be optimized based on a preset version optimization tool.

Images