SAP HANA ANTOL HOLI KEDA PA 195 SPRING

  • Slides: 18
Download presentation
SAP HANA ANTOL, HOLIČ, KEDA PA 195 SPRING 2016

SAP HANA ANTOL, HOLIČ, KEDA PA 195 SPRING 2016

Outline General outline Theoretical core Live Demo(nstration)

Outline General outline Theoretical core Live Demo(nstration)

SAP SE 5 engineers from IBM Hasso Plattner Originally original software, currently also acquisitions

SAP SE 5 engineers from IBM Hasso Plattner Originally original software, currently also acquisitions (10+ billions $ since 2012) One of largest software development companies basically, too big to describe

History – SAP HANA in context TREX , P*TIME, Max. DB Hasso Plattner Current

History – SAP HANA in context TREX , P*TIME, Max. DB Hasso Plattner Current direction is cloud - partnerships with IBM and Microsoft SAP’s flagship product SAP S/4 HANA is built upon HANA (suite containing crm, erp, and other 3 letter business acronyms)

SAP HANA In-memory, column oriented, ACID complying database Vision: store everything in-memory Basic use

SAP HANA In-memory, column oriented, ACID complying database Vision: store everything in-memory Basic use cases: OLTP - inserts - to record some real world transaction OLAP - queries - to find trends 1 copy of data Can store: Relational data (2 d tables) Unstructured (graphs, texts, spatial)

SAP HANA XS alias to e. Xtended application Services application server and web server

SAP HANA XS alias to e. Xtended application Services application server and web server Not standalone application - tightly integrated into HANA Simplifies architecture of overall system and individual applications Programming model: Data intensive calculations in HANA, front-end processing on client XS just glues this together http: //scn. sap. com/docs/DOC-60322 http: //scn. sap. com/community/developer-center/hana/blog/2012/11/29/sap-hana-extended-application-services

SAP HANA SQLScript An interface for applications to access SAP HANA Extension of ANSI

SAP HANA SQLScript An interface for applications to access SAP HANA Extension of ANSI Standard SQL (DDL, DML, Calculation Engine …) Language for creating stored procedures in HANA Extending: Exception handling Enables modular programming, reuse local variables control logic such as if/else that is not available in SQL https: //www. asug. com/discussions/servlet/Jive. Servlet/preview. Body/41137 -102 -160158/162%20 Introduction%20 to%20 SQLScript%20 in%20 SAP%20 HANA. pdf

BEGIN -- Query 1 product_ids = select "Product. Id", "Category", "Desc. Id" from "SAP_HANA_EPM_DEMO".

BEGIN -- Query 1 product_ids = select "Product. Id", "Category", "Desc. Id" from "SAP_HANA_EPM_DEMO". "sap. hana. democontent. epm. data: : products" where "Category" = 'Notebooks' or "Category" = 'PC'; -- Query 2 product_texts = select "Product. Id", "Category", "Desc. Id", "Text" from : product_ids as prod_ids inner join "SAP_HANA_EPM_DEMO". "sap. hana. democontent. epm. data: : texts" as texts on prod_ids. "Desc. Id" = texts. "Text. Id"; -- Query 3 out_notebook_count = select count(*) as cnt from : product_texts where "Category" = 'Notebooks'; -- Query 4 out_pc_count = select count(*) as cnt from : product_texts where "Category" = 'PC'; -- Query 5 out_total_count = select count(*) as cnt from "SAP_HANA_EPM_DEMO". "sap. hana. democontent. epm. data: : products“; END;

SAP HANA Vora Combines: HADOOP + YARN + SPARK Enables: hierarchical queries + OLAP

SAP HANA Vora Combines: HADOOP + YARN + SPARK Enables: hierarchical queries + OLAP in-memory computing engine for Hadoop -> makes Hadoop faster An in-memory query engine that runs on Apache Spark execution framework Compiled queries for accelerated processing across Hadoop Distributed File System (HDFS) nodes Enhanced Spark SQL semantic to include hierarchies to enable OLAP and drill-down analysis Is independent on HANA ● http: //scn. sap. com/community/developer-center/hana/blog/2015/10/05/sap-hana-vora-hadoop

SAP HANA Deployment options SAP HANA On-Premise SAP HANA in the Cloud SAP HANA

SAP HANA Deployment options SAP HANA On-Premise SAP HANA in the Cloud SAP HANA Hybrid

SAP HANA On-Premise SAP HANA Appliance Delivery ● the Solution validation is performed by

SAP HANA On-Premise SAP HANA Appliance Delivery ● the Solution validation is performed by SAP and the SAP partner including preconfigured hardware set-up and preinstalled software. SAP HANA Tailored Data. Center Integration ● enables the Installation and validation to be performed by the customer’s SAP Certified Technology Specialist, and the customer is in charge to align with the hardware partner on the individual support model.

SAP HANA In the Cloud Public Cloud Managed Private Cloud Platform as a service

SAP HANA In the Cloud Public Cloud Managed Private Cloud Platform as a service

So… what is SAP HANA? : ) Database ● Alternative to traditional RDBMS Appliance

So… what is SAP HANA? : ) Database ● Alternative to traditional RDBMS Appliance ● Pre-packed by major HW vendors (resulting from HW demands on RAM) Cloud ● Paa. S - Platform as a Service ● Iaa. S - Infrastructure as a Service ● Mcaas - HANA Cloud Platform and Managed Cloud as a Service Platform ● 3 rd party cloud vendors ● hybrid solutions

SAP HANA Internals #1 In-Memory - everything is stored in RAM - In-Memory first

SAP HANA Internals #1 In-Memory - everything is stored in RAM - In-Memory first approach - disks are only seen as a place to initially load data from and to store new data to, and so provide durability in the case of hardware failure or power loss Compression - redundancy handling (dictionary based) Partitioning - two types of partitioning: single column stored to many servers and different columns of a table stored to many servers

SAP HANA Internals #2 Data stripping - optimization enabling skipping unused columns Parallel processing

SAP HANA Internals #2 Data stripping - optimization enabling skipping unused columns Parallel processing Multiple engines - separate calculation engine - separate planning engine used for functional reporting - OLAP engine, join engine, row engine, SQL engine, . . . - above is controller dividing tasks to these engines

Live Demonstration https: //account. hanatrial. ondemand. com/

Live Demonstration https: //account. hanatrial. ondemand. com/

Would you like to know more? https: //hana. sap. com https: //blogs. saphana. com/2014/09/09/the-sap-hana-faq/

Would you like to know more? https: //hana. sap. com https: //blogs. saphana. com/2014/09/09/the-sap-hana-faq/ https: //blogs. saphana. com/2015/05/19/nosql-oldsql-newsql-memory-sap-hana/ http: //www. sdn. sap. com/irj/scn/index? rid=/library/uuid/70 c 8 e 423 -c 8 aa-3210 -3 fae-e 043 f 5 c 1 ca 92&overridelayout=true http: //help. sap. com/hana/SAP_HANA_Administration_Guide_en. pdf https: //hana. sap. com/implementation/deployment. html https: //account. hanatrial. ondemand. com/ https: //blogs. saphana. com/2013/08/02/the-hana-difference-sap-hana-s-defining-capabilities/