Webエンジニアに知ってほしいRDBアンチパターン

YAPC::Kansaiの登壇資料です。

Transcript

1. WebΤϯδχΞʹ஌ͬͯ΄͍͠
   RDBΞϯνύλʔϯ
   :"1$,BOTBJ
   

   View Slide

2. What is it?
   ࠓ೔Έͳ͞Μʹ࣋ͬͯؼͬͯ΄͍͜͠ͱ
   

   View Slide

3. What is it?
   σʔλϕʔεͷण໋͸
   ΞϓϦέʔγϣϯΑΓ΋௕͍
   

   View Slide

4. What is it?
   ͦΜͳ௕͍෇͖߹͍ʹͳΔσʔλϕʔε
   ͷେ੾ͳࣄΛ͓఻͑͠·͢
   

   View Slide

5. What is it?
   ର৅ͷσʔλϕʔειϑτ΢ΣΞ
   

   View Slide

6. What is it?
   PostgreSQL 9.6ͱMySQL 5.7(InnoDB)ʹݶΔ
   ଞͷRDBͷ࿩͸͠·ͤΜ
   

   View Slide

7. What is it?
   RDBΞϯνύλʔϯ
   

   View Slide

8. What is it?
   RDBΞϯνύλʔϯ
   ↓
   ޙʑʹۤ͠ΈΛੜΉ
   

   View Slide

9. What is it?
   RDBΞϯνύλʔϯΛ஌Δ
   

   View Slide

10. What is it?
    RDBΞϯνύλʔϯΛ஌Δ
    ↓
    ಉ͡աͪΛ܁Γฦ͞ͳ͍
    

    View Slide

11. What is it?
    ࠓ೔͸RDBͷࣦഊྫΛ͝঺հ͠·͢
    

    View Slide

12. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹ๨ΕڈΒΕͨόοΫΞοϓ
    ̏ɹ࢖ΘΕͳ੍͍໿
    ̐ɹϩοΫͷޭࡑ
    ̑ɹ·ͱΊ
    

    View Slide

13. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹ๨ΕڈΒΕͨόοΫΞοϓ
    ̏ɹ࢖ΘΕͳ੍͍໿
    ̐ɹϩοΫͷޭࡑ
    ̑ɹ·ͱΊ
    

    View Slide

14. ࣗݾ঺հ
    ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ
    ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
    ৬ۀɿηʔϧεΤϯδχΞ
    ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ
    ɹɹɹ೔ຊPostgreSQLϢʔβձ
    ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕
    ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
    

    View Slide

15. ࣗݾ঺հ
    ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ
    ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
    ৬ۀɿηʔϧεΤϯδχΞ
    ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ
    ɹɹɹ೔ຊPostgreSQLϢʔβձ
    ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕
    ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
    

    View Slide

16. ࣗݾ঺հ
    ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ
    ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
    ৬ۀɿηʔϧεΤϯδχΞ
    ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ
    ɹɹɹ೔ຊPostgreSQLϢʔβձ
    ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕
    ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
    ೖࣾͰ͢ʂ
    

    View Slide

17. Mackerel
    

    View Slide

18. ͸ͯͳ͸஥ؒΛ୳ͯ͠·͢
    curl -sIL mackerel.io | grep engineer
    

    View Slide

19. ࣗݾ঺հ
    ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ
    ೥ྸɿ32ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
    ৬ۀɿηʔϧεΤϯδχΞ
    ॴଐɿגࣜձࣾ ͸ͯͳʢMackerelνʔϜʣ
    ɹɹɹ೔ຊPostgreSQLϢʔβձ
    ɹɹɹɹɹதࠃࢧ෦ ࢧ෦௕
    ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢
    

    View Slide

20. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹ๨ΕڈΒΕͨόοΫΞοϓ
    ̏ɹ࢖ΘΕͳ੍͍໿
    ̐ɹϩοΫͷޭࡑ
    ̑ɹ·ͱΊ
    

    View Slide

21. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓऔͬͯ·͔͢ʁ
    

    View Slide

22. ๨ΕڈΒΕͨόοΫΞοϓ
    2ʮϨϓϦέʔγϣϯͯ͠Δ͔Β
    όοΫΞοϓ͸ෆཁͰ͸ʁʯ
    

    View Slide

23. ๨ΕڈΒΕͨόοΫΞοϓ
    2ʮϨϓϦέʔγϣϯͯ͠Δ͔Β
    όοΫΞοϓ͸ෆཁͰ͸ʁʯ
    ˣ
    ඞཁͰ͢
    

    View Slide

24. ๨ΕڈΒΕͨόοΫΞοϓ
    ϨϓϦέʔγϣϯ͸ෳ੡
    ྨࣅྫɿσΟεΫͷϛϥʔϦϯά
    

    View Slide

25. ๨ΕڈΒΕͨόοΫΞοϓ
    ϨϓϦέʔγϣϯͰकΕͳ͍ύλʔϯ
    w ෆਖ਼ͳσʔλࠞೖ
    w %&-&5&΍%301
    w ώϡʔϚϯΤϥʔ
    

    View Slide

