RDBアンチパターン

PHPカンファレンス2016の資料です

http://phpcon.php.gr.jp/2016/

Transcript

1. RDBΞϯνύλʔϯ 1)1FSʹ஌ͬͯ΄͍͠
   ϦϨʔγϣφϧσʔλϕʔεͷ͜ͱ
2. What is it? ࣭໰͸Twitterͷϋογϡλά #phpcon_rdb_qa Ͱ͓ئ͍͠·͢
3. What is it? σʔλϕʔεͷण໋͸ ΞϓϦέʔγϣϯΑΓ΋௕͍
4. What is it? ͦΜͳ௕͍෇͖߹͍ʹͳΔσʔλϕʔε ͷେ੾ͳࣄΛ͓఻͑͠·͢
5. What is it? ର৅ͷσʔλϕʔειϑτ΢ΣΞ
6. What is it? PostgreSQL 9.6ͱMySQL 5.7(InnoDB)ʹݶΔ ଞͷRDBͷ࿩͸͠·ͤΜ
7. What is it? RDBΞϯνύλʔϯ
8. What is it? ਖ਼نԽͯ͠… ࣮ߦܭըΛݟͯ… SQLΛॻ͍ͯ…
9. What is it? ྑ͔Εͱࢥͬͯ΍ͬͨͷʹམͪͯ͠·͏᠘
10. What is it? Ξϯνύλʔϯ
11. What is it? Ξϯνύλʔϯ ↓ ޙʑʹۤ͠ΈΛੜΉ
12. What is it? ΞϯνύλʔϯΛ஌Δ
13. What is it? ΞϯνύλʔϯΛ஌Δ ↓ ಉ͡աͪΛ܁Γฦ͞ͳ͍
14. What is it?
15. What is it? SQLΞϯνύλʔϯ͸ݫબ͞Εࣦͨഊू
16. What is it? SQLΞϯνύλʔϯ͸ݫબ͞Εࣦͨഊू ↓ DBͷϊ΢ϋ΢͕٧·໊ͬͨஶ
17. What is it? ࠓ೔͸RDBͷࣦഊྫΛ͝঺հ͠·͢
18. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
19. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
20. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
21. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
22. தࠃ஍ํDBษڧձ https://dbstudychugoku.github.io/
23. தࠃ஍ํDBษڧձ https://dbstudychugoku.github.io/ աڈͷࢿྉ͕߇͑Ίʹݴͬͯ΋
    ࠷ߴͰ࠷ڧͳͷͰੋඇνΣοΫʂ
24. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
25. ڧ͗͢Δґଘ σʔλϕʔεͷந৅Խ
26. ڧ͗͢Δґଘ w %BUB
    "DDFTT
    0CKFDUʢ%"0ʣ
    w 0CKFDU
    3FMBUJPOBM
    .BQQJOH 03.
    w %#
    .JHSBUJPO
27. ڧ͗͢Δґଘ w %PDUSJOF
    
    w &MPRVFOU
    03.
    w *EJPSN
    w 1BSJT
    
    w ͳͲͳͲʜ
28. ڧ͗͢Δґଘ ͜ΕΒͷख๏΍πʔϧ͸ͱͯ΋ศར
    
29. ڧ͗͢Δґଘ ͜ΕΒͷख๏΍πʔϧ͸ͱͯ΋ศར
    ˣ
    ੍໿ɾ੤໿ͱҾ͖׵͑ʹ
    ߴ͍ੜ࢈ੑΛ༩͑ͯ͘ΕΔ
30. ڧ͗͢Δґଘ ੍໿ͱ੤໿
31. ڧ͗͢Δґଘ ੍໿
    ࣮૷্ͷϧʔϧΛڧ͍ΔࣄͰ
    ίʔυͷهड़ྔΛݮΒ͢
32. ڧ͗͢Δґଘ ੍໿
    ࣮૷্ͷϧʔϧΛڧ͍ΔࣄͰ
    ίʔυͷهड़ྔΛݮΒ͢ कΒͳ͍ͱίϯύΠϧΤϥʔ
    ࣮૷΍ઃܭʹ௚݁
