aws black belt online seminar - d1.awsstatic.com© 2018, amazon web services, inc. or its...

© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

0 . 38 9 1 2

AWS Black Belt Online Seminar ��


��t : A@

- 23 3

a Sr hk e W f Td k

f Td R

S -,i m osA Dw S


��

• u (t )s j nl Mca S b/. hiojgm 0 A 0 0 2 W

• y S Mdb /. hiojgmw /. hiojgm f W b

• b su v M z q prf e wf W b

• /. 3 A 18 38 82 C A /. 828 8A C1:82: 0 08:01: 0 3 8A AC19 22 0 8 022 30 2 8 /. ,CA 0 08:01: 0

0 A 0 0 2 0 828 8 0 8 8 2:C3 3 8 8A 3 2C 8A83 3 : 0A 0 A 8 0 CA0 2 0 A /. A 82 A 10A 3 2 08

8 0 8 0 C 0 83 3 : 2 0 A 8:: 1 10A 3 C 02 C0: CA/. A 82 A 0 3 0 0 A 8 0 A 83 3


��

• IB+ 4 D• 4• H A• A• H• +

Agenda


�� H

•H

• H• W

•• 5 5• D


�� 3• 6 D

W D• S•

•• H• A

•

• 3S

•


��

•W

• D•

S• A•• D

H•

•• 7 D


�

DWH��RDB

+$)�&��!�.-��&

