CN106022640B - Electric quantity index checking system and method - Google Patents
Electric quantity index checking system and method Download PDFInfo
- Publication number
- CN106022640B CN106022640B CN201610383848.6A CN201610383848A CN106022640B CN 106022640 B CN106022640 B CN 106022640B CN 201610383848 A CN201610383848 A CN 201610383848A CN 106022640 B CN106022640 B CN 106022640B
- Authority
- CN
- China
- Prior art keywords
- information
- data
- server
- user
- electric quantity
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 230000005611 electricity Effects 0.000 claims abstract description 51
- 238000004458 analytical method Methods 0.000 claims abstract description 35
- 238000004140 cleaning Methods 0.000 claims abstract description 34
- 238000013075 data extraction Methods 0.000 claims abstract description 20
- 238000012544 monitoring process Methods 0.000 claims description 12
- 238000007405 data analysis Methods 0.000 claims description 8
- 238000000605 extraction Methods 0.000 claims description 6
- 230000002159 abnormal effect Effects 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000013500 data storage Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012098 association analyses Methods 0.000 description 1
- 238000012097 association analysis method Methods 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000001364 causal effect Effects 0.000 description 1
- 238000010219 correlation analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
- 238000012360 testing method 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
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to a system and a method for checking an electric quantity index, which comprises the steps of manually reading and recording index information of a user electric energy meter, and transmitting the information to a marketing system server; acquiring index information of a user electric energy meter through an intelligent power utilization information acquisition system, and storing the index information in a power utilization information acquisition server; data extraction is respectively carried out on the electric quantity information of users of the marketing system server and the electricity consumption information acquisition server, and the extracted electric quantity information is subjected to data cleaning and stored in the data server; by comparing and analyzing the electric quantity information of the marketing system and the electric quantity information acquired by the electricity utilization information and outputting the electric quantity information analysis result of the user, the method and the system greatly reduce the abnormal quantity of electricity utilization indexes, greatly reduce the problems of estimation, missing and error reading of a meter reader and obtain considerable economic benefit; the accuracy and integrity of the user profile are improved.
Description
Technical Field
The invention relates to the technical field of power maintenance, in particular to a system and a method for checking an electric quantity index.
Background
Along with the development of intelligent technology, smart electric meter obtains extensive application, and smart electric meter can have automatic electric quantity collection function, need not artificial mode and can obtain user's electric power operation information and electric quantity (use) information, and the work of checking meter in long-range can be realized to the cooperation of intelligent ammeter and intelligent system of checking meter, labour saving and time saving, the work load of the artifical meter reading that greatly reduces. However, the intelligent meter reading system also has a fault, and once the intelligent meter reading system has the fault, the current meter index of the day cannot be acquired, so that manual meter reading by a meter reader is needed, however, the meter reading by the meter reader has certain problems, and firstly, the phenomena of meter reading estimation and meter reading omission exist; secondly, the meter reader mistakes the meter reading index due to carelessness; thirdly, driven by benefits, the meter reader may have a phenomenon of intentionally modifying the index. This will have a negative impact on the operation of the grid: once a user finds that the meter reading index is inconsistent with the actual index, a power grid operation enterprise faces the risk of complaints, the normal power utilization order is seriously influenced, and the legal rights and interests of the power grid operation enterprise are damaged.
Disclosure of Invention
The purpose of the invention is: the electric quantity index checking system and method can accurately check the electric quantity of a power grid user and avoid the problems of estimation, missing and error reading.
In order to realize the purpose, the technical scheme adopted by the invention is as follows: a power index checking method comprises the following steps:
s100, recording index information of the user electric energy meter in a manual meter reading mode, and transmitting the index information of the user electric energy meter to a marketing system server;
s101, index information of the user electric energy meter is acquired through an intelligent electricity utilization information acquisition system, and the index information of the user electric energy meter acquired by the intelligent electricity utilization information acquisition system is stored in an electricity utilization information acquisition server;
s102, performing data extraction on the user electric quantity information in the marketing system server, performing data cleaning on the extracted electric quantity information, and storing the user electric quantity information after the data cleaning to a data server;
s103, performing data extraction on the user electric quantity information in the electricity utilization information acquisition server, performing data cleaning on the extracted electric quantity information, and storing the user electric quantity information subjected to data cleaning to a data server; and
and S104, comparing and analyzing the user electric quantity information stored in the step S102 with the user electric quantity information in the step S103, and outputting a user electric quantity information analysis result.
The invention also has the following features:
in the step S100, the electric quantity information of the user includes information for recording team information, meter reader information, meter book information, substation information, line information, district information, account information, copied book information, and meter reading index information, and the information is stored in the marketing system server.
In the step S102, the data extraction and cleaning of the user power information in the marketing system server includes the following steps:
s201, inputting a meter reading date and acquiring copied book information;
s202, calling an interface of a marketing system server according to the copied book in a circulating manner;
s203, judging whether the table data is changed or not, if not, returning to the step S202;
s204, if the meter reading data in the step S203 is meter reading data, judging whether other meter reading date data exist, and if not, returning to the step S202;
s205, if the data in the step S204 is other meter reading date data, judging non-zero index data, and if not, returning to the step S202;
s206, if the data in the step S205 is non-zero index data, judging whether the city and county codes are legal, if not, returning to the step S202;
s207, if the city and county code in the step S206 is legal, judging whether the meter reading number and the meter reader information are legal, and if the city and county code is illegal, returning to the step S202;
s208, if the meter reading number and the meter reader information in the step S207 are legal, judging whether the user number is empty, if so, returning to the step S202;
s209, if the user number is not null in the step S208, judging whether the meter asset number is null, if so, returning to the step S202;
and S210, if the metering asset number in the step S209 is not empty, storing the electricity quantity information data of the legal user into a data server.
In step S103, the data extraction and cleaning of the user power information in the power consumption information acquisition server includes the following steps:
s301, collecting the current meter reading date, and acquiring the information of the number of the extracted households on the current marketing day;
s302, calling an interface of the electricity consumption information acquisition server according to the meter reading date and the extracted user number information;
s303, judging whether the account number is in the marketing day data or not, if not, returning to the step S302;
s304, if the account number is in the marketing day data in the step S303, judging whether the meter asset number is in the marketing day data, if not, returning to the step S302;
s305, if the table asset number is in the marketing day data in the step S304, judging non-zero index data, and if not, returning to the step S302;
s306, if the data is non-zero index data in the step S305, judging whether the city and county codes are legal, and if the data is illegal, returning to the step S302;
s307, if the city and county codes are legal in the step S306, judging whether the collecting days are equal to the meter reading days, and if not, returning to the step S302;
s308, if the collection date and the meter reading date are equal in the step S307, judging whether a plurality of pieces of repeated data exist, and if not, storing the electric quantity information data of the legal user into a data server;
s309, if a plurality of pieces of repeated data exist in the step S308, retaining the latest time data, and then storing the legal user electricity quantity information data into the data server.
And the information analysis in the S104 comprises data parallel analysis, data clustering analysis and data deviation analysis, and the output analysis result comprises an index comparison monitoring result, an electric quantity peak-to-peak reduction monitoring result, an error compensation electric charge issuing monitoring result and a basic data rectification monitoring result.
The data server downloads the user electric quantity information of the marketing system server through HTTP service, and the data server downloads the user electric quantity information in the electric quantity information acquisition server through DBLINK protocol.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
an electricity quantity index checking system, characterized in that: comprises that
The marketing system server is used for storing the electric quantity information of the user recorded in a manual mode;
and the power consumption information acquisition server is used for storing the information of the electric quantity of the user acquired by the intelligent power consumption information acquisition system.
The data server is used for the receiver to store the electric quantity information of the user sent by the marketing system server and the electricity consumption information acquisition server;
the data server is internally provided with a data extraction and cleaning module which is used for extracting and cleaning the electric quantity information of the user stored in the data server;
the data server is also internally provided with a data analysis and comparison module which is used for receiving the electric quantity information of the extraction and cleaning treatment for analysis and comparison, and the data server outputs the analysis and comparison results output by the data analysis and comparison module.
The invention also has the following features:
the marketing system server is used for storing team information, meter reader information, meter reading book information, transformer substation information, line information, transformer area information, account information, copied book information and meter reading index information, and the electricity utilization information acquisition server is used for storing electricity utilization information of small customers and electricity utilization information of large customers.
The analyzing and comparing module comprises a data parallel analysis unit, a data clustering analysis unit and a data deviation analysis unit.
The data server downloads the user electric quantity information of the marketing system server through HTTP service, and the data server downloads the user electric quantity information in the electric quantity information acquisition server through DBLINK protocol.
Compared with the prior art, the invention has the technical effects that: the method comprises the steps that user electric quantity information is recorded in a manual mode and stored in a marketing system server, the information of the electric quantity of a user is collected by an intelligent electric quantity collection system and stored in an electric quantity collection server, the information of the electric quantity of the user recorded in the two modes is transmitted to a data storage server, and the data server performs extraction and cleaning operation on the information of the electric quantity of the two users, so that the number of abnormal changes of an electricity utilization index is greatly reduced, the problems of estimation, missing and error reading of a meter reader are greatly reduced, and considerable economic benefit is obtained; the accuracy and integrity of the user profile are improved.
Drawings
FIG. 1 is a logic block diagram of a power index checking method;
FIG. 2 is a logic diagram of data extraction and cleaning of user power information in a marketing system server;
fig. 3 is a logic diagram of data extraction and cleaning of the user power information in the power consumption information collection server 20;
fig. 4 is a block diagram of a power index checking system.
Detailed Description
The invention will be further explained with reference to fig. 1 to 4:
a power index checking method comprises the following steps:
s100, recording the index information of the user electric energy meter in a manual meter reading mode, and transmitting the index information of the user electric energy meter to a marketing system server 10;
s101, index information of a user electric energy meter is acquired through an intelligent electricity utilization information acquisition system, and an index information system of the electric energy meter acquired by the intelligent electricity utilization information acquisition system is stored in an electricity utilization information acquisition server 20;
s102, performing data extraction on the user electric quantity information in the marketing system server 10, performing data cleaning on the extracted electric quantity information, and storing the user electric quantity information after data cleaning to the data server 30;
s103, performing data extraction on the user electric quantity information in the electricity consumption information acquisition server 20, performing data cleaning on the extracted electric quantity information, and storing the user electric quantity information after data cleaning to the data server 30; and
and S104, comparing and analyzing the user electric quantity information stored in the step S102 with the user electric quantity information in the step S103, and outputting a user electric quantity information analysis result.
Recording user electric quantity information in a manual mode, storing the user electric quantity information in a marketing system server 10, storing the information of the user electric quantity acquired by an intelligent electric quantity acquisition system in an electric quantity acquisition server 20, transmitting the information of the user electric quantity recorded in the two modes to a data storage server 30, and extracting and cleaning the information of the two user electric quantities by the data server 30, so that the number of power utilization index variations is greatly reduced, the problems of estimation, missing and error of meter readers are greatly reduced, and considerable economic benefits are obtained; the accuracy and integrity of the user profile are improved.
As a preferred embodiment of the present invention, in step S100, the power information of the user includes information for recording a team group, a meter reader, a meter book, a substation, a line, a transformer area, an account, a copied book, and a meter reading index, and is stored in the marketing system server 10.
In the step S102, the data extraction and cleaning of the user power information in the marketing system server 10 includes the following steps:
s201, inputting a meter reading date and acquiring copied book information;
s202, calling an interface of the marketing system server 10 according to the copied book cycle;
s203, judging whether the table data is changed or not, if not, returning to the step S202;
s204, if the meter reading data in the step S203 is meter reading data, judging whether other meter reading date data exist, and if not, returning to the step S202;
s205, if the data in the step S204 is other meter reading date data, judging non-zero index data, and if not, returning to the step S202;
s206, if the data in the step S205 is non-zero index data, judging whether the city and county codes are legal, if not, returning to the step S202;
s207, if the city and county code in the step S206 is legal, judging whether the meter reading number and the meter reader information are legal, and if the city and county code is illegal, returning to the step S202;
s208, if the meter reading number and the meter reader information in the step S207 are legal, judging whether the user number is empty, if so, returning to the step S202;
s209, if the user number is not null in the step S208, judging whether the meter asset number is null, if so, returning to the step S202;
s210, if the meter asset number is not empty in step S209, storing the legal user power information data in the data server 30.
Marketing data is extracted by taking city and county as a unit according to the date of electricity charge issuing data, a request packet is obtained by adopting an Http Post in a data obtaining mode, the request packet is released by a background and then stored in a data current detail data buffer area of an index comparison system for synthesis, and the data can be guaranteed by correspondingly requesting according to the data packet.
In step S103, the data extraction and cleaning of the user power information in the power consumption information acquisition server 20 includes the following steps:
s301, collecting the current meter reading date, and acquiring the information of the number of the extracted households on the current marketing day;
s302, calling an interface of the electricity consumption information acquisition server 20 according to the meter reading date and the extracted user number information;
s303, judging whether the account number is in the marketing day data or not, if not, returning to the step S302;
s304, if the account number is in the marketing day data in the step S303, judging whether the meter asset number is in the marketing day data, if not, returning to the step S302;
s305, if the table asset number is in the marketing day data in the step S304, judging non-zero index data, and if not, returning to the step S302;
s306, if the data is non-zero index data in the step S305, judging whether the city and county codes are legal, and if the data is illegal, returning to the step S302;
s307, if the city and county codes are legal in the step S306, judging whether the collecting days are equal to the meter reading days, and if not, returning to the step S302;
s308, if the collection date and the meter reading date are equal in the step S307, judging whether a plurality of pieces of repeated data exist, and if not, storing the electric quantity information data of the legal user into the data server 30;
s309, if there are multiple pieces of duplicate data in step S308, retaining the latest time data, and then storing the legal user power information data in the data server 30.
The data are sorted and extracted as required by adopting a database linking mode, and the following technologies are adopted in the extraction to ensure the accuracy, consistency and integrity of the data; on the basis of marketing data in the current detail granularity, extracting according to the combined dimensions of city and county codes, marketing house numbers and dates, and ensuring that the extracted data are accurate; the index information attribute acquired by power utilization acquisition is consistent with the structure of the index comparison system data, and the data consistency is ensured through the data type; and the data integrity is ensured by the linkage service and the extraction in a database transaction mode.
And the information analysis in the S104 comprises data parallel analysis, data clustering analysis and data deviation analysis, and the output analysis result comprises an index comparison monitoring result, an electric quantity peak-to-peak reduction monitoring result, an error compensation electric charge issuing monitoring result and a basic data rectification monitoring result.
The index comparison system analyzes the marketing meter reading data and the electricity utilization acquisition data by adopting an association analysis method to obtain a reference conclusion, and association analysis is carried out by establishing association relations among the marketing household number, the electricity utilization acquisition system household number, the marketing meter asset number, the electricity utilization acquisition system meter number, the meter reading date and the acquisition date.
The association rule mining is that a certain regularity exists between values of two or more variables, and is called association. Data association is an important, discoverable class of knowledge that exists in databases. Associations are divided into simple associations, timing associations and causal associations. The purpose of the correlation analysis is to find out the hidden correlation network in the database. Generally, two thresholds, namely support degree and credibility, are used for measuring the correlation of the association rule, so that the mined rule is more in line with the requirement.
Clustering is to classify data into several categories according to similarity, where data in the same category are similar to each other and data in different categories are different. Clustering analysis can build macroscopic concepts, discover distribution patterns of data, and possibly correlations between data attributes.
In the index comparison system, a data snapshot can be established for a specific group, such as a certain cell, the power consumption is analyzed, and the power consumption distribution rule in one year is found.
The deviation comprises a lot of useful knowledge, a lot of abnormal conditions exist in the data in the database, and it is very important to find the abnormal conditions existing in the data in the database. The basic method of bias testing is to look for differences between observations and a reference.
The data server 30 downloads the user power information of the marketing system server 10 through the HTTP service, and the data server 30 downloads the user power information in the power information collection server 20 through the DBLINK protocol.
An electricity quantity index checking system comprises
The marketing system server 10 is used for storing the electric quantity information of the user recorded in a manual mode;
and the power utilization information acquisition server 20 is used for storing the information of the electric quantity of the user acquired by the intelligent power utilization information acquisition system.
The data server 30 is used for receiving and storing the electric quantity information of the user sent by the marketing system server 10 and the electricity consumption information acquisition server 20;
a data extraction and cleaning module 31 is arranged in the data server 30, and the data extraction and cleaning module 31 is used for extracting and cleaning the electric quantity information of the user stored in the data server 30;
the data server 30 is further provided with a data analysis and comparison module 32, the data analysis and comparison module 32 is used for receiving the electric quantity information of the extraction and cleaning processing for analysis and comparison, and the data server 30 outputs the analysis and comparison results output by the data analysis and comparison module 32.
The marketing system server 10 is used for storing team information, meter reader information, meter reading book information, transformer substation information, line information, transformer area information, account information, copied book information and meter reading index information, and the electricity utilization information acquisition server 20 is used for storing electricity utilization information of small customers and electricity utilization information of large customers.
The analyzing and comparing module 32 comprises a data parallel analysis unit, a data clustering analysis unit and a data deviation analysis unit.
The data server 30 downloads the user power information of the marketing system server 10 through the HTTP service, and the data server 30 downloads the user power information in the power information collection server 20 through the DBLINK protocol.
Claims (7)
1. An electricity quantity index checking method is characterized in that: the method comprises the following steps:
s100, recording the index information of the user electric energy meter in a manual meter reading mode, and transmitting the index information of the user electric energy meter to a marketing system server (10);
s101, index information of the user electric energy meter is acquired through an intelligent electricity utilization information acquisition system, and the index information of the user electric energy meter acquired by the intelligent electricity utilization information acquisition system is stored in an electricity utilization information acquisition server (20);
s102, performing data extraction on the user electric quantity information in the marketing system server (10), performing data cleaning on the extracted electric quantity information, and storing the user electric quantity information after data cleaning to the data server (30);
s103, performing data extraction on the user electric quantity information in the electricity consumption information acquisition server (20), performing data cleaning on the extracted electric quantity information, and storing the user electric quantity information after data cleaning to a data server (30); and
s104, comparing and analyzing the user electric quantity information stored in the step S102 with the user electric quantity information in the step S103, and outputting a user electric quantity information analysis result;
in the step S100, the electric quantity information of the user includes information for recording team information, meter reader information, meter book information, substation information, line information, district information, account information, copied book information, and meter reading index information, and the information is stored in the marketing system server (10);
in step S103, the data extraction and cleaning of the user power information in the power consumption information acquisition server (20) includes the following steps:
s301, collecting the current meter reading date, and acquiring the information of the number of the extracted households on the current marketing day;
s302, calling an interface of the electricity consumption information acquisition server (20) according to the meter reading date and the extracted user number information;
s303, judging whether the account number is in the marketing day data, if not, returning to the step S302;
s304, if the account number is in the marketing day data in the step S303, judging whether the meter asset number is in the marketing day data, if not, returning to the step S302;
s305, if the table asset number is in the marketing day data in the step S304, judging non-zero index data, and if not, returning to the step S302;
s306, if the index data is non-zero in the step S305, judging whether the city and county codes are legal or not, if the index data is illegal, returning to the step S302;
s307, if the city and county codes are legal in the step S306, judging whether the collecting days are equal to the meter reading days, and if not, returning to the step S302;
s308, if the collection date and the meter reading date are equal in the step S307, judging whether a plurality of pieces of repeated data exist, and if not, storing the electric quantity information data of the legal user into a data server (30);
s309, if a plurality of pieces of repeated data exist in the step S308, the latest time data is reserved, and then the legal user electricity quantity information data is stored in the data server (30).
2. The electricity quantity index checking method according to claim 1, wherein: in the step S102, the data extraction and cleaning of the user power information in the marketing system server (10) includes the following steps:
s201, inputting a meter reading date and acquiring copied book information;
s202, calling an interface of a marketing system server (10) according to the copied book cycle;
s203, judging whether the table data is changed or not, if not, returning to the step S202;
s204, if the meter reading data in the step S203 is meter reading data, judging whether other meter reading date data exist, if not, returning to the step S202;
s205, if the data in the step S204 is other meter reading date data, judging non-zero index data, and if not, returning to the step S202;
s206, if the data in the step S205 is non-zero index data, judging whether the city and county codes are legal or not, if not, returning to the step S202;
s207, if the city and county code in the step S206 is legal, judging whether the meter reading number and the meter reader information are legal, and if the city and county code is illegal, returning to the step S202;
s208, if the meter reading number and the meter reader information in the step S207 are legal, judging whether the user number is empty, if so, returning to the step S202;
s209, if the user number is not null in the step S208, judging whether the meter asset number is null, if so, returning to the step S202;
s210, if the meter asset number in the step S209 is not empty, storing the legal user electricity quantity information data into a data server (30).
3. The electricity quantity index checking method according to claim 1, wherein: and the information analysis in the S104 comprises data parallel analysis, data clustering analysis and data deviation analysis, and the output analysis result comprises an index comparison monitoring result, an electric quantity peak-to-peak reduction monitoring result, an error compensation electric charge issuing monitoring result and a basic data rectification monitoring result.
4. The electricity quantity index checking method according to claim 1, wherein: the data server (30) downloads the user electric quantity information of the marketing system server (10) through HTTP service, and the data server (30) downloads the user electric quantity information in the electric information acquisition server (20) through DBLINK protocol.
5. An electricity quantity index checking system constructed by the electricity quantity index checking method according to any one of claims 1 to 4, characterized in that: comprises that
The marketing system server (10) is used for storing the electric quantity information of the user recorded in a manual mode;
the electricity consumption information acquisition server (20) is used for storing the information of the electric quantity of the user acquired by the intelligent electricity consumption information acquisition system;
the data server (30) is used for receiving the electric quantity information of the user sent by the marketing system server (10) and the electricity consumption information acquisition server (20);
a data extraction and cleaning module (31) is arranged in the data server (30), and the data extraction and cleaning module (31) is used for extracting and cleaning the electric quantity information of the user stored in the data server (30);
the data server (30) is also internally provided with a data analysis and comparison module (32), the data analysis and comparison module (32) is used for receiving the electric quantity information of the extraction and cleaning treatment for analysis and comparison, and the data server (30) outputs the analysis and comparison results output by the data analysis and comparison module (32);
the marketing system server (10) is used for storing team information, meter reading person information, meter reading book information, transformer substation information, line information, transformer area information, account information, copied book information and meter reading index information, and the electricity utilization information acquisition server (20) is used for storing electricity utilization information of small customers and electricity utilization information of large customers.
6. The electricity quantity index checking system according to claim 5, wherein: the analyzing and comparing module (32) comprises a data parallel analysis unit, a data clustering analysis unit and a data deviation analysis unit.
7. The electricity quantity index checking system according to claim 5, wherein: the data server (30) downloads the user electric quantity information of the marketing system server (10) through HTTP service, and the data server (30) downloads the user electric quantity information in the electric information acquisition server (20) through DBLINK protocol.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610383848.6A CN106022640B (en) | 2016-06-01 | 2016-06-01 | Electric quantity index checking system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610383848.6A CN106022640B (en) | 2016-06-01 | 2016-06-01 | Electric quantity index checking system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106022640A CN106022640A (en) | 2016-10-12 |
| CN106022640B true CN106022640B (en) | 2021-10-26 |
Family
ID=57089433
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610383848.6A Active CN106022640B (en) | 2016-06-01 | 2016-06-01 | Electric quantity index checking system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106022640B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106779400A (en) * | 2016-12-13 | 2017-05-31 | 国家电网公司 | Method of user's electricity index contrast with analyzing |
| CN109460498A (en) * | 2018-11-07 | 2019-03-12 | 广州小天软件有限公司 | A kind of verification of data method and device |
| CN111383428B (en) * | 2020-05-29 | 2020-09-11 | 成都千嘉科技有限公司 | Online meter state monitoring and early warning method |
| CN112529653A (en) * | 2020-12-04 | 2021-03-19 | 广东电网有限责任公司 | Method for automatically checking return material information by intelligent system and intelligent system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102545213A (en) * | 2012-01-11 | 2012-07-04 | 藁城市供电公司 | System and method for managing line loss of power grid in real time |
| CN103713275A (en) * | 2013-10-24 | 2014-04-09 | 国网安徽省电力公司 | Method judging electric energy meter metering inaccuracy abnormities based on multidimensional association rule algorithm |
| CN105354268A (en) * | 2015-10-27 | 2016-02-24 | 国网山东省电力公司济南供电公司 | Meter reading data management system |
| CN105373877A (en) * | 2015-09-14 | 2016-03-02 | 江苏南瑞通驰自动化系统有限公司 | Electricity utilization trend anomaly suspicion analysis and anti-electric-larceny monitoring system |
-
2016
- 2016-06-01 CN CN201610383848.6A patent/CN106022640B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102545213A (en) * | 2012-01-11 | 2012-07-04 | 藁城市供电公司 | System and method for managing line loss of power grid in real time |
| CN103713275A (en) * | 2013-10-24 | 2014-04-09 | 国网安徽省电力公司 | Method judging electric energy meter metering inaccuracy abnormities based on multidimensional association rule algorithm |
| CN105373877A (en) * | 2015-09-14 | 2016-03-02 | 江苏南瑞通驰自动化系统有限公司 | Electricity utilization trend anomaly suspicion analysis and anti-electric-larceny monitoring system |
| CN105354268A (en) * | 2015-10-27 | 2016-02-24 | 国网山东省电力公司济南供电公司 | Meter reading data management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106022640A (en) | 2016-10-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110097297B (en) | Multi-dimensional electricity stealing situation intelligent sensing method, system, equipment and medium | |
| Haben et al. | Analysis and clustering of residential customers energy behavioral demand using smart meter data | |
| CN106022640B (en) | Electric quantity index checking system and method | |
| CN110389269B (en) | Low-voltage distribution area topological relation identification method and device based on current optimization matching | |
| CN105426980B (en) | Power distribution network health index assessment engineering application system | |
| CN109120429B (en) | Risk identification method and system | |
| CN105354697A (en) | Financial account rule base based automatic online auditing method and system | |
| CN112739572A (en) | Detecting an electric vehicle charging at a premises | |
| CN109359868A (en) | A kind of construction method and system of power grid user portrait | |
| CN111090643B (en) | Mass electricity consumption data mining method based on data analysis system | |
| CN110532301B (en) | Audit method, system and readable storage medium | |
| CN110288451B (en) | Financial reimbursement method, system, equipment and storage medium | |
| CN111177208A (en) | Power consumption abnormity detection method based on big data analysis | |
| CN115423429A (en) | Multimode integrated distribution network operation system based on image and sound information | |
| CN108304990B (en) | Power failure sensitivity pre-judging method and system | |
| CN109064211B (en) | Marketing business data analysis method and device and server | |
| CN112631889B (en) | Portrayal method, device, equipment and readable storage medium for application system | |
| CN110188255A (en) | Power consumer Behavior mining method and system based on the shared fusion of business datum | |
| CN106651093A (en) | Smart re-check management and control method used for low voltage set copy system | |
| CN106127602B (en) | Electricity stealing identification method and device based on reduction outlier algorithm | |
| CN112613711A (en) | Water affair big data index management method and system based on six analysis methods | |
| CN114723554B (en) | Abnormal account identification method and device | |
| CN112132631A (en) | Label electricity utilization management method based on power customer portrait | |
| Carrasco-Jiménez et al. | Detection of anomalous patterns in water consumption: An overview of approaches | |
| CN107194529B (en) | Power distribution network reliability economic benefit analysis method and device based on mining technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |