CN104317923A - Method for presenting multi-dimensional data of regulation and control integrated systems of power grids - Google Patents

Method for presenting multi-dimensional data of regulation and control integrated systems of power grids Download PDF

Info

Publication number
CN104317923A
CN104317923A CN201410598538.7A CN201410598538A CN104317923A CN 104317923 A CN104317923 A CN 104317923A CN 201410598538 A CN201410598538 A CN 201410598538A CN 104317923 A CN104317923 A CN 104317923A
Authority
CN
China
Prior art keywords
multidimensional data
theme
power grid
grid regulation
integral system
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
CN201410598538.7A
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.)
North China Grid Co Ltd
Nari Technology Co Ltd
Original Assignee
North China Grid Co Ltd
Nari Technology Co Ltd
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 North China Grid Co Ltd, Nari Technology Co Ltd filed Critical North China Grid Co Ltd
Priority to CN201410598538.7A priority Critical patent/CN104317923A/en
Publication of CN104317923A publication Critical patent/CN104317923A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/283Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Probability & Statistics with Applications (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Fuzzy Systems (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Supply And Distribution Of Alternating Current (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for presenting multi-dimensional data of regulation and control integrated systems of power grids. The method has the advantages that multi-dimensional data models of the regulation and control integrated systems of the power grids are built to provide foundations for presenting the multi-dimensional data at first, then representation themes of the multi-dimensional data are established, rich presentation modes of presentation means such as WEB and reports are combined with comprehensive presentation dimensions provided by the multi-dimensional data models, and accordingly the data can be comprehensively and abundantly presented in a multi-level manner; the method is combined with multi-dimensional data linkage, multi-dimensional analysis and multi-dimensional drill-through presentation technologies, so that the theme data can be comprehensively presented and analyzed from multiple levels, multiple angles and multiple aspects.

Description

Power grid regulation integral system multidimensional data presentation method
Technical field
The invention belongs to technical field of power dispatching automation, be specifically related to power grid regulation integral system multidimensional data presentation method.
Background technology
Along with the develop rapidly of electric system, the requirement of people to the monitoring of operation of power networks data, analysis is more and more higher.At present, people utilize the OO relational model of power grid regulation integral system to carry out data exhibiting, but such ways of presentation data poor intuition, and the more difficult information obtaining profound level, be unfavorable for comprehensively analyzing data and representing.
Summary of the invention
In order to solve the deficiencies in the prior art, the invention provides power grid regulation integral system multidimensional data presentation method, multidimensional data interlock, multidimensional analysis and multidimensional are drilled through display technique and is applied to form and Web, querying condition is flexibly provided, and can cut into slices to data and drill through, make form and Web possess data analysis function, thus solve data poor intuition, be difficult to obtain the problem of the deep information.
For solving the problem, the present invention specifically by the following technical solutions:
Power grid regulation integral system multidimensional data presentation method, is characterized in that, comprise the following steps:
Step 1), sets up the Multidimensional Data Model of power grid regulation integral system;
Step 2), that sets up power grid regulation multidimensional data according to the Multidimensional Data Model in step 1) represents theme;
Step 3), the front end by multidimensional data analysis software represents instrument and realizes and step 2) middle set up represent representing of the relevant multidimensional data of theme;
Step 4), the way of presentation represented step 3) front end in instrument combines with multidimensional data display technique, completes and represents the analysis of multidimensional data.
Aforesaid power grid regulation integral system multidimensional data presentation method, is characterized in that, in described step 1), the step setting up the Multidimensional Data Model of power grid regulation integral system is:
Step 11) sets up the theme of power grid regulation integral system;
Step 12) sets up corresponding dimension according to the theme of the power grid regulation integral system set up in step 11), and is respectively each dimension and sets up corresponding dimension table;
Step 13) sets up corresponding fact table according to the theme of the power grid regulation integral system set up in step 11); Fact table mainly stores the key index data of power grid regulation theme, is the position being positioned at Star Model center, the main key index value disclosing theme.Dimension table is positioned on star graph star angle, and its effect is restriction Query Result, is made by data filtering to return less row from index object query, thus reduces access profile.Each dimension table has oneself attribute, and dimension table and fact table are associated by key word.
The dimension table of the power grid regulation integral system set up in step 12), step 13) under same subject, fact table are set up the correlation table structure of Multidimensional Data Model by step 14), each correlation table structure is corresponding with the theme of the power grid regulation integral system set up in step 11) and set up the submodel of Multidimensional Data Model, submodel corresponding for each theme is combined and obtains Multidimensional Data Model.
Aforesaid power grid regulation integral system multidimensional data presentation method, it is characterized in that, in described step 11), described theme comprises the out-of-limit theme of remote measurement, remote control conjugates theme, data jump theme, data do not refresh theme, crash analysis theme, five class alarm themes, the out-of-limit theme of busbar voltage, the out-of-limit theme of section.
Aforesaid power grid regulation integral system multidimensional data presentation method, it is characterized in that, in described step 12), described dimension comprises date, time, electric pressure, region, plant stand, zone of responsibility, alarm type, five class groupings, wherein the time is daytimes, described five classes groupings comprise accident, abnormal, out-of-limit, conjugate, inform, described alarm type comprises that accident information, remote measurement are out-of-limit, remote signalling displacement, alarm direct transfer.
Aforesaid power grid regulation integral system multidimensional data presentation method, is characterized in that, in described step 14), the submodel of described Multidimensional Data Model is Star Model or snowflake model.
Aforesaid power grid regulation integral system multidimensional data presentation method, it is characterized in that, in described step 14), utilize switching software by the Data import in power grid regulation integral system relational model to set up Multidimensional Data Model fact table in, realize the OO relational model of power grid regulation integral system and convert Multidimensional Data Model to.
Aforesaid power grid regulation integral system multidimensional data presentation method, is characterized in that, described switching software is ETL instrument.
Aforesaid power grid regulation integral system multidimensional data presentation method, it is characterized in that, described step 2) in the theme that represents unify mutually with theme when setting up Multidimensional Data Model, also comprise the out-of-limit theme of remote measurement, remote control displacement theme, data jump theme, data do not refresh theme, crash analysis theme, five class alarm themes, the out-of-limit theme of busbar voltage, the out-of-limit theme of section.
Aforesaid power grid regulation integral system multidimensional data presentation method, it is characterized in that, multidimensional data analysis software in described step 3) is PENTAHO, the front end of multidimensional data analysis software represents that instrument provides that multi-data source manages, interface layout's configuration, link between multiple pel and pel, provides WEB and form two kinds of means to show multidimensional data simultaneously.
Aforesaid power grid regulation integral system multidimensional data presentation method, is characterized in that, in described step 4), multidimensional data display technique comprises multidimensional data interlock, multidimensional analysis and multidimensional drill through display technique.
Beneficial effect of the present invention: power grid regulation integral system multidimensional data presentation method provided by the invention, first the Multidimensional Data Model of power grid regulation integral system is set up, for representing of multidimensional data provides basis, that then sets up multidimensional data represents theme, utilize as WEB, the way of presentation such as form enrich the comprehensive displaying dimension that ways of presentation provides in conjunction with Multidimensional Data Model, realize comprehensive to data, abundant, multi-level displaying, link in conjunction with multidimensional data simultaneously, multidimensional analysis and multidimensional drill through display technique, realize from many levels, multi-angle, many-side comprehensively represents analysis to subject data.
Accompanying drawing explanation
Fig. 1 is the design drawing of the power grid regulation integral system Multidimensional Data Model be the theme with crash analysis;
Fig. 2 is that accident situation analyzes histogram;
Fig. 3 is alarm type dimensional analysis chart;
Fig. 4 is date dimension linkage analysis chart
Fig. 5 is that interface is shown in accident multidimensional analysis.
Embodiment
For crash analysis, also the invention will be further described by reference to the accompanying drawings below.
Power grid regulation integral system multidimensional data presentation method, is characterized in that, comprise the following steps:
Step 1), sets up the Multidimensional Data Model of power grid regulation integral system, sets up the Multidimensional Data Model of power grid regulation integral system in this step 1), and detailed step is as follows:
The theme of step 11) design power grid regulation integral system;
In conjunction with dispatching of power netwoks, the feature of monitoring, to the data analysis in the existing relational model of power grid regulation integral system, mainly according to the achievement data of power grid regulation key and in conjunction with data analysis relevant to achievement data in power grid regulation integral system, the theme of power grid regulation integral system is designed according to the result (mainly comprise key index and index relates to relevant data) analyzed, the achievement data of power grid regulation key comprises remote measurement threshold crossing time, remote control number of times, accident frequency, the time that section is out-of-limit, busbar voltage threshold crossing time, data are refresh time not, data jump number of times, electricity, load value etc.The theme setting up power grid regulation integral system is the primary work of setting up power grid regulation integral system Multidimensional Data Model, the foundation of theme is extremely important for the modeling of Multidimensional Data Model, only have the foundation of the abundant theme about power grid regulation, abundant, deep Multidimensional Data Model could be set up out.According to correlation experience, sum up the out-of-limit theme of remote measurement, analysis theme that remote control displacement theme, data jump theme, data do not refresh multiple power grid regulation integral systems such as theme, crash analysis theme, five class alarm themes, the out-of-limit theme of busbar voltage, the out-of-limit theme of section, relate to the Data subject that power grid regulation is main, the operation conditions of electrical network can be represented comprehensively.
Example is themed as with crash analysis, first the key index needing clear and definite crash analysis theme is accident frequency, has had the achievement data of the key of this theme can consider to carry out multianalysis from the key index accident frequency of dimension to crash analysis theme such as date, time (daytimes), plant stand, region, electric pressures.The corresponding key index data of crash analysis theme and dimension data can obtain from the accident information table power grid regulation integral system.
Step 12) sets up corresponding dimension according to the theme of the power grid regulation integral system set up in step 11), and is respectively each dimension and sets up corresponding dimension table;
Each theme of power grid regulation integral system specify that the angle of the index that theme is shown accordingly and displaying, and go out main dimension according to the data analysis in the existing relational model of power grid regulation integral system, generally comprise the date, time, electric pressure, region, plant stand, zone of responsibility, device type, alarm type, five class grouping (accidents, abnormal, out-of-limit, displacement, the five classes groupings such as to inform) etc. main dimension, and be respectively each dimension and set up dimension table, there is abundant dimension table can analyze from multiple dimension the theme of power grid regulation integral system.Theme as example with crash analysis, to the data analysis in existing power grid regulation integral system relational model, set up five dimension tables, be respectively date dimension, time dimension, electric pressure dimension, plant stand dimension, region dimension.
Step 13) sets up corresponding fact table according to the theme of the power grid regulation integral system set up in step 11);
The fact table of design mainly stores the data value of index, and it mainly stores the key index data of power grid regulation theme, is the position being positioned at Star Model center, the main key index value disclosing theme.The Numerical Range that the territory of fact table comprises key index and the key field be associated with dimension table.Dimension table and fact table together form the basis of power grid regulation integral system Multidimensional Data Model.
The dimension table of the power grid regulation integral system set up in step 12), step 13) under same subject, fact table are set up the correlation table structure of Multidimensional Data Model by step 14), each correlation table structure is corresponding with the theme of the power grid regulation integral system set up in step 1) and set up the submodel of Multidimensional Data Model, submodel corresponding for each theme is combined and obtains Multidimensional Data Model.The submodel of this Multidimensional Data Model is Star Model or snowflake model, namely the Multidimensional Data Model set up is reference with Star Model, snowflake model, the reference of Star Model, snowflake model is conducive to the raising of Multidimensional Data Model search efficiency, and Star Model, snowflake model are more directly perceived, easily be combined into various inquiry by Star Model, snowflake model, the front end of this Multidimensional Data Model shown and more inquires about theme.
Example is themed as with crash analysis, set up the correlation table structure of five dimension tables such as fact table under crash analysis theme and date, daytimes, electric pressure, plant stand, region, fact table and five dimension tables combine the Multidimensional Data Model just forming crash analysis theme.As shown in Figure 1, what be positioned at center in figure is the fact table storing key index accident frequency, be positioned at surrounding what be associated with fact table is the dimension tables such as date, daytimes, electric pressure, plant stand, region.
With identical step, the model similar with crash analysis Multidimensional Data Model is set up in other theme, each theme sets up different multidimensional submodels according to respective key index, and being combined by each multidimensional submodel obtains the corresponding Multidimensional Data Model of each theme.Because crash analysis theme only has a key index, therefore only need to set up a multidimensional submodel, be the Multidimensional Data Model under crash analysis theme.After this Multidimensional Data Model is set up, utilize switching software as ETL instrument by the Data import in power grid regulation integral system relational model in the fact table of the Multidimensional Data Model of this foundation, thus realize the OO relational model of power grid regulation integral system and convert Multidimensional Data Model to.
Step 2), that sets up power grid regulation multidimensional data according to the Multidimensional Data Model in step 1) represents theme;
That sets up multidimensional data according to the Multidimensional Data Model of the achievement data of power grid regulation key (key index data when now crucial achievement data is set up with multidimensional model are consistent) and step 1) foundation represents theme, and the design of abundant theme can carry out the deployment of structure frame level to electrical network multidimensional index data.Power grid regulation integral system needs comprehensive evaluation operation of power networks level quantitatively, thus the quantitative criteria directly perceived providing evaluation operation of power networks level of aggregation for Regulation personnel and relevant leader, therefore need to set up the theme enriching overall target and represent.This represents theme and the theme designed when setting up Multidimensional Data Model unification mutually substantially, comprise the out-of-limit theme of remote measurement, remote control displacement theme, data jump theme, data do not refresh theme, crash analysis theme, five class alarm themes, the out-of-limit theme of busbar voltage, the out-of-limit theme of section, relate to the aspect that power grid regulation is main, analyze from the operation conditions of multidimensional angle to power grid regulation integral system.
Set up on basis at the Multidimensional Data Model of crash analysis theme, be shown as the multidimensional analysis of example explaination crash analysis theme with accident situation analysis and show the main contents related to, corresponding Multidimensional Data Model is generated according to the record of the accident information stored in power grid regulation integral system, the time that can occur according to accident, region, the dimension such as plant stand and device type carries out representing of accident frequency key index, mainly represent the accident total degree in each region in a period of time, represent the accident total degree of each plant stand in each region in a period of time, show the accident total degree of each device type in each plant stand in a period of time.
Step 3), the front end by multidimensional data analysis software represents instrument and realizes and step 2) middle set up represent representing of the relevant multidimensional data of theme;
Multidimensional data is shown and is mainly represented from WEB and form two kinds of means.Front end by multidimensional data analysis softwares such as PENTAHO represents instrument, this front end represents instrument and provides between the management of abundant multi-data source, interface layout's configuration, multiple conventional pel and pel and link, and front end represents instrument and provides the way of presentation that WEB and form etc. realize data simultaneously.Be shown as example with accident situation analysis, as shown in Figure 2, can select from the dimension in region the analysis of accident situation for histogram assembly; Equally, the analysis from the dimension of time, casualty data being carried out to accident situation a time dimension can also be set up as required.The histogram that concrete front end represents instrument form can utilize the dimension of histogram X-axis to choose and realize representing the analysis of accident situation index and histogram under multiple different dimensions.
Step 4), the way of presentation represented step 3) front end in instrument combines with multidimensional data display technique, completes and represents the analysis of multidimensional data.
Utilize multidimensional data interlock, multidimensional analysis and multidimensional to drill through display technique to realize representing analysis from multi-level, multi-angle, many-side to subject data comprehensively.The subject scenes of showing at multidimensional data will make full use of the methods of exhibiting of multidimensional better to represent key index data, provide abundanter step analysis and interactive experience to relevant user of service, make to represent the effect that theme has certain performance analysis.In conjunction with interlock between chart with drill through mechanism, the interlock between coarse grain and fine-grained dimension can be realized and drill through representing, make power grid regulation integral system multidimensional exhibition scene can demonstrating data intension more comprehensively.
The interlock method of multidimensional data is represented for date dimension and alarm type dimension, as shown in Figure 3, Figure 4, the cake chart of distribution in the five class alarm that the alarm type dimension clicking alarm type theme represents month, clicks wherein out-of-limit boxed area and can link and inspire the histogram of a Threshold Crossing Alert month data display.Realize representing from alarm type dimension to the interlock of date dimension.
Show that interface is shown in the accident multidimensional analysis that interface introduction finally generates for accident situation analysis, as shown in Figure 5, after accident situation analysis shows that start time and end time are selected in upper left side, interface, the data of statistical study are limited in time period of specifying, the pie chart of each region accident generation total degree is during this period of time represented after time period selection, the histogram of each plant stand accident generation total degree under this region of click pie chart interlock generation, then the histogram of plant stand histogram interlock generation about the accident generation total degree of switch concrete in this plant stand is clicked, finally click switch column shape figure links and generates the time of concrete accident generation.Whole interface has been carried out multianalysis from multiple dimensions such as time, region, plant stand, equipment to accident information and has been represented.
This power grid regulation integral system multidimensional data presentation method, each achievement data that is established as of Multidimensional Data Model provides abundant multi dimensional analysis basis, and power grid regulation integral system multidimensional data is represented can be realized from the interlock of the formula that inspires between the upper volume between the analysis of various dimensions, dimension and lower brill, various dimensions.The representing to utilize of multidimensional data represents the foundation of theme, adopts abundant multidimensional analysis means, and combines and utilize the instrument such as WEB and form to carry out multianalysis, displaying to multidimensional data.Multidimensional data is shown and can be designed the multidimensional exhibition theme of corresponding granularity for the personnel of different levels, thus more comprehensively carries out omnibearing representing to multidimensional data.
More than show and describe ultimate principle of the present invention, principal character and advantage.The technician of the industry should understand; the present invention is not restricted to the described embodiments; what describe in above-described embodiment and instructions just illustrates principle of the present invention; without departing from the spirit and scope of the present invention; the present invention also has various changes and modifications, and these changes and improvements all fall in the claimed scope of the invention.Application claims protection domain is defined by appending claims and equivalent thereof.

