CN103631900A - Data comparing method based on main gateway and standby gateway comparison - Google Patents
Data comparing method based on main gateway and standby gateway comparison Download PDFInfo
- Publication number
- CN103631900A CN103631900A CN201310590530.1A CN201310590530A CN103631900A CN 103631900 A CN103631900 A CN 103631900A CN 201310590530 A CN201310590530 A CN 201310590530A CN 103631900 A CN103631900 A CN 103631900A
- Authority
- CN
- China
- Prior art keywords
- critical point
- data
- comparison
- standby
- metering
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 23
- 230000002159 abnormal effect Effects 0.000 claims abstract description 12
- 238000004519 manufacturing process Methods 0.000 claims abstract description 4
- 238000004458 analytical method Methods 0.000 claims description 4
- 230000000052 comparative effect Effects 0.000 claims description 3
- 238000009472 formulation Methods 0.000 claims description 3
- 239000000203 mixture Substances 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 3
- 238000012544 monitoring process Methods 0.000 abstract description 3
- 230000000694 effects Effects 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- 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/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention aims to provide a data comparing method based on main gateway and standby gateway comparison. The data comparing method comprises the following steps that main gateway models and standby gateway models are set, and data comparison objects are determined; specified characteristic data of assigned metered objects are extracted from a production database according to the requirements for model setting and data reduction is completed; thresholds used for judging whether data comparison results are reasonable or not are set; the metered objects with abnormal comparison results are screened out; warning is conducted when the situation that the comparison results of data comparison are abnormal occurs. The data comparing method is a multi-dimensional data monitoring method, can achieve the effect that for each metered object, one or more metered objects related to the metered object physically can be found out, electric quantity differences of all the metered objects are only errors caused by circuit losses, transformer losses or metering devices, whether the related metered objects are metered accurately or not can be found out by comparing the electric quantity differences of the metered objects, and therefore data exceptions can be found out more efficiently, more quickly and more accurately.
Description
Technical field
The present invention relates to comparing field, specifically refer to that providing a kind of compares the data comparison method of carrying out based on database schema and active and standby critical point.
Background technology
Developing rapidly of senior measurement system (AMI), has higher requirement to the quality of data of continuous data and accuracy etc.The management method of existing mass data is a lot, such as setting up data warehouse or Data Mart system etc., the magnanimity that realizes data is concentrated, computing, and carries out on this basis data mining, data analysis and application etc., and all these take data accurate be prerequisite.Take electric quantity data as example, source data represents and need to pass through a plurality of links such as data acquisition, data transmission and data calculating to system, in data acquisition, may there is because communication abnormality, table meter are abnormal etc. data exception, may there is loss of data etc. in data transmission procedure, only have all links all to complete accurately and efficiently guarantee data high-quality.
Part measure data management system and terminal have possessed simple comparing function, by comparing and judge that whether data are reasonable etc. with historical data, there is significant limitation, such as data characteristics must meet historical law, can not there is sudden change etc. in data, can not accurately judge, any reliable suggestion more can not be provided.
Summary of the invention
The object of the present invention is to provide a kind of data comparison method based on the comparison of active and standby critical point, it is a kind of data monitoring method of various dimensions, the method is measured object to each, the metering object that can find one or more to be physically associated, electric weight differences of these metering objects are the error that causes of line loss, transformer loss or measuring apparatus etc., by relatively these measure the electric weight difference of objects, just can find whether accurate-metering of these metering objects that are associated, thereby find more efficiently, fast and accurately data exception.
Object of the present invention can realize by following technical measures:
A data comparison method based on the comparison of active and standby critical point, is characterized in that comprising the following steps:
(1) main critical point and standby critical point model are set;
(2) requirement arranging according to model is from Production database extracted data, and completes data preparation;
(3) arrange and judge whether reasonably threshold values of comparing result;
(4) filter out the abnormal metering object of comparison result: the regulation arranging according to model, main critical point out of data pick-up and the characteristic at standby critical point are compared, if the characteristic comparative result at main critical point and standby critical point surpasses the regulation that threshold values arranges, think that this comparison result is abnormal; Otherwise comparison result is normal;
(5) to the comparison result of comparing, be that abnormal situation is carried out alarming processing.
The setting of the model of described step (1) comprises and main critical point and standby critical point metering object is set, sets the logical relation between metering object, and comparing object.
Described main critical point and standby critical point model be physically associated, the difference negligible metering object of metering between result; Described main critical point model refers to the metering object for electric weight clearing; Described standby critical point model refers to the metering object for the main critical point metering of assistant analysis result accuracy; Described metering is to liking single metering point or a plurality of stoichiometric point according to the combination of certain logic relation.
Described comparing object refers to the characteristic of the metering object for analyzing; Described characteristic comprises degree and electric weight at the bottom of the ammeter that measures object.
The data that extract in described step (2) refer to the specific characteristic data of devise a stratagem amount object.
Data preparation in described step (2) refers to that the logical relation arranging between the metering object of formulation according to model calculates the characteristic at main critical point and standby critical point.
Described threshold values comprises two kinds of absolute value and relative values.
The present invention contrasts prior art, and tool has the following advantages:
1. changed by the traditional concept of data rule interpretation data accuracy, fully in conjunction with major status, increased more reasonable and data comparison method accurately.
2. more accurately, reliably, comparison result can be used for monitoring field equipment state to comparing result.
Accompanying drawing explanation
Fig. 1 is data comparison method process flow diagram of the present invention;
Fig. 2 is the substation structure schematic diagram that need to carry out comparing.
Embodiment
The data comparison method that the present invention is based on the comparison of active and standby critical point below in conjunction with accompanying drawing explanation, comprises the following steps:
(1) main critical point and standby critical point model are set, specified data comparison object; The setting of model comprises main critical point and standby critical point metering object is set, and sets the logical relation between metering object, and comparing object;
Described main critical point and standby critical point model refer to be physically associated, the difference negligible metering object of metering between result; Described main critical point model refers to the metering object for electric weight clearing; Described standby critical point model refers to the metering object for the main critical point metering of assistant analysis result accuracy; Described metering is to liking single metering point or a plurality of stoichiometric point according to the logical relation combination of formulating;
Described comparing object refers to the characteristic of the metering object for analyzing; Described characteristic comprises degree and electric weight at the bottom of the ammeter that measures object.
(2) the specific characteristic data of specifying metering object are extracted in the requirement arranging according to model from Production database, and complete data preparation;
Described data preparation refers to that the logical relation arranging between the metering object of formulation according to model calculates the characteristic at main critical point and standby critical point.
(3) arrange and judge whether reasonably threshold values of comparing result;
According to experience and theoretical analysis, arrange one reasonably for judging whether reasonably threshold values of comparing result, described threshold values comprises two kinds of absolute value and relative values.
(4) filter out the abnormal metering object of comparison result: the regulation arranging according to model, main critical point out of data pick-up and the characteristic at standby critical point are compared, if the characteristic comparative result at main critical point and standby critical point surpasses the regulation that threshold values arranges, think that this comparison result is abnormal; Otherwise comparison result is normal;
(5) to the comparison result of comparing, be that abnormal situation is carried out alarming processing.
Transformer station's schematic diagram, can contrast the accuracy of electric weight by the comparison of active and standby critical point as shown in Figure 2, and in Fig. 2, square sign place is stoichiometric point.Suppose 2 main transformer high-pressure side stoichiometric points of the A of transformer station, also 2201 and 2202 be main critical point in figure, standby critical point can have two kinds, standby critical point one: 3 outlet circuit stoichiometric points of the A of transformer station side are also AC A-wire (A of transformer station side), AC second line (A of transformer station side) and AB line (A of transformer station side); Standby critical point two: 3 outlet circuit offside stoichiometric points of the A of transformer station side are also AC A-wire (C of transformer station side), AC second line (C of transformer station side) and AB line (B of transformer station side).Main critical point and standby critical point one metering electric weight difference are bus loss, and main critical point and standby critical point two metering electric weight differences are bus loss and line loss, and the shared ratio of these losses is very little, also can estimate.Therefore, whether accurate to comparing metering electric weight by main critical point and standby critical point electricity ratio.In like manner, also can, by circuit two ends stoichiometric point, such as AC A-wire (A of transformer station side) and AC A-wire (C of transformer station side), as active and standby critical point, carry out comparing.
Embodiments of the present invention are not limited to this; under the above-mentioned basic fundamental thought of the present invention prerequisite; modification, replacement or the change to other various ways that content of the present invention is made according to the ordinary skill knowledge of this area and customary means, within all dropping on rights protection scope of the present invention.
Claims (7)
1. a data comparison method of comparing based on active and standby critical point, is characterized in that comprising the following steps:
(1) main critical point and standby critical point model are set;
(2) requirement arranging according to model is from Production database extracted data, and completes data preparation;
(3) arrange and judge whether reasonably threshold values of comparing result;
(4) filter out the abnormal metering object of comparison result: the regulation arranging according to model, main critical point out of data pick-up and the characteristic at standby critical point are compared, if the characteristic comparative result at main critical point and standby critical point surpasses the regulation that threshold values arranges, think that this comparison result is abnormal; Otherwise comparison result is normal;
(5) to the comparison result of comparing, be that abnormal situation is carried out alarming processing.
2. the data comparison method based on the comparison of active and standby critical point according to claim 1, it is characterized in that: the setting of the model of described step (1) comprises and main critical point and standby critical point metering object is set, sets the logical relation between metering object, and comparing object.
3. the data comparison method based on the comparison of active and standby critical point according to claim 1 and 2, is characterized in that: described main critical point and standby critical point model are the negligible metering objects of difference that be physically associated, between metering result; Described main critical point model refers to the metering object for electric weight clearing; Described standby critical point model refers to the metering object for the main critical point metering of assistant analysis result accuracy; Described metering is to liking single metering point or a plurality of stoichiometric point according to the combination of certain logic relation.
4. the data comparison method based on the comparison of active and standby critical point according to claim 2, is characterized in that: described comparing object refers to the characteristic of the metering object for analyzing; Described characteristic comprises degree and electric weight at the bottom of the ammeter that measures object.
5. the data comparison method based on the comparison of active and standby critical point according to claim 1, is characterized in that: the data that extract in described step (2) refer to the specific characteristic data of devise a stratagem amount object.
6. the data comparison method based on the comparison of active and standby critical point according to claim 1, is characterized in that: the data preparation in described step (2) refers to that the logical relation arranging between the metering object of formulation according to model calculates the characteristic at main critical point and standby critical point.
7. the data comparison method based on the comparison of active and standby critical point according to claim 1, is characterized in that: described threshold values comprises two kinds of absolute value and relative values.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310590530.1A CN103631900A (en) | 2013-11-20 | 2013-11-20 | Data comparing method based on main gateway and standby gateway comparison |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310590530.1A CN103631900A (en) | 2013-11-20 | 2013-11-20 | Data comparing method based on main gateway and standby gateway comparison |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103631900A true CN103631900A (en) | 2014-03-12 |
Family
ID=50212942
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310590530.1A Pending CN103631900A (en) | 2013-11-20 | 2013-11-20 | Data comparing method based on main gateway and standby gateway comparison |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103631900A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105515876A (en) * | 2015-12-29 | 2016-04-20 | 国网浙江省电力公司 | Data link monitoring device and data link monitoring method |
| CN106291253A (en) * | 2016-09-23 | 2017-01-04 | 国网天津市电力公司 | A kind of anti-electricity-theft early warning analysis method |
| CN109446233A (en) * | 2018-09-29 | 2019-03-08 | 广东电网有限责任公司 | A kind of intelligent control method based on line loss dynamic management |
| CN111858701A (en) * | 2020-06-23 | 2020-10-30 | 国网福建省电力有限公司 | Supply and consumption electricity monitoring method based on detail gateway statistics |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030212678A1 (en) * | 2002-05-10 | 2003-11-13 | Bloom Burton H. | Automated model building and evaluation for data mining system |
| CN101446914A (en) * | 2007-11-26 | 2009-06-03 | 阿里巴巴集团控股有限公司 | Database monitoring method and device |
| CN102116857A (en) * | 2010-12-31 | 2011-07-06 | 江苏省电力公司 | Method for checking electric quantity at power grid gate |
| CN102355381A (en) * | 2011-08-18 | 2012-02-15 | 网宿科技股份有限公司 | Method and system for predicting flow of self-adaptive differential auto-regression moving average model |
| CN102508833A (en) * | 2011-09-22 | 2012-06-20 | 用友软件股份有限公司 | Data monitoring device and data monitoring method |
| CN102930373A (en) * | 2012-09-29 | 2013-02-13 | 河北省食品质量监督检验研究院 | Safety risk monitoring and early warning method for dairy products |
-
2013
- 2013-11-20 CN CN201310590530.1A patent/CN103631900A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030212678A1 (en) * | 2002-05-10 | 2003-11-13 | Bloom Burton H. | Automated model building and evaluation for data mining system |
| CN101446914A (en) * | 2007-11-26 | 2009-06-03 | 阿里巴巴集团控股有限公司 | Database monitoring method and device |
| CN102116857A (en) * | 2010-12-31 | 2011-07-06 | 江苏省电力公司 | Method for checking electric quantity at power grid gate |
| CN102355381A (en) * | 2011-08-18 | 2012-02-15 | 网宿科技股份有限公司 | Method and system for predicting flow of self-adaptive differential auto-regression moving average model |
| CN102508833A (en) * | 2011-09-22 | 2012-06-20 | 用友软件股份有限公司 | Data monitoring device and data monitoring method |
| CN102930373A (en) * | 2012-09-29 | 2013-02-13 | 河北省食品质量监督检验研究院 | Safety risk monitoring and early warning method for dairy products |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105515876A (en) * | 2015-12-29 | 2016-04-20 | 国网浙江省电力公司 | Data link monitoring device and data link monitoring method |
| CN106291253A (en) * | 2016-09-23 | 2017-01-04 | 国网天津市电力公司 | A kind of anti-electricity-theft early warning analysis method |
| CN109446233A (en) * | 2018-09-29 | 2019-03-08 | 广东电网有限责任公司 | A kind of intelligent control method based on line loss dynamic management |
| CN111858701A (en) * | 2020-06-23 | 2020-10-30 | 国网福建省电力有限公司 | Supply and consumption electricity monitoring method based on detail gateway statistics |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104794206B (en) | A kind of substation data QA system and method | |
| CN104198980A (en) | Accuracy evaluation system for digital electric energy meter | |
| CN105092917B (en) | A kind of electricity anti-theft system | |
| CN103941079B (en) | Power distribution network PT on-line monitoring and fault diagnosis system | |
| CN202758062U (en) | Overall metering error detection system of digital transformer station electric energy metering device | |
| CN103631900A (en) | Data comparing method based on main gateway and standby gateway comparison | |
| CN105785306A (en) | Voltage transformer on-line group calibration method and apparatus | |
| CN105425107B (en) | A kind of method and its system of active power distribution network fault diagnosis and location | |
| CN108470246A (en) | A kind of planning distribution network reliability index evaluating method of feature based parameter | |
| CN102280874A (en) | Platform-area line loss rate detecting system | |
| Lo et al. | Non-technical loss detection using smart distribution network measurement data | |
| CN104215931A (en) | Automatic electric energy meter calibrating device period investigation method | |
| CN105044649B (en) | A kind of current transformer error horizontal dynamic detection method and system | |
| CN106229969A (en) | Electric network element based on cumulative statistics line loss per unit loss abnormality judgment method | |
| CN104052053B (en) | Based on the power distribution network double line terminal section impedance analysis method of Linear Regression Model in One Unknown | |
| CN103837777A (en) | Method and system for power quality assessment of power supply system | |
| CN105510864B (en) | A kind of detection method of electric energy meter error metering | |
| CN105242231A (en) | Digital electric energy measurement performance detection and tracing method and closed-loop system | |
| CN114152896A (en) | Misalignment replacing system based on acquisition platform | |
| CN105068033B (en) | The calibration equipment and its method of a kind of The Rogowski Optical Current Transformer | |
| CN204086516U (en) | A kind of digitalized electrical energy meter accuracy evaluation system | |
| CN104155543B (en) | Transmission line parameter identification method based on power loss method | |
| CN103412091B (en) | pH value measuring method and device | |
| CN205384360U (en) | BMS current parameter calibrating device | |
| CN204679570U (en) | Secondary equipment of intelligent converting station Commissioning Analysis platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140312 |
|
| WD01 | Invention patent application deemed withdrawn after publication |