Introduction to SAP HANA: A Powerful Database Solution
SAP HANA is a high-performance in-memory database management system used for both OLTP and OLAP scenarios, providing real-time analytics and data processing. Built on cutting-edge technology, SAP HANA offers extended application services, SQLScript for advanced programming, and a robust architecture. Learn about its history, architecture, features, and applications in this detailed overview.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
SAP HANA ANTOL, HOLI , KEDA PA195 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, MaxDB Hasso Plattner Current direction is cloud - partnerships with IBM and Microsoft SAP s flagship product SAP S/4HANA 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 (2d tables) Unstructured (graphs, texts, spatial)
SAP HANA XS alias to eXtended 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/JiveServlet/previewBody/41137-102-1- 60158/162%20Introduction%20to%20SQLScript%20in%20SAP%20HANA.pdf
BEGIN -- Query 1 product_ids = select "ProductId", "Category", "DescId" from "SAP_HANA_EPM_DEMO"."sap.hana.democontent.epm.data::products" where "Category" = 'Notebooks' or "Category" = 'PC'; -- Query 2 product_texts = select "ProductId", "Category", "DescId", "Text" from :product_ids as prod_ids inner join "SAP_HANA_EPM_DEMO"."sap.hana.democontent.epm.data::texts" as texts on prod_ids."DescId" = texts."TextId"; -- 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 SAP HANA On- -Premise Premise SAP HANA in the Cloud SAP HANA in the Cloud SAP HANA Hybrid 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 DataCenter 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 PaaS - Platform as a Service IaaS - Infrastructure as a Service Mcaas - HANA Cloud Platform and Managed Cloud as a Service Platform 3rd 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/70c8e423-c8aa-3210-3fae-e043f5c1ca92&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/
