AWSで始めるビッグデータ分析 Developers.IO 2017

Slide 1

Slide 1 text

"84Ͱ࢝ΊΔϏοάσʔλ෼ੳ %FWFMPQFST*0 ೥݄೔ Ϋϥεϝιουגࣜձࣾീ഼๛

Slide 2

Slide 2 text

ࣗݾ঺հ wീ഼๛ʢ:VUBLB:BXBUBʣ wϓϦηʔϧε୲౰ wݩ&31ύοέʔδͷج൫ίϯαϧ wझຯɿϚϥιϯ ࣗݾ঺հ

Slide 3

Slide 3 text

ΞδΣϯμ ͜ͷηογϣϯʹ͍ͭͯ ύΠϓϥΠϯͰߟ͑Δσʔλ෼ੳج൫ɹ σʔλ෼ੳʹޮ͘"84αʔϏε σʔλ෼ੳϦϑΝϨϯεΞʔΩςΫνϟ

Slide 4

Slide 4 text

͜ͷηογϣϯʹ͍ͭͯ ύΠϓϥΠϯͰߟ͑Δσʔλ෼ੳج൫ɹ σʔλ෼ੳʹޮ͘"84αʔϏε σʔλ෼ੳϦϑΝϨϯεΞʔΩςΫνϟ

Slide 5

Slide 5 text

ηογϣϯͷର৅ऀ w"84Ͱσʔλ෼ੳΛ࢝Ί͍ͨ  ʜԿ͔Β࢝ΊͨΒΑ͍͔Θ͔Βͳ͍ w"84Ͱσʔλ෼ੳج൫Λߏங͢ΔͨΊͷ  ϕετϓϥΫςΟεΛ஌Γ͍ͨ w"84ͷར༻ܦݧ͕͋Δ 71$ &$ 3%4 4 FUD

Slide 6

Slide 6 text

͜ͷηογϣϯͰ͓࿩͠͠ͳ͍͜ͱ wͳͥ"84͔ʁ w֤"84αʔϏεͷৄࡉͳػೳ΍εϖοΫ wσʔλ෼ੳϓϩδΣΫτͷਐΊํ wػցֶशɺ"*

Slide 7

Slide 7 text

͜ͷηογϣϯʹ͍ͭͯ ύΠϓϥΠϯͰߟ͑Δσʔλ෼ੳج൫ɹ σʔλ෼ੳʹޮ͘"84αʔϏε σʔλ෼ੳϦϑΝϨϯεΞʔΩςΫνϟ

Slide 8

Slide 8 text

༷ʑͳϏοάσʔλ ɨ 104σʔλ ϞόΠϧΞϓϦ ߦಈϩά ΫϦοΫ  ετϦʔϜ  4/4 ηϯλʔσʔλ  ɓ

Slide 9

Slide 9 text

σʔλ෼ੳͰར༻Ͱ͖Δ"84αʔϏε Amazon  DynamoDB Amazon  RDS Amazon   Redshift Amazon  S3 AWS Snowball AWS Lambda AWS Batch Amazon EC2 AWS DMS Amazon ES Amazon EMR Amazon Kinesis Amazon  Athena Amazon CloudSearch Amazon QuickSight AWS Data Pipeline Amazon Machine Learning AWS IoT ଟछଟ༷ͳαʔϏε܈ σʔλҠߦ σʔλϕʔε ετϨʔδ ෼ੳ ݕࡧ *P5 ίϯϐϡʔςΟϯά ػցֶश

Slide 10

Slide 10 text

ͲͷαʔϏεΛ࢖͏΂͖͔ʁ 3FETIJGU࢖ͬͨํ͕Α͍ʁ3%4Ͱ΋େৎ෉ʁ Ͳ͏΍ͬͯ"84ʹσʔλΛΞϓϩʔυ͢Δʁ ,JOFTJTͱ໊ͷ෇͘αʔϏε͕ͭ΋ɺɺɺ

Slide 11

Slide 11 text

