CN110442938A - The multi-dimensional intelligent analysis system of new-energy automobile charge rule - Google Patents

The multi-dimensional intelligent analysis system of new-energy automobile charge rule Download PDF

Info

Publication number
CN110442938A
CN110442938A CN201910673113.0A CN201910673113A CN110442938A CN 110442938 A CN110442938 A CN 110442938A CN 201910673113 A CN201910673113 A CN 201910673113A CN 110442938 A CN110442938 A CN 110442938A
Authority
CN
China
Prior art keywords
charge
analysis
charging
data
different
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
CN201910673113.0A
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.)
Nanjing Derui Energy Research Institute Co Ltd
State Grid Corp of China SGCC
State Grid Jiangxi Electric Power Co Ltd
Original Assignee
Nanjing Derui Energy Research Institute Co Ltd
State Grid Corp of China SGCC
State Grid Jiangxi Electric Power 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 Nanjing Derui Energy Research Institute Co Ltd, State Grid Corp of China SGCC, State Grid Jiangxi Electric Power Co Ltd filed Critical Nanjing Derui Energy Research Institute Co Ltd
Priority to CN201910673113.0A priority Critical patent/CN110442938A/en
Publication of CN110442938A publication Critical patent/CN110442938A/en
Pending legal-status Critical Current

Links

Abstract

The invention discloses the multi-dimensional intelligent analysis systems of new-energy automobile charge rule, by the multidimensional analysis platform based on Kylin, Data cube model building module, time dimension charging frequency law-analysing module, Spatial Dimension charge volume analysis of distribution module, different automobile types charging process mutation analysis module including charge data etc..The present invention solves the problems, such as traditional manual or customization analysis charge rule, in the case that especially charging is on a grand scale, charge data analysis time is shortened within 1 minute from previous a few hours, support the extemporaneous analysis of different analysis dimensions, the timeliness that charge rule analysis greatly improved provides decision data basis to charging station construction, optimization charging schedule, charging station planning, bicycle charging optimization etc..

Description

