DynamoDBでQuery - Speaker Deck

DynamoDBでQuery

by jacoyutorius

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

EPDLFSDPNQPTFZNM

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

No content

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

1,4,Ͱݕࡧ͢Δ

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

IUUQTEPDTBXTBNB[PODPNKB@KQBNB[POEZOBNPECMBUFTUEFWFMPQFSHVJEF)PX*U8PSLT1BSUJUJPOTIUNM

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

No content

Slide 32

Slide 32 text

No content

Slide 33

Slide 33 text

No content

Slide 34

Slide 34 text

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