σʔλ෼ੳΞʔΩςΫνϟͷݪଇ wσʔλ෼ੳΛύΠϓϥΠϯͰߟ͑Δ w ऩूɺલॲཧɺอଘɺ෼ੳɺՄࢹԽ w"84ͷ֤αʔϏε͕Կʹ࠷దԽ͞Ε͍ͯΔ͔ʁ·ͨ  ࠷దԽ͞Εͨ݁ՌͷτϨʔυΦϑ͸Կ͔ʁΛཧղ͢Δ w εϧʔϓοτɺϨΠςϯγʔɺεέʔϥϏϦςΟɺ  ѻ͑ΔσʔλλΠϓʗσʔλߏ଄ɺΧελϚΠζੑɺ  ্ݶ஋ɺίετ w֤αʔϏεͷಛ௃Λཧղ্ͨ͠ͰɺύΠϓϥΠϯ্ͷ  ͦΕͧΕͷδϣϒʹ࠷దͳαʔϏεΛબ୒͢Δ

Slide 12

Slide 12 text

ϏοάσʔλύΠϓϥΠϯ લॲཧ ऩू อଘ ෼ੳ ՄࢹԽ | 

Slide 13

Slide 13 text

ϏοάσʔλύΠϓϥΠϯऩू લॲཧ ऩू อଘ ෼ੳ ՄࢹԽ | 

Slide 14

Slide 14 text

ऩू ϑΝΠϧ ετϦʔϜ w ച্σʔλ w ސ٬Ϛελ w ঎඼Ϛελ w ߦಈϩά w ΫϦοΫετϦʔϜ w *P5ηϯαʔσʔλ ɏ σʔλλΠϓʹண໨ AWS IoT Amazon S3 Amazon Kinesis Streams Amazon Kinesis Firehose … … …

Slide 15

Slide 15 text

ूΊͨσʔλ͸4ʹू໿ Amazon S3 Amazon EC2 AWS Aurora Amazon Redshift AWS Lambda Amazon ES Amazon EMR Amazon CloudSearch Amazon QuickSight Amazon Athena AWS IoT Amazon Kinesis Streams Amazon Kinesis Firehose AWS DMS AWS Batch AWS DynamoDB AWS Lambda AWS Data Pipeline

Slide 16

Slide 16 text

ϏοάσʔλύΠϓϥΠϯલॲཧ લॲཧ ऩू อଘ ෼ੳ ՄࢹԽ | 

Slide 17

Slide 17 text

લॲཧ ϦΞϧλΠϜ όον w ࣌ؒຖɺ೔࣍ɺि࣍ɺ w εϧʔϓοτॏࢹ w ஞ࣍ॲཧ w ϨΠςϯγʔॏࢹ Amazon EMR Amazon EC2 AWS Lambda Amazon Kinesis Analytics ɏ ϫʔΫϩʔυʹண໨ ƽ

Slide 18

Slide 18 text

ϏοάσʔλύΠϓϥΠϯ෼ੳɾอଘ લॲཧ ऩू อଘ ෼ੳ ՄࢹԽ | 

Slide 19

Slide 19 text

อଘɾ෼ੳ σʔλߏ଄ ΞΫηεύλʔϯ อଘ ෼ੳ ݻఆ͞ΕͨεΩʔϚ ෳࡶͳϦϨʔγϣφϧΫΤϦɺ ଟ਺ͷϢʔβʔ͔Βͷಉ࣌ΞΫηε 3%4 େن໛σʔλͷूܭɾநग़ 3FETIJGU 4 3FETIJGU4QFDUSVN εΩʔϚϨε γϯϓϧͳΫΤϦɺ௿͍ϨΠςϯγʔ %ZOBNP%# ੜσʔλʹର͢ΔΞυϗοΫ෼ੳ 4 &.3  1SFTUP *NQBMB 4QBSL "UIFOB "UIFOB શจݕࡧ &MBTUJD4FBSDI4FSWJDF $MPVE4FBSDI ɏ σʔλߏ଄ɺΞΫηεύλʔϯʹண໨

Slide 20

Slide 20 text

ϏοάσʔλύΠϓϥΠϯՄࢹԽ લॲཧ ऩू อଘ ෼ੳ ՄࢹԽ | 

Slide 21

Slide 21 text

ՄࢹԽ ఏڙํ๏ ՄࢹԽπʔϧ ηϧϑ#* "NB[PO2VJDL4JHIU ఆܕϨϙʔτ ΧελϜ8FCΞϓϦέʔγϣϯ w %ZOBNP%#-BNCEB"1*(BUFXBZ4 w 3%4&$  ϩά෼ੳͷμογϡϘʔυ "NB[PO&MBTUJD4FBSDI4FSWJDF ,JCBOB ɏ σʔλͷఏڙํ๏ʹண໨͢Δ w "84αʔϏεͷબ୒ࢶ͸গͳ͍αʔυύʔςΟ੡ͷ  πʔϧ΋ݕ౼ ǟ ǟ