*-,(. '

��#*&; PgSQL��

�$1,000/TB/�; �$0.314/��

S3��%.$��"!

Amazon Redshift

��

��2018�3 ��


��

L• S L/• 1

9 Q• 9 O I L 9•


�� C C

• D 2 1 C DH D 8

• CD D H

DC2 - Dense Compute

vCPU (GB) C H (�)

dc2.large 2 15 0.16TB NVMe SSD 1~32 $0.314 /1

dc2.8xlarge 32 244 2.56TB NVMe SSD 2~128 $6.095 /1

DS2 – Dense Storageds2.xlarge 4 31 2TB HDD 1~32 $1.190 /1

ds2.8xlarge 36 244 16TB HDD 2~128 $9.520 /1

� S 22018 3 0


��

1 1

1

H D

1 3


��

C O

HA 2 1

12

HA 2 1 S

S

1

H C A EW C A

C O

HA 2 1

12

HA 2 1 S

S

1

C O

HA 2 1

12

HA 2 1 S

S

1


��

��


��

2 3 1 4

. PC


.• 5 1 ( 5 1 ( C S S

Id li D c• c S ( nae 5 5

(

SS

SS

IdS

( c ()

WS

SN S

o V (EC2)DB P(RDS)nae c

5 5


$

.

.96 %Df S• 0 31 % a D S• % fh D

.96 %• ieDn s * D f• t ~ o • mz• $ R A d $

� 2018 3 C G C


��

D

QEMW

3

QEMR T

B C

3

A3

LL

22 3

QEME IS

2

GQEM I F D

Amazon Lex

Amazon PollyAmazon

Rekognition

Amazon Machine Learning

A 2

AWS Glue


1 2...

N

3

• 1 PLi C r SQq

• R S VCe q

• S d s tVL f ha q uLe

S3V

3 8

Spectrum


��

9 ,• SR B E• , QB I ACD

+1 2 + , 1


�� S 2 a A a2 3

Amazon Redshift

DC

RDBMS Amazon S3

Amazon EC20BI

�� 1,Book,100⏎2,Pen,50⏎…n,Eraser,10⏎

Web��2018-03-05 12:00:00 192.168.0.2 http://www.amazon.com2018-03-05 12:00:01 …

A VPN21

Direct Connect.

Amazon QuickSight


��

��


�� DWH��

2

DWHDWH

DWH 2

Redshift

OR OR


� ��

1 342

eH fRd T WF E

i W .Ut DD I f H

L tAHs hI

ISdA


�� o 4 C 4

4 2

P


��

U h fs GD O2 5B I IME

��• 1 CL 1 JSF• i F U g F• i e

• d g• i e JS D• 0 R Q• IMDS

•

��

0

/

CPU CPU CPU CPU CPU CPU

2 5

t


�� i 6

hd dhd N N fd OR O Mhd OR e IZ

S IZ ) t AYh E hS R t D

B hS RLBMT N KD Dh R Z 2 V )) C

Ut s OS t s

R R t sD Zh t s h PNhS R 2 11


��DCP EQ

y _s a m eutw cn o n s

z p 3LQDOJDASDC MOQ DU DCP EQ NDBQORK n v lfj

3CDLQ QUw w gt _s

6l:UQ ML m fi 02 y v:UQ ML o8RK:U B :U :ALCAPrhn n:UQ ML v 02m

t v4 8m z n n s o

_is(7. n o ) dn n o 6vQQNP, CMBP ATP AKA ML BMK IA IN ODCP EQ JAQDPQ CF O / 1 1 .61 RP

AFD QKJ


��

t

dW PQ

daS

��

t d Ad H h CL

d W PQf

t

2d aS r

D 8 ML

f Ad W eAi

R u A

M daS o

o

dW

daS

2 s BL

��


��

��

�� &��%*-• RTR L C M P EE / 9

/ 2 2 G• 2 2P C e ol

G G / G G

'(EXP

Amazon S3Direct Connect

��Glue

#�� )+$

EMR

��

��,!��"�

��

EC2

Amazon Redshift


��

4 oxz b tRuag d U f

• C8 ED 4,• 4, m O m c• GEG8 0M 3/ 08G 8, 2E G 3/ 1G8 B 3/ G G• G LB8G a 26 . fa

• 1 , z rnm c k• R rn h xz Rs c• Q e bk O z rn d k• 26O Oyous d g P pv

ua 26 d pv udgdc• 08GA B8 Wi l k z rnd O

c S c


��

W• HL 1

HB L• HB R

3• 1

L1 D D3HBL

Redshift


)( (

• 2 3• F D

3• D R 2

P D B• R 2

CA C


��

ALL

Node 1

Slice 1

Slice 2

Node 2

Slice 3

Slice 4

��

KEY(DISTKEY)

Node 1

Slice 1

Slice 2

Node 2

Slice 3

Slice 4

key1

key2

key3

key4

��

Node 1

Slice 1

Slice 2

Node 2

Slice 3

Slice 4

EVEN��

��

P3 RM


��XW• EP c

A O e

R• ia T CR c

V S•D V• 44 b• 4 33

�� DC

orders1.csv1,pencil,100,18-01-012,eraser,50,18-01-02…

:::ordersN.csv30,pen,150,18-01-2831,book,50,18-01-29…

• ��• ��

DX b

DVPN

OR


E-ink ��

“8.5G�� ”��& �,�

�+$!,�+$�",��

50TB/ 80TB10Gb % #*,�

�&��#��

�+&,(),'�,�&��

5 3AWS Snowball


��

+


��

RS S

f At• R RS WR R 7

A 3•• C P• d e

sh oeh i t


� ��

8 Ba s V 8 SPDCIm e r I

• 8 ) Dok I

• PW A) Dok r

3

• H p SP 8A I zcn r

Amazon Redshift

AmazonWorkSpaces

(VDI)

PCoIPBI Server


��

�� e

R

i d3

• 3 9f

R ee h


) (

• M 4 M FM 0 S A

• ML

• O Q W


Workload Management (WLM)

Workload Management (WLM)

1 41

�SQL SQL SQL SQL SQL

SQL


) ) (

P2 8 2 B 802 8 PA G O

2 1 U 0 0 0R C 0LO U

G O 1 400 4

4LO U U 6

4 T 84 T P


��"��!��

BI

Long Query Group

52

ShortQuery Group

3

1804∞

��


��

• R II N 4 e f

• O d

• O B h R id

https://docs.aws.amazon.com/ja_jp/redshift/latest/dg/r_enable_result_cache_for_session.html


��

4 S 5 5f

S

t

3 p d S Ss R iumr h 5

Amazon Redshift

...1 2 3 4 N

2013

ec2017 2018

2014 2015 2016


��

��


uH Idtb a U Rr

: R Rh d WT D 0/423 5 BB D7 t i T G G

T R nh g v P 7 D d D igP Gk SfoO TdUeL mB R

zl Wb (sp

A

( B AE AB

) B AE AD

s d

B C

VY sp

• +• • Te s

Wt fT+

R + HB 0/423 5


��


• t h• % P R eD 5 T i

• T9 0 s

• Hs O R

• 4 W H

D A

• % P R Ti C O R f9 d

https://classmethod.jp/download/technical-library-aws-dwh/http://www.ctc-g.co.jp/report/casestudy/videor/index.html


• 0 5LT I B

•

• - B E•• W H•


��? A 0 h jg

• B ? A A? =B D

? A 0 a l n• B ? A A? =B A ? A D

? A 0 d mj / RopuQtsN q 1SW n• B AD ? ? A A? AD ? = B AD ?-

? A 0 0 .A opu rwN• B ? A A? D A ? A 0

? A 0 Qcd in l bn b 2AB• B IB B A? =B AB B D AD? : AD ? A D ?

? A 0 1B D ? Qf em T• B ? A A? =B 5 A: 5 BD AD ? A D B D ?

1 : A:• B ? A A? =B 5 A: 5 :


��

& S W• . 5 : 3 5 : 5 /3 / 3

& / 3 & ./ - Q• & A a• . 5 : 5-5 5


8/F : A

@awscloud_jp��

545 5

. 1 1


��

S W he ca

- 5/. /- /.

: A


• -166 / 4 1/ 10 W g d p oc aQh tr

- n S W Q s pjA

: :.21 . /6 0 / 7 166 . / 4 1/ 10 / 6 4 2 5: 76• lemi• u w

aws black belt online seminar - d1.awsstatic.com© 2018, amazon web services, inc. or its...

Documents