SAP HANA ANTOL HOLI KEDA PA 195 SPRING
- Slides: 18
SAP HANA ANTOL, HOLIČ, KEDA PA 195 SPRING 2016
Outline General outline Theoretical core Live Demo(nstration)
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 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 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 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 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". "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 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 Hybrid
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
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 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 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/
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/
- Interactive analysis sap business one
- Sap hana hint
- Sap s4 hana for life science industry
- Qa cheat sheet
- Sap hana predictive analysis library
- Sap hana analysis process
- Sap s4 hana automotive
- Sap pxa_no_shared_memory
- Hana sybase
- Lssue
- Sap strategie
- Sap s&op
- Lenovo sap hana appliance
- Sap hana data provisioning
- It company
- Nutanix sap hana production
- Abap cl_http_client
- Sap back order processing
- Cloudera 설치