CN109829125A - Show the platform of user management of dispatching of power netwoks operation data - Google Patents

Show the platform of user management of dispatching of power netwoks operation data Download PDF

Info

Publication number
CN109829125A
CN109829125A CN201910155935.XA CN201910155935A CN109829125A CN 109829125 A CN109829125 A CN 109829125A CN 201910155935 A CN201910155935 A CN 201910155935A CN 109829125 A CN109829125 A CN 109829125A
Authority
CN
China
Prior art keywords
data
user
dispatching
management
module
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
Application number
CN201910155935.XA
Other languages
Chinese (zh)
Inventor
韩旭
耿云秀
亢可
高晗
韩卓伟
李莹
肖凤军
任会生
闫继龙
勾丽娜
郭军
窦凯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Jilin Electric Power Corp
Original Assignee
State Grid Jilin Electric Power Corp
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 State Grid Jilin Electric Power Corp filed Critical State Grid Jilin Electric Power Corp
Priority to CN201910155935.XA priority Critical patent/CN109829125A/en
Publication of CN109829125A publication Critical patent/CN109829125A/en
Pending legal-status Critical Current

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

The embodiment of the invention discloses a kind of platform of user management for showing dispatching of power netwoks operation data, including the data acquisition module for acquiring operation of power networks dynamic real time data, for the database according to preset data standard format storage operation state real time data, for generating the individuation data configuration module of personal homepage frame structure according to user's input page layout and the instruction of dispatching of power netwoks operation data type configuration, for by user demand data from database extract conversion after, it is loaded onto the data processing module of page presentation management module and individuation data configuration module corresponding position and the page presentation management module of the dispatching of power netwoks operation data information for managing personal homepage displaying.The application realizes user security, rapidly obtains grid equipment management and running data, to meet current demand of the different user to different type grid equipment operation data content.

Description

