CN109766373A - Electric network data methods of exhibiting and computer readable storage medium - Google Patents
Electric network data methods of exhibiting and computer readable storage medium Download PDFInfo
- Publication number
- CN109766373A CN109766373A CN201811456843.7A CN201811456843A CN109766373A CN 109766373 A CN109766373 A CN 109766373A CN 201811456843 A CN201811456843 A CN 201811456843A CN 109766373 A CN109766373 A CN 109766373A
- Authority
- CN
- China
- Prior art keywords
- data
- critical data
- preset
- displaying
- exhibiting
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of electric network data methods of exhibiting and computer readable storage mediums, comprising: obtains critical data from electrical network business system by data warehouse technology, and stores the critical data；According to business demand, analysis is optimized to the critical data；According to inquiry designation date, matched critical data is searched, and the critical data obtained to lookup is screened and counted, and query result is obtained；According to preset displaying subtype, preset GIS figure and preset displaying terminal, the query result is shown.The quick visualization of data can be achieved in the present invention.
Description
Technical field
The present invention relates to data visualization technique field more particularly to a kind of electric network data methods of exhibiting and computer-readable
Storage medium.
Background technique
It has been built in power industry system at present and has covered operation system relatively independent and with level more, but to data
Visualized management and application and development are slightly inadequate, lack the data analysis application unified planning for agreeing with future services layout.To
Line monitoring, OA operation analysis, coordinated control and panorama are shown, to grasp operation situation comprehensively, dynamic is supervised during realizing operation
It surveys and the business such as automatic early-warning is at core demand.Quickly autonomous self-service data analysis is more strong with explorative research demand
Strong, user, which wishes quickly to develop, to be shown and reports production, and is designed business scenario and carried out data analysis, to meet diversification industry
Business analysis scene.
Intra-company is taken on work as unit of project, and human cost is high, and repetitive operation is more.Human resources often cannot
Meet the proposition speed of business demand, demand realizes that the period as unit of week and the moon, causes IT department amount huge, and business
Department again can not autonomous finishing service demand.Therefore, project investment is very big, it is expected that very high, but actual output and it is expected not
Match.
Summary of the invention
The technical problems to be solved by the present invention are: providing a kind of electric network data methods of exhibiting and computer-readable storage medium
Matter, it can be achieved that data quick visualization.
In order to solve the above-mentioned technical problem, the technical solution adopted by the present invention are as follows: a kind of electric network data methods of exhibiting, packet
It includes:
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, the critical data searched matched critical data, and lookup is obtained carry out screening and
Statistics, obtains query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the inquiry knot is shown
Fruit.
The invention further relates to a kind of computer readable storage mediums, are stored thereon with computer program, and described program is located
Reason device performs the steps of when executing
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, the critical data searched matched critical data, and lookup is obtained carry out screening and
Statistics, obtains query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the inquiry knot is shown
Fruit.
The beneficial effects of the present invention are: can quick response user demand, quickly generate diligently be concerned about data, and in real time
Visualization；Easy to operate, easy to use, business personnel can independently complete data visualization research and development by related training；Simultaneously
Actual demand can be met and show style.
Detailed description of the invention
Fig. 1 is a kind of flow chart of electric network data methods of exhibiting of the embodiment of the present invention one.
Specific embodiment
To explain the technical content, the achieved purpose and the effect of the present invention in detail, below in conjunction with embodiment and cooperate attached
Figure is explained in detail.
The most critical design of the present invention is: obtaining basic data source by data warehouse technology, pass through basic data source
Data building, support the visualized operation of data.
Referring to Fig. 1, a kind of electric network data methods of exhibiting, comprising:
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, the critical data searched matched critical data, and lookup is obtained carry out screening and
Statistics, obtains query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the inquiry knot is shown
Fruit.
As can be seen from the above description, the beneficial effects of the present invention are: the quick visualization of data can be achieved.
Further, the displaying subtype include line chart, histogram, pie chart, instrument board figure, vector histogram,
Map vector, 3D map, radar map, rose figure and discrete point diagram.
Further, the GIS figure includes power equipment positioning figure, point location figure, thermodynamic chart and migrates figure.
Further, the displaying terminal includes mobile phone terminal, the end PC and large screen.
Seen from the above description, meet actual demand and show style.
The present invention also proposes a kind of computer readable storage medium, is stored thereon with computer program, and described program is located
Reason device performs the steps of when executing
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, the critical data searched matched critical data, and lookup is obtained carry out screening and
Statistics, obtains query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the inquiry knot is shown
Fruit.
Further, the displaying subtype include line chart, histogram, pie chart, instrument board figure, vector histogram,
Map vector, 3D map, radar map, rose figure and discrete point diagram.
Further, the GIS figure includes power equipment positioning figure, point location figure, thermodynamic chart and migrates figure.
Further, the displaying terminal includes mobile phone terminal, the end PC and large screen.
Embodiment one
Please refer to Fig. 1, the embodiment of the present invention one are as follows: a kind of electric network data methods of exhibiting includes the following steps:
S1: obtaining critical data from electrical network business system by data warehouse technology, and store the critical data, or
It receives the data that user imports and saves.By data warehouse technology (such as ETL, Extract-Transform-Load) from
Extraction, the conversion, data modeling that data are carried out in the relevant databases such as ORACLE, MySQL, to complete basic data source
Building supports the access of the data source of big data and other non-relational databases, to complete the calculating and data mining of big data.
S2: according to business demand, analysis is optimized to the critical data；For example, can divide critical data
The operations such as cloth calculating, column storage, memory calculating, distributing communication.
S3: according to inquiry designation date, i.e., the keyword of preset keyword or user's input searches matched crucial number
According to, and the critical data obtained to lookup is screened and is counted, and query result is obtained.Pass through the data structure of basic data source
It builds, can support the extemporaneous inquiry of data, chart combines the operation of the data visualizations such as inquiry.Further, it can access AI algorithm branch
Support more data mining work, such as clustering algorithm, regression algorithm.
S4: according to preset displaying subtype, preset GIS figure and preset displaying terminal, the inquiry is shown
As a result.User can select shown subtype, including line chart, histogram, pie chart, instrument board figure, vector according to demand
Histogram, map vector, 3D map, radar map, rose figure and discrete point diagram；Customized displaying electric power can be also selected according to demand
Equipment positioning figure, thermodynamic chart, migrates the GIS such as figure figure at point location figure；User can also select displaying terminal, such as mobile phone according to demand
End, the end PC, large screen etc..
Wherein, large-size screen monitors are shown, it can be achieved that the customization of large-size screen monitors is shown, can also be achieved the adaptive displaying of single screen, multi-screen.
The end PC is shown, the displaying of the end Intranet PC, the visual presentation for routine office work computer are mainly used for.For mobile phone terminal exhibition
Show, that is, uses the visual presentation of cell phone application, pass through the various data of cell phone application real time inspection Intranet.Data set exhibition can also be carried out
Show, it can be achieved that data acquisition, data cleansing, Data Integration, form visual structure data set, realize the table of all kinds of dynamic datas
Format displaying, and can a key generate various statistical report forms.
Further, this method based on platform architecture include represent layer, service interaction layer, Business Logic and persistently
Layer.
Represent layer: using front and back end isolation technics theory, and front end uses the Component Galleries such as vue, bootstrap, RequireJS
With response type frame.Figure, which is shown, uses Echarts3.0 front-end technology, the data visualization chart library based on Javascript,
There is provided it is intuitive, lively, can interact, personalized data visualization chart.
Service interaction layer: using RESTFUL Client and BlazeDS Client and MQ internet application
API design theory carries out front and back end service interaction.
Business Logic: it is managed project build using Maven, using Spring, SpringMVC, SpringBoot
Open Framework, configuration are simplified, and the configuration hell of spring is skipped, and integrate Redis caching technology, MQ message queue, realize electricity
Net analysis product service logic construction.
Persistent layer: being developed using Open Framework Spring JPA, is provided a kind of object/relationship maps tool and is carried out pipe
The advantages of managing the relation data in Java application, having fully absorbed the ORM frame such as existing Hibernate, TopLink has easy
In use, the advantages that retractility is strong.
Development cost, product maintenance cost and consumer products use cost can be effectively reduced in the present embodiment；Shorten and goes together
Product relatively finds out gap, develops suitable market demand product, and product is made to have the very strong market competitiveness.
Embodiment two
The present embodiment is a kind of computer readable storage medium of corresponding above-described embodiment, is stored thereon with computer journey
Sequence performs the steps of when described program is executed by processor
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, the critical data searched matched critical data, and lookup is obtained carry out screening and
Statistics, obtains query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the inquiry knot is shown
Fruit.
Further, the displaying subtype include line chart, histogram, pie chart, instrument board figure, vector histogram,
Map vector, 3D map, radar map, rose figure and discrete point diagram.
Further, the GIS figure includes power equipment positioning figure, point location figure, thermodynamic chart and migrates figure.
Further, the displaying terminal includes mobile phone terminal, the end PC and large screen.
In conclusion a kind of electric network data methods of exhibiting provided by the invention and computer readable storage medium, it can be quick
User demand is responded, the data being concerned about diligently, and real-time visual are quickly generated；Easy to operate, easy to use, business personnel is logical
Related training is crossed, data visualization research and development can be independently completed；Actual demand can be met simultaneously and show style.
The above description is only an embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalents made by bright specification and accompanying drawing content are applied directly or indirectly in relevant technical field, similarly include
In scope of patent protection of the invention.
Claims (8)
1. a kind of electric network data methods of exhibiting characterized by comprising
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, matched critical data is searched, and the critical data obtained to lookup is screened and counted,
Obtain query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the query result is shown.
2. electric network data methods of exhibiting according to claim 1, which is characterized in that the displaying subtype includes broken line
Figure, histogram, pie chart, instrument board figure, vector histogram, map vector, 3D map, radar map, rose figure and discrete point diagram.
3. electric network data methods of exhibiting according to claim 1, which is characterized in that the GIS figure is fixed including power equipment
Bitmap, point location figure, thermodynamic chart and migrate figure.
4. electric network data methods of exhibiting according to claim 1, which is characterized in that the displaying terminal include mobile phone terminal,
The end PC and large screen.
5. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that described program is by processor
It is performed the steps of when execution
Critical data is obtained from electrical network business system by data warehouse technology, and stores the critical data；
According to business demand, analysis is optimized to the critical data；
According to inquiry designation date, matched critical data is searched, and the critical data obtained to lookup is screened and counted,
Obtain query result；
According to preset displaying subtype, preset GIS figure and preset displaying terminal, the query result is shown.
6. computer readable storage medium according to claim 5, which is characterized in that the displaying subtype includes folding
Line chart, histogram, pie chart, instrument board figure, vector histogram, map vector, 3D map, radar map, rose figure and discrete point diagram.
7. computer readable storage medium according to claim 5, which is characterized in that the GIS figure includes power equipment
Positioning figure, point location figure, thermodynamic chart and migrate figure.
8. computer readable storage medium according to claim 5, which is characterized in that the displaying terminal includes mobile phone
End, the end PC and large screen.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811456843.7A CN109766373A (en) | 2018-11-30 | 2018-11-30 | Electric network data methods of exhibiting and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811456843.7A CN109766373A (en) | 2018-11-30 | 2018-11-30 | Electric network data methods of exhibiting and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109766373A true CN109766373A (en) | 2019-05-17 |
Family
ID=66450359
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811456843.7A Pending CN109766373A (en) | 2018-11-30 | 2018-11-30 | Electric network data methods of exhibiting and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109766373A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110569469A (en) * | 2019-09-06 | 2019-12-13 | 四川长虹电器股份有限公司 | Method for dynamically generating HTML (hypertext markup language) form based on data configuration |
| CN110908873A (en) * | 2019-11-01 | 2020-03-24 | 广东省信息工程有限公司 | Key operation data monitoring method based on domestic equipment |
| CN111708814A (en) * | 2020-04-27 | 2020-09-25 | 广东电网有限责任公司东莞供电局 | Data statistical method, device, equipment and medium |
| CN113704314A (en) * | 2021-08-04 | 2021-11-26 | 百度在线网络技术（北京）有限公司 | Data analysis method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105786864A (en) * | 2014-12-24 | 2016-07-20 | 国家电网公司 | Offline analysis method for massive data |
| CN106294822A (en) * | 2016-08-17 | 2017-01-04 | 国网上海市电力公司 | A kind of electric power data visualization system |
| CN106649765A (en) * | 2016-12-27 | 2017-05-10 | 国网山东省电力公司济宁供电公司 | Smart power grid panoramic data analysis method based on big data technology |
| CN107133255A (en) * | 2017-03-15 | 2017-09-05 | 中国电力科学研究院 | A kind of bulk power grid full view safety defence method and system |
| CN107679076A (en) * | 2017-08-28 | 2018-02-09 | 国网上海市电力公司 | A kind of acquisition analysis system of electric power data |
-
2018
- 2018-11-30 CN CN201811456843.7A patent/CN109766373A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105786864A (en) * | 2014-12-24 | 2016-07-20 | 国家电网公司 | Offline analysis method for massive data |
| CN106294822A (en) * | 2016-08-17 | 2017-01-04 | 国网上海市电力公司 | A kind of electric power data visualization system |
| CN106649765A (en) * | 2016-12-27 | 2017-05-10 | 国网山东省电力公司济宁供电公司 | Smart power grid panoramic data analysis method based on big data technology |
| CN107133255A (en) * | 2017-03-15 | 2017-09-05 | 中国电力科学研究院 | A kind of bulk power grid full view safety defence method and system |
| CN107679076A (en) * | 2017-08-28 | 2018-02-09 | 国网上海市电力公司 | A kind of acquisition analysis system of electric power data |
Non-Patent Citations (3)
| Title |
|---|
| 付学谦等: ""电力计量数据仓库技术研究"", 《陕西电力》 * |
| 梁哲辉等: ""基于大数据技术的电力客户服务辅助决策系统"", 《电子技术与软件工程》 * |
| 童光华等: ""基于数据挖掘技术下电力计量数据仓库模型研究"", 《自动化与仪器仪表》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110569469A (en) * | 2019-09-06 | 2019-12-13 | 四川长虹电器股份有限公司 | Method for dynamically generating HTML (hypertext markup language) form based on data configuration |
| CN110569469B (en) * | 2019-09-06 | 2022-02-01 | 四川长虹电器股份有限公司 | Method for dynamically generating HTML (hypertext markup language) form based on data configuration |
| CN110908873A (en) * | 2019-11-01 | 2020-03-24 | 广东省信息工程有限公司 | Key operation data monitoring method based on domestic equipment |
| CN111708814A (en) * | 2020-04-27 | 2020-09-25 | 广东电网有限责任公司东莞供电局 | Data statistical method, device, equipment and medium |
| CN113704314A (en) * | 2021-08-04 | 2021-11-26 | 百度在线网络技术（北京）有限公司 | Data analysis method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220207398A1 (en) | Systems and methods for modeling machine learning and data analytics | |
| CN109766373A (en) | Electric network data methods of exhibiting and computer readable storage medium | |
| US10275221B2 (en) | Systems and methods for generating data visualization applications | |
| CN110442965A (en) | Railway customer service information machine room implementation management system and method based on BIM | |
| US9934299B2 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
| CN106067080B (en) | Configurable workflow capabilities are provided | |
| US9224222B2 (en) | Interactive multidimensional drilldown analysis | |
| CN107451109A (en) | Report form generation method and system | |
| WO2015060893A1 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
| US9466041B2 (en) | User selected flow graph modification | |
| CN104317842A (en) | Intelligent data extraction and thematic map generation engine based on geographic information technology | |
| CN110928740A (en) | Centralized visualization method and system for operation and maintenance data of cloud computing center | |
| CN107273369A (en) | A kind of table data modification method and device | |
| WO2017143996A1 (en) | Data presentation method and device | |
| US9350561B1 (en) | Visualizing the flow of resources in an allocation model | |
| CN106844669A (en) | Big data visual analyzing display frame construction method and visual analyzing display frame | |
| US20180365312A1 (en) | Systems, Methods, and Apparatuses for Creating, Linking and Discovering Business Navigation Maps for Analyzing Data | |
| US20130096967A1 (en) | Optimizer | |
| Aly et al. | Proposed model of gis-based cloud computing architecture for emergency system | |
| CN109360106A (en) | Portrait construction method, system, medium and computer system | |
| US20130093771A1 (en) | Modified flow graph depiction | |
| CN110389944B (en) | Metadata management system and method based on model | |
| EP2830289B1 (en) | Adaptable reporting in a multi-client telecommunication network | |
| CN106682183A (en) | Linkable data visualization spectacular system | |
| CN106055578A (en) | Geography national condition monitoring system based on GIS network service and rich internet application |
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: 20190517 |
|
| RJ01 | Rejection of invention patent application after publication |