Claims (10)

1. power grid regulation integral system multidimensional data presentation method, is characterized in that, comprises the following steps:
Step 1), sets up the Multidimensional Data Model of power grid regulation integral system;
Step 2), that sets up power grid regulation multidimensional data according to the Multidimensional Data Model in step 1) represents theme;
Step 3), the front end by multidimensional data analysis software represents instrument and realizes and step 2) middle set up represent representing of the relevant multidimensional data of theme;
Step 4), the way of presentation represented step 3) front end in instrument combines with multidimensional data display technique, completes and represents the analysis of multidimensional data.
2. power grid regulation integral system multidimensional data presentation method according to claim 1, is characterized in that, in described step 1), the step setting up the Multidimensional Data Model of power grid regulation integral system is:
Step 11) sets up the theme of power grid regulation integral system;
Step 12) sets up corresponding dimension according to the theme of the power grid regulation integral system set up in step 11), and is respectively each dimension and sets up corresponding dimension table;
Step 13) sets up corresponding fact table according to the theme of the power grid regulation integral system set up in step 11);
The dimension table of the power grid regulation integral system set up under same subject in step 12), step 13), fact table are set up the correlation table structure of Multidimensional Data Model by step 14), each correlation table structure is corresponding with the theme of the power grid regulation integral system set up in step 11) and set up the submodel of Multidimensional Data Model, submodel corresponding for each theme is combined and obtains Multidimensional Data Model.
3. power grid regulation integral system multidimensional data presentation method according to claim 2, it is characterized in that, in described step 11), described theme comprises the out-of-limit theme of remote measurement, remote control conjugates theme, data jump theme, data do not refresh theme, crash analysis theme, five class alarm themes, the out-of-limit theme of busbar voltage, the out-of-limit theme of section.
4. power grid regulation integral system multidimensional data presentation method according to claim 2, it is characterized in that, in described step 12), described dimension comprises date, time, electric pressure, region, plant stand, zone of responsibility, device type, alarm type, five class groupings, described five classes groupings comprise accident, abnormal, out-of-limit, conjugate, inform, described alarm type comprises that accident information, remote measurement are out-of-limit, remote signalling displacement, alarm direct transfer.
5. power grid regulation integral system multidimensional data presentation method according to claim 2, is characterized in that, in described step 14), the submodel of described Multidimensional Data Model is Star Model or snowflake model.
6. power grid regulation integral system multidimensional data presentation method according to claim 5, it is characterized in that, in described step 14), utilize switching software by the Data import in power grid regulation integral system relational model to set up Multidimensional Data Model fact table in, realize the OO relational model of power grid regulation integral system and convert Multidimensional Data Model to.
7. power grid regulation integral system multidimensional data presentation method according to claim 6, is characterized in that, described switching software is ETL instrument.
8. power grid regulation integral system multidimensional data presentation method according to claim 1, is characterized in that, described step 2) in represent theme corresponding with the theme of Multidimensional Data Model.
9. power grid regulation integral system multidimensional data presentation method according to claim 1, it is characterized in that, multidimensional data analysis software in described step 3) is PENTAHO, the front end of multidimensional data analysis software represents that instrument provides that multi-data source manages, interface layout's configuration, link between multiple pel and pel, provides WEB and form two kinds of means to show multidimensional data simultaneously.
10. power grid regulation integral system multidimensional data presentation method according to claim 1, is characterized in that, in described step 4), multidimensional data display technique comprises multidimensional data interlock, multidimensional analysis and multidimensional drill through display technique.
CN201410598538.7A 2014-10-31 2014-10-31 Method for presenting multi-dimensional data of regulation and control integrated systems of power grids Pending CN104317923A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410598538.7A CN104317923A (en) 2014-10-31 2014-10-31 Method for presenting multi-dimensional data of regulation and control integrated systems of power grids

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410598538.7A CN104317923A (en) 2014-10-31 2014-10-31 Method for presenting multi-dimensional data of regulation and control integrated systems of power grids