Slide 22

Slide 22 text

͜ͷηογϣϯʹ͍ͭͯ ύΠϓϥΠϯͰߟ͑Δσʔλ෼ੳج൫ɹ σʔλ෼ੳʹޮ͘"84αʔϏε σʔλ෼ੳϦϑΝϨϯεΞʔΩςΫνϟ

Slide 23

Slide 23 text

σʔλ෼ੳʹޮ͘"84αʔϏε Amazon S3 Amazon EC2 AWS Aurora Amazon Redshift AWS Lambda Amazon ES Amazon EMR Amazon CloudSearch Amazon QuickSight Amazon Athena AWS IoT Amazon Kinesis Streams Amazon Kinesis Firehose AWS DMS AWS Batch AWS DynamoDB AWS Lambda AWS Data Pipeline ओཁͳαʔϏε ಠஅͱภݟ   ͭΛ͝঺հ

Slide 24

Slide 24 text

"NB[PO3FETIJGU w%8)ಛԽͷߴ଎3%# w.11ɺγΣΞʔυφογϯά  ˠεέʔϧΞ΢τͰ͖Δ w1PTUHSF42-ޓ׵ͷ42-͕࢖͑Δ ϊʔυ ϊʔυ ϊʔυ ϊʔυ 42- Amazon  Redshift

Slide 25

Slide 25 text

3FETIJGUͷύϑΥʔϚϯενϡʔχϯά ✦ "NB[PO3FETIJGUςʔϒϧઃܭৄࡉΨΠυ  r෼ࢄελΠϧͱιʔτΩʔͷܾఆํ๏r w IUUQTEBXTTUBUJDDPNFWFOUTKQTVNNJUTMJEF%5QEG w IUUQTXXXZPVUVCFDPNXBUDI W0:-7E9509H wύϑΥʔϚϯεΛҾ͖ग़͢ʹ͸ςʔϒϧઃܭ͕ॏཁ w ෼ࢄΩʔ w ιʔτΩʔ w ѹॖλΠϓ

Slide 26

Slide 26 text

"NB[PO3FETIJGUՁ֨ ϊʔυλΠϓ W$16਺ ϝϞϦ༰ྔ ετϨʔδ༰ྔ ϊʔυ਺ Ձ֨  ϊʔυʗ࣌ؒ *0ੑೳॏࢹ  44%λΠϓ EDMBSHF (J# 5# ʙ EDYMBSHF (J# 5# ʙ ετϨʔδ༰ྔॏࢹ  )%%λΠϓ ETYMBSHF (J# 5# ʙ ETYMBSHF (J# 5# ʙ ˞Ձ֨͸͢΂ͯ౦ژϦʔδϣϯɺ೥݄೔࣌఺ͷ΋ͷͰ͢ɻ wϊʔυλΠϓຖʹετϨʔδ༰ྔ͕ܾ·͍ͬͯΔ wΫϥελʔͷෳ੡ɺϊʔυλΠϓ΍ϊʔυ਺ͷมߋ͸ൺֱత༰қ  ˠੑೳݕূΛߦͬͯϊʔυλΠϓΛܾఆ͢Δ

Slide 27

Slide 27 text

"NB[PO3FETIJGU4QFDUSVN Amazon S3 w 3FETIJGU͔Β4্ͷϑΝΠϧʹ௚઀ΫΤϦͰ͖Δ  σʔλϩʔυෆཁ w ༷ʑͳϑΝΠϧϑΥʔϚοτʹରԠ  $47ɺ547ɺ1BSRVFU౳ʣ w ΞΫηεස౓͕௿͍σʔλΛ4΁Φϑϩʔυ  ˠίετ࡟ݮ w ΫΤϦ୯Ґͷैྔ՝ۚ  εΩϟϯ͞Εͨσʔλ5#͋ͨΓ 4QFDUSVN૚ $47 547   1BSRVFU FUD 3FETIJGU্ͷςʔϒϧͱ δϣΠϯͰ͖Δ SQL

Slide 28

Slide 28 text

