CN103366311B - A kind of Data Fusion method based on transformer station's multisystem - Google Patents

A kind of Data Fusion method based on transformer station's multisystem Download PDF

Info

Publication number
CN103366311B
CN103366311B CN201310291048.8A CN201310291048A CN103366311B CN 103366311 B CN103366311 B CN 103366311B CN 201310291048 A CN201310291048 A CN 201310291048A CN 103366311 B CN103366311 B CN 103366311B
Authority
CN
China
Prior art keywords
data
analysis
interface
module
transformer station
Prior art date
Application number
CN201310291048.8A
Other languages
Chinese (zh)
Other versions
CN103366311A (en
Inventor
张玉龙
邓安明
尹福荣
杨远帜
李睿
王凤
王一凤
陈希龙
Original Assignee
昆明能讯科技有限责任公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 昆明能讯科技有限责任公司 filed Critical 昆明能讯科技有限责任公司
Priority to CN201310291048.8A priority Critical patent/CN103366311B/en
Publication of CN103366311A publication Critical patent/CN103366311A/en
Application granted granted Critical
Publication of CN103366311B publication Critical patent/CN103366311B/en

Links

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
    • Y04S10/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications

Abstract

A kind of Data Fusion method based on transformer station's multisystem, the present invention sets up analysis of data source by the data source integrating transformer station's multisystem;According to analysis of data source, set up the two i.e. data modeling of sets of data model with asset of equipments as core with grid event as core;Follow the data model of foundation, utilize WEBSERVICE interface, data base to directly read, the business datum of each system is extracted by FTP sharing mode respectively;After the business datum of acquisition transformer station related system carries out data integration, data can be carried out classification and share, it is provided that Various types of data service.Problem solved by the invention is to integrate the data source of transformer station's multisystem, there is provided efficiently for transformer station specialty analysis personnel, management personnel, equipment operation information accurately, reduce the blindness of data access, reduce the workload of specialty analysis, increase the work efficiency of specialty analysis.

Description

A kind of Data Fusion method based on transformer station's multisystem
Technical field
The present invention relates to transformer station's multisystem Data Fusion technology, particularly relate to a kind of for realizing transformer station's different pieces of information Data access between source, data cleansing, data conversion, data loading, data, services, data model, Data Integration.
Background technology
Along with the fast development of digital transformer substation, information system quantity gets more and more, and system scale and capacity are increasing, information Measure the hugest.When specialty analysis personnel carry out data analysis, needs call data to checking in different systems, on the one hand increase The blindness of data access, on the one hand add the workload of specialty analysis, reduce work efficiency.
In real work, the information point that different users pays close attention to is different, and same subscriber is in the information point paid close attention to the most in the same time also Difference, the information difference paid close attention between such as different functional departments, between different majors personnel, between leader and common employee is relatively Greatly.
The system quantity of transformer station or concentrator station is more at present, and function is disperseed, and information is overlapped, and data redundancy amount is big.
Summary of the invention
The defect existed for above-mentioned prior art and deficiency, the technical problem to be solved is to provide one can be to power transformation Existing system information of standing is analyzed combing, and the service data information that will be stored in different information systems is integrated, and follows system The data model of one is carried out arranging, and excavates data message according to subject area, arranges and represents, for transformer station's specialty Analysis personnel, management personnel provide efficiently, equipment operation information, the blindness of minimizing data access, professional point of minimizing accurately The workload of analysis, increases the work efficiency of specialty analysis.
In order to solve the problems referred to above, the present invention provides following technical scheme.
A kind of Data Fusion method based on transformer station's multisystem, the invention is characterised in that, by integrating transformer station's multisystem Data source set up analysis of data source;According to analysis of data source, set up with asset of equipments as core with grid event as core The two i.e. data modeling of sets of data model;Follow the data model of foundation, utilize WEBSERVICE interface, data base directly to read Take, the business datum of each system is extracted by FTP sharing mode respectively;The business datum obtaining transformer station's related system is carried out After data integration, data can be carried out classification and share, it is provided that Various types of data service;Wherein:
Analysis of data source includes that company of province layer data integrates module, Substation Station layer data integrates module respectively;Company of province layer data Integrate module to be connected with dispatching patcher data-interface, technical supervision data-interface respectively;Substation Station layer data integrates module respectively It is connected with online monitoring data interface, integrated system data-interface;
Data modeling includes that asset of equipments data module, asset of equipments data module include and data consolidation form module, data Consolidation form module is respectively equipped with data access interface, data output interface;Wherein data access interface respectively with electric parameter Data Input Interface, five anti-information data input interfaces, external environment condition Data Input Interface connect;Data output interface respectively with The ORACLE input interface of data base's output module, formatted data access interface connect;Wherein ORACLE input interface is also It is connected with the ORACLE data base of data base's output module;
Data integration uses and sets up data intermediate database, data intermediate database connect with data base, WEBSERVICE respectively Mouth, ftp server, foreground connect;
Data, services is connected with data analysis module by data middle database data pool, data analysis module the most respectively with more than one Data display service interface, the data analysis service interface of more than connect.
The present invention implements flow process:
1) analysis of data source, for providing intelligent substation analysis result, instructs and provides effectively support for operations staff, on the one hand The dispatching patcher of company of province layer, production management system, weather monitoring system, working-condition monitoring system, technology prison need to be realized Superintend and direct the Data Integration of data analysis center;On the one hand the integrated system of Substation Station layer, five-preventing system, protection need to be realized TT&C system, network work bill system, safety zone monitoring system, security protection ventilating system, power transformation on-line monitoring system Deng Data Integration.
2) data modeling, according to analysis of data source, the data fusion of transformer station's multisystem, needs the data integrated to relate to electrically joining Number, five anti-information, protection observing and controlling, safety zone monitoring, security protection ventilation, management and running, production management, equipment shape The 11 big class data such as state monitoring, lightning monitoring, electric energy quality monitoring, external environmental information.Follow IEC, CIM mark Standard, sets up the two sets of data models with asset of equipments as core with grid event as core.Wherein, with asset of equipments For the data model of core for the longer-term storage of system data, meet the historical data analysis of equipment state and summary Need;Data model with grid event as core, for the instant storage of system data, meets the real-time of grid event Manipulation and instant disposal.
3) data integration, it then follows the data model of foundation, utilize WEBSERVICE interface routine, data base to directly read, The business datum of each system is extracted by the modes such as FTP shares respectively.If the data standard of origin system and offer Data source is unique, then use and set up database link, directly read by SQL statement;If the data of origin system are not Uniquely, and each system data structure there are differences, then require that each origin system is according to unified data model exploitation WEBSERVICE interface routine, it is achieved uploading of data, service end is unified again receives and parses through warehousing;If source The data of system are the data such as non-structured word document, PDF, TXT, picture, then use FTP to share Mode realizes the acquisition of data, and is stored in middle database.
4) data, after obtaining the business datum of transformer station's related system, can be carried out classification and share, it is provided that all kinds of numbers by data, services According to service interface, each operation system can directly from middle database read the business datum that be associated be shown, analyze, Application, provides efficiently for transformer station specialty analysis personnel, management personnel, equipment operation information accurately, reduces data The blindness accessed, reduces the workload of specialty analysis, increases the work efficiency of specialty analysis.
The invention has the beneficial effects as follows, for transformer station specialty analysis personnel, management personnel provide efficiently, equipment operation accurately is believed Breath, reduces the blindness of data access, reduces the workload of specialty analysis, increases the work efficiency of specialty analysis.
Below in conjunction with Figure of description and detailed description of the invention, the present invention is further explained.
Accompanying drawing explanation
Fig. 1 is the flow chart for transformer station's multisystem data fusion of the embodiment of the present invention;
Fig. 2 is analysis of data source structural representation;
Fig. 3 is data modeling constructs schematic diagram;
Fig. 4 is grid event data model schematic diagram;
Fig. 5 is data integration structural representation;
Fig. 6 is data, services structural representation.
Detailed description of the invention:
Illustrate embodiments of the invention are described further below in conjunction with accompanying drawing.
See Fig. 1, a kind of Data Fusion method based on transformer station's multisystem, the invention is characterised in that, by integrating transformer station The data source of multisystem sets up analysis of data source;According to analysis of data source, set up with asset of equipments as core and with grid event be The two i.e. data modeling of sets of data model of core;Follow the data model of foundation, utilize WEBSERVICE interface, data base Directly read, the business datum of each system is extracted by FTP sharing mode respectively;Obtain the business number of transformer station's related system After carrying out data integration, data can be carried out classification and share, it is provided that Various types of data service;Wherein:
Seeing Fig. 2, analysis of data source includes that company of province layer data integrates module, Substation Station layer data integrates module respectively;Company of province Layer data is integrated module and is connected with dispatching patcher data-interface, technical supervision data-interface respectively;Substation Station layer data integrates mould Block is connected with online monitoring data interface, integrated system data-interface respectively;
See that Fig. 3, data modeling include that asset of equipments data module, asset of equipments data module include and data consolidation form module, Data consolidation form module is respectively equipped with data access interface, data output interface;Wherein data access interface respectively with electrically Supplemental characteristic input interface, five anti-information data input interfaces, external environment condition Data Input Interface connect;Data output interface divides It is not connected with ORACLE input interface, the formatted data access interface of data base's output module;Wherein ORACLE input connects Mouth is also connected with the ORACLE data base of data base's output module;
Seeing Fig. 5, data integration uses and sets up data intermediate database, by data intermediate database respectively with data base, WEBSERVICE interface, ftp server, foreground connect;
Data, services is connected with data analysis module by data middle database data pool, data analysis module the most respectively with more than one Data display service interface, the data analysis service interface of more than connect.
The present invention carries out combing integration to transformer station, concentrator station information system, explicit data range of fusion, realizes data fusion machine System, offer data analysis service, both can meet production management of each functional department needs, can meet again substation operation needs, also It is easy to professional and analyzes needs, effectively reduce the blindness of data access, reduce the workload of specialty analysis, increase specialty point The work efficiency of analysis.
It is as follows that the present invention implements flow process:
1) analysis of data source, for providing intelligent substation analysis result, instructs and provides effectively support for operations staff, such as Fig. 2 Shown in, for analysis of data source structural representation.On the one hand analysis of data source need to realize the dispatching patcher of company of province layer, life Produce management system, weather monitoring system, working-condition monitoring system, the Data Integration of technical supervision data analysis center;One Aspect need to realize the integrated system of Substation Station layer, five-preventing system, protection TT&C system, network work bill system, peace The Data Integration of region-wide monitoring system, security protection ventilating system, power transformation on-line monitoring system etc..
2) data modeling, according to analysis of data source, the data fusion of transformer station's multisystem, needs the data integrated to relate to electrically joining Number, five anti-information, protection observing and controlling, safety zone monitoring, security protection ventilation, management and running, production management, equipment shape The 11 big class data such as state monitoring, lightning monitoring, electric energy quality monitoring, external environmental information.Follow IEC, CIM mark Standard, sets up the two sets of data models with asset of equipments as core with grid event as core.Wherein, with asset of equipments For the data model of core for the longer-term storage of system data, meet the historical data analysis of equipment state and summary Need;Data model with grid event as core, for the instant storage of system data, meets the real-time of grid event Manipulation and instant disposal.
Asset of equipments data model is as it is shown on figure 3, equipment real time information is by each different equipment detection information interface Reception information, and by the data access interface entrance data formatting module of data formatting module, data are united One formats.Data after formatting have unified data form, meet and data carry out unified Analysis, data system One storage, the unified requirement shown of data, solve the drawback of the different single corresponding analysis methods of equipment Inspection information Add the effectiveness of data.Format data externally to be exported by the data output interface of data formatting module Data base's input module and form data access interface.Data base's output module is real by accessing existing prevalence data interface Show the support to Sybases such as Oralcle data base, SqlSever data, formatted data has been stored in setting Data base, provides data supporting to operations such as the data analysis in later stage, data statisticss.Formatted data access interface can Output current format data, enable the data after form the most externally to apply in real time, support the data of data exhibiting Updating, showing follow-up real time data provides real time data.
As shown in Figure 4, this model possesses equipment real-time data access to grid event data model and equipment remotely controls merit Energy.The formatted data that equipment real time data connects asset of equipments data model by the automatic request interface of formatted data accesses Interface accesses equipment real time information automatically, and equipment real time information is stored in data real-time database, relies on the data age of real-time database Property, preserving the real time information of equipment, foreground application accesses the facility information in real-time database by the access interface of real-time database And show further.Equipment remotely controls to issue interface by equipment control command and completes equipment control, equipment control Order processed is issued to command area sub-module, and order is made a distinction and uploads to order stipulations combination die by command area sub-module Block, order stipulations composite module carries out specific stipulations combination to adapt to the control of equipment to order, and order stipulations are passed through Stipulations coupling output module is issued to the equipment specified, and completes the long-range control to equipment.
3) data integration, it then follows the data model of foundation, utilize WEBSERVICE interface routine, data base to directly read, The business datum of each system is extracted by the modes such as FTP shares respectively.
As it is shown in figure 5, be data integration structural representation.If the data source of the data standard of origin system and offer is only One, then use and set up database link, directly read by SQL statement, directly access the database;If origin system Data unique, and each system data structure there are differences, then require that each origin system is opened according to unified data model Sending out WEBSERVICE interface routine, it is achieved uploading of data, service end is unified again receives and parses through warehousing, directly Access WebService service interface;If the data of origin system be non-structured word document, PDF, TXT, The data such as picture, then the mode using FTP to share realizes the acquisition of data, and is stored in middle database.Middle database conduct The data pool of all data, provides data support for foreground application.
4) data, after obtaining the business datum of transformer station's related system, can be carried out classification and share, it is provided that all kinds of numbers by data, services According to service interface, each operation system can directly from middle database read the business datum that be associated be shown, analyze, Application, provides efficiently for transformer station specialty analysis personnel, management personnel, equipment operation information accurately, reduces data The blindness accessed, reduces the workload of specialty analysis, increases the work efficiency of specialty analysis.
As shown in Figure 6, for data, services structural representation.Data, services reads data from data middle database becomes data Pond, data categorization module classified by the data in data pool, and to corresponding data display service interface, number According to service interface supply data such as Analysis Service interfaces, facilitate follow-up market demand.

