Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
RDBアンチパターン
soudai sone
November 03, 2016
Technology
79
57k
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
目指すべきソフトウェア開発と 今日から始める最初の一歩 / First step for good development
soudai
1
310
あの人の自分戦略を聞きたい!2022 / developers-summit-2022
soudai
3
1.4k
今まで生き残ってきたRDBMSとこの先10年戦えるデータストア戦略 / Database now and in the past
soudai
8
7.8k
如何にデータベースが重要でなぜ私達が学ぶのか / Reasons for learning a database
soudai
20
10k
ソフトウェアエンジニアと技術力 / developer-lifework
soudai
33
21k
問題を解決するために必要な習慣 / developer-lifehack
soudai
26
9.3k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
38
12k
時間枠の扱いをいい感じにする話 / good-time-schedule-window
soudai
6
1.1k
RDBMSの苦手なことを 如何に乗り越えていくか / challenge-to-rdbms
soudai
17
3.5k
Other Decks in Technology
See All in Technology
Oracle Cloud Infrastructure:2022年5月度サービス・アップデート
oracle4engineer
PRO
0
140
LINEスタンプの実例紹介 小さく始める障害検知・対応・振り返りの 改善プラクティス
line_developers
PRO
3
1.9k
Oracle Database Technology Night #55 Oracle Autonomous Database 再入門
oracle4engineer
PRO
1
140
Puny to Powerful PostgreSQL Rails Apps
andyatkinson
PRO
0
400
0->1 フェーズで E2E 自動テストを導入した私たちの、これまでとこれから
yoyakoba
0
810
アルプの 認証/認可分離戦略と手法
ma2k8
PRO
2
360
Oracle Content Management サービス概要 (2022年5月版)
oracle4engineer
PRO
0
130
2022年最新版 GatsbyJS + TypeScript + microCMS でブログを作る。
hanetsuki
1
290
ニフティでSRE推進活動を始めて取り組んできたこと
niftycorp
2
720
Apache Kafka and the World of Streams
hashitokyo
0
120
開発者のための GitHub Organization の安全な運用と 継続的なモニタリング
flatt_security
3
3.9k
srenext2022-skaru
mixi_engineers
PRO
1
960
Featured
See All Featured
Designing Dashboards & Data Visualisations in Web Apps
destraynor
224
49k
The Most Common Mistakes in Cover Letters
jrick
PRO
4
24k
The Mythical Team-Month
searls
208
39k
Design by the Numbers
sachag
271
17k
Testing 201, or: Great Expectations
jmmastey
21
5.4k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
12
900
Building Better People: How to give real-time feedback that sticks.
wjessup
343
17k
Music & Morning Musume
bryan
35
4.2k
How to Ace a Technical Interview
jacobian
265
21k
Writing Fast Ruby
sferik
612
57k
jQuery: Nuts, Bolts and Bling
dougneiner
56
6.4k
Bash Introduction
62gerente
596
210k
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%#͍͍ͧɻ
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