SAP HANA: an Intelligent Solu4on for Metropolitan City Transport Network
4fun
Igor Anosov Suren Avanian Anastasia Tikhonova Anna Tikhonova
Suren Avanian
Anastasia Tikhonova
Anna Tikhonova
Igor Anosov
NRU HSE, 4th year, Faculty of Economics
NRU HSE, 4th year, Faculty of Economics
NRU HSE, 4th year, Faculty of Economics
NRU HSE, 4th year, Faculty of Economics
Achievements: • Winner of the All-‐Russian olympiad in economics in 2010 • Twice recipient of the award given by the president of Russia • HQ 15% Changellenge Cup Moscow’10 • HQ MedXChallenge’13
Achievements: • Winner of the All-‐Russian olympiad in French in 2010 • Recipient of the award given by the president of Russia • HQ MedXChallenge’13
Achievements: • Winner of the All-‐Russian olympiad in French in 2009 and 2010 • Twice recipient of the award given by the president of Russia • HQ MedXChallenge’13
Achievements: • Winner of the HSE olympiad in economics in 2010 • Member of the Student Council of the Faculty of Economics HSE • Semi-‐finalist Changellenge Cup Russia’13
• Semi-‐finalist Changellenge Cup Russia’13
• Semi-‐finalist Changellenge Cup Russia’13
• Semi-‐finalist Changellenge Cup Russia’13
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement
The main aim of the case is to analyse the current situa4on of the Moscow transporta0on system and the opportuni4es of ITS implementa0on on the plaMorm of SAP HANA in order to make city life beVer What are the exis0ng problems and how ITS can help solve them?
Problems exist in different dimensions of transporta0on system
What are the opportuni0es and the risks of ITS project?
ITS gives more opportuni0es for comfortable city life
Significance of the project and government support can mi0gate possible risks
The following expansion of the project
Why SAP HANA is the most suitable system for solving transporta0on issues?
SAP HANA has a lot of high quality instruments
They provide compe00ve advantages for instant Big Data analysis
SAP HANA is an irreplaceable plaMorm for solving transporta0on problems
How could ITS be integrated into the current Moscow transporta0on system?
Already-‐func0oning facili0es could be a perfect founda0on for further improvement in ITS
Exis0ng foreign experience is successful and has common features with Moscow infrastructure
ITS can b e easily integrated into current Moscow infrastructure
What is the impact of project implementa0on in various spheres of city life?
Economic, social, ecological spheres, city image and security are beneficially effected by ITS
There could be a substan0al decrease in cons as well as a significant improvement in pros
ITS implementa0on makes Moscow life much more comfortable from all points of view
ITS has a wide scope of applica0ons via effec0ve measures
High probability of successful results of the program
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement
Moscow is a well-‐developed city, but it has many infrastructural problems which could be solved by applying ITS to different aspects of transporta0on system Ci4zens and ecology
Cars and traffic system
Chao0c parking impede the flow of passengers spend > 3 hours Low quality of pedestrian and bicycle on the route infrastructure Environmental deteriora0on measures
Moscow is the world’s most congested city 42% • the roads are overloaded overloaded • low organisa0on of city traffic 20% Increasing the number of cars
increasing
Public transport is overloaded during peak hours The route network of public transport is outdated Metro is not available to all ci0zens
20% overloaded
Insufficient number of safe taxi Unpredictable taxi fares Low quality of trucking systems
measures
10% deficit
measures
results
Informing passengers about opera0on of public transport at any 0me from any place
Improving parking policy
Easy movement through the city streets
Taxi and trucks
Public transport
Tracking the routes of public and specialised transport
Informing drivers about current traffic situa0on
results
Allowing ci0zens to control quality of air in the city
Reducing travel 0me and improving environment
Comfortable, fast and efficient public transport
Sources: case, our analysis, www.gucodd.ru, www.ec.europa.eu, www.budget.mos.ru
Providing safety and clear fares in taxi Improving the system of trucking
results
Chargeable parking system
results
measures
Safe taxi with a transparent tariff system
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement
ITS provides a wide range of opportuni4es for crea0ng a comfortable, economical and clean city; however, several risks have to be overcome before this system en4rely func4ons Opportuni4es
Risks
Organisa0on of city traffic using the modeling tools for transport flows
System integra4on & technology deployment issues: • interfacing old & new technologies • developing centralized systems • consistency with standards
Ensuring safety and security on transport and in city streets using road and street video surveillance systems Implementa0on of measures in the sphere of parking policy Management of a large number of traffic lights Reducing the number of missing cars
Ins4tu4onal issues: • integra0on of ITS into agency ac0vi0es • jurisdic0onal barriers • public private partnerships • resistance to new technologies
Mi4gants • Building a new system on the basis of the old one with the effec0ve system of control and management • Monitoring the efficiency of the program implementa0on with involvement of independent experts The importance of this program for the capital of Russia reduces the barriers for implementa0on
Financial issues: • project funding • payment for ITS services • market regula0on
Using credit schemes, preparing and carrying out measures to improve the investment a[rac0veness of project implementa0on
Boosted traffic efficiency and speed
Implementa0on of automated paying system on public transport
Professional development issues: • training and educa0on • sharing of informa0on
• Training and retraining, invi0ng specialized consultants • Enhancing the a[rac0veness and pres0ge of work in this sphere
Legal issues: • liability • privacy laws
Prepara0on of certain legisla0ve acts for the corresponding program
Decrease in traffic conges0on
Improving the logis0c system Implementa0on of op0mal planning policy Sources: case, our analysis, www.budget.mos.ru, www.\wa.dot.gov
Risk coverage
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement
The architecture of SAP HANA provides opportunity to create ITS in Moscow, allowing to analyze large amounts of informa0on with good velocity and low cost for the user SAP HANA architecture features «In-‐memory» database A hybrid database which keeps informa0on using both сolumn and tradi0onal row storage models
«Calcula4on engine»
∞
A high-‐speed computa0on machine of IMCE
Obtaining informa4on from non-‐ERP sources The ability of using SAP BusinessObjects Data Services for non-‐real0me analysis
Flexible modeling The absence of any materializa0on, use of only virtual models, based on non-‐ aggregated opera0ve data 1Atomacity. Coordina0on. Isola0on. Durability
Sources: case, www.sap.com, SAP HANA documenta0on
Advantages they provide
Their applica4on to the exis4ng transporta4on problems
The new genera0on DWH which is compa0ble with so-‐called «ACID1 requirements» and can save huge volumes of analy0cal and transac0on data
Moscow is a megapolis with a huge infrastructure, and the load of informa0on to be analyzed is enormous that’s why access to the data should be immediate
The opportunity of instant in-‐memory big data analysis, shortening the process of informa0on exchange between DWH and applica0on
One of the main difficul0es of processing the Big Data (e.g. informa0on from cameras, sensors and SMS) is a lack of velocity. Indeed, SAP HANA Calcula0on Engine analyzes huge data in less than 3 seconds
In such a configura0on HANA can extract data from any source with a rapid request processing, playing a role of highly-‐efficient data mart on a Enterprise Data Warehouse (EDWH)
This SAP HANA func0on gives the opportunity to process not only the current informa0on, but also great volumes of data about Moscow traffic situa0on which have been accumulated during the last several years
Considerable simplifica0on of the introduc0on of changes to the model, increasing the autonomy of business users who can now easily create their own analy0cal models with the help of instruments installed in SAP HANA
Due to the flexible SAPA HANA modeling system, the employees of Moscow transporta0on department can easily build detailed analy0cal models with low transac0on and retraining costs
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement
At the moment in Moscow there exists good transporta4on infrastructure that could serve as a basis, and taking into account successful foreign experience integra0on of ITS is feasible
Things that already exist in Moscow
Degree of readiness
Traffic Management Centre of Moscow City Government (TMS)
80%
Traffic control system
40%
The Situa0on Center
80% 100%
Restric4on on number of cars Electronic payment of fares Paid parking
Intelligent traffic lights
Panel surveillance
1700
Traffic cameras 1392
2700
Speed of GPS/GLONASS 2100
Metro network length (km)
327
175
151
368
Total
Bus lanes (km)
284
22
200
113
300
Cycle lanes (km)
14
60
500
1500
1200
Number of cars (per 1000 person)
303
108
108
600
320
Annual ridership (per person)
216
611
421
274
231
708
400 New
Total
Current
100 150 New
250 Total
New Sensors
Informa4on panels
Current
Video surveillance
Facili4es to improve in Moscow
600
Current
Moscow Hong Kong Singapore New York Dublin
Driverless trains
Public transport vehicles equipped with GLONASS system
Not connected to the interac0ve map
Comparison with other ci4es where ITS was successfully implemented
126 674 Current
New
800 Total
Sources: case, www.gucodd.ru, www .mic-‐ro.com/metro/table.html, www .dt.mos.ru, www .budget.mos.ru, websites of city transport departments
Well-‐developed
Under development
Does not exist
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement
Economic
ITS favorably influences crucial spheres of city life, increasing the benefits and reducing the drawbacks Decrease in annual transport costs (bln RUB) -‐20% 329
263
Before
Amer
Ecological
Social
Reduc4on of average travel 4me -‐25-‐30% 60 min
Cut of volume of emissions (mln tonnes) -‐25% 0.9 Before
Image
42 min
0.657
+20% 5 mln
Security
Cut in number of road accidents
Before
Before
Underground Car Bus Trolleybus Tram
67 38
+60%
-‐50% 5659 Amer
40%
60%
25 21 20
Decrease in percentage of complaints about road noise (by regions) Total 14 15 12 12 complaints 11 10 8 10 6
+15-‐20%
7 Before
Top-‐3 ranking among developed ci0es in the world Reduc4on in death toll 841
-‐20%
673
Amer
Decrease in fuel consump4on (mln tonnes) -‐20%
-‐30% Improving posi4on in investment aVrac4veness ra4ng
Kept schedules
Before
0.8 1
• 1st place among Russian regions with 31% of all foreign direct investment • 5th place among the most a[rac0ve ci0es for investors in the world • 7th place among high-‐tech ci0es in Europe
-‐5%
Rise in percentage of kept schedules
Amer
42 24 16 13 12
25 RUB bus 25 RUB trolleybus 25 RUB tram 28 RUB underground
Amer
Increase in number of tourists per year 6 mln
11319
Reduc4on of a single 4cket’s price
Increasing profitability of implementa4on (bln RUB) Factors of income increase Amount per year Reduced 0me spent on the road 8.0 Reduced accident rate 3.5 Reduced environmental burden 2.6 Paid parking 0.25 Increase in average speed (kph)
5.6 Amer
Rise in volume of foreign investment Transport (bln USD) sector
70.8 78.4
0.4 7.2 Direct
PorMolio
Total Investment
+5%
Total
Cut in transport risk (death toll to 10000 cars) -‐22% 1.8 Before
1.4 Amer
Sources: case, our analysis, www.budget.mos.ru, www.mos.ru, www.data.mos.ru, www.data.mos.ru, www.dt.mos.ru, www.mosecom.ru, www.transportrussia.ru, www.gibdd.ru, www.mosgortrans.ru, www.moscow.gks.ru, www.gks.ru
Execu4ve summary
Risks & opportuni4es
Problems
Architecture
Integra4on
Supplement №1
Effects
Investment a[rac0veness and comparison of the key features of the city development Gross Domes4c Product (bln USD)
Direct foreign investment (bln USD)
543
2013 2025
455 379 310 228
189
272 188
339 188
(predic0on)
247 126 58
3.1
5.9
4.2
3.1
5.0
5.7
123
6.4
Average annual growth rate (%)
Europe La0n America North America China South-‐Eastern Asia Brazil Australia Africa Russia India
44,1
Ranking of ci4es in developing countries Transport Intellectual capital Level of technological Health, safety and infrastructure and security and innova0on readiness
Sustainable development and environment
Peking Moscow Mexico Istanbul San-‐Paolo Mumbai Jakarta Economic impact
Simplicity of doing business
Peking Moscow Mexico Istanbul San-‐Paolo Mumbai Jakarta Sources: www.inves0nmoscow.ru, www.moscow.ru, www.dvms.mos.ru
Expenditures
Demography
The city as a world center of a[rac0on
Total score 283
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Effects
Supplement №2
SAP HANA plaMorm
Conceptual view of SAP HANA plaqorm
Improvement of processing performance connected with adding cores
Hardware architecture: current and past performance boVlenecks
Sources: www.sap.com, SAP HANA documenta0on
Execu4ve summary
Problems
Risks & opportuni4es
Architecture
Integra4on
Supplement №3
Effects
Maps of the major factors associated with Moscow transporta0on system Air pollu4on in Moscow
Pedestrian zones in Moscow
Pedestrian zones in the 2012 Pedestrian zones 2013 in Landscaping sidewalks in 2013 Improvement and expansion of sidewalks in 2014
Favorable Unfavorable Quite favorable Very unfavorable Areas with the biggest number of complaints
Moscow parking space
Video surveillance in Moscow
Cameras
Sources: www.moscowmap.ru, www.parking.mos.ru, www.citysom.mosmap.ru, www.eco.mos.ru
Parking space Free and paid Parking lots