rdb antipattern refactoring

Builderscon 2017の登壇資料です

https://builderscon.io/tokyo/2017/session/c8f36693-32aa-4bf1-816a-4966f3859926

Transcript

1. RDBΞϯνύλʔϯ ϦϑΝΫλϦϯά #VJMEFSTDPO
   UPLZP
   
2. What is it? ࠓ೔Έͳ͞Μʹ࣋ͬͯؼͬͯ΄͍͜͠ͱ
3. What is it? σʔλϕʔεͷϦϑΝΫλϦϯάͯ͠·͔͢ʁ
4. What is it? σʔλϕʔεͷण໋͸ ΞϓϦέʔγϣϯΑΓ΋௕͍
5. What is it? αʔϏεͷ݈߁Λอͭ
6. What is it? αʔϏεͷ݈߁Λอͭ ↓ ੒௕͢ΔͨΊʹඞཁͳ͜ͱ
7. What is it? ෆద੾ͳσʔλϕʔε͕ ίʔυ΍αʔϏεͷ੒௕ΛࢭΊΔ
8. What is it?
9. What is it? 10೥ޙ΋ઓ͍ଓ͚ΔͨΊʹ ඞཁͳࣄΛ͓఻͑͠·͢
10. What is it?
11. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ
12. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ
13. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
14. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
15. Mackerel
16. ͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer
17. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿCustomer Reliability Engineering ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹɹ ษڧձ୲౰ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
18. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ
20. σʔλϕʔεͷෆ٢ͳष͍ σʔλ͸ੜ͖෺
21. σʔλϕʔεͷෆ٢ͳष͍ σʔλ͸ੜ͖෺
    ˣ
    جຊతʹ௥Ճ͞Ε͍ͯ͘
22. σʔλϕʔεͷෆ٢ͳष͍ σʔλϕʔεઃܭ͸ੵΈ໦
23. σʔλϕʔεઃܭ ͔ͬ͠Γͱ࿅ΒΕͨॳظઃܭ
24. σʔλϕʔεઃܭ ͔ͬ͠Γͱ࿅ΒΕͨॳظઃܭ ͪΌΜͱݕ౼͞Εͨ࢓༷௥Ճ
     ਖ਼͘͠࢓༷มߋ
25. σʔλϕʔεઃܭ ͔ͬ͠Γͱ࿅ΒΕͨॳظઃܭ ͪΌΜͱݕ౼͞Εͨ࢓༷௥Ճ
     ͪΌΜͱݕ౼͞Εͨ࢓༷௥Ճ
     ͪΌΜͱੵΈ্͍͚͛ͯΔ
26. σʔλϕʔεઃܭ ॳظઃܭ
27. σʔλϕʔεઃܭ ॳظઃܭ ϚδΧϧͳઃܭΛ͢Δͱ
    ࢓༷มߋ͕ग़དྷͳ͍
28. σʔλϕʔεઃܭ ॳظઃܭ ࢓༷௥Ճ
29. σʔλϕʔεઃܭ ॳظઃܭ ࢓༷௥Ճ ࣍ͷ࢓༷௥Ճ͸
    Ͳ͏ʹ΋ग़དྷͳ͍
30. ॳظઃܭ ࢓༷௥Ճ 3%#Ξϯνύλʔϯ σʔλϕʔεઃܭ
31. σʔλϕʔεͷෆ٢ͳष͍ 3%#ΞϯνύλʔϯΛݟۃΊΔ
32. RDBΞϯνύλʔϯ w σʔλϕʔεͷ໎ٶ
    w ࣦΘΕͨࣄ࣮
    w ΍Γ͗ͨ͢+0*/
    w ޮ͔ͳ͍JOEFY
    w ϑϥάͷҋ
    
    
    w ʜ
    FUD
33. RDBΞϯνύλʔϯ w σʔλϕʔεͷ໎ٶ
    w ࣦΘΕͨࣄ࣮
    w ΍Γ͗ͨ͢+0*/
    w ޮ͔ͳ͍JOEFY
    w ϑϥάͷҋ
    
    
    w ʜ
    FUD
34. ഁ୼ͨ͠஋ demo=# SELECT delete_flag FROM users GROUP BY delete_flag delete_flag ------------- 1 2 0 9 99 NULL (6 ߦ)
35. RDBΞϯνύλʔϯ
36. IUUQTTQFBLFSEFDLDPNTPVEBJ
37. σʔλϕʔεͷෆ٢ͳष͍ 3%#ΞϯνύλʔϯΛݟۃΊΔ
    ˣ
    σʔλϕʔεͷෆ٢ͳष͍
38. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻
39. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ Ϩίʔυͷଐੑʹ߹Θͤͯ஋ͷҙຯ͕มΘΔΑ͏ͳΧϥϜ
    ձһͩͱೖձ೔ɺελοϑͩͱೖࣾ೔ͱ͢ΔͳͲ
40. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ςʔϒϧόʔδϣϯ
    ࢓༷มߋͷ܁Γฦ͠ͷ຤ɺੜ·ΕΔ͜ͱ͕͋Δ
41. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ඇਖ਼نԽͷ຤ɺσʔλͷ੔߹ੑ͕औΕͳ͘ͳΔ
42. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ྫ͑͹NFNP NFNP NFNPʜ
    ຊ౰ʹඞཁͳ৔߹͸ෳ਺ͷΤϯςΟςΟΛͭʹͯ͠ΔՄ ೳੑ͕͋Δ
43. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ෆཁͳσʔλ͸࡟আ͢Δʢ࿦ཧ࡟আ͠ͳ͍ʣ
    ຊ౰ʹඞཁͳ৔߹͸ύʔςʔγϣϯ΍γϟʔσΟϯά
44. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ࿦ཧ*%ͳͲσʔλͷதͷ৘ใʹΑͬͯҙຯ͕มΘΔ΋ͷ
    ͔Β࢝·Δ*%͸؅ཧऀɺ͔Β࢝·Δ*%͸ϢʔβͳͲ
45. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ σʔλϕʔεͷมߋ΍σʔλͷߋ৽ʹΑͬͯɺΞϓϦέʔ γϣϯ͕յΕΔͷͰ͸ʁͱͳΓखΛ෇͚Εͳ͍ঢ়ଶ
46. σʔλϕʔεͷෆ٢ͳष͍ σʔλϕʔεͷෆ٢ͳष͍
    
47. σʔλϕʔεͷෆ٢ͳष͍ σʔλϕʔεͷෆ٢ͳष͍
    ˣ
    ٕज़తෛ࠴
48. σʔλϕʔεͷෆ٢ͳष͍ νʔζͳͷ͔෗ͬͨڇೕͳͷ͔
49. σʔλϕʔεͷෆ٢ͳष͍ νʔζͳͷ͔෗ͬͨڇೕͳͷ͔
    ˣ
    ຊ౰ʹվम͕ඞཁ͔Ͳ͏͔
50. σʔλϕʔεͷෆ٢ͳष͍ ෗ͬͨڇೕ͸αʔϏεͷ
    ੜࢮʹؔΘΔ
51. σʔλϕʔεͷෆ٢ͳष͍ ͔ͩΒͦ͜ܧଓతͳ
    σʔλϕʔεɾϦϑΝΫλϦϯά
52. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ
53. ͳʹΛϦϑΝΫλϦϯά͢Δ͔ σʔλϕʔεɾϦϑΝΫλϦϯά
54. σʔλϕʔεɾϦϑΝΫλϦϯά
    w ߏ଄ϦϑΝΫλϦϯά
    w σʔλ඼࣭ϦϑΝΫλϦϯά
    w ࢀর੔߹ੑϦϑΝΫλϦϯά
    w ΞʔΩςΫνϟɾϦϑΝΫλϦϯά
    w ϝιουɾϦϑΝΫλϦϯά σʔλϕʔεɾϦϑΝΫλϦϯά
55. σʔλϕʔε
    ϦϑΝΫλϦϯάͷ෼ྨ
    w ߏ଄ ςʔϒϧ΍7JFXͷఆٛ
    w σʔλ඼࣭ σʔλͷ஋
    w ࢀর੔߹ੑ ςʔϒϧͷؔ࿈ੑ
    w ϝιου ετΞυϓϩγδϟ
    w มߋ ςʔϒϧ΍ΧϥϜͷ௥Ճ
    w ΞʔΩςΫνϟ ΞϓϦͱͷΠϯλʔϑΣΠε σʔλϕʔεɾϦϑΝΫλϦϯά