Claims (1)

1. a Data Fusion method based on transformer station's multisystem, it is characterised in that by integrating transformer station's multisystem Data source sets up analysis of data source;According to analysis of data source, set up two with asset of equipments as core with grid event as core Sets of data model i.e. data modeling;Follow the data model of foundation, utilize WEBSERVICE interface, data base to directly read, The business datum of each system is extracted by FTP sharing mode respectively;The business datum obtaining transformer station's related system carries out data After integrated, data carried out classification and shares, it is provided that Various types of data service;Wherein:
Analysis of data source includes that company of province layer data integrates module, Substation Station layer data integrates module respectively;Company of province layer data Integrate module to be connected with dispatching patcher data-interface, technical supervision data-interface respectively;Substation Station layer data integrates module respectively It is connected with online monitoring data interface, integrated system data-interface;
Data modeling includes that asset of equipments data module, asset of equipments data module include and data consolidation form module, data Consolidation form module is respectively equipped with data access interface, data output interface;Wherein data access interface respectively with electric parameter Data Input Interface, five anti-information data input interfaces, external environment condition Data Input Interface connect;Data output interface respectively with The ORACLE input interface of data base's output module, formatted data access interface connect;Wherein ORACLE input interface is also It is connected with the ORACLE data base of data base's output module;
Data integration uses and sets up data intermediate database, data intermediate database connect with data base, WEBSERVICE respectively Mouth, ftp server, foreground connect;
Data, services is connected with data analysis module by data middle database data pool, data analysis module the most respectively with more than one Data display service interface, the data analysis service interface of more than connect;
Implementing flow process is:
1) analysis of data source, for providing intelligent substation analysis result, instructs and provides support for operations staff, on the one hand needing reality The now dispatching patcher of company of province layer, production management system, weather monitoring system, working-condition monitoring system, technical supervision number Data Integration according to analysis center;On the one hand the integrated system of Substation Station layer, five-preventing system, protection observing and controlling need to be realized System, network work bill system, safety zone monitoring system, security protection ventilating system, the number of power transformation on-line monitoring system According to integration;
2) data modeling, according to analysis of data source, the data fusion of transformer station's multisystem, needs the data integrated to relate to electrically joining Number, five anti-information, protection observing and controlling, safety zone monitoring, security protection ventilation, management and running, production management, equipment shape State monitoring, lightning monitoring, electric energy quality monitoring, external environmental information;Follow IEC, CIM standard, set up to set Standby assets are core and the two sets of data models with grid event as core;Wherein, the data with asset of equipments as core Model, for the longer-term storage of system data, meets the historical data analysis of equipment state and the needs of summary;With electrical network Event is the data model instant storage for system data of core, meets the real-time control of grid event and instant place Put;
3) data integration, it then follows the data model of foundation, utilize WEBSERVICE interface routine, data base to directly read, The business datum of each system is extracted by mode that FTP shares respectively;If the data standard of origin system and offer Data source is unique, then use and set up database link, directly read by SQL statement;If the data of origin system are not Uniquely, and each system data structure there are differences, then require that each origin system is according to unified data model exploitation WEBSERVICE interface routine, it is achieved uploading of data, service end is unified again receives and parses through warehousing;If source The data of system are the data of non-structured word document, PDF, TXT, picture, then use FTP to share Mode realizes the acquisition of data, and is stored in middle database;
4) data, after obtaining the business datum of transformer station's related system, are carried out classification and share, it is provided that Various types of data by data, services Service interface, each operation system reads, from middle database, the business datum that is associated and is shown, analyzes, applies, for Transformer station specialty analysis personnel, management personnel provide equipment operation information, reduce the blindness of data access, reduce specially The workload that industry is analyzed, increases the work efficiency of specialty analysis.
CN201310291048.8A 2013-07-11 2013-07-11 A kind of Data Fusion method based on transformer station's multisystem CN103366311B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310291048.8A CN103366311B (en) 2013-07-11 2013-07-11 A kind of Data Fusion method based on transformer station's multisystem

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310291048.8A CN103366311B (en) 2013-07-11 2013-07-11 A kind of Data Fusion method based on transformer station's multisystem