26. ๨ΕڈΒΕͨόοΫΞοϓ
    ͜ΕΒ͔ΒकΔͨΊʹ
    όοΫΞοϓ͕ඞཁ
    

    View Slide

27. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓΛऔͬͯ·͔͢ʁ
    

    View Slide

28. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓΛऔͬͯ·͔͢ʁ
    ˣ
    ϦετΞΛࢼ͠·͔ͨ͠ʁ
    

    View Slide

29. ๨ΕڈΒΕͨόοΫΞοϓ
    ໭ͤͳ͍όοΫΞοϓʹՁ஋͸ແ͍
    

    View Slide

30. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷछྨ
    w ࿦ཧόοΫΞοϓ
    w ΦϑϥΠϯόοΫΞοϓ
    w ΦϯϥΠϯόοΫΞοϓ
    

    View Slide

31. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷछྨ
    w ࿦ཧόοΫΞοϓ
    w ΦϑϥΠϯόοΫΞοϓ
    w ΦϯϥΠϯόοΫΞοϓ
    NZTRMEVNQ΍QH@EVNQ
    42-Λͦͷ··อଘ͢ΔͷͰ͓खܰ
    

    View Slide

32. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷछྨ
    w ࿦ཧόοΫΞοϓ
    w ΦϑϥΠϯόοΫΞοϓ
    w ΦϯϥΠϯόοΫΞοϓ
    αʔόΛࢭΊͯσʔλϑΝΠϧΛίϐʔ
    ख๏͸৭ʑ͋Δ͚Ͳ࿦ཧόοΫΞοϓΑΓ଎͍
    

    View Slide

33. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷछྨ
    w ࿦ཧόοΫΞοϓ
    w ΦϑϥΠϯόοΫΞοϓ
    w ΦϯϥΠϯόοΫΞοϓ
    αʔόΛࢭΊͣʹόοΫΞοϓग़དྷΔ
    ͔͠΋೚ҙͷ৔ॴʹ໭ͤΔ
    ͨͩ͠ɺӡ༻ίετେ
    

    View Slide

34. ๨ΕڈΒΕͨόοΫΞοϓ
    ख๏
    CBDLVQ
    αΠζ
    CBDLVQ
    ࣌ؒ
    ϦετΞ
    ࣌ؒ
    ӡ༻
    ίετ
    ෮چ࣌఺
    ࿦ཧ
    όοΫΞοϓ
    খ খ େ খ όοΫΞοϓ։࢝࣌఺
    ΦϑϥΠϯ
    όοΫΞοϓ
    େ த খ খ όοΫΞοϓ։࢝࣌఺
    ΦϯϥΠϯ
    όοΫΞοϓ
    େʴЋ தʙେ த தʙେ
    όοΫΞοϓऴྃ௚ޙ͔Β
    ࠷৽ঢ়ଶͷؒͷ೚ҙͷ࣌఺
    

    View Slide

35. ๨ΕڈΒΕͨόοΫΞοϓ
    3%#ͷػೳҎ֎ͷόοΫΞοϓ
    w 4UPSBHFͷػೳΛ࢖͏
    w όοΫΞοϓιϑτΛ࢖͏
    w 04ͷػೳΛ࢖͏
    

    View Slide

36. ๨ΕڈΒΕͨόοΫΞοϓ
    3%#ͷػೳҎ֎ͷόοΫΞοϓ
    w 4UPSBHFͷػೳΛ࢖͏
    w όοΫΞοϓιϑτΛ࢖͏
    w 04ͷػೳΛ࢖͏
    εφοϓγϣοτͱ͔
    

    View Slide

37. ๨ΕڈΒΕͨόοΫΞοϓ
    3%#ͷػೳҎ֎ͷόοΫΞοϓ
    w 4UPSBHFͷػೳΛ࢖͏
    w όοΫΞοϓιϑτΛ࢖͏
    w 04ͷػೳΛ࢖͏
    ঎༻όοΫΞοϓιϑτ΢ΣΞͱ͔
    

    View Slide

38. ๨ΕڈΒΕͨόοΫΞοϓ
    3%#ͷػೳҎ֎ͷόοΫΞοϓ
    w 4UPSBHFͷػೳΛ࢖͏
    w όοΫΞοϓιϑτΛ࢖͏
    w 04ͷػೳΛ࢖͏
    04͝ͱؙͬͱόοΫΞοϓ͢Δͱ͔
    

    View Slide

39. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓʹΑͬͯ
    ϦετΞͷํ๏΋ҧ͏
    

    View Slide

40. ๨ΕڈΒΕͨόοΫΞοϓ
    ϦετΞΛࢼ͠·͔ͨ͠ʁ
    

    View Slide