56. ͳʹΛϦϑΝΫλϦϯά͢Δ͔ σʔλϕʔεɾϦϑΝΫλϦϯά
57. ͳʹΛϦϑΝΫλϦϯά͢Δ͔
    ˣ
    γεςϜͷੑ࣭ʹΑͬͯ΋มΘΔ σʔλϕʔεɾϦϑΝΫλϦϯά
58. γϯάϧΞϓϦέʔγϣϯ
    ͱ
    ϚϧνΞϓϦέʔγϣϯ σʔλϕʔεɾϦϑΝΫλϦϯά
59. γϯάϧΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ
60. γϯάϧΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ̍ͭͷΞϓϦέʔγϣϯ͕ ̍ͭͷσʔλϕʔεΛѻ͏
61. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε
62. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε ෳ਺ͷΞϓϦέʔγϣϯ͕ ̍ͭͷσʔλϕʔεΛѻ͏
63. γϯάϧΞϓϦέʔγϣϯͷ࣌͸
    %#ϚΠάϨʔγϣϯ͕׆͖Δ σʔλϕʔεɾϦϑΝΫλϦϯά
64. γϯάϧΞϓϦέʔγϣϯͷ࣌͸
    %#ϚΠάϨʔγϣϯ͕׆͖Δ σʔλϕʔεɾϦϑΝΫλϦϯά ίʔυͰ%#Λ؅ཧͰ͖Δڧ͞
65. ϚϧνΞϓϦέʔγϣϯͷ࣌͸ʁ σʔλϕʔεɾϦϑΝΫλϦϯά
66. ࠓ೔ͷର৅ σʔλϕʔεɾϦϑΝΫλϦϯά
67. ґଘؔ܎ͷଟ͍
    ϚϧνΞϓϦέʔγϣϯ%#Λ
    ϦϑΝΫλϦϯά͢Δ σʔλϕʔεɾϦϑΝΫλϦϯά
68. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ
69. σʔλϕʔε͸ੜ͖෺ ϓϩηεͱϦϑΝΫλϦϯάઓུ
70. σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ
71. σʔλϕʔεϦϑΝΫλϦϯά͸
    ͘͢͝௕͍εύϯʹͳΔ ϓϩηεͱϦϑΝΫλϦϯάઓུ
72. ઓ͏ͨΊͷ४උΛ੔͑Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
73. 
    ந৅Խ ϓϩηεͱϦϑΝΫλϦϯάઓུ
74. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε ӬଓԽϑϨʔϜϫʔΫ
75. 
    ϞχλϦϯά ϓϩηεͱϦϑΝΫλϦϯάઓུ
76. ϓϩηεͱϦϑΝΫλϦϯάઓུ
77. σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠ ϞχλϦϯάͯ͠ঢ়ଶΛ஌Δ
    มԽͷӨڹΛϦΞϧλΠϜʹ஌Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
78. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε ӬଓԽϑϨʔϜϫʔΫ ϞχλϦϯά
79. 
    ඼࣭Λ୲อ͢Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
80. lςετίʔυ͸
    ίʔυͷ඼࣭ͷݟ͑ΔԽz
    ϓϩηεͱϦϑΝΫλϦϯάઓུ Š
    !U@XBEB
81. σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠ Өڹ͕޿͍͔Βͦ͜ςετΛॻ͘
    γφϦΦςετ΋େ੾
    ؔ࿈͢ΔΞϓϦέʔγϣϯͷશ͕ͯର৅ ϓϩηεͱϦϑΝΫλϦϯάઓུ
82. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε ӬଓԽϑϨʔϜϫʔΫ ςετίʔυ ϞχλϦϯά
83. 
    ֮ޛ ϓϩηεͱϦϑΝΫλϦϯάઓུ
84. σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ
85. αʔϏεఀࢭͷน
    ϓϩηεͱϦϑΝΫλϦϯάઓུ
86. αʔϏεఀࢭͷน
    ˣ
    ੓࣏ͱٕज़ͷ྆ํͰղܾ͢Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
87. αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ
88. αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ ϨϓϦέʔγϣϯͳͲΛ͔ͭͬͯݶΓͳ͘ʹ͚ۙͮΔ
    ͔͠͠׬શʹʹ͸ग़དྷͳ͍ͷͰ੓࣏ྗ͕໰ΘΕΔ
89. αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ
90. αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ ςετίʔυͱϞχλϦϯάͰΧόʔ͢Δ
    ༧૝֎ͷঢ়گʹͳͬͯ΋ૉૣ͘ϦΧόϦग़དྷΔࣄલ४උ
91. αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ
92. αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠ ϓϩηεͱϦϑΝΫλϦϯάઓུ ΤϯυϢʔβʔ΍্௕ʹ͜͜Λཧղͯ͠΋Β͏
93. σʔλϕʔεɾϦϑΝΫλϦϯά͸
    ֮ޛ͕ඞཁ ϓϩηεͱϦϑΝΫλϦϯάઓུ
94. 
    ந৅Խ
    
    ϞχλϦϯά
    
    ςετίʔυ
    
    ֮ޛ ϓϩηεͱϦϑΝΫλϦϯάઓུ
95. ͜Ε͚ͩἧ͑ͯߦ͏͚ͩͷՁ஋͕
    ͦͷσʔλϕʔεʹ͋Γ·͔͢ʁ ϓϩηεͱϦϑΝΫλϦϯάઓུ
96. σʔλϕʔεͷෆ٢ͳष͍ νʔζͳͷ͔෗ͬͨڇೕͳͷ͔
97. ͜Ε͚ͩἧ͑ͯߦ͏͚ͩͷՁ஋͕
    ͦͷσʔλϕʔεʹ͋Γ·͔͢ʁ ϓϩηεͱϦϑΝΫλϦϯάઓུ खؒ΋࣌ؒ΋͔͔Δɺ͔ͩΒͦ͜ݕ౼͕େࣄ
     ϦϑΝΫλϦϯάͷҙຯ͸͋Δ͔ʁ
     ࡞ۀʹԠͨ͡ͷޮՌ͸͋Δ͔ʁ
     ࠓ΍Δ΂͖͔ʁ
    
98. ΍ΔͱܾΊͨΒ
    w ର৅Λબఆ͠ɺҠߦظؒΛܾΊΔ
    w ςετͱϞχλϦϯάΛἧ͑Δ
    w ϦϦʔεઓུΛܾΊΔ ϓϩηεͱϦϑΝΫλϦϯάઓུ
99. ΍ΔͱܾΊͨΒ
    w ର৅Λબఆ͠ɺҠߦظؒΛܾΊΔ
    w ςετͱϞχλϦϯάΛἧ͑Δ
    w ϦϦʔεઓུΛܾΊΔ ϓϩηεͱϦϑΝΫλϦϯάઓུ
100. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε ӬଓԽϑϨʔϜϫʔΫ ςετίʔυ ϞχλϦϯά ෳ਺ͷΞϓϦέʔγϣϯͷมߋ͕ඞཁͳ৔߹ʹ
     શͯͷΞϓϦέʔγϣϯ͕ಈ͘ඞཁ͕͋Δ
101. ϚϧνΞϓϦέʔγϣϯ σʔλϕʔε ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ ΞϓϦέʔγϣϯ όονॲཧ σʔλϕʔε ӬଓԽϑϨʔϜϫʔΫ ςετίʔυ ϞχλϦϯά ෳ਺ͷΞϓϦέʔγϣϯͷมߋ͕ඞཁͳ৔߹ʹ
     શͯͷΞϓϦέʔγϣϯ͕ಈ͘ඞཁ͕͋Δ ಉ࣌ʹΞϓϦέʔγϣϯ͕ߋ৽Ͱ͖ͳ͍
     ৔߹΋͋ΔͷͰҠߦظ͕ؒඞཁ
102. ΍ΔͱܾΊͨΒ
     w ର৅Λબఆ͠ɺҠߦظؒΛܾΊΔ
     w ςετͱϞχλϦϯάΛἧ͑Δ
     w ϦϦʔεઓུΛܾΊΔ ϓϩηεͱϦϑΝΫλϦϯάઓུ
103. ΍ΔͱܾΊͨΒ
     w ର৅Λબఆ͠ɺҠߦظؒΛܾΊΔ
     w ςετͱϞχλϦϯάΛἧ͑Δ
     w ϦϦʔεઓུΛܾΊΔ ϓϩηεͱϦϑΝΫλϦϯάઓུ
104. Ҡߦத͸લঢ়ଶͰ΋৽ঢ়ଶͰ΋
     ΞϓϦέʔγϣϯ͸ಈ͘ඞཁ͕͋Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
