Data management method and device for secondary equipment asset ledger, computer equipment, readable storage medium and program product

Abstract

The invention relates to a data management method and device for a secondary equipment asset ledger, computer equipment, a computer readable storage medium and a computer program product. The method comprises the following steps: obtaining to-be-verified secondary equipment asset ledger data; searching a data verification rule corresponding to the secondary equipment asset standing book data in a verification rule base; performing data verification processing on the secondary equipment asset ledger data based on a data verification algorithm corresponding to the data verification rule to obtain an abnormal data verification result and rectification suggestion information corresponding to each piece of verified abnormal data; and performing data governance processing on the abnormal data based on the rectification suggestion information to obtain a secondary equipment asset ledger data governance result. According to the invention, the accuracy of the secondary equipment asset ledger data can be effectively improved, and the safety and stability of a power system are improved.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a data management method, device, computer equipment, computer-readable storage medium and computer program product for secondary equipment asset ledgers. Background Art

[0002] In the power system, secondary equipment is an important device to ensure the safe and stable operation of the power system. It is mainly used to measure, control, monitor and protect the primary equipment of the power system. There are many types of secondary equipment, including measuring meters, control and signal devices, relay protection and automatic devices, backup automatic switching devices, etc. These devices are usually composed of power electronic devices, integrated circuits, microprocessors, etc., and have the characteristics of high precision, high reliability and intelligence. Secondary equipment plays a vital role in the power system, and its performance and reliability are directly related to the safe, stable and economical operation of the power system.

[0003] However, there are many problems with the current secondary equipment asset ledger, such as incomplete structure, incorrect equipment asset category, missing key equipment technical parameters, etc., which cannot effectively support secondary equipment operation analysis and status monitoring. The operation and maintenance status and operation risks of related equipment cannot be obtained, analyzed and predicted in a timely manner, which is not conducive to the implementation and arrangement of equipment transformation and investment plans, and affects the safety and stability of the power system. Summary of the invention

[0004] Based on this, it is necessary to provide a data governance method, device, computer equipment, computer-readable storage medium and computer program product for secondary equipment asset ledgers that can improve the safety and stability of the power system in response to the above-mentioned technical problems.

[0005] In the first aspect, the present application provides a data governance method for secondary equipment asset ledgers, including:

[0006] Obtain the secondary equipment asset ledger data to be verified;

[0007] In the verification rule library, searching for the data verification rules corresponding to the secondary equipment asset ledger data;

[0008] Performing data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data;

[0009] Based on the rectification suggestion information, data governance processing is performed on the abnormal data to obtain the secondary equipment asset ledger data governance result.

[0010] In one embodiment, the data verification rules include normative verification rules, integrity verification rules, and correctness verification rules;

[0011] The data verification algorithm corresponding to the data verification rule is used to perform data verification processing on the secondary equipment asset ledger data to obtain abnormal data verification results, including:

[0012] Based on the data verification algorithm corresponding to the normative verification rule, the secondary equipment asset ledger data is subjected to data normative verification processing to obtain normative abnormal data;

[0013] Performing data integrity verification on the secondary equipment asset ledger data based on a data verification algorithm corresponding to the integrity verification rule to obtain integrity abnormal data;

[0014] Performing data correctness verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the correctness verification rule to obtain correctness abnormal data;

[0015] The normative abnormal data, the integrity abnormal data and the correctness abnormal data are processed as a union to obtain an abnormal data verification result.

[0016] In one embodiment, the method further comprises:

[0017] Obtain secondary equipment data quality management requirements;

[0018] Based on the secondary equipment data quality management requirements, rule generation processing is performed to obtain various types of normative verification rules, integrity verification rules and correctness verification rules;

[0019] An algorithm solidification process is performed based on the normative verification rule, the integrity verification rule and the correctness verification rule to obtain a data verification algorithm.

