$30 off During Our Annual Pro Sale. View Details »

Amazon Neptuneに入門してみる

Amazon Neptuneに入門してみる

NDS 長岡 IT開発者 勉強会 第55回勉強会(2018/03/17)

Yu Watanabe

March 17, 2018
Tweet

More Decks by Yu Watanabe

Other Decks in Programming

Transcript

  1. "NB[PO/FQUVOFʹೖ໳ͯ͠ΈΔ
    :V8BUBOBCF !ZVXC

    /%4௕Ԭ*5։ൃऀษڧձ ୈճษڧձ

    View Slide

  2. ࣗݾ঺հ
    ඇৗۈΤϯδχΞʴϑϦʔϥϯε
    ˙ 41"ʴ"1*ʴ%#ͳ8FCαʔϏεͷ੍࡞!ΞΧσϛΞ
    ϑϩϯτΤϯυɿ+BWB4DSJQU3FBDU
    όοΫΤϯυɿ/PEFKT 3VCZ1)1
    σʔλϕʔεؔ܎ɿ.Z42-/FPK3%'
    ͦͷଞɿαʔόͷઃఆͱ͔ػցֶशͷ͓ख఻͍ͱ͔
    ɾɾɾͳΜͰ΋԰͞ΜͰ͢ɻ

    View Slide

  3. ຊ೔ͷςʔϚ
    "NB[PO/FQUVOF
    "GVMMZNBOBHFEHSBQIEBUBCBTF
    "84ʹ஥ؒೖΓͨ͠άϥϑσʔλϕʔεͰ͢ɻ
    ݱࡏ͸ϓϨϏϡʔ൛͕࢖͑·͢ɻ

    View Slide

  4. άϥϑɾɾɾʁ
    γϦʔζɾ
    य़ͷάϥϑσʔλಛू

    View Slide

  5. άϥϑߏ଄σʔλ
    ˙ σʔλߏ଄ͷछྨ
    • ഑ྻ <ελοΫΩϡʔ>
    • ࿈૝഑ྻ <ϋογϡςʔϒϧϧοΫΞοϓςʔϒϧ>
    • ઢܗϦετ
    • ໦ߏ଄
    • άϥϑ
    ˙ ਎ۙʹ͋Δάϥϑߏ଄
    • మಓ࿏ઢ
    • ίϯϐϡʔλωοτϫʔΫ
    • Ոܥਤʢ໦ߏ଄ʣ
    • 4/4ͷGPMMPXGPMMPXJOHͷؔ܎
    Կ͔ͷωοτϫʔΫ
    ·ͨ͸
    Կ͔ͷ૬ؔؔ܎

    View Slide

  6. άϥϑཧ࿦ͷ༻ޠΛ͢͜͠
    • ϊʔυʢ௖఺ʣͱΤοδʢลʣ
    • ༗޲άϥϑͱແ޲άϥϑ
    • Τοδʹ͸ॏΈ෇͚͕Ͱ͖Δ
    • ୯७άϥϑͱଟॏάϥϑ

    View Slide

  7. "NB[PO/FQUVOF
    ೥݄຤ʹൃද͞Εͨ"NB[PO71$಺ͰՔಇ͢Δάϥϑσʔλ
    ϕʔεɻݱࡏ͸ݶఆϓϨϏϡʔ൛͕ެ։͞Ε͍ͯΔɻ

    View Slide

  8. ͓஋ஈ
    IUUQTBXTBNB[PODPNKQOFQUVOFQSJDJOH
    42-4FSWFSͷ΄͏ͱಉ͘͡Β͍ͷՁ֨ઃఆ
    ˞ϓϨϏϡʔظؒத͸ແྉͰ͢

    View Slide

  9. ʢͪΐͬͱدΓಓʣطଘͷάϥϑσʔλϕʔε
    ˙ ϓϩύςΟάϥϑϞσϧɾɾɾͦΕͧΕಠࣗͷΫΤϦจ๏Λ࣋ͭ
    • /FPK IUUQTOFPKDPN

    FUDʜ
    ˙ 3%'Ϟσϧɾɾɾ8$ඪ४ͷ3%'Ϟσϧͱ41"32-ΫΤϦΛ࢖͏
    • 7JSUVPTP IUUQTWJSUVPTPPQFOMJOLTXDPN

    • 'VTFLJ IUUQTKFOBBQBDIFPSHEPDVNFOUBUJPOTFSWJOH@EBUB

    https://neo4j.com/developer/guide-data-modeling/
    Apache TinkerPop / Gremlin

    View Slide

  10. "NB[PO/FQUVOFͷಛ௃
    ˙ ϓϩύςΟάϥϑɾ3%'ͷ྆ํ͕࢖͑Δ
    άϥϑͷදݱͱ໰͍߹ΘͤͷͨΊʹɺͭͷΦʔϓϯͳۀքඪ४Λαϙʔτ͠·͢ɻ
    (SFNMJOʹΑͬͯ໰߹ͤՄೳͳ"QBDIF5JOLFS1PQޓ׵ͷϓϩύςΟάϥϑɻ
    (SFNMJO͸ϊʔυ ௖఺
    ʹͭͳ͕ΔΤοδ ล
    ΛݸผʹͨͲΔ୳ࡧΛ࣮ݱ͢Δάϥ
    ϑ୳ࡧݴޠͰ͢ɻ41"32-ʹΑͬͯ໰߹ͤՄೳͳ 3%' 3FTPVSDF%FTDSJQUJPO
    'SBNFXPSL
    ɻ
    ˙ ૝ఆ͍ͯ͠Δ༻్
    4/4ɺϨίϝϯσʔγϣϯΤϯδϯɺܦ࿏Ҋ಺ɺ෺ྲྀ࠷దԽɺࣗಈ਍அɺ৵ೖݕ஌
    ΍ήϊϜ഑ྻܾఆͳͲͷΞϓϦέʔγϣϯ͕ྫʹڍ͛ΒΕ·͢ɻ
    https://aws.amazon.com/jp/blogs/news/amazon-neptune-a-fully-managed-graph-database-service/

    View Slide

  11. ͬͦ͘͞࢖ͬͯΈΔ
    ͜͜ʹ͸͋Γ·ͤΜ
    खಈͰΞΫηεʂ
    IUUQTBXTBNB[PODPNKQOFQUVOF
    ʮϓϨϏϡʔʹαΠϯΞοϓʯ͔Βਃ͠ࠐΈ·͢ɻ
    ೔͘Β͍Ͱϝʔϧ͕ಧ͖·ͨ͠ɻ

    View Slide

  12. ؀ڥߏங
    ϢʔβʔΨΠυʢӳޠʣ
    IUUQTEPDTBXTBNB[PODPNKB@KQOFQUVOFMBUFTUVTFSHVJEFJOUSPIUNM
    IUUQTEPDTBXTBNB[PODPNKB@KQOFQUVOFMBUFTUVTFSHVJ
    EFHFUTUBSUFEQSFSFRVJTJUFTIUNM
    • &$Πϯελϯε͔Β/FQUVOFͷ%#ΫϥελʔʹΞΫηε
    • σʔλΛϑΝΠϧ͔Βϩʔυ͢ΔͳΒ4΋ඞཁ
    • ͦΕͧΕʹඞཁͳΞΫηεݖݶΛ෇༩
    ˞&$΍4͸ແྉͰ͸ͳ͍Ͱ͢

    View Slide

  13. ؀ڥߏஙμΠδΣετ
    ͱʹ͔͘શ෦ʮόʔδχΞ๺෦ VTFBTU
    ʯʹ࡞͍ͬͯͩ͘ʂ
    ͦ͜ʹ͔͠/FQUVOF͋Γ·ͤΜʂʂ
    71$ͱ
    &$Πϯελϯεͷ࡞੒
    *".ͰϢʔβʔ࡞Δ

    View Slide

  14. ؀ڥߏஙμΠδΣετ
    /FQUVOFͷΠϯελϯε͸
    /FQUVOFͷίϯιʔϧͰ࡞Δ

    View Slide

  15. ؀ڥߏஙμΠδΣετ

    View Slide

  16. ؀ڥߏஙμΠδΣετ
    /FQUVOFͷ%#Ϋϥελʔ͕Ͱ͖ͨΑʔ
    ϓϩϏδϣχϯάʹ͸ʙ෼͘Β͍͔͔Γ·ͨ͠ɻ

    View Slide

  17. )FMMP/FQUVOF
    &$Πϯελϯεʹ44)ͰϩάΠϯɺ
    /FQUVOFͷΤϯυϙΠϯτʹΫΤϦΛ1045ͯ͠ΈΔɻ
    ۭͬΆͳͷͰɺۭͷ഑ྻ͕ฦ͖ͬͯ·ͨ͠ɻ͜ΕͰ0,ʂ

    View Slide

  18. σʔλͷϩʔυ
    • 4ʹόέοτΛ༻ҙʢόʔδχΞ๺෦ʂʣ
    • /FQUVOF͔ΒಡΈࠐΊΔΑ͏ʹݖݶ෇༩
    • ϑΝΠϧΛ4ʹΞοϓϩʔυ

    View Slide

  19. ࣗ෼ͷσʔλͰ΍ͬͯΈͨ 3%'Ϟσϧ
    Q13952 P23511
    Activation
    2,721 nodes
    43,228 edges
    • ໿ ߦͷ3%'ϑΝΠϧ .#
    Λ4ʹΞοϓϩʔυ
    • &$ίϯιʔϧ͔Βɺ4্ͷσʔλΛ/FQUVOFʹϩʔυͤ͞Δ
    • ඵҎԼͰ/FQUVOFʹΠϯαʔτ׬ྃ

    View Slide

  20. ࣗ෼ͷσʔλͰ΍ͬͯΈͨ 41"32-ΫΤϦ
    curl -X POST --data-binary 'query=PREFIX uniprot:
    SELECT (COUNT(DISTINCT ?prot2) as ?count) WHERE
    {uniprot:P00533 uniprot:activate ?prot1. ?prot1 uniprot:activate ?prot2 .}'
    http://neptuneinstance-cluster.cluster-cumqwp3crwyp.us-east-1-
    beta.rds.amazonaws.com:8182/sparql
    ˙ ͋Δϊʔυ *%1
    ͷ࣍ͷ࣍ͷϊʔυΛશͯऔಘʢͯ͠Χ΢ϯτʣ
    ΤϯυϙΠϯτʹ41"32-ΫΤϦΛ౤͛Δ
    ϊʔυ͕ඵҎԼͰฦ͖ͬͯͨɻ

    View Slide

  21. ·ͱΊ
    • άϥϑߏ଄σʔλ͸άϥϑσʔλϕʔεʹೖΕͯΈΔ
    • طଘͷπʔϧ͸ಋೖͷϋʔυϧ͕ߴ͍PS҆ఆ͠ͳ͍ɻʢݸਓͷҙݟͰ͢ʣ
    • ͦ͜Ͱ"NB[PO/FQUVOF !όʔδχΞ๺෦

    • ϑϧϚωʔδυ
    • εέʔϧͰ͖ΔʢεϞʔϧελʔτՄೳʣ
    • ϓϩύςΟάϥϑͱ3%'ͷ྆Ϟσϧ͕࢖͑Δ
    • े෼࣮༻ϨϕϧʂʢݸਓͷҙݟͰ͢ʣ

    View Slide