イチから学ぶdbt / Learn dbt from scratch

X Πν͔ΒֶͿECU ʙΠν͔Β࢝ΊΔσʔλ׆༻ʂि࿈ଓ΢ΣϏφʔʙ ೥݄೔ ໦ ΫϥεϝιουגࣜձࣾΞϥΠΞϯεࣄۀ෦͠Μ΍

ΞδΣϯμ ͸͡Ίʹ Q෼ ECUશମ֓ཁ Q෼ ECU$MPVEΛΦεεϝ͢Δཧ༝ Q෼
ECUECU$MPVEւ֎ࣄྫͷ঺հ Q෼ ECU$MPVEͷτϨʔχϯά1P$ࢧԉΩϟϯϖʔϯʹ͍ͭͯ Q෼

͸͡Ίʹ എܠը૾ɿ0WFSDPNJOHDPNQMFYJUZUIFCJHHFTUOFXECU$MPVEGFBUVSFTGSPN$PBMFTDF IUUQTXXXHFUECUDPNCMPHOFXECUDMPVEGFBUVSFTBOOPVODFEBUDPBMFTDF

ࣗݾ঺հ ɾ೥݄Ϋϥεϝιουʹத్ೖࣾɺΫϥεϝιου೥໨ ɾ೥݄ΞϥΠΞϯεࣄۀ෦ʹҟಈϞμϯσʔλελοΫ .%4 νʔϜʹॴଐ ɾೖࣾҎདྷʮຖ೥ຊҎ্ͷϒϩά౤ߘʯΛܧଓத ͠Μ΍c%FWFMPQFST*0IUUQTEFWDMBTTNFUIPEKQBVUIPSTIJOZBB

ձࣾ঺հ Φʔϓϯͳൃ૝ͱߴ͍ٕज़ྗʹΑΓ͢΂ͯͷਓʑͷ૑଄׆ಈʹߩݙ͠ଓ͚Δ ໊শɹɹ Ϋϥεϝιουגࣜձࣾ ୅දऀɹ ԣా ૱ ઃ ཱɹɹ2004೥7݄7೔
ຊ ࣾɹɹ౦ژ౎ߓ۠੢৽ڮ1ʵ1ʵ1 ɹɹɹɹ ೔ൺ୩ϑΥʔτλϫʔ26֊ ڌ ఺ɹɹ౦ژɺࡳຈɺઋ୆ɺ্ӽɺ໊ݹ԰ɺେࡕɺ෱Ԭɺ ɹɹɹɹ ԭೄɺϕϧϦϯɺόϯΫʔόʔɺϗʔνϛϯɺ ɹɹɹɹ όϯίΫɺι΢ϧ ࢿຊۚɹ 1ԯԁ ैۀһɹ 700໊ʢ2023೥9݄ݱࡏ/άϧʔϓશମʣ ➢ 2023೥AWSΞδΞ࠷༏लSIύʔτφʔͱͯ͠ ɹ SI Partner of the Year – APJड৆ ➢ 2023೥SI Partner of the Year - GlobalϑΝΠφϦετ ➢ 8೥࿈ଓύʔτφʔ࠷্ҐAWSϓϨϛΞςΟΞ  αʔϏεύʔτφʔೝఆ ➢ AWSެࣜࢿ֨औಘ਺͸2,000Φʔόʔ

Ϋϥεϝιουઃཱप೥Λॕͯ͠ߦ͏ ্࢙࠷େͷςοΫͱϏδωεͷࡇయ ೥݄։࠵༧ఆͷෳ਺೔ظؒΠϕϯτ ΦϯϥΠϯˍΦϑϥΠϯ։࠵Λ૝ఆ *5ۀք಺֎ͷஶ໊ਓଟ਺ొஃ༧ఆ $MBTTNFUIPE0EZTTFZ IUUQTDMBTTNFUIPEKQNPEZTTFZ

σʔλ׆༻Λࢧ͑ΔαʔϏε ΫϥεϝιουͰ͸σʔλ׆༻Λࢧ͑Δ֤छαʔϏεͷಋೖɾӡ༻Λαϙʔτ͍ͯ͠·͢ɻ ֤αʔϏεΛ૊Έ߹Θͤͯ࢖͏͜ͱͰɺΑΓ؆୯ʹσʔλ෼ੳΛߦ͏؀ڥͮ͘ΓΛ͓ख఻͍͠·͢ɻ σʔλ׆༻cύʔτφʔ੡඼cΫϥεϝιουגࣜձࣾ IUUQTDMBTTNFUIPEKQQBSUOFSDBUFHPSZNPEFSOEBUBTUBDL

ຊ೔͸γϦʔζશճͷ͏ͪͷճ໨ECUճͰ͢ ✅ Ր Πν͔ΒֶͿσʔλϝογϡʹΑΔσʔλΨόφϯε ϝιυϩδοΫനੴ༷ ✅ ਫ Πν͔ΒֶͿ4OPX
fl BLF ϝιυϩδοΫനੴ༷ ✅ ਫ Πν͔ΒֶͿ%BUBCSJDLT ϝιυϩδοΫനੴ༷ ✅ ਫ Πν͔ΒֶͿ*NNVUB Ϋϥεϝιου҆ݪ๎ل ✅ ໦ Πν͔ΒֶͿ'JWFUSBO Ϋϥεϝιουεζ ▶ ໦ Πν͔ΒֶͿECU Ϋϥεϝιου͠Μ΍ ਫ Πν͔ΒֶͿ)JHIUPVDI ϝιυϩδοΫനੴ༷ ਫ Πν͔ΒֶͿ-PPLFS ΫϥεϝιουJLVNJ ʲຖि։࠵ʳϝιυϩδοΫࣾڞ࠵ʂΠν͔Β࢝ΊΔσʔλ׆༻ʂि࿈ଓ΢ΣϏφʔc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQOFXTXFFL@XFCJOBS

ECUશମ֓ཁ എܠը૾ɿ0WFSDPNJOHDPNQMFYJUZUIFCJHHFTUOFXECU$MPVEGFBUVSFTGSPN$PBMFTDF IUUQTXXXHFUECUDPNCMPHOFXECUDMPVEGFBUVSFTBOOPVODFEBUDPBMFTDF