Publications (1)

Publication Number Publication Date
CN104317923A true CN104317923A (en) 2015-01-28

Family

ID=52373155

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410598538.7A Pending CN104317923A (en) 2014-10-31 2014-10-31 Method for presenting multi-dimensional data of regulation and control integrated systems of power grids

Country Status (1)

Country Link
CN (1) CN104317923A (en)

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104866567A (en) * 2015-05-22 2015-08-26 国家计算机网络与信息安全管理中心 Method and apparatus for presenting business data
CN105354303A (en) * 2015-11-06 2016-02-24 广东电网有限责任公司清远供电局 Power grid alarm data processing method and apparatus based on BI (Business Intelligence) multi-dimensional analysis theory
CN105447769A (en) * 2015-12-09 2016-03-30 国家电网公司 Power grid regulation and control integration monitoring information intelligent processing system
CN105469164A (en) * 2015-12-15 2016-04-06 四川大学 Topic mode based cross-business calculation and analysis system for power system
CN105528400A (en) * 2015-12-02 2016-04-27 浪潮通用软件有限公司 Web-based multidimensional analysis system and method
CN105787052A (en) * 2016-02-26 2016-07-20 广州品唯软件有限公司 Data processing model building method and data screening method based on data processing model
CN105930905A (en) * 2016-04-15 2016-09-07 广州慧睿思通信息科技有限公司 Logical deduction method and system based on index direction
CN107038513A (en) * 2016-02-03 2017-08-11 中国电力科学研究院 A kind of overview display method of index
CN108399251A (en) * 2018-03-05 2018-08-14 贵州工程应用技术学院 A kind of Intelligence Generator and data exhibiting process that multi-layer data shows
CN108415965A (en) * 2018-02-07 2018-08-17 五维引力(上海)数据服务有限公司 A kind of data processing method and device based on multi-data source
CN108415917A (en) * 2017-03-13 2018-08-17 平安科技(深圳)有限公司 A kind of generation method of Visual Report Forms and the generating means of Visual Report Forms
CN108446305A (en) * 2018-01-30 2018-08-24 上海天旦网络科技发展有限公司 The system and method for various dimensions service data statistics
CN109672703A (en) * 2017-10-16 2019-04-23 中车株洲电力机车研究所有限公司 A kind of wind power plant quality control management method and system
TWI658413B (en) * 2017-08-04 2019-05-01 日商東芝三菱電機產業系統股份有限公司 Data reproducing device for industrial plant
CN110348667A (en) * 2019-05-21 2019-10-18 贵州电网有限责任公司 A kind of power grid accident grade determination method drilled through based on multi-layer data and system
CN112183379A (en) * 2020-09-29 2021-01-05 国网天津市电力公司 Report-oriented multi-dimensional management analysis method and system

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101452485A (en) * 2008-12-31 2009-06-10 中国建设银行股份有限公司 Method and device for generating multidimensional cubic based on relational database
US20100318559A1 (en) * 2009-06-12 2010-12-16 Sap Ag Information Value-Driven Near Real-Time Decision Support

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101452485A (en) * 2008-12-31 2009-06-10 中国建设银行股份有限公司 Method and device for generating multidimensional cubic based on relational database
US20100318559A1 (en) * 2009-06-12 2010-12-16 Sap Ag Information Value-Driven Near Real-Time Decision Support

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
冯思宇: "ETL技术在电力信息分析系统中的应用", 《中国优秀硕士学位论文全文数据库》 *