[0020] In one embodiment, the data governance processing is performed on each abnormal data based on the rectification suggestion information to obtain the secondary equipment asset ledger data governance result including:

[0021] Generate an abnormal data display page based on the abnormal data verification result;

[0022] Based on the rectification suggestion information, data governance processing is performed on the various abnormal data to obtain a data governance preview result, and a data quality change preview page corresponding to the data governance preview result is generated;

[0023] Pushing the abnormal data display page and the data quality change preview page to the data review terminal;

[0024] When a rectification confirmation message is received from the data audit terminal, the secondary equipment asset ledger data is updated based on the data management preview result to obtain a secondary equipment asset ledger data management result.

[0025] In one embodiment, generating an abnormal data display page based on the abnormal data verification result and the rectification suggestion information includes:

[0026] Based on the abnormal data verification result, a chart generation process is performed to obtain an abnormal parameter statistical analysis chart and an abnormal parameter display list;

[0027] A visualization page generation process is performed based on the abnormal parameter statistical analysis chart and the abnormal parameter display list to obtain an abnormal data display page.

[0028] In one of the embodiments, it also includes: based on the secondary equipment asset ledger data management results, scoring each type of secondary equipment asset ledger data to obtain data management scores for different types of secondary equipment asset ledger data; generating a data management assessment ranking corresponding to the data management score; and pushing the data management assessment ranking.

[0029] In a second aspect, the present application also provides a data management device for secondary equipment asset ledgers, characterized in that the device includes:

[0030] The data acquisition module is used to obtain the secondary equipment asset ledger data to be verified;

[0031] A rule search module, used to search for data verification rules corresponding to the secondary equipment asset ledger data in a verification rule library;

[0032] A data verification module, used to perform data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data;

[0033] The data governance module is used to perform data governance processing on the various abnormal data based on the rectification suggestion information to obtain the secondary equipment asset ledger data governance results.

[0034] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0035] Obtain the secondary equipment asset ledger data to be verified;

[0036] In the verification rule library, searching for the data verification rules corresponding to the secondary equipment asset ledger data;

[0037] Performing data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data;

[0038] Based on the rectification suggestion information, data governance processing is performed on the abnormal data to obtain the secondary equipment asset ledger data governance result.

[0039] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:

[0040] Obtain the secondary equipment asset ledger data to be verified;

[0041] In the verification rule library, searching for the data verification rules corresponding to the secondary equipment asset ledger data;

[0042] Performing data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data;

[0043] Based on the rectification suggestion information, data governance processing is performed on the abnormal data to obtain the secondary equipment asset ledger data governance result.

[0044] In a fifth aspect, the present application further provides a computer program product, including a computer program, which implements the following steps when executed by a processor:

[0045] Obtain the secondary equipment asset ledger data to be verified;

[0046] In the verification rule library, searching for the data verification rules corresponding to the secondary equipment asset ledger data;

[0047] Performing data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data;

[0048] Based on the rectification suggestion information, data governance processing is performed on the abnormal data to obtain the secondary equipment asset ledger data governance result.

[0049] The above-mentioned data governance method, device, computer equipment, computer-readable storage medium and computer program product for the secondary equipment asset ledger, after obtaining the secondary equipment asset ledger data to be verified; in the verification rule library, search for the data verification rules corresponding to the secondary equipment asset ledger data; based on the data verification algorithm corresponding to the data verification rule, perform data verification processing on the secondary equipment asset ledger data to obtain abnormal data verification results, and the abnormal data verification results at least include the verified abnormal data, and the corresponding rectification suggestion information of each abnormal data; based on the rectification suggestion information, perform data governance processing on each abnormal data to obtain the secondary equipment asset ledger data governance result. The present application sets special verification rules for the secondary equipment asset ledger, and then performs data verification and data governance processing based on these verification rules, so as to rectify the abnormal data in the secondary equipment asset ledger, effectively improve the accuracy of the secondary equipment asset ledger data, and then improve the safety and stability of the power system. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0051] Figure 1 This is an application environment diagram of a data management method for secondary equipment asset ledgers in one embodiment;

