DynamoDBでQuery

Hamamatsu.js #8のLT資料です

Transcript

1. "NB[PO%ZOBNP%#Ͱݕࡧ͢Δ
   !KBDPZVUPSJVT
   )BNBNBUTVKT
   

   View Slide

2. খ໦༔ే !KBDPZVUPSJVT
   
   ‣ ΤΞʔζגࣜձࣾ
   ‣ +"846()BNBNBUTVSC
   ‣ 3VCZ3VCZPO3BJMT+BWBTDSJQU"84
   ࠷ۙ͸ࣗ࡞ΩʔϘʔυͱΧϨʔ࡞ΓʹϋϚ͍ͬͯΔ
   

   View Slide

3. View Slide

4. View Slide

5. +4͸ύΠϓ໓ଟʹ࢖Θͳ͍͔Βେৎ෉ͩΖଟ෼
   

   View Slide

6. "NB[PO%ZOBNP%#
   ‣ ϑϧϚωʔδυͳ/P42-σʔλϕʔε
   ‣ ߴՄ༻ੑ ͭͷ";΁ͷϨϓϦέʔγϣϯ
   
   ‣ ΩʔόϦϡʔετΞ
   ‣ εΩʔϚϨε
   ‣ ΩϟύγςΟϢχοτ
   ‣ ಡΈॻ͖ੑೳΛܾఆ͢Δύϥϝʔλ
   ‣ lΦϯσϚϯυzͱ͍͏Φϓγϣϯ΋͋Δɻ"NQMJGZΛ௨ͯ͠%ZOBNP%#ͷςʔϒϧ
   Λ࡞ͬͨ৔߹ɺσϑΥϧτͰͪ͜ΒͷΦϓγϣϯ͕༗ޮʹͳΔ
   

   View Slide

7. %ZOBNP%#ͷݕࡧ
   ‣ RVFSZ
   ‣ TDBO
   ςʔϒϧશମΛεΩϟϯͯ͠৚݅ʹ߹க͢Δ΋ͷΛฦ͢
   ύʔςΟγϣϯΩʔιʔτΩʔΛࢦఆͯ͠৚݅ʹ߹க͢Δ΋ͷ
   Λநग़͢Δ
   ॊೈͳݕࡧ͕ՄೳͳҰํɺ%#΁ͷෛՙ͕ߴ͘ύϑΥʔϚϯε΋ྑ͘ͳ͍
   

   View Slide

8. ΍Γ͔ͨͬͨ͜ͱ
   ‣ %ZOBNP%#Ͱݕࡧ
   ‣ ύʔςΟγϣϯΩʔιʔτΩʔΛ࢖͏
   

   View Slide

9. ΍͍ͬͯͳ͍͜ͱ
   ‣ ΩϟύγςΟϢχοτͷࢼࢉ
   ‣ ྉۚ
   

   View Slide

10. EPDLFSDPNQPTFZNM
    

    View Slide

11. ‣ %ZOBNP%#"ENJO
    ‣ IUUQMPDBMIPTU
    ‣ EBUBCBTFFOEQPJOU
    ‣ IUUQMPDBMIPTU
    %ZOBNP%#ΛϩʔΧϧͰىಈ
    

    View Slide

12. View Slide

13. ॅॴ$% ౎ಓ෎ݝ$% ࢢ۠ொଜ$% ொҬ$% ༣ศ൪߸ ࣄۀॴϑϥά ഇࢭϑϥά ౎ಓ෎ݝ ౎ಓ෎ݝΧφ ࢢ۠ொଜ ࢢ۠ொଜΧφ
    ੩Ԭݝ γζΦΧέϯ ඿দࢢத۠
    ϋϚϚπγφ
    ΧΫ
    ੩Ԭݝ γζΦΧέϯ ඿দࢢத۠
    ϋϚϚπγφ
    ΧΫ
    ொҬ ொҬΧφ ொҬิ଍ ژ౎௨Γ໊ ࣈஸ໨ ࣈஸ໨Χφ ิ଍ ࣄۀॴ໊
    ࣄۀॴ໊Χ
    φ
    ࣄۀॴॅॴ ৽ॅॴ$%
    ஁໶ொ ΧδϚν
    יߐ ΧϞΤ ඿দࢢอ݈ॴ
    ϋϚϚπγϗ
    έϯδϤ
    יߐ̎ஸ໨̍
    ̍—̎
    ॅॴKQ
    IUUQKVTZPKQ
    

    View Slide

