際際滷

? 2016 SAP SE or an SAP affiliate company. All rights reserved. 1
Database Lounge Tokyo #3
HANA シ児云き
SAP ン幄塀氏芙
仟消隠再屈 ( う ) @kouji_s_0808 #dbltokyo

�A、聞い�T たSQLに捻 �g廾卆贋
�S弥 �k燕�Y創 HANA 箭火廷函識

HANAで �Y惚
MOD(3,0) ERROR
GREATEST(1,2,NULLき NULL
LどNにTHが｀あグきさ ★ 猟忖方
LどNにTHがでHARがさごきち｀Aてでグきし ★ �` 方
CURRENT_TIMESTAMP ンン �o�v�S 恷仟函誼
NULL||'ABC' NULL
かさ2しかくかじすずか 5せ9
かさ2し'+'XYZ' ERROR

噫� 、おしい

HANAにつわ脅偏�師h
あ�` あ DWH ン

あ�` あ DWH ン
そう �`う

SAP HANA In-Memory Database
Partitioning
Insert Only on Delta Compression
Row and Column Store
No aggregates
+
+
+ +
Memory
Multi-Core (Scale-Up)
Massively Parallel (Scale-Out)
Single Optimized Platform
64-bit address space
supports 2TB RAM/Node
100GB/s throughput/Node
CPU
+
SAP HANA
? �` 恷仟室�g 試喘
? ッ �`
? 恷富 IO棋 �r�g
? ン念戻ン ��夛
SAP HANA
Database
OLAP + OLTP
+
+
+
+
+
+ +
New Main(column)
Single data copy
+
Delta Main (column)
厚仟
(Write Optimized)
歌孚
(Read Optimized)
? CPU
? SIMD Vector�I尖 CPU凋綜 ��p
? TSX 坪 �` 電麿�I尖 CPU �`
? Memory
? Delta(Insert Only) 厚仟ンン �I尖 Column
Store ッ (厚仟�I尖 �Wい) 針捲
? �i 函 �R�s瘁 Column Store �i 函來嬬 �ゝ� �貧
SIMD TSX Real-time

SAP HANA Delivery Model
ン互堀來
SAP 頼畠 �`
? SAP HW �` �`
�` ン
? �` 並念
ッッ
? 並念
ン �`
? 児云議 HW 戻工
? �` �` 光コン �`
ン (OS 根 ) ン
�` 恬�I 駅勣
? �` �` 光コン �` ン
�` い
光 �` �` �{屁
悲�來
屡贋IT�Y�b コ試喘
プンス TDI
HANA Server
Bundled
Storage
DRAM
Application
Database
OS
Virtualization
Network
Storage
HANA Server
Enterprise
Storage
DRAM
Application
Database
OS
Virtualization
Network
Storage

Certified HANA Hardware Directory
http://global.sap.com/community/ebook/2014-09-02-hana-hardware/enEN/appliances.html

HANA SQL
RDBMS け�

HANA SQL
RDBMS け�
そうそけ
い

HANA 室�g議ッン
TREX
(Text Retrieval and information EXtraction)
｀9せ
ADABAS D SAP DB
｀ごし｀ごせ
｀9。
｀ごす
P*TIME
｀さご
HANA
Sybase
Column based in-memory data storage
& processing & distributed infra(no SQL,
no transaction support) And some
processing engines are supported.
(graph, search, classification, mining´)
Row based on disk SQL access data storage
& processing
Data Integration (Data Services)
HANA 1.0 SPS00
TREXMaxDB P*TIME
Sybase ASE, Sybase IQ, Sybase SQL
Anywhere, Sybase Replication Server ´
Row based in-memory SQL access data
storage & processing

SAP HANA Platform
�`タベ�`スサ�`ビス
Web Server JavaScript
Graphic
Modeler
Data Virtualization ELT &
Replication
Columnar
OLTP+OLAP
Multi-Core &
Parallelization
Advanced
Compression
Multi-tenancy Multi-Tier
Storage
Graph Predictive Search
Data
Quality
Series
Data
Business
Functions
Hadoop &
Spark Integration
Streaming
Analytics
Application Lifecycle
Management
High Availability &
Disaster Recovery
OpennessData
Modeling
Admin &
Security
Remote
Data Sync
Spatial
Text
Analytics
Fiori UX
ALM
</>
プ �`ションサ�`ビス �`タ�y栽サ�`ビスプッフ �`ムサ�`ビス
S A P H A N A P l a t f o r m

ン �` �` �`
HANA �]�k來

ン �` �` �`
HANA �]�k來
そうそうッン畠何�え
�o
あ �

In-Memory & Persistence Layer
�`シスタンスレヤ�`(喟�A晒レヤ�`)
HANA �` �` �` 砿尖ンン
砿尖 �` �r �`砿尖佩う
? �` �`
? �` Undo 隠隔 �` �I囃
? �`
? ンン (REDO) 隠隔 �` �I囃
? �` �` �筝�( ンン) 隠贋
揖豚、掲揖豚によスへ ��z
? �` ン (掲揖豚)
? �`貧 �筝� �` �` �` �� z (
300昼 �W决�� z )
? コッ (揖豚)
? ンン�_協ン �` 根ッ �`貧 �`
�` �� z
�`
�`
�` �`
�`
�` �`
ンン
(WAL) �� 竃
- Log Buffer FULL
- Commit/Rollback
協豚議徭��
�` ン
SAP HANA
UNDO DATAREDO
Log Buffer Row Store Column Store
ン
ン
ン