Show the platform of user management of dispatching of power netwoks operation data
Technical field
The present embodiments relate to power grid technique of management and administration fields, run number more particularly to a kind of displaying dispatching of power netwoks According to platform of user management.
Background technique
Dispatching of power netwoks control technology supports that system time is monitored and controlled to power grid, and the power grid for thus generating magnanimity is set Standby operation data, including real time data and historical data, these grid equipment operation datas have power grid management huge Utility value.
But due to safety problem, these data can only place in dispatch data net (one area of Information Network and 2nd area), electricity These data cannot be used by netting other departments and profession, can only be sent out fixed Web by scheduling controlling technology support system and be taken Business real time data.
Since each administration of power networks department and professional are to grid equipment operation data focus and demand difference, merely It is difficult to can satisfy proprietary needs using the data information that browsing device net page pushes, is also unable to satisfy administration of power networks to power grid The demand of equipment operating data.
How safety obtains dispatching of power netwoks operation data to meet different user to the real need of grid equipment operation data It asks, is those skilled in the art's urgent problem to be solved.
Summary of the invention
The embodiment of the present disclosure provides a kind of platform of user management for showing dispatching of power netwoks operation data, realizes user's peace Entirely, grid equipment management and running data are obtained, rapidly to meet different user in different type grid equipment operation data The current demand of appearance.
In order to solve the above technical problems, the embodiment of the present invention the following technical schemes are provided:
The embodiment of the invention provides a kind of platform of user management for showing dispatching of power netwoks operation data, including data acquisition Module, database, individuation data configuration module, data processing module and page presentation management module;
The data acquisition module is for acquiring operation of power networks dynamic real time data;
The database is used to store the operation state real time data according to preset data standard format;
The individuation data configuration module, for according to user's input page layout and dispatching of power netwoks operation data type The page framework structure of configuration-direct generation personal homepage;
The data processing module is loaded onto institute after user demand data are extracted conversion from the database State corresponding position in page presentation management module and the individuation data configuration module;
The page presentation management module, the dispatching of power netwoks operation data information shown for managing the personal homepage.
Optionally, the data acquisition module includes point number data-acquisition submodule, Excel list data acquisition submodule And E file acquires submodule;
The point number data-acquisition submodule is used for according to the point number information table that constructs in advance from each power grid transactional system Acquire corresponding data;The Excel list data acquisition submodule is used to acquire the management and running data sheet of user's upload;Institute State the data that E file acquisition submodule is used to acquire the push of operation of power networks unified database.
Optionally, the data standard format be by data requirement, data area,
There are environmental element, data existing way, data affiliation and data transfer methods for data recognition rule, data It constitutes.
Optionally, the data information individual cultivation module include layout component, basic configuration component, interactive component and Figure configuration component.
Optionally, the figure configuration component includes page layout preview submodule and graphic attribute configuration submodule.
Optionally, the database includes advance data library and user's application database, and the data processing module is also used In by target data from the advance data library extract conversion after, be loaded onto user's application database.
It optionally, further include user data applications page module, the user data applications page module is according to user's need It asks from user's application database and obtains corresponding data, to show the overall situation and real time execution situation of operation of power networks.
Optionally, the page presentation management module includes that Universal page management shows submodule and individual application center letter Breath management shows submodule;
Wherein, the Universal page management shows submodule for showing pre-set normal grid management and running data Information;The individual application central information management shows that submodule is used for after user successfully logs in, and is believed according to the user of binding Breath shows the dispatching of power netwoks operation data of the customized demand of user in the corresponding position of the personal homepage.
Optionally, the individuation data configuration module includes formula configuration center submodule, the formula configuration center Submodule is used to according to affiliated area, power transformation station name, voltage class, device type determine point number information, and according to the point Number information and the point number parameter detailed annotation information of user's input generate point number formula.
Optionally, the point number formula is made of K character, number and oeprator, each K word in the point number formula Symbol presets meaning of parameters.
The advantages of technical solution provided by the present application, is, by the way that individuation data configuration module is arranged, so that each use Family can custom-configure private page according to self-demand, then transport corresponding dispatching of power netwoks from database according to self-demand The real-time and/or historical data of row state is loaded onto private page and is shown, and each user is achieved that a at the initial stage of foundation People exclusively enjoys, by the data display platform of personal management, and currently display homepage is exclusive generation, personal homepage in terms of personal angle The data content of upper display is that itself is required, to realize user security, rapidly obtain grid equipment management and running Data meet current demand of the different user to different type grid equipment operation data content.
It should be understood that the above general description and the following detailed description are merely exemplary, this can not be limited It is open.
Detailed description of the invention
It, below will be to embodiment or correlation for the clearer technical solution for illustrating the embodiment of the present invention or the relevant technologies Attached drawing needed in technical description is briefly described, it should be apparent that, the accompanying drawings in the following description is only this hair Bright some embodiments for those of ordinary skill in the art without creative efforts, can be with root Other attached drawings are obtained according to these attached drawings.
Fig. 1 is a kind of specific reality of the platform of user management provided in an embodiment of the present invention for showing dispatching of power netwoks operation data Apply mode structural framing schematic diagram;
Fig. 2 is one provided in an embodiment of the present invention exemplary personal homepage display schematic diagram;
Fig. 3 is a kind of disclosure user's custom images page display schematic diagram shown according to an exemplary embodiment;
Fig. 4 is a kind of disclosure user's custom images page display signal again shown according to an exemplary embodiment Figure;
Fig. 5 is a kind of embodiment structure schematic diagram of basic configuration component provided in an embodiment of the present invention;
Fig. 6 is a kind of embodiment structure schematic diagram of CSS component provided in an embodiment of the present invention;
Fig. 7 is a kind of embodiment structure schematic diagram of layout component provided in an embodiment of the present invention;
Fig. 8 is a kind of embodiment structure schematic diagram of figure configuration component provided in an embodiment of the present invention;
Fig. 9 is a kind of embodiment structure schematic diagram of interactive component provided in an embodiment of the present invention;
Figure 10 is that component property provided in an embodiment of the present invention configures page display schematic diagram;
Figure 11 is that additional matter provided in an embodiment of the present invention configures page display schematic diagram;
Figure 12 is that illustrative example provided in an embodiment of the present invention configures page display schematic diagram;
Figure 13 is that point number formula provided in an embodiment of the present invention configures page display schematic diagram.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, with reference to the accompanying drawings and detailed description The present invention is described in further detail.Obviously, described embodiments are only a part of the embodiments of the present invention, rather than Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise Under every other embodiment obtained, shall fall within the protection scope of the present invention.
The description and claims of this application and term " first ", " second ", " third " " in above-mentioned attached drawing Four " etc. be for distinguishing different objects, rather than for describing specific sequence.Furthermore term " includes " and " having " and Their any deformations, it is intended that cover and non-exclusive include.Such as contain a series of steps or units process, method, System, product or equipment are not limited to listed step or unit, but may include the step of not listing or unit.
After describing the technical solution of the embodiment of the present invention, the various non-limiting realities of detailed description below the application Apply mode.
Referring first to Fig. 1, Fig. 1 is the platform of user management provided in an embodiment of the present invention for showing dispatching of power netwoks operation data A kind of structural block diagram under specific embodiment, the embodiment of the present invention may include the following contents:
The platform of user management for showing dispatching of power netwoks operation data may include data acquisition module 1, database 2, personalization Data configuration module 3, data processing module 4 and page presentation management module 5.
Data acquisition module 1 can be three for acquiring operation of power networks dynamic real time data, operation of power networks dynamic real time data Kind formatted data, i.e. point number, Excel list data and E file data.Correspondingly, data acquisition module 1 may include point number Data-acquisition submodule, Excel list data acquisition submodule and E file acquire submodule.Point number data-acquisition submodule is used Corresponding data is acquired from each power grid transactional system in the point number information table that basis constructs in advance;Excel list data acquisition Module is used to acquire the management and running data sheet of user's upload;E file acquisition submodule unifies number for acquiring operation of power networks The data pushed according to library.Wherein, point number is SCADA system (Supervisory Control And Data Acquisition, data acquisition and supervisor control), AGC (Automatic Generation Control, automatic generation Control system), EMS (Energy Management System, Energy Management System), OMS (Power dispatching Management system, power dispatching managemant system), PMS (power production management system, electricity Power production management system) etc. power grids transactional system generate;E file data is the number pushed by operation of power networks unified database According to;Excel list data is the data in the management and running data sheet that user such as network operation personnel etc. manually uploads, such as Dispatch daily paper, scheduling data sheet, dispatcher's electricity statistical report form etc..
EMS is automation system for the power network dispatching, the modern electric complex automatic system based on computer technology, SCADA is the basic module of EMS, completes collection, processing explanation, storage and the display of data, and these real time information are transmitted Give other application module.It is mainly used for information processing control, alarm and processing, sequence of events recording and emergency review inverting.
Data are generally divided into digital quantity input, output;Analog input and analog output can claim such a data For a bit, the point number table of in general substation is the summary sheet for acquiring substation operation, the specific point for monitoring data.
Point number in operation of power networks dynamic real time data may include all kinds of operation informations that dispatching of power netwoks needs, such as Fault message, protection and switch motion, remote signalling, telemetering, remote control, remote regulating, five remote signalling breath of remote viewing information, online monitoring data etc..
The point number information table for needing collection point number can generally be constructed in advance, system is according to point number information table from each affairs Property system in acquire respective point number.The primary and secondary equipment of power grid that system can need to monitor and control according to operation of power networks Unit, node, state, operation data etc. automatically create point number information table, the name according to scheduling to unit, have automatic Change the information table of the corresponding signal acquisition point of profession establishment.
Point number information table may include following content: 1, equipment running status point: the switch (breaker) at interval, disconnecting link (every Leave pass) state point and its auxiliary contact.2, equipment operating parameter point: busbar voltage (including phase voltage, line voltage), frequency Rate;The voltage of electric power incoming line, electric current, active power, reactive power;(transformer can want high-low pressure to the electric current of each load spacer Side electric current, active power, reactive power;The electric current etc. at mother interval.3, equipment measuring parameter point: active, the nothing of electric power incoming line Function electric energy;The active energy 4 of load spacer, automation equipment, relay protection basic condition protect definite value, operation conditions, movement Situation).
In one embodiment, system can be used java applet and counted when acquiring data according to point number information table According to collection scheduling task, it is contemplated that acquisition data volume is excessive, and in order to improve data acquisition efficiency, multi-thread concurrent progress can be used The collecting work of data.In addition, can also be timed creation thread by the timed task in Java and distribute execution task letter It ceases (such as 5 minutes/period), the judgement of point number information table is increased during task execution, judges whether point number information table is deposited It is such as being not present, acquisition tasks can carry out the creation of point number information table automatically according to point number information, to avoid being operating abnormally Phenomenon.
Excel list data, user can periodically be scheduled the upload of daily paper Excel file information daily, and system can be according to The parsing of file is carried out according to the format of Excel.After user uploads, system can it is asynchronous by Excel with the shape of file stream Formula transfers to backstage Java code to be handled, and Jxl can be used as main analytic technique, and Jxl, which can be convenient, flexibly to be navigated to Cell location and content using the parsing for carrying out carrying out content line by line to Excel, and are identified to area content blocks Point, the curve graph carried inside resolution file excavates data entrained by figure, when in file there are when Merge Cells, Jxl can filter out the place row or column of Merge Cells, avoid the error between the data and real data of parsing.
E file data formal layout is substantially carried out connection transmitting information between not homologous ray, by Ftp server and Web Service interface carries out the transmission of E file, the generation of file is carried out according to the file generated specification associated documents write, really It is identical as the rule generated to protect parsing, guarantees that actual data information effectively acquires.Ftp is arrived by collection scheduling task timing Server carries out the access of data information, and web Service interface is direct-connected, accesses data resource interface service by WebService, File is transmitted with the file stream in Java, and file stream is generated the parsing that file carries out file, carries out data information storage Realize the acquisition of data information.Data format specifications, since E file contains the entity and item name of data model, simultaneously There are also the details of field before data block, so E file is very accurately, clearly to the description of data entity itself Relationship between data entity.Due to may include the data block of different structure, while these structures in the same E language file Different data blocks has independent entity and item name again.Pass through the relationship and three kinds of E language tables of entity and item name Up to format: can clearly express the one-to-one and many-one relationship expressed between entity by E language file.
For operation of power networks dynamic real time data in addition to various reports are manually uploaded with Excel table, other are all to establish data Interface protocol obtains automatically.
Data source, which chooses acquisition principle, should have automatic identification ability, various data can be collected according to using theme At be associated with, obtain data from SCADA/AGC, EMS, protection analysis system, the transactional systems such as OMS system, can establish corresponding Data subject analysis and excavation.
Before carrying out data acquisition, data acquisition flow specification can be pre-established and data provide standard process.
The data acquired from Various types of data source are not modified to be stored according to preset data standard format, Data structure establishes the data structuring model of standardization, to adapt to big data, diversification, carry out data extraction and place to dimension Reason.
Operation of power networks dynamic real time data may include that basic data (such as may include the primary equipment of power grid, secondary device With the running state data of the equipment such as automation equipment), real-time data of power grid (such as may include SCADA system and WAMS system The grid operation data of acquisition), power grid near-realtime data (such as may include load prediction, generation schedule, maintenance plan, alarm The data such as information.)
According to regulation center status, service management and system application requirement can be established and meet the practical feelings of information in power dispatching center The power scheduling object structure model of condition.The scheduler object being related to for dispatching data based on this model is segmented, such as Can be divided into the objects such as company, power grid, mechanism, plant stand, equipment, and power network object is related to basic information, operation data, event Information is integrated and is processed.The foundation of data model is enable to respond quickly the report demand of each sections in regulation center, interface clothes The application such as business, data query is able to use family and conveniently inquires required historical data, including metric data, measurement pole Value Data, remote signalling displacement data, alarm data, overhaul data etc..
Wherein, power scheduling object structure model is for establishing power network wiring data dynamic analog figure, operation of power networks knot Structure topological diagram etc., power network wiring simulation drawing can carry out operation of power networks monitoring and control;Operation of power networks structural topology figure can carry out The advanced application such as Load flow calculation, short circuit calculation, the equipment verification of power grid.Power scheduling object structure model may include that power grid connects The parameter of the buildings such as cable architecture, the title of each electrical component, parameter, number, direction connects, and the construction method of model can be used Any the relevant technologies, the application do not do any restriction to this.
From the point of view of data type or data use, these data can include:
The common class data for defining organization and electric power container, such as company, scheduling, power grid, plant stand, control section, control Area processed etc.;Electric power system model data, such as calculating parameter, figure, topological relation are described;Characterize Operation of Electric Systems operating condition (telemetering, remote signalling) data are measured, metric data can be subdivided into stable state, dynamic, Temporal Data again;Reflect running environment outside electric power Related data, such as temperature, thunder and lightning, heavy rain, typhoon, icing, mountain fire;The process data of recording dispatching business, as repair ticket, Operation order, fixed value list etc.;All kinds of events of operation of power networks are recorded, such as failure, exception, defect, rations the power supply, draw road item;It is all kinds of The operating statistic data of equipment, such as transformer load maximum, minimum, average, heavily loaded rate, distribution probability;All kinds of electric power containers Statistical data, such as power plant/substation electric power (timing values), electricity (day, the moon, year be accumulative, on year-on-year basis, ring ratio);It is all kinds of The statistical data of electric power tissue, such as power grid/genco power load, electricity consumption, generation power, generated energy).
Database 2 is used to store the operation state real time data, the wound of database 2 according to preset data standard format The database creation technique for seeing any type is built, such as oracle database can be used in the application, the application is to this Any restriction is not done.For the ease of data call, inquiry and management, can preliminary setting data cannonical format, by data acquisition module The data that block 1 acquires carry out specification handles according to preset data standard format on the basis of its former format, that is, by power grid It is stored in database 2 after the conversion of operation state real time data and pretreatment.It in one embodiment, can be from technical standpoint level The data format specifications of operation of power networks dynamic real time data are formulated, numerical nomenclature for example can be as described below:
Data requirement: type, length, precision etc..
Data area: data value range, code and code set.
Data recognition rule: a such as record data in terms of separators.
There are environmental elements for data: which system is such as data belong to, from which table or which file.
Data existing way: database/file/memory, structuring/unstructured.
Data affiliation: which data fork is data be from.
Data transfer method (or data change mode): data are hinted obliquely at, data mart modeling is converted, code conversion, stream compression Etc. rules.
Certainly, other data format specifications can also be used, authority data is carried out to the data that data acquisition module 1 acquires, this Any restriction is not done in application to this.
Individuation data configuration module 3 is used for according to user's input page layout and dispatching of power netwoks operation data type configuration Instruction generates the page framework structure of personal homepage.
User can formulate the data information that personal homepage shows according to self-demand, that is to say, that can be to individual The formulation of dispatching of power netwoks operation data content and page layout formats that homepage is shown.Individuation data configuration module 3 provides Comprehensive control is available, it may include layout component, basic configuration component, interactive component and figure configuration component.
The dispatching of power netwoks operation data content that personal homepage is shown can pass through newly-increased title and chart class corresponding with title Type, configuration item title, point number formula etc. realize the configuration to data content.
Basic configuration component includes some common components, such as title bar, paragraph, address, list, table, button, figure Piece, button group, drop-down menu, navigation, text, media, navigation bar, switch card, prompting frame etc.;Figure configuration component may include drawing Koji-making line chart, column diagram, pie chart, histogram, section limit value figure, meter diagram, etc. graphical tools;Interactive component may include mask Forms, navigation bar, switch card, prompting frame, accordion switching, rotation figure etc..
Individuation data configuration module 3 can realize any position that random component is drawn to editing area, visual right Random component carries out editor and delete operation.Preview function can also be provided (i.e. comprising page cloth for the addition of figure configuration component Office's preview submodule), it can see the page integral layout formulated after completing, figure configuration component attribute letter can also be provided The configuration (configuring submodule comprising graphic attribute) of breath, the attribute of different graphic configuration component also differs widely.Curve graph category Property may include: the curve number of displaying and the corresponding title of every curve, the point number formula of the corresponding configuration of every curve, data Display mode (such as static or real-time);Column diagram attribute may include: the corresponding title of cylindrical region number and every piece of region, often The corresponding point number formula in block region, unique identification major key;Pie chart attribute may include the width value and height value of pie chart, region Title and corresponding point number formula.
Wherein, point number formula is that any point number is established a new point by oeprator as needed by user oneself Number, title is defined by the user, and saves as the point number that can be called for other users, for example, Taobei District block supply amount, electricity consumption electricity Power be added by several substations with several route electricity consumptions in several substations or load power total plus.
Individuation data configuration module 3 includes formula configuration center submodule, and formula configuration center submodule is used for basis Affiliated area, power transformation station name, voltage class, device type determine point number information, and inputted according to point number information and user Point number parameter explains in detail information and generates point number formula, and point number parameter explains in detail the meaning that information is each point number parameter in point number formula. That is, the configuration of point number formula can carry out point number by the formula configuration center submodule in individuation data configuration module 3 It is unique to choose, unique point number information can be finally confirmed by affiliated area, power transformation station name, voltage class, device type. In one embodiment, the generation type of point number formula can be embodied by K character, that is to say, that point number formula is by K Character, number and oeprator composition, such as ((K1+K2)*K3+ 0.5) 1,0 provides point number detailed annotation simultaneously, i.e., in point number formula Each K (K1、K2、K3) representated by information carry out the explanation of meaning of parameters, the meaning of parameters of all K characters in point number formula It forms point number parameter and explains in detail information, the meaning of institute's allocation formula is explained convenient for user itself.User carries out wrong point number formula Point number parameter information can be synchronized when amendment, such as by some K in formula1When being modified, while the deletion pair in point number detailed annotation The explanation information answered, and update revised correct explanation information.Data can bind the user information currently formulated, mesh when saving Be during data exhibiting be not in the problems such as page is obscured.
Data processing module 4 is used for user demand data after extracting conversion in database, is loaded onto page presentation pipe Manage corresponding position in module 6 and individuation data configuration module 3.
Data processing module 4 is based on ETL technology, and ETL (Extract Transform Load extracts conversion load) is used to Process of the description by data from source terminal by extraction (extract), conversion (transform), load (load) to destination, Required data are extracted from data source, by data cleansing, finally according to the data warehouse model pre-defined, by data It is loaded into data warehouse.
ETL tool can be managed as independent data processing module by system manager, itself has statistical analysis Ability carries out class definition functions to some new formatted datas, can also be confirmed by administrator can as the screening factor, Or management user uses the memory of noun frequency, as object element, to meet data uniqueness and standardized format into ETL, may be used also Generate within every three minutes the historical data of a data and generation 3 years.
Page presentation management module 5 is used to manage the dispatching of power netwoks operation data information of personal homepage displaying, that is to say, that Manage dispatching of power netwoks operation data information and the corresponding position it will be shown in personal homepage.
In a specific embodiment, personal homepage may include two display pages, i.e., the individual application center page and Universal page.Correspondingly, page presentation management module 5 may include that Universal page management shows submodule and individual application center letter Breath management shows submodule;Wherein, Universal page management shows submodule for showing pre-set normal grid scheduling fortune Row data information;Individual application central information management shows that submodule is used for after user successfully logs in, according to the user of binding Information shows the dispatching of power netwoks operation data of the customized demand of user in the corresponding position of personal homepage.
The display content of the Universal page of different user can be identical, and the page layout of Universal page can also be identical, current page The dispatching of power netwoks operation data content that the page layout and the page in face are shown can be preset.Universal page shows that content may include Bore hair is respectively dispatched in each region electricity consumption situation, thermal power plant, wind power plant, photovoltaic power generation, net provinces and regions in operation of power networks overall condition, net Electricity consumption situation and grid maintenance, visiting, fault condition etc.;The individual application center page is that user shows after successful log homepage The page, the content that the individual application center page is shown is related to the user information bound in advance, that is to say, that in individual application The page layout progress page that the heart page is shown the data information of user demand or customizes in advance according to user is shown Either corresponding dispatching of power netwoks running state data is shown in the corresponding position of the preset page layout of user.A People shows that the achievable page layout of submodule, universal meter production, datagraphic production are (curve graph, straight using central information management Fang Tu, section limit value figure, meter diagram, pie chart) and the definition of point number formula etc..
In this application, ETL major embodiment is applied in 3 data of personal homepage data processing and individuation data configuration module Processing.
Personal homepage data management: realizing the configuration to personal homepage map and other figures, customized to not same district Domain shows the definition of data and the definition of zone name, realizes the definition to curve graph, column diagram and pie chart, realization pair The individuation data of homepage map area data is formulated, and the differentiation of field color and the period of data retrieval, ultimately forms confession The datalogging information of parsing.
Individuation data configuration: each user enters individuation data configuration module by backstage individual center, to certainly The module that oneself is concerned about is formulated, such as can be defined to the data of column diagram, curve graph and pie chart, mainly includes mould Block title, wide height, X-axis/zone name, X-axis/zone name, data display mode (static/dynamic).
Key data source of the above two o'clock as ETL can be filtered data in the process of processing data, that is, use The discarded configuration information in family, but configuration information will not be deleted but can be investigated to the value of data by system, such as It is availability data when user formulates data, this configuration can be supplied to user, realize data accumulating function Energy.Data source definitions can distribute each item data the storage that a table is convenient for data after completing, rather than institute is in need The data handled are stored into a table, it is therefore an objective to which data can fast and accurately position and the promotion of retrieval rate. ETL can carry out the binding of association attributes, including association user, corresponding module name during extracting change data to data The information such as title, point number formula, time, data information needed for ultimately forming page presentation.
In addition, in the data active push to the personal homepage of user that most users can be also concerned about by system manager, That is, system manager can will retrieve the high dispatching of power netwoks operation data active push of frequency to each user.
In technical solution provided in an embodiment of the present invention, by the way that individuation data configuration module is arranged, so that each use Family can custom-configure private page according to self-demand, then transport corresponding dispatching of power netwoks from database according to self-demand The real-time and/or historical data of row state is loaded onto private page and is shown, and each user is achieved that a at the initial stage of foundation People exclusively enjoys, by the data display platform of personal management, and currently display homepage is exclusive generation, personal homepage in terms of personal angle The data content of upper display is that itself is required, to realize user security, rapidly obtain grid equipment management and running Data meet current demand of the different user to different type grid equipment operation data content.
Usually, scheduling controlling operation data, scheduling energy management system generate data, power dispatch system operation and management system produces The data volume of the operations of power networks dynamic real time datas such as raw data, power grid operation data, management and running demographic data's report is larger, such as Generally just there is a point more than 10,000 in one substation, and dynamic data resolution ratio is all nanosecond, and a regional dispatch administration will 60 or more substations, the data volume of generation are very huge.The dispatching of power netwoks operation data demand of different users is different, from depositing Itself information needed of 2 query and search of database of storage net operation state real time data needs the long period, in order to improve user The efficiency of dispatching of power netwoks operation data is obtained, can be the dedicated database of different types of user setting, data acquisition module 1 will Its data acquired is stored to advance data library, can be each user setting user application database, according to the need of different user It asks by the data information memory of its possible demand into corresponding user's application database, i.e., according to the customized extraction number of user According to data dynamic link is established, the application database of user-specific is established.It, can be directly corresponding when user's data needed for calling User's application database in query and search, when corresponding user's application database retrieval less than required data letter Breath, then inquired into advance data library, so that effectively promoting user obtains dispatching of power netwoks operation data efficiency.User applies data The operation of power networks dynamic historical data for needing to show and real time data can be stored in library, the key comprising showing the retrieval provided Content, page configuration information and data calculation formula etc..
Operation of power networks dynamic historical data is from transactionals systems such as SCADA/AGC, EMS, protection analysis system, OMS system It being acquired in system, the data in dispatching of power netwoks daily paper are that report obtains, and user power utilization information is that power grid operation unified database obtains, Overhaul of the equipments information is obtained from OMS and PMS.
For example, advance data acquisition preprocessed data amount is very huge and many and diverse, such as is accessing 56 substations With scheduling normal operating devices interruption maintenance information, one month data just generates 3 G bytes, independent data processing server Resource utilization ratio up to 40% or so, be typically necessary to handle sole user's data by the way of directly acquiring 30 seconds or more, using delamination process, the data application library of user oneself is established, wanting to the data just selected can be at 22 point The real-time processing of historical data is carried out afterwards, and a User Page general in this way, which is shown, to be no more than 10 seconds.
Database 2 may include advance data library and user's application database, and the data extracted from preposition database are storing When to user's application database, it can be handled by data processing module 4.Data processing module 4 be used for by target data from After conversion is extracted in advance data library, it is loaded onto user's application database.That is, data processing is i.e. by data from source terminal (advance data library) passes through the process extract, convert, being loaded onto destination (user's application database), extracts institute from data source The data needed, finally according to the data warehouse model pre-defined, load data into data warehouse by data cleansing It goes.The technical solution that specific implementation process can refer to the record of ETL the relevant technologies just repeats no more herein.
There are two functions for the tool of data processing module 4, and one is for the data in advance data to be cleaned and handled Afterwards, disaggregatedly history real time data is established, to call directly or calculate for system;Another function is by user Corresponding data load is in personal homepage and individuation data configuration module corresponding position in application database.
Database is shown by establishing independent User Page, and data needed for storing customer data base only ensure that use The rapidity that family personal homepage face is shown improves the efficiency that user obtains dispatching of power netwoks operation data.
Optionally, data acquisition specification process can be as described below: to service source system (such as SCADA, EMS, PMS, power grid Operation unified database) analyse in depth-determine data area-and establishes model-to data according to interface specification acquisition data- It carries out modelling processing-data and enters data warehouse-data and summarize to be supplied to each business application system.
Optionally, data offer process can be as described below: proposing data requirements-regulation big data pipe by target service system Platform demand analysis-provides data according to the specification of target call for demand process data-.
During data provide, big data treatment technology can be used for example: factorial analysis, Cluster Classification, fast Speed judgement etc..
When being processed for demand data, by taking application oracle database as an example, the fast formatting of subregion point has been carried out The large-scale distributed data warehouse frame of a concentration is established, since the data volume of importing is big, the import volume of each second is frequent 100,000,000 can be reached, while number of concurrent is high, each point will real-time acquisition program module because different user has different demands Enormous amount is called, while being possible to that thousands of access and operation can be generated into, one of to solve the problems, such as to take two links pair Data are handled, by those data and warp of the data sources from front end by processing different data type and format Crossing factorial analysis, clustering, principal component analysis, quick clustering method and clustering procedure, discriminant analysis, correspondence analysis technology etc. will count According to carry out classify and the pretreatment that data become 3 minutes points is imported into Distributed Data Warehouse, then pass through ETL work After tool is responsible for data by distribution, in heterogeneous data source, such as relation data, flat data file are drawn into interim middle layer It cleaned, converted, integrated, removed data that are unconcerned, invalid, going against accepted conventions, be finally loaded into data warehouse, guarantee number According to complete and high quality valid data, become user's application database on basis, and assign it is associated call have 3 years data of history, for the optional point number called of user or formula point number.
In order to make those skilled in the art more understand the technical solution of the application, present invention also provides specific examples To illustrate the details of technical scheme, it may include the following contents:
Individual center can be accessed (as shown in Figure 2) by entrance quick in personal homepage, can also be by IE Address field input address directly accesses, such as address can be http: // 10.165.133.164, and input username and password logs in System accesses personal homepage by click " management and running data application homepage ".
In the customized figure for entering individual center default display active user's configuration, such as shown in Fig. 3.
The corresponding self-defining data being currently configured of the Edit button is clicked to be custom-configured again.
It clicks menu on the left side and selects the Custom component needed to configure, the component for including mainly has following content, please refers to Shown in Fig. 3, the functional module that each component includes is seen described in Fig. 5-Fig. 9.
Layout component can first be dragged first, the representatives such as 12,6.6,8.4 in layout component mean the page is divided into it is several A part, the ratio that each part occupies are how many, layout component is established complete after, figure configuration component, substantially can be dragged Configuration component, interactive component, CSS the component achievable customized page configuration into each layout component.
To every class component, the Edit button for clicking component opens the configuration page of current component, and configuration current component needs Data information to be shown please refers to shown in Figure 10:
Title (must fill out): the title that current component is shown.
ID (must be filled out): unique identification current component label, click " generating ID " system automatically generated unique identification.
It is wide, high: the width and height that setting component is shown.
Line title: the title that each line of curve graph is shown, a curve drawing system provide 4 curves.
Formula: configuring the data that each line is shown, that is, respectively corresponds which point number or point number formula.
Reference line: same period comparison.
Type: in real time and static.Real-time system can periodically carry out data query and show.The static state offer period is counted It is investigated that asking.
It determines: saving current configuration information.
Cancel: abandoning current configuration information.
" dragging " button for clicking component can drag to any position in current page.
Component " deletion " button is clicked, component is deleted.
" preservation " button is clicked, preservation custom-configures information, and system can carry out working as number of days automatically according to the data of definition According to operation, for inquiry use, historical data can daily morning carry out data operation.
The " Cancel " button is clicked, the configuration information currently defined is abandoned.
The additional matter configuration of private page is seen shown in Figure 11:
" newly-increased " button is clicked, new configuration item is increased, can be used for accidentally deleting default configuration information use, be shown in homepage The effect shown can be as shown in 12.
Title: it is mainly used for identifying configuration item.
Subtype: region electric power is accounted for for electric power accounting, regional generation accounting, for electric power accounting (second level), regional generation The module that different homepages are shown is respectively corresponded than (second level) to be configured.
Title: configuration item title.
" configuration " button is clicked, to needing data to be shown to carry out custom formula configuration, as shown in figure 13:
The positioning and selection of point number are carried out by chosen area, substation, voltage class, point number type condition, system is silent Recognize the point number chosen by K1 key representations, point number parameter information can be looked by " meaning of parameters " configured in the page It sees, such as: ((K1+K2)*K3+0.5)/10。
K1, K2, K3, K4 are needed to fill in manually, be counted filling in by choosing point number system automatically generated, arithmetic operator symbol Input method is switched into English state when operator.
" synchronization " button uses when deleting for formula configuration error, it is therefore intended that point number and formula in " meaning of parameters " In be consistent." confirming button " is clicked after the completion of configuration and determines configuration, is clicked the " Cancel " button and is abandoned being currently configured.
The Edit button is clicked, configuration information is changed.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with it is other The difference of embodiment, same or similar part may refer to each other between each embodiment.
Professional further appreciates that, unit described in conjunction with the examples disclosed in the embodiments of the present disclosure And algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware and The interchangeability of software generally describes each exemplary composition and step according to function in the above description.These Function is implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Profession Technical staff can use different methods to achieve the described function each specific application, but this realization is not answered Think beyond the scope of this invention.
The step of method described in conjunction with the examples disclosed in this document or algorithm, can directly be held with hardware, processor The combination of capable software module or the two is implemented.Software module can be placed in random access memory (RAM), memory, read-only deposit Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technology In any other form of storage medium well known in field.
Above to it is provided by the present invention it is a kind of show dispatching of power netwoks operation data platform of user management carried out in detail It introduces.Used herein a specific example illustrates the principle and implementation of the invention, the explanation of above embodiments It is merely used to help understand method and its core concept of the invention.It should be pointed out that for the ordinary skill people of the art Member for, without departing from the principle of the present invention, can with several improvements and modifications are made to the present invention, these improve and Modification is also fallen within the protection scope of the claims of the present invention.

