CN102609513A - Multi-data-source database system for condition monitoring of electric transmission and transformation equipment - Google Patents
Multi-data-source database system for condition monitoring of electric transmission and transformation equipment Download PDFInfo
- Publication number
- CN102609513A CN102609513A CN2012100263648A CN201210026364A CN102609513A CN 102609513 A CN102609513 A CN 102609513A CN 2012100263648 A CN2012100263648 A CN 2012100263648A CN 201210026364 A CN201210026364 A CN 201210026364A CN 102609513 A CN102609513 A CN 102609513A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- status monitoring
- database management
- input
- 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.)
- Granted
Links
Images
Landscapes
- Supply And Distribution Of Alternating Current (AREA)
Abstract
A multi-data-source database system for condition monitoring of electric transmission and transformation equipment comprises an input module (1), a judgment module (2), a format conversion module (3), a receiving processing module (4), an advanced algorithm module (5), a data separation module (6), a database management module (7) and a database module (8). The input module (1) is respectively connected with the format conversion module (3) and the receiving processing module (4) through the judgment module (2), the judgment module (2) is connected with the advanced algorithm module (5), the receiving processing module (4) is connected with the data separation module (6), and the database management module (7) is respectively connected with the advanced algorithm module (5), the data separation module (6) and the database module (8). Various data source information for condition monitoring of electric transmission and transformation equipment can be efficiently processed to extract effective data from the data source information and store the effective data in a database to upwardly provide an inquiry interface, so that software or scientific researchers can conveniently inquire required information such as pictures, data and the like according to inquiry requirements.
Description
Technical field
The present invention relates to slip condition database, in particular, relate to the database technical field of power transmission and transformation equipment state monitoring plurality according to the source.
Background technology
At present, along with the fast development of electrical network, the continuous increase of power transmission and transforming equipment quantity, existing prophylactic repair pattern exist deficiency, the test blindness because of manpower big, be prone to equipment caused shortcoming such as damage, suddenly wait to get into new maintenance pattern, i.e. repair based on condition of component.Carrying out of repair based on condition of component work is to be based upon on the basis that equipment state is controlled; Formulate the degree decision that rational and effective equipment repair and maintenance strategy is understood equipment state by the technician.By the end of at present, every kind of power transmission and transforming equipment all there are a lot of status monitoring means, these detection meanss are often all preserved data by the computer of oneself, and data volume is big, disperses but preserve, is not easy to inquiry and the statistics of later stage to data.
Between above-mentioned situation, the power transmission and transformation equipment state monitoring plurality is saved in the database so that the later stage inquiry becomes a problem anxious to be solved in this area according to source information is concentrated.
Summary of the invention
The objective of the invention is to solve the problem that prior art exists, a kind of efficiently status monitoring multi-data source database easily is provided, so that software or scientific research personnel are according to the querying condition judgment data.
For realizing above technical purpose, technical scheme of the present invention is:
The power transmission and transformation equipment state monitoring plurality comprises with lower module according to source database system:
Load module is used to judge that the data source that the user imports is the data of which kind of power equipment, which kind of type, according to the characteristic of input data, the data distribution of input is further handled to the determination module of affiliated power equipment then;
Determination module, this module all has under every kind of power equipment, and the status monitoring data that are used for load module is obtained are judged, judge that these status monitoring data enter into format converting module or receiving processing module;
Format converting module, the status monitoring data that are used for that load module is obtained are input to power equipment under the native system, the tractable form of the system that converts into, and send into the advanced algorithm module;
Receiving processing module is used for the data that status monitoring obtains are input to power equipment under the native system, and sends into the data separating resume module;
The advanced algorithm module; Be used for the easy processing format status monitoring data that conversion gets to format converting module and carry out the advanced algorithm processing; Comprise operations such as denoising, enhancing, sharpening, and will handle later status monitoring data and be input to database management module and finally preserve;
The data separating module; The status monitoring data that are used for receiving processing module is transmitted are carried out separating treatment; The status monitoring data message is separated into the data layout of system requirements, and will handles later status monitoring data and pass to database management module with corresponding virgin state Monitoring Data and finally preserve;
Database management module receives data and primary data information (pdi) that the status monitoring data that transmit from the advanced algorithm module and data separating module transmit respectively, sorts out respectively and sends into DBM and preserve;
DBM receives the data that transmit from database management module, is saved to database and various query interfaces upwards are provided;
Annexation between each module is that load module is connected with format converting module, receiving processing module respectively through determination module; Format converting module is connected with the advanced algorithm module; Receiving processing module is connected with the data separating module; Database management module is connected with advanced algorithm module, data separating module, DBM respectively;
The workflow of this system is following:
Useful technique effect of the present invention is:
1) the present invention adopts load module 1 and the data acquisition technology that the several data interface concurrent moves, and the several data input format is had very strong adaptability;
2) advanced algorithm module 5 is used the special advanced algorithm that strengthens to the power transmission and transformation equipment state Monitoring Data, is convenient to handle targetedly the power transmission and transformation equipment state Monitoring Data;
3) data separating module 6 adopts data separating technology targetedly, and mask data makes things convenient for Users'Data Analysis from the status monitoring data;
4) realize the database of the multiple management of various states monitoring means, realized the management of power transmission and transformation equipment state Monitoring Data.
Below in conjunction with accompanying drawing and specific embodiment the present invention is done further explanation.
Description of drawings
Fig. 1 is that power transmission and transformation equipment state monitoring plurality of the present invention is according to each module diagram of source database;
Fig. 2 is that power transmission and transformation equipment state monitoring plurality of the present invention is according to source database system data input stream journey figure.
Embodiment
The power transmission and transformation equipment state monitoring plurality the present invention includes with lower module according to source database system:
Load module 1 is used to judge that the data source that the user imports is the data of which kind of power equipment, which kind of type, according to the characteristic of input data, the data distribution of input is further handled to the determination module of affiliated power equipment then;
Determination module 2, this module all has under every kind of power equipment, and the status monitoring data that are used for load module is obtained are judged, judge that these status monitoring data enter into format converting module or receiving processing module;
Format converting module 3, the status monitoring data that are used for that load module is obtained are input to power equipment under the native system, the tractable form of the system that converts into, and send into the advanced algorithm module;
Receiving processing module 4 is used for the data that status monitoring obtains are input to power equipment under the native system, and sends into the data separating resume module;
Advanced algorithm module 5; Be used for the easy processing format status monitoring data that conversion gets to format converting module and carry out the advanced algorithm processing; Comprise operations such as denoising, enhancing, sharpening, and will handle later status monitoring data and be input to database management module and finally preserve;
Data separating module 6; The status monitoring data that are used for receiving processing module is transmitted are carried out separating treatment; The status monitoring data message is separated into the data layout of system requirements, and will handles later status monitoring data and pass to database management module with corresponding virgin state Monitoring Data and finally preserve;
DBM 8 receives the data that transmit from database management module, is saved to database and various query interfaces upwards are provided;
Annexation between each module is that load module 1 is connected with format converting module 3, receiving processing module 4 respectively through determination module 2; Format converting module 3 is connected with advanced algorithm module 5; Receiving processing module 4 is connected with data separating module 6; Database management module 7 is connected with advanced algorithm module 5, data separating module 6, DBM 8 respectively;
The workflow of this system is following:
1) beginning, the start-up system general supply;
2) load module 1 requires user input data, data type and affiliated power equipment thereof; Whether by determination module 2 decision data is to be prone to processing format; If data are non-easy processing format; Then utilize transfer algorithm in the format converting module 3 will import data and transfer tractable form to, data are sent into utilized the advanced processes algorithm that data are strengthened targetedly in the advanced algorithm module 5 again, give DBM 8 then and deposit image data base in; If the data of input are to be prone to processing format, then carry out 3); Said easy processing format is meant active file forms such as JPG, BMP, is non-common forms such as DICOM but not be prone to processing format;
3) carry out the figure image intensifying according to the data message characteristic; As utilize gray-scale transformation method realization figure image intensifying; Enter data in 6 of the data separating modules by receiving processing module 4; Be the data layout of system requirements by data separating module 6 according to the data message Feature Conversion then, data message and raw data after will being changed by database management module 7 are afterwards together given database management module 8 and are deposited image data base in; Finish, program withdraws from.
Each module working condition is following: after software systems are moved; Load module 1 is the input of waiting status Monitoring Data at any time; Determination module 2, format converting module 3, receiving processing module 4, advanced algorithm module 5, data separating module 6, database management module 7, DBM 8 these eight module parallel runnings; As user during to system's input state Monitoring Data; Whether load module 1 needs format conversion to judge through 2 pairs of these status monitoring data of determination module; Carrying out format conversion like need changes to format converting module 3 this status monitoring data distribution; In format converting module 3, the status monitoring data are changed arrangement, give advanced algorithm module 5 with transformation result and handle, this module is responsible for using a series of advanced processes algorithms it to be carried out processing such as data enhancing and give database management module 7 labeled finally depositing in the database according to the characteristic of status monitoring data.
Load module 1 in the system of the present invention, determination module 2, format converting module 3, receiving processing module 4, advanced algorithm module 5, data separating module 6, database management module 7, DBM 8 these eight modules all can adopt the prior art module, also can adopt the module of design voluntarily.
Claims (1)
1. the power transmission and transformation equipment state monitoring plurality is characterized in that according to source database system, comprises with lower module:
Load module (1) is used to judge that the data source that the user imports is the data of which kind of power equipment, which kind of type, according to the characteristic of input data, the data distribution of input is further handled to the determination module of affiliated power equipment then;
Determination module (2), this module all has under every kind of power equipment, and the status monitoring data that are used for load module is obtained are judged, judge that these status monitoring data enter into format converting module or receiving processing module;
Format converting module (3), the status monitoring data that are used for that load module is obtained are input to power equipment under the native system, the tractable form of the system that converts into, and send into the advanced algorithm module;
Receiving processing module (4) is used for the data that status monitoring obtains are input to power equipment under the native system, and sends into the data separating resume module;
Advanced algorithm module (5); Be used for the easy processing format status monitoring data that conversion gets to format converting module and carry out the advanced algorithm processing; Comprise operations such as denoising, enhancing, sharpening, and will handle later status monitoring data and be input to database management module and finally preserve;
Data separating module (6); The status monitoring data that are used for receiving processing module is transmitted are carried out separating treatment; The status monitoring data message is separated into the data layout of system requirements, and will handles later status monitoring data and pass to database management module with corresponding virgin state Monitoring Data and finally preserve;
Database management module (7) receives data and primary data information (pdi) that the status monitoring data that transmit from the advanced algorithm module and data separating module transmit respectively, sorts out respectively and sends into DBM and preserve;
DBM (8) receives the data that transmit from database management module, is saved to database and various query interfaces upwards are provided;
Annexation between each module is that load module (1) is connected with format converting module (3), receiving processing module (4) respectively through determination module (2); Format converting module (3) is connected with advanced algorithm module (5); Receiving processing module (4) is connected with data separating module (6); Database management module (7) is connected with advanced algorithm module (5), data separating module (6), DBM (8) respectively;
The workflow of this system is following:
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210026364.8A CN102609513B (en) | 2012-02-07 | 2012-02-07 | Multi-data-source database system for condition monitoring of electric transmission and transformation equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210026364.8A CN102609513B (en) | 2012-02-07 | 2012-02-07 | Multi-data-source database system for condition monitoring of electric transmission and transformation equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102609513A true CN102609513A (en) | 2012-07-25 |
| CN102609513B CN102609513B (en) | 2014-01-01 |
Family
ID=46526885
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210026364.8A Active CN102609513B (en) | 2012-02-07 | 2012-02-07 | Multi-data-source database system for condition monitoring of electric transmission and transformation equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102609513B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657493A (en) * | 2015-03-06 | 2015-05-27 | 云南电网有限责任公司电力科学研究院 | Transformer winding state multi-data source database system |
| CN105719093A (en) * | 2016-01-26 | 2016-06-29 | 云南电网有限责任公司电力科学研究院 | Icing monitoring multi-data-source processing method and system of large unmanned plane |
| CN116521777A (en) * | 2023-07-05 | 2023-08-01 | 中国水利水电第七工程局有限公司 | Remote interface method for tunnel engineering monitoring data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1687922A (en) * | 2005-05-30 | 2005-10-26 | 北京慧讯信息技术有限公司 | Distributed data source data integration system and method |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN102156798A (en) * | 2011-01-07 | 2011-08-17 | 成都中医药大学 | Traditional Chinese medicine syndrome information acquisition system |
-
2012
- 2012-02-07 CN CN201210026364.8A patent/CN102609513B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1687922A (en) * | 2005-05-30 | 2005-10-26 | 北京慧讯信息技术有限公司 | Distributed data source data integration system and method |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN102156798A (en) * | 2011-01-07 | 2011-08-17 | 成都中医药大学 | Traditional Chinese medicine syndrome information acquisition system |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657493A (en) * | 2015-03-06 | 2015-05-27 | 云南电网有限责任公司电力科学研究院 | Transformer winding state multi-data source database system |
| CN105719093A (en) * | 2016-01-26 | 2016-06-29 | 云南电网有限责任公司电力科学研究院 | Icing monitoring multi-data-source processing method and system of large unmanned plane |
| CN116521777A (en) * | 2023-07-05 | 2023-08-01 | 中国水利水电第七工程局有限公司 | Remote interface method for tunnel engineering monitoring data |
| CN116521777B (en) * | 2023-07-05 | 2023-09-22 | 中国水利水电第七工程局有限公司 | Remote interface method for tunnel engineering monitoring data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102609513B (en) | 2014-01-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100595700C (en) | Reschedule decision making system of semiconductor manufacturing system | |
| CN101867226B (en) | Wide-area distribution type data collection method for dispatching automation system | |
| CN102609513B (en) | Multi-data-source database system for condition monitoring of electric transmission and transformation equipment | |
| CN106375480A (en) | Electric energy data real-time acquisition system and method based on distributed system | |
| CN103957280A (en) | Connection allocation and scheduling method of sensor network in Internet of things | |
| CN101299770B (en) | Method for processing cooperation information of wireless sensor network | |
| CN112788110A (en) | Product appearance detection method based on cloud edge collaborative model optimization and implementation system thereof | |
| CN108572562A (en) | A kind of smart home wisdom energy management system based on Internet of Things and QT graphical interfaces | |
| CN204331799U (en) | Real-time vehicle-mounted cold chain transportation information monitoring system | |
| CN104319897B (en) | Intelligent micro-grid control system for achieving high-speed communication based on FPGA | |
| CN102375912B (en) | Data integration device and method among different engineering software systems | |
| CN202167880U (en) | Power supply system of inspection robot in converting station | |
| CN206767052U (en) | A kind of classification harvester of distributed automatization recyclable rubbish | |
| CN112884358A (en) | Electric heating equipment ordered power utilization optimized scheduling method and terminal | |
| CN102521318A (en) | General data exchange device based on extensible markup language (XML) | |
| CN204290485U (en) | Transformer station's O&M integration work on the spot information acquisition system | |
| CN106828150A (en) | A kind of discrete battery management system | |
| RU157928U1 (en) | DEVICE FOR CONTROL AND MANAGEMENT OF THE PRODUCTION PROCESS | |
| CN107706982A (en) | The charging pile control system of collective and distributive type control | |
| CN102508921B (en) | Image database system combining X-ray digital picture with partial discharge map | |
| CN202713363U (en) | Radio monitoring system based on protocol interface adaptation | |
| CN103810256B (en) | Method based on partitioning technique quick distribution data in big data network optimization platform | |
| CN101788902B (en) | Information equipment | |
| CN104657493A (en) | Transformer winding state multi-data source database system | |
| CN101394640A (en) | Communication resource line patrolling management system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220624 Address after: 650217 yundian science and Technology Park, No.105, Yunda West Road, economic development zone, Kunming City, Yunnan Province Patentee after: YUNNAN ELECTRIC POWER TEST & RESEARCH INSTITUTE (GROUP) Co.,Ltd. Address before: 650217 Yunnan Kunming Economic and Technological Development Zone Yunda West Road Middle Yundian Science Park Patentee before: YUN NAN ELECTRIC TEST & RESEARCH INSTITUTE GROUP Co.,Ltd. ELECTRIC INSTITUTE |