33. ڧ͗͢Δґଘ ੍໿
    ࣮૷্ͷϧʔϧΛڧ͍ΔࣄͰ
    ίʔυͷهड़ྔΛݮΒ͢ कΒͳ͍ͱίϯύΠϧΤϥʔ
    ࣮૷΍ઃܭʹ௚݁ ςʔϒϧͷJEΧϥϜඞਢ
    ࢦఆͰ͖Δܕ
    σʔλΞΫηεͷखஈͳͲ
34. ڧ͗͢Δґଘ ੤໿
    ܾ·Γ͝ͱ ύλʔϯ ΛकΔࣄͰ
    ઃܭ΍࣮૷ͷҰ؏ੑͱ࠶ར༻͕Մೳ
35. ڧ͗͢Δґଘ ੤໿
    ܾ·Γ͝ͱ ύλʔϯ ΛकΔࣄͰ
    ઃܭ΍࣮૷ͷҰ؏ੑͱ࠶ར༻͕Մೳ कΒͳͯ͘΋ίʔυ͸ಈ͘
    Ϟϥϧ΍஌ࣝͷෆ଍ͳͲͰແࢹ͞ΕΔ έʔε͕͋Δ
36. ڧ͗͢Δґଘ ੤໿
    ܾ·Γ͝ͱ ύλʔϯ ΛकΔࣄͰ
    ઃܭ΍࣮૷ͷҰ؏ੑͱ࠶ར༻͕Մೳ σβΠϯύλʔϯ
    ઃܭࢥ૝
    ίʔυن໿ͳͲ कΒͳͯ͘΋ίʔυ͸ಈ͘
    Ϟϥϧ΍஌ࣝͷෆ଍ͳͲͰແࢹ͞ΕΔ έʔε͕͋Δ
37. ڧ͗͢Δґଘ σʔλϕʔεͷந৅Խ͸
    ੍໿ͱ੤໿ͷੈք ϧʔϧ Ϛφʔ
38. ڧ͗͢Δґଘ ੍໿ͱ੤໿ͱҾ͖׵͑ʹ
    ࣦ͍ͬͯΔࣄ
39. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ
40. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ
41. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ ܕͱ͔ϚςϏϡʔͱ͔τϦΨʔͱ͔DIFDL੍໿ͱ͔
42. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ
43. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ 8JOEPXؔ਺ͱ͔8*5)۟ͱ͔
44. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ
45. ڧ͗͢Δґଘ w 3%#ͷػೳ
    w 42-ͷڧྗͳจ๏
    w 3%#ͷຊདྷͷ੹຿ͱઃܭ
46. ڧ͗͢Δґଘ 3%#ͷ੹຿
    w σʔλΛอଘ͢Δ
    w σʔλΛऔΓग़͢
    w σʔλΛकΔ
47. ڧ͗͢Δґଘ ͋ͳͨͷσʔλ
    ͪΌΜͱकΕͯ·͔͢ʁ
48. ڧ͗͢Δґଘ %#ͷઃܭʹڧ੍͍໿͕ൃੜ͢Δ
    
49. ڧ͗͢Δґଘ %#ͷઃܭʹڧ੍͍໿͕ൃੜ͢Δ
    ˣ
    03.
    Λҙࣝͨ͠εΩʔϚઃܭ
    3%#.4
    Λҙࣝͨ͠Ϋϥεઃܭ
50. ڧ͗͢Δґଘ %#ͷઃܭʹڧ੍͍໿͕ൃੜ͢Δ
    ˣ
    03.
    Λҙࣝͨ͠εΩʔϚઃܭ
    3%#.4
    Λҙࣝͨ͠Ϋϥεઃܭ ྆ྠ͕ΩϨΠʹճ͍ͬͯΔͱ͖͸
    ߴ͍ੜ࢈ੑΛൃش͢Δ
51. ڧ͗͢Δґଘ ੍໿ͱ੤໿่͕ΕΔͱ͖
52. ڧ͗͢Δґଘ σʔλ͕੒௕ͨ࣌͠
    
53. ڧ͗͢Δґଘ σʔλ͕੒௕ͨ࣌͠
    αʔϏε͕੒௕ͨ࣌͠
54. ڧ͗͢Δґଘ σʔλ͕੒௕ͨ࣌͠
    ˣ
    ΞϓϦέʔγϣϯଆ͚ͩͰ
    Χόʔग़དྷͳ͘ͳͬͨ࣌ αʔϏε͕੒௕ͨ࣌͠