105. σʔλϕʔε
     ϦϑΝΫλϦϯάͷ෼ྨ
     w ߏ଄ ςʔϒϧ΍7JFXͷఆٛ
     w σʔλ඼࣭ σʔλͷ஋
     w ࢀর੔߹ੑ ςʔϒϧͷؔ࿈ੑ
     w ϝιου ετΞυϓϩγδϟ
     w มߋ ςʔϒϧ΍ΧϥϜͷ௥Ճ
     w ΞʔΩςΫνϟ ΞϓϦͱͷΠϯλʔϑΣΠε σʔλϕʔεɾϦϑΝΫλϦϯά
106. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ 
107. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  ຖ೥Ճྸͷ61%"5&͕ඞཁͳͷͰ ੜ೥݄೔ʹมߋ͍ͨ͠
108. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  ੜ೥݄೔͔Β೥ྸΛܭࢉͤ͞Δ ࢓૊Έ͕ඞཁ
     
109. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ  
110. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   Ҡߦظؒ͸ඞཁ
111. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   Ҡߦ͕׬ྃͯ͠ෆཁʹ ͳͬͨΒ࡟আ͢Δ
112. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   ͲͷΑ͏ʹ͜ͷςʔϒϧΛ දݱ͢Δ͔
113. %#ͷػೳΛ͏·͘׆༻͢Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
114. %#ͷػೳΛ͏·͘׆༻͢Δ
     ˣ
     ྫ͑͹τϦΨʔ ϓϩηεͱϦϑΝΫλϦϯάઓུ
115. JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   چΞϓϦ ৽ΞϓϦ */4&35࣌ʹ೥ྸ͕ແ͍
116. JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   چΞϓϦ ৽ΞϓϦ */4&35࣌ʹτϦΨʔͰ೥ྸΛܭࢉͯ͠ೖྗ͢Δ
117. JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   چΞϓϦ ৽ΞϓϦ औಘ࣌ʹ೥ྸ͕͋ΔͷͰಈ͘
118. 
     ϦϑΝΫλϦϯάͷඞཁੑΛ൑அ͢Δ
     
     ద੾ͳϦϑΝΫλϦϯάख๏Λબ୒͢Δ
     
     σʔλϕʔεͷҠߦظؒΛܾΊΔ
     
     ϦϑΝΫλϦϯάͷ࣮ࢪ
     
     มߋલมߋதมߋޙͷςετΛߦ͏
     
     ΞϓϦέʔγϣϯΛॱ࣍վम͢Δ
     
     ϦϑΝΫλϦϯά׬ྃΛप஌͢Δ ϓϩηεͱϦϑΝΫλϦϯάઓུ
119. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ ̒ɹ·ͱΊ
120. ݱ৔Ͱઓ͏͋ͳͨ΁ ϦϑΝΫλϦϯάख๏
     w %#ϚΠάϨʔγϣϯπʔϧΛ࢖͏
     w %#ͷػೳΛར༻͢Δ
     w खಈͰ42-Λ࣮ߦ͢Δ
121. ϦϑΝΫλϦϯάͷίπ
     ݱ৔Ͱઓ͏͋ͳͨ΁
122. Ҡߦલʹ໭ͤΔࣄ ݱ৔Ͱઓ͏͋ͳͨ΁
123. Ҡߦத͸աڈͷঢ়ଶΛอ࣋͢Δࣄ ݱ৔Ͱઓ͏͋ͳͨ΁
124. Ҡߦத͸աڈͷঢ়ଶΛอ࣋͢Δࣄ
     ˣ
     CBDLVQ΍ϨϓϦέʔγϣϯΛ࢖͏ ݱ৔Ͱઓ͏͋ͳͨ΁
125. খ͞ͳมߋΛ௕͍εύϯͰ܁Γฦ͢
     ݱ৔Ͱઓ͏͋ͳͨ΁
126. খ͞ͳมߋΛ௕͍εύϯͰ܁Γฦ͢
     ˣ
     %#͸Өڹൣғ͕޿͍ͷͰ
     ੾Γ෼͚Λ͠΍͘͢͢Δ͜ͱ͕େࣄ ݱ৔Ͱઓ͏͋ͳͨ΁
127. 㙽ʹ΋֯ʹ΋
     ςετͱϞχλϦϯά͕େࣄ ݱ৔Ͱઓ͏͋ͳͨ΁ ແ͠Ͱઓ͏ͷ͸ମॏܭΛ࣋ͨͳ͍μΠΤοτͱҰॹ