Cited By (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104866567A (en) * 2015-05-22 2015-08-26 国家计算机网络与信息安全管理中心 Method and apparatus for presenting business data
CN105354303A (en) * 2015-11-06 2016-02-24 广东电网有限责任公司清远供电局 Power grid alarm data processing method and apparatus based on BI (Business Intelligence) multi-dimensional analysis theory
CN105528400A (en) * 2015-12-02 2016-04-27 浪潮通用软件有限公司 Web-based multidimensional analysis system and method
CN105447769A (en) * 2015-12-09 2016-03-30 国家电网公司 Power grid regulation and control integration monitoring information intelligent processing system
CN105469164A (en) * 2015-12-15 2016-04-06 四川大学 Topic mode based cross-business calculation and analysis system for power system
CN107038513A (en) * 2016-02-03 2017-08-11 中国电力科学研究院 A kind of overview display method of index
CN105787052A (en) * 2016-02-26 2016-07-20 广州品唯软件有限公司 Data processing model building method and data screening method based on data processing model
CN105930905A (en) * 2016-04-15 2016-09-07 广州慧睿思通信息科技有限公司 Logical deduction method and system based on index direction
CN108415917A (en) * 2017-03-13 2018-08-17 平安科技(深圳)有限公司 A kind of generation method of Visual Report Forms and the generating means of Visual Report Forms
CN110651231B (en) * 2017-08-04 2022-10-11 东芝三菱电机产业系统株式会社 Data reproducing device for industrial plant
US11209809B2 (en) 2017-08-04 2021-12-28 Toshiba Mitsubishi-Electric Industrial Systems Corporation Data reproduction device for industrial plant
CN110651231A (en) * 2017-08-04 2020-01-03 东芝三菱电机产业系统株式会社 Data reproducing device for industrial plant
TWI658413B (en) * 2017-08-04 2019-05-01 日商東芝三菱電機產業系統股份有限公司 Data reproducing device for industrial plant
CN109672703A (en) * 2017-10-16 2019-04-23 中车株洲电力机车研究所有限公司 A kind of wind power plant quality control management method and system
CN108446305A (en) * 2018-01-30 2018-08-24 上海天旦网络科技发展有限公司 The system and method for various dimensions service data statistics
CN108415965A (en) * 2018-02-07 2018-08-17 五维引力(上海)数据服务有限公司 A kind of data processing method and device based on multi-data source
CN108399251A (en) * 2018-03-05 2018-08-14 贵州工程应用技术学院 A kind of Intelligence Generator and data exhibiting process that multi-layer data shows
CN110348667A (en) * 2019-05-21 2019-10-18 贵州电网有限责任公司 A kind of power grid accident grade determination method drilled through based on multi-layer data and system
CN112183379A (en) * 2020-09-29 2021-01-05 国网天津市电力公司 Report-oriented multi-dimensional management analysis method and system

Similar Documents

Publication Publication Date Title
CN104317923A (en) Method for presenting multi-dimensional data of regulation and control integrated systems of power grids
CN105574652B (en) Intelligent power distribution network planning big data management and control system and method
EP3913555A1 (en) Power distribution network operation aided decision-making analysis system and method
Ouyang et al. Methodologies, principles and prospects of applying big data in safety science research
CN103617576B (en) General fault detecting and maintenance method for equipment
CN105069690A (en) Power grid operating data processing method
CN107918830B (en) Power distribution network running state evaluation method based on big data technology
CN103902816A (en) Electrification detection data processing method based on data mining technology
CN101576881A (en) Data visualization system and realization method
CN104866567A (en) Method and apparatus for presenting business data
CN104021248B (en) A kind of airborne machinery product FMECA analysis methods
CN101566981A (en) Method for establishing dynamic virtual data base in analyzing and processing system
CN110489464A (en) Heuristic figure fusion visualization method and device
CN103309964A (en) High-efficiency visible monitoring analysis system for large-scale traffic data
CN104299102A (en) Multidimensional data model modeling method of power grid regulation and control integration system
CN103399925A (en) Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system
CN107506393A (en) A kind of agriculture big data model and its in application agriculturally
DE102009048610A1 (en) Method and device for the transparent representation of information related to a development of a motor vehicle
CN105528671B (en) A kind of power grid Multidimensional Awareness based on big data and safety estimation system and method
CN102096688A (en) Method and device for generating data report
CN103840955A (en) Operation maintenance system of distributed IT system, and operation maintenance management method thereof
CN103646100A (en) Report data organization model
CN110956692A (en) Method for combining three-dimensional scene visualization based on power supply reliability data analysis
CN103942266A (en) Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP
CN102750653A (en) Method and system for performing multi-dimensional benchmarking analysis on electric power scheduling information

Legal Events

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

Application publication date: 20150128