55. ڧ͗͢Δґଘ ੍໿ͱ੤໿่͕ΕΔ࣌ͷྫ
    w ΫΤϦ͕ࡹ͚ͳ͘ͳͬͨ
    w γϟʔσΟϯά͕ඞཁ
    w */%&9͕ඞཁ͕ͩར༻Ͱ͖ͳ͍
    w "-5&3จ͕ාͯ͘ྲྀͤͳ͍
56. ڧ͗͢Δґଘ ੍໿ͱ੤໿่͕ΕΔ࣌ͷྫ
    w ΫΤϦ͕ࡹ͚ͳ͘ͳͬͨ
    w γϟʔσΟϯά͕ඞཁ
    w */%&9͕ඞཁ͕ͩར༻Ͱ͖ͳ͍
    w "-5&3จ͕ාͯ͘ྲྀͤͳ͍ ύϑΥʔϚϯε໰୊ʹΑ੍ͬͯ໿ͱ੤໿่͕ΕΔ
57. ڧ͗͢Δґଘ ݱঢ়Ͱ͸03.͸
    ΠϯϐʔμϯεɾϛεϚον
    Λղܾ͢ΔͨΊͷଘࡏ
    Ͱ͋ͬͯ3%#ͷ׬શͳந৅ԽͰ͸ͳ͍
58. ڧ͗͢Δґଘ ॲํᝦ
    
59. ڧ͗͢Δґଘ ॲํᝦ
    ੍໿ͱ੤໿ʹΑͬͯ
    ࣦ͍ͬͯΔଘࡏΛ๨Εͳ͍͜ͱ
60. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
61. Ӆ͞Εͨঢ়ଶ σʔλϕʔε͸
    σʔλอଘ͢ΔͨͩͷശͰ͸ແ͍
62. Ӆ͞Εͨঢ়ଶ ϦϨʔγϣφϧϞσϧ
    
63. Ӆ͞Εͨঢ়ଶ ϦϨʔγϣφϧϞσϧ
    ˣ
    ࣄ࣮ͷΈΛอଘ͢Δ
64. Ӆ͞Εͨঢ়ଶ ࣄ࣮ͱঢ়ଶ
65. Ӆ͞Εͨঢ়ଶ ঢ়ଶͷྫ
    wϢʔβͷঢ়ଶ TUBUVTΧϥϜʣ
    w՝ۚঢ়ଶʢ༩৴ɺ੥ٻࡁΈʣ
    wΧʔτ৘ใʢΧΰͷதɺߪೖࡁΈʣ