128. ៉ྷͳϦϑΝΫλϦϯά
     w ࢀরͱߋ৽ͷಡΈࠐΈઌΛ෼͚Δ
     w ߋ৽ͷϘτϧωοΫΛ෼͚Δ
     w σʔλઃܭΛݟ௚͢
     w ద੾ʹ*/%&9Λ׆༻͢Δ ݱ৔Ͱઓ͏͋ͳͨ΁
129. ҋͷਂ͍ϦϑΝΫλϦϯά
     w +0*/Λඇਖ਼نԽͰิ͏
     w ֎෦Ωʔ੍໿Λ֎͢
     w ͱΓ͋͑ͣΩϟογϡʹಥͬࠐΉ
     w ۃ౓ͷεέʔϧΞοϓ ݱ৔Ͱઓ͏͋ͳͨ΁
130. %#ͷػೳΛ͏·͘׆༻͢Δ ݱ৔Ͱઓ͏͋ͳͨ΁
131. ίϛϡχςΟΛ͏·͘׆༻͢Δ ݱ৔Ͱઓ͏͋ͳͨ΁
132. σʔλϕʔείϛϡχςΟ ɾQPTUHSFTRMKQ
     4MBDL νϟοτϧʔϜ
     IUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN
     ɾNZTRMDBTVBM
     4MBDL νϟοτϧʔϜ
     IUUQTNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN
     
133. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ
134. ·ͱΊ σʔλϕʔεͷण໋͸
     ΞϓϦέʔγϣϯΑΓ΋௕͍
135. ·ͱΊ Ұ౓࡞ͬͨ%#͸ফͤͳ͍
     
136. ·ͱΊ Ұ౓࡞ͬͨ%#͸ফͤͳ͍
     ˣ
     ఆظతͳϝϯςφϯε͸ඞਢ
137. ·ͱΊ ໰୊͸খ͍͞͏ͪʹ௚͢
138. ·ͱΊ ໰୊͸খ͍͞͏ͪʹ௚͢
     ˣ
     %#ͷංେԽͱڞʹ໰୊΋େ͖͘ͳΔ
139. ·ͱΊ πʔϧ΍%#ͷػೳΛ׆༻͢Δ
140. ·ͱΊ πʔϧ΍%#ͷػೳΛ׆༻͢Δ
     ˣ
     %#ϚΠάϨʔγϣϯ΍Ծ૝ྻͳͲ
     ઓ͏ͨΊͷಓ۩΋ਐԽ͍ͯ͠Δ
141. ·ͱΊ
142. ·ͱΊ %#ͷ໰୊͸๨Εͨࠒʹ΍ͬͯ͘Δ
143. ·ͱΊ
144. ·ͱΊ σʔλϕʔεͷࢮ͸αʔϏεͷࢮ
145. ·ͱΊ σʔλϕʔεͷࢮ͸αʔϏεͷࢮ
     ˣ
     ղܾͰ͖Δਓ͸ӳ༤
146. ·ͱΊ αʔϏε΍νʔϜΛकΔ
147. ·ͱΊ αʔϏε΍νʔϜΛकΔ
     ˣ
     ͦͷͨΊʹֶͿ
148. ·ͱΊ ۪ऀ͸ܦݧʹֶͿ
     ݡऀ͸աڈʹֶͿ
149. ·ͱΊ पғͷܦݧஊ͔ΒֶͿ
     
150. ·ͱΊ पғͷܦݧஊ͔ΒֶͿ
     ˣ
     ੵۃతʹίϛϡχςΟΛར༻͢Δ
151. ·ͱΊ 3%#ͷ஌ࣝ͸ण໋͕௕͍
152. ·ͱΊ 3%#ͷ஌ࣝ͸ण໋͕௕͍
     ˣ
     ֮͑Ε͹࢓ࣄͰ௕͍ؒ໾ʹཱͭ
153. ·ͱΊ ࠓ೔͔Βվળ͢Δ
154. ·ͱΊ ࠓ೔͔Βվળ͢Δ
     ˣ
     ͦΕ͸͋ͳͨࣗ਎Ͱ͢
155. ·ͱΊ lखΛಈ͔ͨ͠ਓ͚͕ͩੈքΛม͑Δz
     Š
     :BTVIJSP
     0OJTIJ
156. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