41. ๨ΕڈΒΕͨόοΫΞοϓ
    ϦετΞΛࢼ͠·͔ͨ͠ʁ
    ˣ
    ϝϯόʔͷதͰग़དྷΔਓ͍·͔͢ʁ
    

    View Slide

42. ๨ΕڈΒΕͨόοΫΞοϓ
    Ξϯνύλʔϯ
    w όοΫΞοϓͯ͠ͳ͍
    w ϦετΞग़དྷΔਓ͕͍ͳ͍
    w Քಇ཰ʹ߹ͬͨઃܭग़དྷͯͳ͍
    

    View Slide

43. ๨ΕڈΒΕͨόοΫΞοϓ
    Քಇ཰ ೥ؒఀࢭ࣌ؒ ೉қ౓
    ೔ όοΫΞοϓͱϦετΞͰे෼
    ೔
    ΦϯϓϨͳΒ༧උϚγϯ͕ඞཁ
    େσʔλͳΒϦετΞॴཁ࣌ؒΛ೺Ѳ͓ͯ͘͠
    ࣌ؒ
    ๏ఆఀిͱ͔࣌ؒ೔ରԠͳͲ
    γεςϜ֎ͷ෦෼ʹ΋Өڹ͕ग़Δ
    ෼
    όοΫΞοϓ͔ΒͷϦετΞ͚ͩͰ͸೉͍͠
    ίʔϧυελϯόΠͱ͔ඞཁ
    ෼ ஗ԆϨϓϦέʔγϣϯͳͲͷઐ༻ͷγεςϜ͕ඞཁ
    ඵ
    ແఀࢭαʔόͱ͔ඞཁͳϨϕϧ
    ίετ͕ҟৗʹߴ͘ͳΔ
    

    View Slide

44. ๨ΕڈΒΕͨόοΫΞοϓ
    ࣗ෼ͨͪͷ໨ࢦ͢৔ॴΛܾΊΔ
    

    View Slide

45. ๨ΕڈΒΕͨόοΫΞοϓ
    ࣗ෼ͨͪͷ໨ࢦ͢৔ॴΛܾΊΔ
    ˣ
    ͦΕʹ߹ΘͤͨόοΫΞοϓΛʂ
    

    View Slide

46. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓ΋औͬͨ͠
    ϦετΞ΋ࢼ͔ͨ͠Βେৎ෉ʂ
    

    View Slide

47. ๨ΕڈΒΕͨόοΫΞοϓ
    ͱࢥͬͨΒେؒҧ͍
    ʢ͔͜͜ΒΉ͠Ζຊ୊ʣ
    

    View Slide

48. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷ᠘
    w Քಇ౰ॳ͸ಈ͍͍͕ͯͨόοΫΞοϓ͕ංେԽ
    ͯ͠ɺ͋Δ೔ΤϥʔʹͳΓऔΕͯͳ͔ͬͨ
    w ϦετΞ͠Α͏ͱࢥ͕ͬͨϑΝΠϧ͕σΧ͗͢
    ͯసૹʹ͕͔͔࣌ؒΓɺλΠϜΞ΢τʹͳΔ
    w ಉ͡෺ཧαʔόʹऔ͍ͬͯΔͷͰσΟεΫ͕ࢮ
    ͵ͱҰॹʹόοΫΞοϓ΋ࢮ͵
    

    View Slide

49. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷ᠘
    w Քಇ౰ॳ͸ಈ͍͍͕ͯͨόοΫΞοϓ͕ංେԽ
    ͯ͠ɺ͋Δ೔ΤϥʔʹͳΓऔΕͯͳ͔ͬͨ
    w ϦετΞ͠Α͏ͱࢥ͕ͬͨϑΝΠϧ͕σΧ͗͢
    ͯసૹʹ͕͔͔࣌ؒΓɺλΠϜΞ΢τʹͳΔ
    w ಉ͡෺ཧαʔόʹऔ͍ͬͯΔͷͰσΟεΫ͕ࢮ
    ͵ͱҰॹʹόοΫΞοϓ΋ࢮ͵
    

    View Slide

50. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷ᠘
    w Քಇ౰ॳ͸ಈ͍͍͕ͯͨόοΫΞοϓ͕ංେԽ
    ͯ͠ɺ͋Δ೔ΤϥʔʹͳΓऔΕͯͳ͔ͬͨ
    w ϦετΞ͠Α͏ͱࢥ͕ͬͨϑΝΠϧ͕σΧ͗͢
    ͯసૹʹ͕͔͔࣌ؒΓɺλΠϜΞ΢τʹͳΔ
    w ಉ͡෺ཧαʔόʹऔ͍ͬͯΔͷͰσΟεΫ͕ࢮ
    ͵ͱҰॹʹόοΫΞοϓ΋ࢮ͵
    

    View Slide

