Share
Embed
Jupyter NotebookからDb2へらくらくアクセス - Db2 Magic コマンドを使おう! - / 20220421 Jupyter Notebooks with Db2
2022年4/21(木) オンライン開催
【ハンズオン】Jupyter NotebookからDb2へらくらくアクセス
https://ibm-developer.connpass.com/event/242523/
の資料です。
Kyoko Nishito
April 21, 2022
Transcript
39 slides
-
ށ ژࢠ ຊΞΠɾϏʔɾΤϜגࣜձࣾ ςΫϊϩδʔࣄۀ෦ %BUB"*5FDIOJDBM4BMFT github.com/kyokonishito twitter.com/KyokoNishito www.linkedin.com/in/kyokonishito qiita.com/nishikyon speakerdeck.com/kyokonishito
ຊ*#.ʹͯओʹ*#.ͷࣾγεςϜ։ൃɾอकʹैࣄ͠ɺཁ ݅ఆ͔ٛΒอक·Ͱɺ։ൃऀɾ1.ɾΞʔΩςΫτͱͯ͠ຊɺ "1֤ࠃͷੜ࢈ཧγεςϜߪങγεςϜɺ*5ࢿ࢈ཧγε ςϜ ɺ෯͘ܦݧ͖ͯ͠·ͨ͠ɻͦͷޙ*#.%FWFMPQFS "EWPDBUFͱͯ͠։ൃऀͷܒ׆ಈΛߦ͍ͬͯ·ͨ͠ɻ ݱࡏData and "*ςΫχΧϧεϖγϟϦετ͍ͬͯ·͢ɻ 8PNFOJO%BUB4DJFODF 5PLZP!*#. ։࠵ ࠓʹ։࠵༧ఆ ୈ ճ ຊ౷ܭֶձ౷ܭڭҭ ड 2 IBM Data & AI / © 2022 IBM Corporation -
ຊͷతͱΰʔϧ తɿ %C .BHJDίϚϯυΛͬͨ +VQZUFS /PUFCPPL͔Β%CΒ͘Β͘ΞΫηε Λ࣮ײͯ͠Β͏ʂ 3 IBM Data
& AI / © 2022 IBM Corporation ΰʔϧɿ %C .BHJDίϚϯυΛ͍ͨ͘ͳΔʂ -
14:00-15:00 (60min) %Cʹཷ·ͬͨσʔλΛ༗ޮ׆༻ʂ +VQZUFS /PUFCPPL͔Β%C Β͘Β͘ΞΫηε • ΠϯτϩμΫγϣϯ • ࣮ࡍʹͬͯΈ·͠ΐ͏
• ·ͱΊ • 2" ຊͷλΠϜςʔϒϧ IBM Data & AI / © 2022 IBM Corporation 4 -
ҰॹʹͬͯΈΔ߹ޙͰ࣮ࢪ߹ͷࣄલ४උ IBM Data & AI / © 2022 IBM Corporation
5 IUUQTJCNCPYDPNWOJTIJUPQSFQ #PYͷαΠϯΞοϓϩάΠϯෆཁͰ͢ɻ ͦͷΑ͏ͳϝοηʔδ͕දࣔ͞ΕͨΒ9ΛΫϦοΫͯ͠Ϋϩʔζ͍ͯͩ͘͠͞ɻ -
ΠϯτϩμΫγϣϯ 6 IBM Data & AI / © 2022 IBM
Corporation -
+VQZUFS /PUFCPPL%C +VQZUFS /PUFCPPL ίʔυ ओʹ1ZUIPO ΛΠϯλϥΫςΟϒʹهड़ɾ࣮ߦ͕͙͢Ͱ͖ɺ݁ՌΛ͙͢ʹάϥ ϑԽͨ͠Γදࣔͨ͠Γ͢Δ͜ͱ͕Ͱ͖ΔΦʔϓϯιʔεͷ8FCΞϓϦέʔγϣϯͰ ͢ɻ +VQZUFS
/PUFCPPLͱ%CΛซ༻͢Δ͜ͱͰɺσʔλϕʔεͰͷ42-ͷϓϩτλΠ ϐϯάɺΞϓϦέʔγϣϯͷߏஙɺ݁ՌͷੳɺσʔλͷάϥϑԽͳͲΛૉૣ͘ߦ͏ ͜ͱ͕Ͱ͖·͢ɻ IBM Data & AI / © 2022 IBM Corporation 7 -
+VQZUFS /PUFCPPLͲ͜Ͱ͑Δ 8JOEPXT .BD ͳͲͷ1$ʹಋೖͯ͠͏ – 1$ʹQZUIPOͷڥΛಋೖ্ͨ͠Ͱɺ+VQZUFS /PUFCPPL͕ಋೖͰ͖·͢ ɻ
– ·ͨ7JTVBM4UVEJP$PEF 74$PEF ͰOPUFCPPL༻Ͱ͖·͢ɻ 74$PEF KVQZUFS OPUFCPPLͰݕࡧ Πϯλʔωοτ্ͷαʔϏεΛར༻ 4BB4 – *#. $MPVE 8BUTPO 4UVEJP ຊ͜Ε%CυϥΠόʔϥΠϒϥϦೖΓ – (PPHMF$PMBCPSBUPSZ ͳͲͳͲɾɾɾ IBM Data & AI / © 2022 IBM Corporation 8 -
.BHJDίϚϯυ • +VQZUFS /PUFCPPLͷػೳ • ίʔυϒϩοΫͰ༻Ͱ͖ΔߏจΛ֦ு • .BHJDίϚϯυɺύʔηϯτه߸ʮʯͰ࢝·Δ • /PUFCPPLͷಈ࡞ͷมߋɺ04ίϚϯυͷ࣮ߦɺ
/PUFCPPLػೳͷ֦ுͳͲɺ ڥ Ͱ͞·͟·ͳػೳΛఏڙ IBM Data & AI / © 2022 IBM Corporation 9 -
%C.BHJDίϚϯυ IUUQTHJUIVCDPN*#.ECKVQZUFS %C.BHJDίϚϯυ TRM • ඪ४తͳ42-ߏจΛ༻ͯ͠ %CςʔϒϧΛরձ͢Δ͜ͱ͕ Ͱ͖Δ.BHJDίϚϯυ • ϩʔυ͕ඞཁ
ඪ४Ͱఏڙ͞ Ε͍ͯͳ͍ • +VQZFSಈ࡞ڥʹ%Cͷ QZUIPOϥΠϒϥϦɺ%Cυϥ Πόʔ͕ඞཁ IBM Data & AI / © 2022 IBM Corporation 10 -
࣮ࡍʹͬͯΈ·͠ΐ͏ 11 IBM Data & AI / © 2022 IBM
Corporation -
ࣄલ४උ͕࣮ࢪࡁΈͷঢ়ଶ͔Β࢝Ί·͢ IBM Data & AI / © 2022 IBM Corporation
12 IUUQTJCNCPYDPNWOJTIJUPQSFQ • %CPO$MPVEͷϥΠτϓϥϯαʔϏε࡞ • %CPO$MPVEͷࢿ֨ใͷ࡞ • 8BUTPO4UVEJPͷϥΠτϓϥϯαʔϏε࡞ • 8BUTPO4UVEJP ·ͨ$MPVE1BLGPS%BUB ϓϩδΣΫτ࡞ ͱઃఆ -
*#.$MPVEʹϩάΠϯ • *#.$MPVEϩάΠϯ *#.$MPVE"DDPVOU ొͨ͠ϝʔϧΞυϨε ΛೖΕͯϩάΠϯ͍ͯͩ͘͠͞ɻ IUUQTDMPVEJCNDPNMPHJOʹΞΫηεͯ͠ϩάΠϯ͠·͢ɻ IBM Data &
AI / © 2022 IBM Corporation 13 -
ϦιʔεϦετΛදࣔ *#.$MPVEϩΰͷࠨԣͷϋϯόʔΨɾϝχϡʔΛΫϦοΫ ϦιʔεɾϦετΛબ 8BUTPO4UVEJPͷىಈ IBM Data & AI / ©
2022 IBM Corporation 14 -
αʔϏε͓ΑͼιϑτΣΞͷ8BUTPO4UVEJPYYΛબ YYਓʹΑͬͯҧ ͍·͢ 8BUTPO4UVEJPͷىಈ IBM Data & AI /
© 2022 IBM Corporation 15 -
ηογϣϯ༻ͷ/PUFCPPLΛ։͘ ʮࢿ࢈ʯΛΫϦοΫ͠·͢ɻ <৽نࢿ࢈ >ΛΫϦοΫ͠·͢ IBM Data & AI / ©
2022 IBM Corporation 20 -
ηογϣϯ༻ͷ/PUFCPPLΛ։͘ ʮ63-͔ΒʯΛΫϦοΫ ໊લʹ Db2MagicCommand-Demo ͱೖྗ /PUFCPPL63-ʹҎԼΛίϐʔϖʔετͰೖྗ https://github.com/kyokonishito/db2magic-cmd-sample/blob/main/Db2MagicCommand-Demo.ipynb ʮ࡞ʯΛΫϦοΫ
ηογϣϯͰ༻͢Δ OPUFCPPL͕ಡΈࠐ·Ε·͢ɻ IBM Data & AI / © 2022 IBM Corporation 22 -
Ҏޙ/PUFCPPLͰઆ໌͠·͢ IBM Data & AI / © 2022 IBM Corporation
25 Notebookのソース: https://github.com/kyokonishito/db2magic-cmd-sample/blob/main/Db2MagicCommand-Demo.ipynb -
"QQFOEJY อଘͨ͠$47σʔλΛ֬ೝ 28 IBM Data & AI / © 2022
IBM Corporation -
·ͱΊ 35 IBM Data & AI / © 2022 IBM
Corporation -
·ͱΊ +VQZUFS /PUFCPPL͔Β %C .BHJD ίϚϯυͰ%CʹΒ͘Β͘ΞΫηεͰ͖·͢👍 ͬͱ͍Ζ͍ΖͳίϚϯυͷ͍ํ ͪ͜ΒΛࢀরɿIUUQTTQFBLFSEFDLDPNLZPLPOJTIJUPECBOEKVQZUFSOPUFCPPLT ·ͨຊՈ(JUIVC SFQPTJUPSZΛࢀর͍ͯͩ͘͠͞
ӳޠ ࠷৽ͷใͪ͜ΒʹͳΓ·͢ɻ https://github.com/IBM/db2-jupyter IBM Data & AI / © 2022 IBM Corporation 36 -
ϫʔΫγϣοϓɺηογϣϯɺ͓Αͼࢿྉɺ*#.·ͨηογϣϯൃදऀʹΑͬͯ४උ͞ΕɺͦΕͧΕಠࣗͷݟղΛөͨ͠ͷͰ͢ɻͦΕΒใఏڙͷతͷΈ Ͱఏڙ͞Ε͓ͯΓɺ͍͔ͳΔࢀՃऀʹରͯ͠๏త·ͨͦͷଞͷࢦಋॿݴΛҙਤͨ͠ͷͰͳ͘ɺ·ͨͦͷΑ͏ͳ݁ՌΛੜΉͷͰ͋Γ·ͤΜɻຊߨԋࢿྉ ʹؚ·Ε͍ͯΔใʹ͍ͭͯɺશੑͱਖ਼֬ੑΛظ͢ΔΑ͏ྗ͠·͕ͨ͠ɺʮݱঢ়ͷ··ʯఏڙ͞Εɺ໌ࣔ·ͨ҉ࣔʹ͔͔ΘΒ͍͔ͣͳΔอূΘͳ͍ͷͱ ͠·͢ɻຊߨԋࢿྉ·ͨͦͷଞͷࢿྉͷ༻ʹΑͬͯɺ͋Δ͍ͦͷଞͷؔ࿈ʹΑͬͯɺ͍͔ͳΔଛ͕ੜͨ͡߹ɺ*#.ΛෛΘͳ͍ͷͱ͠·͢ɻ ຊߨԋ ࢿྉʹؚ·Ε͍ͯΔ༰ɺ*#.·ͨͦͷαϓϥΠϠʔϥΠηϯεަऀ͔Β͍͔ͳΔอূ·ͨද໌ΛҾ͖ͩ͢͜ͱΛҙਤͨ͠ͷͰɺ*#.ιϑτΣΞͷ༻ Λنఆ͢Δద༻ϥΠηϯεܖͷ߲Λมߋ͢Δ͜ͱΛҙਤͨ͠ͷͰͳ͘ɺ·ͨͦͷΑ͏ͳ݁ՌΛੜΉͷͰ͋Γ·ͤΜɻ ຊߨԋࢿྉͰ*#.ɺϓϩάϥϜɺ·ͨαʔϏεʹݴٴ͍ͯͯ͠ɺ*#.͕Ӧۀ׆ಈΛߦ͍ͬͯΔͯ͢ͷࠃͰͦΕΒ͕༻ՄೳͰ͋Δ͜ͱΛ҉ࣔ͢ΔͷͰ͋Γ ·ͤΜɻຊߨԋࢿྉͰݴٴ͍ͯ͠ΔϦϦʔεػೳɺࢢػձ·ͨͦͷଞͷཁҼʹج͍ͮͯ*#.ಠࣗͷܾఆݖΛ͍ͬͯͭͰมߋͰ͖Δͷͱ͠ɺ ͍͔ͳΔํ๏ʹ͓͍ͯকདྷͷ·ͨػೳ͕༻ՄೳʹͳΔͱ֬͢Δ͜ͱΛҙਤͨ͠ͷͰ͋Γ·ͤΜɻຊߨԋࢿྉʹؚ·Ε͍ͯΔ༰ɺࢀՃऀ͕։࢝͢Δ
׆ಈʹΑͬͯಛఆͷൢചɺച্ߴͷ্ɺ·ͨͦͷଞͷ݁Ռ͕ੜ͡Δͱड़Δɺ·ͨ҉ࣔ͢Δ͜ͱΛҙਤͨ͠ͷͰɺ·ͨͦͷΑ͏ͳ݁ՌΛੜΉͷͰ͋Γ· ͤΜɻ ύϑΥʔϚϯεɺཧ͞Εͨڥʹ͓͍ͯඪ४తͳ*#.ϕϯνϚʔΫΛ༻ͨ͠ଌఆͱ༧ଌʹج͍͍ͮͯ·͢ɻϢʔβʔ͕ܦݧ͢Δ࣮ࡍͷεϧʔϓοτύ ϑΥʔϚϯεɺϢʔβʔͷδϣϒɾετϦʔϜʹ͓͚ΔϚϧνϓϩάϥϛϯάͷྔɺೖग़ྗߏɺετϨʔδߏɺ͓Αͼॲཧ͞ΕΔϫʔΫϩʔυͳͲͷߟྀࣄ߲Λ ؚΉɺଟ͘ͷཁҼʹԠͯ͡มԽ͠·͢ɻ͕ͨͬͯ͠ɺݸʑͷϢʔβʔ͕͜͜Ͱड़ΒΕ͍ͯΔͷͱಉ༷ͷ݁ՌΛಘΒΕΔͱ֬͢ΔͷͰ͋Γ·ͤΜɻ هड़͞Ε͍ͯΔͯ͢ͷ͓٬༷ࣄྫɺͦΕΒͷ͓٬༷͕ͲͷΑ͏ʹ*#.Λ༻͔ͨ͠ɺ·ͨͦΕΒͷ͓٬༷͕ୡͨ݁͠Ռͷ࣮ྫͱͯࣔ͠͞ΕͨͷͰ͢ɻ࣮ࡍ ͷڥίετ͓ΑͼύϑΥʔϚϯεಛੑɺ͓٬༷͝ͱʹҟͳΔ߹͕͋Γ·͢ɻ *#.ɺ*#.ϩΰɺJCNDPNɺ*#.$MPVE %Cɺ ੈքͷଟ͘ͷࠃͰొ͞Εͨ*OUFSOBUJPOBM#VTJOFTT.BDIJOFT$PSQPSBUJPOͷඪͰ͢ɻଞͷ໊͓ΑͼαʔϏε ໊ɺͦΕͧΕ*#.·֤ͨࣾͷඪͰ͋Δ߹͕͋Γ·͢ɻݱ࣌Ͱͷ *#.ͷඪϦετʹ͍ͭͯɺXXXJCNDPNMFHBMDPQZUSBEFTIUNMΛ͝ཡ͍ͩ͘͞ɻ .JDSPTPGU 8JOEPXT 7JTVBM4UVEJPɺ.JDSPTPGU$PSQPSBUJPOͷඪ·ͨొඪͰ͢ɻ .BDถࠃͦͷଞͷࠃͰొ͞Εͨ"QQMF *ODͷඪͰ͢ɻ 1ZUIPOɼ1ZUIPO4PGUXBSF'PVOEBUJPOͷొඪ Ͱ͢ɻ +VQZUFS ɼ/VN'0$64 GPVOEBUJPOͷొඪͰ͢ɻ (PPHMFɺ $P-BCPSBUPSZɺ (PPHMF--$ͷඪͰ͢ɻ (JU)VC ɺ(JU)VC *ODͷඪ·ͨొඪͰ͢ɻ BoxはBox Inc.の商標または登録商標です。