ʮECUʯͱ͸ҰମԿͳͷ͔ʁ ɾྺ࢙ ɹɾ೥جຊతͳม׵ػೳΛ௥Ճ͢ΔιϦϡʔγϣϯͱͯ͠։ൃ։࢝ ɹɾ೥2ςετػೳ௥Ճ ɹɾ೥2$*$%ػೳ௥Ճ ɹɾ೥2υΩϡϝϯτػೳ௥Ճ ɹɾ೥2ECU-FBO։࢝ ɹɾ೥2ECU$MPVEʹ*%&௥Ճ ɹɾ೥2ॳͷΧϯϑΝϨϯε։࠵
ɹɾ೥ECU4FNBOUJD-BZFS 1ZUIPOαϙʔτ ɹɾ೥ECU.FTI ECU&YQMPSFS %BUBCVJMEUPPM8JLJQFEJB IUUQTFOXJLJQFEJBPSHXJLJ%BUB@CVJME@UPPM 8IZZPV ZFTZPV TIPVMEDPOTJEFSKPJOJOHUIFECU-BCTNBSLFUJOHUFBNcCZ+BOFTTB-BOU[c.FEJVN IUUQTKBOFTTBMBOU[NFEJVNDPNXIZZPVZFTZPVTIPVMEDPOTJEFSKPJOJOHUIFECUMBCTNBSLFUJOHUFBNEFFB

ʮECUʯͱ͸ҰମԿͳͷ͔ʁ ɾEBUBCVJMEUPPM ɾσʔλ෼ੳ؀ڥʹ͓͚Δม׵ॲཧɺॴҦ&-5ॲཧͷz5 5SBOTGPSNBUJPOม׵ ͷ෦෼Λ୲͏ϓϩμΫτ ɾΞφϦετ΍ΤϯδχΞ͕΢ΣΞϋ΢ε಺ͷσʔλΛΑΓޮՌతʹม׵͢Δͷʹ༗༻ ɾϞσϧ .PEFM ͱ͍͏֓೦Ͱม׵ॲཧΛϞδϡʔϧԽͯ͠؅ཧ
ɹɾม׵ॲཧ͸42- ·ͨ͸1ZUIPO Ͱ࣮૷ ɾϞσϧ؅ཧҎ֎ʹ΋σʔλม׵ॲཧपΓʹؔ͢Δ༷ʑͳػೳ΋උ͍͑ͯΔ ɹɾςετɺυΩϡϝϯτɺϞσϧؒͷґଘؔ܎؅ཧ౳ͳͲ ɾσʔλ෼ੳք۾ͷ֤छαʔϏε࿈ܞɺల։΋๛෋ ΤίγεςϜ ɾҎԼͭͷϓϩμΫτల։ ɹɾECU$PSFɿΦʔϓϯιʔεແྉίϚϯυϥΠϯϕʔε ɹɾECU$MPVEɿ4BB4ແྉˍ༗ঈ(6*ˍίϚϯυϥΠϯซ༻ ECU-BCTc5SBOTGPSN%BUBJO:PVS8BSFIPVTFIUUQTXXXHFUECUDPN

ECUͷݱঢ়Λද͢ʮ਺ࣈʯ "CPVUECU-BCTIUUQTXXXHFUECUDPNECUMBCTBCPVUVT ECUͷΧϯϑΝϨϯεΠϕϯτʰ$PBMFTDFʱجௐߨԋΦϯϥΠϯࢹௌϨϙʔτECU$PBMFTDF$PBMFTDFc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTSFQPSUECUDPBMFDTFLFZOPUF ར༻ࣾ਺ɿສࣾ ECU$MPVEͷར༻ऀ਺ɿਓ௒ ೝఆΤϯδχΞɿਓ ίϛϡχςΟϝϯόʔ਺ɿສਓ ࣮Քಇ؀ڥͰECUΛར༻͍ͯ͠Δ૊৫ɿສ௒
શੈքʹల։͢ΔECUίϛϡχςΟɿΧࠃάϧʔϓ Ϟσϧ ࣮૷42-ͷ࣮ߦ ݺͼग़͠ɿ ɹ೥݄͚ͩͰສճɺྦྷܭԯճ

ɾσʔλνʔϜ͕෼ੳΤϯδχΞϦϯάͷϕετϓϥΫςΟεΛ࢖༻ͯ͠ ɹσʔλΛม׵ग़དྷΔΑ͏ʹ͢Δπʔϧ ɾΦʔϓϯιʔεແྉ ɾίϚϯυϥΠϯπʔϧͱͯ͠04؀ڥʹಋೖɺॲཧ಺༰ʹԠͯ͡ίϚϯυΛ࣮ߦ ECU$PSF͸Ͳ͏͍͏ϓϩμΫτͳͷ͔ ECUJOJU ϓϩδΣΫτͷॳظԽ ECUDMPOF ϞσϧΛෳ੡
ECUDPNQJMF ϞσϧͷίϯύΠϧ ࣮ߦ͸͠ͳ͍ ECUEFQT ର৅ϓϩδΣΫτͷґଘؔ܎Λղܾ ECUCVJME બ୒ϦιʔεͷςετͱϏϧυΛ࣮ࢪ ECUQBSTF ϓϩδΣΫτΛղੳ ECUUFTU ର৅ϓϩδΣΫτ಺ͷςετΛ࣮ߦ ECUSFUSZ ࠷ޙʹ࣮ߦͨ͠ECUίϚϯυΛ࠶࣮ߦ ECUEFCVH ઀ଓઃఆͱϓϩδΣΫτͷσόοά ECUSVOPQFSBUJPO %#ʹର͢Δ೚ҙͷϝϯςφϯε42-࣮ߦ ECUSVO ର৅ϓϩδΣΫτ಺ͷϞσϧ ॲཧ Λ࣮ߦ ECUTFFE $47ϑΝΠϧΛ%8)ʹಡΈࠐΉ ECUDMFBO ର৅ϓϩδΣΫτ಺੒Ռ෺Λ࡟আ ECUTIPX มߋޙͷςʔϒϧߦΛϓϨϏϡʔ ECUMJTU ϓϩδΣΫτ಺ఆٛϦιʔεΛҰཡදࣔ ECUTOBQTIPU ϓϩδΣΫτఆٛͷεφοϓγϣοτ࣮ߦ ECUEPDT ର৅ϓϩδΣΫτͷυΩϡϝϯτੜ੒ ECUTPVSDF ιʔεσʔλૢ࡞ͷͨΊͷπʔϧΛఏڙ ECU$PNNBOESFGFSFODFcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNSFGFSFODFECUDPNNBOET

ECU$MPVE͸Ͳ͏͍͏ϓϩμΫτͳͷ͔ ɾECUΛಋೖ͢ΔͨΊͷ࠷΋଎͍ɺ࠷΋৴པੑͷߴ͍ํ๏ ɾ4BB4ແྉ %FWFMPQFSϓϥϯ ʙ༗ঈ 5FBN·ͨ͸&OUFSQSJTFϓϥϯ ɾ8FCϕʔεͷ6*Ͱશͯͷૢ࡞Λߦ͏ ɹɾECU$MPVE$-*ͰίϚϯυϥΠϯΛ࢖༻ͨ͠։ൃ΋αϙʔτ
ʻओͳػೳʼ ɾECU$MPVE*%& ૯߹։ൃ؀ڥ ɾݸผ؀ڥ ࣮Քಇ؀ڥͱ։ൃ؀ڥ ͷηοτΞοϓ΍؅ཧ ɾECUδϣϒͷεέδϡʔϧ࣮ߦ ɾδϣϒ࣮ߦ݁Ռͷ௨஌ػೳ ɾECUϓϩδΣΫτͷυΩϡϝϯτΛϗετͯ͠ڞ༗Մೳ ɾ(JU)VCɺ(JU-BCɺ"[VSF%FW01TΛαϙʔτ ɾܧଓతΠϯςάϨʔγϣϯ $* ɾηΩϡϦςΟ໘ͷڧԽ ɾECUηϚϯςΟοΫϨΠϠʔ ɾ%JTDPWFSZ"1* ˞ ɾδϣϒ࣮ߦཤྺ ɾECUΤΫεϓϩʔϥʔ ˞ ɾΩʔϘʔυγϣʔτΧοτ ɾϑΝΠϧͷঢ়ଶΛදࣔ ɾIDEܦ༝Ͱgitόʔδϣϯ؅ཧ ɾϓϩδΣΫτͷυΩϡϝϯτΛੜ੒ɾ࿈ܞ ɾϓϨϏϡʔɺίϯύΠϧ) ɾϏϧυɺςετɺ࣮ߦΛϘλϯͰૢ࡞ ɾίϚϯυόʔܦ༝ͰdbtίϚϯυΛ࣮ߦ ɾϑΝΠϧΤΫεϓϩʔϥܦ༝ͰϑΝΠϧͷυϥοάˍυϩοϓૢ࡞ ɾλϒͱϑΝΠϧΛ੔ཧ ɾϑΝΠϧͷݕࡧˍஔ׵ ɾཁૉͷෳ਺બ୒ ɾϘλϯΫϦοΫͰίʔυͷϑΥʔϚοτɾ੔ܗ ɾGitͷࠩ෼Ϗϡʔ ɾ։ൃͷߴ଎Խʹ໾ཱ֤ͭछΦʔτίϯϓϦʔτػೳ ɾIDE্ͰDAGදࣔ ɾεςʔλεόʔ ɾϒϥ΢βͷදࣔϞʔυΛϥΠτ/μʔΫʹ੾Γସ͑Մೳ

ECU$MPVEʹ͓͚Δߏ੒ཁૉͷؔ܎ੑ <ECU$MPVEΞΧ΢ϯτͱϓϩδΣΫτ ECU1SPKFDU > ɾECU$MPVEΞΧ΢ϯτ͸ϢʔβʔͱECUϓϩδΣΫτΛ࣋ͭ ɹɾϢʔβʔɿECUϓϩδΣΫτʹର͢Δૢ࡞Λߦ͏ ɹɾϓϩδΣΫτɿ೚ҙͷυϝΠϯྖҬʹ͓͚Δɺม׵ॲཧΛߦ͏ͨΊͷ ɹɹॲཧϓϩάϥϜ΍ઃఆϑΝΠϧҰࣜΛ؅ཧ͢Δ୯Ґ ɹɾϢʔβʔ͸ϩʔϧʹΑͬͯݖݶ͕ఆΊΒΕ͍ͯΔ
ɹɾϢʔβʔ͸ECUϓϩδΣΫτʹΞΫηε ɾECU$MPVEʹ͓͚ΔϢʔβʔΞΧ΢ϯτ੍ݶ ɹɾ%FWFMPQFSϓϥϯɿϢʔβʔͷΈ ɹɾ5FBNϓϥϯɿ։ൃऀɿਓ·ͰɺಡΈऔΓઐ༻ɿਓ·Ͱ ɹɾ&OUFSQSJTFϓϥϯɿແ੍ݶʹ௥ՃՄೳ ɾECU$MPVEʹ͓͚ΔϓϩδΣΫτ਺ͷ੍ݶ ɹɾ%FWFMPQFSϓϥϯɺ5FBNϓϥϯɿ࠷େͭ ɹɾ&OUFSQSJTFϓϥϯɿແ੍ݶʹ௥ՃՄೳ "CPVUECUQSPKFDUTcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTCVJMEQSPKFDUT 6TFSTBOEMJDFOTFTcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTTFBUTBOEVTFST "CPVUVTFSBDDFTTJOECU$MPVEcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTBCPVUVTFSBDDFTT

ECUͷϓϩδΣΫτߏ଄ JOECU$MPVE

ECUͷϓϩδΣΫτߏ଄ JOECU$MPVE ɾECU@QSPKFDUZNMɿECUϓϩδΣΫτͷجຊઃఆɺ֤छύε৘ใΛ؅ཧ ɾNPEFMTɿECUͰ࡞੒ɺ؅ཧɺ࿈ܞ͢ΔʰϞσϧʱͷ৘ใΛϨΠϠʔ෼͚ͯ͠؅ཧ ɹɾYYYYYYYTRMɿม׵ॲཧΛهड़ɻϑΝΠϧ໊ʹςʔϒϧ໊ͱͯ͠ॲཧ͞ΕΔ ɹɾYYYYYYYZNMɿରԠ͢ΔϞσϧͷ֤छ৘ใΛ؅ཧɻςετ΍υΩϡϝϯτ৘ใ΋هࡌ ɾBOBMZTFTɿϞσϧ؅ཧ͠ͳ͍͕෼ੳ༻్౳Ͱѻ͍͍ͨ42-Λ؅ཧ ɾNBDSPTɿԿ౓Ͱ΋ར༻ग़དྷΔ+JOKBίʔυΛϚΫϩͱͯ͠ఆٛɾ؅ཧ ɾTFFETɹɿECUϓϩδΣΫτ಺Ͱ؅ཧՄೳͳ$47ϑΝΠϧΛ֨ೲ
ɾTOBQTIPUTɿECUͰར༻͢Δ%8)ͷཤྺ৘ใΛ؅ཧ ɾUFTUTɹɹɿϞσϧʹର͢ΔςετΛهड़ͨ͠42-Λ؅ཧ ɾQBDLBHFTZNMɿECUʹΠϯϙʔτͯ͠࢖͑ΔϥΠϒϥϦػೳͷ৘ใΛ؅ཧ <ϓϩδΣΫτ ECU1SPKFDU ಺ͷ֤छߏ੒ཁૉ>

ECU$MPVEͷ42-ॲཧΠϝʔδ <ैདྷͷόονॲཧΠϝʔδ>

ECU$MPVEͷ42-ॲཧΠϝʔδ <ECU$MPVEʹ͓͚Δ42-ॲཧΠϝʔδ>

ECU$MPVEͷ42-ॲཧΠϝʔδ <ECU$MPVEʹ͓͚Δ42-ॲཧΠϝʔδ> 2ECU͸ΫΤϦॲཧͷ݁ՌΛ಺෦ʹอ࣋͢Δͷ͔ʁ "͠·ͤΜɻ 2ECU$MPVE͸σʔλ΢ΣΞϋ΢εʹΞΫηεͨ͠σʔλΛอ࣋͢Δͷ͔ʁECUc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTRVFTUJPOEPFTECUDMPVESFUBJOUIFEBUBBDDFTTFEJOUIFEBUBXBSFIPVTF

ECUͷཁ͸ʰϞσϧʱͷ։ൃ42-ͷ࣮૷ <ECUʹ͓͚Δ42-Ϟσϧͷ࣮૷಺༰> ɾϞσϧ໊͸ϑΝΠϧ໊ΑΓܧঝ͞ΕΔ ɾdbt runίϚϯυΛ࣮ߦ͢ΔͱɺECU͸هࡌͨ͠42-Λ ɹcreate view as·ͨ͸create table
asεςʔτϝϯτ ɹͱͯ͠ίϯύΠϧˍ࣮ߦ ɾϞσϧ಺Ͱ͸ଞͷϞσϧɺιʔεσʔλɺϚΫϩΛࢀরՄೳ ɾ+JOKBΛ׆༻ͯ͠ଞͷΤϯςΟςΟΛࢀরͨ͠Γɺ42-্Ͱ͸ ɹ௨ৗग़དྷͳ͍Α͏ͳࣄΛ࣮૷ల։ग़དྷͨΓ΋͢Δ ɾϚςϦΞϥΠθʔγϣϯ ӬଓԽख๏ ͷઃఆ಺༰ʹԠͯ͡ ɹϞσϧͷग़ྗΛϏϡʔ΍ςʔϒϧ౳ʹอଘͰ͖Δ ɾ42-ͷॻ͖ํ ɹɾ֤42-ϑΝΠϧ͸ͭͷ4&-&$5จ͔ΒͳΔ ɹɾࠨهͷΑ͏ʹଟ਺ͷ$5& $PNNPO5BCMF&YQSFTTJPO ɹɹڞ௨ςʔϒϧࣜ Ͱॻ͔ΕΔ͜ͱ͕ଟ͍ɺͱ͍͏͔ਪ঑

ECUͷཁ͸ʰϞσϧʱͷ։ൃ42-ͷ࣮૷ <ͳͥz4&-&$5จͰهड़z͢Δͷ͔ʁ> 2ม׵ॲཧʹԙ͍ͯ%.-Λهड़ग़དྷͳ͍ͷ͸ͳͥͰ͔͢ʁ "ҎԼͷཧ༝΍എܠ͕͋Γ·͢ɻ TFMFDUεςʔτϝϯτʹΑΓม׵ʹΞΫηεͰ͖ΔΑ͏ʹͳΔͨΊ ɹ%.-ΑΓ΋બ୒εςʔτϝϯτͷॻ͖ํΛ஌͍ͬͯΔਓ͕ଟ͍ͨΊɺΑΓଟ͘ͷਓ͕ม׵ϨΠϠʔʹΞΫηεͰ͖ΔΑ͏ʹͳΓ·͢ɻ ద੾ͳ%.-Λॻ͘ͷ͸೉͍͠ ɹ%%-%.-Λࣗ෼Ͱ࡞੒͢Δͱɺ࣍ͷΑ͏ͳ໰୊ʹר͖ࠐ·ΕΔՄೳੑ͕͋Γ·͢ɻ ɹɾςʔϒϧ͕͢Ͱʹଘࡏ͢Δ৔߹͸Ͳ͏ͳΓ·͔͢
ͦΕͱ΋ɺ͜ͷςʔϒϧ͸͢ͰʹϏϡʔͱͯ͠ଘࡏ͍ͯ͠·͕͢ɺࠓ౓͸ςʔϒϧʹ͍ͨ͠ͷͰ͠ΐ͏͔ ɹɾεΩʔϚ͕͢Ͱʹଘࡏ͢Δ৔߹͸Ͳ͏ͳΓ·͔͢ ͦΕͱ΋ɺεΩʔϚ͕͢Ͱʹଘࡏ͢Δ͔Ͳ͏͔Λ֬ೝ͢Δඞཁ͕͋Γ·͔͢ ɹɾϞσϧΛΞτϛοΫʹஔ͖׵͑Δʹ͸Ͳ͏͢Ε͹Α͍Ͱ͔͢ ςʔϒϧΛΫΤϦ͢Δਓʹμ΢ϯλΠϜ͕ൃੜ͠ͳ͍Α͏ʹ ɹɾ։ൃ؀ڥͰ͜ΕΒͷม׵Λ࣮ߦͰ͖ΔΑ͏ʹεΩʔϚΛύϥϝʔλԽ͍ͨ͠৔߹͸Ͳ͏͢Ε͹Α͍Ͱ͔͢ ɹɾ͜ΕΒͷεςʔτϝϯτΛͲͷॱংͰ࣮ߦ͢Δඞཁ͕͋Γ·͔͢ ΧεέʔυΛ࣮ߦ͢Δͱଞͷ΋ͷ͕յΕ·͔͢ ɹ͜ΕΒͷ໰୊͸ͦΕͧΕղܾͰ͖·͕͢ɺ࣌ؒΛ࠷େݶʹ׆༻Ͱ͖Δͱ͸ߟ͑ΒΕ·ͤΜɻ ECU͸42-Λੜ੒͢Δ͚ͩͰ͸͋Γ·ͤΜ ɹɾϞσϧͷςετɺυΩϡϝϯτͷੜ੒ɺεφοϓγϣοτͷ࡞੒ͳͲΛߦ͏͜ͱ͕Ͱ͖·͢ɻ ϕϯμʔϩοΫΠϯΛܰݮͷͨΊ ɹɾ42-ݴޠ͸ɺ TFMFDUεςʔτϝϯτͰ͸ͳ͘ %.-ͱ%%-Ͱ࠷΋෼ذ͢Δ܏޲͕͋Γ·͢ɻ ɹɹ࡞੒͢Δ42-ͷྔΛݮΒ͢͜ͱͰɺ৽͍͠σʔλϕʔεςΫϊϩδ΁ͷҠߦ͕༰қʹͳΓ·͢ɻ ɹɾΧελϜ%.-Λهड़͢Δඞཁ͕͋Δ৔߹͸ɺΧελϜϚςϦΞϥΠθʔγϣϯΛ࢖༻ͯ͠ECUͰ͜ΕΛߦ͏ํ๏͕͋Γ·͢ɻ 42-NPEFMTcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTCVJMETRMNPEFMT

ECUͷཁ͸ʰϞσϧʱͷ։ൃ42-ͷ࣮૷ <ͳͥ$5& ڞ௨ςʔϒϧࣜ ͕ਪ঑͞Ε͍ͯΔͷ͔ʁ> $5& $PNNPO5BCMF&YQSFTTJPO Λ࢖༻͢ΔͱɺෳࡶͳΫΤϦΛ૬ޓʹ઀ଓͯ͠ߏஙͰ͖Δ୯७ͳίʔυϒϩοΫʹ෼ׂͰ͖· ͢ɻ͋·ΓܗࣜతͰ͸ͳ͘ɺΑΓਓؒతͳײ֮Ͱݴ͑͹ɺ$5&͸ɺߏங͍ͯ͠Δେن໛ͳΫΤϦ಺ͷಠཱͨ͠খ͞ͳΫΤϦͱͯ͠ߟ͑ Δ͜ͱ͕Ͱ͖·͢ɻ$5&ͷ࡞੒͸ɺجຊతʹɺ࡞੒͍ͯ͠ΔΫΤϦͷ࢒Γͷ෦෼શମͰΞΫηεͰ͖ΔҰ࣌ϏϡʔΛ࡞੒͢Δ͜ͱʹࣅ
͍ͯ·͢ɻ ίʔυʹ$5&Λ࣮૷͢Δओͳಈػ͸ɺΫΤϦͷෳࡶ͞Λ؆ૉԽ͠ɺίʔυͷՄಡੑΛߴΊΔ͜ͱͰ͢ɻ ΫΤϦͰ$5&Λ࢖༻͢Δ͜ͱʹ͸ଞʹ΋େ͖ͳར఺͕͋Γ·͢ɻ͜Εʹ͍ͭͯ͸ɺҎԼͰઆ໌͠·͢ɻ ɾ؆ུԽɿίʔυͷߏ଄ɺՄಡੑɺσόοΫϓϩηεΛ؆ૉԽͰ͖Δ ɾߏ଄ͷཱ֬ɿίʔυΛখ͞ͳηάϝϯτʹ෼ׂͰ͖ɺίʔυʹߏ଄Λ༩͑Δ͜ͱ͕Ͱ͖Δ ɹ ECU-BCTͰ͸ɺECUϞσϧʹ༧ଌՄೳͰ૊৫Խ͞Εͨߏ଄Λ࡞੒͢ΔɺJNQPSUMPHJDBM fi OBM$5&Λ࢖༻͢Δ͜ͱΛΑ͘޷Ή ɾґଘؔ܎Λ؆୯ʹಛఆɿ$5&Λ׆༻ͨ͠ه๏ͱ͢Δ͜ͱͰϞσϧͷґଘؔ܎͕෼͔Γ΍͘͢ͳΔ ɾίʔυϒϩοΫ΁ͷ໌֬ͳϥϕϧ෇͚͕ՄೳʹɿΫΤϦ࡞੒ऀͱΫΤϦܧঝऀ Ҿ͖ܧ͗ର৅ऀ ૒ํʹϝϦοτ ɾςετͱσόοά͕༰қʹɿΫΤϦΛ$5&ʹ෼ׂ͢Δ͜ͱͰ֤$5&͕ద੾ʹಈ࡞͍ͯ͠Δ͔Λςετ͢Δ͜ͱ΋༰қʹ ɾϏϡʔͷஔ׵ɿ$5&Λ࢖ͬͯϏϡʔ͔ΒඞཁͳҰ࣌తͳ݁ՌΛ࡞੒Ͱ͖Δ ɾ࠶ར༻ੑɿ$5&Λ࢖͏͜ͱͰGSPNεςʔτϝϯτͰ$5&@&913&44*0/@/".&ࢀর͠ΫΤϦͷ࠶ར༻͕Մೳʹ $5&JO42-2VJUFQPTTJCMZUIFCFTUUIJOHUPIBQQFOUP42-IUUQTEPDTHFUECUDPNUFSNTDUF

ECUʹ͓͚Δ42-ͷॻ͖ํɺҠߦ౳ͷϕετϓϥΫςΟε ɾ)PXXFTUZMFPVSECUNPEFMTcECU%FWFMPQFS)VC ɹIUUQTEPDTHFUECUDPNCFTUQSBDUJDFTIPXXFTUZMFIPXXFTUZMFPVSECUNPEFMT ɾ)PXXFTUZMFPVS42-cECU%FWFMPQFS)VC ɹIUUQTEPDTHFUECUDPNCFTUQSBDUJDFTIPXXFTUZMFIPXXFTUZMFPVSTRM ɾ.JHSBUFGSPN%%- %.- BOETUPSFEQSPDFEVSFTcECU%FWFMPQFS)VC ɹIUUQTEPDTHFUECUDPNHVJEFTNJHSBUFGSPNTUPSFEQSPDFEVSFT
TUFQ ɾ3FGBDUPSJOHMFHBDZ42-UPECUcECU%FWFMPQFS)VC ɹIUUQTEPDTHFUECUDPNHVJEFTSFGBDUPSJOHMFHBDZTRM TUFQ ɾ#FTUQSBDUJDFTGPSEBUBNPEFMJOHXJUI42-BOEECUc"JSCZUF ɹIUUQTBJSCZUFDPNCMPHTRMEBUBNPEFMJOHXJUIECU