Publications (2)

Publication Number Publication Date
CN103366311A CN103366311A (en) 2013-10-23
CN103366311B true CN103366311B (en) 2016-12-28

Family

ID=49367591

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310291048.8A CN103366311B (en) 2013-07-11 2013-07-11 A kind of Data Fusion method based on transformer station's multisystem

Country Status (1)

Country Link
CN (1) CN103366311B (en)

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103577939A (en) * 2013-11-22 2014-02-12 广东电网公司电力调度控制中心 Grid data management method and system
CN103605767A (en) * 2013-11-26 2014-02-26 国家电网公司 Data access method and system of power transmission lines
CN104699720A (en) * 2013-12-10 2015-06-10 中兴通讯股份有限公司 Merging and storing method and system for massive data
CN104464050B (en) * 2014-11-17 2017-01-11 国家电网公司 Transformer substation gate operation management system
CN104750787B (en) * 2015-03-12 2018-10-12 国家电网公司 Data integration processing system and integrated processing method
CN105425856A (en) * 2015-11-12 2016-03-23 云南电网有限责任公司物流服务中心 Transformer positioning and monitoring device
CN107609987A (en) * 2017-09-19 2018-01-19 广西电网有限责任公司电力科学研究院 A kind of intelligent power transformation operational system of equipment oriented owner
CN109634958A (en) * 2018-11-23 2019-04-16 北斗天地股份有限公司 A kind of method and system of multisystem position data processing
CN109977188A (en) * 2019-03-28 2019-07-05 国网河南省电力公司经济技术研究院 A kind of multi-specialized data correlation fusion method of gradual power grid and device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN201742443U (en) * 2010-05-31 2011-02-09 广西电网公司电力科学研究院 Computer network for testing electric transmission and transformation equipment states
CN102545387A (en) * 2012-01-20 2012-07-04 中国电力科学研究院 Integrated information platform of intelligent substation
CN102750606A (en) * 2012-05-16 2012-10-24 中国电力科学研究院 Power grid scheduling cloud system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN201742443U (en) * 2010-05-31 2011-02-09 广西电网公司电力科学研究院 Computer network for testing electric transmission and transformation equipment states
CN102545387A (en) * 2012-01-20 2012-07-04 中国电力科学研究院 Integrated information platform of intelligent substation
CN102750606A (en) * 2012-05-16 2012-10-24 中国电力科学研究院 Power grid scheduling cloud system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
变电智能化管理指标体系研究;晋伟平;《中国优秀硕士学位论文全文数据库经济与管理科学辑》;20130515(第5期);第2.2.1,3.1.2,4.2.4节,图3.1,3.6,4.1 *