Claims (10)

1. a kind of platform of user management for showing dispatching of power netwoks operation data, which is characterized in that including data acquisition module, data Library, individuation data configuration module, data processing module and page presentation management module;
The data acquisition module is for acquiring operation of power networks dynamic real time data;
The database is used to store the operation state real time data according to preset data standard format;
The individuation data configuration module, for according to user's input page layout and dispatching of power netwoks operation data type configuration Instruction generates the page framework structure of personal homepage;
The data processing module is loaded onto the page after user demand data are extracted conversion from the database Face shows corresponding position in management module and the individuation data configuration module;
The page presentation management module, the dispatching of power netwoks operation data information shown for managing the personal homepage.
2. the platform of user management according to claim 1 for showing dispatching of power netwoks operation data, which is characterized in that the number It include point number data-acquisition submodule, Excel list data acquisition submodule and E file acquisition submodule according to acquisition module;
The point number data-acquisition submodule is used to be acquired according to the point number information table constructed in advance from each power grid transactional system Corresponding data;The Excel list data acquisition submodule is used to acquire the management and running data sheet of user's upload;The E File acquisition submodule is used to acquire the data of operation of power networks unified database push.
3. the platform of user management according to claim 1 for showing dispatching of power netwoks operation data, which is characterized in that the number It is that there are environmental elements, data existing way, number by data requirement, data area, data recognition rule, data according to cannonical format It is constituted according to affiliation and data transfer method.
4. the platform of user management according to claim 3 for showing dispatching of power netwoks operation data, which is characterized in that the number It is believed that breath individual cultivation module includes layout component, basic configuration component, interactive component and figure configuration component.
5. the platform of user management according to claim 4 for showing dispatching of power netwoks operation data, which is characterized in that the figure Shape configuration component includes page layout preview submodule and graphic attribute configuration submodule.
6. according to claim 1 to the platform of user management for showing dispatching of power netwoks operation data described in 5 any one, feature It is, the database includes advance data library and user's application database, and the data processing module is also used to number of targets According to after extracting conversion in the advance data library, it is loaded onto user's application database.
7. the platform of user management according to claim 6 for showing dispatching of power netwoks operation data, which is characterized in that further include User data applications page module, the user data applications page module is according to user demand from user's application database Corresponding data is obtained, to show the overall situation and real time execution situation of operation of power networks.
8. the platform of user management of dispatching of power netwoks operation data, feature are shown described in -5 any one according to claim 1 It is, the page presentation management module includes that Universal page management shows that submodule and individual application central information management are shown Submodule;
Wherein, the Universal page management shows submodule for showing pre-set normal grid management and running data letter Breath;The individual application central information management shows that submodule is used for after user successfully logs in, according to the user information of binding The dispatching of power netwoks operation data of the customized demand of user is shown in the corresponding position of the personal homepage.
9. the platform of user management of dispatching of power netwoks operation data, feature are shown described in -5 any one according to claim 1 It is, the individuation data configuration module includes formula configuration center submodule, and the formula configuration center submodule is used for Point number information is determined according to affiliated area, power transformation station name, voltage class, device type, and according to the point number information and use The point number parameter detailed annotation information of family input generates point number formula.
10. the platform of user management according to claim 9 for showing dispatching of power netwoks operation data, which is characterized in that described Point number formula is made of K character, number and oeprator, and each K character in the point number formula presets meaning of parameters.
CN201910155935.XA 2019-03-01 2019-03-01 Show the platform of user management of dispatching of power netwoks operation data Pending CN109829125A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910155935.XA CN109829125A (en) 2019-03-01 2019-03-01 Show the platform of user management of dispatching of power netwoks operation data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910155935.XA CN109829125A (en) 2019-03-01 2019-03-01 Show the platform of user management of dispatching of power netwoks operation data