The multi-dimensional intelligent analysis system of new-energy automobile charge rule
Technical field
The present invention relates to a kind of multi-dimensional intelligent analysis systems of new-energy automobile charge rule, belong to electric car charging skill Art field.
Background technique
New-energy automobile industry is as national industry strategy, at present fast-developing and popularization and application, the development of electric car It is unable to do without the construction of electrically-charging equipment.Charging has the characteristics such as big, the strong, rapid development of randomness of power, large-scale automobile charging It will affect the safe and stable operation of power grid.
Therefore, the trip rule and its charging behavior of quantitative analysis new-energy automobile, analyzes charging from multidimensional angle comprehensively Rule helps to reinforce the heightened awareness to charging demand for electric vehicles, and the prior art is mainly the following mode:
1) off-line data is exported, manual analyzing is carried out by the methods of Excel;
2) statistics of data is carried out by sql sentence or data base querying mode;
3) proprietary statistics program is developed, realizes proprietary page interrogation from bicycle loss, power station electricity etc..
Above-mentioned 1) kind mode be manual mode, individual special demands can temporarily should in this way, other situations Under do not adapt to various businesses actual conditions and development need substantially.
2) kind mode need certain programming basis Data Analyst and personnel very familiar to database structure This statistics just may be implemented, requirement of this mode to Data Analyst is very high, often rapid swollen with business demand It is swollen to be difficult to get caught up in.
3) kind mode generally have preferable human-computer interaction interface, common business demand also can conveniently and efficiently be divided Analysis is realized by page tissue and is analyzed the charge rule of overall picture, but limitation in a new business demand it is also obvious that mention After out, generally require through customized development, data statistics, show as a result, if the analysis data time span being related to is very big, It is just difficult to that presenting for analysis result is rapidly completed.
All there is limitation in three of the above mode, especially can not achieve the impromptu inquiry of online different dimensions.
Summary of the invention
The technical problem to be solved by the invention is to provide a kind of analyses of the multi-dimensional intelligent of new-energy automobile charge rule to be System without presetting the logic of statistical analysis, but utilizes OLAP multidimensional analysis technology, from time, space, vehicle, battery Equal different dimensions realize immediate inquiring, and Data Analyst is facilitated quickly to excavate discovery charge rule.
In order to solve the above technical problems, the technical solution adopted by the present invention are as follows:
The multi-dimensional intelligent analysis system of new-energy automobile charge rule, including following functions module:
Multidimensional analysis platform based on Kylin, for managing the incidence relation between new-energy automobile charge data and data;
The Data cube model of charge data constructs module, multidimensional analysis platform is based on, by ETL tool, by charge data And its fact that incidence relation table extracts, and establishes charge data cube;
Time dimension charging frequency law-analysing module passes through time dimension drilling analysis on the basis of charge data cube Tool creates the querying condition of Multiple Time Scales, the rule of analysis the charging frequency and charge volume, charge power;
Spatial Dimension charge volume analysis of distribution module is drilled through point on the basis of charge data cube by Spatial Dimension Analysis tool analyzes different charging piles, different charging stations, different regions from the charge power in different provinces and charge volume and is distributed rule Rule;
Different automobile types charging process mutation analysis module, establishes analysis model from operational angle, according to different business demand shapes At different analysis results;
Result display module is analyzed, finally, the analysis result of different dimensions is intuitively shown by visual means.
The multidimensional analysis platform based on Kylin is operated in for managing the charge data of new-energy automobile In Linux server, pass through incidence relation management between the modeling tool of wizard-like, tables of data, true table and dimension table Different dimensions and index is arranged in association, is convenient for from different dimensional analysis charge data cubes.
The dimension table includes time, power station, battery, vehicle, client, customer type, clearing type.
The fact table includes charging order record, charging station account data, charging pile data.
The visual means include visualization table.
The different business demand includes traffic and the flat charge profile feature of electric power peak valley, and bicycle charges behavior, same Charging behavior change caused by type new-energy automobile charge rule, different battery charge rules and promotion.
The invention has the benefit that
The case where present invention solves the problems, such as traditional manual or customization analysis charge rule, and especially charging is on a grand scale Under, charge data analysis time is shortened within 1 minute from previous a few hours, extemporaneous point for supporting different analysis dimensions The timeliness of charge rule analysis greatly improved in analysis, fills to charging station construction, optimization charging schedule, charging station planning, bicycle It is electrically optimized etc. to provide decision data basis.
The present invention can bring actual operation, O&M, rule to each electric vehicle, each charging station, each city Charge Management Break-up value is drawn, it is real with the multi-dimensional intelligent analysis system and method for service bring direct economic benefit per year over 5000000 yuan The indirect benefit of existing energy-saving charging and reasonable construction is per year over 100000000 yuan.
Detailed description of the invention
Fig. 1 is the structural diagram of the present invention.
Specific embodiment
The present invention will be further explained with reference to the accompanying drawing.
As shown in Figure 1, the multi-dimensional intelligent analysis system of new-energy automobile charge rule, including following functions module:
Multidimensional analysis platform based on Kylin, for managing the incidence relation between new-energy automobile charge data and data; For managing the charge data of new-energy automobile, operates in Linux server, pass through the modeling tool of wizard-like, data Incidence relation management, true table between table are associated with dimension table, different dimensions and index are arranged, convenient for dividing from different dimensions Analyse charge data cube;
The Data cube model of charge data constructs module, will be filled based on multidimensional analysis platform by kettle ETL tool The fact that electric data and its incidence relation, table extracted, and established charge data cube;True table is charging order record, fills Power station account data, charging pile data etc., the present invention mainly use Star Model to design charge data cube.Dimension table packet Time, power station, battery, vehicle, client, customer type, clearing type etc. are included, index includes the charging frequency, charging station power benefit With rate, charging pile time availability, churn rate, charging station electricity loss rate etc..
Time dimension charging frequency law-analysing module is drilled through on the basis of charge data cube by time dimension Analysis tool creates the querying condition of Multiple Time Scales, the rule of analysis the charging frequency and charge volume, charge power;
Spatial Dimension charge volume analysis of distribution module is drilled through point on the basis of charge data cube by Spatial Dimension Analysis tool analyzes different charging piles, different charging stations, different regions from the charge power in different provinces and charge volume and is distributed rule Rule;
Time dimension drilling analysis tool and Spatial Dimension drilling analysis tool are OLAP multidimensional analysis technology.
Different automobile types charging process mutation analysis module, establishes analysis model from operational angle, according to different business need It asks to form different analysis results;The different business demand includes traffic and the flat charge profile feature of electric power peak valley, list Charging behavior change caused by vehicle charging behavior, same type new-energy automobile charge rule, different battery charge rules and promotion Deng.
Result display module is analyzed, finally, the analysis result of different dimensions is intuitively shown by visual means;This implementation Example shows code without writing front end page, can be with to different dimensions inquiry by Saiku open source system matched with Kylin Dynamic Display is selected to come out according to condition, the analysis query result of different dimensions is intuitively shown by visualizing forms mode, is made It obtains Data Analyst and obtains mining analysis result at a glance.
The purpose of the present embodiment is that a kind of OLAP dimensional analytic system of new-energy automobile charge rule is provided, by being based on The multidimensional analysis platform of Kylin, Data cube model building module, the time dimension charging frequency including charge data Law-analysing module, Spatial Dimension charge volume analysis of distribution module, different automobile types charging process mutation analysis module etc. are Electric automobile charging station construction provides advisory opinion with planning.
In conclusion according to the abovementioned embodiments of the present invention, providing a kind of multidimensional intelligence of new-energy automobile charge rule Can analysis system, by the time, space, business different dimensions multidimensional drilling analysis charge rule, meanwhile, analysis result be not necessarily to Coding can be shown by forms mode.
The above is only a preferred embodiment of the present invention, it should be pointed out that: for the ordinary skill people of the art For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered It is considered as protection scope of the present invention.