[0052] Figure 2 It is a flowchart of a data management method for secondary equipment asset ledger in one embodiment;

[0053] Figure 3 A schematic diagram of the many problems existing in the secondary equipment asset ledger in one embodiment;

[0054] Figure 4 A schematic diagram of a process for visually displaying abnormal data in one embodiment;

[0055] Figure 5 A schematic diagram of the principle of a secondary equipment data quality management system in one embodiment;

[0056] Figure 6 It is a structural block diagram of a data management device for secondary equipment asset ledger in one embodiment;

[0057] Figure 7 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0058] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0059] The data management method for secondary equipment asset ledger provided in the embodiment of the present application can be applied to Figure 1 In the application environment shown. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. When the data operation and maintenance personnel of the terminal 102 party want to process the collected data related to the secondary equipment asset ledger, the data governance method for the secondary equipment asset ledger of this application can be used for data governance. The data operation and maintenance personnel submit a corresponding processing request to the server 104 through the terminal 102, and the server 104 obtains the secondary equipment asset ledger data to be verified according to the processing request; in the verification rule library, the data verification rules corresponding to the secondary equipment asset ledger data are searched; based on the data verification algorithm corresponding to the data verification rule, the secondary equipment asset ledger data is subjected to data verification processing to obtain abnormal data verification results, and the abnormal data verification results at least include the verified abnormal data, and the rectification suggestion information corresponding to each abnormal data; based on the rectification suggestion information, the abnormal data is subjected to data governance processing to obtain the secondary equipment asset ledger data governance result. The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, IoT devices, and portable wearable devices. The IoT devices may be smart speakers, smart TVs, smart air conditioners, smart car devices, projection devices, etc. Portable wearable devices may be smart watches, smart bracelets, head-mounted devices, etc. Head-mounted devices may be virtual reality (VR) devices, augmented reality (AR) devices, smart glasses, etc. The server 104 may be an independent physical server, a server cluster or distributed system consisting of multiple physical servers, or a cloud server that provides cloud computing services.

[0060] In an exemplary embodiment, Figure 2 As shown in the figure, a data governance method for secondary equipment asset ledger is provided, which is applied to Figure 1 The server 104 in the example is used as an example to illustrate, including the following steps 201 to 207. Among them:

[0061] Step 201, obtaining the secondary equipment asset ledger data to be verified.

[0062] Step 203, searching the verification rule library for data verification rules corresponding to the secondary equipment asset ledger data.

[0063] Among them, the secondary equipment asset ledger data refers to the asset ledger data of secondary equipment. In the power system, secondary equipment is an important equipment to ensure the safe and stable operation of the power system, including relay protection devices, automation equipment, communication equipment, etc. ‌The asset ledger is a detailed record table used to record and manage the asset information of the enterprise. ‌It includes fixed asset ledgers and equipment ledgers, etc., which are used to record detailed information of fixed assets and equipment respectively. ‌The verification rule library is a pre-established database for storing various types of data verification rules, such as normative verification rules, integrity verification rules and correctness verification rules and the data verification algorithms corresponding to these rules. These rules can verify the secondary equipment asset ledger data to be verified from the perspectives of standard manufacturer verification, equipment category verification, equipment name verification, parameter mandatory item verification, etc., to determine abnormal data.

