CN104659915A - ETL (Extract-Transform-Load) terminal monitoring device for smart power grid - Google Patents
ETL (Extract-Transform-Load) terminal monitoring device for smart power grid Download PDFInfo
- Publication number
- CN104659915A CN104659915A CN201510053208.4A CN201510053208A CN104659915A CN 104659915 A CN104659915 A CN 104659915A CN 201510053208 A CN201510053208 A CN 201510053208A CN 104659915 A CN104659915 A CN 104659915A
- Authority
- CN
- China
- Prior art keywords
- etl
- terminal
- controller
- equipment
- terminal monitoring
- 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
Classifications
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02B—CLIMATE CHANGE MITIGATION TECHNOLOGIES RELATED TO BUILDINGS, e.g. HOUSING, HOUSE APPLIANCES OR RELATED END-USER APPLICATIONS
- Y02B90/00—Enabling technologies or technologies with a potential or indirect contribution to GHG emissions mitigation
- Y02B90/20—Smart grids as enabling technology in buildings sector
-
- Y—GENERAL 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
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS 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/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/40—Display of information, e.g. of data or controls
-
- Y—GENERAL 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
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS 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
- Y04S40/00—Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them
- Y04S40/12—Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment
- Y04S40/126—Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment using wireless data transmission
Landscapes
- Alarm Systems (AREA)
Abstract
The invention discloses an ETL (Extract-Transform-Load) terminal monitoring device for a smart power grid. The ETL terminal monitoring device comprises a controller, a memorizer, a touch screen, a network interface, a radio frequency identification device, a display screen and a loudspeaker, wherein the controller serves as the core controller of the device and is respectively connected with the memorizer, the touch screen, the network interface, the radio frequency identification device, the display screen and the loudspeaker. The ETL terminal monitoring device for the smart power grid, provided by the invention, has the benefits that the device has the portability and the radio frequency identification function, can support delicacy management and standardized construction of the smart power grid well, promotes the security and the economic efficiency of the electric power system operation, supports electricity big data, and guarantees internal and external data circulation of various business chains.
Description
Technical field
The invention belongs to intelligent grid informatization technical field, particularly relate to a kind of intelligent grid ETL terminal monitoring equipment.
Background technology
In power industry, the developing rapidly of strong intelligent grid makes that ICT (information and communication technology) is just produced with unprecedented range, the degree of depth and electrical network, business administration rapid fusion, information communication system has become " nervous centralis " of intelligent grid, supports electrical network production and administration of new generation development.At present, State Grid Corporation of China has tentatively built up domestically leading, world-class information integrated platform.Along with putting into operation successively of three ground centralized data center, one-level disposes the expansion of service application scope, and the on-line running at structuring and unstructured data center, electrical network business datum all begins to take shape from total amount and kind.Along with progressively popularizing of follow-up intelligent electric meter, electrical network business datum will from the abundant and expansion further of ageing aspect.
State Grid Corporation of China pays much attention to data assets management, it can be used as the basis building strong intelligent grid and " three collection five large " System Construction, and applies that ETL instrument Informatica realizes that Data Data extracts, conversion, to load.ETL is the abbreviation of English Extract-Transform-Load, to be used for describing by data from source terminal through extraction, transposition, to be loaded on the process of destination.
Informatica is as the implementation tool of ETL, combine powerful data analysis, cleaning, coupling, report, monitoring capacity and wieldy interface, a brand-new relation/data warehouse equipment bag can be provided, this connection is expanded to the solution aiming at large data customization, and by being connected with this locality that Transaction Processing (OLTP) and Data Environments (OLAP) data store, provide the access to high flow capacity transaction data.
In the process of routine work running, the data how to be differed from one another by different business are stored in shared database, and do not affect again the data of former business module own and report form, Informatica instrument plays very crucial effect.And to Informatica operation monitoring, safeguards system stable operation just seems particularly important; Fig. 1 is Informatica application architecture.
The conventional main application system of ETL tool monitors mode carries function, and this function can carry out general view to work flow operation information, but can not reach the stable demand of monitoring ruuning situation, maintenance system.Especially need to analyze situation separately to stream compression situation, systemic-function can not embody this type of content completely.Therefore a kind of monitoring means of personalization is lacked at present.
Summary of the invention
In order to solve the problem, the object of the present invention is to provide a kind of intelligent grid ETL terminal monitoring equipment.
In order to achieve the above object, intelligent grid ETL terminal monitoring equipment provided by the invention comprises controller, memory, touch-screen, network interface, radio frequency identification equipment, display screen and loud speaker; Wherein: controller is the core controller of this device, and it is connected with loud speaker with memory, touch-screen, network interface, radio frequency identification equipment, display screen respectively;
Memory is information memory cell, for storage terminal support program, and stores associated profile and terminal operation daily record;
Touch-screen is user's inputting interface, and by touch-screen, user can operate terminal, and after input instruction, terminal makes corresponding response;
Network interface is network connection interface, for being connected with ETL equipment by electric power system Intranet, obtains relevant ETL running log; ETL equipment is connected with controller by network interface;
Radio frequency identification equipment is radio frequency card identifying device, uses radio-frequency card to substitute the login mode of original user name, password, and is controlled authority by different radio-frequency cards, check the ETL running log corresponded simultaneously;
Display screen is device for display of message, by this kind equipment, by graphic interface Dynamic Announce ETL ruuning situation in terminal;
Loud speaker is audio output apparatus, carries out alarm by loud speaker to operation exception situation, realizes various ways and jointly monitors ETL ruuning situation.
Described intelligent grid ETL terminal monitoring equipment also comprises the printer be connected with controller, and controller, by command operating printer, makes printer running log general view information be exported according to customized demand.
Advantage and the good effect of intelligent grid ETL terminal monitoring equipment provided by the invention are:
Expand electric network information monitoring mode, the important applied field that strong intelligent grid is Mobile solution technology is netted in state, this terminal monitoring equipment possesses and carries the functions such as removable, radio-frequency (RF) identification, can support fine-grained management and the Standardization Construction of intelligent grid well.
ETL mobile terminal utilizes controller as nerve center.Controller sends information gathering instruction and carries out customization collection to system information, in conjunction with historical data situation, sends unusual fluctuation decision instruction, makes analysis to system running state, and create output unit in order to control information display format.
ETL mobile terminal is to realize personalized monitoring for target, mainly statistical monitoring is carried out to dimensions such as work flow operation duration, data traffic, flowing mode and user profile, handled easily personnel make reasonable judgement to running situation and health condition, ensure that each business chain bar data normal stream turns, analysis and excavation finally for realizing the large data of electric power provide support.
Accompanying drawing explanation
Fig. 1 is Informatica application architecture schematic diagram.
Fig. 2 is the composition frame chart of intelligent grid ETL terminal monitoring equipment provided by the invention.
Fig. 3 is ETL terminal monitoring schematic diagram
Embodiment
Below in conjunction with the drawings and specific embodiments, intelligent grid ETL terminal monitoring equipment provided by the invention is described in detail.
The object of the invention is to the deficiency overcoming existing ETL monitoring of environmental, on the basis of PC end solidification monitoring, increase personalized customization monitoring, realize monitoring the various dimensions of ETL ruuning situation, support system stable operation.
ETL terminal monitoring is based on system cloud gray model daily record, and strengthening shows the stream compression different information of source and destination end, and in conjunction with local hardware environment, for the internal logic between workflow, circulation criterion, realizes the multi-level requirement of monitor message.
As shown in Figure 2, intelligent grid ETL terminal monitoring equipment provided by the invention comprises: controller 1, memory 2, touch-screen 3, network interface 4, radio frequency identification equipment 5, display screen 6, printer 7 and loud speaker 8; Wherein: controller 1 is the core controller of this device, it is connected with loud speaker 8 with memory 2, touch-screen 3, network interface 4, radio frequency identification equipment 5, display screen 6, printer 7 respectively;
Memory 2 is information memory cell, for storage terminal support program, and stores associated profile and terminal operation daily record;
Touch-screen 3 is user's inputting interface, and by touch-screen, user can operate terminal, and after input instruction, terminal makes corresponding response;
Network interface 4 is network connection interface, for being connected with ETL equipment 9 by electric power system Intranet, obtains relevant ETL running log; ETL equipment 9 is connected with controller 1 by network interface 4;
Radio frequency identification equipment 5 is radio frequency card identifying device, uses radio-frequency card to substitute the login mode of original user name, password, and is controlled authority by different radio-frequency cards, check the ETL running log corresponded simultaneously;
Display screen 6 is device for display of message, by this kind equipment, by graphic interface Dynamic Announce ETL ruuning situation in terminal;
Printer 7 is printing device, by this equipment, running log general view information is printed out according to real needs;
Loud speaker 8 is audio output apparatus, carries out alarm by loud speaker to operation exception situation, realizes various ways and jointly monitors ETL ruuning situation.
Intelligent grid ETL terminal monitoring equipment provided by the invention mainly comprises following four functions:
One, system operation situation
The main information on services of system operation situation major embodiment ETL, comprises Integration Services, data bank, system load situation.This content is from system environments, and the stability that monitoring system is run, for system steadily and surely provides safeguard.
Two, work flow operation situation
The overall condition of workflow between each business module of work flow operation situation major embodiment, business module, and stress the overall details of the stream compression course of processing, comprise workflow title, task names, successfully load the information such as record number, successfully write record number, write failure record number, time of origin and end time.
Three, work flow operation statistics
Work flow anomalies gathers in principal statistical special time period, the information of system cloud gray model exception, for optimization system environment, the design of Perfect the work stream provide resource.This function specifically acts on and comprises system stability rate, the normal operation ratio of workflow, the classification of operation exception situation and ratio, work flow operation duration and linearly describe.
Four, work flow anomalies is detailed
Work flow anomalies detail, in conjunction with operation conditions and operating statistic, embodies emphatically ETL operation exception information, and to abnormal information in addition simple analysis.Mainly comprise system exception situation and proportion, data bank operation exception and proportion, work flow anomalies is described in detail, wherein in work flow anomalies is described in detail, terminate error message for tasks carrying and will provide quick solution, realize the expanded function of monitoring system.
The implementation step of intelligent grid ETL terminal monitoring equipment provided by the invention is as follows:
Step one, definition statement of requirements stage: for the business specialty involved by ETL data pick-up logic, circulation logic, detection requirement defined function demand, and enumerate out specific functional modules and function declaration;
Step 2, safety inspection Qualify Phase: by electric network terminal safety permission mode, inner net computer terminal, by obtaining the distribution of dhcp address, in the assignment procedure to the safety inspection that terminal is correlated with, guarantees that terminal meets corporate security requirement;
Step 3, information gathering mode implementation phase: according to Informatica tool applications framework and work flow operation mode.Realize the automatic collection to functional requirement data.And change into the discernible file of terminal;
Step 4, information ways of presentation design phase: according to defined functional requirement and the operation information collected in early stage, according to different monitoring visual angles with monitor dimension, design information exhibition method;
Step 5, ETL terminal monitoring implementation phase: according to defined good functional requirement and data display scheme, according to the program development flow process of standard, start the realization of ETL terminal monitoring system.Regularly carry out key function testing authentication work in development process, ensure that systemic-function meets the demands.
Claims (2)
1. an intelligent grid ETL terminal monitoring equipment, is characterized in that: described intelligent grid ETL terminal monitoring equipment comprises: controller (1), memory (2), touch-screen (3), network interface (4), radio frequency identification equipment (5), display screen (6) and loud speaker (8); Wherein: the core controller that controller (1) is this device, it is connected with loud speaker (8) with memory (2), touch-screen (3), network interface (4), radio frequency identification equipment (5), display screen (6) respectively;
Memory (2) is information memory cell, for storage terminal support program, and stores associated profile and terminal operation daily record;
Touch-screen (3) is user's inputting interface, and by touch-screen, user can operate terminal, and after input instruction, terminal makes corresponding response;
Network interface (4) is network connection interface, for being connected with ETL equipment (9) by electric power system Intranet, obtains relevant ETL running log; ETL equipment (9) is connected with controller (1) by network interface (4);
Radio frequency identification equipment (5) is radio frequency card identifying device, uses radio-frequency card to substitute the login mode of original user name, password, and is controlled authority by different radio-frequency cards, check the ETL running log corresponded simultaneously;
Display screen (6) is device for display of message, by this kind equipment, by graphic interface Dynamic Announce ETL ruuning situation in terminal;
Loud speaker (8) is audio output apparatus, carries out alarm by loud speaker to operation exception situation, realizes various ways and jointly monitors ETL ruuning situation.
2. intelligent grid ETL terminal monitoring equipment according to claim 1, it is characterized in that: described intelligent grid ETL terminal monitoring equipment also comprises the printer (7) be connected with controller (1), controller (1), by command operating printer (7), makes printer (7) running log general view information be exported according to customized demand.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510053208.4A CN104659915A (en) | 2015-02-02 | 2015-02-02 | ETL (Extract-Transform-Load) terminal monitoring device for smart power grid |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510053208.4A CN104659915A (en) | 2015-02-02 | 2015-02-02 | ETL (Extract-Transform-Load) terminal monitoring device for smart power grid |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104659915A true CN104659915A (en) | 2015-05-27 |
Family
ID=53250728
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510053208.4A Pending CN104659915A (en) | 2015-02-02 | 2015-02-02 | ETL (Extract-Transform-Load) terminal monitoring device for smart power grid |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104659915A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477636A (en) * | 2009-01-15 | 2009-07-08 | 电子科技大学 | Arm type wearable computer terminal equipment |
| CN102539911A (en) * | 2012-01-13 | 2012-07-04 | 广东电网公司电力科学研究院 | Intelligent electric energy metering system under internet-of-things architecture |
| CN103383750A (en) * | 2012-05-04 | 2013-11-06 | 山西省电力公司阳泉供电公司 | Power grid summarized information organic integrated platform |
| CN203368521U (en) * | 2013-07-30 | 2013-12-25 | 贵州电网公司信息通信分公司 | Monitoring large screen based on ETL technology |
| CN104318481A (en) * | 2014-05-04 | 2015-01-28 | 国家电网公司 | Power-grid-operation-oriented holographic time scale measurement data extraction conversion method |
-
2015
- 2015-02-02 CN CN201510053208.4A patent/CN104659915A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477636A (en) * | 2009-01-15 | 2009-07-08 | 电子科技大学 | Arm type wearable computer terminal equipment |
| CN102539911A (en) * | 2012-01-13 | 2012-07-04 | 广东电网公司电力科学研究院 | Intelligent electric energy metering system under internet-of-things architecture |
| CN103383750A (en) * | 2012-05-04 | 2013-11-06 | 山西省电力公司阳泉供电公司 | Power grid summarized information organic integrated platform |
| CN203368521U (en) * | 2013-07-30 | 2013-12-25 | 贵州电网公司信息通信分公司 | Monitoring large screen based on ETL technology |
| CN104318481A (en) * | 2014-05-04 | 2015-01-28 | 国家电网公司 | Power-grid-operation-oriented holographic time scale measurement data extraction conversion method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102687111A (en) | Techniques for power analysis | |
| CN101908165A (en) | Geographic information system (GIS)-based industrial cluster information integration service system and method | |
| CN103593804A (en) | Electric power information communication scheduling and monitoring platform | |
| CN104899384A (en) | Structural health monitoring visualization system based on Revit | |
| CN103325074B (en) | Power system real-time data processing method | |
| CN106210124B (en) | Unified cloud data center monitoring system | |
| CN105574640A (en) | Method for constructing unified and comprehensive management platform of application | |
| CN104007738A (en) | Public building energy efficiency data collecting and processing system based on OPC UA | |
| CN106383763A (en) | Data center intelligent fault detection alarm system | |
| CN106294562A (en) | A kind of electric network information methods of exhibiting and device | |
| CN111082521A (en) | Operation and maintenance data monitoring method and operation and maintenance system of power grid regulation and control system | |
| CN106407072A (en) | Monitoring system of big data platform | |
| CN101944768A (en) | Power equipment state monitoring method, device and system | |
| CN109764915A (en) | According to production environment temperature and humidity intelligent method for early warning, storage medium and intelligent terminal | |
| CN108830540B (en) | Method, device and system for processing engineering project archive | |
| CN104484734A (en) | Low-carbon city energy optimized configuration data center architecture | |
| CN113592210A (en) | Internet of things integrated management platform for water supply non-negative-pressure secondary water supply facility | |
| CN104504491A (en) | Meter reading control method and system | |
| CN108205086A (en) | Monitoring method, device and system for power grid equipment | |
| CN103247087A (en) | City distribution network graphical intelligent anti-misoperation system and method of system | |
| CN104659915A (en) | ETL (Extract-Transform-Load) terminal monitoring device for smart power grid | |
| CN106850322B (en) | Resource equipment management system based on six-layer model | |
| CN203217352U (en) | Machine room wireless monitoring system, handheld device and machine room equipment | |
| CN112688435B (en) | Comprehensive monitoring method, device, control system and storage medium for power grid | |
| CN115438812A (en) | Life-saving management method and device for power transmission equipment, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150527 |