Publications (1)

Publication Number Publication Date
CN109829125A true CN109829125A (en) 2019-05-31

Family

ID=66865006

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910155935.XA Pending CN109829125A (en) 2019-03-01 2019-03-01 Show the platform of user management of dispatching of power netwoks operation data

Country Status (1)

Country Link
CN (1) CN109829125A (en)

Cited By (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110427396A (en) * 2019-08-02 2019-11-08 南方电网科学研究院有限责任公司 Electric energy meter data retrieval method, device, equipment and computer readable storage medium
CN110519352A (en) * 2019-08-19 2019-11-29 海南电网有限责任公司 A kind of peak regulation data uploading method for power grid
CN110555010A (en) * 2019-09-11 2019-12-10 中国南方电网有限责任公司 power grid real-time operation data storage system
CN110896219A (en) * 2019-11-20 2020-03-20 赵静怡 Power network processing system and method based on big data and database
CN111061239A (en) * 2019-12-27 2020-04-24 广东电网有限责任公司 Remote programmed operation system for power grid dispatching
CN111221488A (en) * 2019-12-23 2020-06-02 国网青海省电力公司经济技术研究院 Large-screen display method and system for clean energy in high-altitude area
CN111722777A (en) * 2020-06-30 2020-09-29 南方电网数字电网研究院有限公司 Power grid operation data query method and device, computer equipment and storage medium
CN112269670A (en) * 2020-10-30 2021-01-26 重庆紫光华山智安科技有限公司 Data storage method, device and system and storage medium
CN112506093A (en) * 2020-11-12 2021-03-16 国网江苏省电力有限公司连云港市赣榆区供电分公司 Office full-automatic system for power grid dispatching
CN112629584A (en) * 2020-11-16 2021-04-09 上海电机学院 State monitoring system of ring main unit equipment based on multi-source information fusion
CN112860769A (en) * 2021-03-10 2021-05-28 广东电网有限责任公司 Energy planning data management system
CN113093676A (en) * 2021-04-02 2021-07-09 东方电子股份有限公司 Method for processing maintenance equipment alarm signal
CN113485982A (en) * 2021-05-19 2021-10-08 国网河北省电力有限公司衡水供电分公司 Power business data display method and device and terminal equipment
CN114243913A (en) * 2021-12-10 2022-03-25 国网江苏省电力有限公司 Regulation and control operation analysis display method based on smart grid system
CN114637866A (en) * 2022-05-09 2022-06-17 武汉汉灿科技有限公司 Information management method and device for digital new media

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107122185A (en) * 2017-04-21 2017-09-01 国网福建省电力有限公司 One kind shows method for the visualization of distribution network parameters category information
CN108493828A (en) * 2018-02-01 2018-09-04 贵州电网有限责任公司 Real time information Three-Dimensional Dynamic intelligence display systems

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107122185A (en) * 2017-04-21 2017-09-01 国网福建省电力有限公司 One kind shows method for the visualization of distribution network parameters category information
CN108493828A (en) * 2018-02-01 2018-09-04 贵州电网有限责任公司 Real time information Three-Dimensional Dynamic intelligence display systems

Cited By (21)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110427396A (en) * 2019-08-02 2019-11-08 南方电网科学研究院有限责任公司 Electric energy meter data retrieval method, device, equipment and computer readable storage medium
CN110519352A (en) * 2019-08-19 2019-11-29 海南电网有限责任公司 A kind of peak regulation data uploading method for power grid
CN110519352B (en) * 2019-08-19 2022-06-28 海南电网有限责任公司 Peak-shaving data uploading method for power grid
CN110555010A (en) * 2019-09-11 2019-12-10 中国南方电网有限责任公司 power grid real-time operation data storage system
CN110555010B (en) * 2019-09-11 2022-04-05 中国南方电网有限责任公司 Power grid real-time operation data storage system
CN110896219A (en) * 2019-11-20 2020-03-20 赵静怡 Power network processing system and method based on big data and database
CN112467723A (en) * 2019-11-20 2021-03-09 乐清市泰博恒电子科技有限公司 Power network processing method based on big data and database
CN111221488A (en) * 2019-12-23 2020-06-02 国网青海省电力公司经济技术研究院 Large-screen display method and system for clean energy in high-altitude area
CN111061239A (en) * 2019-12-27 2020-04-24 广东电网有限责任公司 Remote programmed operation system for power grid dispatching
CN111722777A (en) * 2020-06-30 2020-09-29 南方电网数字电网研究院有限公司 Power grid operation data query method and device, computer equipment and storage medium
CN111722777B (en) * 2020-06-30 2022-01-21 南方电网数字电网研究院有限公司 Power grid operation data query method and device, computer equipment and storage medium
CN112269670B (en) * 2020-10-30 2023-08-25 重庆紫光华山智安科技有限公司 Data warehouse-in method, device, system and storage medium
CN112269670A (en) * 2020-10-30 2021-01-26 重庆紫光华山智安科技有限公司 Data storage method, device and system and storage medium
CN112506093A (en) * 2020-11-12 2021-03-16 国网江苏省电力有限公司连云港市赣榆区供电分公司 Office full-automatic system for power grid dispatching
CN112629584A (en) * 2020-11-16 2021-04-09 上海电机学院 State monitoring system of ring main unit equipment based on multi-source information fusion
CN112860769B (en) * 2021-03-10 2023-01-20 广东电网有限责任公司 Energy planning data management system
CN112860769A (en) * 2021-03-10 2021-05-28 广东电网有限责任公司 Energy planning data management system
CN113093676A (en) * 2021-04-02 2021-07-09 东方电子股份有限公司 Method for processing maintenance equipment alarm signal
CN113485982A (en) * 2021-05-19 2021-10-08 国网河北省电力有限公司衡水供电分公司 Power business data display method and device and terminal equipment
CN114243913A (en) * 2021-12-10 2022-03-25 国网江苏省电力有限公司 Regulation and control operation analysis display method based on smart grid system
CN114637866A (en) * 2022-05-09 2022-06-17 武汉汉灿科技有限公司 Information management method and device for digital new media

Similar Documents

Publication Publication Date Title
CN109829125A (en) Show the platform of user management of dispatching of power netwoks operation data
CN105843182B (en) A kind of power scheduling accident prediction system and method based on OMS
CN107357856B (en) Method for realizing data integration and data service based on power grid panoramic service model
CN105069690B (en) A kind of grid operation data processing method
CN104600840B (en) A kind of intelligent scheduling anti-misoperation management system and method
CN102215253B (en) Layered exchange and control method for real-time monitoring system data by power dispatching
WO2023115842A1 (en) Data-driven offline and online integrated simulation system and method for power distribution network
CN103762723B (en) Method and system for managing a power grid
CN1881744B (en) High voltage DC power transmission converter station real-time monitoring system realizing method
CN103440367B (en) Transformer station's panoramic view data modeling method
CN106339509A (en) Power grid operation data sharing system based on large data technology
CN106774062A (en) The collection of charging pile and monitoring system and charging pile
CN102255386A (en) Operation management system of client distribution equipment
CN104616205A (en) Distributed log analysis based operation state monitoring method of power system
CN106960292A (en) A kind of operation flow monitoring system and method applied to Utilities Electric Co.
CN112698953A (en) Power grid intelligent operation and detection platform based on micro-service
CN107968482A (en) A kind of generation of electricity by new energy station management platform
CN107910956A (en) A kind of integrated power network schedule automation operation comprehensive supervision method of main plant stand
CN107993004A (en) A kind of power information processing system and method
CN101482960A (en) Method and system for marketing in bank hall
CN110427392A (en) A kind of power distribution network grid-based management information system based on cloud platform
CN111967789A (en) Debugging system is transferred in distribution automation terminal warehouse debugging
CN113612306A (en) Distributed power distribution cabinet and control system thereof
CN110033195A (en) Adjust grid model splicing method to a kind of province based on CIM/CIS
CN109561155A (en) A kind of monitoring of substation equipment remote centralized and O&M method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20190531