[0064] For example, in the power system, secondary equipment is important equipment to ensure the safe and stable operation of the power system, including relay protection devices, automation equipment, communication equipment, etc. Figure 3 As shown, there are many problems with the secondary equipment asset ledger at present, such as incomplete structure, wrong equipment asset category, missing key equipment technical parameters, etc., which cannot effectively support the operation analysis and status monitoring of secondary equipment. Therefore, before performing data analysis on these secondary equipment asset ledger data, data governance is required to ensure the availability of data. Therefore, the terminal 102 can submit a corresponding data governance request to the server 104 and specify the secondary equipment asset ledger data to be verified. The server 104 first obtains the secondary equipment asset ledger data to be verified. Then, from the verification rule library, the data verification rules corresponding to the secondary equipment asset ledger data are searched. Different secondary equipment asset ledger data correspond to different secondary equipments. When performing data verification processing, data verification rules can be searched based on the specific type of secondary equipment. In one embodiment, the newly added secondary equipment asset ledger data can be collected by periodic governance. When the governance time node is reached, the incremental secondary equipment asset ledger data generated between the previous time node and the current time node is used as the data to be verified, and then the verification processing is performed.

[0065] Step 205, based on the data verification algorithm corresponding to the data verification rule, the secondary equipment asset ledger data is subjected to data verification processing to obtain abnormal data verification results, which at least include the verified abnormal data and the rectification suggestion information corresponding to each abnormal data.

[0066] Among them, the data verification algorithm mainly solidifies various data verification rules through digital means. The data verification algorithm can intelligently identify abnormal data quality parameters of each secondary device and give rectification suggestions for the abnormal parameters.

[0067] Exemplarily, different secondary equipment asset ledger data correspond to different secondary equipment, and when performing data verification processing, the secondary equipment asset ledger data of different equipment. The corresponding data verification rules and data verification algorithms can be determined first, and then the data verification algorithm is used to perform data verification processing on the secondary equipment asset ledger data. In a specific embodiment, the values ​​of various equipment parameters including voltage level parameters belong to a fixed range, such as the voltage level parameter should belong to one of the ranges of 800kV, 500kV, 220kV, and 110kV. If the parameter value is empty or not within the enumeration range, the abnormal data verification result corresponding to the parameter can be obtained through data verification processing, and reminder information is listed, including the path information, manufacturer, model, maintenance team, verification error cause, etc. of the secondary equipment. Thereby, the abnormal data quality parameters of each secondary equipment are identified, and rectification suggestions are given for the abnormal parameters.

[0068] Step 207, based on the rectification suggestion information, data governance processing is performed on each abnormal data to obtain the secondary equipment asset ledger data governance result.

[0069] Exemplarily, after obtaining the abnormal data verification results and the rectification suggestion information corresponding to each abnormal data verified, these abnormal data can be modified through the rectification suggestion information, and rectification suggestion information can be automatically generated by providing data rectification tools, so as to perform data governance processing on each abnormal data and obtain the secondary equipment asset ledger data governance results. Since rectification suggestion information is given, the present application scheme also supports manual modification of secondary equipment asset ledger data. Operation and maintenance personnel can manually modify the identified abnormal data based on the rectification suggestion information to ensure data accuracy.

[0070] The above-mentioned data governance method for the secondary equipment asset ledger is as follows: after obtaining the secondary equipment asset ledger data to be verified; in the verification rule library, the data verification rules corresponding to the secondary equipment asset ledger data are searched; based on the data verification algorithm corresponding to the data verification rule, the secondary equipment asset ledger data is subjected to data verification processing to obtain abnormal data verification results, and the abnormal data verification results at least include the verified abnormal data, and the rectification suggestion information corresponding to each abnormal data; based on the rectification suggestion information, data governance processing is performed on each abnormal data to obtain the secondary equipment asset ledger data governance result. The present application sets special verification rules for the secondary equipment asset ledger, and then performs data verification and data governance processing based on these verification rules, so as to rectify the abnormal data in the secondary equipment asset ledger, effectively improve the accuracy of the secondary equipment asset ledger data, and then improve the safety and stability of the power system.

[0071] In an exemplary embodiment, Figure 3 As shown, step A includes step 302 to step 306. Among them:

