Tweet
Tweet

Slide 1

Slide 1 text

Cygames 1 / 3 - # #

Slide 2

Slide 2 text

/ 6Amazon Redshift / 3 2 6 3 / 2 /

Slide 3

Slide 3 text

Cygames 3 2015 Cygames / 6 / iOS/Android 2017 3 /

Slide 4

Slide 4 text

4 • • 6 3 • SHADOWVERSE • C Re:Dive /

Slide 5

Slide 5 text

Slide 6

Slide 6 text

/ 3 • e DWH d • DWH 3 6 • A f 3 • R S 6 3 W / a

Slide 7

Slide 7 text

/ •Redshift3 7 • 7 6 / 7 7

Slide 8

Slide 8 text

8 D • 3 / B 6 DB(MySQL) 6 DWH(Amazon Redshift) Amazon Redshift (…) 6

Slide 9

Slide 9 text

/ I •Redshift / • 39 D • / 6 • D Amazon Redshift B3

Slide 10

Slide 10 text

• 0/ 6 10 • 0/3 10 • 3 1 0 0 1 0

Slide 11

Slide 11 text

6 • • 3 2 3 • 2 1 /

Slide 12

Slide 12 text

Amazon Redshift user_id_table( user_id varchar(16) ) 6 2 user_id_table( user_id varchar(16) ) /3 1 user_id_table( user_id varchar(16), name varchar(255) ) Amazon Redshift user_id_table( user_id varchar(16) )

Slide 13

Slide 13 text

• 3 32 3 1 32 3 •3 / 6 / 1 3

Slide 14

Slide 14 text

•( 4 Ø 6 4 ) • DB 4 ) /3 Ø 4 ( ) 1

Slide 15

Slide 15 text

Slide 16

Slide 16 text

/ • EC2 + SQS + S3 + Redshift • / / 3 1 / SQS6 • Redshift 3 6 3 S36 • / Redshift

Slide 17

Slide 17 text

/ 6 1 7 Amazon Redshift 3

Slide 18

Slide 18 text

6 •L DRedshift S R6 B • 31 3 • 6 L D E • • E 8L D / 3

Slide 19

Slide 19 text

3 6 3 Extract Load 3 1 9 3 3 1/ 1 3 3 3 3 3

Slide 20

Slide 20 text

2L 3 Q2 •Extract 2 2 + + 0/ 0 2 0/ 0 2 2 0/ 0 2 DC 2L + S 2 T E2B 2 + 6 D Q2 + D

Slide 21

Slide 21 text

6 6 •Load 2+ 6 6 2+ 6 6 S 6 6 6 6 6 D D 6 Q E6 BR 3 1/ Q B 6 B 6

Slide 22

Slide 22 text

• B S3 2Redshift / 6 DB / 2 • / 6 B 6 D 2 RENAME B / 3

Slide 23

Slide 23 text

user_action_log )( D 6/32 3 D 6/32 3 D = : )(B : D 6/32 3 2 1 6/32 3 user_action_log user_action_log_ver1

Slide 24

Slide 24 text

BR S D 4 3 2 6 / 4 3

Slide 25

Slide 25 text

/ 5 /B 5 A5R 6 26 S5 A A 5 / 2 / D A A A 5 3 /B

Slide 26

Slide 26 text

( D ( B •Redshift B S( S3 ( ) 2 / Ø 6 D ( •DB S( ( S3 Ø ( ( 2 D ( 3 Ø ( 2 S( 6 ) )

Slide 27

Slide 27 text

6 2 / 6 2 Amazon Redshift 3 7

Slide 28

Slide 28 text

2 82 3 Redshift •K 8 S3 • 2 2 2 3 / •Redshift 6 2S3

Slide 29

Slide 29 text

3/ / / Parse Load 2/63/ / 3/ / / 3/ / "Kibana is a registered trademark of Elasticsearch BV."

Slide 30

Slide 30 text

0 / •Parse 0 0 6 3 0 0 "Kibana is a registered trademark of Elasticsearch BV."

Slide 31

Slide 31 text

•Load / 1 3 6

Slide 32

Slide 32 text

2 •DB / Redshift 6 • 3 • 2 Redshift

Slide 33

Slide 33 text

/ 3 S / R 3 3 6 /df e

Slide 34

Slide 34 text

R D •R D / SeD D S3 hs Ø / D i D )( 6 Dt 4 • Sf d ØB S 46/ i B S B B 3 4

Slide 35

Slide 35 text

Slide 36

Slide 36 text

• d s h r Ø 6 f / • S i 3e Ø S s S i t e 3