Share
Embed
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