ADエンジニアがみたre:Invent 2018

re:Invent 2018に参加したレポートです。本発表ではQLDB, Timestreamの広告システムへの適用について話しました。

https://ichigayageek.connpass.com/event/111436/

Transcript

1. "%ΤϯδχΞ͕Έͨ
   SF*OWFOU
    TV[VLFO ࢢϲ୩(FFL˒/JHIU
   
2. ࢲʹ͍ͭͯ ͚ͣ͢Μ
   HJUIVCDPNTV[VLFO
   !TV[V@W
   qVDU
   441
   IUUQTqVDUKQ
   Λ࡞͍ͬͯ·͢
   BKJUPGN
   ͱ͍͏ϙουΩϟετΛ΍͍ͬͯ·͢
3. ౎಺๭ॴޕޙ࣌
4. "%ΤϯδχΞ͔Βݟͨ SF*OWFOU
    w ࣄྫ঺հ
   "%5-ʢ޿ࠂܥͷϦʔμʔγοϓηογϣ ϯʣ
   
   w "%ؔ࿈γεςϜͷΞʔΩςΫνϟͰ࢖͑ͦ͏ͳSF*OWFOU
   Ͱͷ6QEBUFΛͭ঺հ͠·͢
5. Έͳ͞Μ؂ࠪϩάͬͯ Ͳ͏อଘ͞Εͯ·͔͢ʁ
6. ؂ࠪϩάཁ݅ w ͞·͟·ͳߦಈɺࣄ৅ʹؔ͢ΔσʔλΛ࣮֬ʹه࿥͢Δ
   w τϨʔαϏϦςΟΛ୲อ͢Δ
   w ফ͑ͳ͍ Α͋͘Δύλʔϯ
   
   3%#ʹ؂ࠪ༻ςʔϒϧΛͭ͘Γʢ೔࣌ɺૢ࡞ର৅ɺૢ࡞಺༰ʣΛ͍Ε͓ͯ͘
   
   ΫΤϦ͕ͭΒ͍ɺ؂ࠪϩάͷվ᜵Λ๷͙ͨΊͷݖݶઃఆ͕ඞཁ
7. "NB[PO
   2VBOUVN
   -FEHFS
   %BUBCBTF
   2-%# w ϑϧϚωʔδυͳ୆ாσʔλϕʔε
   w ҉߸Խ͞Εɺཤྺ͕อূ͞Εɺ͔ͭJNNVUBCMFͳσʔλ ͱͯ͠อ࣋Ͱ͖Δɻߋ৽΋࡟আ΋Ͱ͖ͳ͍ɻ
   w 42-MJLFͳ"1*
   
   τϥϯβΫγϣϯαϙʔτ 
   4P3
   4ZTUFNPG3FDPSE
   ͳΞϓϦέʔγϣϯʹ߹͏
8. IUUQTTQFBLFSEFDLDPNOBPZBTZTUFNPGSFDPSE UPTZTUFNPGFOHBHFNFOU TMJEF
   
9. ޿ࠂӡ༻ͰͷBVEJUBCJMJUZͱ
   ΞΠσΞ w طଘΞϓϦέʔγϣϯ
   
   2-%#Ͱ༰қʹ࣮ݱɻ͍ΘΏΔ؂ࠪϩάɻ
   w ୭͕͍ͭͲͷ޿ࠂओͷҊ݅ɾ࿮ͷઃఆΛͯ͠ɺͲͷظؒͲͷ୯Ձ Ͱྲྀ͔ͨ͠ɻ·ͨͦͷมߋཤྺɻ
   w ʮ೥݄೔ʹ%41
   "Ͱೖߘ͞ΕͨΫϦΤΠςΟϒ͕441
   # ͷഔମ9ͷ޿ࠂ࿮:ʹͯΦʔΫγϣϯJE
   EFBECFFGͰམࡳ͞ΕͨɻU ඵޙʹදࣔ͞ΕɺΫϦοΫ͞Εɺίϯόʔδϣϯͨ͠ɻʯͱ͍ͬͨ ৘ใΛϓϥοτϑΥʔϜΛ·͍ͨͰݕূՄೳʹͰ͖ΔͩΖ͏͔ʁ
   w ෼ࢄܕ୆ா͕ඞཁ
   
   IUUQTJBCUFDIMBCDPNXPSLJOH HSPVQTCMPDLDIBJOXPSLJOHHSPVQ
   
10. ഑৴ϩάؔ࿈
11. ޿ࠂͷ഑৴ϩάͷಛ௃ w ͨͩͻͨ͢Βʹଟ͘ɺ૿͑ଓ͚Δ
    w ࿮ɺҊ݅ʹ͍༷ͭͯʑͳ࣠ʢ࣌ؒɺछผ
    FUDʣͰूܭ͢ Δඞཁ͕͋Δ
    w Ϗδωεཁ݅ʹΑͬͯूܭ༻όον͕ͲΜͲΜ;͍͑ͯ͘ εέʔϥϒϧͰεΩʔϚϨεͰϦΞϧλΠϜͰ
    ҆ఆͨ͠ϚωʔδυͳϩάूܭΛ࣮ݱ͍ͨ͠
12. SF*OWFOU
    Ͱͷ
    ϩάؔ࿈6QEBUF w 5JNFTUSFBN
    ϑϧϚωʔδυ࣌ܥྻ%#
    w 4
    #BUDI
    0QFSBUJPOT
    4ͷૢ࡞Λ·ͱΊͯɻ&5-ؔ࿈ Ͱ׆༂ͷ༧ײɻ
    w ,JOFTJT
    %BUB
    "OBMZUJDTͰ+BWB
    'MJOL
    ͕αϙʔτ
    w TUSFBNLFZ#Z  XJOEPX  BQQMZ ʜ
    w %BUB
    4USFBNͰ͸ͳͯ͘"OBMZUJDTͳͷ͕
13. ,JOFTJTҎޙͷΑ͋͘Δ
    ϩάऩूج൫ BQQ ,JOFTJT T pSFIPTF "UIFOBͰΈΔ 4PVSDF
    PG
    5SVUI
14. 5JNFTUSFBN͕͘Δͱ BQQ ,JOFTJT T pSFIPTF DPOTVNFS UJNFTUSFBN GPS
    %BTICPBSE
15. ΋͔ͯ͠͠ɾɾʁ
    BQQ ,JOFTJT T pSFIPTF 1BSRVFU UJNFTUSFBN pSFIPTF
    ʢ΄͍͠ʣ
16. 5JNFTUSFBN΁ͷظ଴ w *OqVY%#΋͍͍͕ɾɾ&OUFSQSJTF͡Όͳ͍ͱDMVTUFS͕͔ͭ͑ͳ͍
    w IUUQTXXXJOqVYEBUBDPNCMPHJOqVYECDMVTUFSJOH
    
    w 1SPNFUIFVT΋͍͍͚Ͳ'FEFSBUJPOΛ͠ͳ͍ͱεέʔϧ͠ͳ͍ɻ
    w &MBTUJDTFBSDI
    4FSWJDF΋͍͍͚ͲɺSFJOEFYJOH΍DMVTUFSαΠζ ͳͲ͸ؾΛ͔ͭΘͳ͍ͱ͍͚ͳ͍
    
    &MBTUJDTFBSDIಛ༗ͷνϡʔ χϯά͸ଟগඞཁ େن໛ͳूܭ΍೔ผͷ෼ੳόον͸#JH2VFSZ
    BOEPS
    "UIFOBͰɻ
 ϦΞϧλΠϜʹ͍ۙμογϡϘʔυ΍ϞχλϦϯά༻్͸
 5JNFTUSFBNʹҠ͍͖͍ͯͨ͠ɻ
17. 8PSLTIPQ
    
    4FTTJPOͳͲ w ✏SF*OWFOU
    ͰΈ͖ͯͨηογϣϯ
    
    ͋ͱͰΈΔ ηογϣϯͷϝϞ
    IUUQTTV[VLFOIBUFOBCMPHKQ FOUSZ
    
    w BKJUPGN
    
    $BOU
    8SBQ
    6Q
    SF*OWFOU
    
    XJUIJO
    
    IPVS
    IUUQTBKJUPGN
    
18. ࢀߟࢿྉ
19. 
 *"#
    #MPDLDIBJO
    8PSLJOH
    (SPVQ
    6QEBUFTΑΓ
    IUUQTXXXZPVUVCFDPNXBUDI WM87C;LTY8PUTJOEFYMJTU1-B5FMUI*@CZ5/UTM$)R6C/-8M
20. ,JOFTJTͰ+BWB w IUUQTXXXTMJEFTIBSFOFU"NB[PO8FC4FSWJDFTOFXMBVODIBNB[POLJOFTJT EBUBBOBMZUJDTGPSKBWBBQQMJDBUJPOTBOUBXTSFJOWFOU