CN103577550A - Grid equipment data verification method - Google Patents
Grid equipment data verification method Download PDFInfo
- Publication number
- CN103577550A CN103577550A CN201310485502.3A CN201310485502A CN103577550A CN 103577550 A CN103577550 A CN 103577550A CN 201310485502 A CN201310485502 A CN 201310485502A CN 103577550 A CN103577550 A CN 103577550A
- Authority
- CN
- China
- Prior art keywords
- rule
- data
- verification
- data verification
- grid equipment
- 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 25
- 238000013524 data verification Methods 0.000 title claims abstract description 18
- 238000012795 verification Methods 0.000 claims abstract description 21
- 238000013499 data model Methods 0.000 claims description 5
- 230000001174 ascending effect Effects 0.000 claims description 3
- 230000008859 change Effects 0.000 claims description 3
- 230000008569 process Effects 0.000 abstract description 4
- 230000007547 defect Effects 0.000 abstract 1
- 238000004458 analytical method Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 230000007812 deficiency Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 230000001747 exhibiting effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 238000012372 quality testing Methods 0.000 description 1
- 239000000126 substance Substances 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/284—Relational databases
-
- 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
-
- 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)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Primary Health Care (AREA)
- Marketing (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention aims to provide a grid equipment data verification method. The grid equipment data verification method is characterized by comprising the following steps of establishing a data verification and collocation model, including establishing an equipment attribute list, an equipment attribute rule contrast list and a rule list; performing a data verification and collocation process, i.e. finding a verification rule according to an equipment type and checking whether data are standard or not. The invention aims to provide a grid data verification and collocation method which is more flexibly expanded in order to overcome the defects of the current grid GIS data verification and collocation method. The method is used for establishing a verification rule collocating model in a relation database and maintaining corresponding relation between each type of grid equipment and a verification rule.
Description
Technical field
The present invention relates to electrical network Spatial GIS (GIS) and electric network information maintenance technology field, a kind of " generating-transmission of electricity-power transformation-distribution " the full electric network equipment that relates in particular to is at GIS job platform data check collocation method.
Background technology
Along with GIS technology develops in electrical network field, each province, districts and cities set up electrical network Spatial GIS (GIS) successively, prefectures and cities office utilizes frequency also more and more higher to electrical network infrastructure device attribute data, auxiliary turn power supply plan analysis, industry expand auxiliaryly apply to install, line loss is calculated, quasi real time the construction of the Premium Features such as data exhibiting has been made good try to the Operation and management of power distribution network.
Yet because first stage of construction grid equipment data check does not have unified standard and each basic GIS platform bottom layer realization mechanism different, when increment equipment is issued, likely problem data is submitted in operation version, cause in the use procedure of these Premium Features, the incorrect situation of its analysis result also can occur, and this has a strong impact on power supply reliability and customer satisfaction.The analysis found that in the attribute data of basic unit's grid equipment, still to have data quality problem and lack the data of typing are carried out to quality testing, cause data to enter after system, produce various data quality problems and be basic reason (such as: fill in that attribute data is imperfect, fill substance mistake etc.).In order to solve this problem, the quality verification mode of studying more reliable grid equipment attribute data is extremely necessary.
At present, power grid GIS platform device data check, is mainly that following two kinds of modes realize: write the verification of code implementation rule and the verification of system reading and saving configuration file.
Code implementation rule verification: this is very original implementation, at power grid GIS platform, pass through the verification of code implementation rule, after pole line editor preservation, code needs the redaction rule judgement pole line two ends can not unsettled (can there is no annexation), the equipment that pole line connects must be (such as pole line can not directly connect with transformer) defining in topological model, and electric pressure field value must be the value in enumerated table etc.This mode maintenance cost is high, is not easy to configuration and later expansion.
Profile rules verification: this mode is mainly saved in XML file, be extensibility, structuring and the cross-platform feature of utilizing XML, set up the data check allocation models based on XML, but device category be various, corresponding multiple rule, being not easy to of many-to-many relationship checked and safeguarded.
Summary of the invention
The object of the invention is to solve the deficiency of existing power grid GIS data check collocation method, a kind of electric network data verification collocation method of more flexible, flexible expansion is provided.For setting up verification rule configuration model at relational database, safeguard every class grid equipment and both corresponding relations of verification rule.
The technical scheme that the present invention specifically takes comprises the steps:
One, build data check allocation models:
Data check allocation models comprises device attribute table, the device attribute rule table of comparisons and rule list.
1) device attribute table: device attribute table is the device attribute table recording in existing power grid GIS data model, and the data check allocation models of structure does not change existing power grid GIS data model.
2) the device attribute rule table of comparisons: device attribute rule table of comparisons recording unit table name, device field (DFLD) and corresponding number of regulation (ID), also comprise associate device tables of data and rule list, wherein, device field (DFLD) can corresponding many rules, as: affiliated power supply station code field is character type, can corresponding field length be less than to equal 18 rule and content and can only comprise digital two rules.
3) rule list: rule list is record data verification rule, and concrete form is the SQL statement that records verification.
Two, data check layoutprocedure
Data check layoutprocedure is found out verification rule according to device type, checks whether standard of data, specifically comprises as follows:
1) according to device type title, at equipment Regulation table, search corresponding rule, service regeulations sequence number ascending sort, draws rule ID set.
2), according to rule ID set, in rule list, search corresponding rule.
3) circulation searching regular collection out.
4), according to the data of every rule verification corresponding device, if there is check errors, record and export prompting.
Accompanying drawing explanation
Fig. 1 is data check illustraton of model;
The process flow diagram of Fig. 2 data check layoutprocedure.
Embodiment
Below in conjunction with accompanying drawing, grid equipment data check collocation method of the present invention is described further, the present invention is applied to " generating-transmission of electricity-power transformation-distribution " full electric network equipment at the data check of GIS job platform, specifically comprises the steps:
One, build data check allocation models:
As shown in Figure 1, data check allocation models comprises device attribute table, the device attribute rule table of comparisons and rule list.
1) device attribute table: device attribute table is recording unit attribute list in existing power grid GIS data model, and the data check allocation models of structure can not change existing model.
2) the device attribute rule table of comparisons: device attribute rule table of comparisons recording unit table name, device field (DFLD) and corresponding rule ID, associate device tables of data and rule list, device field (DFLD) can corresponding many rules, as: affiliated power supply station code field is character type, can corresponding field length be less than to equal 18 rule and content and can only comprise digital two rules.
3) rule list: rule list is record data verification rule, records the SQL statement of verification.
Two, data check layoutprocedure
Data check layoutprocedure is found out verification rule according to device type, checks whether standard of data, as shown in Figure 2, specifically comprises as follows:
1) according to device type title, at equipment legend table, search corresponding rule, service regeulations sequence number ascending sort, draws rule ID set.
2), according to rule ID set, in rule list, search corresponding rule.
3) circulation searching regular collection out.
4), according to every rule calibration equipment data, there is wrong record output prompting.
This invention is the deficiency for existing power grid GIS data check collocation method, and of proposition is more flexible, the electric network data verification collocation method of flexible expansion.At relational database, set up verification rule configuration model, safeguard every class grid equipment and both corresponding relations of verification rule.
Those skilled in the art should understand the present invention still can have the variation of various embodiments.Though above-described embodiment with and characteristic to describe in detail as above, needing to understand can have multiple variation under spirit of the present invention and category, substitutes and revises.Moreover, flow process in this instructions, machine, manufactures, and the material forming, means, the specific embodiment of method and step is not in order to limit range of application of the present invention.Those of ordinary skills can understand the flow process of the embodiment of the present invention easily, and machine is manufactured, the material forming, means, method, or step, in preexist or improvement after a while, according to the present invention, applied embodiment is to complete close function or to reach close result.
Claims (5)
1. a grid equipment data verification method, is characterized in that comprising following content:
Build data check allocation models: comprise and build device attribute table, the device attribute rule table of comparisons and rule list;
Data check layoutprocedure: find out verification rule according to device type, check whether standard of data.
2. grid equipment data verification method as claimed in claim 1, is characterized in that: described device attribute table is the device attribute table recording in existing power grid GIS data model, and the data check allocation models of structure does not change existing power grid GIS data model.
3. grid equipment data verification method as claimed in claim 1, it is characterized in that: the described device attribute rule table of comparisons is for recording unit table name, device field (DFLD) and corresponding number of regulation (ID), also comprise associate device tables of data and rule list, wherein, corresponding one or more rule of device field (DFLD).
4. grid equipment data verification method as claimed in claim 1, is characterized in that: described rule list is record data verification rule, and concrete form is the SQL statement that records verification.
5. grid equipment data verification method as claimed in claim 1, is characterized in that: described data check layoutprocedure comprises the steps:
1) according to device type title, at equipment Regulation table, search corresponding rule, service regeulations sequence number ascending sort, draws rule ID set.
2), according to rule ID set, in rule list, search corresponding rule.
3) circulation searching regular collection out.
4), according to the data of every rule verification corresponding device, if there is check errors, record and export prompting.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310485502.3A CN103577550A (en) | 2013-10-16 | 2013-10-16 | Grid equipment data verification method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310485502.3A CN103577550A (en) | 2013-10-16 | 2013-10-16 | Grid equipment data verification method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103577550A true CN103577550A (en) | 2014-02-12 |
Family
ID=50049326
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310485502.3A Pending CN103577550A (en) | 2013-10-16 | 2013-10-16 | Grid equipment data verification method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103577550A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104391903A (en) * | 2014-11-14 | 2015-03-04 | 广州科腾信息技术有限公司 | Distributed storage and parallel calculation-based power grid data quality detection method |
| CN105389300A (en) * | 2015-10-27 | 2016-03-09 | 云南电网有限责任公司 | Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data |
| CN105844546A (en) * | 2016-04-20 | 2016-08-10 | 国网四川省电力公司 | Power distribution network information interaction method based on GIS mirror image technology |
| CN106600461A (en) * | 2016-12-15 | 2017-04-26 | 国网浙江宁波市鄞州区供电公司 | data verification method, device and equipment |
| CN107609016A (en) * | 2017-08-03 | 2018-01-19 | 南京南瑞集团公司 | Electricity transaction data accuracy method of calibration based on expression parsing |
| CN109377471A (en) * | 2018-08-21 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of picture verification |
| CN112580186A (en) * | 2020-11-03 | 2021-03-30 | 国网江苏省电力有限公司营销服务中心 | Method for generating marketing side power supply equipment GIS graph |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040181543A1 (en) * | 2002-12-23 | 2004-09-16 | Canon Kabushiki Kaisha | Method of using recommendations to visually create new views of data across heterogeneous sources |
| CN102819766A (en) * | 2011-06-09 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method, device and enterprise system for checking forms |
-
2013
- 2013-10-16 CN CN201310485502.3A patent/CN103577550A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040181543A1 (en) * | 2002-12-23 | 2004-09-16 | Canon Kabushiki Kaisha | Method of using recommendations to visually create new views of data across heterogeneous sources |
| CN102819766A (en) * | 2011-06-09 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method, device and enterprise system for checking forms |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104391903A (en) * | 2014-11-14 | 2015-03-04 | 广州科腾信息技术有限公司 | Distributed storage and parallel calculation-based power grid data quality detection method |
| CN105389300A (en) * | 2015-10-27 | 2016-03-09 | 云南电网有限责任公司 | Method for importing two-dimensional table data into distribution network GIS (Geographic Information System) system to automatically generate 10kV device data |
| CN105844546A (en) * | 2016-04-20 | 2016-08-10 | 国网四川省电力公司 | Power distribution network information interaction method based on GIS mirror image technology |
| CN105844546B (en) * | 2016-04-20 | 2019-12-31 | 国网四川省电力公司 | GIS mirror image technology-based power distribution network information interaction method |
| CN106600461A (en) * | 2016-12-15 | 2017-04-26 | 国网浙江宁波市鄞州区供电公司 | data verification method, device and equipment |
| CN107609016A (en) * | 2017-08-03 | 2018-01-19 | 南京南瑞集团公司 | Electricity transaction data accuracy method of calibration based on expression parsing |
| CN109377471A (en) * | 2018-08-21 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of picture verification |
| CN112580186A (en) * | 2020-11-03 | 2021-03-30 | 国网江苏省电力有限公司营销服务中心 | Method for generating marketing side power supply equipment GIS graph |
| CN112580186B (en) * | 2020-11-03 | 2024-03-08 | 国网江苏省电力有限公司营销服务中心 | Method for generating GIS (geographic information System) diagram of marketing-side power supply equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103577550A (en) | Grid equipment data verification method | |
| CN102622463B (en) | Drawing-model uniformity based method for automatic check of design drawings | |
| US6516326B1 (en) | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database | |
| CN103955789B (en) | A kind of supply path analysis method based on allotment Integrated Model | |
| CN106815326B (en) | System and method for detecting consistency of data table without main key | |
| CN105138752B (en) | Intelligent substation SCD file land parcel change trace differentiation compares and methods of exhibiting | |
| CN103592898B (en) | A kind of electronic product manufacture automatic control system and method | |
| CN107292769B (en) | Substation reconstruction and extension configuration consistency comparison and verification method based on RCD | |
| CN105447247A (en) | Method and system for checking regulation and control information | |
| CN108090165A (en) | A kind of acquisition methods of the collection of illustrative plates variation based on embedded chart database | |
| CN101174237B (en) | Automatic test method, system and test device | |
| CN106570105A (en) | Structured processing method for power equipment test report | |
| CN101930481A (en) | Method used for generating CIM model describing power grid change in designated time slot and system thereof | |
| CN102609520A (en) | Method for exporting model data of substation by filtering | |
| CN114968984A (en) | Digital twin full life cycle management platform | |
| CN104881739B (en) | Data consistency verification method is matched somebody with somebody by a kind of battalion based on IEC61970/61968 CIM standards | |
| CN103208087A (en) | Power distribution network data checking method based on international electrotechnical commission (IEC) 61968 standard | |
| CN111625944B (en) | Normalization verification method for G file of transformer substation main wiring diagram | |
| CN109271350B (en) | Database and information point table automatic comparison and synchronization method based on telecontrol communication | |
| CN114936442B (en) | System and method for accurately positioning power distribution network equipment and forming topological graph | |
| CN103247087A (en) | City distribution network graphical intelligent anti-misoperation system and method of system | |
| CN115510842A (en) | Transformer substation model full-data verification method based on new-generation secondary system | |
| CN106156916A (en) | A kind of renovation cracking tire RFID information acquisition management method and system | |
| CN107818535A (en) | A kind of Underground Pipeline Data management method, apparatus and system | |
| CN110597933B (en) | Matching method of power grid topological data |
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 | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140212 |