[0072] In one embodiment, the data verification rules include normative verification rules, integrity verification rules, and correctness verification rules. Step 205 includes: performing data normative verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the normative verification rule to obtain normative abnormal data; performing data integrity verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the integrity verification rule to obtain integrity abnormal data; performing data correctness verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the correctness verification rule to obtain correctness abnormal data; performing union processing on the normative abnormal data, the integrity abnormal data, and the correctness abnormal data to obtain the abnormal data verification result.

[0073] Exemplarily, the normative verification rules, integrity verification rules and correctness verification rules are verification rules set from the perspectives of normativeness, integrity, correctness, etc. These three rules can be used to identify and judge whether the data is abnormal from the perspectives of normativeness, integrity, correctness, etc., and then obtain the corresponding verification results. In a more specific embodiment, through the normative verification rules, integrity verification rules and correctness verification rules, multi-dimensional verification rules for secondary equipment asset ledger parameters can be constructed, that is, standard manufacturer verification, equipment category verification, equipment name verification, parameter mandatory verification, parameter enumeration value verification and other verification rules are constructed. For the normative verification rules, standard manufacturer verification rules, equipment category verification rules, equipment name verification rules, and parameter enumeration value verification rules for its sub-items can be constructed. For the integrity verification rules, standard manufacturer verification rules and parameter mandatory verification rules for its sub-items can be constructed. For the correctness verification rules, standard manufacturer verification rules, equipment category verification rules, equipment name verification rules, and parameter enumeration value verification rules for its sub-items can be constructed. Then, by verifying these rules, the abnormal data identified and judged by each rule can be obtained. Since one abnormal data may trigger multiple rules, the normative abnormal data, the integrity abnormal data and the correctness abnormal data can be processed together to obtain the abnormal data verification result. In this embodiment, the secondary equipment asset ledger data is verified from different angles through the normative verification rules, the integrity verification rules and the correctness verification rules, so as to effectively ensure the accuracy of abnormal data identification and effectively avoid missed detection.

[0074] In an exemplary embodiment, the method also includes: obtaining secondary equipment data quality management requirements; performing rule generation processing based on the secondary equipment data quality management requirements to obtain various types of normative verification rules, integrity verification rules, and correctness verification rules; performing algorithm solidification processing based on the normative verification rules, integrity verification rules, and correctness verification rules to obtain a data verification algorithm.

[0075] Exemplarily, the present application also includes a process of rule generation and algorithm solidification processing, which is used to fill the rule database. First, the data quality management requirements corresponding to the secondary equipment to be managed can be collected. Then, based on this information, the rule refinement processing is carried out, and the rule generation processing is carried out in combination with the principles of standardization, integrity and correctness. Generate the sub-rules of the standard verification rules, integrity verification rules and correctness verification rules, and save them in the corresponding sub-rule database. For the problems of non-standard manufacturers, a standard manufacturer verification rule library is established; for the problems of non-standard parameter values, a parameter enumeration value verification rule library is established; for the problems of mandatory requirements but empty types, a mandatory item verification rule library is established. And various sub-rule libraries can be revised based on the newly generated rules. Through the rule generation processing, various types of standard verification rules, integrity verification rules and correctness verification rules can be obtained. After that, the verification rules can be solidified into an effective data verification algorithm through digital means, so as to intelligently identify the abnormal data quality parameters of each secondary device. In this embodiment, various types of data verification rules and their corresponding data verification algorithms are obtained through rule generation and algorithm solidification processing, so that abnormal data can be identified and processed through rules and algorithms, which can effectively ensure the efficiency and accuracy of abnormal data identification.

[0076] In an exemplary embodiment, Figure 4 As shown, step 207 includes:

[0077] Step 401: Generate an abnormal data display page based on the abnormal data verification result.

[0078] Step 403: Perform data governance processing on each abnormal data based on the rectification suggestion information, obtain a data governance preview result, and generate a data quality change preview page corresponding to the data governance preview result.

[0079] Step 405: Push the abnormal data display page and the data quality change preview page to the data review terminal.

