Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
RDBアンチパターン
Search
soudai sone
November 03, 2016
Technology
79
64k
RDBアンチパターン
PHPカンファレンス2016の資料です
http://phpcon.php.gr.jp/2016/
soudai sone
November 03, 2016
Tweet
Share
More Decks by soudai sone
See All by soudai sone
Gitlab本から学んだこと - そーだいなるプレイバック / gitlab-book
soudai
4
440
**強い**エンジニアのなり方 - フィードバックサイクルを勝ち取る / grow one day each day
soudai
65
19k
マルチテナントの実現におけるDB設計とRLS / Utilizing RSL in multi-tenancy
soudai
26
6.3k
キャッシュと向き合う、キャッシュと共に生きる / cache pattern
soudai
31
11k
RDBアンチパターンと戦う - 削除フラグ 完全攻略ガイド / delete flag
soudai
25
16k
コミュニティと共に生きる - キャリアの螺旋 / live with community
soudai
7
4.4k
今年1年間の”アウトプット”を振り返る / soudai's output - 2023
soudai
12
1.9k
「GitLabに学ぶ 世界最先端のリモート組織のつくりかた」の輪読会のススメ - そーだいなる輪読会キックオフ / soudai-kickoff
soudai
0
280
Webアプリケーションのパフォーマンス・チューニングの勘所 / web tuningperformance
soudai
40
12k
Other Decks in Technology
See All in Technology
Além do else! Categorizando Pokemóns com Pattern Matching no JavaScript
wmsbill
0
640
Janus
bkuhlmann
1
490
Cracking the KubeCon CfP
inductor
2
250
ChatworkのSRE部って実は 半分くらいPlatform Engineering部かもしれない
saramune
0
160
検証を通して見えてきたTiDBの性能特性
lycorptech_jp
PRO
6
3.8k
Azureの基本的な権限管理の勉強会
yhana
0
590
Python と Snowflake はズッ友だょ!~ Snowflake の Python 関連機能をふりかえる ~
__allllllllez__
1
120
オーナーシップを持つ領域を明確にする
konifar
13
3.2k
どうするコスト最適化のトレードオフ
tetsuyaooooo
1
530
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
360
Vertex AI を中心に 生成AIのアップデートを共有します
kaz1437
0
310
競技としてのKaggle、役に立つKaggle
yu4u
3
1.8k
Featured
See All Featured
YesSQL, Process and Tooling at Scale
rocio
164
13k
Bootstrapping a Software Product
garrettdimon
PRO
302
110k
GraphQLの誤解/rethinking-graphql
sonatard
50
9.2k
The Pragmatic Product Professional
lauravandoore
25
5.8k
Ruby is Unlike a Banana
tanoku
96
10k
GraphQLとの向き合い方2022年版
quramy
32
12k
Testing 201, or: Great Expectations
jmmastey
28
6.4k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
7
1k
Adopting Sorbet at Scale
ufuk
68
8.6k
Writing Fast Ruby
sferik
621
60k
Creatively Recalculating Your Daily Design Routine
revolveconf
210
11k
Navigating Team Friction
lara
178
13k
Transcript
RDBΞϯνύλʔϯ 1)1FSʹͬͯ΄͍͠ ϦϨʔγϣφϧσʔλϕʔεͷ͜ͱ
What is it? ࣭Twitterͷϋογϡλά #phpcon_rdb_qa Ͱ͓ئ͍͠·͢
What is it? σʔλϕʔεͷण໋ ΞϓϦέʔγϣϯΑΓ͍
What is it? ͦΜͳ͍͖߹͍ʹͳΔσʔλϕʔε ͷେͳࣄΛ͓͑͠·͢
What is it? ରͷσʔλϕʔειϑτΣΞ
What is it? PostgreSQL 9.6ͱMySQL 5.7(InnoDB)ʹݶΔ ଞͷRDBͷ͠·ͤΜ
What is it? RDBΞϯνύλʔϯ
What is it? ਖ਼نԽͯ͠… ࣮ߦܭըΛݟͯ… SQLΛॻ͍ͯ…
What is it? ྑ͔Εͱࢥͬͯͬͨͷʹམͪͯ͠·͏᠘
What is it? Ξϯνύλʔϯ
What is it? Ξϯνύλʔϯ ↓ ޙʑʹۤ͠ΈΛੜΉ
What is it? ΞϯνύλʔϯΛΔ
What is it? ΞϯνύλʔϯΛΔ ↓ ಉ͡աͪΛ܁Γฦ͞ͳ͍
What is it?
What is it? SQLΞϯνύλʔϯݫબ͞Εࣦͨഊू
What is it? SQLΞϯνύλʔϯݫબ͞Εࣦͨഊू ↓ DBͷϊϋ͕٧·໊ͬͨஶ
What is it? ࠓRDBͷࣦഊྫΛ͝հ͠·͢
͋͐͡Μͩ ̍ɹࣗݾհ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
͋͐͡Μͩ ̍ɹࣗݾհ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
ࣗݾհ ໊લɿીࠜɹେʢͦͶɹ͚ͨͱʣ ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦ ɹɹٕज़తʹLLܥݴޠͱ͔RDB͕͖Ͱ͢
ࣗݾհ ໊લɿીࠜɹେʢͦͶɹ͚ͨͱʣ ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦ ɹɹٕज़తʹLLܥݴޠͱ͔RDB͕͖Ͱ͢
தࠃํDBษڧձ https://dbstudychugoku.github.io/
தࠃํDBษڧձ https://dbstudychugoku.github.io/ աڈͷࢿྉ͕߇͑Ίʹݴͬͯ ࠷ߴͰ࠷ڧͳͷͰੋඇνΣοΫʂ
͋͐͡Μͩ ̍ɹࣗݾհ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
ڧ͗͢Δґଘ σʔλϕʔεͷநԽ
ڧ͗͢Δґଘ w %BUB"DDFTT0CKFDUʢ%"0ʣ w 0CKFDU3FMBUJPOBM.BQQJOH 03. w %#.JHSBUJPO
ڧ͗͢Δґଘ w %PDUSJOF w &MPRVFOU03. w *EJPSN w 1BSJT w
ͳͲͳͲʜ
ڧ͗͢Δґଘ ͜ΕΒͷख๏πʔϧͱͯศར
ڧ͗͢Δґଘ ͜ΕΒͷख๏πʔϧͱͯศར ˣ ੍ɾͱҾ͖͑ʹ ߴ͍ੜ࢈ੑΛ༩͑ͯ͘ΕΔ
ڧ͗͢Δґଘ ੍ͱ
ڧ͗͢Δґଘ ੍ ্࣮ͷϧʔϧΛڧ͍ΔࣄͰ ίʔυͷهड़ྔΛݮΒ͢
ڧ͗͢Δґଘ ੍ ্࣮ͷϧʔϧΛڧ͍ΔࣄͰ ίʔυͷهड़ྔΛݮΒ͢ कΒͳ͍ͱίϯύΠϧΤϥʔ ࣮ઃܭʹ݁
ڧ͗͢Δґଘ ੍ ্࣮ͷϧʔϧΛڧ͍ΔࣄͰ ίʔυͷهड़ྔΛݮΒ͢ कΒͳ͍ͱίϯύΠϧΤϥʔ ࣮ઃܭʹ݁ ςʔϒϧͷJEΧϥϜඞਢ ࢦఆͰ͖Δܕ σʔλΞΫηεͷखஈͳͲ
ڧ͗͢Δґଘ ܾ·Γ͝ͱ ύλʔϯ ΛकΔࣄͰ ઃܭ࣮ͷҰ؏ੑͱ࠶ར༻͕Մೳ
ڧ͗͢Δґଘ ܾ·Γ͝ͱ ύλʔϯ ΛकΔࣄͰ ઃܭ࣮ͷҰ؏ੑͱ࠶ར༻͕Մೳ कΒͳͯ͘ίʔυಈ͘ ϞϥϧࣝͷෆͳͲͰແࢹ͞ΕΔ έʔε͕͋Δ
ڧ͗͢Δґଘ ܾ·Γ͝ͱ ύλʔϯ ΛकΔࣄͰ ઃܭ࣮ͷҰ؏ੑͱ࠶ར༻͕Մೳ σβΠϯύλʔϯ ઃܭࢥ ίʔυنͳͲ कΒͳͯ͘ίʔυಈ͘
ϞϥϧࣝͷෆͳͲͰແࢹ͞ΕΔ έʔε͕͋Δ
ڧ͗͢Δґଘ σʔλϕʔεͷநԽ ੍ͱͷੈք ϧʔϧ Ϛφʔ
ڧ͗͢Δґଘ ੍ͱͱҾ͖͑ʹ ࣦ͍ͬͯΔࣄ
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ ܕͱ͔ϚςϏϡʔͱ͔τϦΨʔͱ͔DIFDL੍ͱ͔
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ 8JOEPXؔͱ͔8*5)۟ͱ͔
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ
ڧ͗͢Δґଘ w 3%#ͷػೳ w 42-ͷڧྗͳจ๏ w 3%#ͷຊདྷͷͱઃܭ
ڧ͗͢Δґଘ 3%#ͷ w σʔλΛอଘ͢Δ w σʔλΛऔΓग़͢ w σʔλΛकΔ
ڧ͗͢Δґଘ ͋ͳͨͷσʔλ ͪΌΜͱकΕͯ·͔͢ʁ
ڧ͗͢Δґଘ %#ͷઃܭʹڧ੍͍͕ൃੜ͢Δ
ڧ͗͢Δґଘ %#ͷઃܭʹڧ੍͍͕ൃੜ͢Δ ˣ 03.Λҙࣝͨ͠εΩʔϚઃܭ 3%#.4Λҙࣝͨ͠Ϋϥεઃܭ
ڧ͗͢Δґଘ %#ͷઃܭʹڧ੍͍͕ൃੜ͢Δ ˣ 03.Λҙࣝͨ͠εΩʔϚઃܭ 3%#.4Λҙࣝͨ͠Ϋϥεઃܭ ྆ྠ͕ΩϨΠʹճ͍ͬͯΔͱ͖ ߴ͍ੜ࢈ੑΛൃش͢Δ
ڧ͗͢Δґଘ ੍ͱ่͕ΕΔͱ͖
ڧ͗͢Δґଘ σʔλ͕ͨ࣌͠
ڧ͗͢Δґଘ σʔλ͕ͨ࣌͠ αʔϏε͕ͨ࣌͠
ڧ͗͢Δґଘ σʔλ͕ͨ࣌͠ ˣ ΞϓϦέʔγϣϯଆ͚ͩͰ Χόʔग़དྷͳ͘ͳͬͨ࣌ αʔϏε͕ͨ࣌͠
ڧ͗͢Δґଘ ੍ͱ่͕ΕΔ࣌ͷྫ w ΫΤϦ͕ࡹ͚ͳ͘ͳͬͨ w γϟʔσΟϯά͕ඞཁ w */%&9͕ඞཁ͕ͩར༻Ͱ͖ͳ͍ w "-5&3จ͕ාͯ͘ྲྀͤͳ͍
ڧ͗͢Δґଘ ੍ͱ่͕ΕΔ࣌ͷྫ w ΫΤϦ͕ࡹ͚ͳ͘ͳͬͨ w γϟʔσΟϯά͕ඞཁ w */%&9͕ඞཁ͕ͩར༻Ͱ͖ͳ͍ w "-5&3จ͕ාͯ͘ྲྀͤͳ͍
ύϑΥʔϚϯεʹΑ੍ͬͯͱ่͕ΕΔ
ڧ͗͢Δґଘ ݱঢ়Ͱ03. ΠϯϐʔμϯεɾϛεϚον Λղܾ͢ΔͨΊͷଘࡏ Ͱ͋ͬͯ3%#ͷશͳநԽͰͳ͍
ڧ͗͢Δґଘ ॲํᝦ
ڧ͗͢Δґଘ ॲํᝦ ੍ͱʹΑͬͯ ࣦ͍ͬͯΔଘࡏΛΕͳ͍͜ͱ
͋͐͡Μͩ ̍ɹࣗݾհ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
Ӆ͞Εͨঢ়ଶ σʔλϕʔε σʔλอଘ͢ΔͨͩͷശͰແ͍
Ӆ͞Εͨঢ়ଶ ϦϨʔγϣφϧϞσϧ
Ӆ͞Εͨঢ়ଶ ϦϨʔγϣφϧϞσϧ ˣ ࣄ࣮ͷΈΛอଘ͢Δ
Ӆ͞Εͨঢ়ଶ ࣄ࣮ͱঢ়ଶ
Ӆ͞Εͨঢ়ଶ ঢ়ଶͷྫ wϢʔβͷঢ়ଶ TUBUVTΧϥϜʣ w՝ۚঢ়ଶʢ༩৴ɺٻࡁΈʣ wΧʔτใʢΧΰͷதɺߪೖࡁΈʣ
Ӆ͞Εͨঢ়ଶ Ϩίʔυʹঢ়ଶΛ࣋ͨͤΔͱةݥ
JE OBNF BHF EFMFUF@qBH TPOF TPVEBJ
UBLFUPNP TPOF
JE OBNF BHF EFMFUF@qBH TPOF TPVEBJ
UBLFUPNP TPOF আͱݴ͏ঢ়ଶΛϑϥάͰදݱ
Ӆ͞Εͨঢ়ଶ $user = $this->get_user($user_id); if ($user->get(‘delete_falg’) == 1) { //
আࡁΈͷϢʔβͷॲཧ return }
Ӆ͞Εͨঢ়ଶ $user = $this->get_user($user_id); if ($user->get(‘delete_falg’) == 1) { //
আࡁΈͷϢʔβͷॲཧ return } σʔλͷதͷঢ়ଶΞϓϦέʔγϣϯ औΓग़͢·ͰΘ͔Βͳ͍
Ӆ͞Εͨঢ়ଶ w 6OJRVF੍͕ࢮΜͩΓ w */%&9͕ࢮΜͩΓ w ֎෦Ωʔ੍͕ࢮΜͩΓ
Ӆ͞Εͨঢ়ଶ Ϩίʔυ͔Β ঢ়ଶ͕ݟ͑ͳ͍࣌ ͬͱةݥ
ച্ JE ച্ֹۚ ച্ ૹঢ়ଶ ૹࡁ
ൃத ộ ộ ộ ച্JE JE ݸ ߪೖऀ TPOF TPOF TPOF TPOF JE ໊ Ձ֨ 42-࣮ફೖ Ϧʔμϒϧίʔυ ϓϩάϥϚͷͨΊͷ42- σʔλϕʔεɾϦϑΝΫλϦϯά Χʔτ ച্
ച্JE JE ݸ ߪೖऀ TPOF
TPOF TPOF TPOF JE ໊ Ձ֨ 42-࣮ફೖ Ϧʔμϒϧίʔυ ϓϩάϥϚͷͨΊͷ42- σʔλϕʔεɾϦϑΝΫλϦϯά ച্ ച্ JE ച্ֹۚ ച্ ૹঢ়ଶ ૹࡁ ൃத ộ ộ ộ Χʔτ
ച্JE JE ݸ ߪೖऀ TPOF
TPOF TPOF TPOF JE ໊ Ձ֨ 42-࣮ફೖ Ϧʔμϒϧίʔυ ϓϩάϥϚͷͨΊͷ42- σʔλϕʔεɾϦϑΝΫλϦϯά ച্ ച্ JE ച্ֹۚ ച্ ૹঢ়ଶ ૹࡁ ൃத ộ ộ ộ ফඅ੫ͷঢ়ଶ͕ӅΕͯΔ ͱ͕ͰมΘΔ Χʔτ
ച্JE JE ݸ ߪೖऀ TPOF
TPOF TPOF TPOF JE ໊ Ձ֨ 42-࣮ફೖ Ϧʔμϒϧίʔυ ϓϩάϥϚͷͨΊͷ42- σʔλϕʔεɾϦϑΝΫλϦϯά ച্ ച্ JE ച্ֹۚ ച্ ૹঢ়ଶ ૹࡁ ൃத ộ ộ ộ ͍ͭૹঢ়ଶ͕ มΘ͔ͬͨΘ͔Βͳ͍ Χʔτ
ച্JE JE ݸ ߪೖऀ TPOF
TPOF TPOF TPOF JE ໊ Ձ֨ 42-࣮ફೖ Ϧʔμϒϧίʔυ ϓϩάϥϚͷͨΊͷ42- σʔλϕʔεɾϦϑΝΫλϦϯά ച্ ച্ JE ച্ֹۚ ച্ ૹঢ়ଶ ૹࡁ ൃத ộ ộ ộ Χʔτ
ച্JE JE ݸ ߪೖऀ TPOF
TPOF TPOF TPOF JE ໊ Ձ֨ 42-࣮ફೖ Ϧʔμϒϧίʔυ ϓϩάϥϚͷͨΊͷ42- σʔλϕʔεɾϦϑΝΫλϦϯά ച্ ໊͕มΘͬͨΒʁ Ձ֨Λม͑ͨΒʁ ച্ͷࣄ࣮ͱෆ߹͕ੜ·ΕΔ ച্ JE ച্ֹۚ ച্ ૹঢ়ଶ ૹࡁ ൃத ộ ộ ộ Χʔτ
Ӆ͞Εͨঢ়ଶ Ӆ͞Εͨঢ়ଶͷྫ wૹঢ়ଶͷཤྺ wߪೖཤྺͷফඅ੫ͷ༁ wআߋ৽ͷཤྺ
Ӆ͞Εͨঢ়ଶ ࣄ࣮ͷΈΛอଘ͢Δ
Ӆ͞Εͨঢ়ଶ ࣄ࣮ͷΈΛอଘ͢Δ ˣ ࣄ࣮ͷཤྺΛอଘ͢Δ
ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্
ộ ộ ộ ফඅ੫ ച্ ച্JE ૹঢ়ଶ ࡞࣌ ൃத ૹத ೲࡁ ൃத ফඅ੫ ༗ޮ ࣦޮ OVMM ૹঢ়گ
ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্
ộ ộ ộ ফඅ੫ ച্ ച্JE ૹঢ়ଶ ࡞࣌ ൃத ૹத ೲࡁ ൃத ফඅ੫ ༗ޮ ࣦޮ OVMM ૹঢ়گ ૹঢ়گͷཤྺΛ࣋ͭ ߋ৽Ͱແ͘ՃͰྺ࢙Λ࡞Δ
ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্
ộ ộ ộ ফඅ੫ ച্ ച্JE ૹঢ়ଶ ࡞࣌ ൃத ૹத ೲࡁ ൃத ফඅ੫ ༗ޮ ࣦޮ OVMM ૹঢ়گ ಉ༷ʹফඅ੫ͷྺ࢙Λ࣋ͭ ฦ࣌ͷ͍͠ͷॲཧͷ࣌ͳͲ Ͱ࣋ͬͯͳ͍ͱࢮ͵
ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্
ộ ộ ộ ফඅ੫ ച্ ച্JE ૹঢ়ଶ ࡞࣌ ൃத ૹத ೲࡁ ൃத ফඅ੫ ༗ޮ ࣦޮ OVMM ૹঢ়گ ಉ༷ʹফඅ੫ͷྺ࢙Λ࣋ͭ ฦ࣌ͷ͍͠ͷॲཧͷ࣌ͳͲ Ͱ࣋ͬͯͳ͍ͱࢮ͵ 1PTUHSF42-ͷൣғܕΛ͏ͱ༗ޮൣғ ΛεϜʔζʹॲཧग़དྷΔ
ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্
ộ ộ ộ ফඅ੫ ച্ ച্JE ૹঢ়ଶ ࡞࣌ ൃத ૹத ೲࡁ ൃத ফඅ੫ ༗ޮ ࣦޮ OVMM ૹঢ়گ ܭࢉͨ͠ΒಘΔࣄ͕ग़དྷΔ ඇਖ਼نԽͷҰͭ ύϑΥʔϚϯεͱ૬ஊ
ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্
ộ ộ ộ ফඅ੫ ച্ ച্JE ૹঢ়ଶ ࡞࣌ ൃத ૹத ೲࡁ ൃத ফඅ੫ ༗ޮ ࣦޮ OVMM ૹঢ়گ ܭࢉͨ͠ΒಘΔࣄ͕ग़དྷΔ ඇਖ਼نԽͷҰͭ ύϑΥʔϚϯεͱ૬ஊ .Z42-ͷԾྻΛར༻͢Δͱ ΑΓΩϨΠʹ࣮ग़དྷΔ
Ӆ͞Εͨঢ়ଶ σʔλϕʔε্ʹແ͍σʔλ ΞϓϦଆͰ࡞Γग़ͤͳ͍
Ӆ͞Εͨঢ়ଶ Ӆ͞Εͨঢ়ଶ͕͋Δͱ ྫ֎ରԠͷ࣌ʹࢮ͵
Ӆ͞Εͨঢ়ଶ ॲํᝦ
Ӆ͞Εͨঢ়ଶ ॲํᝦ దਖ਼ͳܗͰσʔλΛอଘ͢Δ
Ӆ͞Εͨঢ়ଶ ॲํᝦ దਖ਼ͳܗͰσʔλΛอଘ͢Δ ˣ ͪΌΜͱϦεΫϔοδΛ͢Δ
͋͐͡Μͩ ̍ɹࣗݾհ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
ϩοΫͷޭࡑ τϥϯβΫγϣϯͱσʔλ߹ੑ
ϩοΫͷޭࡑ τϥϯβΫγϣϯϨϕϧ
ϩοΫͷޭࡑ τϥϯβΫγϣϯϨϕϧ ໊લ Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍
ಡΈऔΓରͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ
ϩοΫͷޭࡑ τϥϯβΫγϣϯϨϕϧ ໊લ Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍
ಡΈऔΓରͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ .Z42-ͷσϑΥϧτ͜͜
ϩοΫͷޭࡑ τϥϯβΫγϣϯϨϕϧ ໊લ Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍
ಡΈऔΓରͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ 1PTUHSF42- 0SBDMF%# 42-4FSWFS ͷσϑΥϧτ͜͜
ϩοΫͷޭࡑ τϥϯβΫγϣϯϨϕϧ ໊લ Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍
ಡΈऔΓରͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ 1PTUHSF42- 0SBDMF%# 42-4FSWFS ͷσϑΥϧτ͜͜ ϑΝϯτϜϦʔυμʔςΟϦʔυͳͲͷࠓ͠·ͤΜ ʮ͑ʁͳʹͦΕʯͬͯਓࠓ͙͢άάοͯษڧͨ͠ํ͕͍͍Ͱ͢
ϩοΫͷޭࡑ ͳͥτϥϯβΫγϣϯ͕ඞཁ͔
ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# " ಉ࣌ʹߪೖ
ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# " ಉ࣌ʹߪೖ ࡏݿ͕࠷ޙͷݸͩͬͨͱ͖ɺ ͲͪΒΛ༏ઌ͢Δ͔ʁ
ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# " ઌʹΞΫηεͨ͠ͷͰ ʹରͯ͠ϩοΫΛऔಘ ࡏݿ͕ແ͍ͷͰ ΤϥʔʹͳΔ
ϩοΫͷޭࡑ ฒྻॲཧͷσʔλͷෆ߹Λ͙
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌ ྫ͑σΠϦʔͷདྷళϙΠϯτͷॲཧͱ͔ ߪೖ࣌ͷϙΠϯτݮࢉͷॲཧͱ͔
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌ ˓˓ݶఆͷࡏݿॲཧͱ͔ Ұਓ͋ͨΓͷߪೖݶքͷॲཧͱ͔
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌
ϩοΫͷޭࡑ ͋ͳͨͷॲཧେৎʁ w ෳͷϒϥβΛ։͍ͯಉ࣌ΞΫηε w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌ w ฒྻॲཧΛॻ͍ͨ࣌ Ұͭͷσʔλʹରͯ͠ෳͷαʔϏε͕ΞΫηε͢Δ࣌ͱ͔ ߴԽͷͨΊʹඇಉظॲཧϚϧνεϨουॲཧΛ࡞ͬͨ࣌ͱ͔
ϩοΫͷޭࡑ ϩοΫͷ ࣄ࣮ʹج͍ͯ࣌ܥྻʹॲཧͯ͠ σʔλΛదʹकΔ
ϩοΫͷޭࡑ ͜͜·ͰϩοΫͷޭࡑͷޭͷ෦
ϩοΫͷޭࡑ ϩοΫͷࡑ
ϩοΫͷޭࡑ ϩοΫʹΑΔੑೳԆ
ϩοΫͷޭࡑ ϩοΫʹΑΔੑೳԆ ˣ ϩοΫͪʹΑΔॲཧԆ
ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# " ઌʹΞΫηεͨ͠ͷͰ ʹରͯ͠ϩοΫΛऔಘ ։์ͪ ͜ͷαΠτ͍ͳ͊
ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# " ઌʹΞΫηεͨ͠ͷͰ ʹରͯ͠ϩοΫΛऔಘ ։์ͪ ͜ͷαΠτ͍ͳ͊ ྆ํͷϢʔβ͕ͦΕͧΕͷϩοΫͰ ͨ͞Εͨ߹σοτϩοΫ
ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# " ઌʹΞΫηεͨ͠ͷͰ ʹରͯ͠ϩοΫΛऔಘ ։์ͪ ͜ͷαΠτ͍ͳ͊ ྆ํͷϢʔβ͕ͦΕͧΕͷϩοΫͰ ͨ͞Εͨ߹σοτϩοΫ
ϩοΫͷޭࡑ ओͳϩοΫͷछྨ w ഉଞ F9DMVEFE ϩοΫ w ڞ༗ 4IBSFE ϩοΫ
ϩοΫͷޭࡑ ओͳϩοΫͷछྨ w ഉଞ F9DMVEFE ϩοΫ w ڞ༗ 4IBSFE ϩοΫ
ϩοΫରʹରͯ͠ɺଞͷΞΫηεΛҰېࢭ͢Δ ଞͷΞΫηεߋ৽ɾআɾࢀরશͯग़དྷͳ͍ ॻ͖ࠐΈϩοΫͱݺΕΔࣄ͋Δ
ϩοΫͷޭࡑ ओͳϩοΫͷछྨ w ഉଞ F9DMVEFE ϩοΫ w ڞ༗ 4IBSFE ϩοΫ
ϩοΫରʹରͯ͠ɺࢀরҎ֎ͷॲཧΛېࢭ͢Δ ଞͷΞΫηεࢀর 4&-&$5 Λ͢Δ͜ͱ͕ग़དྷΔ ಡΈࠐΈϩοΫͱݺΕΔࣄ͋Δ
ϩοΫͷޭࡑ ϩοΫΛΒͳ͍ॴͰऔ͍ͬͯΔ
ϩοΫͷޭࡑ ϩοΫΛΒͳ͍ॴͰऔ͍ͬͯΔ ˣ ҉తϩοΫ
ϩοΫͷޭࡑ .Z42-ͷ߹
ϩοΫͷޭࡑ 1PTUHSF42-ͷ߹
ϩοΫͷޭࡑ ϩοΫΛΒͳ͍ॴͰऔ͍ͬͯΔ ˣ ҉తϩοΫ ಛʹڞ༗ϩοΫසൟʹऔ͍ͬͯΔ
ϩοΫͷޭࡑ ϩοΫσʔλΛकΔͨΊʹඞཁ
ϩοΫͷޭࡑ ϩοΫσʔλΛकΔͨΊʹඞཁ ˣ ύϑΥʔϚϯεͱτϨʔυΦϑ
ϩοΫͷޭࡑ w ϩοΫͪͰॲཧ͕٧·Δ w ͍4&-&$5ʹΑͬͯߋ৽ॲཧ͕٧·Δ w ߋ৽ର͕ίϯϑϦΫτͯͨ͠͞ΕΔ w σοτϩοΫɺτϥϯβΫγϣϯࢮ͵
ϩοΫͷޭࡑ αʔϏεͷϝΠϯςʔϒϧةݥ w ଟ͘ͷࢀরͰར༻͍ͯ͠Δ w ߋ৽සൟʹ͋Δ w +0*/αϒΫΤϦͷରʹͳ͍ͬͯΔ
ϩοΫͷޭࡑ ͦͦϩοΫͷॲཧ 3%#ʹΑ͔ͬͯͳΓҧ͏
ϩοΫͷޭࡑ ͦͦϩοΫͷॲཧ 3%#ʹΑ͔ͬͯͳΓҧ͏ ॲํᝦΛҰׅΓͰݴ͑ͳ͍
ϩοΫͷޭࡑ ϩοΫσʔλΛकΔͨΊʹඞཁ
ϩοΫͷޭࡑ ϩοΫσʔλΛकΔͨΊʹඞཁ ˣ ͔͠͠τϥϒϧͷ࣌ͷࠜਂ͍
ϩοΫͷޭࡑ ॲํᝦ
ϩοΫͷޭࡑ ॲํᝦ ϩοΫΛΔ
ϩοΫͷޭࡑ ະͳΔΈා͍
ϩοΫͷޭࡑ ະͳΔΈා͍ ˣ ͔ͬ͠Γͱཧղ͢Δࣄ
ϩοΫͷޭࡑ ϩοΫΛݟΔ
ϩοΫͷޭࡑ ϩοΫΛݟΔ ˣ ֤%#ʹ༻ҙ͞Ε͍ͯΔΈΛ͏
ϩοΫͷޭࡑ ϜʔΞͷ๏ଇͷݶք
ϩοΫͷޭࡑ ϜʔΞͷ๏ଇͷݶք ˣ ࣌ฒྻɾࢄॲཧ࣌
ϩοΫͷޭࡑ ϜʔΞͷ๏ଇͷݶք ˣ ࣌ฒྻɾࢄॲཧ࣌ ଟ͘ͷιϑτΣΞΤϯδχΞฒྻॲཧ͕ۤख ͔ͩΒͦ͜कΓͷΈ͔ͬ͠ΓΔ
͋͐͡Μͩ ̍ɹࣗݾհ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
·ͱΊ ػೳπʔϧʹґଘ͠ա͗ͳ͍
·ͱΊ ػೳπʔϧʹґଘ͠ա͗ͳ͍ ˣ γϯϓϧͳઃܭશͯʹউΔ
·ͱΊ σʔλͷण໋ίʔυΑΓ͍
·ͱΊ Ұ࡞ͬͨ%#ফͤͳ͍
·ͱΊ Ұ࡞ͬͨ%#ফͤͳ͍ ˣ ઃܭ͕େࣄ
·ͱΊ σʔλϕʔεͷࢮαʔϏεͷࢮ
·ͱΊ σʔλϕʔεͷࢮαʔϏεͷࢮ ˣ ղܾͰ͖Δਓӳ༤
·ͱΊ %#ͷΕͨࠒʹͬͯ͘Δ
·ͱΊ
·ͱΊ αʔϏενʔϜΛकΔͨΊʹ ແΛط͢Δ
·ͱΊ ۪ऀܦݧʹֶͿ ݡऀաڈʹֶͿ
·ͱΊ पғͷܦݧஊ͔ΒֶͿ
·ͱΊ पғͷܦݧஊ͔ΒֶͿ ˣ ੵۃతʹίϛϡχςΟΛར༻͢Δ
ࢀߟࢿྉ ɾQPTUHSFTRMKQ4MBDL νϟοτϧʔϜ IUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN ɾNZTRMDBTVBM4MBDL νϟοτϧʔϜ IUUQTNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN
·ͱΊ 3%#ͷࣝण໋͕͍
·ͱΊ 3%#ͷࣝण໋͕͍ ˣ ֮͑ΕࣄͰ͍ؒʹཱͭ
·ͱΊ ΑΓྑ͍ઃܭΛ Ұॹʹߟ͑ͯߦ͖·͠ΐ͏
·ͱΊ 3%#͍͍ͧɻ
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