CN113379275A - Data management method, system, equipment and storage medium based on electric energy - Google Patents
Data management method, system, equipment and storage medium based on electric energy Download PDFInfo
- Publication number
- CN113379275A CN113379275A CN202110694301.9A CN202110694301A CN113379275A CN 113379275 A CN113379275 A CN 113379275A CN 202110694301 A CN202110694301 A CN 202110694301A CN 113379275 A CN113379275 A CN 113379275A
- Authority
- CN
- China
- Prior art keywords
- analysis
- electric energy
- data
- preset
- rule
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000013523 data management Methods 0.000 title claims abstract description 39
- 238000004458 analytical method Methods 0.000 claims abstract description 149
- 230000002159 abnormal effect Effects 0.000 claims abstract description 52
- 238000012545 processing Methods 0.000 claims abstract description 17
- 238000004140 cleaning Methods 0.000 claims description 51
- 238000012795 verification Methods 0.000 claims description 38
- 238000012163 sequencing technique Methods 0.000 claims description 10
- 230000005856 abnormality Effects 0.000 claims description 7
- 239000000126 substance Substances 0.000 claims description 2
- 238000010276 construction Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000013528 artificial neural network Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000005284 excitation Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000007723 transport mechanism Effects 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 238000005406 washing Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06395—Quality analysis or management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/80—Management or planning
- Y02P90/82—Energy audits or management systems therefor
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Databases & Information Systems (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Educational Administration (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Health & Medical Sciences (AREA)
- Game Theory and Decision Science (AREA)
- Computer Security & Cryptography (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Probability & Statistics with Applications (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data management method, a system, equipment and a storage medium based on electric energy, wherein the data management method based on the electric energy comprises the following steps: receiving an analysis instruction, and acquiring electric energy data of a power supply unit according to the analysis instruction; determining a corresponding abnormal analysis rule according to the data attribute of the electric energy data and a preset analysis rule database, wherein the preset analysis rule database comprises matching information of the data attribute and the abnormal analysis rule; and carrying out anomaly analysis on the electric energy data according to the anomaly analysis rule to obtain an analysis result. According to the invention, after the processing module determines the corresponding abnormal analysis rule according to the data attribute of the electric energy data and the preset analysis rule database, the abnormal analysis module can perform abnormal analysis on the electric energy data according to the abnormal analysis rule to obtain an analysis result, so that the quality analysis of the electric energy data is realized, and relevant personnel can know the quality of the electric energy data according to the analysis result.
Description
Technical Field
The present invention relates to the field of data management technologies, and in particular, to a method, a system, a device, and a storage medium for data management based on electrical energy.
Background
In order to meet the requirements of 'full coverage and full collection' of an electric energy metering and collecting system of the south network company, a perfect electric energy information data platform is constructed, and full coverage of collection of all levels of electric energy gateways of power supply companies in various cities of the whole province is achieved. In the construction process, the combination of inheritance and development and the combination of practicability and foresight are emphasized, the actual conditions of the dispatches and the local dispatches are comprehensively considered, the existing resources are effectively integrated and fully utilized, the construction cost is reduced, and the construction risk is reduced; under the overall arrangement of provincial companies, data of the full-provincial electric energy metering system are uniformly brought into a dispatching system platform for management in a data integration mode, and the system construction and application are strived to obtain actual effects.
In the related art, the electric energy data of the whole province is collected uniformly through a system platform, however, the quality of the electric energy data is not analyzed, some electric energy data which are repeatedly collected, unrelated and incomplete can be directly processed, the control and processing according to the electric energy data with quality problems are inaccurate, and related users cannot clearly determine the quality condition of the electric energy data.
Disclosure of Invention
The present invention is directed to solving at least one of the problems of the prior art. Therefore, the invention provides a data management method based on electric energy, which can perform quality analysis on the electric energy data to output an analysis result so that related personnel can know the quality condition of the electric energy data.
The invention also provides a data management system based on the electric energy.
The invention also provides the electronic control equipment.
The invention also provides a computer readable storage medium.
In a first aspect, an embodiment of the present invention provides a method for data management based on electrical energy, including:
receiving an analysis instruction, and acquiring electric energy data of a power supply unit according to the analysis instruction;
determining a corresponding abnormal analysis rule according to the data attribute of the electric energy data and a preset analysis rule database, wherein the preset analysis rule database comprises matching information of the data attribute and the abnormal analysis rule;
and carrying out anomaly analysis on the electric energy data according to the anomaly analysis rule to obtain an analysis result.
The data management method based on the electric energy of the embodiment of the invention at least has the following beneficial effects: after the processing module determines the corresponding abnormal analysis rule according to the data attribute of the electric energy data and the preset analysis rule database, the abnormal analysis module can perform abnormal analysis on the electric energy data according to the abnormal analysis rule to obtain an analysis result, so that the quality analysis of the electric energy data is realized, and relevant personnel can know the quality of the electric energy data according to the analysis result.
According to further embodiments of the present invention, the method for electrical energy-based data management, the anomaly analysis rule includes: cleaning standards and check rules; the preset analysis rule database includes:
a preset cleaning rule base, wherein the preset cleaning rule base comprises matching information of the data attribute and the cleaning standard;
and/or the presence of a gas in the gas,
and presetting a check rule base, wherein the preset check rule base comprises the data attribute and the matching information of the check rule.
According to other embodiments of the present invention, a method for managing data based on electric energy, which performs an anomaly analysis on the electric energy data according to the anomaly analysis rule to obtain an analysis result, includes:
performing data cleaning on the electric energy data according to the cleaning standard to obtain a cleaning result;
and verifying the electric energy data according to the verification rule to obtain a verification result.
According to further embodiments of the present invention, a method for data management based on electrical energy, further comprises:
determining a corresponding sorting grade according to the analysis result and a preset grade database, wherein the preset grade database comprises matching information of the analysis result and the sorting grade;
and displaying the power supply units according to the sorting level.
According to still further embodiments of the present invention, the preset level database includes:
a first scoring rule base, wherein the first scoring rule base comprises matching information of the cleaning result and a first score;
the second scoring rule base comprises matching information of the verification result and a second score;
a rank database comprising anomaly scores and match information for the ranked ranks.
According to another embodiment of the present invention, a method for managing data based on electric energy, wherein the determining a corresponding ranking level according to the analysis result and a preset ranking database includes:
determining a first score corresponding to the cleaning result according to the cleaning result and a preset first scoring rule base;
determining a second score corresponding to the verification result according to the verification result and a preset second scoring rule base;
determining an abnormal score according to the first score, the second score, a preset first weight and a preset second weight;
and determining a sorting grade corresponding to the abnormal score according to the abnormal score and the grade database.
According to further embodiments of the present invention, a method for data management based on electrical energy, further comprises:
acquiring a report generation instruction;
and matching the power supply unit with the sequencing grade according to the report generation instruction to generate a ranking report.
In a second aspect, an embodiment of the present invention provides an electrical energy-based data management system, including:
the receiving module is used for receiving an analysis instruction;
the acquisition module is used for acquiring the electric energy data of a power supply unit according to the analysis instruction;
the processing module is used for determining a corresponding abnormal analysis rule according to a data attribute of the electric energy data and a preset analysis rule database, and the preset analysis rule database comprises matching information of the data attribute and the abnormal analysis rule;
and the abnormality analysis module is used for carrying out abnormality analysis on the electric energy data according to the abnormality analysis rule so as to obtain an analysis result.
The data management system based on the electric energy of the embodiment of the invention at least has the following beneficial effects: after the processing module determines the corresponding abnormal analysis rule according to the data attribute of the electric energy data and the preset analysis rule database, the abnormal analysis module can perform abnormal analysis on the electric energy data according to the abnormal analysis rule to obtain an analysis result, so that the quality analysis of the electric energy data is realized, and relevant personnel can know the quality of the electric energy data according to the analysis result.
In a third aspect, an embodiment of the present invention provides an electronic control apparatus including:
at least one processor, and,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform a method of electrical energy-based data management as in the first aspect.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium storing computer-executable instructions for causing a computer to perform the method for electrical energy-based data management according to the first aspect.
Additional features and advantages of the application will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the application. The objectives and other advantages of the application may be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating an embodiment of a method for electrical energy-based data management, in accordance with an embodiment of the present invention;
FIG. 2 is a flow chart illustrating a method for managing data based on electrical energy according to another embodiment of the present invention;
FIG. 3 is a flow chart illustrating a method for managing data based on electrical energy according to another embodiment of the present invention;
FIG. 4 is a flow chart illustrating a method for managing data based on electrical energy according to another embodiment of the present invention;
FIG. 5 is a flow chart illustrating a method for managing data based on electrical energy according to another embodiment of the present invention;
FIG. 6 is a flow chart illustrating a method for managing data based on electrical energy according to another embodiment of the present invention;
FIG. 7 is a block diagram of an embodiment of a system for data management based on electrical energy, in accordance with the present invention;
fig. 8 is a block diagram of an embodiment of an electronic control device according to the present invention.
Reference numerals: 100. a receiving module; 200. an acquisition module; 300. a processing module; 400. an anomaly analysis module; 500. a processor; 600. a memory.
Detailed Description
The concept and technical effects of the present invention will be clearly and completely described below in conjunction with the embodiments to fully understand the objects, features and effects of the present invention. It is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments, and those skilled in the art can obtain other embodiments without inventive effort based on the embodiments of the present invention, and all embodiments are within the protection scope of the present invention.
In the description of the embodiments of the present invention, if "a number" is referred to, it means one or more, if "a plurality" is referred to, it means two or more, if "greater than", "less than" or "more than" is referred to, it is understood that the number is not included, and if "greater than", "lower" or "inner" is referred to, it is understood that the number is included. If reference is made to "first" or "second", this should be understood to distinguish between features and not to indicate or imply relative importance or to implicitly indicate the number of indicated features or to implicitly indicate the precedence of the indicated features.
Because the electric energy data in the traditional technology are directly collected and then processed, the quality of the electric energy data is not analyzed, the electric energy data is easy to repeat, incomplete and inaccurate, and the subsequent control according to the electric energy data processing is also inaccurate.
Based on the above, the application discloses a data management method, system, device and storage medium based on electric energy, which can automatically analyze the quality of electric energy data, facilitate relevant personnel to adjust the electric energy data of each power supply unit according to the analysis result of the electric energy data, and improve the integrity, consistency and accuracy of the electric energy data.
In a first aspect, referring to fig. 1, the present embodiment discloses a data management method based on electrical energy, including:
s100, receiving an analysis instruction, and acquiring electric energy data of a power supply unit according to the analysis instruction;
s200, determining a corresponding abnormal analysis rule according to the data attribute of the electric energy data and a preset analysis rule database, wherein the preset analysis rule database comprises matching information of the data attribute and the abnormal analysis rule;
and S300, carrying out abnormity analysis on the electric energy data according to the abnormity analysis rule to obtain an analysis result.
The method comprises the steps of establishing a preset analysis rule database, forming matching information according to data attributes of different electric energy data and corresponding abnormal analysis rules, and storing the matching information into the preset analysis rule database. Therefore, when the electric energy data needs to be analyzed, the data attribute of the electric energy data and the preset analysis rule database are used for determining the corresponding abnormal analysis rule, namely the analysis mode of each type of electric energy data can be clarified, and then the abnormal analysis is carried out on the type of electric energy data according to the abnormal analysis rule so as to judge whether the electric energy data is effective, complete, repeated and the like to obtain an analysis result. Therefore, related personnel can adjust each power supply unit according to the analysis result of each electric energy data so as to ensure that the electric energy data is complete, consistent and accurate.
The analysis instruction receiving step can be manual operation or an analysis instruction sent at regular time according to preset timing time so as to realize the regular analysis of the electric energy data, so that the requirements of different users on the electric energy data analysis can be met by sending the analysis instruction manually and sending the analysis instruction at regular time, and the flexibility of the electric energy data analysis is improved.
In some embodiments, the anomaly analysis rules include: cleaning standards and check rules; the preset analysis rule database includes: presetting a cleaning rule base and/or a verification rule base, wherein the preset cleaning rule base comprises data attribute and matching information of a cleaning standard; the preset check rule base comprises data attributes and matching information of the check rules.
Because the uniqueness, the relevance, the completeness, the consistency, the accuracy and the timeliness of the electric energy data are required to be subjected to data cleaning and verification, corresponding cleaning standards and verification rules can be determined through a preset cleaning rule base and a preset verification rule base, whether the electric energy data are unique, relevant, consistent and timely is judged through the cleaning standards, whether the electric energy data are complete and accurate is judged through the verification rules, so that the quality judgment of the electric energy data is realized, and relevant personnel can perform corresponding data adjustment according to an analysis result.
Referring to fig. 2, step S200 includes:
s210, determining a cleaning standard corresponding to the data attribute according to the data attribute of the electric energy data and a preset cleaning rule base;
and S220, determining a verification rule corresponding to the data attribute according to the electric energy data, the data attribute and a preset verification rule base.
The data cleaning is mainly needed for finding and correcting the last process of recognizable errors in the electric energy data, and is mainly used for checking the consistency of the electric energy meter data and processing invalid electric energy meter data and missing electric energy meter data so as to ensure the uniqueness, consistency, relevance and timeliness of the electric energy meter data. And the verification rule is mainly used for verifying whether the electric energy data is accurate and complete.
Referring to fig. 3, in some embodiments, step S300 includes:
s310, carrying out data cleaning on the electric energy data according to a cleaning standard to obtain a cleaning result;
and S320, verifying the electric energy data according to the verification rule to obtain a verification result.
The main remote from data cleansing of the electrical energy data according to cleansing criteria is the conversion of dirty data into electrical energy data meeting data quality requirements using relevant techniques such as mathematical statistics, data mining or predefined cleansing rules. Therefore, the cleaning result is obtained after the electric energy data are cleaned, and the cleaning result is stored in the MPP database. And then, the electric energy data is verified according to the verification rule so as to verify whether the electric energy meets the verification rule or not to obtain a corresponding verification result. The verification of the electric energy data by the verification rule mainly comprises the steps of verifying whether the electric energy data is complete and accurate or not to obtain a verification result whether the electric energy data is complete and accurate or not, and storing the verification result into the MPP database. Through with washing result and check-up result storage in the MPP database, can unified management, directly read in the MPP database when needing to use can.
Referring to fig. 4, in some embodiments, the method for data management based on electric energy further comprises:
s400, determining a corresponding sorting grade according to the analysis result and a preset grade database, wherein the preset grade database comprises the matching information of the analysis result and the sorting grade;
and S500, displaying the power supply units according to the sorting level.
Different analysis results correspond to different sorting levels, and therefore matching information of the sorting levels corresponding to each analysis result is stored in a preset level database. And when the electric energy data is subjected to abnormal analysis, obtaining an analysis result, and determining a sequencing grade corresponding to the analysis result according to the analysis result and the matching information stored in the preset grade database. And determining the sequencing grade of each power supply unit, namely sequencing and displaying the power supply units according to the sequencing grade, and rectifying the electric energy data through the power supply units related to the grade sequencing excitation.
Referring to fig. 5, in some embodiments, a method of data management based on electrical energy, further comprises:
s600, acquiring a report generation instruction;
and S700, matching the power supply unit with the sequencing grade according to the report generation instruction to generate a ranking report.
The ranking reports with the power supply units and the ranking grades matched with each other are generated through the report generation instruction, each power supply unit can download the ranking reports to clear the quality ranking of the current electric energy data of the power supply unit, and the power supply units can be stimulated to improve the quality of the electric energy data through the ranking reports, so that the quality of the electric energy data of each power supply unit is continuously improved.
In some embodiments, the preset level database comprises: the system comprises a first grading rule base, a second grading rule base and a grade database; the first scoring rule base comprises matching information of the cleaning result and the first score; the second scoring rule comprises matching information of the verification result and the second score; the rank database includes anomaly scores and match information for rank ordering.
Referring to fig. 6, wherein step S400 includes:
s410, determining a first score corresponding to the cleaning result according to the cleaning result and a preset first scoring rule base;
s420, determining a second score corresponding to the verification result according to the verification result and a preset second scoring rule base;
s430, determining abnormal values according to the first values, the second values, the preset first weight values and the preset second weight values;
and S440, determining a sorting grade corresponding to the abnormal score according to the abnormal score and the grade database.
The method comprises the steps of determining a first score corresponding to a cleaning result according to the cleaning result and a preset first scoring rule base, determining a second score according to a verification result and a preset second scoring rule base, then adding the product of the first score and the preset first weight to the product of the second score and the preset second weight to obtain an abnormal score, and then determining a corresponding sorting grade according to the abnormal score and a grade database, so that the sorting grade of a power supply unit can be quickly obtained according to the cleaning result and the verification result.
For example, assume that the cleaning results are classified as poor, general, medium, good, excellent, and the first scores corresponding to the poor in the first scoring rule are 1 score, 3 score, 5 score, 6 score, 7 score, 8 score, 9 score, and 10 score. The checking result is also divided into extremely poor, general, medium, good, excellent and excellent, and the first scores corresponding to the extremely poor in the first scoring rule are 0 score, 2 score, 4 score, 5 score, 6 score, 7 score, 8 score and 10 score. Assuming that the preset first weight is 0.6 and the preset second weight is 0.4, the cleaning result of the electric energy data of the power supply unit a is analyzed to be middle, and the verification result is good, the abnormal score of the power supply unit a is 7 × 0.6+7 × 0.4 ═ 7, and the cleaning result of the electric energy data of the power supply unit B is excellent, and the abnormal score of the power supply unit B is 9 × 0.6+7 × 0.4 ═ 8.2. After the abnormal scores of the power supply unit A and the power supply unit B are clear, the matching information of the abnormal scores and the sorting levels stored in the second scoring rule base is divided into 1 grade from 3 to 4, 2 grades from 4 to 5, 3 grades from 5 to 6, 4 grades from 6 to 7, 5 grades from 7 to 8, 6 grades from 8 to 9 and 7 grades from 9 to 10. Therefore, the power supply unit A can be determined to be 5 levels, the power supply unit B is determined to be 6 levels, and therefore the sequencing condition of the power supply units A and B is known to be B-A, and therefore the power supply unit A can timely correct the electric energy data under the condition of clear sequencing of the power supply unit A, and the quality improvement of the electric energy data is improved.
The method for data management based on electric energy according to an embodiment of the present invention is described in detail in one specific embodiment with reference to fig. 1 to 6. It is to be understood that the following description is only exemplary, and not a specific limitation of the invention.
According to an analysis instruction sent by a user in manual or preset time, electric energy data of a corresponding power supply unit are collected according to the analysis instruction, a cleaning standard corresponding to data attributes is determined according to the data attributes of the electric energy data and a preset cleaning rule base, and a verification rule corresponding to the data attributes is determined according to the data attributes of the electric energy data and a preset verification rule base. Then, the electric energy data are subjected to cleaning standard to obtain a cleaning result so as to judge the uniqueness, relevance, consistency and timeliness of the electric energy data; and then, the electric energy data is checked according to the checking rule to obtain a checking result so as to check the integrity and the accuracy of the electric energy data. And then determining a first score corresponding to the cleaning result according to the cleaning result and a preset first scoring rule base, determining a second score corresponding to the verification result according to the verification result and a preset second scoring rule base, obtaining an abnormal score by adding the product of the first score and a preset first weight to the product of the second score and a preset second weight, determining a corresponding sorting grade according to the abnormal score and a preset grade database, then displaying the power supply units according to the sorting grade in a sorting way, and matching the power supply units and the sorting grade according to a report generation instruction to generate a ranking report. Therefore, related personnel can clearly know the ranking condition of the quality of the electric energy data of the power supply unit where the related personnel are located according to the ranking report so as to stimulate the related personnel to carry out the correction and modification of the electric energy data and improve the quality of the electric energy data.
In a second aspect, referring to fig. 7, an embodiment of the present invention further discloses an electric energy-based data management system, including: the system comprises a receiving module 100, an obtaining module 200, a processing module 300 and an abnormality analysis module 400; the receiving module 100 is configured to receive an analysis instruction; the obtaining module 200 is configured to obtain electric energy data of a power supply unit according to the analysis instruction; the processing module 300 is configured to determine a corresponding abnormal analysis rule according to the data attribute of the electric energy data and a preset analysis rule database, where the preset analysis rule database includes matching information of the data attribute and the abnormal analysis rule; the anomaly analysis module 400 is used for performing anomaly analysis on the electric energy data according to the anomaly analysis rule to obtain an analysis result.
After the processing module 300 determines the corresponding abnormal analysis rule according to the data attribute of the electric energy data and the preset analysis rule database, the abnormal analysis module 400 can perform abnormal analysis on the electric energy data according to the abnormal analysis rule to obtain an analysis result, and relevant personnel can judge the uniqueness, relevance, integrity, consistency, accuracy and timeliness of the electric energy data according to the analysis result, so that the quality analysis of the electric energy data is realized, the quality of the electric energy data is clear according to the analysis result, the electric energy data is rectified to ensure the completeness, accuracy and consistency of the electric energy data, and the accuracy of further analysis and judgment of the electric energy data is improved.
The operation process of the electric energy-based data management system specifically refers to the electric energy-based data management method of the first aspect, and is not described herein again.
In a third aspect, an embodiment of the present invention further discloses an electronic control device, including: at least one processor 500, and a memory 600 communicatively coupled to the at least one processor 500; wherein the memory 600 stores instructions executable by the at least one processor 500, the instructions being executable by the at least one processor 500 to enable the at least one processor 500 to perform the method of electrical energy based data management as the first aspect.
The electronic device may be a mobile terminal device or a non-mobile terminal device. The mobile terminal equipment can be a mobile phone, a tablet computer, a notebook computer, a palm computer, vehicle-mounted terminal equipment, wearable equipment, a super mobile personal computer, a netbook, a personal digital assistant, CPE, UFI (wireless hotspot equipment) and the like; the non-mobile terminal equipment can be a personal computer, a television, a teller machine or a self-service machine and the like; the embodiments of the present invention are not particularly limited.
The memory 600 may be an external memory or an internal memory, and the external memory is an external memory card, such as a Micro SD card. The external memory card communicates with the processor 500 through the external memory 600 interface to implement a data storage function. For example, files such as music, video, etc. are saved in an external memory card. The internal memory may be used to store computer-executable program code, which includes instructions.
In a fourth aspect, a computer-readable storage medium stores computer-executable instructions for causing a computer to perform the method for electrical energy-based data management as in the first aspect.
The above-described embodiments of the apparatus are merely illustrative, wherein the units illustrated as separate components may or may not be physically separate, i.e. may be located in one place, or may also be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
One of ordinary skill in the art will appreciate that all or some of the steps, systems, and methods disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. Some or all of the physical components may be implemented as software executed by a processor, such as a central processing unit, digital signal processor, or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.
The embodiments of the present invention have been described in detail with reference to the accompanying drawings, but the present invention is not limited to the above embodiments, and various changes can be made within the knowledge of those skilled in the art without departing from the gist of the present invention. Furthermore, the embodiments of the present invention and the features of the embodiments may be combined with each other without conflict.
Claims (10)
1. A method of data management based on electrical energy, comprising:
receiving an analysis instruction, and acquiring electric energy data of a power supply unit according to the analysis instruction;
determining a corresponding abnormal analysis rule according to the data attribute of the electric energy data and a preset analysis rule database, wherein the preset analysis rule database comprises matching information of the data attribute and the abnormal analysis rule;
and carrying out anomaly analysis on the electric energy data according to the anomaly analysis rule to obtain an analysis result.
2. The electrical energy-based data management method according to claim 1, wherein the anomaly analysis rule comprises: cleaning standards and/or verification rules; the preset analysis rule database includes:
a preset cleaning rule base, wherein the preset cleaning rule base comprises matching information of the data attribute and the cleaning standard;
and/or the presence of a gas in the gas,
and presetting a check rule base, wherein the preset check rule base comprises the data attribute and the matching information of the check rule.
3. The method for electrical energy-based data management according to claim 2, wherein said performing an anomaly analysis on said electrical energy data according to said anomaly analysis rule to obtain an analysis result comprises:
performing data cleaning on the electric energy data according to the cleaning standard to obtain a cleaning result;
and verifying the electric energy data according to the verification rule to obtain a verification result.
4. The electrical energy-based data management method of claim 3, further comprising:
determining a corresponding sorting grade according to the analysis result and a preset grade database, wherein the preset grade database comprises matching information of the analysis result and the sorting grade;
and displaying the power supply units according to the sorting level.
5. The electrical energy-based data management method according to claim 4, wherein the preset level database comprises:
a first scoring rule base, wherein the first scoring rule base comprises matching information of the cleaning result and a first score;
the second scoring rule base comprises matching information of the verification result and a second score;
a rank database comprising anomaly scores and match information for the ranked ranks.
6. The electrical energy-based data management method according to claim 5, wherein the determining the corresponding ranking level according to the analysis result and the preset ranking database comprises:
determining a first score corresponding to the cleaning result according to the cleaning result and a preset first scoring rule base;
determining a second score corresponding to the verification result according to the verification result and a preset second scoring rule base;
determining an abnormal score according to the first score, the second score, a preset first weight and a preset second weight;
and determining a sorting grade corresponding to the abnormal score according to the abnormal score and the grade database.
7. An electrical energy-based data management method according to any one of claims 4 to 6, further comprising:
acquiring a report generation instruction;
and matching the power supply unit with the sequencing grade according to the report generation instruction to generate a ranking report.
8. An electrical energy-based data management system, comprising:
the receiving module is used for receiving an analysis instruction;
the acquisition module is used for acquiring the electric energy data of a power supply unit according to the analysis instruction;
the processing module is used for determining a corresponding abnormal analysis rule according to a data attribute of the electric energy data and a preset analysis rule database, and the preset analysis rule database comprises matching information of the data attribute and the abnormal analysis rule;
and the abnormality analysis module is used for carrying out abnormality analysis on the electric energy data according to the abnormality analysis rule so as to obtain an analysis result.
9. An electronic control apparatus, characterized by comprising:
at least one processor, and,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the electrical energy-based data management method of any one of claims 1 to 7.
10. A computer-readable storage medium storing computer-executable instructions for causing a computer to perform the method for electrical energy-based data management according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110694301.9A CN113379275A (en) | 2021-06-22 | 2021-06-22 | Data management method, system, equipment and storage medium based on electric energy |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110694301.9A CN113379275A (en) | 2021-06-22 | 2021-06-22 | Data management method, system, equipment and storage medium based on electric energy |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113379275A true CN113379275A (en) | 2021-09-10 |
Family
ID=77578504
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110694301.9A Pending CN113379275A (en) | 2021-06-22 | 2021-06-22 | Data management method, system, equipment and storage medium based on electric energy |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113379275A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106161138A (en) * | 2016-06-17 | 2016-11-23 | 贵州电网有限责任公司贵阳供电局 | A kind of intelligence automatic gauge method and device |
| CN109033174A (en) * | 2018-06-21 | 2018-12-18 | 北京国网信通埃森哲信息技术有限公司 | A kind of power quality data cleaning method and device |
| CN110659273A (en) * | 2019-09-20 | 2020-01-07 | 南方电网科学研究院有限责任公司 | Data abnormity monitoring and repairing method of distributed big data acquisition platform |
| CN112241403A (en) * | 2020-10-29 | 2021-01-19 | 深圳供电局有限公司 | Electric energy quality data cleaning method and system for typical scene |
| CN112365361A (en) * | 2020-09-16 | 2021-02-12 | 贵州电网有限责任公司 | Power metering data quality physical examination method based on rule base |
-
2021
- 2021-06-22 CN CN202110694301.9A patent/CN113379275A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106161138A (en) * | 2016-06-17 | 2016-11-23 | 贵州电网有限责任公司贵阳供电局 | A kind of intelligence automatic gauge method and device |
| CN109033174A (en) * | 2018-06-21 | 2018-12-18 | 北京国网信通埃森哲信息技术有限公司 | A kind of power quality data cleaning method and device |
| CN110659273A (en) * | 2019-09-20 | 2020-01-07 | 南方电网科学研究院有限责任公司 | Data abnormity monitoring and repairing method of distributed big data acquisition platform |
| CN112365361A (en) * | 2020-09-16 | 2021-02-12 | 贵州电网有限责任公司 | Power metering data quality physical examination method based on rule base |
| CN112241403A (en) * | 2020-10-29 | 2021-01-19 | 深圳供电局有限公司 | Electric energy quality data cleaning method and system for typical scene |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110221145B (en) | Power equipment fault diagnosis method and device and terminal equipment | |
| CN109345417B (en) | Online assessment method and terminal equipment for business personnel based on identity authentication | |
| CN107180343B (en) | Method and device for automatic payment | |
| CN108495329B (en) | Method and device for evaluating reliability of base station | |
| CN107424105B (en) | Medical imaging equipment fee-missing intelligent management system and method | |
| CN109582550B (en) | Method, device and server for acquiring full-service scene fault set | |
| CN110796347B (en) | Refined management system and method based on material tracking technology | |
| CN109450089B (en) | Transformer area low voltage identification method and device and terminal equipment | |
| CN110610431A (en) | Intelligent claim settlement method and intelligent claim settlement system based on big data | |
| CN110221933A (en) | Aacode defect assists restorative procedure and system | |
| CN112463859A (en) | User data processing method based on big data and business analysis and big data platform | |
| CN109933605A (en) | Electricity charge mistake checks method, apparatus and electronic equipment | |
| CN112184072B (en) | Machine room equipment management method and device | |
| CN115329814B (en) | Low-voltage user link identification method and device based on image signal processing | |
| CN110991150B (en) | Data format conversion method, device and account reporting system | |
| CN112990868A (en) | Method, system, equipment and storage medium for automatic vehicle insurance claims | |
| CN102810122A (en) | Verification system and method for electronic product design | |
| CN107633462A (en) | Power marketing checking method and terminal device | |
| CN113379275A (en) | Data management method, system, equipment and storage medium based on electric energy | |
| CN107590541B (en) | On-site processing method for low success rate defect of load data acquisition | |
| CN109636437A (en) | Cell average price predictor method, electronic device and storage medium | |
| CN110690982A (en) | Telecommunication network management performance data correlation analysis method and system | |
| CN114862053A (en) | Material supplier pushing method, system and equipment | |
| CN110175181B (en) | Information updating method based on data analysis and related equipment | |
| CN102256271B (en) | The acquisition methods and device of capacity expansion indication information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210910 |
|
| RJ01 | Rejection of invention patent application after publication |