[0080] Step 407, when receiving the rectification confirmation message from the data review terminal, the secondary equipment asset ledger data is updated based on the data management preview result to obtain the secondary equipment asset ledger data management result.

[0081] Exemplarily, for the process of data governance, the identified abnormal data and the results of data governance can be previewed and displayed in a visual display manner. For the abnormal data verification results obtained by verification, the abnormal data display page corresponding to the result can be directly generated, so as to display the various types of abnormal data currently identified to the operation and maintenance personnel. For the process of data governance, the abnormal data of this part can be taken out first, and then data governance can be performed, and these abnormal data can be corrected to obtain the data governance results corresponding to the abnormal data, and then the data quality change preview page corresponding to the data governance preview result can be generated. Then the abnormal data display page and the data quality change preview page are sent to the data audit terminal, and the operation and maintenance personnel of the data audit terminal will conduct the final confirmation processing on these data. If the confirmation is correct, the corresponding rectification confirmation message can be fed back. The server responsible for data governance can update the secondary equipment asset ledger data according to the received rectification confirmation message, update the original abnormal data to the normal number after governance, and obtain the corresponding secondary equipment asset ledger data governance results. In one of the embodiments, for the process of data visualization display, a chart generation process can be performed based on the abnormal data verification results to obtain an abnormal parameter statistical analysis chart and an abnormal parameter display list; a visualization page generation process can be performed based on the abnormal parameter statistical analysis chart and the abnormal parameter display list to obtain an abnormal data display page. Through the analysis chart and the display list, various types of abnormal data existing before correction can be intuitively displayed, including the path information, manufacturer, model, maintenance team, verification error cause, etc. of the secondary equipment. In this embodiment, the visualization display of the abnormal data verification results and the data governance preview results is realized, thereby effectively reducing the burden of the operation and maintenance team in carrying out the secondary equipment data quality rectification work through data display.

[0082] In an exemplary embodiment, it also includes: based on the secondary equipment asset ledger data management results, scoring each type of secondary equipment asset ledger data to obtain data management scores for different types of secondary equipment asset ledger data; generating a data management assessment ranking corresponding to the data management score; and pushing the data management assessment ranking.

[0083] Exemplarily, the scheme of the present application also includes a visual tracking and assessment processing process. Based on the secondary equipment asset ledger data governance results, each type of secondary equipment asset ledger data is scored and processed to obtain data governance scores for different types of secondary equipment asset ledger data; and a data governance assessment ranking corresponding to the data governance score is generated; and the data governance assessment ranking is pushed. The secondary equipment asset ledger is evaluated through ranking, so as to display and track the quality of the secondary equipment data. In this embodiment, based on the intelligently identified abnormal data and the rectified abnormal data, a visual abnormal data tracking analysis and secondary equipment data quality assessment ranking are formed through assessment rules, so as to clearly grasp the progress of secondary equipment data quality rectification from the management perspective and the team perspective, and effectively urge the operation and maintenance personnel responsible for data management to do a good job in secondary equipment data quality rectification.

[0084] In one embodiment, a corresponding secondary equipment data quality management system can be constructed based on the data management method for secondary equipment asset ledger of this application to achieve data management. The principle of the secondary equipment data quality management system can be specifically referred to Figure 5 As shown, first obtain the secondary equipment asset ledger data to be verified as the basic data, and then set the verification rule base and various data management rules in each rule sub-base based on the verification principles such as normative verification, integrity verification and correctness verification. The data verification algorithm corresponding to the data verification rule is used to verify the secondary equipment asset ledger data, and the abnormal data verification result and the rectification suggestion information corresponding to each abnormal data verified are obtained; the abnormal data display page is generated based on the abnormal data verification result; the data governance of each abnormal data is performed based on the rectification suggestion information to obtain the data governance preview result, and the data quality change preview page corresponding to the data governance preview result is generated; the abnormal data display page and the data quality change preview page are pushed to the data audit terminal; when the rectification confirmation message of the data audit terminal is received, the secondary equipment asset ledger data is updated based on the data governance preview result to obtain the secondary equipment asset ledger data governance result. At the same time, the assessment and scoring can also be performed based on the basic data and the final governance result. At the same time, the secondary equipment data quality management system can also be integrated into the power grid management platform system as a subsystem to realize the automation of the verification process, real-time monitoring, and intelligent rectification. The system should support remote access and mobile access to facilitate users to operate anytime and anywhere.