14. 1,Ͱݕࡧ͢Δ
    ॅॴ$% ॅॴ ॅॴΧφ
    ੩Ԭݝ඿দࢢத۠יߐொ γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣ΢
    
    ੩Ԭݝ඿দࢢத۠יߐொத෦ిྗɹʢגʣɹ඿দӦۀॴיߐொ̎
    ̎—̍
    γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣ΢νϢ΢ϒσϯϦϤΫɹʢΧϒʣɹ
    ϋϚϚπΤΠΪϤ΢γϤ
    

    View Slide

15. ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
    

    View Slide

16. ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
    

    View Slide

17. 1,4,Ͱݕࡧ͢Δ
    

    View Slide

18. https:/
    /docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/
    LegacyConditionalParameters.KeyConditions.html
    “ςʔϒϧʹର͢ΔΫΤϦͷ৔߹ɺςʔϒϧͷϓϥΠϚϦΩʔଐੑͷΈ
    ͷ৚݅Λ࣋ͭ͜ͱ͕Ͱ͖·͢ɻEQ ৚݅ͱͯ͠ύʔςΟγϣϯΩʔͷ໊
    લͱ஋Λఏڙ͢Δඞཁ͕͋Γ·͢ɻ
    ΦϓγϣϯͰɺιʔτΩʔΛࢀর͢Δ 2 ൪໨ͷ৚݅ΛࢦఆͰ͖·͢ɻ”
    RVFSZͷ੍ݶ
    

    View Slide

19. https:/
    /docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/
    LegacyConditionalParameters.KeyConditions.html
    KeyConditions ͷ৔߹ɺ࣍ͷൺֱԋࢉࢠͷΈ͕αϙʔτ͞Ε͍ͯ·͢ɻ
    EQ | LE | LT | GE | GT | BEGINS_WITH | BETWEEN
    RVFSZͷ੍ݶ
    

    View Slide

