DataEngineeringStudy #11
䚷ᅵᕝ⛱⏕䝕䞊䝍ᇶ┙ရ㉁ྥୖ䛾䛯䜑䛾୍ᖺ$XZXKC
View Slide
┠ḟƔ ⮬ᕫ⤂Ɣ 㐺ᛶ┘ど䝅䝇䝔䝮䛾ᑟධƔ /RRNHU䛾ᑟධƔ GEW&ORXG䛾ᑟධƔ 䛥䛔䛤䛻
ᅵᕝ⛱⏕7VXFKLNDZD7RVKLNLƔ ឡ▱┴ฟ㌟Ɣ ᖺᮾᕤሗ⌮ᕤᏛ㝔༞Ɣ ᰴᘧ♫䝍䜲䝭䞊ż '5('DWD5HOLDELOLW\(QJLQHHULQJ䝏䞊䝮ż 䝕䞊䝍ᇶ┙䛾㛤Ⓨ䞉ಖᏲ䞉㐠⏝ż ศᯒᇶ┙䛾㛤Ⓨ䞉ಖᏲ䞉㐠⏝Ɣ 7ZLWWHU#WYWJB⮬ᕫ⤂
⣙ᖺ๓䛾䝕䞊䝍ᇶ┙
̐᭦᪂䝍䜲䝭䞁䜾䛾㐜ᘏ%LJ4XHU\䝴䞊䝄䞊䛛䜙᭦᪂䝍䜲䝭䞁䜾䛜㐜䜜䛶䛔䜛䛸䛾ධಙ䛜ቑຍ䛭䛾㒔ᗘ'5(䝏䞊䝮䛜༶ᑐᛂ┘ど䛿䛔䛟䛴䛛ධ䜜䛶䛔䛯䛜䚸䜲䞁䝣䝷䜔䚸䝕䞊䝍䝟䜲䝥䝷䜲䞁䛺䛹ከᒱ䛻䜟䛯䜛䝞䜾䛾Ⓨ⏕※䛜䛒䜚ᑐᛂ䛻㛫䛜ྲྀ䜙䜜䜛䜘䛖䛻䝕䞊䝍ရ㉁䛾ၥ㢟Ⅼʍ᭦᪂㢖ᗘ┘ど6/26/$䛾ᑟධ㐺ᛶ䜢6/,䛸䛧䛶ྛ䝕䞊䝍䝋䞊䝇䛤䛸䛻 6/$䜢ศᯒ⪅䛸ᐃ⩏䜶䝷䞊䝞䝆䜵䝑䝖䜢タ䛡䜛䛣䛸䛷᪂つ㛤Ⓨ䛻㛫䛜䛡䜛䜘䛖䛻䛺䜛䝫䝇䝖䝰䞊䝔䝮䛷ᨵၿ䜒ᅇ䜛%LJ4XHU\䛾᭱⤊᭦᪂้䜢┘ど䛩䜛䛣䛸䛷 '5(䝏䞊䝮䛜䜶䝷䞊䛻᪩䛟Ẽ䛵䛡䜛䜘䛖䛻䛺䜛̐̐̐̐
6/,6/$6/2䛾ᐃ⩏6HUYLFH/HYHO,QGLFDWRU䝃䞊䝡䝇䛾ရ㉁䜢Ᏺ䜛䛯䜑䛾ᣦᶆ6/,6/$6/26HUYLFH/HYHO$JUHHPHQW6/,䛷ᐃ⩏䛧䛯ᣦᶆ䛻㛵䛩䜛䝃䞊䝡䝇ᥦ౪⪅䛸䛾ዎ⣙◚䛳䛯䛻䛹䛖䛩䜛䛛䛺䛹6HUYLFH/HYHO2EMHFWLYH6/,䛷ᐃ⩏䛧䛯ᣦᶆ䛾ලయⓗ䛺┠Ᏻ
'5(䝏䞊䝮䛻䛚䛡䜛6/,6/26/$䛾ᐃ⩏6HUYLFH/HYHO,QGLFDWRU䝕䞊䝍䝟䜲䝥䝷䜲䞁䛾㐺ᛶ䝕䞊䝍䝋䞊䝇䛾᭦᪂䛛䜙䛹䛾䛟䜙䛔㐜䜜䛶㌿㏦ඛ䛷ᐇ⏝ྍ⬟䛻䛺䜛䛛6/,6/$6/26HUYLFH/HYHO$JUHHPHQW䝕䞊䝍䝋䞊䝇䛤䛸䛻%LJ4XHU\⏝⪅䛸⤖䜀䜜䛯㐺ᛶ䛻㛵䛩䜛ዎ⣙◚䛳䛯ሙྜ䛿䝫䝇䝖䝰䞊䝔䝮䜢ᐇ䝕䞊䝍䝋䞊䝇$䛿᪥䛾㐺ᛶ䛷䛾㌿㏦6HUYLFH/HYHO2EMHFWLYH'5(䝏䞊䝮ෆ䛷Ỵᐃ䛥䜜䛯䝕䞊䝍䝋䞊䝇䛤䛸䛾㐺ᛶ䛾┠ᶆ䝕䞊䝍䝋䞊䝇$䛿KRXU䛾㐺ᛶ䛷䛾㌿㏦
㐺ᛶ䛾┘ど㐜ᘏ㛫┘ど䝅䝇䝔䝮䛾ᐇྛ✀䝕䞊䝍䝟䜲䝥䝷䜲䞁䛾㐺ᛶ䛻㛵䛩䜛6/2䛸%LJ4XHU\䛾䝯䝍䝕䞊䝍䛷䛒䜛᭱⤊᭦᪂㛫䜢ẚ㍑6/26/$䜘䜚䜒᭦᪂㛫䛜㐜ᘏ䛧䛶䛔䛯䜙VODFN䛻㏻▱䛧䚸㞀ᐖᑐᛂ䞉䝫䝇䝖䝰䞊䝔䝮䜢ᐇ䝁䞊䝗䛿S\WKRQ䛷సᡂ䛧䚸*LWKXE$FWLRQV䛷ᐃᮇᐇ⾜
䜚㏉䜚㐺ᛶ䛾6/26/$䜢ᐃ⩏䛩䜛䛣䛸䛻䜘䛳䛶䚸ศᯒ⪅䛿䝕䞊䝍䛾㌿㏦㛫䛻䛚䛡䜛㐜ᘏ䜢ᢕᥱ䛧䛺䛜䜙ศᯒ䛜ྍ⬟䛻䛺䛳䛯'5(䝏䞊䝮䜒㞀ᐖᑐᛂ䜢ᐇ䛩䜛㝿䛾ᇶ‽್䛻䜘䜚䚸㞀ᐖᑐᛂ䛸ᶵ⬟㛤Ⓨ䜢䝞䝷䞁䝇䜘䛟ᐇ⾜䛩䜛䛣䛸䛜䛷䛝䜛䜘䛖䛻䛺䛳䛯
䜽䜶䝸䛾ಟṇ䛚㢪䛔䛧䜎䛩䛣䛾䝎䝑䝅䝳䝪䞊䝗䛾సᡂ䛚㢪䛔䛧䜎䛩䝕䞊䝍ရ㉁䛾ၥ㢟Ⅼ̐ศᯒ䝏䞊䝮䜈䛾౫㢗㐣ከศᯒ䝏䞊䝮䛻䜽䜶䝸䛾సᡂ䚸ಟṇ䛺䛹䛾౫㢗䛜ቑຍㄡ䛛䛜సᡂ䛧䛯䜽䜶䝸䜢⏝䛩䜛䛣䛸䛷ᑡ䛧䛪䛴䝈䝺䛜Ⓨ⏕ʍ/RRNHU䛾ᑟධ/RRNHU䛷๓䛻64/䜢ᐃ⩏䛧䛶䛒䛢䜛䛣䛸䛷䚸䜽䜶䝸䛾᭩䛝᪉䛻䜘䜛䝈䝺䜢ῶ䜙䛩䚹ㄡ䛷䜒䝎䝑䝅䝳䝪䞊䝗䜢⡆༢䛻సᡂ䛷䛝䜛䜘䛖䛻䛩䜛䛣䛸䛷䚸䝕䞊䝍ά⏝䛾ಁ㐍䜢ᮇᚅ
/RRNHU䛾ᑟධ/RRNHU䛻䜘䜛䝕䞊䝍ရ㉁䛾ྥୖ㢖⦾䛻ศᯒ䛷⏝䛔䜙䜜䜛ᣦᶆ䜢 ':+䛸䛧䛶/RRNHU䛛䜙ᐃ⩏/RRN0/䛻䜘䜛64/ᐃ⩏䛾୍ᮏ([SORUH䛻䜘䜛䝎䝑䝅䝳䝪䞊䝗సᡂ䛾⡆᫆5HGDVK䛷⏝䛔䜙䜜䜛䝎䝑䝅䝳䝪䞊䝗䛾⨨
䜚㏉䜚/RRNHU䛾ᑟධ䛻䜘䜚䚸/RRN0/䛻グ㏙䛧䛯ᣦᶆ䛻㛵䛧䛶䛿ㄡ䛷䜒⡆༢䛻䝎䝑䝅䝳䝪䞊䝗䜢సᡂ䛷䛝䚸䛭䛾䝕䞊䝍䛾ရ㉁䜒ୖ䛜䛳䛯/RRNHU䛷ᐃ⩏䛧䛯ᣦᶆ䜢%LJ4XHU\䛛䜙䜒ศᯒྍ⬟䛺≧ែ䛻䛩䜛䛣䛸䛷䚸䝕䞊䝍䝫䞊䝍䝹䜔5HGDVK䛷䛾䝕䞊䝍䛾ရ㉁䜒㧗䛟䛺䛳䛯/RRNHU䛿ゝㄒ䛭䛾䜒䛾䛿64/䜢ᇶᮏ䛸䛧䛶䛔䜛䛾䛷䜻䝱䝑䝏䜰䝑䝥䛿⡆༢䛰䛳䛯䛜䚸䝁䞊䝗ᵓᡂ䛾タィ䛿㞴䛧䛟䚸ఱᗘ䛛య䛾タィ䜢䜔䜚┤䛧䛯5HGDVK䛷⏝䛔䜙䜜䛶䛔䜛䝎䝑䝅䝳䝪䞊䝗䜢 /RRNHU䛻⛣⾜䛧䜘䛖䛸䛧䛶䛔䜛䛜 /RRN0/䛻ᐃ⩏䛩䜉䛝ᣦᶆ䜒ከ䛟䚸䜎䛰⛣⾜㏵୰䛷䛒䜛/RRNHU䛾䝁䝭䝳䝙䝔䜱䛜ᗈ䛔䛾䛷䚸♫䛥䜣䛸 /RRNHU䛾ᵓᡂ䛻䛴䛔䛶┦ㄯ䛧䛺䛜䜙㛤Ⓨ䛷䛝䛯䛾䛷䛩䛤䛟ຓ䛛䛳䛯
̐(7/䛾7ฎ⌮䛾䝒䞊䝹౫Ꮡᛶ䚸⫧䚸㏱᫂ᛶ䝕䞊䝍㔞䛾ቑຍ䛻క䛔䝬䝇䜻䞁䜾䛺䛹䛾ຍᕤฎ⌮䜢⾜䛳䛶䛔䜛HPEXONෆ䛾7ฎ⌮䝁䞊䝗䛾ᐇ⾜㛫䛜⫧䛧䛶䛝䛯WURFFR䛺䛹䛾HPEXON௨እ䛾䝕䞊䝍䝟䜲䝥䝷䜲䞁䛾ᑟධ䛻䜘䜚7ฎ⌮䛜HPEXON䛻౫Ꮡ䛧䛶䛔䜛HPEXON䛾䝁䞊䝗䜢ㄞ䜎䛺䛔䛸 7ฎ⌮䛾ෆᐜ䛜ᢕᥱ䛷䛝䛪䚸ศᯒ⪅䛛䜙䛩䜛䛸㏱᫂䛺ฎ⌮䛷䛒䜛䝕䞊䝍ရ㉁䛾ၥ㢟ⅬʍGEW&ORXG䛾ᑟධ䛻䜘䜛(/7䝟䜲䝥䝷䜲䞁䛾ᵓ⠏GEW&ORXG䜢⏝䛔䛶HPEXON䛷⾜䛳䛶䛔䛯7ฎ⌮䜢௦᭰䝕䞊䝍䝟䜲䝥䝷䜲䞁䛻⏝䛔䛶䛔䜛䝒䞊䝹䛻౫Ꮡ䛫䛪䛻䚸%LJ4XHU\䛻㞟䛧䛯䝕䞊䝍䛻ᑐ䛧䛶ᵝ䚻䛺ຍᕤ䛜ྍ⬟䛻ຍᕤ䜢୍⟠ᡤ䛻㞟䜑䜛䛣䛸䛷䚸ศᯒ⪅䛻ຍᕤሗ䜢㐺ษ䛻ఏ䛘䜙䜜䜛䜘䛖䛻ᮇᚅ䝬䝇䜻䞁䜾䛺䛹䛾ຍᕤฎ⌮¡
䜚㏉䜚GEW&ORXG䛾ᑟධ䛻䜘䜚䚸䛹䛾䝕䞊䝍䝟䜲䝥䝷䜲䞁䛛䜙䝕䞊䝍䜢㞟䛧䛶䜒ඹ㏻䛾ຍᕤ䛜䛷䛝䜛䜘䛖䛻䛺䛳䛯GEW&ORXG䛿䜲䞁䝣䝷䛾ᩚഛ䛜ᚲせ䛺䛯䜑䚸䝏䞊䝮䝯䞁䝞䞊䛜ᑡ䛺䛔 '5(䝏䞊䝮䛻䛿㐺ษ䛺䝒䞊䝹䛰䛳䛯䚹ゝㄒ䜒 64/䜢ᇶᮏ䛸䛧䛶䛔䜛䛾䛷ᑟධ䜎䛷䛾䝁䝇䝖䛜ప䛛䛳䛯(7/ᇶ┙䜢(/7ᇶ┙䛻ኚ᭦䛩䜛㝿䛻䚸ຍᕤ䛧䛶䛺䛔䝕䞊䝍䜢≉ᐃ䛾 *&3䝥䝻䝆䜵䜽䝖䛻ಖᏑ䛩䜛ᚲせ䛜䛒䜛䛜䚸 *&3䛾,$0ᵓᡂ䛜」㞧䛷䛭䛣䛛䜙ᡭ䜢䛴䛡䜛䛾䛜ኚ䛰䛳䛯
᭱㏆䛾䝕䞊䝍ᇶ┙
䛣䜜䛛䜙䛾ရ㉁䛾䛚䛡䜛ㄢ㢟䝕䞊䝍ရ㉁䛻䛚䛡䜛 6/,䛸䛧䛶㐺ᛶ䜢ᐃ⩏䛧䛯䛜䚸䛻䜒୍ពᛶ䚸ᛶ䛺䛹䛾ᣦᶆ䛜䛒䜚䚸┘ど䛺䛹䜢㐺ᛂ䛩䜛䛣䛸䛷ရ㉁䛾ྥୖ䜢┠ᣦ䛧䛯䛔GEW&ORXG䛿'5(䝏䞊䝮䜢୰ᚰ䛸䛧䛯䝕䞊䝍ຍᕤ䚸 /RRNHU䛿ศᯒ⪅䛜୰ᚰ䛸䛺䜛ຍᕤ䜢ᢸᙜ䛩䜛䛣䛸䛷䝕䞊䝍ศᯒ䛻䛚䛡䜛䝁䝇䝖䚸ရ㉁䛾ྥୖ䜢┠ᣦ䛧䛯䛔ྛ✀%,䝒䞊䝹䛾ᙺ䜢ศᢸ䛧䚸㐺ษ䛺 %,䝒䞊䝹䛾⏝䜢♫ⓗ䛻㐺ᛂ䛧䚸ရ㉁䛾㧗䛔䝕䞊䝍ά⏝䜢ಁ㐍䛧䛯䛔
䛥䛔䛤䛻㼔㼠㼠㼜㼟㻦㻛㻛㼙㼑㼑㼠㼥㻚㼚㼑㼠㻛㼙㼍㼠㼏㼔㼑㼟㻛㼙㻱㻶㼜㻵㼚㼤㻳㻺㼒㼁㼅䈊 㼔㼠㼠㼜㼟㻦㻛㻛㼣㼣㼣㻚㼣㼍㼚㼠㼑㼐㼘㼥㻚㼏㼛㼙㻛㼜㼞㼛㼖㼑㼏㼠㼟㻛㻡㻣㻥㻤㻝㻜䈊