51. ๨ΕڈΒΕͨόοΫΞοϓ
    όοΫΞοϓͷ᠘
    w Քಇ౰ॳ͸ಈ͍͍͕ͯͨόοΫΞοϓ͕ංେԽ
    ͯ͠ɺ͋Δ೔ΤϥʔʹͳΓऔΕͯͳ͔ͬͨ
    w ϦετΞ͠Α͏ͱࢥ͕ͬͨϑΝΠϧ͕σΧ͗͢
    ͯసૹʹ͕͔͔࣌ؒΓɺλΠϜΞ΢τʹͳΔ
    w ಉ͡෺ཧαʔόʹऔ͍ͬͯΔͷͰσΟεΫ͕ࢮ
    ͵ͱҰॹʹόοΫΞοϓ΋ࢮ͵
    

    View Slide

52. ๨ΕڈΒΕͨόοΫΞοϓ
    ͦͷόοΫΞοϓεΫϦϓτ
    ࠓ΋ͪΌΜͱಈ͍ͯ·͔͢ʁ
    

    View Slide

53. ๨ΕڈΒΕͨόοΫΞοϓ
    ॲํᝦ
    w όοΫΞοϓͱϦετΞΛඞͣࢼ͢
    w ఆظతʹϦετΞ͢Δ
    w όοΫΞοϓͷ݁ՌΛద੾ʹ؂ࢹ͢Δ
    

    View Slide

54. ๨ΕڈΒΕͨόοΫΞοϓ
    స͹͵ઌͷόοΫΞοϓ
    

    View Slide

55. ๨ΕڈΒΕͨόοΫΞοϓ
    స͹͵ઌͷόοΫΞοϓ
    ˣ
    ि໌͚ʹඞͣνʔϜͷঢ়گ֬ೝΛʂ
    

    View Slide

56. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹ๨ΕڈΒΕͨόοΫΞοϓ
    ̏ɹ࢖ΘΕͳ੍͍໿
    ̐ɹϩοΫͷޭࡑ
    ̑ɹ·ͱΊ
    

    View Slide

57. ࢖ΘΕͳ੍͍໿
    3%#ͷ੹຿
    

    View Slide

58. ࢖ΘΕͳ੍͍໿
    3%#ͷ੹຿
    w σʔλΛอଘ͢Δ
    w σʔλΛऔΓग़͢
    w σʔλΛकΔ
    

    View Slide

59. ࢖ΘΕͳ੍͍໿
    3%#ͷ੹຿
    w σʔλΛอଘ͢Δ
    w σʔλΛऔΓग़͢
    w σʔλΛकΔ
    

    View Slide

60. ࢖ΘΕͳ੍͍໿
    σʔλΛԿ͔ΒकΔ͔ʁ
    

    View Slide

61. ࢖ΘΕͳ੍͍໿
    όάͱώϡʔϚϯΤϥʔ͔ΒकΔ
    

    View Slide

62. ࢖ΘΕͳ੍͍໿
    ੍໿ͷछྨ આ໌
    13*."3:,&:੍໿
    ॏෳͱ/6--͕ແ͘ɺͦͷςʔϒϧͰҰҙͳߦ
    Ͱ͋Δ͜ͱΛ֬ఆͤ͞Δ
    /05/6--੍໿ /6--͕ແ͍ࣄΛ֬ఆͤ͞Δ
    6/*26&੍໿
    ͦͷ஋͕ςʔϒϧͰҰҙͰ͋Δ͜ͱΛ֬ఆͤ͞
    Δʢ/6--͸ڐ༰͞ΕΔʣ
    $)&$,੍໿
    ࢦఆͨ͠৚݅ͷ஋ͷΈ͕อଘ͞Ε͍ͯΔ͜ͱΛ
    ֬ఆͤ͞Δ
    %&'"6-5੍໿
    ஋͕ࢦఆ͞Εͳ͍࣌ʹอଘ͞ΕΔ஋ΛܾΊΔ
    ͦΕʹΑΓॳظ஋Λ֬ఆͤ͞Δ
    '03&*(/,&:੍໿
    ผςʔϒϧͷओΩʔͱࢀর੔߹ੑ͕อͨΕͯΔ
    ࣄΛ֬ఆͤ͞Δ
    

    View Slide

63. ࢖ΘΕͳ੍͍໿
    ஋ͱϦϨʔγϣϯγοϓΛकΔ
    

    View Slide

64. ࢖ΘΕͳ੍͍໿
    ੍໿Λ࢖Θͳ͍എܠ
    w ΞϓϦଆͰόϦσʔγϣϯ͢Δ͔Βେৎ෉
    w ੍໿͢ΔͱςετσʔλΛ༻ҙ͢Δͷ͕໘౗
    w 03.͕ରԠͯ͠ͳ͍
    

    View Slide

65. ࢖ΘΕͳ੍͍໿
    ͦͷ݁Ռʜ
    

    View Slide

66. ࢖ΘΕͳ੍͍໿
    ஋΍ϦϨʔγϣϯγοϓ͕ഁ୼
    

    View Slide

67. ࢖ΘΕͳ੍͍໿
    ஋΍ϦϨʔγϣϯγοϓ͕ഁ୼
    ˣ
    σʔλΛඥղ͚ͳ͍
    

    View Slide

68. ഁ୼ͨ͠஋
    demo=# SELECT delete_flag
    FROM users
    GROUP BY delete_flag
    delete_flag
    -------------
    1
    2
    0
    9
    99
    NULL
    (6 ߦ)
    

    View Slide

69. ࢖ΘΕͳ੍͍໿
    ഁ୼ͨ͠ϦϨʔγϣϯγοϓ
    w JE͕Ͳͷςʔϒϧʹඥͮ͘ͷ͔Θ͔Βͳ͍
    w ςʔϒϧͷ਌ࢠؔ܎͕Θ͔Βͳ͍
    w ςʔϒϧͷσʔλʹෆ੔߹͕͋ͬͯ+0*/
    ग़དྷͳ͍
    

    View Slide

