DataBase Refactoring

■オープンセミナー岡山の登壇資料です。
http://okayama.open-seminar.org/

■Twitterまとめ
https://togetter.com/li/1109418

Transcript

1. σʔλϕʔε ϦϑΝΫλϦϯά Φʔϓϯηϛφʔ!Ԭࢁ
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. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹઓ͏ͨΊͷࣄલ४උ ̐ɹϦϑΝΫλϦϯά ̑ɹ·ͱΊ
10. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹઓ͏ͨΊͷࣄલ४උ ̐ɹϦϑΝΫλϦϯά ̑ɹ·ͱΊ
11. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿηʔϧεΤϯδχΞ ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
12. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿηʔϧεΤϯδχΞ ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
13. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿηʔϧεΤϯδχΞ ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢ 
    ೖࣾͰ͢ʂ
14. Mackerel
15. Mackerel
16. ͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer
17. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿηʔϧεΤϯδχΞ ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ ɹɹɹ೔ຊPostgreSQLϢʔβձ ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
18. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹઓ͏ͨΊͷࣄલ४උ ̐ɹϦϑΝΫλϦϯά ̑ɹ·ͱΊ
19. σʔλϕʔεͷෆ٢ͳष͍ σʔλϕʔεͷෆ٢ͳष͍
20. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻
21. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ Ϩίʔυͷଐੑʹ߹Θͤͯ஋ͷҙຯ͕มΘΔΑ͏ͳΧϥϜ
    ձһͩͱೖձ೔ɺελοϑͩͱೖࣾ೔ͱ͢ΔͳͲ
22. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ςʔϒϧόʔδϣϯ
    ࢓༷มߋͷ܁Γฦ͠ͷ຤ɺੜ·ΕΔ͜ͱ͕͋Δ
23. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ඇਖ਼نԽͷ຤ɺσʔλͷ੔߹ੑ͕औΕͳ͘ͳΔ
24. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ྫ͑͹NFNP NFNP NFNPʜ
    ຊ౰ʹඞཁͳ৔߹͸ෳ਺ͷΤϯςΟςΟΛͭʹͯ͠ΔՄ ೳੑ͕͋Δ
25. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ෆཁͳσʔλ͸࡟আ͢Δʢ࿦ཧ࡟আ͠ͳ͍ʣ
    ຊ౰ʹඞཁͳ৔߹͸ύʔςʔγϣϯ΍γϟʔσΟϯά
26. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ ࿦ཧ*%ͳͲσʔλͷதͷ৘ใʹΑͬͯҙຯ͕มΘΔ΋ͷ
    ͔Β࢝·Δ*%͸؅ཧऀɺ͔Β࢝·Δ*%͸ϢʔβͳͲ
27. σʔλϕʔεͷෆ٢ͳष͍ wෳ਺ͷ໨తʹ࢖ΘΕΔΧϥϜ
    wෳ਺ͷ໨తʹ࢖ΘΕΔςʔϒϧ
    w৑௕ͳσʔλ
    wΧϥϜͷଟ͗͢Δςʔϒϧ
    wߦͷଟ͗͢Δςʔϒϧ
    wʮεϚʔτʯΧϥϜ
    wมߋͷڪා σʔλϕʔεϦϑΝΫλϦϯά͔ΒҾ༻ σʔλϕʔεͷมߋ΍σʔλͷߋ৽ʹΑͬͯɺΞϓϦέʔ γϣϯ͕յΕΔͷͰ͸ʁͱͳΓखΛ෇͚Εͳ͍ঢ়ଶ
28. σʔλϕʔεͷෆ٢ͳष͍ σʔλϕʔεͷෆ٢ͳष͍
    
29. σʔλϕʔεͷෆ٢ͳष͍ σʔλϕʔεͷෆ٢ͳष͍
    ˣ
    ٕज़తෛ࠴
