CN102521421A - Method for importing intelligent transformer substation state monitoring system model into database - Google Patents
Method for importing intelligent transformer substation state monitoring system model into database Download PDFInfo
- Publication number
- CN102521421A CN102521421A CN2012100040705A CN201210004070A CN102521421A CN 102521421 A CN102521421 A CN 102521421A CN 2012100040705 A CN2012100040705 A CN 2012100040705A CN 201210004070 A CN201210004070 A CN 201210004070A CN 102521421 A CN102521421 A CN 102521421A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- monitoring system
- system model
- model
- 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
Images
Landscapes
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
Abstract
The invention discloses a method for importing an intelligent transformer substation state monitoring system model into a database. The method comprises the following steps of: firstly importing a transformer substation model SCD (Circuit Switch Data) configuration file through a model analysis module, reading data of the transformer substation state monitoring system model, converting the data of the transformer substation state monitoring system model into database list information and database structure information, sequentially importing the database list information into a database according to the database structure information, and enabling transformer substation background software to conveniently obtain transformer substation field state monitoring data under the situation of already importing information of the intelligent transformer substation state monitoring system model into the database.
Description
Technical field
The present invention relates to a kind of method that intelligent substation condition monitoring system model is imported database.
Background technology
At present, in the intelligent substation on-line monitoring system, each monitoring equipment transfers to the monitoring backstage after self monitoring information is gathered, and be responsible for and each monitoring equipment communication on the monitoring backstage, and the gathering of information.Information gathers gathering of the model of mind that relates to each different manufacturers, distinct device; Quantity of information is many, and has nothing in common with each other, in the face of a large amount of and different information sources; If the corresponding with it database information of manual configuration; Efficient is low and error rate is high, is inappropriate for the informationization of current intelligent substation, the characteristics of robotization.Also there is not corresponding automatic mode with it at present.
In sum, to the defective of prior art, need the method for intelligent online monitoring background system configuration especially, promptly a kind of method with intelligent substation condition monitoring system model importing database is with the problem of mentioning more than solving.
Summary of the invention
The object of the present invention is to provide a kind of method that intelligent substation condition monitoring system model is imported database; Above-mentioned deficiency to the prior art existence; Having overcome can't be according to its automatic configuration database table information after the gathering of model of mind of different manufacturers, distinct device; Situation that can only manual configuration, the condition monitoring system model file of will standing entirely imports database automatically, thereby realizes the object of the invention.
The technical matters that the present invention solved can adopt following technical scheme to realize:
A kind of method with intelligent substation condition monitoring system model importing database is characterized in that said method comprises the steps:
1) the model parsing module is used for reading the information of intelligent substation condition monitoring system model;
2) model information and database table information translation module information translation that said model parsing module is read is database table information and database structure information;
3) database table information importing module imports database table information in the database according to database structure information successively;
4) the data message display module shows through the information of a visual interface with system's operation.
In one embodiment of the invention, the information in the said intelligent substation condition monitoring system model comprises device model information and device relationships information.
In one embodiment of the invention, said step 2) input file in is the SCD file, and output file is database table information and database structure information.
In one embodiment of the invention, the bad border of operation of said method comprises windows and Unix system.
Description of drawings
Fig. 1 is the method flow diagram that intelligent substation condition monitoring system model is imported database of the present invention.
Embodiment
For technological means, creation characteristic that the present invention is realized, reach purpose and effect and be easy to understand and understand, below in conjunction with embodiment, further set forth the present invention.
As shown in Figure 1; A kind of method of the present invention with intelligent substation condition monitoring system model importing database, it comprises that an intelligent substation condition monitoring system model parsing module, transformer station's condition monitoring system model information and database table information translation module, a database table information import module and and is used for the data message display module; Its method of work comprises the steps:
1) the model parsing module is used for reading the information of intelligent substation condition monitoring system model;
2) model information and database table information translation module information translation that said model parsing module is read is database table information and database structure information;
3) database table information importing module imports database table information in the database according to database structure information successively;
4) the data message display module shows through the information of a visual interface with system's operation.
Intelligent substation condition monitoring system model parsing module is used to import the status monitoring model information at full station; Comprise the energy monitoring apparatus under transformer and the interval; 61850 monitoring models of monitoring equipments such as lightning arrester, office put, oil chromatography, bushing shell for transformer, ground current, the little water of density, isolating switch, 61850 monitoring models of each equipment comprise information model, remote measurement, remote signalling report, monitoring node etc.; The logical relation that also comprises each monitoring equipment in addition; Comprise power transformer and electric pressure under the transformer station; Comprise checkout equipments such as oil chromatography, bushing shell for transformer under the power transformer; Comprise under the electric pressure at interval, comprise lightning arrester at interval down, innings put, monitoring equipments such as ground current, the little water of density, isolating switch.
Whether transformer station's condition monitoring system model information and database table information translation module exist correlation table through the information check database that intelligent substation model parsing module obtains; The corresponding IED table of primary equipment information; The corresponding LD table of secondary device information; The corresponding LN table of monitoring node information, the corresponding DO of detection limit information, DA table; The device relationships table is present in the tables such as SUBSTATION, BAY, TRANSFORMER, TRANSFORMERBU, LIGHTNINGARRE, simultaneously the corresponding historical data table of checkout facility.In internal memory, convert the information in the SCD file into database information corresponding data structure then.
Database table information imports the module needed data structure of each tables of data that conversion is good before and imports successively in each table.
The data message display module displays at visual interface the module operation information.Facility information prompting as importing imports miscue, imports successfully prompting; The facility information prompting of conversion, successfully prompting is changed in the miscue of conversion; Import the table information indicating of database, import the miscue of database, import the failure prompting of database etc.
More than show and described ultimate principle of the present invention and principal character and advantage of the present invention.The technician of the industry should understand; The present invention is not restricted to the described embodiments; That describes in the foregoing description and the instructions just explains principle of the present invention; Under the prerequisite that does not break away from spirit and scope of the invention, the present invention also has various changes and modifications, and these variations and improvement all fall in the scope of the invention that requires protection.The present invention requires protection domain to be defined by appending claims and equivalent thereof.
Claims (4)
1. the method with intelligent substation condition monitoring system model importing database is characterized in that said method comprises the steps:
1) the model parsing module is used for reading the information of intelligent substation condition monitoring system model;
2) model information and database table information translation module information translation that said model parsing module is read is database table information and database structure information;
3) database table information importing module imports database table information in the database according to database structure information successively;
4) the data message display module shows through the information of a visual interface with system's operation.
2. the method with intelligent substation condition monitoring system model importing database according to claim 1 is characterized in that the information in the said intelligent substation condition monitoring system model comprises device model information and device relationships information.
3. according to claim 1 intelligent substation condition monitoring system model is imported the method for database, it is characterized in that said step 2) in input file be the SCD file, output file is database table information and database structure information.
4. the method with intelligent substation condition monitoring system model importing database according to claim 1 is characterized in that the bad border of operation of said method comprises windows and Unix system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100040705A CN102521421A (en) | 2012-01-06 | 2012-01-06 | Method for importing intelligent transformer substation state monitoring system model into database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100040705A CN102521421A (en) | 2012-01-06 | 2012-01-06 | Method for importing intelligent transformer substation state monitoring system model into database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102521421A true CN102521421A (en) | 2012-06-27 |
Family
ID=46292334
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012100040705A Pending CN102521421A (en) | 2012-01-06 | 2012-01-06 | Method for importing intelligent transformer substation state monitoring system model into database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102521421A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106707151A (en) * | 2016-12-15 | 2017-05-24 | 中国南方电网有限责任公司超高压输电公司贵阳局 | High-voltage breaker online monitoring system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6516326B1 (en) * | 2000-10-30 | 2003-02-04 | Stone And Webster Consultants, Inc. | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database |
| CN101587152A (en) * | 2009-07-13 | 2009-11-25 | 江苏省电力试验研究院有限公司 | Electric energy quality monitoring system |
| CN102156795A (en) * | 2010-02-12 | 2011-08-17 | 华东电网有限公司 | Simulation information system of digital transformer station based on transformer station configuration description file |
-
2012
- 2012-01-06 CN CN2012100040705A patent/CN102521421A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6516326B1 (en) * | 2000-10-30 | 2003-02-04 | Stone And Webster Consultants, Inc. | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database |
| CN101587152A (en) * | 2009-07-13 | 2009-11-25 | 江苏省电力试验研究院有限公司 | Electric energy quality monitoring system |
| CN102156795A (en) * | 2010-02-12 | 2011-08-17 | 华东电网有限公司 | Simulation information system of digital transformer station based on transformer station configuration description file |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106707151A (en) * | 2016-12-15 | 2017-05-24 | 中国南方电网有限责任公司超高压输电公司贵阳局 | High-voltage breaker online monitoring system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112114230B (en) | Distribution network monitoring system for low-voltage transformer area and transformer area topology identification method | |
| CN103414251B (en) | A kind of substation network communication analogue system based on IEC61850 | |
| CN105227350A (en) | Based on the intelligent substation IED configuration file management-control method of CRC check code | |
| CN103760874B (en) | Check meter source of trouble localization method in a kind of low-voltage platform area | |
| CN104092310B (en) | A kind of intelligent power distribution monitoring and energy management system backstage | |
| CN105429291A (en) | Correlation method of primary wiring diagram and secondary system logic connecting diagram of intelligent substation | |
| WO2015149594A1 (en) | Iec61850-based communication simulation method for partial discharge on-line monitoring device | |
| CN204391903U (en) | A kind of line loss monitoring system | |
| WO2015149596A1 (en) | Iec61850-based communication simulation method for leakage current on-line monitoring device | |
| CN206524629U (en) | A kind of low-voltage distribution control system | |
| CN103107914A (en) | Detection method and detection system for remote power acquisition terminal | |
| CN104698374A (en) | Method for improving testing efficiency and accuracy of automatic relay protecting tester | |
| CN103544652A (en) | Power grid industry classification load automatic statistical method and system | |
| CN206421561U (en) | Power information real-time data acquisition device | |
| CN104392603B (en) | A kind of live power information collecting device intelligent diagnosis system | |
| CN105405281A (en) | Detection method for carrier communication failures of smart electric meter | |
| CN103217597B (en) | A kind of construction method of general test template of digital relay protective device | |
| CN105634122A (en) | Ammeter remote control system | |
| CN204631168U (en) | A kind of industrial current transformer remote diagnosis and maintenance system | |
| CN102521421A (en) | Method for importing intelligent transformer substation state monitoring system model into database | |
| CN203573483U (en) | Wireless acquisition device with multifunctional acquisition and control capacity | |
| CN203704977U (en) | Terminal equipment of electric oil filling equipment oil quality on-line monitoring system | |
| CN103607051B (en) | A kind of transformer station's enlargement method and system | |
| CN204515160U (en) | Offshore shooting instrument towing cable DC constant current power supply is powered and is gone up electric system step by step | |
| CN103151845A (en) | Intelligent substation state monitoring platform based on IEC 61850 |
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: 20120627 |