CN101702211A - Supporting verification method for account table data of electric transmission and transformation equipment - Google Patents
Supporting verification method for account table data of electric transmission and transformation equipment Download PDFInfo
- Publication number
- CN101702211A CN101702211A CN200910153738A CN200910153738A CN101702211A CN 101702211 A CN101702211 A CN 101702211A CN 200910153738 A CN200910153738 A CN 200910153738A CN 200910153738 A CN200910153738 A CN 200910153738A CN 101702211 A CN101702211 A CN 101702211A
- Authority
- CN
- China
- Prior art keywords
- data
- equipment
- database
- intermediate database
- account table
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a supporting verification method for account table data of electric transmission and transformation equipment. The method comprises the following steps: 1) establishment of intermediate database: needed data is retrieved from a database of electric power secure production information management system to establish an intermediate database, wherein the retrieved data comprises statistical data of power grid device information and statistical data of account table data volume which are retrieved to establish the temporary intermediate database; and 2) verification of intermediate database: the integrality, normalization and timeliness of the statistical data of power grid device information and statistical data of account table data volume in the temporary intermediate database are verified. The invention can be used for performing full utilization on the data of the electric power secure production information management system, and providing information for the managers to decide.
Description
Technical field
The present invention relates to a kind of supporting verification method for account table data of electric transmission and transformation equipment.
Background technology
The electric power safety Style Product Information Management System is numerous at present, but the data in this system are not made full use of, and causes the waste of electric power safety Style Product Information Management System resource, and the information of decision-making can not effectively be provided for the supvr.
Summary of the invention
The objective of the invention is to design a kind of supporting verification method for account table data of electric transmission and transformation equipment.
What the present invention will solve is that the data that have the electric power safety Style Product Information Management System now do not make full use of, and causes the problem of the wasting of resources of electric power safety Style Product Information Management System.
In order to realize purpose of the present invention, the technical solution used in the present invention which comprises at least following steps:
1) foundation of intermediate database: from the database of electric power safety Style Product Information Management System, extract the data that need, set up intermediate database; The data that extracted comprise electrical network equipment information statistics and account data amount statistics, set up interim intermediate database behind these two kinds of data pick-ups;
2) verify intermediate database: integrality, standardization, promptness to electrical network equipment information statistics in the interim intermediate database and account data amount statistics are verified;
The check method of integrality is: open intermediate database, verify relevant data presented and whether fill out entirely, parameter is listed for empty data pick-up, be convenient to relevant unit and verify rectification;
The check method of standardization is: work out device parameter standardization principle, the device parameter standardization principle according to working out does not extract meeting specification data, is convenient to relevant unit to the production safety management infosystem, and is perfect to in-problem data;
The check method of promptness is: carry out the put into operation inquiry on date of equipment according to unit, time, as with certain innings certain year certain month new throwing electric substation, newly throw facility information, newly throw line information etc. and come out, double-click and enter specifically to check that this facility information is data presented.
Operation interface of the present invention and functional module adopt the .NET development environment, and database adopts ORACLE9.0;
In the step 1), extracted data time and number of times from the database of electric power safety Style Product Information Management System, self-defined according to importance, in order not influence the operation of production safety management system, every day timing extraction, generally carry out extracted data at dead of night about 12 o'clock, the data of extraction provide with intuitionistic forms such as tabulation, diagrams.
Electrical network equipment information in step 1) statistics comprises: relevant informations such as the electric substation in the electrical network, transformer, capacity, isolating switch, the number of lines and line length, they gather (500 kilovolts, ± 500 kilovolts, 220 kilovolts, 110 kilovolts, 35 kilovolts) according to the electric pressure classification.
Step 2) the account data amount statistics in comprises: A) device class: comprise equipment such as power transformation primary equipment, Secondary device, transmission facility, miscellaneous equipment, pipeline; B), equipment ownership (assets ownership): comprise provincial assets, local assets; C) equipment making time; D) other condition.
Advantage of the present invention is: utilize the present invention can the data of electric power safety Style Product Information Management System be made full use of, the information of decision-making is provided for the supvr.
Embodiment
The present invention is further illustrated below in conjunction with embodiment.
Method of the present invention comprises the steps:
1) foundation of intermediate database: from the database of electric power safety Style Product Information Management System, extract the data that need, set up intermediate database; The data that extracted comprise electrical network equipment information statistics and account data amount statistics, set up interim intermediate database behind these two kinds of data pick-ups;
2) verify intermediate database: integrality, standardization, promptness to electrical network equipment information statistics in the interim intermediate database and account data amount statistics are verified;
The check method of integrality is: open intermediate database, verify relevant data presented and whether fill out entirely, parameter is listed for empty data pick-up, be convenient to relevant unit and verify rectification;
The check method of standardization is: work out device parameter standardization principle, the device parameter standardization principle according to working out does not extract meeting specification data, is convenient to relevant unit to the production safety management infosystem, and is perfect to in-problem data.
The check method of promptness is: carry out the put into operation inquiry on date of equipment according to unit, time, as with certain innings certain year certain month new throwing electric substation, newly throw facility information, newly throw line information etc. and come out, double-click and enter specifically to check that this facility information is data presented.
Operation interface of the present invention and functional module adopt the .NET development environment, and database adopts ORACLE9.0;
In the step 1), extracted data time and number of times, self-defined according to importance, in order not influence the operation of production safety management system, every day, timing extraction generally carried out extracted data at dead of night about 12 o'clock, and the data of extraction provide with intuitionistic forms such as tabulation, diagrams.
Electrical network equipment information statistics in the step 1) comprises:
Relevant informations such as the electric substation in the electrical network, transformer, capacity, isolating switch, the number of lines and line length, they gather (500 kilovolts ,+500 kilovolts, 220 kilovolts, 110 kilovolts, 35 kilovolts) according to electric pressure classification.
Step 2) the account data amount statistics in comprises: A) device class: comprise equipment such as power transformation primary equipment, Secondary device, transmission facility, miscellaneous equipment, pipeline; B) equipment ownership (assets ownership): comprise provincial assets, local assets; C) equipment making time; D) other condition.
Described A) device class, specifically see the following form:
Described B) equipment ownership (assets ownership), specifically see the following form:
| The assets ownership |
| State's net is entrusted |
| Ground belongs to assets |
| Entrust in East China |
| Economize corporate assets |
| The assets ownership |
| User's assets |
| Provincial assets |
| The county belongs to assets |
Described step 2) device parameter standardization principle such as following table in:
Also should comprise in the above-mentioned standardization principle:
One, manufacturing plant, the date of putting into operation, model, electric pressure, Asset Attributes, device type can not be sky
Two, date of putting into operation can not be later than the server time of checking the same day
Three, electric pressure must be in " 0.11,0.22,0.38,6,10,15.75,63,35,110,220,330,500 " one, unit is kV
Four, Asset Attributes is necessary in " trusts of state net, East China trust, province's corporate assets, provincial assets, belong to assets, county's genus assets, user's assets " one.
Five, the same numeric type field of all devices same category of device is compared and 1000 times gap should not be occurred.
Claims (5)
1. supporting verification method for account table data of electric transmission and transformation equipment is characterized in which comprises at least following steps:
1) foundation of intermediate database: from the database of electric power safety Style Product Information Management System, extract the data that need, set up intermediate database; The data that extracted comprise electrical network equipment information statistics and account data amount statistics, set up interim intermediate database behind these two kinds of data pick-ups;
2) verify intermediate database: integrality, standardization, promptness to electrical network equipment information statistics in the interim intermediate database and account data amount statistics are verified;
The check method of integrality is: open intermediate database, verify relevant data presented and whether fill out entirely, parameter is listed for empty data pick-up, be convenient to relevant unit and verify rectification;
The check method of standardization is: work out device parameter standardization principle, the device parameter standardization principle according to working out does not extract meeting specification data, is convenient to relevant unit to the production safety management infosystem, and is perfect to in-problem data;
The check method of promptness is: carry out the put into operation inquiry on date of equipment according to unit, time, as with certain innings certain year certain month new throwing electric substation, newly throw facility information, newly throw line information and relevant Information Statistics are come out, double-click and enter specifically to check that this facility information is data presented.
2. supporting verification method for account table data of electric transmission and transformation equipment as claimed in claim 1, it is characterized in that in the step 1), extracted data time and number of times from the database of electric power safety Style Product Information Management System, self-defined according to importance, in order not influence the operation of production safety management system, every day, timing extraction generally carried out extracted data at dead of night about 12 o'clock, and the data of extraction provide with intuitionistic forms such as tabulation, diagrams.
3. supporting verification method for account table data of electric transmission and transformation equipment as claimed in claim 1, it is characterized in that the electrical network equipment information statistics in the step 1) comprises: relevant informations such as the electric substation in the electrical network, transformer, capacity, isolating switch, the number of lines and line length, they gather according to the electric pressure classification.
4. supporting verification method for account table data of electric transmission and transformation equipment as claimed in claim 1 is characterized in that step 2) in account data amount statistics comprise: A) device class: comprise power transformation primary equipment, Secondary device, transmission facility, miscellaneous equipment, pipeline and relevant device; B) equipment ownership: comprise provincial assets, local assets; C) equipment making time; D) other condition.
5. supporting verification method for account table data of electric transmission and transformation equipment as claimed in claim 1 is characterized in that operation interface of the present invention and functional module adopt the .NET development environment, and database adopts ORACLE9.0;
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910153738A CN101702211A (en) | 2009-11-05 | 2009-11-05 | Supporting verification method for account table data of electric transmission and transformation equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910153738A CN101702211A (en) | 2009-11-05 | 2009-11-05 | Supporting verification method for account table data of electric transmission and transformation equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101702211A true CN101702211A (en) | 2010-05-05 |
Family
ID=42157125
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910153738A Pending CN101702211A (en) | 2009-11-05 | 2009-11-05 | Supporting verification method for account table data of electric transmission and transformation equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101702211A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102938129A (en) * | 2012-10-31 | 2013-02-20 | 国家电网公司 | Routing management method of electricity information machine accounts |
| CN103426125A (en) * | 2013-08-05 | 2013-12-04 | 国家电网公司 | Intelligent checking system for transformer accounts for production management system (PMS) |
| CN104318404A (en) * | 2014-11-19 | 2015-01-28 | 国网河南省电力公司濮阳供电公司 | Relay protection equipment standing book managing method and system |
| CN110008254A (en) * | 2019-04-02 | 2019-07-12 | 云南电网有限责任公司电力科学研究院 | A kind of transformer equipment account verification processing method |
| CN110909525A (en) * | 2019-11-19 | 2020-03-24 | 云南电网有限责任公司信息中心 | System and method for realizing automatic comparison of standing book information |
| CN111552718A (en) * | 2020-04-23 | 2020-08-18 | 国网河北省电力有限公司 | Interactive intelligent power auditing method containing process information |
-
2009
- 2009-11-05 CN CN200910153738A patent/CN101702211A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102938129A (en) * | 2012-10-31 | 2013-02-20 | 国家电网公司 | Routing management method of electricity information machine accounts |
| CN103426125A (en) * | 2013-08-05 | 2013-12-04 | 国家电网公司 | Intelligent checking system for transformer accounts for production management system (PMS) |
| CN104318404A (en) * | 2014-11-19 | 2015-01-28 | 国网河南省电力公司濮阳供电公司 | Relay protection equipment standing book managing method and system |
| CN110008254A (en) * | 2019-04-02 | 2019-07-12 | 云南电网有限责任公司电力科学研究院 | A kind of transformer equipment account verification processing method |
| CN110008254B (en) * | 2019-04-02 | 2023-09-26 | 云南电网有限责任公司电力科学研究院 | Transformer equipment standing book checking processing method |
| CN110909525A (en) * | 2019-11-19 | 2020-03-24 | 云南电网有限责任公司信息中心 | System and method for realizing automatic comparison of standing book information |
| CN111552718A (en) * | 2020-04-23 | 2020-08-18 | 国网河北省电力有限公司 | Interactive intelligent power auditing method containing process information |
| CN111552718B (en) * | 2020-04-23 | 2020-12-08 | 国网河北省电力有限公司 | Interactive intelligent power auditing method containing process information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101702211A (en) | Supporting verification method for account table data of electric transmission and transformation equipment | |
| CN104102790B (en) | Power supply figure automatic mapping system and method based on GIS | |
| CN109146089A (en) | A kind of life period of an equipment management method based on BIM | |
| CN102800033A (en) | Distribution production and marketing business integration system | |
| CN102426525B (en) | Panoramic modeling method of multi-application system | |
| CN102801213A (en) | Integrated method and integrated device of SCD (System Configuration Document) of transformer station | |
| CN102495916A (en) | Multi-application-system panoramic modeling method based on object matching | |
| CN102608962A (en) | Automatic maintenance method for bottom-up electricity-consumption information acquisition equipment | |
| CN104504485A (en) | Integrative power system relay protection setting calculation method | |
| CN107798489A (en) | A kind of electric network operation site safety management method based on wechat platform | |
| CN101770518A (en) | Metadata management method of power grid enterprise integrated information die | |
| CN104091034B (en) | Circuit communication chart automatic mapping system and method based on Graphic Pattern Matching | |
| CN104168138A (en) | Electric power communication network system centralized topology generation and display method | |
| CN103699688B (en) | Terminal model for supporting power supply reliability management of terminal user | |
| CN106789347A (en) | A kind of method that alarm association and network fault diagnosis are realized based on alarm data | |
| CN103164532B (en) | The classification piecemeal abstracting method of grid model data and system | |
| CN101867185A (en) | System and method for automatically maintaining PI measuring point of power system | |
| CN102938581B (en) | Communication service method and system for on-line monitoring of transformer substation | |
| CN104578404A (en) | Online monitoring system for secondary equipment of power system | |
| CN112446619B (en) | Power distribution network rush-repair processing method and device | |
| CN104933519A (en) | Relay protection device condition-based maintenance aided decision making system | |
| CN103617141A (en) | Method for electrical equipment field test and characteristic evaluation management | |
| CN104735039A (en) | Communication conversion method | |
| CN108182055A (en) | The information object modeling method and system of a kind of SCD file | |
| CN103279899B (en) | Electric network operation panoramic model extended method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100505 |