70. ࢖ΘΕͳ੍͍໿
    ద੾ͳ੍໿ͱ஋͸ઃܭΛޠΔ
    

    View Slide

71. ࢖ΘΕͳ੍͍໿
    ద੾ͳ੍໿ͱ஋͸ઃܭΛޠΔ
    ˣ
    ػցతʹ&3ਤ΋࡞ΕΔ
    

    View Slide

72. ࢖ΘΕͳ੍͍໿
    ॲํᝦ
    w ద੾ʹ੍໿Λ׆༻͢Δ
    w ਖ਼نԽͯ͠֎෦Ωʔ੍໿Λਖ਼͘͠࢖͏
    w ࠷ॳ͸੍໿͕͋ΔલఏͰߟ͑ɺඞཁͳΒ
    ֎͢͜ͱΛݕ౼͢Δ
    

    View Slide

73. ࢖ΘΕͳ੍͍໿
    σʔλϕʔεͷઃܭ͸ͱͯ΋େࣄ
    

    View Slide

74. ࢖ΘΕͳ੍͍໿
    σʔλϕʔεͷઃܭ͸ͱͯ΋େࣄ
    ˣ
    ੍໿Λ࢖͏͜ͱͰྑ͍ઃܭΛ࡞Δ
    

    View Slide

75. ࢖ΘΕͳ੍͍໿
    ద੾ͳ੍໿͸ద੾ͳઃܭΛੜΈ
    ద੾ͳઃܭ͸ੜ࢈ੑΛߴΊΔ
    

    View Slide

76. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹ๨ΕڈΒΕͨόοΫΞοϓ
    ̏ɹ࢖ΘΕͳ੍͍໿
    ̐ɹϩοΫͷޭࡑ
    ̑ɹ·ͱΊ
    

    View Slide

77. ϩοΫͷޭࡑ
    τϥϯβΫγϣϯͱσʔλ੔߹ੑ
    

    View Slide

78. ϩοΫͷޭࡑ
    τϥϯβΫγϣϯ෼཭Ϩϕϧ
    

    View Slide

79. ϩοΫͷޭࡑ
    τϥϯβΫγϣϯ෼཭Ϩϕϧ
    ໊લ ෼཭Ϩϕϧ આ໌
    4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ
    3&1&"5"#-&3&"% ڧ͍
    ಡΈऔΓର৅ͷσʔλ
    ΛৗʹಡΈऔΔ
    3&"%$0..*55&% ·͊·ڧ͍
    ֬ఆͨ͠࠷৽σʔλΛ
    ৗʹಡΈऔΔ
    3&"%
    6/$0..*55&%
    ऑ͍
    ଞͷॲཧʹΑͬͯߦΘ
    Ε͍ͯΔɺॻ͖͔͚ͷ
    σʔλ·ͰಡΈऔΔɻ
    

    View Slide

80. ϩοΫͷޭࡑ
    τϥϯβΫγϣϯ෼཭Ϩϕϧ
    ໊લ ෼཭Ϩϕϧ આ໌
    4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ
    3&1&"5"#-&3&"% ڧ͍
    ಡΈऔΓର৅ͷσʔλ
    ΛৗʹಡΈऔΔ
    3&"%$0..*55&% ·͊·ڧ͍
    ֬ఆͨ͠࠷৽σʔλΛ
    ৗʹಡΈऔΔ
    3&"%
    6/$0..*55&%
    ऑ͍
    ଞͷॲཧʹΑͬͯߦΘ
    Ε͍ͯΔɺॻ͖͔͚ͷ
    σʔλ·ͰಡΈऔΔɻ
    .Z42-ͷσϑΥϧτ͸͜͜
    

    View Slide