"NB[PO4QFDUSVNར༻্ͷ஫ҙ఺ w֎෦දʹର͢Δ4&-&$5ͷΈՄ ߋ৽͸຤αϙʔτ w+40/ʹ͸ରԠ͍ͯ͠ͳ͍ wόʔδχΞ๺෦ɺΦϨΰϯɺΦϋΠΦϦʔδϣϯͰͷΈ  ར༻Մೳ ˞͍ͣΕ΋೥݄೔࣌఺ͷ৘ใͰ͢ɻ

Slide 29

Slide 29 text

"NB[PO&.3 wϚωʔδυ)BEPPQΫϥελʔ w ਺෼ͰΫϥελʔΛىಈ w δϣϒऴྃ࣌ʹΫϥελʔΛ࡟আ w)JWFɺ4QBSLɺ1SFTUPͳͲͷ  ෼ࢄॲཧΞϓϦέʔγϣϯΛ࣮ߦ wσʔλετΞͱͯ͠4͕࢖͑Δ w%ZOBNP%#΍,JOFTJT4USFBNT  ͷσʔλʹ΋௚઀ΞΫηεͰ͖Δ Amazon EMR  Cluster   JOQVU Amazon  DynamoDB Amazon S3 Amazon Kinesis Streams   PVUQVU

Slide 30

Slide 30 text

3FETIJGUͱ&.3 )BEPPQ wڞ௨ɿ෼ࢄॲཧɺεέʔϧΞ΢τͰ͖Δ wߏ଄Խσʔλɿ3FETIJGU wඇߏ଄Խɺ൒ߏ଄Խσʔλɿ&.3 )BEPPQ w%8)༻్Ͱ͋Ε͹ӡ༻ɺ҆ఆੑɺίετͷ؍఺Ͱ  3FETIJGUͷར༻Λਪ঑ wΑ͋͘Δύλʔϯɿ  &.3 )BEPPQ Ͱඇߏ଄Խʗ൒ߏ଄ԽσʔλΛ  ߏ଄Խσʔλ΁ม׵͠3FETIJGU΁ϩʔυ

Slide 31

Slide 31 text

"NB[PO"UIFOB Amazon S3 w Ϛωʔδυ1SFTUP w αʔόʔϨε w 4্ͷϑΝΠϧʹ௚઀ΫΤϦͰ͖Δ w ༷ʑͳϑΝΠϧϑΥʔϚοτΛαϙʔτ  $47ɺ547ɺ1BSRVFUɺ+40/ɺ"WSP౳ʣ w ΫΤϦ୯Ґͷैྔ՝ۚ  εΩϟϯ͞Εͨσʔλ5#͋ͨΓ Amazon Athena SQL

Slide 32

Slide 32 text

"NB[PO"UIFOBར༻্ͷ஫ҙ఺ wΫΤϦ͸෼ͰλΠϜΞ΢τ w4&-&$5*/4&35ʹ͸ະରԠ wϦτϥΠػߏ͕ͳ͍ wόονॲཧʹ͸޲͔ͳ͍  (޲͔͍ͳ͍͚ͩͰͰ͖ͳ͘͸ͳ͍) wΞυϗοΫΫΤϦ޲͚ 

Slide 33

Slide 33 text

"NB[PO,JOFTJT4USFBNT wετϦʔϜσʔλͷऩूͱอଘ w อଘظؒ͸࣌ؒʙ࠷େ೔ؒ wϦΞϧλΠϜॲཧ w σʔλͷೖྗ͔Βऔಘ·Ͱͷ஗Ԇ͸௨ৗඵະຬ wߴ͍εέʔϥϏϦςΟ w εϧʔϓοτ΍σʔλྔʹԠͯ͡εέʔϧΠϯʗΞ΢τՄೳ γϟʔυͷ෼ׂɺ౷߹ Amazon Kinesis Streams AWS Lambda Amazon EMR Amazon Kinesis–  enabled app Amazon Redshift Amazon DynamoDB Amazon S3 Put Put Get Get Get AWS IoT Put

Slide 34

Slide 34 text