ͦͷଞϞσϧ։ൃɾ؅ཧΛαϙʔτ͢Δ֤छศརػೳ ʲ+JOKB͕ECUͷ༷ʑͳ৔ॴͰ࢖͑Δʳ ɹɾςϯϓϨʔτݴޠͰ͋Δ+JOKBΛ࢖͍ɺॊೈੑͷߴ੍͍ޚߏ଄΍ॲཧͷల։͕Մೳʹ ʲ.BDSP͕࢖͑Δʳ ɹɾԿ౓΋࠶ར༻ग़དྷΔίʔυஅยΛ࡞੒ɾొ࿥͠ɺ༷ʑͳہ໘Ͱ׆༻Մೳʹ ʲ1BDLBHFΛ࢖༷ͬͯʑͳ༗༻ϥΠϒϥϦΛECUϓϩδΣΫτʹ૊ΈࠐΉ͜ͱ͕ग़དྷΔʳ ɹɾઌਓͷ஌ݟ͕٧·ͬͨ༗༻ϥΠϒϥϦΛϓϩδΣΫτʹΠϯϙʔτͯ͠׆༻Մೳ ʲςετػೳ͕ॆ࣮͓ͯ͠ΓɺECUͰѻ͏σʔλʹର༷ͯ͠ʑͳςετ͕ߦ͑Δʳ ɹɾ୯Ұςετɺ൚༻ςετɺ୯ମςετɺύοέʔδΛ׆༻༷ͨ͠ʑͳ੾ΓޱͰͷςετΛ࣮ࢪՄೳ
ʲυΩϡϝϯτ࡞੒ػೳ͕ར༻ՄೳɺσʔλΧλϩά΍Ϧωʔδ৘ใ΋͙͢ݟΕΔʳ ɹɾϞσϧʹର͢ΔυΩϡϝϯτઃఆ ओʹ%FTDSJQUJPO Λ͓ͯ͘͜͠ͱͰσʔλΧλϩάతཁૉΛ౿·͑ͨ ɹɹυΩϡϝϯτΛੜ੒ɻECU$MPVEͰ͋Ε͹ίϯςϯπͷల։΋αʔϏε಺Ͱߦͬͯ͘ΕΔ ʲϞσϧ಺ͷઃఆͰࢀর͢ΔଞϞσϧΛࢦఆ͓ͯ͘͜͠ͱͰɺϞσϧؒͷґଘؔ܎Λ%"(Ͱදࣔͯ͘͠ΕΔʳ ɹɾੜσʔλιʔεࢀর༻ͷTPVSDFؔ਺ɺଞςʔϒϧࢀর࣌ʹ༻͍ΔSFGؔ਺Λ࢖ͬͯΫΤϦΛ૊ΜͰ͓͘ͱ ɹɹECU͕ࣗಈͰཁૉؒࢀরΛߏஙɺ%"(ͷܗͰґଘؔ܎Λ෼͔Γ΍͘͢දࣔͯ͘͠ΕΔ

ࠓ೔͓఻͍͑ͨ͠େςʔϚ͸ʜ ͱ͍͏͜ͱͰɺ͜͜·Ͱ͸ ओʹzECUͷ֓ཁzʹ͍ͭͯ આ໌͖ͯ͠·ͨ͠ɻ

ࠓ೔͓఻͍͑ͨ͠େςʔϚ͸ʜ ͔͜͜Β͸ɺECUͷϓϩμΫτͷ ͭͰ͋ΔʰECU$MPVEʱʹ͍ͭͯ ͦͷྑ͞Λ͓఻͍͖͍͑ͯͨ͠ͱࢥ ͍·͢ɻ

ECU$MPVEΛ Φεεϝ͢Δཧ༝ എܠը૾ɿ0WFSDPNJOHDPNQMFYJUZUIFCJHHFTUOFXECU$MPVEGFBUVSFTGSPN$PBMFTDF IUUQTXXXHFUECUDPNCMPHOFXECUDMPVEGFBUVSFTBOOPVODFEBUDPBMFTDF

ECU$PSFͱECU$MPVEͷҧ͍ ECU$PSFͱECU$MPVEͷؔ܎ੑɾҧ͍ͳͲʹ͍ͭͯ·ͱΊͯΈͨECUc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTEJ ff FSFODFTCFUXFFOECUDPSFBOEECUDMPVE ߲໨ ECU$PSF ECU$MPVE αʔϏεར༻ܗଶ
Φʔϓϯιʔε1ZUIPOύοέʔδ 4BB4 අ༻ ແঈ ແঈ %FWFMPQFSϓϥϯ ʙ༗ঈ 5FBN&OUFSQSJTFϓϥϯ ૢ࡞ํ๏ ίϚϯυϥΠϯΠϯλϑΣʔε $-* Ͱૢ࡞ 8FCը໘Λհͯ͠ૢ࡞ ಋೖํ๏ lECU$PSFzٴͼzؔ࿈͢Δ%8)zͷ 1ZUIPOύοέʔδΛΠϯετʔϧ %8)΍(JUϦϙδτϦ৘ใΛ४උͷ্8FCը໘Λհͯ͠ ECUϓϩδΣΫτΛ࡞੒ ग़དྷΔ͜ͱ ECU$PSF͕ఏڙ͍ͯ͠ΔίϚϯυૢ࡞ ECU$PSF͕ఏڙ͍ͯ͠ΔίϚϯυૢ࡞ٴͼ ECU$MPVE͕ఏڙ͍ͯ͠Δ֤छػೳ΍8FCը໘্Ͱͷૢ࡞

ECU$PSFͱECU$MPVEͷҧ͍ ECU$PSFͱECU$MPVEͷؔ܎ੑɾҧ͍ͳͲʹ͍ͭͯ·ͱΊͯΈͨECUc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTEJ ff FSFODFTCFUXFFOECUDPSFBOEECUDMPVE ߲໨ ECU$PSF ECU$MPVE ιʔείʔυͷฤूํ๏
௚ʹΤσΟλ౳ͰϑΝΠϧΛฤू͢Δ͔ɺ ฤू؀ڥΛࣗ෼Ͱ༻ҙઃఆ͢Δඞཁ͕͋Δ ౷߹։ൃ؀ڥ *%& Λར༻͠ɺ֤छิॿͷԸܙΛड͚ͳ͕Β ޮ཰తʹ࡞ۀ͕ग़དྷΔ εέδϡʔϦϯάػೳ ผ్εέδϡʔϧαʔϏε౳ͱ࿈ܞͤ͞Δ͔ɺ ࣗ෼ͰԿΒ͔ͷ࢓૊ΈΛߏங͢Δඞཁ͕͋Δ ར༻Մೳ ECU$MPVE্ͷػೳͱͯ͠ඪ४૷උ "1*αϙʔτ ͳ͍ ͋Δ ϓϩδΣΫτͷ υΩϡϝϯτ υΩϡϝϯτ࡞੒ػೳ͸͋Δ͕ɺυΩϡϝϯτϗετ؀ڥ͸ ͳ͍ͷͰಠࣗʹख഑ɾల։͢Δඞཁ͕͋Δ υΩϡϝϯτ࡞੒ػೳ͕͋Γɺ4BB4؀ڥ಺Ͱࣗಈ࿈ܞɺࢀরՄೳ ઌਐతͳػೳ ར༻ग़དྷͳ͍ ར༻Մೳ ྫ4FNBOUJD-BZFS %BUB.FTI &YQMPSFSͳͲ ܧଓతΠϯςάϨʔγϣϯ $* ͳ͍ ผ్αʔυύʔςΟ੡αʔϏεͱ࿈ܞ͢Δඞཁ͕͋Δ ར༻Մೳ ECU$MPVE্ͷػೳͱͯ͠ඪ४૷උ ηΩϡϦςΟपΓͷରԠ ࣗݾϗετܕͷҝશͯະରԠ શ෦ࣗ෼ୡͰͳΜͱ͔͠ͳ͚Ε͹ͳΒͳ͍ ECU$MPVEଆͰରԠ͞Ε͍ͯΔ΋ͷ͕͋Δ αϙʔτपΓ ͳ͍ ɾڧ͍ͯݴ͑͹ίϛϡχςΟ΍ϑΥʔϥϜͰ ɹࣗ෼ୡͰ৘ใΛऔΓʹߦ͘ˍ୳͘͢Β͍ ͋Δ ɾECU$MPVEΛհͨ͠νέοταϙʔτ ɾϓϥϯʹԠ֤ͨ͡छαϙʔτମ੍ ؀ڥͷ෼཭ ͦ΋ͦ΋ʮ؀ڥʯͱ͍͏֓೦͕ͳ͍ ʮ։ൃ؀ڥʯͱʮຊ൪؀ڥʯΛ෼͚ͯల։ग़དྷΔػೳ͕͋Δ νʔϜͷ֓೦ ͳ͍ ΞΧ΢ϯτ্Ͱෳ਺ϝϯόʔΛট଴Մೳ νʔϜ։ൃʹ΋ରԠ

ECU$MPVE͕ྑ͍Ͷʂͱࢥ͏ز͔ͭͷϙΠϯτ 4BB4؀ڥΛར༻͢Δ͜ͱʹΑΔ֤छઃఆɾ؅ཧ࡞ۀͷखؒΛେ෯ʹ࡟ݮ ECU$PSFʹ͸ແ͍ɺECU$MPVEͰར༻ग़དྷΔ๛෋ͳػೳ܈   ɾ։ൃεϐʔυΛՃ଎ͤ͞ΔECU$MPVE*%& ૯߹։ൃ؀ڥ ͷ֤छػೳ
  ɾ(JUϦϙδτϦ࿈ܞʹΑΔιʔείʔυ΍ઃఆϑΝΠϧͷόʔδϣϯ؅ཧ   ɾม׵ॲཧͷ։ൃ͔Βςετɺӡ༻౳ʹؔ͢Δ֤छػೳΛඪ४૷උ ECU$MPVEͷϓϥϯʹԠ༷ͨ͡ʑͳศརػೳ   ɾECU$MPVE5FBNϓϥϯͰར༻ग़དྷΔػೳ   ɾECU$MPVE&OUFSQSJTFϓϥϯͰར༻ग़དྷΔػೳ   ɹɾ"EWBODFEͳ֤छ෼ੳɺల։ػೳ   ɹɾηΩϡϦςΟपΓͷڧԽ ECUΛғΉʮΤίγεςϜʯ͕ॆ࣮͍ͯ͠Δ νʔϜ։ൃ͕εϜʔζʹਐΊΒΕΔ νέοταϙʔτ͕ड͚ΒΕΔ

֤छઃఆɾ؅ཧ࡞ۀͷखؒΛେ෯ʹ࡟ݮ ηϧϑϗετܕͷECU$PSFͷ৔߹ɺECUपΓͷ؀ڥઃఆɾ࿈ܞ͸શͯϢʔβʔଆͰͷ ηοτΞοϓ͕ඞཁͱͳΓ·͢ɻ ɾECU͕Ϋϥ΢υσʔλϓϥοτϑΥʔϜͰͷσʔλม׵ΛڧԽ ɾϩʔΧϧΠϯετʔϧʹΑΔECUͷ։ൃ ɾ$-*Λ࢖༻ͯ͠HJU fl PXΛ࣮ߦ ɾ,VCFSOFUFT͕؅ཧ͢Δ%PDLFSίϯςφ্ͰECUΛ࣮ߦ
ɾ"JS fl PXɺ1SFGFDUɺ·ͨ͸%BHTUFSΛհͨ͠   ɹECUδϣϒͷΦʔέετϨʔγϣϯ ɾ(JUIVC"DUJPOTɺ"[VSF%FW0QTɺ(JU-BCΛ ɹ࢖༻ͨ͠$*ͷ؅ཧͱઃఆ ɾδϣϒϚχϑΣετΛ#-0#ετϨʔδʹอଘɾ؅ཧ ɾΫϥ΢υίϯϐϡʔςΟϯάͱετϨʔδΛ ɹߏ੒ͯ͠ECUυΩϡϝϯτΛϗεςΟϯά ɾ1ZUIPOͱECUͷόʔδϣϯ؅ཧ ɹɿ ɹɿ

֤छઃఆɾ؅ཧ࡞ۀͷखؒΛେ෯ʹ࡟ݮ 4BB4ܕͷECU$MPVEΛಋೖ͢Δ͜ͱͰɺECU$PSFͰઃఆ͍ͯͨ͠؀ڥઃఆɾ࿈ܞͷखؒΛͳ͘͢ɺ ΋͘͠͸࡟ݮ͢Δ͜ͱ͕Ͱ͖·͢ɻ আڈ࡟ݮ͕ݟࠐΊΔ࡞ۀ ɾશһͷϩʔΧϧϚγϯʹ1ZUIPOͱECUΛΠϯετʔϧ ɾϢʔβʔʹ$-*HJUίϚϯυͱϫʔΫϑϩʔΛڭ͑Δ ɾ%PDLFSίϯςφͰECUΛ࣮ߦ͠ɺ,VCFSOFUFTΫϥελΛ؅ཧ ɾECUδϣϒϚχϑΣετͷ؅ཧͱอଘ ɾECUυΩϡϝϯτͷઃఆͱϗετ
ɾ1ZUIPOͱECUͷόʔδϣϯΛ࠷৽ͷঢ়ଶʹอͪɺಉظ ɾECUδϣϒͷ؂ࢹͱΞϥʔτͷઃఆ

ECU$MPVEͰར༻ग़དྷΔ๛෋ͳػೳ܈ ػೳ๛෋ͳ౷߹։ൃ؀ڥ *%& ͕ECUϓϩδΣΫτ࡞੒ޙ͙͢ʹར༻Ͱ͖·͢ɻECU$PSFͰૢ࡞͢Δ ECUίϚϯυΛؚΊͨଟ࠼ͳػೳΛ༗͍ͯ͠·͢ɻ ɾΩʔϘʔυγϣʔτΧοτ ɾϑΝΠϧͷঢ়ଶΛදࣔ ɾ*%&ܦ༝ͰHJUόʔδϣϯ؅ཧ ɾϓϩδΣΫτͷυΩϡϝϯτΛੜ੒ɾ࿈ܞ
ɾϓϨϏϡʔɺίϯύΠϧ ɾϏϧυɺςετɺ࣮ߦΛϘλϯͰૢ࡞ ɾίϚϯυόʔܦ༝ͰECUίϚϯυΛ࣮ߦ ɾϑΝΠϧΤΫεϓϩʔϥܦ༝ͰϑΝΠϧͷυϥοάˍυϩοϓૢ࡞ ɾλϒͱϑΝΠϧΛ੔ཧ ɾϑΝΠϧͷݕࡧˍஔ׵ ɾཁૉͷෳ਺બ୒ ɾϘλϯΫϦοΫͰίʔυͷϑΥʔϚοτɾ੔ܗ ɾ(JUͷࠩ෼Ϗϡʔ ɾ։ൃͷߴ଎Խʹ໾ཱ֤ͭछΦʔτίϯϓϦʔτػೳ ɾ*%&্Ͱ%"(දࣔ ɾεςʔλεόʔ ɾϒϥ΢βͷදࣔϞʔυΛϥΠτμʔΫʹ੾Γସ͑Մೳ "CPVUUIFECU$MPVE*%&cECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVEECUDMPVEJEFEFWFMPQJOUIFDMPVE *%&VTFSJOUFSGBDFcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVEECUDMPVEJEFJEFVTFSJOUFSGBDF

ECU$MPVEͰར༻ग़དྷΔ๛෋ͳػೳ܈ ຊ൪؀ڥ ࣮Քಇ؀ڥ ͱ։ൃ؀ڥΛ෼͚ͯ؅ཧ͢Δ͜ͱΛ೦಄ʹஔ͍ͨ࢓૊Έ͕ར༻Ͱ͖·͢ɻ ɾ։ൃ؀ڥͰͷ࡞ۀ͸ݸผʹઃఆͨ͠σʔλ΢ΣΞϋ΢ε؀ڥԼͰɺεΩʔϚ΋ݸਓ։ൃ༻ʹ෼͚ͯ؅ཧ ɾϓϧϦΫΤετΛհͨ͠όʔδϣϯ؅ཧԼͰͷݸผ։ൃ࡞ۀ ɾຊ൪؀ڥ͸։ൃ؀ڥͱ͸ผʹ࡞੒ɺෳ਺࡞੒Մೳ ɾຊ൪؀ڥ༻ͷ΢ΣΞϋ΢ε઀ଓ͸ผ్࡞੒ɺ։ൃ؀ڥͱ෼͚ͯ؅ཧ͢Δ͜ͱͰ҆શʹσϓϩΠɺϦϦʔε࡞ۀ͕ߦ͑Δ "CPVUFOWJSPONFOUTcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTFOWJSPONFOUTJOECU

ECU$MPVEͰར༻ग़དྷΔ๛෋ͳػೳ܈ (JUϦϙδτϦ࿈ܞΛը໘ૢ࡞Ͱߦ͑·͢ɻ೉͍͠ίϚϯυૢ࡞Λҙࣝ͢Δ͜ͱແ͘ɺ ·ͨ(JUόʔδϣϯ؅ཧʹ͓͚ΔʰϓϧϦΫΤετʱͷ࢓૊ΈΛECU։ൃʹ૊ΈࠐΉ͜ͱ͕ՄೳͰ͢ɻ ɾར༻Մೳͳ(JUϦϙδτϦαʔϏε͸(JU)VC (JU-BC "[VSF%FW0QT ECUϚωʔδυͷϦϙδτϦ ɾECUϚωʔδυϦϙδτϦʹ͍ͭͯ͸ϓϧϦΫΤετͷػೳ͸࢖͑·ͤΜ ɾϓϧϦΫΤετҎ֎ͷૢ࡞͸ECU$MPVEͷը໘ૢ࡞Ͱ׬݁
ɾϓϧϦΫΤετ෦෼ʹؔͯ͠͸αʔυύʔςΟαʔϏεͷը໘ૢ࡞Ͱ࿈ܞ "(JU8PSL fl PXGPS%BUB5FBNTIUUQTXXXHFUECUDPNBOBMZUJDTFOHJOFFSJOHUSBOTGPSNBUJPOHJUXPSL fl PX

ECU$MPVEͰར༻ग़དྷΔ๛෋ͳػೳ܈ ֤छECUίϚϯυ͸*%&ܦ༝Ͱ࣮ߦ͢Δ͜ͱ͕Ͱ͖·͢ɻ ࣮ߦਐ௙ɺϩά΍Τϥʔ౳ͱ͍࣮ͬͨߦ݁Ռʹؔ͢Δ৘ใΛ෼͔Γ΍͘͢೺ѲͰ͖·͢ɻ *%&VTFSJOUFSGBDFcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTDMPVEECUDMPVEJEFJEFVTFSJOUFSGBDF

ECU$MPVEͰར༻ग़དྷΔ๛෋ͳػೳ܈ ECUͷϞσϧʹରͯ͠ద੾ͳࢀরࢦఆ TPVSDFؔ਺΍SFGؔ਺ʹΑΔଞϞσϧࢦఆ Λߦ͓ͬͯ͘͜ͱͰɺ ECU$MPVE*%&্ͰϞσϧؒͷґଘؔ܎ΛՄࢹԽͯ͘͠ΕΔΑ͏ʹͳΓ·͢ɻ 8IBUJTB%"(BOEXIZJTJUJNQPSUBOU ECU-BCTIUUQTEPDTHFUECUDPNUFSNTEBH

ECU$MPVEͷϓϥϯʹԠͨ͡ར༻Մೳػೳ ECU$MPVEʹ͓͚Δϓϥϯͷҧ͍ʹ͍ͭͯ %FWFMPQFS 5FBN &OUFSQSJTF ECUc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTEJ ff FSFODFTCFUXFFOQMBOTJOECUDMPVE

ECU$MPVEͷϓϥϯʹԠͨ͡ར༻Մೳػೳ ࣌ظ ໊݅ ར༻Մೳͳ৚݅ ೥݄ 5SJHHFSPOKPCDPNQMFUJPO ECU$MPVE5FBNBOE&OUFSQSJTFQMBOT ೥݄ 6TFFYQPSUTUPXSJUFTBWFE
RVFSJFT ECU$MPVENVMUJUFOBOU5FBNPS&OUFSQSJTFQMBOT POECUWFSTJPOTPSOFXFS ೥݄ 4VQQPSUGPS (JUSFQPTJUPSZDBDIJOH ECU$MPVE&OUFSQSJTFQMBOT ೥݄ ECU$MPVE4FNBOUJD-BZFS (FOFSBMMZ"WBJMBCMF ECU$MPVE5FBNPS&OUFSQSJTFNVMUJUFOBOUQMBOT POECUWPSIJHIFS ECU$MPVEͷ5FBNϓϥϯɺ&OUFSQSJTFϓϥϯͰͷΈ࢖͑Δศརػೳ΋࠷ۙঃʑʹ૿͖͍͑ͯͯ·͢ɻ ˞ҎԼ͸௚ۙϦϦʔε͞Εͨ΋ͷͷத͔Βͷൈਮ "CPVUECU$MPVE3FMFBTF/PUFTcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTECUWFSTJPOTECUDMPVESFMFBTFOPUFT

ECU$MPVEͷϓϥϯʹԠͨ͡ར༻Մೳػೳ ECU$MPVE&OUFSQSJTFϓϥϯͳΒͰ͸ͷػೳ΍ಛ৭ʹ͍ͭͯ͸ҎԼͷͱ͓ΓͰ͢ɻ ɾ։ൃऀϢʔβʔͷγʔτ਺ͷ্ݶແ͠ ແ੍ݶ ɹ %FWFMPQFSϓϥϯ࠷େਓɺ5FBNϓϥϯ࠷େਓ ɾ࡞੒ՄೳͳϓϩδΣΫτ਺ͷ্ݶແ͠
ແ੍ݶ ɹ %FWFMPQFSϓϥϯɺ5FBNϓϥϯڞʹ࠷େͭ ɾ&OUFSQSJTFϓϥϯͰͷΈར༻Մೳͳػೳ ɹɾ3#"$ ϩʔϧϕʔεͷΞΫηε੍ޚ 440 γϯάϧαΠϯΦϯ αϙʔτ ɹɾ؂ࠪϩά ɹɾ4-"ˋ ɹɾσϓϩΠΦϓγϣϯ ύϒϦοΫΫϥ΢υͷબ୒ɺϚϧνςφϯτ ɹɾΤϯλʔϓϥΠζαϙʔτٴͼϓϩϑΣογϣφϧαʔϏε ɹɾηΩϡϦςΟϨϙʔτɺ๏తϨϏϡʔɺ੥ٻॻൃߦɺΧελϜ৚݅ͳͲ ɾߋʹηΩϡϦςΟΛߴΊ͍ͨ৔߹ͷ&OUFSQSJTFϓϥϯΦϓγϣϯ͕༻ҙ͞Ε͍ͯΔ ɹɾωΠςΟϒ"[VSF%FW0QTαϙʔτ ɹɾϓϥΠϕʔτϦϯΫରԠ ɹɾߴ౓ͳηΩϡϦςΟ ϓϥΠϕʔτ઀ଓɺ*1ΞυϨε୯ҐͰͷڐՄɾϒϩοΫ౳

ECUΛऔΓғΉʮΤίγεςϜʯͷଘࡏ 8FMDPNFUPUIFECUFDPTZTUFNIUUQTXXXHFUECUDPNCMPHUIFECUFDPTZTUFN ECU$MPVEJOUFHSBUJPOTcECU-BCTIUUQTXXXHFUECUDPNQSPEVDUJOUFHSBUJPOT "WBJMBCMFJOUFHSBUJPOTcECU%FWFMPQFS)VCIUUQTEPDTHFUECUDPNEPDTVTFECUTFNBOUJDMBZFSBWBJMTMJOUFHSBUJPOT ECUͱͷ࿈ܞΛᨳ͍ͬͯΔϞμϯσʔλελοΫͷαʔϏεʹ͸ͲͷΑ͏ͳ΋ͷ͕͋Δͷ͔ECUc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTECUDMPVEJOUFHSBUJPOTMJTU ECU ECU$MPVE ͸༷ʑͳΧςΰϦͷ༷ʑͳαʔϏεͱͷ࿈ܞΛᨳ͍ͬͯ·͢ɻECUΛத৺ʹਾ͑ͨϞμϯσʔλε
λοΫ؀ڥɺσʔλ෼ੳ؀ڥΛଞαʔϏεͱͷ࿈ܞͰߏங͠қ͍ͷ΋ECUͷେ͖ͳಛ௃Ͱ͢ɻ ʲσʔλ΢ΣΞϋ΢εʳ ɹ"MMPZ%# "NB[PO3FETIJGU #JH2VFSZ %BUBCSJDLT .JDSPTPGU'BCSJD 4OPX fl BLF 4UBSCVSTU ʲσʔλҠಈʳ ɹ'JWFUSBO ʲ#*෼ੳʳ ɹ%FFQOPUF (PPHMF4IFFUT )FY )PVTFXBSF ,MJQGPMJP -JHIUEBTI .PEF 1SFTFU 4JHNB 5BCMFBV 5IPVHUTQPU ʲӡ༻෼ੳϦόʔε&5-ʳ ɹ$FOTVT )JHIUPVDI ʲσʔλ඼࣭ʳ ɹ"OPNBMP #JHFZF %BUBCBOE %BUBGPME .FUBQMBOF .POUF$BSMP 4PEB ʲσʔλΧλϩάʳ ɹ"DSZM%BUB "MBUJPO "UMBO $PMMJCSB 4FDPEB 4FMFDU4UBS ʲΦʔέετϨʔγϣϯʳ ɹ"JS fl PX %BHTUFS 1SFGFDU

νέοταϙʔτରԠ ECU$MPVEͰ͸ɺϝχϡʔ͔Βαϙʔτ໰͍߹ΘͤΛνέοτىථܗࣜͰߦ͑·͢ɻ ECU$MPVEͷαϙʔτ໰͍߹Θͤํ͕ࣜνϟοτ͔ΒνέοτىථʹมΘ͍ͬͯ·͢ECUc%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQBSUJDMFTECUDMPVETVQQPSUDSFBUFBUJDLFU

εϜʔζͳνʔϜ։ൃ ECU ECU$MPVE Ͱ͸ɺ5FBNϓϥϯ&OUFSQSJTFϓϥϯʹԙ͍ͯʮෳ਺ਓʹΑΔνʔϜ։ൃʯ͕Մೳͱͳ͍ͬͯ·͢ɻ νʔϜ։ൃΛߟྀͨ͠ػೳ΋౰વ༻ҙ͞Ε͍ͯ·͢ɻ *OWJUFVTFSTUPECU$MPVEcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTJOWJUFVTFST "CPVUVTFSBDDFTTJOECU$MPVEcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTBCPVUVTFSBDDFTT
6TFSTBOEMJDFOTFTcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTTFBUTBOEVTFST &OUFSQSJTFQFSNJTTJPOTcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTFOUFSQSJTFQFSNJTTJPOT 4FMGTFSWJDFQFSNJTTJPOTcECU%FWFMPQFS)VC IUUQTEPDTHFUECUDPNEPDTDMPVENBOBHFBDDFTTTFMGTFSWJDFQFSNJTTJPOT

εϜʔζͳνʔϜ։ൃ ɾECU$MPVEͰ͸֤छιʔείʔυͷฤूʹΫϥ΢υ౷߹؀ڥ *%& ͕ར༻ग़དྷΔ ɹ ECU$PSFͰ͸௚ʹϑΝΠϧΛฤू͢Δ͔ɺฤू؀ڥΛࣗ෼Ͱ༻ҙ͢Δඞཁ͕͋Δ ɾECU$MPVEͰ͸εέδϡʔϦϯάػೳ͕αʔϏεͱͯ͠ఏڙ͞Ε͍ͯΔ ɹ
ECU$PSFͰ͸ผ్εέδϡʔϧαʔϏεͱ࿈ܞͤ͞Δ͔ɺࣗ෼ͰԿΒ͔࢓૊ΈΛߏங͢Δඞཁ͕͋Δ ɾECU$MPVEʹ͸"1*αϙʔτ͕͋Δ ɹ ECU$PSFʹ͸"1*αϙʔτ͸ແ͍ ɾECU$MPVEͰ͸ɺϓϩδΣΫτͷυΩϡϝϯτ͕αʔϏεͱͯ͠࡞੒ར༻ࢀরՄೳ ɹ ECU$PSFͰ΋υΩϡϝϯτ࡞੒͸Մೳ͕ͩɺυΩϡϝϯτϗετ؀ڥ͸ಠࣗʹ༻ҙ͠ͳ͍ͱ͍͚ͳ͍ ɾECU$MPVEͰ͸ηϚϯςΟοΫϨΠϠʔػೳ͕࢖͑Δ ɹ ECU$PSFͰ͸ར༻ෆՄ ɾECU$MPVEʹ͸ܧଓతΠϯςάϨʔγϣϯ $* ࿈ܞػೳ͕͋Δ ɹ ECU$PSFͰ$*Λ࣮ݱ͢Δ৔߹͸ผ్αʔυύʔςΟ੡αʔϏεͱͷ࿈ܞ͕ඞཁ ɾECU$MPVEͰ͸ηΩϡϦςΟपΓͷରԠ͕ҝ͞Ε͍ͯΔ ɹ ECU$PSF͸ࣗݾϗετܕͷҝ͜ͷลΓ͸શͯະରԠɺશ෦ࣗ෼ୡͰԿͱ͔͢Δ͔͠ͳ͍ ɾECU$MPVEͰ͸νέοταϙʔτ͕ड͚ΒΕΔ ɹ ECU$PSFͰ͸౰વͳ͕Βड͚ΒΕͳ͍ ɾECU$MPVEͰ͸ʮ։ൃ؀ڥʯͱʮຊ൪؀ڥʯΛ෼͚ͯ؅ཧग़དྷΔ ɹ ECU$PSFͰ͸ͦ΋ͦ΋ʮ؀ڥʯͱ͍͏֓೦͕ແ͍ ɾECU$MPVEͰ͸νʔϜ։ൃΛ౿·͑ͨػೳ͕༻ҙ͞Ε͍ͯΔ 5FBN &OUFSQSJTFϓϥϯ ɹ ECU$PSFʹ͸ͦ΋ͦ΋ʮνʔϜʯͱ͍͏֓೦͕ແ͍ ɾˠˠˠ݁ՌɺECU$MPVEͩͱνʔϜ։ൃ͕௙Δ

ECUؔ࿈ࣄྫ എܠը૾ɿ0WFSDPNJOHDPNQMFYJUZUIFCJHHFTUOFXECU$MPVEGFBUVSFTGSPN$PBMFTDF IUUQTXXXHFUECUDPNCMPHOFXECUDMPVEGFBUVSFTBOOPVODFEBUDPBMFTDF

ECUʹؔ͢Δʮࣄྫʯू͸ެࣜαΠτʹͯల։ ECU$BTF4UVEJFTcECU-BCTIUUQTXXXHFUECUDPNTVDDFTTTUPSJFT

ECUؔ࿈ࣄྫɿ.D%POBMET/PSEJDT .D%POBME`T/PSEJDTFTUBCMJTIFTBOJNCMFBOETUBOEBSEJ[FE%BUB7BVMUTUSVDUVSFXJUIECU$MPVEcECU-BCT IUUQTXXXHFUECUDPNTVDDFTTTUPSJFTNDEPOBME&TOPSEJDT ɾ.D%POBMET/PSEJDT͸ɺച্ԯϢʔϩΛؚΉɺෳ਺ͷϨετϥϯɺ ɹυϥΠϒεϧʔɺ഑ୡ͔ΒͷूੵσʔλΛ౷ҰԽ͠ɺ̐ͭͷࢢ৔Ͱ ɹҰݩతͳσʔλ΢ΣΞϋ΢εΛߏஙɻ ɾ֤ࢢ৔͸ಠࣗͷ*5෦໳ͱσʔλ΢ΣΞϋ΢εΛ͍࣋ͬͯͨͨΊɺ'PPE'PMLٴͼ ɹ.D%POBME`T(MPCBM΁ͷ౷Ұ͞ΕͨใࠂͷͨΊʹɺҰͭͷϓϥοτϑΥʔϜͱ ɹσʔλ΢ΣΞϋ΢εͷ࡞੒͕ඞཁͩͬͨɻ
ɾ.D%POBMET͸ɺళ಺΍ΦϯϥΠϯɺ6CFS&BUTͷΑ͏ͳୈࡾऀιʔε͔Βͷ ɹ஫จʹؔ࿈͢ΔൢചσʔλΛूੵ͠ɺϏδωεશମͷӡ༻վળʹ໾ཱ͍ͯͯΔɻ ɾ4OPX fl BLFɺ'JWFUSBOɺECU$MPVEΛ༻͍ͯ%BUB7BVMU্Ͱ ɹதԝूݖԽ͞ΕͨσʔλελοΫΛ࡞੒͠ɺ৯඼αʔϏεখചνΣʔϯΦϖϨʔλͷӡӦΛࢧԉɻ ɾ.D%POBMET/PSEJDT͸ɺσʔλ΢ΣΞϋ΢εͷݎ࿚ੑΛߴΊɺώετϦΧϧσʔλ΁ͷΞΫηεΛഒૣ͘͢Δ͜ͱͰɺ ɹσʔλͷ௥੻ੑΛ޲্ͤ͞ɺϏδωεϢʔβʔ͔Βͷ৴པΛ֫ಘɻ

ECUؔ࿈ࣄྫɿ/BTEBR /BTEBR`TSPVUFUPUIFNPEFSOEBUBTUBDLcECU-BCT IUUQTXXXHFUECUDPNTVDDFTTTUPSJFTOBTEBR ɾ/BTEBR͸ɺ๺ถͱϊϧσΟοΫॾࠃʹͷূ݊औҾॴΛ࣋ͪɺ ɹΫϥ΢υٕज़Λۦ࢖ͯ͠σʔλΠϯϑϥΛ࠷దԽɻ ɾσʔλ΢ΣΞϋ΢ε͔ΒσʔλϨΠΫ΁ͷҠߦʹΑΓϝϯςφϯείετΛ ɹ࡟ݮ͠ɺσʔλॲཧͷޮ཰͕޲্ɻ ɾECU$MPVEͷಋೖʹΑΓɺϏδωεϢʔβʔ͸؆୯ʹඞཁͳσʔλʹ ɹΞΫηεͰ͖ΔΑ͏ʹͳͬͨɻ
ɾΦϓγϣϯϏδωεͰ͸ECU$MPVEΛ࢖͍ɺ਺ඦͷϞσϧ͔Β ɹ৽͍͠ϏδωεΠϯαΠτΛൃݟɻ ɾ/BTEBR͸ɺECU$MPVEʹΑΔ੒ޭΛଞͷϏδωεྖҬʹ΋޿͛ɺ͞Βʹࠃࡍࢢ৔Ͱͷల։Λܭըɻ

ECUؔ࿈ࣄྫɿ)VC4QPU )VC4QPUFNQPXFSTBOBMZTUTUPPXOUIFJSUPPMTXJUIECU IUUQTXXXHFUECUDPNTVDDFTTTUPSJFTIVCTQPU ɾ)VC4QPU͸ɺ෼ੳνʔϜΛੜ࢈తͰ޾ͤɺͦͯ͠εέʔϥϒϧʹ͢ΔͨΊʹɺ ɹ4OPX fl BLFͳͲͷ࠷৽ͷΫϥ΢υ΢ΣΞϋ΢εΛॳظஈ֊͔Β࠾༻ɻ ɹʮσʔλϕʔε؅ཧऀ͕ෆཁͰɺಈతεέʔϦϯά΍Ϋϩʔχϯά͕Մೳʯ ɹͱड़΂͍ͯΔɻ
ɾσʔλม׵ͷ໰୊Λ"QBDIF"JS fl PXͰղܾ͠Α͏ͱ͠·͕ͨ͠ɺ ɹ݁Ռతʹίʔυϕʔε͕ཚࡶʹͳΓɺϞσϧͷґଘؔ܎Λ೺Ѳ͢Δͷ͕ ɹ೉͘͠ͳͬͨɻ·ͨɺϞσϧͷߋ৽΍τϥϒϧγϡʔςΟϯά͕ࠔ೉ʹͳΔ ɹͱ͍͏৽ͨͳ՝୊΋ൃੜɻ ɾECUΛಋೖͨ͜͠ͱͰɺ෼ੳ୲౰ऀ͸σʔλϞσϦϯάΛਖ਼͍͠ํ๏Ͱ ɹߦ͏͜ͱ͕Ͱ͖ɺࣗ෼ͷπʔϧΛࣗΒॴ༗͢Δ͜ͱ͕ଅਐ͞Εͨɻ ɹ͜ΕʹΑΓɺϞσϧґଘੑΛఆٛ͠ɺϞσϧΛߋ৽͠ɺτϥϒϧγϡʔςΟϯά ɹΛߦ͏͜ͱ͕༰қʹͳͬͨɻ ɾ)VC4QPUͷύʔτφʔνʔϜΛؚΉ͍͔ͭ͘ͷ෼ੳνʔϜ͸ɺECUΛશ໘తʹ࠾༻ɻ ɹ͜ΕʹΑΓɺϏδωεϢʔβʔࣗΒ͕୳ࡧΛߦ͏͜ͱ͕ՄೳͱͳΓɺϓϩάϥϜʹؔ͢ΔΑΓࡉ͔ͳཧղΛ࣮ݱɻ ɾࠓޙɺ)VC4QPU͸ɺECUͷςετϑϨʔϜϫʔΫ΁ͷҠߦ΍ɺ42-εΩϧΛ࣋ͭશ෼ੳ୲౰ऀͷ಺෦ίϛϡχςΟߏஙʹ౒ΊΔ͜ͱͰɺ ɹ͜ΕΒͷπʔϧͷՄೳੑΛ࠷େݶʹҾ͖ग़͢͜ͱΛ໨ࢦ͍ͯ͠Δɻ

ECU$MPVE τϨʔχϯά1P$ࢧԉ Ωϟϯϖʔϯʹ͍ͭͯ എܠը૾ɿ0WFSDPNJOHDPNQMFYJUZUIFCJHHFTUOFXECU$MPVEGFBUVSFTGSPN$PBMFTDF IUUQTXXXHFUECUDPNCMPHOFXECUDMPVEGFBUVSFTBOOPVODFEBUDPBMFTDF

࠷ޙʹએ఻ ECU$MPVEͷτϨʔχϯάˍ1P$Ωϟϯϖʔϯɺ࢝Ί·ͨ͠ʂ Ϋϥεϝιουɺσʔλม׵πʔϧlECU$MPVEzͷ1P$ࢧԉαʔϏε൒ֹΩϟϯϖʔϯ։࢝ʙECUͷݕূςʔϚઃఆ͔Β؀ڥߏஙɺτϨʔχϯά·ͰΛαϙʔτʙcΫϥεϝιουגࣜձࣾ IUUQTDMBTTNFUIPEKQOFXTECUDBNQBJHO

࠷ޙʹએ఻ ʲΩϟϯϖʔϯ಺༰ɿ಺༁ʳ ΩοΫΦϑϛʔςΟϯάɺτϨʔχϯάؔ࿈ώΞϦϯά dI ΦϯϥΠϯτϨʔχϯά I ɹɾ࠲ֶηογϣϯ
ɹ˞ ࠲ֶηογϣϯͱฒߦͯ͠ ͓٬༷؀ڥΛ༻͍ͨϛχԋश τϨʔχϯάৼΓฦΓ NJO 1P$ʹؔ͢ΔώΞϦϯά ʙI 1P$ I શମৼΓฦΓɾϑΟʔυόοΫϛʔςΟϯά I ˞શฤΦϯϥΠϯ૝ఆɺ࣭ٙԠ౴͸దٓɺ1P$͸ৄࡉ૒ํௐ੔ͷ্࣮ࢪ Ϋϥεϝιουɺσʔλม׵πʔϧlECU$MPVEzͷ1P$ࢧԉαʔϏε൒ֹΩϟϯϖʔϯ։࢝ʙECUͷݕূςʔϚઃఆ͔Β؀ڥߏஙɺτϨʔχϯά·ͰΛαϙʔτʙcΫϥεϝιουגࣜձࣾ IUUQTDMBTTNFUIPEKQOFXTECUDBNQBJHO

࠷ޙʹએ఻ ECUcΫϥεϝιουגࣜձࣾIUUQTDMBTTNFUIPEKQQBSUOFSECU ECUશൠͷ͓໰͍߹Θͤ͸ͪ͜Β͔Βɻ

イチから学ぶdbt / Learn dbt from scratch

イチから学ぶdbt / Learn dbt from scratch

More Decks by shinyaa31

Other Decks in Technology

Featured

Transcript