rdb antipattern refactoring

rdb antipattern refactoring

88f4e84b94fe07cddbd9e6479d689192?s=128

soudai sone

August 03, 2017
Tweet

Transcript

  1. RDBΞϯνύλʔϯ ϦϑΝΫλϦϯά #VJMEFSTDPOUPLZP

  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. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹσʔλϕʔεɾϦϑΝΫλϦϯά ̐ɹϓϩηεͱϦϑΝΫλϦϯάઓུ ̑ɹݱ৔Ͱઓ͏͋ͳͨ΁ɹ ̒ɹ·ͱΊ

  19. None
  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. σʔλϕʔείϛϡχςΟ ɾQPTUHSFTRMKQ4MBDL νϟοτϧʔϜ  IUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN ɾNZTRMDBTVBM4MBDL νϟοτϧʔϜ  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 Š:BTVIJSP0OJTIJ

  156. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