Slide 1
Slide 1 text
:VVLJ5BLF[BXBZUBLF
%3&43&ͷϓϥΫςΟε༥߹ʹΑΔ
ΫϥυωΠςΟϒͳσʔλج൫࡞Γ
Slide 2
Slide 2 text
QSP
fi
MF
• ελʔϑΣεςΟόϧגࣜձࣾ΄͔
• σʔλॲཧ͍Ζ͍Ζ
• (P4DBMB
• ϚΠΫϩαʔϏεΞʔΩςΫνϟɾϦΞΫςΟϒγεςϜɺ
ϨΨγʔվળ43&%3&ɺ֤छϞσϦϯάͷࢧԉͳͲ
• 9IUUQTUXJUUFSDPNFY@UBLF[BXB
Slide 3
Slide 3 text
"HFOEB
• %3&ͬͯͲΜͳ͜ͱΛ͢Δͷʁ
• ΫϥυͳΒͰͷσʔλج൫ͬͯʁ
Slide 4
Slide 4 text
%3&ͬͯͳΜͰ͠ΐ͏ʁ
Slide 5
Slide 5 text
%BUB3FMJBCJMJUZ&OHJOFFSJOH
• 43&ͷϓϥΫςΟεΛσʔλ࣭ࢹͳͲʹద༻
• Ϗδωεҙࢥܾఆʹར༻͢Δ
σʔλͷ৴པੑʹؔ͢Δ׆ಈ
Slide 6
Slide 6 text
ͲΜͳ͜ͱΛਐΊ͍ͯ͘ͷ͔
Slide 7
Slide 7 text
σʔλج൫ͬͯͳʹΛ͢Δͷʁ
• ձࣾͷυϝΠϯʹΑͬͯଊ͑ํҟͳΓ·͢
• σʔλ׆༻Λલఏʹσʔλऩूɺཧɺ࡞ͳͲ
σʔλʹؔ͢Δج൫
• σʔλΛΞϓϦέʔγϣϯʹϦόʔε&5-ͨ͠Γɺ
ػցֶशʹར༻͞ΕͨΓ
Slide 8
Slide 8 text
σʔλ׆༻ͱ
• ձࣾ׆ಈͳͲʹ͓͚ΔʮҙࢥܾఆʯʮۀޮԽʯɺ
ʮϚʔέςΟϯάʯͳͲͷ্ʹཱͯΔ
• σʔλυϦϒϯͳاۀจԽ࡞Γʹͳͯ͘ͳΒͳ͍ͷ
• Ͳ͏͍͏σʔλΛΤϏσϯεʹ͍͚ͯ͠ྑ͍͔ɺ
ͳͲձࣾʹΑͬͯશ͘ҧ͏ͨΊɺ
Կ͔Λࢀߟʹ͢Δͱ׆༻͕Ͱ͖ΔΘ͚Ͱͳ͍
Slide 9
Slide 9 text
׆༻Ͱ͖ΔΑ͏ʹ͢ΔͨΊʹ
Slide 10
Slide 10 text
ࣄۀɾձࣾΛΔ
• ࣄۀͷυϝΠϯΛ͔ͬ͠Γͱཧղ͢Δ͜ͱ
• υϝΠϯΛཧղ͠ͳ͚Εσʔλʹؔ࿈͢Δ׆ಈ͕͍͠
• ୯७ʹσʔλΛू͢Δɺ͚ͩͰ׆༻͠ʹ͍͘
Slide 11
Slide 11 text
ࣄۀɾձࣾΛΔ
• ࣄۀͷཧղΛ্͛Δ͜ͱͰະདྷΛߟ͑ΒΕΔΑ͏ʹ
• ະདྷʹߦͨ͘ΊʹݱࡏԿ͕Γ͍ͯͳ͍ͷ͔ɺ
Ͳ͏͍͏ઓུΛཱͯΔඞཁ͕͋Δͷ͔
• σʔλΛͲ͏׆༻͢ΔͱɾͲΜͳͷ͕͋Δͱ
ࢦ͍ͨ͠ํʹ͔͑Δͷ͔
Slide 12
Slide 12 text
σʔλΛݟΔɺۀΛΔ
• ݱঢ়ͷσʔλ͕ͲͷΑ͏ʹͳ͍ͬͯΔͷ͔
• Ͳ͏͍ͬͨۀϑϩʔɺΞϓϦέʔγϣϯ͕͋Γ
ͲͷλΠϛϯάͰσʔλ͕࡞ΒΕΔͷ͔
• ͲͷλΠϛϯάͷσʔλ͕׆༻Ͱ͖Δͷ͔
Slide 13
Slide 13 text
σʔλΛݟΔɺۀΛΔ
• σʔλઃܭΞϓϦέʔγϣϯدΓͳͷ͔ɺ
׆༻ʹ͑͏Δઃܭʹͳ͍ͬͯΔͷ͔
• อ͞ΕΔσʔλͷ࣭
ҙࢥܾఆࣄۀ׆ಈʹରͯ͠༗༻͔Ͳ͏͔
Slide 14
Slide 14 text
͋ΔͷΛ৴༻͠ͳ͍
• ࠓ͋Δͷෆेͳͷ͔͠Εͳ͍
• ͜͏͍͏σʔλ͕ඞཁͩ
• ׆༻͢ΔͨΊʹඞཁͳσʔλ͕ͳ͚Ε
Ͳ͔͜Βͦͷσʔλ͕࡞ΒΕͦ͏͔ʢύΠϓϥΠϯʣ
Slide 15
Slide 15 text
͋ΔͷΛ৴༻͠ͳ͍
• ࣄۀυϝΠϯΛཧղ͍ͯ͠ͳ͚Εɺ
σʔλ͕৴༻Ͱ͖Δ͔Ͳ͏͔ͷஅ͕͔ͭͳ͍
• σʔλ͕ͲͷΑ͏ʹͳ͍ͬͯΔ͖͔
• վળΛͭͷͰͳ͘ɺվળ͢ΔͨΊʹඞཁͳͷΛ
ࣗΒ࣮ߦ͢Δ
Slide 16
Slide 16 text
ྫ͑
• $73ͳͲΛਖ਼͘͠ೝͰ͖Δσʔλଗ͍ͬͯΔ͔ʁ
• ΧʔτམͪͲͷ͘Β͍ʁ
ͦͷ࣌Χʔτʹ͋Δͷʁ
ߪೖใͱΧʔτใඥ͍ͮͯΔʁ
• ར༻͍ͯ͠Δ4BBTαʔϏεͱσʔλ݁߹Ͱ͖Δʁ
Slide 17
Slide 17 text
ݴΘΕͨ௨Γʹσʔλͷूɺ
సૹΛ͢ΕΑ͍ɺͱࢥ͍ͬͯ·ͤΜ͔ʁ
Slide 18
Slide 18 text
ϢʔβʔΠϯλϥΫγϣϯΛཧղ͢Δ
• Ϣʔβʔͱࣾ֎Θͣརؔऀશͯ
• σʔλԿ͔ͷࣄͷεφοϓγϣοτ
• ͲͷΑ͏ͳͷ͕ࣄͱѻ͑Δͷ͔
Slide 19
Slide 19 text
ΠϯλϥΫγϣϯΛཧղ͢Δʹ
• ΞϓϦέʔγϣϯͷϑϩʔΛཏ͢Δ
• υϝΠϯΠϕϯτΛݟ͚ͭग़͢
• υϝΠϯΤΩεύʔτʹฒͯ͠Β͏
• τϥοΩϯάͷઃܭͳͲʹ׆༻
Slide 20
Slide 20 text
Ͳ͔͜Βੜ·ΕͯͲ͜ʹ͍͘ͷ͔
Slide 21
Slide 21 text
Πϕϯτετʔϛϯά
• αʔϏεͳͲʹؔΘΔϝϯόʔΛूΊ࣮ͯࢪ
• ͲͷΑ͏ͳग़དྷࣄ͕ى͜Δ͔
• ίϯςΩετͲͷΑ͏ʹͳ͍ͬͯΔ͔
• γεςϜͱυϝΠϯͷؔੑΛඥղ͘
Slide 22
Slide 22 text
Πϕϯτετʔϛϯά
• %3&׆ಈΛߦ͏ϝϯόʔ͚ͩͰΒͳ͍
• ৴པੑΛ্͍͛ͯͨ͘ΊʹจԽ࡞Γ
ҙࣝ࡞Γ͕ඞཁෆՄܽ
• ؔऀΛר͖ࠐΈೝࣝΛ߹ΘͤΔ͜ͱ
Slide 23
Slide 23 text
σʔλʹؔ͢Δࢥߟ
Slide 24
Slide 24 text
$3*41%.
• σʔλੳͷϑϨʔϜϫʔΫ
• σʔλʹؔ͢Δ৴པੑͱͳʹ͔Λཧղ͢Δ
• ৴པੑΛվળɾҡ͍࣋ͯͨ͘͠ΊʹඞཁෆՄܽ
Slide 25
Slide 25 text
Ϗδωεͷཧղ
• ࣄۀͷํੑઓུɺϏδωεͷඪɾతΛܾΊΔ
• ݱࡏͱͷΪϟοϓঢ়گΛѲ
• ୡج४Λઃ͚ɺୡʹͲͷΑ͏ʹ͖͔͢ΛܾΊΔ
Slide 26
Slide 26 text
σʔλͷཧղ
• ݱࡏͲͷΑ͏ͳσʔλ͕͋Δ͔Λௐࠪ
• 3%#.4͚ͩͰͳ͘ɺΤΫηϧͳͲͷιϑτΣΞ
֤छ4BB4ͳͲͷར༻ঢ়گѲ
• ۀϑϩʔͳͲཧղ
Slide 27
Slide 27 text
σʔλͷ४උ
• Ͳͷσʔλ͕༗༻͔ɺͲΜͳσʔλ͕ෆ͍ͯ͠Δ͔
• ౷߹ूɺσʔλΫϨϯδϯάͳͲΛߦ͏
• ͲͷΑ͏ͳͷΛ༻͍ͯσʔλج൫Λ࡞Δ͔ʹؔΘΔ
Slide 28
Slide 28 text
ϞσϦϯά
• ϏδωεඪͳͲͷୡΛαϙʔτͰ͖Δ
ϞσϦϯάͳͲΛߦ͏
• ੳ࣠ɺར༻ํ๏ʹԠͯ͡ෳͷ࣠ͰϞσϧ࡞
• ࣌ܥྻूܭͳͷ͔ɺ͔ͬ͠Γͱཧղ͠·͠ΐ͏
Slide 29
Slide 29 text
ධՁ
• ϏδωεඪͳͲͷୡΛαϙʔτͰ͖Δͷ͔ධՁ
• ͲͷఔୡͰ͖Δ͔ɺͲ͏͍ͬͨՌʹͳΓͦ͏͔
• ࡞Δ͚ͩͰͳ͘ΞτΧϜΛେࣄʹ
Slide 30
Slide 30 text
ల։ɾڞ༗
• ेͳධՁ͕ಘΒΕΕɺϑϩʔ
γεςϜɾΞϓϦέʔγϣϯͳͲʹಋೖ
• ܭଌՄೳͳޮՌଌఆͳͲߦ͍
ઓུͳͲʹซͤͯϝϯςφϯεͳͲΛܧଓ͢Δ
Slide 31
Slide 31 text
རؔऀΛཧղ͢Δ
• σʔλ͕ؔ͢ΔઓུϑϩʔΛཧղ͢Δ͜ͱͰ
৴པੑͱԿ͔͕ཧղͰ͖Δ
• ͲͷΑ͏ͳසɺͲͷΑ͏ͳઓུͰσʔλʹؔ͢Δ
Λղܾ͍͔ͯ͘͠
Slide 32
Slide 32 text
σʔλͷ४උ
Slide 33
Slide 33 text
σʔλͷ४උ͍͠
• ෳͷεςʔΫϗϧμ
• αΠϩԽɾ͋ͪͪ͜ʹ͋Δσʔλ
• ࿈ଓੑͷͳ͍σʔλ
Slide 34
Slide 34 text
αΠϩԽ
• ϓϩμΫτͳͲͷνʔϜͰ
͢Ͱʹσʔλநग़֦ு͕ߦΘΕ͍ͯΔ
• ձࣾΛԣஅͨ͠ঢ়گஅ͕͍ͨ͠ɺͳͲ͕͍͠
• ηΩϡϦςΟΨόφϯεޮ͔ͤΒΕͳ͍
Slide 35
Slide 35 text
࿈ଓੑ͕ͳ͍
• ϓϩμΫτಠࣗͷ*%ཧɺෳࡶԽͨ͠*%Ϛοϐϯά
• ҰͭͷγεςϜͰҰ؏ੑ͕͋ͬͯ
ԣஅతͳσʔλͱͯ͠ΈΔͱࠞࡏ
• σʔλʹ͓͚ΔϥΠϑαΠΫϧͷҧ͍
Slide 36
Slide 36 text
ղܾ͢Δʹ
• ϑΟδΧϧ44P5PSϩδΧϧ44P5
• αΠϩԽ͕ਐΜͰ͠·͍ͬͯΔ߹
ϑΟδΧϧ44P5͔ΒͰͳ͚Ε͍͠
• σʔλͷ৴པੑʹ݁͢Δ
Slide 37
Slide 37 text
ΫϥυωΠςΟϒͳσʔλج൫
Slide 38
Slide 38 text
"UIFOBϑΟδΧϧ44P5
• &-5Ͱ4ʹͱʹ͔͘సૹ
• υϝΠϯΠϕϯτͳͲΛཧղͨ͠͏͑Ͱ
΄ͱΜͲ͕݁Ռ߹Ͱͳ͍
• νʔϜͷن͕খ͍͞ͱෆࣗ༝ͳ͠
• ύʔςΟγϣϯઃܭࢥ͍ͷ··
Slide 39
Slide 39 text
ϨΠϠ
Slide 40
Slide 40 text
ϑΟδΧϧ4405
σʔλιʔε
Slide 41
Slide 41 text
ϑΟδΧϧ4405
ίϨΫςΟϯά
ϓϩηογϯά
Slide 42
Slide 42 text
ϑΟδΧϧ4405
ετϨʔδ
Slide 43
Slide 43 text
ϑΟδΧϧ4405
ΞΫηε
Slide 44
Slide 44 text
• ؔΘΔਓ͕૿͑Δͱίϯτϩʔϧ͕͍͠
• σʔλج൫ʹணख͍ͯ͘͠ͱ
ࢥ͍ͬͯͳ͔ͬͨࣄʹग़ձ͏͜ͱ
• ͢ͰʹαΠϩԽ͕Ճ͍ͯ͠Δ߹
ϑΟδΧϧ4405͚ͩͰݶք
Slide 45
Slide 45 text
• ݖݶ͕͍͠
• ͪΐͬͱͨ͠ॲཧ4QBSLͳͲ͕ඞཁͳͨΊ
ηϧϑαʔϏεԽͯ͠ɺਁಁ͕͍͠
ʢ׳Εͳ͍ٕज़ελοΫͷڋ൱ʣ
Slide 46
Slide 46 text
4OPX
fl
BLFҠߦ
• ϑΟδΧϧPSϩδΧϧͱʹղܾ͕Ͱ͖Δ
• ඪ४తͳ42-͚ͩͰଟ͕͘ղܾͰ͖Δ
• ֎෦ωοτϫʔΫΞΫηεՄೳ
• "UIFOBͳͲͰར༻͍ͯͨ͠1BSRVFU͕ͦͷ··ར༻Ͱ͖Δ
Slide 47
Slide 47 text
ϞσϦϯάɾධՁ
Slide 48
Slide 48 text
σʔλͷϥΠϑαΠΫϧΛೝࣝ͢Δ
• ྫ͑υϝΠϯΠϕϯτൃੜ͔Β͍ͭ·Ͱʹ
σʔλ͕࿈ܞ͞ΕΔ͖͔
• 4-*ϝχϡʔGSFTIOFTTͳͲΛࢀߟʹઓུɺ
ར༻༻్ɺσʔλϞσϧʹซͤͯσʔλͷΛܾఆ
Slide 49
Slide 49 text
χΞϦΞϧλΠϜ
3%4ͳͲͷϨίʔυมߋΛݕͯ͠
%FCF[JVN͕ߦใΛ,BGLBసૹ
ඞཁʹԠͯ͡0VUCPYύλʔϯͳͲΛಋೖ
Slide 50
Slide 50 text
χΞϦΞϧλΠϜ
4OPX
fl
BLF$POOFDUPSGPS,BGLB
Λར༻͠ɺ
,BGLBͷτϐοΫʹه͞ΕͨλΠϛϯάͰ
4OPX
fl
BLF࿈ܞ
Slide 51
Slide 51 text
Ϩίʔυྫ
create or replace view HOGE_DB.RAW_DATA.TEST_IU_VIEW (
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
SOURCE_PROCESSED_TS,
SOURCE_SERVER,
SOURCE_DB,
SOURCE_TABLE,
DML_OPERATOR
) as
SELECT
record_content:"after"."id"::NUMBER as ID,
record_content:"after"."name"::NUMBER as NAME,
record_content:"ts_ms"::STRING::DATETIME as DEBEZIUM_PROCESSED_TS,
record_content:"source"."ts_usec"::STRING::DATETIME as SOURCE_PROCESSED_TS,
record_content:"source"."name"::STRING as SOURCE_SERVER,
record_content:"source"."db"::STRING as SOURCE_DB,
record_content:"source"."table"::STRING as SOURCE_TABLE,
record_content:"op"::STRING as DML_OPERATOR
FROM HOGE_DB.RAW_DATA.CDC_RAW_TESTS
WHERE lower(DML_OPERATOR) in ('r', 'c', 'u');
Slide 52
Slide 52 text
Ϩίʔυྫ
create or replace view HOGE_DB.RAW_DATA.TEST_IU_VIEW (
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
SOURCE_PROCESSED_TS,
SOURCE_SERVER,
SOURCE_DB,
SOURCE_TABLE,
DML_OPERATOR
) as
SELECT
record_content:"after"."id"::NUMBER as ID,
record_content:"after"."name"::NUMBER as NAME,
record_content:"ts_ms"::STRING::DATETIME as DEBEZIUM_PROCESSED_TS,
record_content:"source"."ts_usec"::STRING::DATETIME as SOURCE_PROCESSED_TS,
record_content:"source"."name"::STRING as SOURCE_SERVER,
record_content:"source"."db"::STRING as SOURCE_DB,
record_content:"source"."table"::STRING as SOURCE_TABLE,
record_content:"op"::STRING as DML_OPERATOR
FROM HOGE_DB.RAW_DATA.CDC_RAW_TESTS
WHERE lower(DML_OPERATOR) in ('r', 'c', 'u');
ཧআͷ߹CFGPSFΛࢀর
Slide 53
Slide 53 text
Ϩίʔυྫ
create or replace view HOGE_DB.RAW_DATA.TEST_IU_VIEW (
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
SOURCE_PROCESSED_TS,
SOURCE_SERVER,
SOURCE_DB,
SOURCE_TABLE,
DML_OPERATOR
) as
SELECT
record_content:"after"."id"::NUMBER as ID,
record_content:"after"."name"::NUMBER as NAME,
record_content:"ts_ms"::STRING::DATETIME as DEBEZIUM_PROCESSED_TS,
record_content:"source"."ts_usec"::STRING::DATETIME as SOURCE_PROCESSED_TS,
record_content:"source"."name"::STRING as SOURCE_SERVER,
record_content:"source"."db"::STRING as SOURCE_DB,
record_content:"source"."table"::STRING as SOURCE_TABLE,
record_content:"op"::STRING as DML_OPERATOR
FROM HOGE_DB.RAW_DATA.CDC_RAW_TESTS
WHERE lower(DML_OPERATOR) in ('r', 'c', 'u');
ཧআͷ߹E
Slide 54
Slide 54 text
MERGE INTO HOGE_DB.STAGING_DATA.TESTS as tgt
USING (
SELECT * FROM (
SELECT *,
ROW_NUMBER() over (
PARTITION BY ID
ORDER BY DEBEZIUM_PROCESSED_TS DESC
) as row_num
FROM (
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_IU_VIEW
UNION ALL
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_D_VIEW
) as u
) as t1 WHERE t1.row_num = 1
) as src
ON tgt.ID = src.ID
WHEN MATCHED AND src.DML_OPERATOR = 'd' THEN DELETE
WHEN MATCHED AND src.DML_OPERATOR = 'u' THEN
UPDATE SET
tgt.ID = src.ID,
tgt.NAME = src.NAME
WHEN NOT MATCHED AND src.DML_OPERATOR IN ('c', 'r', 'u') THEN
INSERT (
ID,
NAME
)
VALUES (
src.ID,
src.NAME
);
Slide 55
Slide 55 text
MERGE INTO HOGE_DB.STAGING_DATA.TESTS as tgt
USING (
SELECT * FROM (
SELECT *,
ROW_NUMBER() over (
PARTITION BY ID
ORDER BY DEBEZIUM_PROCESSED_TS DESC
) as row_num
FROM (
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_IU_VIEW
UNION ALL
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_D_VIEW
) as u
) as t1 WHERE t1.row_num = 1
) as src
ON tgt.ID = src.ID
WHEN MATCHED AND src.DML_OPERATOR = 'd' THEN DELETE
WHEN MATCHED AND src.DML_OPERATOR = 'u' THEN
UPDATE SET
tgt.ID = src.ID,
tgt.NAME = src.NAME
WHEN NOT MATCHED AND src.DML_OPERATOR IN ('c', 'r', 'u') THEN
INSERT (
ID,
NAME
)
VALUES (
src.ID,
src.NAME
);
3%4ͳͲ͔ΒϨίʔυ͕আ͞Εͨ߹
4OPX
fl
BLF͔Βআ
Slide 56
Slide 56 text
MERGE INTO HOGE_DB.STAGING_DATA.TESTS as tgt
USING (
SELECT * FROM (
SELECT *,
ROW_NUMBER() over (
PARTITION BY ID
ORDER BY DEBEZIUM_PROCESSED_TS DESC
) as row_num
FROM (
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_IU_VIEW
UNION ALL
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_D_VIEW
) as u
) as t1 WHERE t1.row_num = 1
) as src
ON tgt.ID = src.ID
WHEN MATCHED AND src.DML_OPERATOR = 'd' THEN DELETE
WHEN MATCHED AND src.DML_OPERATOR = 'u' THEN
UPDATE SET
tgt.ID = src.ID,
tgt.NAME = src.NAME
WHEN NOT MATCHED AND src.DML_OPERATOR IN ('c', 'r', 'u') THEN
INSERT (
ID,
NAME
)
VALUES (
src.ID,
src.NAME
);
Ϩίʔυ͕ߋ৽͞Εͨ߹
4OPX
fl
BLFͷϨίʔυߋ৽
Slide 57
Slide 57 text
MERGE INTO HOGE_DB.STAGING_DATA.TESTS as tgt
USING (
SELECT * FROM (
SELECT *,
ROW_NUMBER() over (
PARTITION BY ID
ORDER BY DEBEZIUM_PROCESSED_TS DESC
) as row_num
FROM (
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_IU_VIEW
UNION ALL
SELECT
ID,
NAME,
DEBEZIUM_PROCESSED_TS,
DML_OPERATOR
FROM HOGE_DB.RAW_DATA.TEST_D_VIEW
) as u
) as t1 WHERE t1.row_num = 1
) as src
ON tgt.ID = src.ID
WHEN MATCHED AND src.DML_OPERATOR = 'd' THEN DELETE
WHEN MATCHED AND src.DML_OPERATOR = 'u' THEN
UPDATE SET
tgt.ID = src.ID,
tgt.NAME = src.NAME
WHEN NOT MATCHED AND src.DML_OPERATOR IN ('c', 'r', 'u') THEN
INSERT (
ID,
NAME
)
VALUES (
src.ID,
src.NAME
);
4OPX
fl
BLFʹσʔλ͕ͳ͍͕ɺ
আҎ֎ͷϨίʔυૢ࡞͕͋ͬͨ߹
*OTFSU
Slide 58
Slide 58 text
͕ྑ͍Ͱγϯϓϧʹ
• ଟগͷ࿈ܞઃఆ͋Γ·͕͢ɺ42-͚ͩͰ݁
• ࿈ܞ͕ࣦഊͯ͠σʔλյΕͳ͍
• ࿈ܞ͍ͨ͠͠߹%FCF[JVNͰ಄͔Β࠶࿈ܞ
• ϦεΫཧղ͠ɺӨڹൣғΛ࠷খݶʹ
Slide 59
Slide 59 text
ߟྀ
• Ϩίʔυ͕ଟ͍߹ɺ
༨ܭͳ௨৴͕ൃੜ͠ͳ͍Α͏ʹ͍ͨ͠߹ͳͲ4ͳͲซ༻
• ϦΞϧλΠϜੑ͕ຊʹඞཁ͔Ͳ͏͔
ٻΊΒΕΔɾ৴པੑΛ໌Β͔ʹ͢Δ
• ECUͳͲར༻
Slide 60
Slide 60 text
֎෦ωοτϫʔΫܦ༝ͷ࿈ܞ
• "1*͕ެ։͞Ε͍ͯΔαʔϏεͳͲͦͷ··࿈ܞՄೳ
• 6%'ετΞυϓϩγʔδϟͱͯ͠ΈࠐΊΔͷ
• σʔλج൫ͳͲͷετϨʔδʹͳͯ͘
ཧతʹ౷߹Մೳ
Slide 61
Slide 61 text
τΠϧͷݮ
Slide 62
Slide 62 text
τΠϧͷݮ
• ηϧϑαʔϏεͷͨΊͷࣗಈԽ
&-54OPX
fl
BLFͳͲ
• ϓϩμΫτ͝ͱͷՄࢹԽπʔϧಋೖͳͲͷͨΊͷ
ݖݶઃܭ
• Ξϥʔτͷ௨
Slide 63
Slide 63 text
τΠϧͷݮ
• 4DIFNB&WPMVUJPO
• δϣϒεέδϡʔϧཧ
• ϦτϥΠ
Slide 64
Slide 64 text
ͳΜͰࣗಈԽ͢Εྑ͍Θ͚Ͱͳ͍
• ࣗಈԽ͗ͨ͢͜͠ͱʹΑΔࣄނ
• νʔϜͷೝෛՙ
• νʔϜͷ݈߁ঢ়ଶɾϞνϕʔγϣϯ
Slide 65
Slide 65 text
࣭ςετ
Slide 66
Slide 66 text
ਖ਼֬ੑ
• ଞڥͰ࡞ΒΕͨσʔλͱࠩҟ͕ͳ͍͔Ͳ͏͔
• ֹۚܭࢉͳͲͷζϨਖ਼֬ͳҙࢥܾఆʹͭͳ͕Βͳ͍
• ܭࢉࣜϨίʔυɺΧϥϜͳͲظΛຬ͔ͨ͢
• Ͳͷ͘Β͍ڐ༰͞ΕΔͷ͔ೝࣝΛ͋ΘͤΔ
Slide 67
Slide 67 text
ਖ਼֬ੑ
• 99͔Β࿈ܞ͞Εͨσʔλ͕ؒͰ
औΓѻֹ͍ۚͱҰக͍ͯ͠Δ͜ͱͳͲ
• ظؒͰɺఆΊͨ݅Ҏ্ະ࿈ܞͣΕ͕͋Δ߹
ରԠΛ͠ͳ͚ΕͳΒͳ͍
• ೝ͕ࣝ߹্ͬͨͰܰඍͳͷͰ͋Ε࠶࿈ܞ࣮ߦͳͲ
Slide 68
Slide 68 text
Ұ؏ੑ
• Ұ؏ੑͷ͋ΔϑΥʔϚοτʹԊ͍ͬͯΔ͔Ͳ͏͔
• ͓͔͠ͳσʔλϑΥʔϚοτ͕ࠞࡏ͍ͯ͠ͳ͍͔Ͳ͏͔
߹ੑʹ͕ͳ͍͔
• ಉ༷ʹ4-0ͳͲΛ໌ه͠ɺ
σʔλͷमਖ਼PSϑϩʔͳͲຊ࣭తͳվળΛߦ͏
Slide 69
Slide 69 text
͜͜ʹ͋Δͷ΄ΜͷҰ෦
Slide 70
Slide 70 text
·ͱΊ
• ࣄۀཧղͱυϝΠϯΛ͔ͬ͠ΓͱטΈࡅ͘
• ࣄۀͷະདྷΛ૾͠ɺͦ͜ʹඞཁͳσʔλΛཧղ͢Δ
• 43&ͷϓϥΫςΟεΛऔΓೖΕɺଟ͘Λר͖ࠐΜͰਪਐ
• ΫϥυΛ׆༻ͯ͠ར༻͍͢͠σʔλج൫࡞Γ