Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Kenta Suzuki
December 18, 2018

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

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

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

Kenta Suzuki

December 18, 2018
Tweet

More Decks by Kenta Suzuki

Other Decks in Technology

Transcript

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

    View full-size slide

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

    View full-size slide

  3. ౎಺๭ॴޕޙ࣌

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  7. "NB[PO2VBOUVN-FEHFS%BUBCBTF
    2-%#

    w ϑϧϚωʔδυͳ୆ாσʔλϕʔε
    w ҉߸Խ͞Εɺཤྺ͕อূ͞Εɺ͔ͭJNNVUBCMFͳσʔλ
    ͱͯ͠อ࣋Ͱ͖Δɻߋ৽΋࡟আ΋Ͱ͖ͳ͍ɻ
    w 42-MJLFͳ"1*τϥϯβΫγϣϯαϙʔτ
    4P3 4ZTUFNPG3FDPSE
    ͳΞϓϦέʔγϣϯʹ߹͏

    View full-size slide

  8. IUUQTTQFBLFSEFDLDPNOBPZBTZTUFNPGSFDPSE
    UPTZTUFNPGFOHBHFNFOU TMJEF

    View full-size slide

  9. ޿ࠂӡ༻ͰͷBVEJUBCJMJUZͱ
    ΞΠσΞ
    w طଘΞϓϦέʔγϣϯ2-%#Ͱ༰қʹ࣮ݱɻ͍ΘΏΔ؂ࠪϩάɻ
    w ୭͕͍ͭͲͷ޿ࠂओͷҊ݅ɾ࿮ͷઃఆΛͯ͠ɺͲͷظؒͲͷ୯Ձ
    Ͱྲྀ͔ͨ͠ɻ·ͨͦͷมߋཤྺɻ
    w ʮ೥݄೔ʹ%41"Ͱೖߘ͞ΕͨΫϦΤΠςΟϒ͕441#
    ͷഔମ9ͷ޿ࠂ࿮:ʹͯΦʔΫγϣϯJEEFBECFFGͰམࡳ͞ΕͨɻU
    ඵޙʹදࣔ͞ΕɺΫϦοΫ͞Εɺίϯόʔδϣϯͨ͠ɻʯͱ͍ͬͨ
    ৘ใΛϓϥοτϑΥʔϜΛ·͍ͨͰݕূՄೳʹͰ͖ΔͩΖ͏͔ʁ
    w ෼ࢄܕ୆ா͕ඞཁIUUQTJBCUFDIMBCDPNXPSLJOH
    HSPVQTCMPDLDIBJOXPSLJOHHSPVQ

    View full-size slide

  10. ഑৴ϩάؔ࿈

    View full-size slide

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

    View full-size slide

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

    w %BUB4USFBNͰ͸ͳͯ͘"OBMZUJDTͳͷ͕

    View full-size slide

  13. ,JOFTJTҎޙͷΑ͋͘Δ
    ϩάऩूج൫
    BQQ ,JOFTJT T
    pSFIPTF
    "UIFOBͰΈΔ
    4PVSDFPG5SVUI

    View full-size slide

  14. 5JNFTUSFBN͕͘Δͱ
    BQQ ,JOFTJT T
    pSFIPTF
    DPOTVNFS
    UJNFTUSFBN
    GPS%BTICPBSE

    View full-size slide

  15. ΋͔ͯ͠͠ɾɾʁ
    BQQ ,JOFTJT T
    pSFIPTF
    1BSRVFU
    UJNFTUSFBN
    pSFIPTF
    ʢ΄͍͠ʣ

    View full-size slide

  16. 5JNFTUSFBN΁ͷظ଴
    w *OqVY%#΋͍͍͕ɾɾ&OUFSQSJTF͡Όͳ͍ͱDMVTUFS͕͔ͭ͑ͳ͍
    w IUUQTXXXJOqVYEBUBDPNCMPHJOqVYECDMVTUFSJOH
    w 1SPNFUIFVT΋͍͍͚Ͳ'FEFSBUJPOΛ͠ͳ͍ͱεέʔϧ͠ͳ͍ɻ
    w &MBTUJDTFBSDI4FSWJDF΋͍͍͚ͲɺSFJOEFYJOH΍DMVTUFSαΠζ
    ͳͲ͸ؾΛ͔ͭΘͳ͍ͱ͍͚ͳ͍&MBTUJDTFBSDIಛ༗ͷνϡʔ
    χϯά͸ଟগඞཁ
    େن໛ͳूܭ΍೔ผͷ෼ੳόον͸#JH2VFSZBOEPS"UIFOBͰɻ

    ϦΞϧλΠϜʹ͍ۙμογϡϘʔυ΍ϞχλϦϯά༻్͸

    5JNFTUSFBNʹҠ͍͖͍ͯͨ͠ɻ

    View full-size slide

  17. 8PSLTIPQ4FTTJPOͳͲ
    w ✏SF*OWFOUͰΈ͖ͯͨηογϣϯ͋ͱͰΈΔ
    ηογϣϯͷϝϞIUUQTTV[VLFOIBUFOBCMPHKQ
    FOUSZ
    w BKJUPGN$BOU8SBQ6QSF*OWFOUXJUIJO
    IPVSIUUQTBKJUPGN

    View full-size slide


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

    View full-size slide

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

    View full-size slide