Persistence Storage I/O Pattern
シ Data Volume Log Volume Backup Storage
�� z ンン - WRITE
OLTP �C 古 4KB �` ン I/O
OLAP �C 寄 I/O (1 MB
貧� 辛��)
-
�` ンッッ
�`
WRITE
4 KB �C 64 MB 掲揖豚 �K双I/O ( �`
楚 �塞卆贋)
- -
DB壅軟�� ` �`
�` �`
READ
4 KB �C 64 MB 掲揖豚 �K双I/O ( �`
楚 Row Store 卆贋)
READ
256 KB 掲揖豚I/O
-
Column Store �` �` READ
4 KB �C 16 MB 掲揖豚 �K双I/O
- -
�` �` ? ッッ READ
4 KB �C 64 MB 掲揖豚I/O ( ッ �`
512 MB)
- WRITE
512 MB �` ン I/O (�O協辛嬬)
? ッッ - READ
4 KB �C 128 MB 掲揖豚I/O ( ッ �`
128 MB)
WRITE
4 KB �C 128 MB �` ン I/O
�` WRITE
4 KB �C 64 MB 掲揖豚 �K双I/O
READ
256 KB 掲揖豚I/O
READ
Data backup: 512 MB ッ �`I/O
Log backup: 128 MB ッ �`I/O

�` けそ謹
�` 鯉�{ いい�

�` けそ謹
�` 鯉�{ いい�
寄嬋健芦伉い
�F�g中(コ中) 弼？返粁戻工
い

Scale Up/Scale Out Cluster
Scale Up Server
? 2 CPU 128GB ? 20 CPU 20TB
? SoH S/4HANA BWoH �` �`
喘余 SAP HANA
? HA/DR �`
Scale Out Cluster
? �`あ２岬參貧 �` �`��撹
? �` 256GB, 512GB, 1TB, 1.5TB,
2TB, 3TB,式び4TB
? �J協�g 恷寄��撹: 94 �` @4TB/Server
(376TB)
? HA/DR �`

Dynamic Tiering
SAP HANA + Extended Table + SAP Sybase IQ + Hadoop
光ン � 伏 �` �I尖
? In-Memory Platform
? OLTP/OLAP�I尖
? 仇尖秤�� へ
蛍裂�v方
? Disk �`
? 互堀 �紳� 互い�R�s
? �` 協�x ッッ
HANA 邑�^議 �g佩辛嬬
? TB?PB ��夛晒 �` ��
�` 辛嬬
? �` 嶷�}隠隔い
? HANA �C嬬い
? �` 塘崔�� IQ �筝�
? NLS �i �z ��喘 �`
聞喘
? �` � SLA勣箔悲� ��
HANA
Hot
Dynamic Tiering
Warm
SAP Sybase IQ
Cold
? SDA Hive/Spark 俊�A
? vUDF 屡贋 MarReduce
試喘
? vUDF SQL �g佩辛嬬
Raw
Hadoop

Multistore Table
( 11/30 �` HANA 2.0 In-Memory
�` ン Disk �` ン邑�^議辛嬬
Multistore Table �` い YO!)
Partition Table
Table
Part #3
Part #1
Part #4
Part #2
In-Memory
based Column
Engine
Disk based
Column Engine
Multistore Table

互い

互い
ぎももナ$おぎ�

SAP HANA, eXpress Edition
SAP HANA, eXpress Edition
? 32GB �o�� ン �` 辛嬬 SAP Developer Center
? �J協HW音勣 �` 徭附 PC �� AWS Azure
? SCN(SAP Community Network)�U喇 �` 並念�O協�g
�` 吉淫根
? 32GB參貧駅勣 �_�k 哈 �@い嗤��
井SAP HANAへ卞佩辛嬬
http://go.sap.com/japan/developer/topics/sap-hana-express.html
Feature Scope Description
SAP HANA 乾う� SAP HANA, express edition ッン �`

Q & A
Any Question?

THANK YOU!

窒�並�
ン �` ン益芙匯違議 �u瞳圭�來 �h苧あ �秘吭房�Q
協佩う�H 登僅児�� ン �` ン SAP ン弐�s
そ麿弐�s 念戻あ
SAP ン �` ン古�h 並�I �g�F ン �` ン �
�d い �C嬬 �_�k �` �� x�� いン �`
ンび SAP �藺� び嚠協い繍栖 �_�k �筝� 辛嬬來あ SAP 昧�r
尖喇泌採 ��わ並念嚠御 �筝�
云�� 斌�I來蒙協朕議へ �m栽來掲盃墾來吉 �a幣議隠�^ 根苧幣 �a幣
��わい隠�^ 育うあ SAP 吭�躓� 嶷寄 �^払軟
咀 �p墾茅云�� `� 用鯛吉 �^払い SAP �販 �わい

際際滷

堰粥鰻粥のハナシの児云のき

More Related Content

What's hot (20)

Similar to 堰粥鰻粥のハナシの児云のき (20)

More from Koji Shinkubo (11)

堰粥鰻粥のハナシの児云のき