"NB[PO,JOFTJT'JSFIPTF wετϦʔϜσʔλͷऩूͱ഑৴ wϓϩάϥϜ։ൃෆཁɺઃఆͷΈͰ4ɺ3FETIJGUɺ&MBTUJD4FBSDI4FSWJDF  ʹσʔλΛ഑৴Ͱ͖Δ ஗Ԇ͸࠷୹Ͱඵʙ࠷େඵ wεϧʔϓοτʹԠͯࣗ͡ಈεέʔϧ wετϦʔϜσʔλʹରͯ͠"84-BNCEBΛ࣮ߦͰ͖Δ  σʔλม׵ॲཧͳͲ Amazon Kinesis Firehose Amazon ES Amazon S3 AWS IoT Amazon Redshift Delivery Put Put Put Delivery Delivery AWS Lambda

Slide 35

Slide 35 text

"NB[PO,JOFTJT"OBMZUJDT Amazon Kinesis Streams AWS IoT Put Put Put Amazon Kinesis Analytics w ετϦʔϜσʔλʹରͯ͠42-ΫΤϦΛ࣮ߦͰ͖Δ w ,JOFTJT4USFBNT'JSFIPTF͔Β*OQVUˠ,JOFTJT4USFBNT'JSFIPTFʹ0VUQVU w εϧʔϓοτʹԠͯࣗ͡ಈεέʔϧ Amazon Kinesis Firehose Amazon Redshift SQL

Slide 36

Slide 36 text

,JOFTJT4USFBNTͱ'JSFIPTFͷൺֱ ػೳ ϨΠςϯγʔ σʔλͷॲཧ εέʔϧΞ΢τʗΠϯ ౦ژϦʔδϣϯͰͷ  ར༻Մ൱ ,JOFTJT  4USFBNT ετϦʔϜσʔλͷ  ऩूͱอଘ ໿ඵ ΧελϜ  ΞϓϦέʔγϣϯ ϢʔβʔଆͰ  ίϯτϩʔϧ Մ ,JOFTJT  'JSFIPTF ετϦʔϜσʔλͷ  ऩूͱ഑৴ ࠷୹ඵ 4ɺ3FETIJGUɺ  &MBTUJD4FBSDI 4FSWJDFʹࣗಈ഑৴ ࣗಈ ൱  όʔδχΞɺΦϨΰϯɺ  ΞΠϧϥϯυͷΈ w·ͣ͸,JOFTJT'JSFIPTFΛݕ౼ wϨΠςϯγʔɺσʔλॲཧύλʔϯͰ൑அͯ͠  ,JOFTJT'JSFIPTFͰࣄ଍Γͳ͍৔߹͸,JOFTJT4USFBNTΛར༻

Slide 37

Slide 37 text

,JOFTJTͷՁ֨ Kinesis Streams ߲໨ ྉۚ ౦ژϦʔδϣϯ γϟʔυ࣌ؒ  .#ඵͷσʔλೖྗͱ.#ඵͷσʔλग़ྗ 165ϖΠϩʔυϢχοτ ,#   Ϣχοτ͝ͱ ֦ுσʔλอ࣋ظݶ ࠷େ೔ؒ ɺγϟʔυ࣌ؒ͝ͱ ˞Ձ֨͸͢΂ͯ೥݄೔࣌఺ͷ΋ͷͰ͢ɻ Kinesis Firehose ߲໨ ྉۚ όʔδχΞϦʔδϣϯ औΓࠐ·Εͨσʔλྔ(#͋ͨΓ ʙ  ˞5JFSྉۚ Kinesis Analytics ߲໨ ྉۚ όʔδχΞϦʔδϣϯ ,16 ,JOFTJT1SPDFTTJOH6OJU ɺ࣌ؒ͋ͨΓ   ˞5JFSྉۚ

Slide 38

Slide 38 text

"NB[PO2VJDL4JHIU w Ϛωʔδυ#*αʔϏε w "84಺֎ͷσʔλιʔεʹ઀ଓͰ͖Δ w 41*$& ΠϯϝϞϦॲཧʹ࠷దԽ͞Εͨߴ଎σʔλϕʔε ʹ  σʔλΛऔΓࠐΉ͜ͱͰߴ଎ͳ෼ੳ͕Ͱ͖Δ Amazon QuickSight

Slide 39

Slide 39 text