30. σʔλϕʔεͷෆ٢ͳष͍ νʔζͳͷ͔෗ͬͨڇೕͳͷ͔
31. σʔλϕʔεͷෆ٢ͳष͍ νʔζͳͷ͔෗ͬͨڇೕͳͷ͔
    ˣ
    ຊ౰ʹվम͕ඞཁ͔Ͳ͏͔
32. σʔλϕʔεͷෆ٢ͳष͍ ᄿ֮Λຏ͘
33. σʔλϕʔεͷෆ٢ͳष͍ ৭ΜͳઃܭΛݟΔ
34. σʔλϕʔεͷෆ٢ͳष͍
35. σʔλϕʔεͷෆ٢ͳष͍ ௚͢΂͖ͩͱ෼͔Ε͹ɺ
    ҆৺ͯ͋͠ͱ͸ಓΛਐΉ͚ͩ
36. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹઓ͏ͨΊͷࣄલ४උ ̐ɹϦϑΝΫλϦϯά ̑ɹ·ͱΊ
37. ઓ͏ͨΊͷࣄલ४උ ઓ͏ʹϦϑΝΫλϦϯά
38. ઓ͏ͨΊͷࣄલ४උ σʔλϕʔεͷಛ௃
39. ઓ͏ͨΊͷࣄલ४උ σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠
40. ઓ͏ͨΊͷࣄલ४උ ϦϑΝΫλϦϯάʹඞཁͳϞϊ
41. ઓ͏ͨΊͷࣄલ४උ
42. ઓ͏ͨΊͷࣄલ४උ
43. ઓ͏ͨΊͷࣄલ४උ σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠ ϞχλϦϯάͯ͠ঢ়ଶΛ஌Δ
    มԽͷӨڹΛϦΞϧλΠϜʹ஌Δ
44. ઓ͏ͨΊͷࣄલ४උ σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠ Өڹ͕޿͍͔Βͦ͜ςετΛॻ͘
    γφϦΦςετ΋େ੾
    ؔ࿈͢ΔΞϓϦέʔγϣϯͷશ͕ͯର৅
45. ઓ͏ͨΊͷࣄલ४උ σʔλϕʔεͷಛ௃
    w σʔλ͸ৗʹมԽ͍ͯ͠Δ
    w Өڹൣғ͕޿͍
    w %#ΛࢭΊΔ͜ͱ͕೉͍͠
46. ઓ͏ͨΊͷࣄલ४උ αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠
47. ઓ͏ͨΊͷࣄલ४උ αʔϏεఀࢭͷน
    
48. ઓ͏ͨΊͷࣄલ४උ αʔϏεఀࢭͷน
    ˣ
    ੓࣏ͱٕज़ͷ྆ํͰղܾ͢Δ
49. ઓ͏ͨΊͷࣄલ४උ αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠
50. ઓ͏ͨΊͷࣄલ४උ αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠
51. ઓ͏ͨΊͷࣄલ४උ αʔϏεఀࢭͷน
    w αʔϏε͸ࢭΊΕͳ͍
    w ࢭΊͨ࣌ͷӨڹൣғ͕Θ͔Βͳ͍
    w ແఀࢭͷ࢓૊ΈΛ࡞Δͷ͸೉͍͠
52. ઓ͏ͨΊͷࣄલ४උ σʔλϕʔεϦϑΝΫλϦϯά͸
    ͘͢͝௕͍εύϯʹͳΔ
53. ઓ͏ͨΊͷࣄલ४උ ࢝ΊΔલʹඞཁͳࣄ
    w ର৅Λબఆ͠ɺҠߦظؒΛܾΊΔ
    w ςετͱϞχλϦϯάΛἧ͑Δ
    w ϦϦʔεઓུΛܾΊΔ
54. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹઓ͏ͨΊͷࣄલ४උ ̐ɹϦϑΝΫλϦϯά ̑ɹ·ͱΊ
55. ϦϑΝΫλϦϯά σʔλϕʔε
    ϦϑΝΫλϦϯά