66. Ӆ͞Εͨঢ়ଶ Ϩίʔυʹঢ়ଶΛ࣋ͨͤΔͱةݥ
67. JE OBNF BHF EFMFUF@qBH  TPOF    TPVEBJ    UBLFUPNP    TPOF  
68. JE OBNF BHF EFMFUF@qBH  TPOF    TPVEBJ    UBLFUPNP    TPOF   ࡟আͱݴ͏ঢ়ଶΛϑϥάͰදݱ
69. Ӆ͞Εͨঢ়ଶ $user = $this->get_user($user_id); if ($user->get(‘delete_falg’) == 1) { // ࡟আࡁΈͷϢʔβͷॲཧ return }
70. Ӆ͞Εͨঢ়ଶ $user = $this->get_user($user_id); if ($user->get(‘delete_falg’) == 1) { // ࡟আࡁΈͷϢʔβͷॲཧ return } σʔλͷதͷঢ়ଶ͸ΞϓϦέʔγϣϯ
    ͸औΓग़͢·ͰΘ͔Βͳ͍
71. Ӆ͞Εͨঢ়ଶ w 6OJRVF੍໿͕ࢮΜͩΓ
    w */%&9͕ࢮΜͩΓ
    w ֎෦Ωʔ੍໿͕ࢮΜͩΓ
72. Ӆ͞Εͨঢ়ଶ Ϩίʔυ͔Β
    ঢ়ଶ͕ݟ͑ͳ͍࣌͸
    ΋ͬͱةݥ
73. ച্ JE ച্ֹۚ ച্೔ ഑ૹঢ়ଶ    
     ഑ૹࡁ   
     ൃ஫த ộ ộ ộ ച্JE ঎඼JE ݸ਺ ߪೖऀ    TPOF    TPOF    TPOF    TPOF ঎඼JE ঎඼໊ Ձ֨  42-࣮ફೖ໳    Ϧʔμϒϧίʔυ    ϓϩάϥϚͷͨΊͷ42-    σʔλϕʔεɾϦϑΝΫλϦϯά   ঎඼ Χʔτ ച্
74. ച্JE ঎඼JE ݸ਺ ߪೖऀ    TPOF    TPOF    TPOF    TPOF ঎඼JE ঎඼໊ Ձ֨  42-࣮ફೖ໳    Ϧʔμϒϧίʔυ    ϓϩάϥϚͷͨΊͷ42-    σʔλϕʔεɾϦϑΝΫλϦϯά   ঎඼ ച্ ച্ JE ച্ֹۚ ച্೔ ഑ૹঢ়ଶ    
     ഑ૹࡁ   
     ൃ஫த ộ ộ ộ Χʔτ
75. ച্JE ঎඼JE ݸ਺ ߪೖऀ    TPOF    TPOF    TPOF    TPOF ঎඼JE ঎඼໊ Ձ֨  42-࣮ફೖ໳    Ϧʔμϒϧίʔυ    ϓϩάϥϚͷͨΊͷ42-    σʔλϕʔεɾϦϑΝΫλϦϯά   ঎඼ ച্ ച্ JE ച্ֹۚ ച্೔ ഑ૹঢ়ଶ    
     ഑ૹࡁ   
     ൃ஫த ộ ộ ộ ফඅ੫ͷঢ়ଶ͕ӅΕͯΔ
    ͱ͕೔෇ͰมΘΔ Χʔτ
76. ച্JE ঎඼JE ݸ਺ ߪೖऀ    TPOF    TPOF    TPOF    TPOF ঎඼JE ঎඼໊ Ձ֨  42-࣮ફೖ໳    Ϧʔμϒϧίʔυ    ϓϩάϥϚͷͨΊͷ42-    σʔλϕʔεɾϦϑΝΫλϦϯά   ঎඼ ച্ ച্ JE ച্ֹۚ ച্೔ ഑ૹঢ়ଶ    
     ഑ૹࡁ   
     ൃ஫த ộ ộ ộ ͍ͭ഑ૹঢ়ଶ͕
    มΘ͔ͬͨΘ͔Βͳ͍ Χʔτ
77. ച্JE ঎඼JE ݸ਺ ߪೖऀ    TPOF    TPOF    TPOF    TPOF ঎඼JE ঎඼໊ Ձ֨  42-࣮ફೖ໳    Ϧʔμϒϧίʔυ    ϓϩάϥϚͷͨΊͷ42-    σʔλϕʔεɾϦϑΝΫλϦϯά   ঎඼ ച্ ച্ JE ച্ֹۚ ച্೔ ഑ૹঢ়ଶ    
     ഑ૹࡁ   
     ൃ஫த ộ ộ ộ Χʔτ
78. ച্JE ঎඼JE ݸ਺ ߪೖऀ    TPOF    TPOF    TPOF    TPOF ঎඼JE ঎඼໊ Ձ֨  42-࣮ફೖ໳    Ϧʔμϒϧίʔυ    ϓϩάϥϚͷͨΊͷ42-    σʔλϕʔεɾϦϑΝΫλϦϯά   ঎඼ ച্ ঎඼໊͕มΘͬͨΒʁ
    Ձ֨Λม͑ͨΒʁ
    ച্ͷࣄ࣮ͱෆ੔߹͕ੜ·ΕΔ ച্ JE ച্ֹۚ ച্೔ ഑ૹঢ়ଶ    
     ഑ૹࡁ   
     ൃ஫த ộ ộ ộ Χʔτ
79. Ӆ͞Εͨঢ়ଶ Ӆ͞Εͨঢ়ଶͷྫ
    w഑ૹঢ়ଶͷཤྺ
    wߪೖཤྺͷফඅ੫ͷ಺༁
    w࡟আ΍ߋ৽ͷཤྺ
80. Ӆ͞Εͨঢ়ଶ ࣄ࣮ͷΈΛอଘ͢Δ
    
81. Ӆ͞Εͨঢ়ଶ ࣄ࣮ͷΈΛอଘ͢Δ
    ˣ
    ࣄ࣮ͷཤྺΛอଘ͢Δ
82. ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্೔      
         
     ộ ộ ộ ফඅ੫ ച্ ച্JE ഑ૹঢ়ଶ ࡞੒೔࣌  ൃ஫த 
      ഑ૹத 
      ೲ඼ࡁ 
      ൃ஫த 
     ফඅ੫ ༗ޮ೔ ࣦޮ೔      OVMM ഑ૹঢ়گ
83. ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্೔      
         
     ộ ộ ộ ফඅ੫ ച্ ച্JE ഑ૹঢ়ଶ ࡞੒೔࣌  ൃ஫த 
      ഑ૹத 
      ೲ඼ࡁ 
      ൃ஫த 
     ফඅ੫ ༗ޮ೔ ࣦޮ೔      OVMM ഑ૹঢ়گ ഑ૹঢ়گͷཤྺΛ࣋ͭ
    ߋ৽Ͱ͸ແ͘௥ՃͰྺ࢙Λ࡞Δ
84. ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্೔      
         
     ộ ộ ộ ফඅ੫ ച্ ച্JE ഑ૹঢ়ଶ ࡞੒೔࣌  ൃ஫த 
      ഑ૹத 
      ೲ඼ࡁ 
      ൃ஫த 
     ফඅ੫ ༗ޮ೔ ࣦޮ೔      OVMM ഑ૹঢ়گ ಉ༷ʹফඅ੫ͷྺ࢙Λ࣋ͭ
    ฦ඼࣌ͷ෷͍໭͠ͷॲཧͷ࣌ͳͲ
    Ͱ࣋ͬͯͳ͍ͱࢮ͵
85. ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্೔      
         
     ộ ộ ộ ফඅ੫ ച্ ച্JE ഑ૹঢ়ଶ ࡞੒೔࣌  ൃ஫த 
      ഑ૹத 
      ೲ඼ࡁ 
      ൃ஫த 
     ফඅ੫ ༗ޮ೔ ࣦޮ೔      OVMM ഑ૹঢ়گ ಉ༷ʹফඅ੫ͷྺ࢙Λ࣋ͭ
    ฦ඼࣌ͷ෷͍໭͠ͷॲཧͷ࣌ͳͲ
    Ͱ࣋ͬͯͳ͍ͱࢮ͵ 1PTUHSF42-ͷൣғܕΛ࢖͏ͱ༗ޮൣғ ΛεϜʔζʹॲཧग़དྷΔ
86. ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্೔      
         
     ộ ộ ộ ফඅ੫ ച্ ച্JE ഑ૹঢ়ଶ ࡞੒೔࣌  ൃ஫த 
      ഑ૹத 
      ೲ඼ࡁ 
      ൃ஫த 
     ফඅ੫ ༗ޮ೔ ࣦޮ೔      OVMM ഑ૹঢ়گ ܭࢉͨ͠ΒಘΔࣄ͕ग़དྷΔ
    ඇਖ਼نԽͷҰͭ
    ύϑΥʔϚϯεͱ૬ஊ
87. ച ্ ച্ۚ ֹ ফඅ੫ ফඅ੫ֹ ച্೔      
         
     ộ ộ ộ ফඅ੫ ച্ ച্JE ഑ૹঢ়ଶ ࡞੒೔࣌  ൃ஫த 
      ഑ૹத 
      ೲ඼ࡁ 
      ൃ஫த 
     ফඅ੫ ༗ޮ೔ ࣦޮ೔      OVMM ഑ૹঢ়گ ܭࢉͨ͠ΒಘΔࣄ͕ग़དྷΔ
    ඇਖ਼نԽͷҰͭ
    ύϑΥʔϚϯεͱ૬ஊ .Z42-ͷԾ૝ྻΛར༻͢Δͱ ΑΓΩϨΠʹ࣮૷ग़དྷΔ
88. Ӆ͞Εͨঢ়ଶ σʔλϕʔε্ʹແ͍σʔλ͸
    ΞϓϦଆͰ࡞Γग़ͤͳ͍
89. Ӆ͞Εͨঢ়ଶ Ӆ͞Εͨঢ়ଶ͕͋Δͱ
    ྫ֎ରԠͷ࣌ʹࢮ͵
90. Ӆ͞Εͨঢ়ଶ ॲํᝦ
    
91. Ӆ͞Εͨঢ়ଶ ॲํᝦ
    దਖ਼ͳܗͰσʔλΛอଘ͢Δ
92. Ӆ͞Εͨঢ়ଶ ॲํᝦ
    దਖ਼ͳܗͰσʔλΛอଘ͢Δ
    ˣ
    ͪΌΜͱϦεΫϔοδΛ͢Δ
93. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
94. ϩοΫͷޭࡑ τϥϯβΫγϣϯͱσʔλ੔߹ੑ
95. ϩοΫͷޭࡑ τϥϯβΫγϣϯ෼཭Ϩϕϧ
96. ϩοΫͷޭࡑ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&
    3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%
    $0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"%
    6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ
97. ϩοΫͷޭࡑ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&
    3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%
    $0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"%
    6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ .Z42-ͷσϑΥϧτ͸͜͜
98. ϩοΫͷޭࡑ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&
    3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%
    $0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"%
    6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ 1PTUHSF42-
    0SBDMF%#
    42-4FSWFS
    ͷσϑΥϧτ͸͜͜
99. ϩοΫͷޭࡑ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&
    3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%
    $0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"%
    6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ 1PTUHSF42-
    0SBDMF%#
    42-4FSWFS
    ͷσϑΥϧτ͸͜͜ ϑΝϯτϜϦʔυ΍μʔςΟϦʔυͳͲͷ࿩͸ࠓ೔͸͠·ͤΜ
    ʮ͑ʁͳʹͦΕʯͬͯਓ͸ࠓ͙͢άάοͯษڧͨ͠ํ͕͍͍Ͱ͢
100. ϩοΫͷޭࡑ ͳͥτϥϯβΫγϣϯ͕ඞཁ͔
101. ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# ঎඼" ಉ࣌ʹߪೖ
102. ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# ঎඼" ಉ࣌ʹߪೖ ࡏݿ͕࠷ޙͷݸͩͬͨͱ͖ɺ ͲͪΒΛ༏ઌ͢Δ͔ʁ
103. ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# ঎඼" 
     ઌʹΞΫηεͨ͠ͷͰ
     ঎඼ʹରͯ͠ϩοΫΛऔಘ 
     ࡏݿ͕ແ͍ͷͰ
     ΤϥʔʹͳΔ
104. ϩοΫͷޭࡑ ฒྻॲཧͷσʔλͷෆ੔߹Λ๷͙
105. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌
106. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌
107. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌ ྫ͑͹σΠϦʔͷདྷళϙΠϯτͷॲཧͱ͔
     ঎඼ߪೖ࣌ͷϙΠϯτݮࢉͷॲཧͱ͔
108. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌
109. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌ ˓˓ݶఆ঎඼ͷࡏݿॲཧͱ͔
     Ұਓ͋ͨΓͷߪೖݶք਺ͷॲཧͱ͔
110. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌
111. ϩοΫͷޭࡑ ͋ͳͨͷॲཧ͸େৎ෉ʁ
     w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
     w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
     w ฒྻॲཧΛॻ͍ͨ࣌ Ұͭͷσʔλʹରͯ͠ෳ਺ͷαʔϏε͕ΞΫηε͢Δ࣌ͱ͔
     ߴ଎ԽͷͨΊʹඇಉظॲཧ΍ϚϧνεϨουॲཧΛ࡞ͬͨ࣌ͱ͔
112. ϩοΫͷޭࡑ ϩοΫͷ੹຿
     ࣄ࣮ʹج͍ͯ࣌ܥྻʹॲཧͯ͠
     σʔλΛద੾ʹकΔ
113. ϩοΫͷޭࡑ ͜͜·Ͱ͸ϩοΫͷޭࡑͷޭͷ෦෼
114. ϩοΫͷޭࡑ ϩοΫͷࡑ
115. ϩοΫͷޭࡑ ϩοΫʹΑΔੑೳ஗Ԇ
116. ϩοΫͷޭࡑ ϩοΫʹΑΔੑೳ஗Ԇ
     ˣ
     ϩοΫ଴ͪʹΑΔॲཧ஗Ԇ
117. ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# ঎඼" 
     ઌʹΞΫηεͨ͠ͷͰ
     ঎඼ʹରͯ͠ϩοΫΛऔಘ 
     ։์଴ͪ ͜ͷαΠτ஗͍ͳ͊
118. ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# ঎඼" 
     ઌʹΞΫηεͨ͠ͷͰ
     ঎඼ʹରͯ͠ϩοΫΛऔಘ 
     ։์଴ͪ ͜ͷαΠτ஗͍ͳ͊ ྆ํͷϢʔβ͕ͦΕͧΕͷϩοΫͰ
     ଴ͨ͞Εͨ৔߹͸σοτϩοΫ
119. ϩοΫͷޭࡑ Ϣʔβ" Ϣʔβ# ঎඼" 
     ઌʹΞΫηεͨ͠ͷͰ
     ঎඼ʹରͯ͠ϩοΫΛऔಘ 
     ։์଴ͪ ͜ͷαΠτ஗͍ͳ͊ ྆ํͷϢʔβ͕ͦΕͧΕͷϩοΫͰ
     ଴ͨ͞Εͨ৔߹͸σοτϩοΫ
120. ϩοΫͷޭࡑ ओͳϩοΫͷछྨ
     w ഉଞ F9DMVEFE ϩοΫ
     w ڞ༗ 4IBSFE ϩοΫ
121. ϩοΫͷޭࡑ ओͳϩοΫͷछྨ
     w ഉଞ F9DMVEFE ϩοΫ
     w ڞ༗ 4IBSFE ϩοΫ ϩοΫର৅ʹରͯ͠ɺଞͷΞΫηεΛҰ੾ېࢭ͢Δ
     ଞͷΞΫηε͸ߋ৽ɾ࡟আɾࢀরશͯग़དྷͳ͍
     ॻ͖ࠐΈϩοΫͱݺ͹ΕΔࣄ΋͋Δ
122. ϩοΫͷޭࡑ ओͳϩοΫͷछྨ
     w ഉଞ F9DMVEFE ϩοΫ
     w ڞ༗ 4IBSFE ϩοΫ ϩοΫର৅ʹରͯ͠ɺࢀরҎ֎ͷॲཧΛېࢭ͢Δ
     ଞͷΞΫηε͸ࢀর 4&-&$5 Λ͢Δ͜ͱ͕ग़དྷΔ
     ಡΈࠐΈϩοΫͱݺ͹ΕΔࣄ΋͋Δ
123. ϩοΫͷޭࡑ ϩοΫΛ஌Βͳ͍ॴͰऔ͍ͬͯΔ
124. ϩοΫͷޭࡑ ϩοΫΛ஌Βͳ͍ॴͰऔ͍ͬͯΔ
     ˣ
     ҉໧తϩοΫ
125. ϩοΫͷޭࡑ .Z42-ͷ৔߹
126. ϩοΫͷޭࡑ 1PTUHSF42-ͷ৔߹
127. ϩοΫͷޭࡑ ϩοΫΛ஌Βͳ͍ॴͰऔ͍ͬͯΔ
     ˣ
     ҉໧తϩοΫ ಛʹڞ༗ϩοΫ͸සൟʹऔ͍ͬͯΔ
128. ϩοΫͷޭࡑ ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     
129. ϩοΫͷޭࡑ ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     ˣ
     ύϑΥʔϚϯεͱτϨʔυΦϑ
130. ϩοΫͷޭࡑ w ϩοΫ଴ͪͰॲཧ͕٧·Δ
     w ஗͍4&-&$5ʹΑͬͯߋ৽ॲཧ͕٧·Δ
     w ߋ৽ର৅͕ίϯϑϦΫτͯ͠଴ͨ͞ΕΔ
     w σοτϩοΫɺτϥϯβΫγϣϯ͸ࢮ͵
131. ϩοΫͷޭࡑ αʔϏεͷϝΠϯςʔϒϧ͸ةݥ
     w ଟ͘ͷࢀরͰར༻͍ͯ͠Δ
     w ߋ৽΋සൟʹ͋Δ
     w +0*/΍αϒΫΤϦͷର৅ʹͳ͍ͬͯΔ
132. ϩοΫͷޭࡑ ͦ΋ͦ΋ϩοΫͷॲཧ͸
     3%#ʹΑ͔ͬͯͳΓҧ͏
133. ϩοΫͷޭࡑ ͦ΋ͦ΋ϩοΫͷॲཧ͸
     3%#ʹΑ͔ͬͯͳΓҧ͏ ॲํᝦΛҰׅΓͰݴ͑ͳ͍
134. ϩοΫͷޭࡑ ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     
135. ϩοΫͷޭࡑ ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     ˣ
     ͔͠͠τϥϒϧͷ࣌ͷࠜ͸ਂ͍
136. ϩοΫͷޭࡑ ॲํᝦ
     
137. ϩοΫͷޭࡑ ॲํᝦ
     ϩοΫΛ஌Δ
138. ϩοΫͷޭࡑ ະ஌ͳΔ࢓૊Έ͸ා͍
     
139. ϩοΫͷޭࡑ ະ஌ͳΔ࢓૊Έ͸ා͍
     ˣ
     ͔ͬ͠Γͱཧղ͢Δࣄ
140. ϩοΫͷޭࡑ ϩοΫΛݟΔ
     
141. ϩοΫͷޭࡑ ϩοΫΛݟΔ
     ˣ
     ֤%#ʹ༻ҙ͞Ε͍ͯΔ࢓૊ΈΛ࢖͏
142. ϩοΫͷޭࡑ ϜʔΞͷ๏ଇͷݶք
     
143. ϩοΫͷޭࡑ ϜʔΞͷ๏ଇͷݶք
     ˣ
     ࣌୅͸ฒྻɾ෼ࢄॲཧ࣌୅΁
144. ϩοΫͷޭࡑ ϜʔΞͷ๏ଇͷݶք
     ˣ
     ࣌୅͸ฒྻɾ෼ࢄॲཧ࣌୅΁ ଟ͘ͷιϑτ΢ΣΞΤϯδχΞ͸ฒྻॲཧ͕ۤख
     ͔ͩΒͦ͜कΓͷ࢓૊Έ͔ͬ͠Γ஌Δ
145. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹڧ͗͢Δґଘ ̏ɹӅ͞Εͨঢ়ଶ ̐ɹϩοΫͷޭࡑ ̑ɹ·ͱΊ
146. ·ͱΊ ػೳ΍πʔϧʹґଘ͠ա͗ͳ͍
147. ·ͱΊ ػೳ΍πʔϧʹґଘ͠ա͗ͳ͍
     ˣ
     γϯϓϧͳઃܭ͸શͯʹউΔ
148. ·ͱΊ σʔλͷण໋͸ίʔυΑΓ΋௕͍
     
149. ·ͱΊ Ұ౓࡞ͬͨ%#͸ফͤͳ͍
     
150. ·ͱΊ Ұ౓࡞ͬͨ%#͸ফͤͳ͍
     ˣ
     ઃܭ͕େࣄ
151. ·ͱΊ σʔλϕʔεͷࢮ͸αʔϏεͷࢮ
152. ·ͱΊ σʔλϕʔεͷࢮ͸αʔϏεͷࢮ
     ˣ
     ղܾͰ͖Δਓ͸ӳ༤
153. ·ͱΊ %#ͷ໰୊͸๨Εͨࠒʹ΍ͬͯ͘Δ
154. ·ͱΊ
155. ·ͱΊ αʔϏε΍νʔϜΛकΔͨΊʹ
     ແ஌Λط஌͢Δ
156. ·ͱΊ ۪ऀ͸ܦݧʹֶͿ
     ݡऀ͸աڈʹֶͿ
157. ·ͱΊ पғͷܦݧஊ͔ΒֶͿ
     
158. ·ͱΊ पғͷܦݧஊ͔ΒֶͿ
     ˣ
     ੵۃతʹίϛϡχςΟΛར༻͢Δ
159. ࢀߟࢿྉ ɾQPTUHSFTRMKQ
     4MBDL νϟοτϧʔϜ
     IUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN
     ɾNZTRMDBTVBM
     4MBDL νϟοτϧʔϜ
     IUUQTNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN
     
160. ·ͱΊ 3%#ͷ஌ࣝ͸ण໋͕௕͍
161. ·ͱΊ 3%#ͷ஌ࣝ͸ण໋͕௕͍
     ˣ
     ֮͑Ε͹࢓ࣄͰ௕͍ؒ໾ʹཱͭ
162. ·ͱΊ ΑΓྑ͍ઃܭΛ
     Ұॹʹߟ͑ͯߦ͖·͠ΐ͏
163. ·ͱΊ 3%#͸͍͍ͧɻ
164. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