HANA overview

Jin JiangSolution Architect17-Oct

Agenda

Background

Tech overview

Roadmap

Competitor

HANA in Dell

Technology Innovations

Technology that allows the processing of massive quantities of real time data

in the main memory of the server to provide immediate results

from analyses and transactions

Merger & Acquisition

What’s the HANA

HANA=High-performance Analytic Appliance

An appliance for processing high volumes of transactional data in real time

Includes tools for data modeling, data and lifecycle management, security, operations

Provides support for multiple interfaces based on industry standards

The Application powered by HANA

• Sales & Operations Planning

• SAP Smart Meter Analytics

• SAP Dynamic Cash Management

• SAP Trade Promotion Management

• SAP BusinessObjectsStrategic Workforce Planning

• SAP BusinessObjects Planning and Consolidation

•  Profitability Analysis Accelerator for ERP (CO-PA)

Technical Overview

Calculation Model A calc model can be generated on the fly

based on input script or SQL/MDX

A calc model can also define a parameterized calculation schema for highly optimized reuse

A calc model supports scripted operations

Data Storage Row Store - Metadata

Column Store – 10-20x Data Compression

SAP HANA Solutions & Win Case

HANA: Industry Scenarios• Financial Services‐Hedge fund trading analysis . ‐Real-time systematic risk management and reporting based on market trading exposure

• Consumer Products‐Supplier Risk Management‐Inventory Recall Reconciliation Product track and trace

‐Product Lifecycle and Cost management‐EPA standards compliance‐On-Shelf Availability Analysis‐Real-time Warranty and defect analysis

• Retail‐Store Operations‐Point-of-Sales Retail Sales Analytics‐Load Balance Optimization‐Real-time completive multi-channel pricing‐Product damage, returns and spoilage

• Manufacturing‐O&G Operational Performance Management‐Manufacturing Production and Maintenance Analytics‐Real-time Asset Utilization Analytics

Real-time Analysis Example: Hedge Fund Analysis

SAP HANA Road Map

Today‘s System Landscape ERP System running on traditional database

BW running on traditional database

Data extracted from ERP and loaded into BW

BWA accelerates analytic models

Analytic data consumed in BI or pulled to data marts

Step 1 – In-Memory in parallel(Q4 2010) Operational data in traditional database is replicated

intomemory for operational reporting

Analytic models from production EDW can be brought into memory for agile modeling and reporting

Third party data (POS, CDR etc) can be brought into memory for agile modeling and reporting

Step 3 – New Applications (Planned for Q3 2011) New applications extend the core business suite

with new capabilities

New applications delegate data intense operations entirely to the in-memory computing

Operational data from new applications is immediately accessible for analytics – real real time

Step 2 – Primary Data Store for BW(Planned for Q3 2011) In-Memory Computing used as primary

persistence for BW

BW manages the analytic metadata and the EDW data provisioning processes

Detailed operational data replicated from applications is the basis for all processes

SAP HANA 1.5 will be able to provide the functionality of BWA

SAP HANA Road Map

Step 5 – Platform Consolidation All applications (ERP and BW) run on data

residing in-memory

Analytics and operations work on data in real time

In-memory computing executes all transactions, transformations, and complex data processing

Step 4 – Real Time Data Feed(2012/2013)Applications write data simultaneously to

traditional databases as well as the in-memory computing

SAP HANA Road Map

Competitive Overview•Optimized Hardware

– Processor: 40 Intel Cores (4 Intel® Xeon® E7-4870)– Memory: 1 Terabyte DRAM

•Software Breakthroughs– Adaptive In-Memory Caching– In-Memory Columnar Compression– Optimized Storage Block Access– Free Form Data Exploration– High Density Visualizations– Optimized for Exadata

HANA in DellDell offers this solution around SAP HANA including:•Executive Discovery Workshop•Technology Introduction / POC•Design and Implementation

Dell Confidential

Dell solution for SAP HANA includes:• Dell PowerEdge R910 server• SAP software preinstalled by Dell,

including the InMemory Computational Engine (ICE)

• Consulting services as listed below• HANA SW License from SAP

Dell SAP HANA Hardware Architecture:

Dell PowerEdge R910• 2 x Intel x7560 2.26 GHz• 256 GB RAM• 2 x Fusion-io ioDrive Duo 640GB• 14 x 146 GB 15K SAS Drives• SuSE Linux Enterprise Server 11 SP1

Thank you!