81. ϩοΫͷޭࡑ
    τϥϯβΫγϣϯ෼཭Ϩϕϧ
    ໊લ ෼཭Ϩϕϧ આ໌
    4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ
    3&1&"5"#-&3&"% ڧ͍
    ಡΈऔΓର৅ͷσʔλ
    ΛৗʹಡΈऔΔ
    3&"%$0..*55&% ·͊·ڧ͍
    ֬ఆͨ͠࠷৽σʔλΛ
    ৗʹಡΈऔΔ
    3&"%
    6/$0..*55&%
    ऑ͍
    ଞͷॲཧʹΑͬͯߦΘ
    Ε͍ͯΔɺॻ͖͔͚ͷ
    σʔλ·ͰಡΈऔΔɻ
    1PTUHSF42- 0SBDMF%# 42-4FSWFS
    ͷσϑΥϧτ͸͜͜
    

    View Slide

82. ϩοΫͷޭࡑ
    τϥϯβΫγϣϯ෼཭Ϩϕϧ
    ໊લ ෼཭Ϩϕϧ આ໌
    4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ
    3&1&"5"#-&3&"% ڧ͍
    ಡΈऔΓର৅ͷσʔλ
    ΛৗʹಡΈऔΔ
    3&"%$0..*55&% ·͊·ڧ͍
    ֬ఆͨ͠࠷৽σʔλΛ
    ৗʹಡΈऔΔ
    3&"%
    6/$0..*55&%
    ऑ͍
    ଞͷॲཧʹΑͬͯߦΘ
    Ε͍ͯΔɺॻ͖͔͚ͷ
    σʔλ·ͰಡΈऔΔɻ
    1PTUHSF42- 0SBDMF%# 42-4FSWFS
    ͷσϑΥϧτ͸͜͜
    ϑΝϯτϜϦʔυ΍μʔςΟϦʔυͳͲͷ࿩͸ࠓ೔͸͠·ͤΜ
    ʮ͑ʁͳʹͦΕʯͬͯਓ͸ࠓ͙͢άάοͯษڧͨ͠ํ͕͍͍Ͱ͢
    

    View Slide

83. ϩοΫͷޭࡑ
    ͳͥτϥϯβΫγϣϯ͕ඞཁ͔
    

    View Slide

84. ϩοΫͷޭࡑ
    Ϣʔβ" Ϣʔβ#
    ঎඼"
    ಉ࣌ʹߪೖ
    

    View Slide

85. ϩοΫͷޭࡑ
    Ϣʔβ" Ϣʔβ#
    ঎඼"
    ಉ࣌ʹߪೖ
    ࡏݿ͕࠷ޙͷݸͩͬͨͱ͖ɺ
    ͲͪΒΛ༏ઌ͢Δ͔ʁ
    

    View Slide

86. ϩοΫͷޭࡑ
    Ϣʔβ" Ϣʔβ#
    ঎඼"
    ઌʹΞΫηεͨ͠ͷͰ
    ঎඼ʹରͯ͠ϩοΫΛऔಘ
    ࡏݿ͕ແ͍ͷͰ
    ΤϥʔʹͳΔ
    

    View Slide

87. ϩοΫͷޭࡑ
    ฒྻॲཧͷσʔλͷෆ੔߹Λ๷͙
    

    View Slide

88. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    

    View Slide

89. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    

    View Slide

90. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    ྫ͑͹σΠϦʔͷདྷళϙΠϯτͷॲཧͱ͔
    ঎඼ߪೖ࣌ͷϙΠϯτݮࢉͷॲཧͱ͔
    

    View Slide

91. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    

    View Slide

92. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    ˓˓ݶఆ঎඼ͷࡏݿॲཧͱ͔
    Ұਓ͋ͨΓͷߪೖݶք਺ͷॲཧͱ͔
    

    View Slide

93. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    

    View Slide

94. ϩοΫͷޭࡑ
    ͋ͳͨͷॲཧ͸େৎ෉ʁ
    w ෳ਺ͷϒϥ΢βΛ։͍ͯಉ࣌ΞΫηε
    w όζͬͨ࣌ͳͲͷେྔͷಉ࣌ΞΫηε࣌
    w ฒྻॲཧΛॻ͍ͨ࣌
    Ұͭͷσʔλʹରͯ͠ෳ਺ͷαʔϏε͕ΞΫηε͢Δ࣌ͱ͔
    ߴ଎ԽͷͨΊʹඇಉظॲཧ΍ϚϧνεϨουॲཧΛ࡞ͬͨ࣌ͱ͔
    

    View Slide

95. ϩοΫͷޭࡑ
    ϩοΫͷ੹຿
    ࣄ࣮ʹج͍ͯ࣌ܥྻʹॲཧͯ͠
    σʔλΛద੾ʹकΔ
    

    View Slide

96. ϩοΫͷޭࡑ
    ͜͜·Ͱ͸ϩοΫͷޭࡑͷޭͷ෦෼
    

    View Slide

97. ϩοΫͷޭࡑ
    ϩοΫͷࡑ
    

    View Slide

98. ϩοΫͷޭࡑ
    ϩοΫʹΑΔੑೳ஗Ԇ
    

    View Slide

