Background
In recent years, with the rapid development of energy systems and power industries in China and the continuous expansion of the capacity of power systems, the problem of the power quality of a public power grid becomes increasingly serious, and in order to meet the challenges brought by the changes, ensure the high-quality power supply for users and simultaneously optimize the management mode of power quality of power grid enterprises, a set of scientific and effective power quality detection scheme needs to be established by power companies.
Compared with developed countries and regions, the on-line power quality monitoring research in China starts late, the current power system lacks mature research results in terms of power grid safety reliability and power grid quality, and due to the fact that different industries have different characteristics, the power grid has few specific applications for the on-line power quality monitoring system and mostly only stays in a theoretical framework part.
At present, the following problems exist in the data quality management work of the large-scale and late-start power quality online monitoring system:
the data acquisition process has the condition of manual input acquisition, and the multi-system maintenance process causes the problems of data loss, untimely data uploading, low automatic integration proportion and inconsistent data in the data acquisition, conversion, uploading and warehousing processes. Therefore, the efficiency and the data utilization rate are low in the power quality management process. The automatic acquisition of data and the fusion and sharing of cross-professional and cross-layer data cannot be realized; the accurate investment of a power grid enterprise and the improvement of the power supply service level are not facilitated; the power supply reliability of the electric power enterprise is improved.
Disclosure of Invention
Aiming at the problems in the prior art, the embodiment of the invention provides a method and a device for checking power standing book data based on a blood relationship, so as to realize the conversion of a power quality management mode and effectively improve the efficiency of data quality management.
In a first aspect, an embodiment of the present invention provides a method for checking power ledger data, including:
acquiring first account data of an electric energy quality online monitoring system and second account data of a source service system;
acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data;
acquiring intelligent evaluation data based on the total data volume of the standing book automatically integrated by the power quality online monitoring system and the total data volume of the standing book of the first standing book data;
and matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to acquire consistency evaluation data.
In a second aspect, an embodiment of the present invention provides an apparatus for checking power ledger data, including:
the data acquisition module is used for acquiring first account data of the power quality online monitoring system and second account data of the source service system;
the integrity evaluation module is used for acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data;
the intelligent evaluation module is used for acquiring intelligent evaluation data based on the total data volume of the standing book and the total data volume of the first standing book data, which are automatically integrated by the electric energy quality online monitoring system;
and the consistency evaluation module is used for matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to acquire consistency evaluation data.
In a third aspect, an embodiment of the present invention provides an electric power standing book data verification apparatus, including:
at least one processor; and
at least one memory communicatively coupled to the processor, wherein:
the memory stores program instructions executable by the processor, and the processor calls the program instructions to execute the power ledger data verification method and the method of any optional embodiment of the invention.
In a fourth aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium storing computer instructions, where the computer instructions cause the computer to execute the method for checking power ledger data according to the embodiment of the present invention and the method according to any optional embodiment of the present invention.
According to the method for checking the electric power standing book data, provided by the embodiment of the invention, based on the blood relationship between the electric energy quality on-line monitoring system standing book data and the PMS system, the electricity utilization information acquisition system and the automatic power supply voltage acquisition system standing book data, the integrity, the consistency and the intelligence of the data are evaluated through blood relationship data comparison, so that the data quality process control and management of the electric energy quality on-line monitoring system are realized, the safe operation of a power grid and the reliable supply of electric power resources are realized, and the efficiency of data quality management and the automatic acquisition proportion are greatly improved.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some embodiments, but not all embodiments, of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a schematic flow chart of a method for checking power ledger data according to an embodiment of the present invention, and as shown in fig. 1, the method includes:
s100, acquiring first account data of an electric energy quality online monitoring system and second account data of a source service system;
specifically, the power quality online monitoring system is configured to monitor various data of the source service system in real time in an online manner, and the data is used as the self account data, that is, the first account data.
The source service system refers to an original system of a data source of the power quality online monitoring system.
Specifically, the source service system comprises a PMS system, a power utilization information acquisition system and a power supply voltage automatic acquisition system;
the ledger data of the power system includes: the system comprises main network 13 facilities (lightning arresters, current transformers, voltage transformers, buses, overhead lines, cable lines, isolating switches, wave traps, combined electrical appliances, transformers, reactors, coupling capacitors and circuit breakers), public distribution network distribution transformers and pole-mounted transformers, transformer substations, power supply special users and power supply voltage monitoring points.
S200, acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data;
and the integrity evaluation is to evaluate whether the number of evaluation objects displayed by respective account data in the power quality online monitoring system and the source service system is the same.
S300, acquiring intelligent evaluation data based on the total data volume of the standing book automatically integrated by the power quality online monitoring system and the total data volume of the standing book of the first standing book data;
the intelligent evaluation is to evaluate whether the total data volume of the standing book automatically integrated by the power quality on-line monitoring system is the same as the total data volume of the standing book monitored by the power quality on-line monitoring system.
And S400, matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to obtain consistency evaluation data.
The consistency evaluation power quality online monitoring system and the source service system judge whether the data of the evaluation objects are consistent, and specifically, whether the data of the evaluation objects are consistent is compared through key fields.
In the embodiment of the present invention, steps S200, S300, and S400 are not executed in any order, and may be executed in any order.
The embodiment of the invention is based on the blood relationship between the machine account data of the power quality online monitoring system and the machine account data of the PMS, the power utilization information acquisition system and the power supply voltage automatic acquisition system, and performs data integrity, consistency and intelligent evaluation by blood relationship data comparison, thereby realizing data quality process control and management of the power quality online monitoring system, realizing safe operation of a power grid and reliable supply of power resources, and greatly improving the efficiency of data quality management and the automatic acquisition proportion.
Specifically, the evaluation object includes:
the power facilities monitored by the PMS system and the power quality on-line monitoring system; the electric power facility includes a plurality of: the transformer comprises a lightning arrester, a current transformer, a voltage transformer, a bus, an overhead line, a cable line, an isolating switch, a wave trap, a combined electrical appliance, a transformer, a reactor, a coupling capacitor, a circuit breaker, a public distribution network distribution transformer, a pole-mounted transformer and a transformer substation.
The power supply public users monitored by the PMS system and the electric energy quality on-line monitoring system;
the power supply special users monitored by the power utilization acquisition system and the electric energy quality online monitoring system;
and the power supply voltage monitoring points are monitored by the power supply voltage automatic acquisition system and the electric energy quality on-line monitoring system.
Based on the above embodiment, in step S200, the acquiring integrity evaluation data based on the device data of the evaluation object in the first standing book data and the device data of the evaluation object in the second standing book data specifically includes:
s200.1, respectively counting first equipment data, second equipment data and third equipment data of evaluation objects in the first standing book data and the second standing book data, wherein the first equipment data are the total number of the equipment of the evaluation objects, the second equipment data are the number of the equipment of the evaluation objects in a delivery or in-operation state, and the third equipment data are the number of the equipment of the evaluation objects in the delivery or in-operation state; the evaluation objects comprise the electric power facilities, the power supply public users, the power supply special users and the power supply voltage monitoring points.
S200.2, calculating the deviation ratio of the first equipment data, the second equipment data and the third equipment data of the evaluation object in the power quality online monitoring system and the corresponding data of the source service system according to a preset deviation ratio check rule, and acquiring integrity evaluation data.
Specifically, the preset deviation ratio checking rule is as follows:
the deviation rate is (evaluation data of the power quality online monitoring system-evaluation data of the source service system)/evaluation data of the source service system;
the evaluation data is first device data, second device data or third device data of the evaluation object.
In this embodiment, the integrity of the data of the three devices of the evaluation object in the power quality online monitoring system and the source service system may be obtained respectively, and on this basis, the integrity of the total data may be obtained, that is, the integrity of the total number of the devices of the evaluation object, the integrity of the number of the devices of the evaluation object in the commissioning or in the operation state, and the integrity of the number of the devices of the evaluation object in the commissioning or in the operation state are obtained according to the preset deviation ratio check rule; and acquiring the integrity of total data according to the sum of the first equipment data, the second equipment data and the third equipment data of the evaluation object in the power quality online monitoring system and the sum of the first equipment data, the second equipment data and the third equipment data of the evaluation object in the source service system.
Based on the above embodiment, in step S300, based on the total data volume of the standing book and the total data volume of the standing book of the first standing book data, which are automatically integrated by the online power quality monitoring system, the intelligent evaluation data is acquired, which specifically includes:
s300.1, respectively counting the total data volume of the standing book automatically integrated by the power quality on-line monitoring system and the total data volume of the standing book of the first standing book data;
and S300.2, calculating the ratio of the total data volume of the automatically integrated standing book to the total data volume of the first standing book data, and acquiring intelligent evaluation data.
Specifically, the ratio of the automatic integration is the total standing book data amount of the first standing book data/the total standing book data amount of the second standing book data.
Based on the above embodiment, in step S400, the obtaining consistency evaluation data according to matching between the key field of the evaluation object in the first standing book data and the key field of the evaluation object in the second standing book data specifically includes:
s400.1, matching a specific field of an evaluation object in the first standing book data with a corresponding field of the evaluation object in the second standing book data;
in this embodiment, the evaluation objects include the above-mentioned electric power facilities, power supply public users, power supply private users, and power supply voltage monitoring points; for different evaluation objects, the specific fields used for matching may be the same or different, and may be one field or a plurality of fields, and what specific evaluation field is specifically adopted needs to be determined according to the specific evaluation object and the standing book data of the specific evaluation object.
S400.2, judging whether the key fields of the evaluation objects in the power quality online monitoring system and the source service system are consistent or not for all the successfully matched evaluation objects, and obtaining the total number of consistent key fields in all the successfully matched evaluation objects;
when the consistency is judged, the consistency of the successfully matched price-matching objects is judged; and corresponding to the evaluation object with unsuccessful matching, consistency does not need to be judged.
Specifically, the consistency is judged not based on all data of the evaluation object but based on the key field, so that the judgment efficiency can be improved. Specifically, the key fields may be the same or different according to different evaluation objects.
And S400.3, calculating the proportion of the total number of the consistent key fields to the total number of the equipment of the evaluation object of the power quality online monitoring system, and acquiring consistency evaluation data.
Specifically, the proportion of the consistent key fields is the total number of the consistent key fields/the total number of the devices to be evaluated by the online power quality monitoring system.
The following describes specific matching and consistency determination of different evaluation targets, that is, power facilities, power supply utility users, power supply exclusive users, and power supply voltage monitoring points.
Based on the above embodiment, the matching the specific field of the evaluation object in the first standing book data and the corresponding field of the evaluation object in the second standing book data specifically includes:
for an electric facility, matching an ID or line code or user identification field of the electric facility in the first ledger data with an ID or line code or user identification field of the electric facility in the second ledger data;
for a power supply special user, matching a user identification field of the power supply special user in the first standing book data with a user identification field of the power supply special user in the second standing book data;
and for the power supply voltage monitoring points, matching codes of the power supply voltage monitoring points in the first machine account data with codes of the power supply voltage monitoring points in the second machine account data.
Based on the above embodiment, the determining, for all successfully matched evaluation objects, whether the key fields of the evaluation objects in the online power quality monitoring system and the source service system are consistent to obtain a total number of consistent key fields in all successfully matched evaluation objects specifically includes:
for the electric power facilities, if the ID or the line code or the user identification field of the electric power facilities in the first account data is successfully matched with the ID or the line code or the user identification field of the electric power facilities in the second account data at the same time, judging whether the electric energy quality online monitoring system is consistent with the key fields of the electric power facilities in the source business system, and acquiring the number of the electric power facilities with consistent key fields as the total number of the consistent key fields in the electric power facilities with successful matching; specifically, the key field may be a commissioning date and the like.
For the power supply special users, if the user identification field of the power supply special user in the first account data is successfully matched with the user identification field of the power supply special user in the second account data, judging whether the key fields of the power quality online monitoring system and the power supply special user in the source business system are consistent, and acquiring the number of the power supply special users with all the consistent key fields as the total number of the consistent key fields of all the successfully matched power supply special users; specifically, the key field may be a commissioning date and the like.
For the power supply voltage monitoring points, if the codes of the power supply voltage monitoring points in the first account data and the codes of the power supply voltage monitoring points in the second account data are successfully matched, judging whether the key fields of the power quality online monitoring system and the power supply voltage monitoring points in the source service system are consistent, and acquiring the number of the power supply voltage monitoring points with the consistent key fields as the total number of the consistent key fields in all the successfully matched power supply voltage monitoring points; specifically, the key field may be a commissioning date and the like.
After the total number of the key fields in the data which can be matched in the power facility, the power supply public user, the power supply special user and the power supply voltage monitoring point is obtained, the consistency evaluation data of the evaluation objects in the power quality online monitoring system and the source service system can be obtained through the total number of the key fields which is consistent/the total number of the equipment of the evaluation objects in the power quality online monitoring system.
In summary, the embodiments of the present invention are directed to solving the problems in the prior art, such as: the method is characterized in that the data quality process of the power quality on-line monitoring system is controlled and managed by calculating and evaluating the integrity, consistency and intelligence of data and evaluating the data quality problem through the blood-related relationship between the account data of the power quality on-line monitoring system and the account data of a PMS system, a power utilization information acquisition system and a power supply voltage automatic acquisition system, and by comparing the blood-related data, the data quality process of the power quality on-line monitoring system is controlled and managed, and scientific and reliable statistical results are provided for a power grid, and providing quantitative basis for comprehensive plan decision.
The embodiment of the invention constructs a power data quality evaluation system, which comprises the following steps:
(1) determining the relevant systems required for evaluation: a source service system (a PMS system, a power utilization information acquisition system and a power supply voltage automatic acquisition system) and an electric energy quality on-line monitoring system.
(2) Determining an evaluation object: the transformer comprises main network 13 facilities (a lightning arrester, a current transformer, a voltage transformer, a bus, an overhead line, a cable line, an isolating switch, a wave trap, a combined electrical appliance, a transformer, a reactor, a coupling capacitor and a circuit breaker), a public distribution network distribution transformer, a pole-mounted transformer, a transformer substation, a power supply special user and a power supply voltage monitoring point.
(3) Determining an evaluation dimension: including an integrity dimension, an intelligence dimension, and a consistency dimension.
(4) Determining an evaluation index corresponding to each dimension: the standing book deviation rate, the standing book automatic integration proportion and the standing book attribute consistency rate. Aiming at different evaluation indexes under different evaluation dimensions, different evaluation rules are designed, and the method specifically comprises the following steps:
for the integrity dimension, the calculation rule of the standing book deviation rate is as follows: (total data of the power quality online monitoring system-total data of the source service system)/total data of the source service system.
For intelligent dimensions, the automatic integration proportion calculation rule is: the electric energy quality on-line monitoring system automatically integrates the total quantity of the machine accounts/the total quantity of the machine accounts in the electric energy quality on-line monitoring system.
For the consistency dimension, the calculation rule of the standing book attribute information consistency rate is as follows: and the quantity of the electric energy quality on-line monitoring systems/the total quantity of the ledgers of the electric energy quality on-line monitoring systems is consistent with the key field of the source system service system.
The embodiment of the invention realizes the data quality process control and management of the power quality on-line monitoring system, provides scientific and reliable statistical results for the power grid, and provides quantitative basis for comprehensive plan decision.
An embodiment of the present invention further provides an apparatus for checking power ledger data, including:
the data acquisition module is used for acquiring first account data of the power quality online monitoring system and second account data of the source service system;
the integrity evaluation module is used for acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data;
the intelligent evaluation module is used for acquiring intelligent evaluation data based on the total data volume of the standing book and the total data volume of the first standing book data, which are automatically integrated by the electric energy quality online monitoring system;
and the consistency evaluation module is used for matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to acquire consistency evaluation data.
The apparatus according to the embodiment of the present invention may be used to implement the technical solution of the embodiment of the power ledger data verification method shown in fig. 1, and the implementation principle and the technical effect are similar, which are not described herein again.
Fig. 2 is a schematic diagram of a framework of a power ledger data verification apparatus according to an embodiment of the present invention. Referring to fig. 2, an embodiment of the present invention provides an electric power standing book data checking apparatus, including: a processor (processor)210, a communication Interface (communication Interface)220, a memory (memory)230 and a bus 240, wherein the processor 210, the communication Interface 220 and the memory 230 complete communication with each other through the bus 240. Processor 210 may call logic instructions in memory 230 to perform methods comprising: acquiring first account data of an electric energy quality online monitoring system and second account data of a source service system; the first standing book data is the standing book data of the source business system automatically collected by the electric energy quality on-line monitoring system; acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data; acquiring intelligent evaluation data based on the total data volume of the standing book automatically integrated by the power quality online monitoring system and the total data volume of the standing book of the first standing book data; and matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to acquire consistency evaluation data.
An embodiment of the present invention discloses a computer program product, which includes a computer program stored on a non-transitory computer readable storage medium, the computer program including program instructions, when the program instructions are executed by a computer, the computer can execute the methods provided by the above method embodiments, for example, the method includes: acquiring first account data of an electric energy quality online monitoring system and second account data of a source service system; the first standing book data is the standing book data of the source business system automatically collected by the electric energy quality on-line monitoring system; acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data; acquiring intelligent evaluation data based on the total data volume of the standing book automatically integrated by the power quality online monitoring system and the total data volume of the standing book of the first standing book data; and matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to acquire consistency evaluation data.
Embodiments of the present invention provide a non-transitory computer-readable storage medium, which stores computer instructions, where the computer instructions cause the computer to perform the methods provided by the above method embodiments, for example, the methods include: acquiring first account data of an electric energy quality online monitoring system and second account data of a source service system; the first standing book data is the standing book data of the source business system automatically collected by the electric energy quality on-line monitoring system; acquiring integrity evaluation data based on the equipment data of the evaluation object in the first standing book data and the equipment data of the evaluation object in the second standing book data; acquiring intelligent evaluation data based on the total data volume of the standing book automatically integrated by the power quality online monitoring system and the total data volume of the standing book of the first standing book data; and matching the key field of the evaluation object in the first standing book data with the key field of the evaluation object in the second standing book data to acquire consistency evaluation data.
Those of ordinary skill in the art will understand that: the implementation of the above-described apparatus embodiments or method embodiments is merely illustrative, wherein the processor and the memory may or may not be physically separate components, i.e. may be located in one place, or may 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 can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as a usb disk, a removable hard disk, a ROM/RAM, a magnetic disk, an optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute the method according to the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.