Also Published As

Publication number Publication date
CN103366311A (en) 2013-10-23

Similar Documents

Publication Publication Date Title
CN106253486B (en) A kind of power supply system intelligent fault Computer Aided Analysis System
CN103366312B (en) A kind of intelligent transformer substation cloud system
CN103175513B (en) System and method for monitoring hydrology and water quality of river basin under influence of water projects based on Internet of Things
RU2546320C2 (en) Intelligent network
CN102215253B (en) Layered exchange and control method for real-time monitoring system data by power dispatching
CN105023188B (en) Digital city management data sharing system based on cloud data
CN103595816B (en) Expense plateform system is urged in power marketing integration
JP5616330B2 (en) Method and system for managing a power grid
CN102830681B (en) A kind of method for supervising of remote electric energy consumption data
CN101354408B (en) Electric energy acquisition and operation management system and method based on platform zone centralized service terminal
CN101329564B (en) Computer room management system
CN103077212B (en) Transformer substation configuration file control method and system
CN103198391B (en) Based on power communication system for managing spare part and the method for ant group algorithm
CN103812052B (en) A kind of for without the centralized monitoring system of man-machine polling transmission line and monitoring method
CN103941745B (en) For without the mobile substation of man-machine polling transmission line and method of work
CN105574652B (en) Intelligent power distribution network planning big data management and control system and method
CN103631921B (en) A kind of configuration information of transformer substation detection method and device
CN103914791A (en) Electrical equipment state maintenance system
CN103203277B (en) Ball mill monitoring system based on smart cloud computing platform and monitoring method
CN105187010B (en) The Intellectualized monitoring and operational system of a kind of photovoltaic plant
CN102882969B (en) A kind of safety production cloud service platform of industrial and mining enterprises
CN103441571A (en) Integrated monitoring system information platform for transformer substation
CN103532744B (en) A kind of intelligent grid information communication integral supporting platform
CN103675600B (en) Based on the Fault Diagnosis of Distribution Network system and method for topological knowledge
CN102932419B (en) A kind of data-storage system for the safety production cloud service platform towards industrial and mining enterprises

Legal Events

Date Code Title Description
PB01 Publication
C06 Publication
SE01 Entry into force of request for substantive examination
C10 Entry into substantive examination
GR01 Patent grant
C14 Grant of patent or utility model