99. ϩοΫͷޭࡑ
    ϩοΫʹΑΔੑೳ஗Ԇ
    ˣ
    ϩοΫ଴ͪʹΑΔॲཧ஗Ԇ
    

    View Slide

100. ϩοΫͷޭࡑ
     Ϣʔβ" Ϣʔβ#
     ঎඼"
     ઌʹΞΫηεͨ͠ͷͰ
     ঎඼ʹରͯ͠ϩοΫΛऔಘ
     ։์଴ͪ
     ͜ͷαΠτ஗͍ͳ͊
     

     View Slide

101. ϩοΫͷޭࡑ
     Ϣʔβ" Ϣʔβ#
     ঎඼"
     ઌʹΞΫηεͨ͠ͷͰ
     ঎඼ʹରͯ͠ϩοΫΛऔಘ
     ։์଴ͪ
     ͜ͷαΠτ஗͍ͳ͊
     ྆ํͷϢʔβ͕ͦΕͧΕͷϩοΫͰ
     ଴ͨ͞Εͨ৔߹͸σοτϩοΫ
     

     View Slide

102. ϩοΫͷޭࡑ
     ओͳϩοΫͷछྨ
     w ഉଞ F9DMVEFE
     ϩοΫ
     w ڞ༗ 4IBSFE
     ϩοΫ
     

     View Slide

103. ϩοΫͷޭࡑ
     ओͳϩοΫͷछྨ
     w ഉଞ F9DMVEFE
     ϩοΫ
     w ڞ༗ 4IBSFE
     ϩοΫ
     ϩοΫର৅ʹରͯ͠ɺଞͷΞΫηεΛҰ੾ېࢭ͢Δ
     ଞͷΞΫηε͸ߋ৽ɾ࡟আɾࢀরશͯग़དྷͳ͍
     ॻ͖ࠐΈϩοΫͱݺ͹ΕΔࣄ΋͋Δ
     

     View Slide

104. ϩοΫͷޭࡑ
     ओͳϩοΫͷछྨ
     w ഉଞ F9DMVEFE
     ϩοΫ
     w ڞ༗ 4IBSFE
     ϩοΫ
     ϩοΫର৅ʹରͯ͠ɺࢀরҎ֎ͷॲཧΛېࢭ͢Δ
     ଞͷΞΫηε͸ࢀর 4&-&$5
     Λ͢Δ͜ͱ͕ग़དྷΔ
     ಡΈࠐΈϩοΫͱݺ͹ΕΔࣄ΋͋Δ
     

     View Slide

105. ϩοΫͷޭࡑ
     ϩοΫΛ஌Βͳ͍ॴͰऔ͍ͬͯΔ
     

     View Slide

106. ϩοΫͷޭࡑ
     ϩοΫΛ஌Βͳ͍ॴͰऔ͍ͬͯΔ
     ˣ
     ҉໧తϩοΫ
     

     View Slide

107. ϩοΫͷޭࡑ
     .Z42-ͷ৔߹
     

     View Slide

108. ϩοΫͷޭࡑ
     1PTUHSF42-ͷ৔߹
     

     View Slide

109. ϩοΫͷޭࡑ
     ϩοΫΛ஌Βͳ͍ॴͰऔ͍ͬͯΔ
     ˣ
     ҉໧తϩοΫ
     ಛʹڞ༗ϩοΫ͸සൟʹऔ͍ͬͯΔ
     

     View Slide

110. ϩοΫͷޭࡑ
     ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     

     View Slide

111. ϩοΫͷޭࡑ
     ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     ˣ
     ύϑΥʔϚϯεͱτϨʔυΦϑ
     

     View Slide

112. ϩοΫͷޭࡑ
     w ϩοΫ଴ͪͰॲཧ͕٧·Δ
     w ஗͍4&-&$5ʹΑͬͯߋ৽ॲཧ͕٧·Δ
     w ߋ৽ର৅͕ίϯϑϦΫτͯ͠଴ͨ͞ΕΔ
     w σοτϩοΫɺτϥϯβΫγϣϯ͸ࢮ͵
     

     View Slide

113. ϩοΫͷޭࡑ
     αʔϏεͷϝΠϯςʔϒϧ͸ةݥ
     w ଟ͘ͷࢀরͰར༻͍ͯ͠Δ
     w ߋ৽΋සൟʹ͋Δ
     w +0*/΍αϒΫΤϦͷର৅ʹͳ͍ͬͯΔ
     

     View Slide

114. ϩοΫͷޭࡑ
     ͦ΋ͦ΋ϩοΫͷॲཧ͸
     3%#ʹΑ͔ͬͯͳΓҧ͏
     

     View Slide

115. ϩοΫͷޭࡑ
     ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     

     View Slide

116. ϩοΫͷޭࡑ
     ϩοΫ͸σʔλΛकΔͨΊʹඞཁ
     ˣ
     ͔͠͠τϥϒϧͷ࣌ͷࠜ͸ਂ͍
     

     View Slide