2VJDL4JHIUՁ֨ ແྉ࿮ ແྉ࿮  Ϣʔβʔ 4UBOEBSE&EJUJPO &OUFSQSJTF&EJUJPO αϒεΫϦϓγϣϯ /" ೥ؒ ݄ؒ ೥ؒ ݄ؒ Ϣʔβʔʗ݄ όϯυϧ͞Εͨ  41*$&༰ྔ (# (# (# (# (# ௥Ճͷ41*$&༰ྔ  (#͋ͨΓʗ݄ (# ˞Ձ֨͸೥݄೔࣌఺ͷ΋ͷͰ͢ɻ w Ϣʔβʔ୯Ґͷ՝ۚͱɺར༻͢ΔετϨʔδ 41*$& ༰ྔʹର͢Δ՝ۚ w &OUFSQSJTF&EJUJPOɿ  "%࿈ܞɺ҉߸Խɺ4".-ϕʔεͷϑΣσϨʔςου440Λαϙʔτ  ࠓޙػೳ͕௥Ճ͞ΕΔ༧ఆ

Slide 40

Slide 40 text

͜ͷηογϣϯʹ͍ͭͯ ύΠϓϥΠϯͰߟ͑Δσʔλ෼ੳج൫ɹ σʔλ෼ੳʹޮ͘"84αʔϏε σʔλ෼ੳϦϑΝϨϯεΞʔΩςΫνϟ

Slide 41

Slide 41 text

ϦϑΝϨϯεΞʔΩςΫνϟ wǡ ച্෼ੳ wΦϯϓϨϛεͷ%#ʹ͋Δച্σʔλ wҎԼͷ෼ੳ؀ڥΛఏڙ wੜσʔλʹର͢ΔΞυϗοΫ෼ੳ wηϧϑ#* wఆܕϨϙʔτ

Slide 42

Slide 42 text

ച্෼ੳσʔλऩू ੜσʔλ σʔλ͸4ʹू໿ σʔλΞοϓϩʔυ Internet ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ)

Slide 43

Slide 43 text

ച্෼ੳੜσʔλͷΞυϗοΫ෼ੳ Amazon  Athena Amazon  EMR ੜσʔλ σʔλΞοϓϩʔυ ΞυϗοΫ෼ੳ "UIFOBɺ&.3Ͱ  ΞυϗοΫ෼ੳ ǟ Internet ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ)

Slide 44

Slide 44 text

ച্෼ੳσʔλม׵ɺ੔ܗ Amazon  Athena Amazon  EMR ੜσʔλ Ճ޻ࡁΈσʔλ Amazon  EMR σʔλΞοϓϩʔυ ΞυϗοΫ෼ੳ σʔλม׵ɺ੔ܗ &.3Ͱσʔλม׵ɺ੔ܗ ؆қͳॲཧͰ͋Ε͹&$Ͱࡁ·ͤΔ͜ͱ΋ ǟ Internet ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ)

Slide 45

Slide 45 text

ച্෼ੳ3FETIJGU΁औࠐΈ Amazon  Athena Amazon  EMR ੜσʔλ Ճ޻ࡁΈσʔλ Amazon Redshift όοναʔόʔ Amazon  EMR σʔλϩʔυ ίϚϯυ࣮ߦ σʔλΞοϓϩʔυ ΞυϗοΫ෼ੳ σʔλม׵ɺ੔ܗ όοναʔόʔͰ  $01:ίϚϯυΛ࣮ߦ ǟ Internet ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ)

Slide 46

Slide 46 text

ച্෼ੳ3FETIJGU΁औࠐΈ Amazon  Athena Amazon  EMR ੜσʔλ Ճ޻ࡁΈσʔλ Amazon Redshift όοναʔόʔ Amazon  EMR σʔλϩʔυ ίϚϯυ࣮ߦ σʔλΞοϓϩʔυ ΞυϗοΫ෼ੳ σʔλม׵ɺ੔ܗ σΟϝϯγϣϯ ςʔϒϧ͸ 3FETIJGU΁ 4QFDUSVN ϑΝΫτςʔϒϧ͸4ʹɻ 4QFDUSVNͰΞΫηε ǟ Internet ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ) Redshift Spectrum͕౦ژϦʔδϣϯͰ࢖͑ΔΑ͏ʹͳͬͨΒɺɺɺ  (·ͨ͸όʔδχΞʗΦϨΰϯϦʔδϣϯͰ෼ੳج൫Λߏங͢ΔͳΒɺɺɺ)

Slide 47

Slide 47 text

