CN102609513B - 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
- CN102609513B CN102609513B CN201210026364.8A CN201210026364A CN102609513B CN 102609513 B CN102609513 B CN 102609513B CN 201210026364 A CN201210026364 A CN 201210026364A CN 102609513 B CN102609513 B CN 102609513B
- Authority
- CN
- China
- Prior art keywords
- module
- data
- database
- condition monitoring
- 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.)
- Active
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 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 exists deficiency, the test blindness because of manpower greatly, easily equipment to be caused the shortcomings such as damage, suddenly waits to enter new maintenance model, 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; Formulating the degree that rationally effectively the equipment repair and maintenance strategy is understood equipment state by the technician determines.By the end of at present, every kind of power transmission and transforming equipment is had to a lot of status monitoring means, these detection meanss are often all by the computer save data of oneself, and data volume is large, but preserve, disperses, and 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 concentrated and is saved in database so that the later stage inquiry becomes a problem anxious to be resolved in this area according to source information.
Summary of the invention
The objective of the invention is to solve the problem that prior art exists, provide a kind of efficiently status monitoring multi-data source database easily, so that software or scientific research personnel judge data according to querying condition.
For realizing above technical purpose, technical scheme of the present invention is:
The power transmission and transformation equipment state monitoring plurality, according to source database system, comprises with lower module:
Load module, for judging that the data source that the user inputs is the data of which kind of power equipment, which kind of type, then, according to the feature of input data, the determination module by the Data dissemination of input to affiliated power equipment is further processed;
Determination module, this module all has under every kind of power equipment, for the Condition Monitoring Data that load module is obtained, is judged, judges that this Condition Monitoring Data enters into format converting module or receiving processing module;
Format converting module, be input to power equipment under native system for the Condition Monitoring Data that load module is obtained, the tractable form of the system that is converted to, and send into the advanced algorithm module;
Receiving processing module, be input to power equipment under native system for the data that status monitoring is obtained, and send into the data separating resume module;
The advanced algorithm module, carry out the advanced algorithm processing for the easy processing format Condition Monitoring Data that conversion gets to format converting module, comprise denoising, enhancing, sharpening operation, and be input to database management module and finally preserve processing Condition Monitoring Data later;
The data separating module, carry out separating treatment for the Condition Monitoring Data that receiving processing module is transmitted, the data layout that is system requirements by the Condition Monitoring Data information separated, and pass to database management module with corresponding virgin state Monitoring Data and finally preserve processing Condition Monitoring Data later;
Database management module, receive respectively data and primary data information (pdi) that the Condition Monitoring Data that transmits from the advanced algorithm module and data separating module transmit, sorts out respectively and send into database module and preserve;
Database module, receive 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 by 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, database module respectively;
The workflow of this system is as follows:
1) start, start the system general supply;
2) load module requires user input data, data type and affiliated power equipment thereof, by the determination module decision data, whether be easy processing format, if the easy processing format of data right and wrong, utilize transfer algorithm in format converting module will input data and transfer tractable form to, data are sent in the advanced algorithm module and utilized the advanced processes algorithm to strengthen targetedly data again, then give database management module and database module and deposit image data base in; If the data of input are easy processing format, carry out 3);
3) carry out the figure image intensifying according to the data message feature, by receiving processing module, entered data in the data separating module, then the data layout that is system requirements by the data separating module according to the data message Feature Conversion, together given the data message after advanced algorithm module and data separating module converts and raw data database module and deposit image data base in by database management module afterwards; Finish, workflow exits.
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 to very strong adaptability;
2) advanced algorithm module 5 is used the advanced algorithm strengthened for the power transmission and transformation equipment state Monitoring Data specially, is convenient to process targetedly the power transmission and transformation equipment state Monitoring Data;
3) data separating module 6 adopts data separating technology targetedly, and from Condition Monitoring Data, mask data facilitates Users'Data Analysis;
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 the drawings and specific embodiments, the present invention is further explained.
The accompanying drawing explanation
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, according to source database system, the present invention includes with lower module:
Load module 1, for judging that the data source that the user inputs is the data of which kind of power equipment, which kind of type, then, according to the feature of input data, the determination module by the Data dissemination of input to affiliated power equipment is further processed;
Determination module 2, this module all has under every kind of power equipment, for the Condition Monitoring Data that load module is obtained, is judged, judges that this Condition Monitoring Data enters into format converting module or receiving processing module;
Format converting module 3, be input to power equipment under native system for the Condition Monitoring Data that load module is obtained, the tractable form of the system that is converted to, and send into the advanced algorithm module;
Receiving processing module 4, be input to power equipment under native system for the data that status monitoring is obtained, and send into the data separating resume module;
Advanced algorithm module 5, carry out the advanced algorithm processing for the easy processing format Condition Monitoring Data that conversion gets to format converting module, comprise denoising, enhancing, sharpening operation, and be input to database management module and finally preserve processing Condition Monitoring Data later;
Data separating module 6, carry out separating treatment for the Condition Monitoring Data that receiving processing module is transmitted, the data layout that is system requirements by the Condition Monitoring Data information separated, and pass to database management module with corresponding virgin state Monitoring Data and finally preserve processing Condition Monitoring Data later;
Database management module 7, receive respectively data and primary data information (pdi) that the Condition Monitoring Data that transmits from the advanced algorithm module and data separating module transmit, sorts out respectively and send into database module and preserve;
Database module 8, receive 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 by 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, database module 8 respectively;
The workflow of this system is as follows:
1) start, start the system general supply;
2) load module 1 requires user input data, data type and affiliated power equipment thereof, by determination module 2 decision data, whether be easy processing format, if the easy processing format of data right and wrong, utilize transfer algorithm in format converting module 3 will input data and transfer tractable form to, data are sent in advanced algorithm module 5 and utilized the advanced processes algorithm to strengthen targetedly data again, then give database management module 7 and database module 8 and deposit image data base in; If the data of input are easy processing format, carry out 3); Described easy processing format refers to the active file forms such as JPG, BMP, but not the easy processing format non-common form such as be DICOM;
3) carry out the figure image intensifying according to the data message feature, as utilize gray-scale transformation method to realize the figure image intensifying, by receiving processing module 4, entered data in data separating module 6, then the data layout that is system requirements by data separating module 6 according to the data message Feature Conversion, together given the data message after advanced algorithm module and data separating module converts and raw data database module 8 and deposit image data base in by database management module 7 afterwards; Finish, workflow exits.
The modules working condition is as follows: 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, database module 8 these eight module parallel runnings, as the user during to system input state Monitoring Data, whether load module 1 needs format conversion to be judged through 2 pairs of these Condition Monitoring Datas of determination module, this Condition Monitoring Data is distributed to format converting module 3 is changed as need carry out format conversion, Condition Monitoring Data is changed to arrangement in format converting module 3, giving advanced algorithm module 5 by transformation result is processed, this module is responsible for using a series of advanced processes algorithms it to be carried out to the processing such as data enhancing and giving database management module 7 filling labels according to the characteristic of Condition Monitoring Data finally depositing in database.
Load module 1 in 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, database module 8 these eight modules all can adopt the prior art module, also can adopt the module of designed, designed.
Claims (1)
1. the power transmission and transformation equipment state monitoring plurality, according to source database system, is characterized in that, comprises with lower module:
Load module (1), for judging that the data source that the user inputs is the data of which kind of power equipment, which kind of type, then, according to the feature of input data, the determination module by the Data dissemination of input to affiliated power equipment is further processed;
Determination module (2), this module all has under every kind of power equipment, for the Condition Monitoring Data that load module is obtained, is judged, judges that this Condition Monitoring Data enters into format converting module or receiving processing module;
Format converting module (3), be input to power equipment under native system for the Condition Monitoring Data that load module is obtained, the tractable form of the system that is converted to, and send into the advanced algorithm module;
Receiving processing module (4), be input to power equipment under native system for the data that status monitoring is obtained, and send into the data separating resume module;
Advanced algorithm module (5), carry out the advanced algorithm processing for the easy processing format Condition Monitoring Data that conversion gets to format converting module, comprise denoising, enhancing, sharpening operation, and be input to database management module and finally preserve processing Condition Monitoring Data later;
Data separating module (6), carry out separating treatment for the Condition Monitoring Data that receiving processing module is transmitted, the data layout that is system requirements by the Condition Monitoring Data information separated, and pass to database management module with corresponding virgin state Monitoring Data and finally preserve processing Condition Monitoring Data later;
Database management module (7), receive respectively data and primary data information (pdi) that the Condition Monitoring Data that transmits from the advanced algorithm module and data separating module transmit, sorts out respectively and send into database module and preserve;
Database module (8), receive 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 by 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), database module (8) respectively;
The workflow of this system is as follows:
1) start, start the system general supply;
2) load module (1) requires user input data, data type and affiliated power equipment thereof, by determination module (2) decision data, whether be easy processing format, if the easy processing format of data right and wrong, utilize transfer algorithm in format converting module (3) will input data and transfer tractable form to, data are sent in advanced algorithm module (5) and utilized the advanced processes algorithm to strengthen targetedly data again, then give database management module (7) and database module (8) and deposit image data base in; If the data of input are easy processing format, carry out 3);
3) carry out the figure image intensifying according to the data message feature, by receiving processing module (4), entered data in data separating module (6), then the data layout that is system requirements by data separating module (6) according to the data message Feature Conversion, together given the data message after advanced algorithm module and data separating module converts and raw data database module (8) and deposit image data base in by database management module (7) afterwards; Finish, workflow exits.
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 CN102609513A (en) | 2012-07-25 |
| CN102609513B true 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) |
Families Citing this family (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 |
| CN116521777B (en) * | 2023-07-05 | 2023-09-22 | 中国水利水电第七工程局有限公司 | Remote interface method for tunnel engineering monitoring data |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100401288C (en) * | 2005-05-30 | 2008-07-09 | 北京慧讯信息技术有限公司 | 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
Also Published As
| Publication number | Publication date |
|---|---|
| CN102609513A (en) | 2012-07-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102609513B (en) | Multi-data-source database system for condition monitoring of electric transmission and transformation equipment | |
| CN203734848U (en) | Internet of Things gateway | |
| CN112788110A (en) | Product appearance detection method based on cloud edge collaborative model optimization and implementation system thereof | |
| CN207882744U (en) | A kind of printing machine monitoring system based on Internet of Things | |
| CN204331799U (en) | Real-time vehicle-mounted cold chain transportation information monitoring system | |
| CN203217033U (en) | Fault positioning and diagnosing system for power distribution network | |
| CN101299770A (en) | Method for processing cooperation information of wireless sensor network | |
| CN103984301A (en) | Cleaning equipment management system based on Internet of things | |
| CN207624035U (en) | A kind of construction site supervisory systems based on recognition of face | |
| CN105677745A (en) | General efficient self-service data search system and implementation method | |
| CN105446203A (en) | Robot power control method and system | |
| CN101739236B (en) | Information processing method of information equipment | |
| RU157928U1 (en) | DEVICE FOR CONTROL AND MANAGEMENT OF THE PRODUCTION PROCESS | |
| CN102508921B (en) | Image database system combining X-ray digital picture with partial discharge map | |
| CN103995676A (en) | Data storage method and device and data processing method and device | |
| CN104267336A (en) | Fault diagnosis system based on circuit breaker operating mechanism | |
| CN104657493A (en) | Transformer winding state multi-data source database system | |
| CN101394640B (en) | Communication resource line patrolling management system and method | |
| CN203165187U (en) | Wireless data acquisition device | |
| CN106777347A (en) | A kind of unmanned plane power-line patrolling big data processing system | |
| CN204086936U (en) | Energy source monitoring system topological structure | |
| CN103679548A (en) | Maintenance strategy database system for power transmission and transformation equipment | |
| CN101788902B (en) | Information equipment | |
| CN206834846U (en) | A kind of power system mid-long term load forecasting system based on PLC | |
| CN205142260U (en) | Router and intelligent house control 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 | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| 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 |
|
| TR01 | Transfer of patent right |