[0085] It should be understood that, although the steps in the flowcharts involved in the above embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps is not strictly limited in order, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above embodiments may include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0086] Based on the same inventive concept, the embodiment of the present application also provides a data management device for secondary equipment asset ledgers for implementing the data management method for secondary equipment asset ledgers involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in one or more data management device embodiments for secondary equipment asset ledgers provided below can be referred to the limitations of the data management method for secondary equipment asset ledgers above, and will not be repeated here.

[0087] In an exemplary embodiment, Figure 6 As shown, a data management device for secondary equipment asset ledger is provided, including:

[0088] The data acquisition module 601 is used to acquire the secondary equipment asset ledger data to be verified.

[0089] The rule search module 603 is used to search for data verification rules corresponding to the secondary equipment asset ledger data in the verification rule library.

[0090] The data verification module 605 is used to perform data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, which at least include the verified abnormal data and the rectification suggestion information corresponding to each abnormal data.

[0091] The data governance module 607 is used to perform data governance processing on various abnormal data based on the rectification suggestion information to obtain the secondary equipment asset ledger data governance results.

[0092] In one embodiment, the data verification rules include normative verification rules, integrity verification rules and correctness verification rules; the data verification module 605 is specifically used to: perform data normative verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the normative verification rules to obtain normative abnormal data; perform data integrity verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the integrity verification rules to obtain integrity abnormal data; perform data correctness verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the correctness verification rules to obtain correctness abnormal data; perform union processing on the normative abnormal data, integrity abnormal data and correctness abnormal data to obtain the abnormal data verification result.

[0093] In one embodiment, it also includes a rule base generation module, which is used to: obtain secondary equipment data quality management requirements; perform rule generation processing based on the secondary equipment data quality management requirements to obtain various types of normative verification rules, integrity verification rules and correctness verification rules; perform algorithm solidification processing based on the normative verification rules, integrity verification rules and correctness verification rules to obtain a data verification algorithm.

[0094] In one embodiment, the data governance module 607 is specifically used to: generate an abnormal data display page based on the abnormal data verification result; perform data governance processing on each abnormal data based on the rectification suggestion information to obtain the data governance preview result, and generate a data quality change preview page corresponding to the data governance preview result; push the abnormal data display page and the data quality change preview page to the data review terminal; when receiving the rectification confirmation message from the data review terminal, update the secondary equipment asset ledger data based on the data governance preview result to obtain the secondary equipment asset ledger data governance result.

[0095] In one embodiment, the data governance module 607 is also used to: generate charts based on the abnormal data verification results to obtain abnormal parameter statistical analysis charts and abnormal parameter display lists; generate visualization pages based on the abnormal parameter statistical analysis charts and abnormal parameter display lists to obtain abnormal data display pages.

[0096] In one embodiment, it also includes an assessment ranking module, which is used to: score and process various types of secondary equipment asset ledger data based on the secondary equipment asset ledger data management results to obtain data management scores for different types of secondary equipment asset ledger data; generate data management assessment rankings corresponding to the data management scores; and push the data management assessment rankings.

[0097] Each module in the above-mentioned data management device for secondary equipment asset ledger can be implemented in whole or in part by software, hardware and their combination. Each of the above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the corresponding operations of each of the above modules.

[0098] In an exemplary embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. Figure 7 As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. Among them, the processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data management data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a data management method for a secondary equipment asset ledger is implemented.