Claims (6)

1. the multi-dimensional intelligent analysis system of new-energy automobile charge rule, it is characterised in that: including following functions module:
Multidimensional analysis platform based on Kylin, for managing the incidence relation between new-energy automobile charge data and data;
The Data cube model of charge data constructs module, multidimensional analysis platform is based on, by ETL tool, by charge data And its fact that incidence relation table extracts, and establishes charge data cube;
Time dimension charging frequency law-analysing module passes through time dimension drilling analysis on the basis of charge data cube Tool creates the querying condition of Multiple Time Scales, the rule of analysis the charging frequency and charge volume, charge power;
Spatial Dimension charge volume analysis of distribution module is drilled through point on the basis of charge data cube by Spatial Dimension Analysis tool analyzes different charging piles, different charging stations, different regions from the charge power in different provinces and charge volume and is distributed rule Rule;
Different automobile types charging process mutation analysis module, establishes analysis model from operational angle, according to different business demand shapes At different analysis results;
Result display module is analyzed, finally, the analysis result of different dimensions is intuitively shown by visual means.
2. the multi-dimensional intelligent analysis system of new-energy automobile charge rule according to claim 1, it is characterised in that: described Multidimensional analysis platform based on Kylin operates in Linux server, leads to for managing the charge data of new-energy automobile The incidence relation management crossed between the modeling tool of wizard-like, tables of data, true table are associated with dimension table, and different dimensions are arranged And index, it is convenient for from different dimensional analysis charge data cubes.
3. the multi-dimensional intelligent analysis system of new-energy automobile charge rule according to claim 2, it is characterised in that: described Dimension table includes time, power station, battery, vehicle, client, customer type, clearing type.
4. the multi-dimensional intelligent analysis system of new-energy automobile charge rule according to claim 1, it is characterised in that: described True table includes charging order record, charging station account data, charging pile data.
5. the multi-dimensional intelligent analysis system of new-energy automobile charge rule according to claim 1, it is characterised in that: described Visual means include visualization table.
6. the multi-dimensional intelligent analysis system of new-energy automobile charge rule according to claim 1, it is characterised in that: described Different business demands includes traffic and the flat charge profile feature of electric power peak valley, bicycle charging behavior, same type new energy vapour Charging behavior change caused by vehicle charge rule, different battery charge rules and promotion.
CN201910673113.0A 2019-07-24 2019-07-24 The multi-dimensional intelligent analysis system of new-energy automobile charge rule Pending CN110442938A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910673113.0A CN110442938A (en) 2019-07-24 2019-07-24 The multi-dimensional intelligent analysis system of new-energy automobile charge rule

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910673113.0A CN110442938A (en) 2019-07-24 2019-07-24 The multi-dimensional intelligent analysis system of new-energy automobile charge rule

Publications (1)

Publication Number Publication Date
CN110442938A true CN110442938A (en) 2019-11-12

Family

ID=68431403

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910673113.0A Pending CN110442938A (en) 2019-07-24 2019-07-24 The multi-dimensional intelligent analysis system of new-energy automobile charge rule

