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

9c47f639b91a66ccf901724eaaf9043d?s=47 Kenta Suzuki
December 18, 2018

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

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

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

9c47f639b91a66ccf901724eaaf9043d?s=128

Kenta Suzuki

December 18, 2018
Tweet

Transcript

  1. "%ΤϯδχΞ͕Έͨ SF*OWFOU TV[VLFO ࢢϲ୩(FFL˒/JHIU

  2. ࢲʹ͍ͭͯ ͚ͣ͢ΜHJUIVCDPNTV[VLFO!TV[V@W qVDU441IUUQTqVDUKQΛ࡞͍ͬͯ·͢ BKJUPGNͱ͍͏ϙουΩϟετΛ΍͍ͬͯ·͢

  3. ౎಺๭ॴޕޙ࣌

  4. "%ΤϯδχΞ͔Βݟͨ SF*OWFOU w ࣄྫ঺հ"%5-ʢ޿ࠂܥͷϦʔμʔγοϓηογϣ ϯʣ w "%ؔ࿈γεςϜͷΞʔΩςΫνϟͰ࢖͑ͦ͏ͳSF*OWFOU Ͱͷ6QEBUFΛͭ঺հ͠·͢

  5. Έͳ͞Μ؂ࠪϩάͬͯ Ͳ͏อଘ͞Εͯ·͔͢ʁ

  6. ؂ࠪϩάཁ݅ w ͞·͟·ͳߦಈɺࣄ৅ʹؔ͢ΔσʔλΛ࣮֬ʹه࿥͢Δ w τϨʔαϏϦςΟΛ୲อ͢Δ w ফ͑ͳ͍ Α͋͘Δύλʔϯ 3%#ʹ؂ࠪ༻ςʔϒϧΛͭ͘Γʢ೔࣌ɺૢ࡞ର৅ɺૢ࡞಺༰ʣΛ͍Ε͓ͯ͘ ΫΤϦ͕ͭΒ͍ɺ؂ࠪϩάͷվ᜵Λ๷͙ͨΊͷݖݶઃఆ͕ඞཁ

  7. "NB[PO2VBOUVN-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ͷ޿ࠂ࿮:ʹͯΦʔΫγϣϯJEEFBECFFGͰམࡳ͞ΕͨɻU ඵޙʹදࣔ͞ΕɺΫϦοΫ͞Εɺίϯόʔδϣϯͨ͠ɻʯͱ͍ͬͨ ৘ใΛϓϥοτϑΥʔϜΛ·͍ͨͰݕূՄೳʹͰ͖ΔͩΖ͏͔ʁ w ෼ࢄܕ୆ா͕ඞཁIUUQTJBCUFDIMBCDPNXPSLJOH HSPVQTCMPDLDIBJOXPSLJOHHSPVQ
  10. ഑৴ϩάؔ࿈

  11. ޿ࠂͷ഑৴ϩάͷಛ௃ w ͨͩͻͨ͢Βʹଟ͘ɺ૿͑ଓ͚Δ w ࿮ɺҊ݅ʹ͍༷ͭͯʑͳ࣠ʢ࣌ؒɺछผFUDʣͰूܭ͢ Δඞཁ͕͋Δ w Ϗδωεཁ݅ʹΑͬͯूܭ༻όον͕ͲΜͲΜ;͍͑ͯ͘ εέʔϥϒϧͰεΩʔϚϨεͰϦΞϧλΠϜͰ ҆ఆͨ͠ϚωʔδυͳϩάूܭΛ࣮ݱ͍ͨ͠

  12. SF*OWFOUͰͷ ϩάؔ࿈6QEBUF w 5JNFTUSFBNϑϧϚωʔδυ࣌ܥྻ%# w 4#BUDI0QFSBUJPOT4ͷૢ࡞Λ·ͱΊͯɻ&5-ؔ࿈ Ͱ׆༂ͷ༧ײɻ w ,JOFTJT%BUB"OBMZUJDTͰ+BWB 'MJOL

    ͕αϙʔτ w TUSFBNLFZ#Z  XJOEPX  BQQMZ ʜ  w %BUB4USFBNͰ͸ͳͯ͘"OBMZUJDTͳͷ͕
  13. ,JOFTJTҎޙͷΑ͋͘Δ ϩάऩूج൫ BQQ ,JOFTJT T pSFIPTF "UIFOBͰΈΔ 4PVSDFPG5SVUI

  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 &MBTUJDTFBSDI4FSWJDF΋͍͍͚ͲɺSFJOEFYJOH΍DMVTUFSαΠζ ͳͲ͸ؾΛ͔ͭΘͳ͍ͱ͍͚ͳ͍

    &MBTUJDTFBSDIಛ༗ͷνϡʔ χϯά͸ଟগඞཁ େن໛ͳूܭ΍೔ผͷ෼ੳόον͸#JH2VFSZBOEPS"UIFOBͰɻ
 ϦΞϧλΠϜʹ͍ۙμογϡϘʔυ΍ϞχλϦϯά༻్͸
 5JNFTUSFBNʹҠ͍͖͍ͯͨ͠ɻ
  17. 8PSLTIPQ4FTTJPOͳͲ w ✏SF*OWFOUͰΈ͖ͯͨηογϣϯ͋ͱͰΈΔ ηογϣϯͷϝϞIUUQTTV[VLFOIBUFOBCMPHKQ FOUSZ w BKJUPGN$BOU8SBQ6QSF*OWFOUXJUIJO IPVSIUUQTBKJUPGN

  18. ࢀߟࢿྉ

  19. 
 *"##MPDLDIBJO8PSLJOH(SPVQ6QEBUFTΑΓ IUUQTXXXZPVUVCFDPNXBUDI WM87C;LTY8PUTJOEFYMJTU1-B5FMUI*@CZ5/UTM$)R6C/-8M

  20. ,JOFTJTͰ+BWB w IUUQTXXXTMJEFTIBSFOFU"NB[PO8FC4FSWJDFTOFXMBVODIBNB[POLJOFTJT EBUBBOBMZUJDTGPSKBWBBQQMJDBUJPOTBOUBXTSFJOWFOU