[0099] Those skilled in the art will understand that Figure 7 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0100] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0101] In one embodiment, a computer-readable storage medium is provided, storing a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0102] In one embodiment, a computer program product or computer program is provided, the computer program product or computer program includes computer instructions, the computer instructions are stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps in the above-mentioned method embodiments.

[0103] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0104] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0105] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0106] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A data management method for secondary equipment asset ledger, characterized in that: The method comprises: Obtain the secondary equipment asset ledger data to be verified; In the verification rule library, searching for the data verification rules corresponding to the secondary equipment asset ledger data; Performing data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data; Based on the rectification suggestion information, data governance processing is performed on the abnormal data to obtain the secondary equipment asset ledger data governance result.

2. The method according to claim 1, characterized in that The data verification rules include standardization verification rules, integrity verification rules and correctness verification rules; The data verification algorithm corresponding to the data verification rule is used to perform data verification processing on the secondary equipment asset ledger data to obtain abnormal data verification results, including: Based on the data verification algorithm corresponding to the normative verification rule, the secondary equipment asset ledger data is subjected to data normative verification processing to obtain normative abnormal data; Performing data integrity verification on the secondary equipment asset ledger data based on a data verification algorithm corresponding to the integrity verification rule to obtain integrity abnormal data; Performing data correctness verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the correctness verification rule to obtain correctness abnormal data; The normative abnormal data, the integrity abnormal data and the correctness abnormal data are processed as a union to obtain an abnormal data verification result.

3. The method according to claim 1, characterized in that The method further comprises: Obtain secondary equipment data quality management requirements; Based on the secondary equipment data quality management requirements, rule generation processing is performed to obtain various types of normative verification rules, integrity verification rules and correctness verification rules; An algorithm solidification process is performed based on the normative verification rule, the integrity verification rule and the correctness verification rule to obtain a data verification algorithm.

4. The method according to claim 1, characterized in that: The data governance processing of each abnormal data based on the rectification suggestion information is performed to obtain the secondary equipment asset ledger data governance results including: Generate an abnormal data display page based on the abnormal data verification result; Based on the rectification suggestion information, data governance processing is performed on the various abnormal data to obtain a data governance preview result, and a data quality change preview page corresponding to the data governance preview result is generated; Pushing the abnormal data display page and the data quality change preview page to the data review terminal; When a rectification confirmation message is received from the data audit terminal, the secondary equipment asset ledger data is updated based on the data management preview result to obtain a secondary equipment asset ledger data management result.

5. The method according to claim 4, characterized in that Generating an abnormal data display page based on the abnormal data verification result includes: Based on the abnormal data verification result, a chart generation process is performed to obtain an abnormal parameter statistical analysis chart and an abnormal parameter display list; A visualization page generation process is performed based on the abnormal parameter statistical analysis chart and the abnormal parameter display list to obtain an abnormal data display page.

6. The method according to any one of claims 1 to 5, characterized in that: Also includes: Based on the secondary equipment asset ledger data management results, scoring and processing are performed on various types of secondary equipment asset ledger data to obtain data management scores for different types of secondary equipment asset ledger data; Generate a data governance assessment ranking corresponding to the data governance score; Push the data governance assessment ranking.

7. A data management device for secondary equipment asset ledger, characterized in that: The device comprises: The data acquisition module is used to obtain the secondary equipment asset ledger data to be verified; A rule search module, used to search for data verification rules corresponding to the secondary equipment asset ledger data in a verification rule library; A data verification module, used to perform data verification processing on the secondary equipment asset ledger data based on the data verification algorithm corresponding to the data verification rule to obtain abnormal data verification results, wherein the abnormal data verification results at least include various abnormal data verified and rectification suggestion information corresponding to each abnormal data; The data governance module is used to perform data governance processing on the various abnormal data based on the rectification suggestion information to obtain the secondary equipment asset ledger data governance results.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images