56. ϦϑΝΫλϦϯά
57. ϦϑΝΫλϦϯά σʔλϕʔε
    ϦϑΝΫλϦϯάͷ෼ྨ
    w ߏ଄ ςʔϒϧ΍7JFXͷఆٛ
    w σʔλ඼࣭ σʔλͷ஋
    w ࢀর੔߹ੑ ςʔϒϧͷؔ࿈ੑ
    w ϝιου ετΞυϓϩγδϟ
    w มߋ ςʔϒϧ΍ΧϥϜͷ௥Ճ
    w ΞʔΩςΫνϟ ΞϓϦͱͷΠϯλʔϑΣΠε
59. ϦϑΝΫλϦϯά ៉ྷͳϦϑΝΫλϦϯά
    w ࢀরͱߋ৽ͷಡΈࠐΈઌΛ෼͚Δ
    w ߋ৽ͷϘτϧωοΫΛ෼͚Δ
    w σʔλઃܭΛݟ௚͢
    w ద੾ʹ*/%&9Λ׆༻͢Δ
60. ϦϑΝΫλϦϯά ҋͷਂ͍ϦϑΝΫλϦϯά
    w +0*/Λඇਖ਼نԽͰิ͏
    w ֎෦Ωʔ੍໿Λ֎͢
    w ͱΓ͋͑ͣΩϟογϡʹಥͬࠐΉ
    w ۃ౓ͷεέʔϧΞοϓ
61. ϦϑΝΫλϦϯά ϦϑΝΫλϦϯάख๏
62. ϦϑΝΫλϦϯά ϦϑΝΫλϦϯάख๏
    w %#ϚΠάϨʔγϣϯπʔϧΛ࢖͏
    w %#ͷػೳΛར༻͢Δ
    w खಈͰ42-Λ࣮ߦ͢Δ
63. ϦϑΝΫλϦϯά ϦϑΝΫλϦϯάख๏
    w %#ϚΠάϨʔγϣϯπʔϧΛ࢖͏
    w %#ͷػೳΛར༻͢Δ
    w खಈͰ42-Λ࣮ߦ͢Δ
64. ϦϑΝΫλϦϯά ϦϑΝΫλϦϯάख๏
    w %#ϚΠάϨʔγϣϯπʔϧΛ࢖͏
    w %#ͷػೳΛར༻͢Δ
    w खಈͰ42-Λ࣮ߦ͢Δ
65. ϦϑΝΫλϦϯά ϦϑΝΫλϦϯάख๏
    w %#ϚΠάϨʔγϣϯπʔϧΛ࢖͏
    w %#ͷػೳΛར༻͢Δ
    w खಈͰ42-Λ࣮ߦ͢Δ
66. ϦϑΝΫλϦϯά ϦϑΝΫλϦϯάͷίπ
    
67. ϦϑΝΫλϦϯά Ҡߦલʹ໭ͤΔࣄ
68. ϦϑΝΫλϦϯά Ҡߦத͸աڈͷঢ়ଶΛอ࣋͢Δࣄ
69. ϦϑΝΫλϦϯά σʔλϕʔε
    ϦϑΝΫλϦϯάͷ෼ྨ
    w ߏ଄ ςʔϒϧ΍7JFXͷఆٛ
    w σʔλ඼࣭ σʔλͷ஋
    w ࢀর੔߹ੑ ςʔϒϧͷؔ࿈ੑ
    w ϝιου ετΞυϓϩγδϟ
    w มߋ ςʔϒϧ΍ΧϥϜͷ௥Ճ
    w ΞʔΩςΫνϟ ΞϓϦͱͷΠϯλʔϑΣΠε
70. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ 
71. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  ຖ೥Ճྸͷ61%"5&͕ඞཁͳͷͰ ੜ೥݄೔ʹมߋ͍ͨ͠
72. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  ੜ೥݄೔͔Β೥ྸΛܭࢉͤ͞Δ ࢓૊Έ͕ඞཁ
    
73. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ  
74. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   Ծ૝ྻΛར༻͢Δ
75. JE ໊લ ೥ྸ  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔  ીࠜɹ૖େ   ીࠜɹኽָ   ીࠜɹᗅָ   ીࠜɹࡣָ  JE ໊લ ੜ೥݄೔ ೥ྸ  ીࠜɹ૖େ    ીࠜɹኽָ    ીࠜɹᗅָ    ીࠜɹࡣָ   ෆཁʹͳͬͨΒ
    ࡟আ͢Δ
76. ϦϑΝΫλϦϯά খ͞ͳมߋΛ௕͍εύϯͰ܁Γฦ͢
77. ϦϑΝΫλϦϯά খ͞ͳมߋΛ௕͍εύϯͰ܁Γฦ͢
    ˣ
    %#͸Өڹൣғ͕޿͍ͷͰ
    ੾Γ෼͚Λ͠΍͘͢͢Δ͜ͱ͕େࣄ
78. ϦϑΝΫλϦϯά େ͖ͳσʔλͷϦϑΝΫλϦϯά
79. ϦϑΝΫλϦϯά େ͖ͳσʔλͷϦϑΝΫλϦϯάྫ
    w େ͖ͳςʔϒϧͷมߋ
    w Ϩίʔυͷߋ৽͕ܹ͍͠ςʔϒϧ
    w %#ͷόʔδϣϯΞοϓ
80. มߋલ ΞϓϦ
81. ෳ੡ มߋલ มߋޙ ΞϓϦ
82. มߋલ มߋޙ ΞϓϦ
83. มߋલ มߋޙ ΞϓϦ
84. มߋޙ ΞϓϦ
85. ϦϑΝΫλϦϯά %#ͷػೳΛ͏·͘׆༻͢Δ
86. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹσʔλϕʔεͷෆ٢ͳष͍ ̏ɹઓ͏ͨΊͷࣄલ४උ ̐ɹDBϦϑΝΫλϦϯά ̑ɹ·ͱΊ
87. ·ͱΊ σʔλϕʔε͸ੜ͖෺
88. ·ͱΊ σʔλϕʔε͸ੜ͖෺ ↓ ఆظతͳϝϯςφϯε͸ඞਢ
89. ·ͱΊ ໰୊͸খ͍͞͏ͪʹ௚͢
90. ·ͱΊ ໰୊͸খ͍͞͏ͪʹ௚͢ ↓ DBͷ੒௕ͱڞʹ໰୊΋ංେԽ͢Δ
91. ·ͱΊ πʔϧ΍DBͷػೳΛ׆༻͢Δ
92. ·ͱΊ πʔϧ΍DBͷػೳΛ׆༻͢Δ ↓ DBϚΠάϨʔγϣϯ΍Ծ૝ྻͳͲ ઓ͏ͨΊͷಓ۩΋೔ʑਐԽ͍ͯ͠Δ
93. ·ͱΊ
94. ·ͱΊ
95. ·ͱΊ Ұ౓࡞ͬͨ%#͸ফͤͳ͍
    
96. ·ͱΊ Ұ౓࡞ͬͨ%#͸ফͤͳ͍
    ˣ
    ઃܭ͕େࣄ
97. ·ͱΊ पғͷܦݧஊ͔ΒֶͿ
    
98. ·ͱΊ पғͷܦݧஊ͔ΒֶͿ
    ˣ
    ੵۃతʹίϛϡχςΟΛར༻͢Δ
99. ࢀߟࢿྉ ɾQPTUHSFTRMKQ
    4MBDL νϟοτϧʔϜ
    IUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN
    ɾNZTRMDBTVBM
    4MBDL νϟοτϧʔϜ
    IUUQTNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN
    
100. ·ͱΊ lखΛಈ͔ͨ͠ਓ͚͕ͩੈքΛม͑Δz
     Š
     :BTVIJSP
     0OJTIJ
101. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