SAP HANA Application development by Milen Manov

Transcript

1. Use this title slide only with an image SAP HANA Application Development Milen Manov
 March 2016 Public
2. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 2 Disclaimer This presentation outlines our general product direction and should not be relied on in making a purchase decision. This presentation is not subject to your license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release any functionality mentioned in this presentation. This presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.
3. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 3 Agenda • Why SAP HANA Platform? • What is the SAP HANA Platform? • Demo of what can you do with SAP HANA Platform? • Try for free on SAP HANA Cloud Platform
4. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 4 Agenda • Why SAP HANA Platform? • What is the SAP HANA Platform? • Demo • Try for free on SAP HANA Cloud Platform
5. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 5 The challenges with current IT Landscape
 Silos, delay and complexity hinders business agility and innovation ETL & Staging Data Application silos Multiple data copies Batch processing Partial business view No real-time insights Limited ability to innovate Manufacturing App Data Logic Finance App Data Logic Sales App Data Logic Service App Data Logic Streaming App Data Logic Predictive App Data Logic Analytics App Logic Data Spatial App Data Logic ETL & Staging Data ETL & Staging Data
6. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 6 No waiting for data access and processing Speed Simplicity Innovation All 
 application logic (OLTP & OLAP) processed in one system The solution is only possible with in-memory data management
 Only data in-memory enables all applications to become real-time All data types processed in one system Data Manufacturing App Finance 
 App Sales 
 App Service 
 App Streaming 
 App Predictive 
 App Analytics 
 App Spatial 
 App ONE Platform for ALL applications Logic Logic Logic Logic Logic Logic Logic Logic
7. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 7 Agenda • Why SAP HANA Platform? • What is the SAP HANA Platform? • Demo • Try for free on SAP HANA Cloud Platform
8. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 8 • Database & data processing engines • Application Server • Planning, Calculation engine • Libraries of statistical, predictive and business functions What is SAP HANA OLTP + OLAP 
 in Columnar database SIMPLIFIED Application 
 Processing OPTIMIZED End-to-end
 Data Processing CONVERGED Text Planning Geo Spatial Transactions Streaming Prescriptive Predictive Sentiment Intelligence Machine Learning Operational Analytics SAP HANA
 (Main Memory) SAP HANA
 (Main Memory) SAP HANA
 (Main Memory) Application 
 Server Layer In-Memory 
 Database layer Libraries
9. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 9 SAP HANA DB Row and Column Store + + ++ Compression Partitioning Avoiding Aggregate Tables Insert Only on Delta
10. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 10 The wonders of Dictionary Compression Order Country Product Sales 456 France corn 1000 457 Italy wheat 900 458 Spain rice 600 459 Italy rice 800 460 Denmark corn 500 461 Denmark rice 600 462 Belgium rice 600 463 Italy rice 1100 … … … … Logical Table 1 Belgium 2 Denmark 3 France 4 Italy 5 Spain 5 entries ! 
 3 bits to encode 1 3 2 4 3 5 4 4 5 2 6 2 7 1 8 4 … … Dictionary 1 7 2 5,6 3 1 4 2,4,8 5 3 Compressed column Where was order 460? Inverted
 index Which orders 
 in Italy?
11. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 11 Delta Store Delta Store Read Write Main
 Store New Delta Read Write New Main New Main New Delta Write Read Merge Operation Main Store Delta Store During delta merge operation: • Read/write access still works on old stores and new delta store After delta merge operation: • Data optimized for fast access again Before delta merge operation: • Delta store grows
12. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 12 Parallel Processing Column
 Order 456 457 458 459 460 461 462 463 … Column
 Product corn wheat corn rice wheat barley rye wheat … Column
 Sales 1000 1050 600 800 2000 300 900 1200 … Core 4 Core 3 Core 1 Core 2 processed by processed by processed by processed by
13. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 13 • Database & data processing engines • Application Server • Planning, Calculation engine • Libraries of statistical, predictive and business functions Simplify Data Processing OLTP + OLAP 
 in Columnar database SIMPLIFIED Application 
 Processing OPTIMIZED End-to-end
 Data Processing CONVERGED Text Planning Geo Spatial Transactions Streaming Prescriptive Predictive Sentiment Intelligence Machine Learning Operational Analytics SAP HANA
 (Main Memory) SAP HANA
 (Main Memory) SAP HANA
 (Main Memory) Application 
 Server Layer In-Memory 
 Database layer Libraries
14. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 14 File Filtering • Load binary, flat, and other documents directly into HANA for native text search and analysis Native Text Analysis • Give structure to unstructured textual content • Supports up to 31 languages for linguistic mark-up and extraction dictionary and 11 languages for predefined core extractions Text Analysis for Big Data
15. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 15 Linguistic Search Require full-text index Exact search • Finds contained words • Exact spelling matters Linguistic search • Find word forms with same linguistic stem SELECT * FROM "MESSAGES"
 WHERE CONTAINS("MESSAGE", 'businesses', EXACT) SELECT * FROM "MESSAGES"
 WHERE CONTAINS("MESSAGE", 'go', LINGUISTIC)
16. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 16 Sentiment Analysis Sentiment analysis, is the field of study that analyzes people’s opinions, sentiments, evaluations, appraisals, attitudes, and emotions towards entities such as products, services, organizations, individuals, issues, events, topics, and their attributes. -- Bing Liu, “Sentiment Analysis and Opinion Mining“
17. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 17
18. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 18 SAP HANA In-Memory Predictive Analytics Predictive Analysis Library (PAL) • Native predictive algorithms • In-database processing for powerful and fast results • Quicker implementations • Support for clustering, classification, association, time series etc… R Integration for SAP HANA • Enables the use of the R open source environment (> 3,500 packages) in the context of the HANA in-memory database • R integration enabled via high performing parallelized connection • R script is embedded within SAP HANA SQL Script Combine in-memory analytics in SAP HANA with R to support a variety of advanced 
 analytic and predictive scenarios
19. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 19 • Database & data processing engines • Application Server • Planning, Calculation engine • Libraries of statistical, predictive and business functions Application Platform OLTP + OLAP 
 in Columnar database SIMPLIFIED Application 
 Processing OPTIMIZED End-to-end
 Data Processing CONVERGED Text Planning Geo Spatial Transactions Streaming Prescriptive Predictive Sentiment Intelligence Machine Learning Operational Analytics SAP HANA
 (Main Memory) SAP HANA
 (Main Memory) SAP HANA
 (Main Memory) Application 
 Server Layer In-Memory 
 Database layer Libraries
20. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 20 Push the control flow down! Presentation logic Control flow logic Calculation logic Data Client HANA
21. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 21 Development model for SAP HANA based native applications SAP HANA extended application services offer • Easy access to SAP HANA database via HTTP-based consumption • Attractive, dynamic HTML5 UI applications via OData services or by writing native application-specific code that runs in SAP HANA context • Powerful search services • Built-in web server to access static content stored in SAP HANA repository Application development following a layered approach • UI rendering completely in the client (browser, mobile apps) • Server-side procedural logic in JavaScript • All artifacts stored in the SAP HANA repository SAP HANA Client Presentation logic Control flow logic Calculation logic Data XS
22. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 22 SAP HANA Extended Application Services – Overview 
 Front-end Technologies • http/s • HTML5 / SAPUI5 • Client-side JavaScript Control Flow Technologies • OData • Server-Side JavaScript • XMLA Data Processing Technologies • SQL / SqlScript • Calculation Engine Functions • Application Function Library (AFL) Presentation logic Control flow logic Data Client: Browser or Mobile SAP HANA XS Calculation logic
23. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 23 Development tools • SAP HANA Studio • Web IDE
24. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 24 Agenda • Why SAP HANA Platform? • What is the SAP HANA Platform? • Demo • Try for free on SAP HANA Cloud Platform
25. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 25 Customers: SAP solutions powered by SAP HANA 1,721x Faster daily production control report SAP Suite on HANA, SAP HANA Live 3 days Migrate to SAP Suite on HANA, SAP HANA Enterprise Cloud 96% Reduction in data extract, processing, and load times SAP BW powered by SAP HANA 400% Faster reporting speed for accelerated analysis and planning cycles, time to action SAP BPC powered by SAP HANA, SAP BW powered by SAP HANA Unified Picture of sales, profits, and share targets, all in one system SAP S&OP powered by HANA <3 Seconds Render 500 million rows of data graphically to the user SAP Lumira powered by HANA 70% Reduction in IT total cost of ownership SAP Suite on HANA, SAP HANA Enterprise Cloud 45% growth of fantasy football platform using SAP HANA Cloud Platform and SAP Lumira Cloud powered by SAP HANA
26. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 26 SAP HANA Cloud Platform (PaaS) Big Data Services Data & Storage Services SAP HANA Cloud Platform Platform Services Dev & Ops Java / HTML5 Runtimes IaaS Layer On-Premise / Managed Cloud (HEC) SAP S/4 HANA SAP Business
 Suite SAP Business Warehouse SaaS SuccessFactors C4C Concur SAP S/4 HANA Ariba Analytics Collaboration UX Integration Security Mobile IoT ASE HANA Build Extend Integrate
27. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 27 Try out for free on https://account.hanatrial.ondemand.com/
28. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 28 Useful links • https://account.hanatrial.ondemand.com/ • https://open.sap.com/courses • https://www.youtube.com/user/saphanaacademy
29. © 2015 SAP SE or an SAP affiliate company. All rights reserved. Thank you Contact information: Milen Manov milen.manov@sap.com Bemberis, Ainars <ainars.bemberis@sap.com>