20. IUUQTEPDTBXTBNB[PODPNKB@KQBNB[POEZOBNPECMBUFTUEFWFMPQFSHVJEF)PX*U8PSLT1BSUJUJPOTIUNM
    

    View Slide

21. ࢁསݝ
    ੩Ԭݝ
    Ѫ஌ݝ
    ʜ
    ੩ԬࢢѮ۠
    ੩Ԭࢢਗ਼ਫ۠
    ʜ
    ඿দࢢத۠
    ඿দࢢ੢۠
    ʜ
    ஁໶ொ
    ࠠ԰ொ
    ʜ
    יߐ
    ݩ඿ொ
    ʜ
    FY
    TFMFDUCPYͰυϦϧμ΢ϯ͢ΔΑ͏ͳ6*
    

    View Slide

22. (4*
    ‣ ςʔϒϧ࡞੒࣌ʹࢦఆ͢Δ1,4,ͱ͸ผʹఆٛͰ͖ΔΠϯσοΫε
    ‣ Ұͭͷςʔϒϧʹ͖ͭɺ࠷େͭͷ(4*͕ొ࿥Մೳ
    ‣ (4*͝ͱʹΩϟύγςΟϢχοτͷઃఆ͕ඞཁ
    ‣ (4*͸ςʔϒϧͷࣹӨɻϨίʔυͷొ࿥௚ޙʹ(4*΁ݕࡧΛ͔͚ͯ΋͙͢ʹ
    ൓ө͞Ε͍ͯͳ͍৔߹͕͋Δ
    άϩʔόϧηΧϯμϦΠϯσοΫε
    

    View Slide

23. ॅॴ$%
    ౎ಓ෎ݝ
    $%
    ࢢ۠ொଜ
    $%
    ொҬ$% ༣ศ൪߸
    ࣄۀॴϑϥ
    ά
    ഇࢭϑϥά ౎ಓ෎ݝ
    ౎ಓ෎ݝΧ
    φ
    ࢢ۠ொଜ
    ࢢ۠ொଜΧ
    φ
    ொҬ ொҬΧφ
    
    
    
    ੩Ԭݝ
    γζΦΧέ
    ϯ
    ඿দࢢத۠
    ϋϚϚπγ
    φΧΫ
    יߐ ΧϞΤ
    DBUFHPSZ WBMVF
    DJUZ ඿দࢢத۠
    DBUFHPSZ WBMVF
    QSFGFDUVSF ੩Ԭݝ
    DBUFHPSZ WBMVF
    UPXO יߐ
    

    View Slide

24. ॅॴ$% DBUFHPSZ DBUFHPSZ@WBMVF ౎ಓ෎ݝ ࢢ۠ொଜ ொҬ
    QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
    DJUZ ੩Ԭݝ඿দࢢத۠ ඿দࢢத۠
    UPXO ੩Ԭݝ඿দࢢத۠יߐ יߐ
    1, 4,
    ॅॴ$%
    ౎ಓ෎ݝ
    $%
    ࢢ۠ொଜ
    $%
    ொҬ$% ༣ศ൪߸
    ࣄۀॴϑϥ
    ά
    ഇࢭϑϥά ౎ಓ෎ݝ
    ౎ಓ෎ݝΧ
    φ
    ࢢ۠ொଜ
    ࢢ۠ொଜΧ
    φ
    ொҬ ொҬΧφ
    
    
    
    ੩Ԭݝ
    γζΦΧέ
    ϯ
    ඿দࢢத۠
    ϋϚϚπγ
    φΧΫ
    יߐ ΧϞΤ
    

    View Slide

25. ॅॴ$% DBUFHPSZ DBUFHPSZ@WBMVF ౎ಓ෎ݝ ࢢ۠ொଜ ொҬ
    QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
    DJUZ ੩Ԭݝ඿দࢢத۠ ඿দࢢத۠
    UPXO ੩Ԭݝ඿দࢢத۠יߐ יߐ
    1, 4,
    1, 4,
    ॅॴ$% DBUFHPSZ DBUFHPSZ@WBMVF ౎ಓ෎ݝ ࢢ۠ொଜ ொҬ
    QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
    DJUZ ੩Ԭݝ඿দࢢத۠ ඿দࢢத۠
    UPXO ੩Ԭݝ඿দࢢத۠יߐ יߐ
    (4*
    

    View Slide

26. (4*ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
    

    View Slide

27. (4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔ
    લํҰகݕࡧ݁Ռ
    

    View Slide

28. (4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔݕࡧ݁Ռ
    

    View Slide

29. ࢁསݝ
    ੩Ԭݝ
    Ѫ஌ݝ
    ʜ
    ੩ԬࢢѮ۠
    ੩Ԭࢢਗ਼ਫ۠
    ʜ
    ඿দࢢத۠
    ඿দࢢ੢۠
    ʜ
    ஁໶ொ
    ࠠ԰ொ
    ʜ
    יߐ
    ݩ඿ொ
    ʜ
    FY
    TFMFDUCPYͰυϦϧμ΢ϯ͢ΔΑ͏ͳ6*
    

    View Slide

30. %ZOBNP%#σʔλϞσϦϯάދͷר
    IUUQNBSDZIBUFOBCMPHDPNFOUSZ
    ͷ΅Γʔ͞ΜͷΫϥ΢υΠϯϑϥ1PEDBTUʰ5SBDLরҪ͞Μͷ
    4FSWFSMFTTΞʔΩςΫτࢦೆͱɺ1BUSFPOొ࿥ͷ͓஌ΒͤʱͷϝϞ
    IUUQTDMPVEJOGSBBVEJPUSBDLEGFD
    %ZOBNP%#Λ࢖༻ͨ͠ઃܭͱΞʔΩςΫνϟͷઃܭʹؔ͢ΔϕετϓϥΫςΟε
    IUUQTEPDTBXTBNB[PODPNKB@KQBNB[POEZOBNPECMBUFTUEFWFMPQFSHVJEFCFTU
    QSBDUJDFTIUNM
    

    View Slide

31. View Slide

32. View Slide

33. View Slide

34. "84&YQFSU0OMJOF+"846(඿দ"84ษڧձ
    IUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT
    +"846(඿দ"84ษڧձ
    IUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT
    +"84%":4
    IUUQTKBXTEBZTKBXTVHKQ
    

    View Slide