CN113781000A - Intelligent data checking power management system and management method - Google Patents
Intelligent data checking power management system and management method Download PDFInfo
- Publication number
- CN113781000A CN113781000A CN202111096979.3A CN202111096979A CN113781000A CN 113781000 A CN113781000 A CN 113781000A CN 202111096979 A CN202111096979 A CN 202111096979A CN 113781000 A CN113781000 A CN 113781000A
- Authority
- CN
- China
- Prior art keywords
- data
- equipment
- abnormal
- abnormal data
- checking
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 42
- 230000002159 abnormal effect Effects 0.000 claims abstract description 96
- 238000013523 data management Methods 0.000 claims abstract description 30
- 238000013524 data verification Methods 0.000 claims abstract description 6
- 238000004458 analytical method Methods 0.000 claims description 17
- 238000012216 screening Methods 0.000 claims description 13
- 238000007405 data analysis Methods 0.000 claims description 8
- 238000012986 modification Methods 0.000 claims description 7
- 230000004048 modification Effects 0.000 claims description 7
- 230000009466 transformation Effects 0.000 claims description 6
- 230000014509 gene expression Effects 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000012550 audit Methods 0.000 claims 1
- 238000000034 method Methods 0.000 abstract description 10
- 238000001514 detection method Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000003908 quality control method Methods 0.000 description 3
- 238000007689 inspection Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000005259 measurement 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/10—Office automation; Time 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an intelligent data checking power management system and a management method, wherein the intelligent data checking power management system comprises: the database is used for storing equipment data needing data verification; the equipment data comprises current resource data of the equipment and a preset check rule of the equipment; the background data management module is connected with the database and used for regularly checking the equipment data in the database and adding abnormal data which do not accord with the preset checking rule of the equipment into an abnormal data list; and the checking terminal is connected with the background data management module and is used for acquiring the abnormal data list of the background data management module and displaying the abnormal data list. The method and the device can timely and comprehensively know and check the data quality condition of the equipment, solve the problems of nonstandard basic information, large workload, time and labor consumption and high error rate in data check in the prior art, and improve the working efficiency and the data check management and control level.
Description
Technical Field
The invention relates to the technical field of power data processing, in particular to an intelligent data checking power management system and a management method.
Background
And each management department of the power company provides powerful guarantee for the deepened application of production management business according to the checking rules of the assessment parameters of various devices. However, in actual work, data quality problems such as nonstandard basic information, non-standard basic information, missing basic information, non-uniform basic information and the like occur in data checking, and the requirements of timely extraction and sharing of a power grid company cannot be met. And the accuracy of part of production service data is poor, and the measurement units, the data precision and the names are inaccurate, so that the direct and full utilization can not be realized. Meanwhile, the abnormal operation rule of data checking is complex, the data size is large, repeated data screening, pasting and other operations are required, the workload is large, particularly for personnel who monitor and analyze according to the field rule of the equipment, a large amount of energy and time are often consumed during data processing, screening is mistaken or omitted carelessly, and for equipment operation and maintenance personnel at the production front line, the abnormal operation is screened by means which is lacked, a detection and control method is lacked, and autonomous data quality control can not be supported.
Disclosure of Invention
In order to overcome the defects of the prior art, an intelligent data checking power management system and a management method are provided, and the problems that basic information is not standard, workload is large, time and labor are consumed, and error rate is high in data checking in the prior art are solved.
In order to solve the above technical problem, the present invention provides an intelligent data checking power management system, including:
the database is used for storing equipment data needing data verification; the equipment data comprises current resource data of the equipment and a preset check rule of the equipment;
the background data management module is connected with the database and used for regularly checking the equipment data in the database and adding abnormal data which do not accord with the preset checking rule of the equipment into an abnormal data list;
and the checking terminal is connected with the background data management module and is used for acquiring an abnormal data list of the background data management module and displaying the abnormal data list.
The data analysis module is connected with the background data management module and is used for analyzing the abnormal data of the abnormal data list to obtain an analysis report of the equipment.
Further, the preset checking rule comprises a basic attribute rule and an attribute association rule of the device.
Further, the basic attribute rule comprises a regular expression, non-null, inclusion, number type limitation and size range limitation of the equipment; the attribute association rule refers to whether the attributes of a plurality of associated resource items are consistent.
Further, the background data management module further includes:
the query unit is connected with the checking terminal and used for searching and screening the abnormal data in the abnormal data list according to the received query instruction;
and the modifying unit is connected with the checking terminal and used for adding, deleting or modifying the abnormal data, the checking rules or the resource items of the abnormal data list according to the received modifying instruction.
Further, the equipment comprises power transformation primary equipment, power transformation secondary equipment, power transmission equipment, other equipment, pipelines and related equipment.
The invention also provides an intelligent data checking power management method, which is characterized in that the intelligent data checking power management system comprises the following steps:
step S1, the background data management module acquires the equipment data to be checked in the database, and determines the check rule of the equipment in the database;
step S2, performing data check on the current resource data of the equipment according to the check rule of the equipment;
step S3, adding abnormal data which do not accord with the check rule of the equipment into an abnormal data list;
and step S4, checking the abnormal data list through the checking terminal, and maintaining the equipment according to the abnormal data list.
Further, the step S4 further includes the following steps:
step S41, the data analysis module analyzes the abnormal data in the abnormal data list to obtain an analysis report about the abnormal data of the device; the analysis report comprises the name of the equipment, abnormal data which do not accord with the preset check rule of the equipment and an abnormal type;
step S42, maintaining the equipment according to the analysis report;
and step S43, the background data management module rechecks the equipment according to the check rule until the equipment meets the check rule, and deletes the abnormal data from the abnormal data list.
Further, the intelligent data checking power management method further comprises the following steps:
and step S0, recording the equipment data needing data check, and regularly transmitting the current resource data of the equipment to a database.
Further, the intelligent data checking power management method further includes:
the background data management module receives a query requirement input by a user, and queries and screens abnormal data in the abnormal data list; or
And the background data management module receives a modification requirement input by a user and adds, deletes or modifies the data in the abnormal data list.
The implementation of the invention has the following beneficial effects: the equipment in the power system can be checked, abnormal data can be found in time according to preset checking rules of the equipment and added into the abnormal data list, the abnormal data list can be checked and processed by workers, a large amount of data can be processed without manual screening, and the problems of high error rate and repeated screening of manual screening are avoided. And an abnormal data list is constructed according to each device, and workers lacking a detection and control method are assisted to directly and autonomously carry out data quality control and maintain.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic block diagram of an intelligent data checking power management system according to an embodiment of the present invention.
Fig. 2 is a schematic flowchart of an intelligent data verification power management method according to a second embodiment of the present invention.
Detailed Description
The following description of the embodiments refers to the accompanying drawings, which are included to illustrate specific embodiments in which the invention may be practiced.
As shown in fig. 1, an embodiment of the present invention provides an intelligent data checking power management system, which can check resource data of a device in a power grid system, so as to implement accuracy and rationality management on the device.
The intelligent data checking power management system comprises:
the database 1 is used for storing equipment data needing data checking, wherein the equipment data comprise current resource data of the equipment and a preset checking rule of the equipment;
the background data management module 2 is connected with the database 1 and used for regularly checking the equipment data in the database 1 and adding abnormal data which do not accord with the preset checking rule of the equipment into an abnormal data list;
and the checking terminal 4 is connected with the background data management module 2 and is used for acquiring the abnormal data list of the background data management module 2 and displaying the abnormal data list.
In this embodiment, the verification terminal 4 may be a displayable and interactive intelligent terminal such as a computer, a tablet computer, and a smart phone that are disposed inside the power system.
In the present embodiment, the database 1 is used to store device data of the device. The equipment comprises primary power transformation equipment, secondary power transformation equipment, power transmission equipment, other equipment, pipelines and related equipment, equipment data can comprise asset property, asset units, equipment names, models, factory numbers, voltage ratios, rated current (high voltage), rated current (low voltage), section element loss (W), rated capacity (kVA), affiliated power stations, no-load loss (W), use states and the like of the equipment, and current resource data of the equipment can be determined according to data required by preset checking rules of different equipment. The preset checking rules of the device can be divided into basic attribute rules and attribute association rules: the basic attribute rule comprises a regular expression, non-null, inclusion, digital type limitation and size range limitation of the equipment; the regular expression can be written by self-definition to compare data, for example, each interface necessarily has associated equipment, and the equipment attribute of the interface is not necessarily null; the attribute association rule is whether the attributes of the associated resource items are consistent, and if a certain attribute is inconsistent, for example, the sub-network to which the device table and the interface table belong is inconsistent, the attribute association rule is inconsistent with the preset check rule.
And the background management module 2 checks the equipment according to the preset check rule of the equipment at regular time, and when the abnormal data which does not accord with the preset check rule of the equipment is found, the abnormal data which does not accord with the preset check rule of the equipment is added into an abnormal data list to wait for the user to process.
The data analysis module 3 is further arranged in the embodiment, and the data analysis module 3 is connected with the background data management module 2 and is used for analyzing the abnormal data list according to past experience and an equipment workbook to obtain an analysis report of the equipment and present the analysis report in the verification terminal 4, so that a worker does not need to search for an abnormal reason again according to the abnormal data list and can directly process the abnormal reason according to the analysis report.
And checking the abnormal data list and the analysis report through the checking terminal 4 by a worker, and maintaining. In order to facilitate management of workers, the background data management module 2 is further provided with a query unit and a modification unit, the query unit is connected with the checking terminal 4, and the abnormal data in the abnormal data list is searched and screened according to the received query instruction. The staff can directly screen according to the device name, time, or attributes such as the check rule, so as to quickly find abnormal data which do not accord with the preset check rule of the device. The modification unit is connected with the checking terminal 4, and adds, deletes or modifies the resource data, the checking rule or the resource item of the abnormal data list according to the received modification instruction. The check rules and the resource items of the equipment are provided with independent lists, the lists are stored in the database 1, and workers can inquire and modify the lists through the check terminal 4.
The intelligent data checking power management system provided by the invention can check the equipment in the power system, can process a large amount of data without manual screening, and avoids the problems of high error rate and repeated screening of manual screening. And an abnormal data list is constructed according to each device, and the abnormal data list can be directly screened and checked through the query unit. Meanwhile, a data analysis module 3 is additionally arranged to analyze the abnormal data list to obtain an analysis report of the abnormal data of the equipment, and the data quality management is directly and autonomously carried out by workers lacking the inspection and control method for maintenance.
Based on the same inventive concept, as shown in fig. 2, a second embodiment of the present invention further provides an intelligent data verification power management method, which is applied to the intelligent data verification power management system, and includes the following steps:
step S1, the background data management module acquires the equipment data to be checked in the database, and determines the check rule of the equipment in the database;
step S2, performing data check on the current resource data of the equipment according to the check rule of the equipment;
step S3, adding abnormal data which do not accord with the check rule of the equipment into an abnormal data list;
and step S4, checking the abnormal data list through the checking terminal, and maintaining the equipment according to the abnormal data list.
Before the step S1, the method further includes step S0, entering device data that needs to be subjected to data check, and periodically transmitting the current resource data of the device to the database 1.
Specifically, step S4 includes the steps of:
step S41, the data analysis module 3 analyzes the abnormal data in the abnormal data list to obtain an analysis report about the abnormal data of the device, where the analysis report includes the name of the device, the abnormal data that does not conform to the preset check rule of the device, and the abnormal type, so as to assist a worker lacking an inspection and control method to directly and autonomously develop data quality management for maintenance;
step S42, maintaining the equipment according to the analysis report; when the record of a certain abnormal data list is displayed, the record is selected, the analysis report of the abnormal data list can be displayed, and a worker can directly modify the record through a modification unit of the background data management unit.
Step S43, the background data management module 2 checks the device again according to the check rule until the device meets the check rule, and deletes the data from the abnormal data list. And rechecking the recorded equipment after the modification is finished, and if the equipment does not accord with the modified equipment, repeating the step S42 until the equipment accords with the check rule, and deleting the record from the abnormal data list.
In addition, a query request can be input through a query unit of the background data management module 2, and data in the abnormal data list is queried and screened. And the query unit displays different query windows according to different rules. If the basic attribute rule is queried, input boxes such as non-empty, containing, not containing, number type, narrow range, regular expression and the like are displayed, and if the attribute association rule is queried, associated resource items and associated resource attributes are displayed.
As can be seen from the above description, the following advantageous effects are obtained in implementing the present invention: the equipment in the power system can be checked, abnormal data can be found in time according to preset checking rules of the equipment and added into the abnormal data list, the abnormal data list can be checked and processed by workers, a large amount of data can be processed without manual screening, and the problems of high error rate and repeated screening of manual screening are avoided. And an abnormal data list is constructed according to each device, and workers lacking a detection and control method are assisted to directly and autonomously carry out data quality control and maintain.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.
Claims (10)
1. An intelligent data-audit power management system, comprising:
the database is used for storing equipment data needing data verification; the equipment data comprises current resource data of the equipment and a preset check rule of the equipment;
the background data management module is connected with the database and used for regularly checking the equipment data in the database and adding abnormal data which do not accord with the preset checking rule of the equipment into an abnormal data list;
and the checking terminal is connected with the background data management module and is used for acquiring an abnormal data list of the background data management module and displaying the abnormal data list.
2. The intelligent data checking power management system according to claim 1, further comprising a data analysis module, connected to the background data management module, for analyzing the abnormal data in the abnormal data list to obtain an analysis report of the device.
3. The intelligent data-checking power management system according to claim 1, wherein the preset checking rules comprise basic attribute rules and attribute association rules of the device.
4. The intelligent data-auditing power management system of claim 3 where the base attribute rules include regular expressions, non-null, containment, numeric type limits, size range limits for the device; the attribute association rule refers to whether the attributes of a plurality of associated resource items are consistent.
5. The intelligent data-auditing power management system of claim 3, where the background data management module further comprises:
the query unit is connected with the checking terminal and used for searching and screening the abnormal data in the abnormal data list according to the received query instruction;
and the modifying unit is connected with the checking terminal and used for adding, deleting or modifying the abnormal data, the checking rules or the resource items of the abnormal data list according to the received modifying instruction.
6. The intelligent data-auditing power management system of claim 1 where the devices include primary power transformation devices, secondary power transformation devices, power transmission devices, other devices, pipelines and their associated devices.
7. An intelligent data-check power management method applied to the intelligent data-check power management system according to any one of claims 1 to 6, comprising the following steps:
step S1, the background data management module acquires the equipment data to be checked in the database, and determines the check rule of the equipment in the database;
step S2, performing data check on the current resource data of the equipment according to the check rule of the equipment;
step S3, adding abnormal data which do not accord with the check rule of the equipment into an abnormal data list;
and step S4, checking the abnormal data list through the checking terminal, and maintaining the equipment according to the abnormal data list.
8. The intelligent data-auditing power management method according to claim 7, where said step S4 further includes the steps of:
step S41, the data analysis module analyzes the abnormal data in the abnormal data list to obtain an analysis report about the abnormal data of the device; the analysis report comprises the name of the equipment, abnormal data which do not accord with the preset check rule of the equipment and an abnormal type;
step S42, maintaining the equipment according to the analysis report;
and step S43, the background data management module rechecks the equipment according to the check rule until the equipment meets the check rule, and deletes the abnormal data from the abnormal data list.
9. The intelligent data-auditing power management method of claim 7, further comprising the steps of:
and step S0, recording the equipment data needing data check, and regularly transmitting the current resource data of the equipment to a database.
10. The intelligent data-auditing power management method of claim 9, further comprising:
the background data management module receives a query requirement input by a user, and queries and screens abnormal data in the abnormal data list; or
And the background data management module receives a modification requirement input by a user and adds, deletes or modifies the data in the abnormal data list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111096979.3A CN113781000A (en) | 2021-09-18 | 2021-09-18 | Intelligent data checking power management system and management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111096979.3A CN113781000A (en) | 2021-09-18 | 2021-09-18 | Intelligent data checking power management system and management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113781000A true CN113781000A (en) | 2021-12-10 |
Family
ID=78851988
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111096979.3A Pending CN113781000A (en) | 2021-09-18 | 2021-09-18 | Intelligent data checking power management system and management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113781000A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103188094A (en) * | 2011-12-28 | 2013-07-03 | 中国移动通信集团贵州有限公司 | Resource data verification system and resource data verification method |
| CN104732344A (en) * | 2015-03-18 | 2015-06-24 | 浪潮通信信息系统有限公司 | Resource data checking system and method |
| CN105678646A (en) * | 2016-03-24 | 2016-06-15 | 国网辽宁省电力有限公司电力科学研究院 | Production management system distribution network equipment machine account intelligent inspection system |
| CN110008254A (en) * | 2019-04-02 | 2019-07-12 | 云南电网有限责任公司电力科学研究院 | A kind of transformer equipment account verification processing method |
| CN111221956A (en) * | 2019-12-26 | 2020-06-02 | 国网宁夏电力有限公司中卫供电公司 | PMS distribution network equipment data quality checking method for power management system |
-
2021
- 2021-09-18 CN CN202111096979.3A patent/CN113781000A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103188094A (en) * | 2011-12-28 | 2013-07-03 | 中国移动通信集团贵州有限公司 | Resource data verification system and resource data verification method |
| CN104732344A (en) * | 2015-03-18 | 2015-06-24 | 浪潮通信信息系统有限公司 | Resource data checking system and method |
| CN105678646A (en) * | 2016-03-24 | 2016-06-15 | 国网辽宁省电力有限公司电力科学研究院 | Production management system distribution network equipment machine account intelligent inspection system |
| CN110008254A (en) * | 2019-04-02 | 2019-07-12 | 云南电网有限责任公司电力科学研究院 | A kind of transformer equipment account verification processing method |
| CN111221956A (en) * | 2019-12-26 | 2020-06-02 | 国网宁夏电力有限公司中卫供电公司 | PMS distribution network equipment data quality checking method for power management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101614781B (en) | Intelligent diagnosis method of radio and television equipment based on spatial rule index | |
| CN108388640B (en) | Data conversion method and device and data processing system | |
| CN112463807A (en) | Data processing method, device, server and storage medium | |
| CN112598142B (en) | Wind turbine maintenance working quality inspection auxiliary method and system | |
| CN113781000A (en) | Intelligent data checking power management system and management method | |
| CN115391432A (en) | Judicial big data processing method, system, server and storage medium | |
| CN105573984A (en) | Socio-economic indicator identification method and device | |
| CN114757157A (en) | Method, apparatus, device and medium for generating aircraft work package | |
| CN114385782A (en) | Nuclear power plant maintenance auxiliary decision-making method based on knowledge graph | |
| CN114912866A (en) | Information association method, device, equipment and storage medium | |
| CN112445918A (en) | Knowledge graph generation method and device, electronic equipment and storage medium | |
| CN113342987A (en) | Composite network construction method of special corpus for power distribution DTU acceptance | |
| JPH06335165A (en) | Method and apparatus for constituting data base of power system monitoring control system, method and apparatus for managing data base of power system monitoring control system and power system monitoring control system | |
| CN111625616A (en) | Enterprise-level data management system capable of realizing mass storage | |
| US20220215320A1 (en) | Process data processing method and apparatus, storage medium, and electronic equipment | |
| Sinlae et al. | Application Of Business Intelligence In The Analysis And Visualization Of Xyz University Alumni Data Using The Tableau Platform | |
| CN117875948B (en) | Equipment-based power grid overhaul event determination method, device, equipment and medium | |
| CN115146604B (en) | Method, device, equipment and storage medium for generating interface technical document | |
| CN113744359B (en) | Method and system for constructing system flow chart of nuclear power station | |
| CN106815331A (en) | Defect aid in treatment method and system based on typical defect storehouse | |
| CN109246389B (en) | Method and equipment for associating monitoring points | |
| CN114358801A (en) | Data tracing method, system, equipment and storage medium | |
| CN118171423A (en) | Power grid diagram construction method and device based on data fusion, terminal equipment and medium | |
| CN116166520A (en) | Apparatus and method for test part management | |
| CN114862619A (en) | Basic electricity charge processing method and device, electronic equipment and medium |
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 |