Country Status (1)

Country Link
CN (1) CN110442938A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113077113A (en) * 2021-05-10 2021-07-06 成都特来电新能源有限公司 Intelligent planning and design method for charging infrastructure

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104820790A (en) * 2015-05-25 2015-08-05 国家电网公司 Method and device for processing charging load data of electric automobile
US20180285439A1 (en) * 2017-03-28 2018-10-04 Shanghai Kyligence Information Technology Co., Ltd Olap pre-calculation model, automatic modeling method, and automatic modeling system
CN109193727A (en) * 2018-10-30 2019-01-11 国网江苏省电力有限公司南通供电分公司 A kind of intelligent distribution network probability coordinated planning method containing electric car
CN109408548A (en) * 2018-09-19 2019-03-01 中国电力科学研究院有限公司 A kind of urban electric power big data application system and method
CN110019396A (en) * 2017-12-01 2019-07-16 中国移动通信集团广东有限公司 A kind of data analysis system and method based on distributed multidimensional analysis

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104820790A (en) * 2015-05-25 2015-08-05 国家电网公司 Method and device for processing charging load data of electric automobile
US20180285439A1 (en) * 2017-03-28 2018-10-04 Shanghai Kyligence Information Technology Co., Ltd Olap pre-calculation model, automatic modeling method, and automatic modeling system
CN110019396A (en) * 2017-12-01 2019-07-16 中国移动通信集团广东有限公司 A kind of data analysis system and method based on distributed multidimensional analysis
CN109408548A (en) * 2018-09-19 2019-03-01 中国电力科学研究院有限公司 A kind of urban electric power big data application system and method
CN109193727A (en) * 2018-10-30 2019-01-11 国网江苏省电力有限公司南通供电分公司 A kind of intelligent distribution network probability coordinated planning method containing electric car

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
陈兴强等: "新能源公交车辆大数据决策支持平台的研究", 《城市公共交通》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113077113A (en) * 2021-05-10 2021-07-06 成都特来电新能源有限公司 Intelligent planning and design method for charging infrastructure
CN113077113B (en) * 2021-05-10 2023-12-12 成都特来电新能源有限公司 Intelligent planning and designing method for charging infrastructure

Similar Documents

Publication Publication Date Title
CN107402976B (en) Power grid multi-source data fusion method and system based on multi-element heterogeneous model
CN105574652B (en) Intelligent power distribution network planning big data management and control system and method
CN109408548A (en) A kind of urban electric power big data application system and method
CN109582667A (en) A kind of multiple database mixing storage method and system based on power regulation big data
CN105022769A (en) Data interaction system of urban underground pipeline, and method thereof
CN108694244A (en) A kind of electric network synthetic application platform based on three-dimensional data
CN103559562A (en) Power grid intelligent operation system and achieving method thereof
CN108446396B (en) Power data processing method based on improved CIM model
CN107832876B (en) Partition maximum load prediction method based on MapReduce framework
CN104020396A (en) Grid fault diagnosis method based on data mining
CN103970887A (en) Information stream display system and method based on GIS distribution network graphs
CN107918830A (en) A kind of distribution Running State assessment system and method based on big data technology
CN105117421A (en) Social network analysis method based on graph structure matching
CN110532283A (en) A kind of smart city big data processing system based on Hadoop aggregated structure
CN115423429A (en) Multimode integrated distribution network operation system based on image and sound information
CN106203787A (en) The industry information analysis method added based on a figure and system
CN112102003A (en) Big data platform-based electricity customer core resource management system and method
CN115358522A (en) Enterprise online monitoring system and method
CN109412155B (en) Power distribution network power supply capacity evaluation method based on graph calculation
CN104484734A (en) Low-carbon city energy optimized configuration data center architecture
CN110442938A (en) The multi-dimensional intelligent analysis system of new-energy automobile charge rule
CN113722564A (en) Visualization method and device for energy and material supply chain based on space map convolution
Escobedo et al. Business intelligence and data analytics (BI&DA) to support the operation of smart grid
CN111191803A (en) Information management platform system for airport flight area pavement
Li et al. A data warehouse architecture supporting energy management of intelligent electricity system

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
AD01 Patent right deemed abandoned

Effective date of abandoning: 20230721

AD01 Patent right deemed abandoned