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
7
1.3k
**強い**エンジニアのなり方 - フィードバックサイクルを勝ち取る / grow one day each day
soudai
65
20k
マルチテナントの実現におけるDB設計とRLS / Utilizing RSL in multi-tenancy
soudai
26
6.4k
キャッシュと向き合う、キャッシュと共に生きる / cache pattern
soudai
31
11k
RDBアンチパターンと戦う - 削除フラグ 完全攻略ガイド / delete flag
soudai
26
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
ゼロから始めるVue.jsコミュニティ貢献 / first-vuejs-community-contribution-link-and-motivation
lmi
1
150
ServiceNow Now Platform 最新版Washington, D.C.リリース
manarobot
0
100
Google Cloud Next '24 Recap(Cloud Run/k8s)
mokocm
0
310
.NET Profiler in 2024.
kkamegawa
2
860
Building Dashboards as a Hobby
egmc
0
350
自己改善からチームを動かす! 「セルフエンジニアリングマネージャー」のすゝめ
shoota
6
1k
20分で完全に理解するGrafanaダッシュボード
hamadakoji
5
880
Cracking the KubeCon CfP
inductor
2
270
開発生産性大幅アップ!Postman VS Code拡張機能
nagix
3
620
生成AIの変革の時代に、直近1年で直面した課題とその解決策
ktc_wada
0
510
AWS学習者向けにAzureの解説スライドを作成した話
handy
3
180
web-application-security
matsuihidetoshi
1
190
Featured
See All Featured
Adopting Sorbet at Scale
ufuk
69
8.6k
Thoughts on Productivity
jonyablonski
59
3.9k
Principles of Awesome APIs and How to Build Them.
keavy
121
16k
4 Signs Your Business is Dying
shpigford
176
21k
The Pragmatic Product Professional
lauravandoore
26
5.8k
Side Projects
sachag
451
41k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
64
14k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
41
4.4k
A Philosophy of Restraint
colly
197
16k
Bootstrapping a Software Product
garrettdimon
PRO
302
110k
Designing on Purpose - Digital PM Summit 2013
jponch
111
6.5k
Stop Working from a Prison Cell
hatefulcrawdad
267
19k
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%#͍͍ͧɻ
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