117. ϩοΫͷޭࡑ
     ॲํᝦ
     

     View Slide

118. ϩοΫͷޭࡑ
     ॲํᝦ
     ϩοΫΛ஌Δ
     

     View Slide

119. ϩοΫͷޭࡑ
     ະ஌ͳΔ࢓૊Έ͸ා͍
     

     View Slide

120. ϩοΫͷޭࡑ
     ະ஌ͳΔ࢓૊Έ͸ා͍
     ˣ
     ͔ͬ͠Γͱཧղ͢Δࣄ
     

     View Slide

121. ϩοΫͷޭࡑ
     ϩοΫΛݟΔ
     

     View Slide

122. ϩοΫͷޭࡑ
     ϩοΫΛݟΔ
     ˣ
     ֤%#ʹ༻ҙ͞Ε͍ͯΔ࢓૊ΈΛ࢖͏
     

     View Slide

123. View Slide

124. ϦϑΝΫλϦϯά
     ៉ྷͳϦϑΝΫλϦϯά
     w ࢀরͱߋ৽ͷಡΈࠐΈઌΛ෼͚Δ
     w ߋ৽ͷϘτϧωοΫΛ෼͚Δ
     w σʔλઃܭΛݟ௚͢
     w ద੾ʹ*/%&9Λ׆༻͢Δ
     

     View Slide

125. ϦϑΝΫλϦϯά
     ҋͷਂ͍ϦϑΝΫλϦϯά
     w +0*/Λඇਖ਼نԽͰิ͏
     w ֎෦Ωʔ੍໿Λ֎͢
     w ͱΓ͋͑ͣΩϟογϡʹಥͬࠐΉ
     w ۃ౓ͷεέʔϧΞοϓ
     

     View Slide

126. ͋͐͡Μͩ
     ̍ɹࣗݾ঺հ
     ̎ɹ๨ΕڈΒΕͨόοΫΞοϓ
     ̏ɹ࢖ΘΕͳ੍͍໿
     ̐ɹϩοΫͷޭࡑ
     ̑ɹ·ͱΊ
     

     View Slide

127. ·ͱΊ
     

     View Slide

128. ·ͱΊ
     SQLΞϯνύλʔϯ͸ݫબ͞Εࣦͨഊू
     

     View Slide

129. ·ͱΊ
     SQLΞϯνύλʔϯ͸ݫબ͞Εࣦͨഊू
     ↓
     DBͷϊ΢ϋ΢͕٧·໊ͬͨஶ
     

     View Slide

130. ·ͱΊ
     Ұ౓࡞ͬͨ%#͸ফͤͳ͍
     

     View Slide

131. ·ͱΊ
     Ұ౓࡞ͬͨ%#͸ফͤͳ͍
     ˣ
     ઃܭ͕େࣄ
     

     View Slide

132. ·ͱΊ
     σʔλϕʔεͷࢮ͸αʔϏεͷࢮ
     

     View Slide

133. ·ͱΊ
     σʔλϕʔεͷࢮ͸αʔϏεͷࢮ
     ˣ
     ղܾͰ͖Δਓ͸ӳ༤
     

     View Slide

134. ·ͱΊ
     %#ͷ໰୊͸๨Εͨࠒʹ΍ͬͯ͘Δ
     

     View Slide

135. ·ͱΊ
     

     View Slide

136. ·ͱΊ
     αʔϏε΍νʔϜΛकΔ
     

     View Slide

137. ·ͱΊ
     αʔϏε΍νʔϜΛकΔ
     ˣ
     ͦͷͨΊʹֶͿ
     

     View Slide

138. ·ͱΊ
     ۪ऀ͸ܦݧʹֶͿ
     ݡऀ͸աڈʹֶͿ
     

     View Slide

139. ·ͱΊ
     पғͷܦݧஊ͔ΒֶͿ
     

     View Slide

140. ·ͱΊ
     पғͷܦݧஊ͔ΒֶͿ
     ˣ
     ੵۃతʹίϛϡχςΟΛར༻͢Δ
     

     View Slide

141. ࢀߟࢿྉ
     ɾQPTUHSFTRMKQ4MBDL νϟοτϧʔϜ
     
     IUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN
     ɾNZTRMDBTVBM4MBDL νϟοτϧʔϜ
     
     IUUQTNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN
     

     View Slide

142. ·ͱΊ
     3%#ͷ஌ࣝ͸ण໋͕௕͍
     

     View Slide

143. ·ͱΊ
     3%#ͷ஌ࣝ͸ण໋͕௕͍
     ˣ
     ֮͑Ε͹࢓ࣄͰ௕͍ؒ໾ʹཱͭ
     

     View Slide

144. ·ͱΊ
     ΑΓྑ͍ઃܭΛ
     Ұॹʹߟ͑ͯߦ͖·͠ΐ͏
     

     View Slide

145. ·ͱΊ
     3%#͸͍͍ͧɻ
     

     View Slide

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

     View Slide