ച্෼ੳ#*πʔϧͰ෼ੳɺՄࢹԽ Amazon  Athena Amazon  EMR ੜσʔλ Ճ޻ࡁΈσʔλ Amazon QuickSight Amazon Redshift όοναʔόʔ Amazon  EMR σʔλϩʔυ ίϚϯυ࣮ߦ σʔλΞοϓϩʔυ ΞυϗοΫ෼ੳ σʔλม׵ɺ੔ܗ 4QFDUSVN 2VJDL4JHIUͰՄࢹԽɻ ͦͷଞ#*πʔϧ΋࢖༻Մೳ ՄࢹԽ ǟ Internet ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ) (όʔδχΞ or ΦϨΰϯ)

Slide 48

Slide 48 text

ച্෼ੳϨϙʔτఏڙ Amazon  Athena Amazon  EMR ੜσʔλ Ճ޻ࡁΈσʔλ Amazon Redshift όοναʔόʔ Amazon  EMR 4QFDUSVN Amazon RDS for PostgreSQL dblink NBUFSJBMJ[FEWJFX   Ϩϙʔτදࣔ  αʔόʔ ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ) σʔλϩʔυ ίϚϯυ࣮ߦ σʔλΞοϓϩʔυ ΞυϗοΫ෼ੳ σʔλม׵ɺ੔ܗ ϨϙʔτӾཡऀ (100ਓʙ) Amazon QuickSight ǟ ՄࢹԽ Internet Internet (όʔδχΞ or ΦϨΰϯ) σʔλϚʔτΛ3%4ʹอଘ͠ɺ ϨϙʔτӾཡऀʹ։์

Slide 49

Slide 49 text

