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
80
66k
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
仕事を前に進めるためのコツ - 判断と決断と共有 / Aim for the goal
soudai
63
26k
アプリケーションが 正しく動作するということ - 自動テスト編 / Automated Testing
soudai
14
2.8k
Gitlab本から学んだこと - そーだいなるプレイバック / gitlab-book
soudai
8
1.7k
**強い**エンジニアのなり方 - フィードバックサイクルを勝ち取る / grow one day each day
soudai
87
29k
マルチテナントの実現におけるDB設計とRLS / Utilizing RSL in multi-tenancy
soudai
26
7.9k
キャッシュと向き合う、キャッシュと共に生きる / cache pattern
soudai
34
13k
RDBアンチパターンと戦う - 削除フラグ 完全攻略ガイド / delete flag
soudai
28
18k
コミュニティと共に生きる - キャリアの螺旋 / live with community
soudai
7
5.6k
今年1年間の”アウトプット”を振り返る / soudai's output - 2023
soudai
13
2.2k
Other Decks in Technology
See All in Technology
ラブグラフ紹介資料 〜プロダクト解体新書〜 / Lovegraph Product Deck
lovegraph
0
14k
LeSSはスクラムではない!?LeSSにおけるスクラムマスターの振る舞い方とは / Scrum Master Behavior in LeSS
toma_sm
0
210
Kubernetes Meetup Tokyo #67 - KEP-3619: Fine-grained SupplementalGroups Control / k8sjp67-kep-3619
everpeace
0
140
品質マネジメントで抑えておきたい2つのリスクを見分けて未来に備えよう #yapcjapan
makky_tyuyan
0
110
tenntennはなんでnewmoにnew社したの? - YAPC::Hakodate 2024
tenntenn
PRO
0
290
Microsoft 365 でデータセキュリティを強化しよう
sophiakunii
2
190
Castor - Le Task Runner PHP qui simplifie votre Workflow
lyrixx
1
290
Semantic Kernel の Agent 機能試してみた!
okazuki
1
160
Deno Deploy で Web Cache API を 使えるようになったので試した知見
toranoana
1
110
【㈱アイモバイル】エンジニア向け会社説明資料
imobile
0
470
ゼロから実装まで!機械学習入門
natsuki0726
0
200
I tried the newly introduced certification "Applied Skills" on Microsoft Learn
mappie_kochi
0
230
Featured
See All Featured
Adopting Sorbet at Scale
ufuk
73
9k
A better future with KSS
kneath
237
17k
Intergalactic Javascript Robots from Outer Space
tanoku
268
27k
Gamification - CAS2011
davidbonilla
80
5k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
159
15k
Robots, Beer and Maslow
schacon
PRO
157
8.2k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
191
16k
The Straight Up "How To Draw Better" Workshop
denniskardys
232
130k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.2k
Building an army of robots
kneath
302
42k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
27
1.9k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
29
1.7k
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%#͍͍ͧɻ
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