Hana

SAP High-Performance Analytic Appliance 1.0 (SAP HANA) A First Look At The System Architecture

Marc Bernard SAP Technology Regional Implementation Group

February 2011

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 orimplied, 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.

© 2011 SAP AG. All rights reserved. / Page 2

Agenda

1. 2. 3. 4. 5. 6.

Architecture Overview Row StoreColumn Store Persistency Layer Modeling Q&A

© 2011 SAP AG. All rights reserved. / Page 3

Architecture Overview
In-Memory Computing Engine and Surroundings
In-Memory Computing Studio Administration Modeling MS Excel Dashboard Design Clients (planned, e.g.) SAP BI4 universes (WebI,...) In-Memory Computing Engine Replication Agent Session Management Transaction Manager Authorization ManagerMetadata Manager Logger BI4 Explorer BI4 Analysis

ERP Load Controller

ERP DB

Request Processing / Execution Control SQL Parser MDX Replication Server SQL Script Calc Engine

SAP Business Objects BI4 Data Services Designer Data Services SBO BI4 Information Design Tool SBO BI4 servers ( program for client)

Relational Engines Row Store Column Store

Page Management

Persistence LayerDisk Storage
Data Volumes Log Volumes

Other Source Systems SAP NetWeaver BW 3rd Party

© 2011 SAP AG. All rights reserved. / Page 4

Architecture Overview
The Engine
IMC Studio Administration Modeling MS Excel Clients (planned, e.g.) SBOP Explorer 4.0 SBOP Analysis Xcelsius In-Memory ComputingSAP BI universes (WebI,...) Engine

Session Management
ERP Load Controller ReplicationAgent Log

Request Processing / Execution Control SQL Parser MDX SQL Script Calc Engine

Transaction Manager Authorization Manager Metadata Manager Logger

ERP DB

Replication Server
SBO Information Design Tool

Business Objects Enterprise Data Services Designer Data Services

Relational Engines Row Store Column Store

SBO server Page Management programs for clients

PersistenceLayer

Other Source Systems SAP NetWeaver BW

Disk Storage Log Volumes

Data Volumes

3rd Party

© 2011 SAP AG. All rights reserved. / Page 5

Architecture Overview
Loading Data into SAP HANA
In-Memory Computing Studio Administration Modeling MS Excel Dashboard Design Clients (planned, e.g.) SAP BI4 universes (WebI,...) In-Memory Computing Engine Replication Agent Session ManagementTransaction Manager Authorization Manager Metadata Manager Logger BI4 Explorer BI4 Analysis

ERP Load Controller

ERP DB

Request Processing / Execution Control SQL Parser MDX Replication Server SQL Script Calc Engine

Business Objects Enterprise Data Services Designer Data Services SBO Information Design Tool SBO BI4 servers ( program for client)

Relational Engines Row Store ColumnStore

Page Management

Persistence Layer

Disk Storage
Data Volumes Log Volumes

Other Source Systems SAP NetWeaver BW 3rd Party

© 2011 SAP AG. All rights reserved. / Page 6

Architecture Overview
Data Modeling
In-Memory Computing Studio Administration Modeling MS Excel Dashboard Design Clients (planned, e.g.) SAP BI4 universes (WebI,...) In-Memory Computing Engine Replication...