ച্෼ੳશମ૾ Amazon  Athena Amazon  EMR ੜσʔλ Ճ޻ࡁΈσʔλ Amazon Redshift όοναʔόʔ Amazon  EMR 4QFDUSVN Amazon RDS for PostgreSQL dblink NBUFSJBMJ[FEWJFX   Ϩϙʔτදࣔ  αʔόʔ Internet σʔλϩʔυ ίϚϯυ࣮ߦ σʔλΞοϓϩʔυ Internet ΞυϗοΫ෼ੳ σʔλม׵ɺ੔ܗ Amazon QuickSight ǟ ϨϙʔτӾཡऀ (100ਓʙ) ՄࢹԽ ෼ੳ୲౰ऀ (਺ਓʙे਺ਓ) (όʔδχΞ or ΦϨΰϯ)

Slide 50

Slide 50 text

ϦϑΝϨϯεΞʔΩςΫνϟ w ϩά෼ੳ w8FCΞϓϦέʔγϣϯͷߦಈϩάͱΞΫηεϩά wߦಈϩά͸#*πʔϧͰ෼ੳ wΞΫηεϩά͸ɺ wϦΞϧλΠϜμογϡϘʔυͰՄࢹԽ wಛఆͷ͖͍͠஋Λ௒͑ͨ΋ͷΛνϟοτʹ௨஌

Slide 51

Slide 51 text

ϩά෼ੳσʔλऩू Amazon Kinesis Firehose ߦಈϩά ෼ੳ୲౰ऀ ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ ,JOFTJT'JSFIPTF΁  ϩάσʔλΛ1VU Web/App  αʔόʔ

Slide 52

Slide 52 text

ϩά෼ੳ3FETIJGUͱ4΁഑৴ ੜσʔλ Amazon Redshift Web/App  αʔόʔ Amazon Kinesis Firehose Lambda function ߦಈϩά ෼ੳ୲౰ऀ ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ ϩάσʔλΛ 3FETIJGUͱ4ʹ഑৴

Slide 53

Slide 53 text

ϩά෼ੳ#*πʔϧͰ෼ੳɺՄࢹԽ ੜσʔλ Amazon Redshift Amazon QuickSight Amazon Kinesis Firehose Lambda function ߦಈϩά ෼ੳ୲౰ऀ Internet ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ 2VJDL4JHIUͰՄࢹԽɻ ͦͷଞ#*πʔϧ΋࢖༻Մೳ Web/App  αʔόʔ

Slide 54

Slide 54 text

ϩά෼ੳੜσʔλͷΞυϗοΫ෼ੳ Amazon  Athena ੜσʔλ Amazon Redshift Amazon QuickSight Amazon Kinesis Firehose Lambda function ߦಈཤྺ ෼ੳ୲౰ऀ Internet ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ "UIFOBͰ  ΞυϗοΫ෼ੳ Web/App  αʔόʔ

Slide 55

Slide 55 text

ϩά෼ੳσʔλऩू Amazon  Athena ੜσʔλ Amazon Redshift Amazon QuickSight Amazon Kinesis Firehose Lambda function ߦಈϩά ΞΫηεϩά Amazon Kinesis Firehose Lambda function ෼ੳ୲౰ऀ γεςϜ  ؅ཧऀ Internet ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ ,JOFTJT'JSFIPTF΁  ϩάσʔλΛ1VU Web/App  αʔόʔ

Slide 56

Slide 56 text

ϩά෼ੳ&MBTUJD4FBSDIͰՄࢹԽ Amazon  Athena ߦಈϩά  ੜσʔλ Amazon Redshift Amazon QuickSight Amazon Kinesis Firehose Amazon ES Lambda function ߦಈϩά ΞΫηεϩά Amazon Kinesis Firehose ſ Lambda function ෼ੳ୲౰ऀ γεςϜ  ؅ཧऀ ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ Internet Internet ϩάσʔλΛ  &MBTUJD4FBSDI4FSWJDFʹ഑৴ɻ  ,JCBOBͰՄࢹԽ Web/App  αʔόʔ ΞΫηεϩά ੜσʔλ ੜσʔλ͸4ʹอଘ͓ͯ͘͠

Slide 57

Slide 57 text

ϩά෼ੳϦΞϧλΠϜ௨஌ Amazon  Athena ੜσʔλ Amazon Redshift Amazon QuickSight Amazon Kinesis Streams Amazon Kinesis Analytics Amazon Kinesis Firehose Amazon ES Lambda function ߦಈϩά ΞΫηεϩά Amazon Kinesis Firehose ſ Lambda function Lambda function ෼ੳ୲౰ऀ γεςϜ  ؅ཧऀ ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ Internet Internet ,JOFTJT4USFBNTͷΠϕϯττϦΨʔͰ  -BNCEBϑΝϯΫγϣϯΛ࣮ߦ͠  νϟοτʹ௨஌ Web/App  αʔόʔ ΞΫηεϩά ੜσʔλ ,JOFTJT"OBMZUJDTͰ  σʔλநग़ˍ,JOFTJT4USFBNTʹ഑৴

Slide 58

Slide 58 text

ϩά෼ੳશମ૾ Amazon  Athena Amazon Redshift Amazon QuickSight Amazon Kinesis Streams Amazon Kinesis Analytics Amazon Kinesis Firehose Amazon ES Lambda function ߦಈϩά ΞΫηεϩά Amazon Kinesis Firehose ſ Lambda function Lambda function ෼ੳ୲౰ऀ γεςϜ  ؅ཧऀ ౦ژϦʔδϣϯ όʔδχΞ or ΦϨΰϯϦʔδϣϯ Internet Internet Web/App  αʔόʔ ΞΫηεϩά ੜσʔλ ߦಈϩά  ੜσʔλ

Slide 59

Slide 59 text

·ͱΊ wσʔλ෼ੳΛύΠϓϥΠϯͰߟ͑Δ w ऩूɺલॲཧɺอଘɺ෼ੳɺՄࢹԽ w"84ͷ֤αʔϏε͕Կʹ࠷దԽ͞Ε͍ͯΔ͔ʁ·ͨ  ࠷దԽ͞Εͨ݁ՌͷτϨʔυΦϑ͸Կ͔ʁΛཧղ͢Δ w εϧʔϓοτɺϨΠςϯγʔɺεέʔϥϏϦςΟɺ  ѻ͑ΔσʔλλΠϓɺΧελϚΠζੑɺ্ݶ஋ɺ  ίετ w֤αʔϏεͷಛ௃Λཧղ্ͨ͠ͰɺύΠϓϥΠϯ্ͷ  ͦΕͧΕͷδϣϒʹ࠷దͳαʔϏεΛબ୒͢Δ

Slide 60

Slide 60 text

͍͞͝ʹ w"84͸4ɺ"UIFOBɺ,JOFTJTɺ-BNCEBɺ 2VJDL4JHIUͳͲɺαʔόʔϨεͰ͙͢ʹˍ҆Ձʹ࢖͑Δ  αʔϏε΋ॆ࣮ "84ͰϏοάσʔλ෼ੳΛ  ࢝Ί·͠ΐ͏ʂ