MHAでデータベースの運用を楽にしよう！

Transcript

1. ٱถ୓അ(.01&1"#0JOD
   ϗε5FDI.5(
   .)"Ͱσʔλϕʔεӡ༻Λ
   ָʹ͠Α͏ʂ
   
   

   View Slide

2. ΠϯϑϥΤϯδχΞ
   ٱถ୓അ!UBLVNBLVNF
   ϗεςΟϯάࣄۀ෦ΠϯϑϥνʔϜ
   
   

   View Slide

3. .)"ͱ͸ʁ
   
   

   View Slide

4. .)"ͱ͸ʁ
   w.Z42-ΤΩεύʔτͱͯ͠ੈքతʹ΋༗໊ͳদ৴ՅൣࢯʹΑΔɺ
   .Z42-Ϛελʔͷ৑௕ԽΛߦ͏ͨΊͷ1FSM੡ͷιϑτ΢ΣΞɻ
   w਺ඵͷμ΢ϯλΠϜͰɺσʔλͷ੔߹ੑΛอͪͭͭɺϚελʔαʔ
   όͷϑΣΠϧΦʔόΛߦ͏ػೳΛ΋͍ͬͯΔɻ
   (JUIVC
   IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMNBOBHFS
   IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMOPEF
   
   

   View Slide

5. Զ͸σʔλϕʔεͷഒ
   ௼Γ͕޷͖ͩʂʂʂ
   
   

   View Slide

6. ͱ͍͏͜ͱͰ
   
   

   View Slide

7. Ϛελʔσʔλϕʔεͷো֐ʹΑͬͯ
   w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ
   w ͍ͭͰʹɺ௼ΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ
   
   

   View Slide

8. Ϛελʔσʔλϕʔεͷো֐ʹΑͬͯ
   w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ
   w ͍ͭͰʹɺ௼ΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ
   
   

   View Slide

9. ͱ͍͏ײ͡ͷϞνϕʔγϣϯͰ
   .)"ͷಋೖΛߦ͍·ͨ͠ʂ
   
   

   View Slide

10. ຊ೔ͷ಺༰
    લఏ஌ࣝ
    ɾϚελʔσʔλϕʔεͷো֐ରԠ͕ਏ͍͜ͱͷڞ༗
    ϝΠϯͷ͓͸ͳ͠
    ɾͦΕΛղܾ͢Δ.)"ͷಈ࡞ͷ࢓૊Έ
    ͓ΘΓ
    ɾࠓޙʹ͍ͭͯ
    

    View Slide

11. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    
    

    View Slide

12. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS TMBWF TMBWF
    "QQMJDBUJPO
    ॻ͖ࠐΈ
    ಉظ
    ಉظ
    ௨ৗ࣌
    
    

    View Slide

13. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS TMBWF TMBWF
    "QQMJDBUJPO
    ॻ͖ࠐΈ
    େ੾ͳߋ৽ॲཧ͕ࢭ·Δ
    ো֐ൃੜʂ
    ো֐ൃੜ
    
    

    View Slide

14. ͔͜͜Β෮چ࡞ۀ͕࢝·Δ
    
    

    View Slide

15. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS TMBWF TMBWF
    "QQMJDBUJPO
    σʔλ͕൪৽͍͠αʔόΛબͿ
    ৽Ϛελʔબఆ
    
    

    View Slide

16. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS NBTUFS TMBWF
    "QQMJDBUJPO
    σʔλͷ੔߹ੑΛ߹ΘͤΔ
    ৽NBTUFS TMBWFؒͷ
    σʔλͷ੔߹ੑΛ߹ΘͤΔ
    
    σʔλྔʹԠ͕͔͔ͯ࣌ؒ͡Δ࡞ۀ
    

    View Slide

17. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS NBTUFS TMBWF
    "QQMJDBUJPO
    εϨʔϒಉظΛ։࢝
    ಉظ
    
    

    View Slide

18. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS NBTUFS TMBWF
    "QQMJDBUJPO
    ΞϓϦέʔγϣϯ͸
    ॻ͖ࠐΈΛ࠶։
    ॻ͖ࠐΈ࠶։
    ಉظ
    
    

    View Slide

19. ͜ͷҰ࿈ͷ࡞ۀΛٸ͍Ͱ
    ߦΘͳ͚Ε͹ͳΒͳ͍
    
    

    View Slide

20. େมͰ͢Ͷʜ
    
    

    View Slide

21. खಈ෮چͷ໰୊఺
    wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚Ε͹ͳΒͳ͍
    wো֐ݕ஌ˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝
    wλΠϜϥά͕ൃੜ͢Δɻͦͷؒ͸αʔϏεஅɻ
    wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ
    w໷ؒͳͲʹى͖Δ͜ͱ΋͋ΔͷͰ୲౰ऀ͕ർฐ͢Δ
    
    

    View Slide

22. खಈ෮چͷ໰୊఺
    wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚Ε͹ͳΒͳ͍
    wো֐ݕ஌ˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝
    wλΠϜϥά͕ൃੜ͢Δɻͦͷؒ͸αʔϏεஅɻ
    wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ
    w໷ؒͳͲʹى͖Δ͜ͱ΋͋ΔͷͰ୲౰ऀ͕ർฐ͢Δ
    w୲౰ऀ͕௼ΓΛָ͠ΜͰ͍Δ͔΋͠Εͳ͍ɻ
    
    

    View Slide

23. ͦΕΛղܾ͢Δҝʹ.)"Λಋೖͨ͠ʂ
    
    

    View Slide

24. .)"͸ো֐ݕ஌͔Β෮چ·ͰͷҰ࿈ͷ
    ྲྀΕΛࣗಈͰߦͬͯ͘ΕΔιϑτ΢ΣΞɻ
    
    

    View Slide

25. ຊ೔͸.)"ͷಈ࡞ͷ࢓૊Έʹ͍ͭͯ
    આ໌͍ͨ͠ͱࢥ͍·͢ʂ
    
    

    View Slide

26. ߏ੒
    NBTUFS TMBWF TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ϔϧενΣοΫ
    ࠷௿ϊʔυ
    
    Ϛελʔʹো֐͕ى͖Ε͹ࣗಈͰ
    ผͷαʔόʹ੾Γସ͑Δ
    

    View Slide

27. Ҏ߱ͷઆ໌
    .)"ͷओͳҎԼͷػೳʹ͍ͭͯॱʹઆ໌͠·͢ɻ
    ɾϔϧενΣοΫ
    ɾσʔλͷ੔߹ੑͷΩʔϓ
    ɾϑΣΠϧΦʔόʔ
    
    

    View Slide

28. ϔϧενΣοΫ
    ɾNBTUFSσʔλϕʔε͕ࢀর΋͘͠͸ॻ͖ࠐΈͰ͖Δঢ়ଶͰ͋Δ͔
    ɹΛνΣοΫ͢Δɻ NIBNBOBHFSNIBOPEF<.BTUFS>
    
    
    

    View Slide

29. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH ʢ.BTUFS͔ΒૹΒΕ͖ͯͨσʔλͰσʔλϕʔεʹॻ͖ࠐ·Ε͍ͯͳ͍΋ͷʣ
    
    

    View Slide

30. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    Ϛελʔσʔλϕʔεʹো֐ൃੜʂ
    
    

    View Slide

31. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    ൪σʔλ͕.BTUFSʹ͍ۙαʔόΛ
    ৽Ϛελʔʹબఆ
    
    

    View Slide

32. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    
    ৽Ϛελʔʹબఆ
    

    View Slide

33. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    Ͳͷ4MBWFʹ΋సૹ͞Ε͍ͯͳ͍σʔλ͸ϩετ
    
    

    View Slide

34. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS ৽ϚελʔͷSFMBZMPH͕શͯద༻͞ΕΔ·Ͱ
    NIBNBOBHFS͸଴ػ
    
    

    View Slide

35. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS
    4MBWFʹ଍Γͳ͍σʔλΛ4$1Ͱసૹ͢Δ
    
    

    View Slide

36. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS
    SFMBZMPHΛద༻
    
    

    View Slide

37. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS
    σʔλͷ੔߹ੑ͕อͨΕΔ
    
    

    View Slide

38. ϑΣΠϧΦʔόʔ
    NBTUFS TMBWF TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ো֐ൃੜ
    ݕ஌ʂ
    
    "QQT
    

    View Slide

39. ϑΣΠϧΦʔόʔ
    NBTUFS TMBWF TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    Ϛελʔબఆ
    
    "QQT
    

    View Slide

40. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ੔߹ੑͷΩʔϓ
    
    "QQT
    

    View Slide

41. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ։࢝
    ಉظ։࢝
    
    "QQT
    

    View Slide

42. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ։࢝
    ಉظ։࢝
    
    "QQT
    ⾨͜Ε͚ͩͰ͸ΞϓϦέʔγϣϯ͕ݹ͍ϚελʔΛࢀর͍ͯ͠Δঢ়ଶ
    

    View Slide

43. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ
    ಉظ
    ϑΣΠϧΦʔόʔ࣌ʹ.)"ͷػೳͰ೚ҙͷ
    εΫϦϓτΛ࣮ߦͰ͖Δʂ
    
    "QQT
    

    View Slide

44. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ
    ಉظ
    όʔνϟϧ*1
    όʔνϟϧ*1ΞυϨεΛ༧Ί෇༩͓͖ͯ͠ɺεΫϦϓτͰ৽ϚελʔʹҠಈͤͯ͞
    ΞϓϦέʔγϣϯ͕ϚελʔͷࢀরઌΛม͑ͳͯ͘ྑ͍Α͏ʹ͢Δɻ
    
    "QQT
    

    View Slide

45. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ
    ಉظ
    όʔνϟϧ*1
    
    "QQT
    ⾨ΞϓϦέʔγϣϯ͸৽͍͠ϚελʔΛࣗಈతʹࢀর͢Δ
    

    View Slide

46. ͦͷଞͷػೳ
    ɾࣗಈϑΣΠϧΦʔό࣌ͷ௨஌ػೳ
    ɾखಈͰͷϚελʔ੾ସ͑ػೳ
    ɹˠσʔλϕʔεͷϝϯςφϯεָ͕ʹͳΔʂ
    ɾεϨʔϒຖʹϚελʔঢ֨ީิͷઃఆ͕Ͱ͖Δɻ
    ɹˠόοΫΞοϓ༻్ͷαʔό͸Ϛελʔʹঢ֨ͤ͞ͳ͍
    ɹɹͳͲͷӡ༻͕Մೳɻ
    
    

    View Slide

47. .)"͸طଘͷ.Z42-ͷఀࢭΛ
    ൐Θͣʹಋೖ͢Δ͜ͱ͕Ͱ͖ΔͷͰ
    ඇৗʹಋೖͷෑډ͕௿͍Ͱ͢ʂ
    
    

    View Slide

48. ୆ͷNIBNBOBHFSͰෳ਺ͷ
    γεςϜΛ؅ཧ͢Δ͜ͱ͕Ͱ͖·͢ʂ
    
    

    View Slide

49. ʲࢀߟʳ.)"Λಋೖ͢ΔͨΊͷલఏ৚݅
    w֤ϊʔυؒͰͷ44)ެ։伴ೝূ͕Ͱ͖Δ͜ͱ
    w.Z42-Ҏ߱ͷΈαϙʔτ
    wϚελʔঢ֨ީิͷαʔόͰMPHCJO͕FOBCMFʹͳͬͯΔ͜ͱ
    wSFMBZ@MPH@QVSHFΛແޮʹ͓ͯ͘͠ඞཁ
    wཧ༝͸ɺϑΣΠϧΦʔό࣌ʹ࠷৽ͷ4MBWFͷSFMBZ@MPHΛݹ͍4MBWFʹసૹ͠
    ͯ੔߹ੑΛ୲อ͢ΔͨΊɻ
    w Ϛελʔঢ֨ީิαʔόʹϨϓϦέʔγϣϯ༻Ϣʔβ͕ଘࡏ͢Δ͜ͱ
    w εςʔτϝϯτϕʔεͷϨϓϦέʔγϣϯͰ͸-0"%%"5"*/'*-&Λ࢖༻ͯ͠͸
    ͍͚ͳ͍
    
    

    View Slide

50. ϖύϘͰ͸ɺ͓ͬ͘Μ͞Μ !IGN
    ͕
    EBZT"MCVNʹઌߦಋೖ͍ͯͨ͠ͷͰ
    ஌ݟΛڞ༗௖͖ɺඇৗʹָʹಋೖͰ͖·ͨ͠ʂ
    ʢ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂʣ
    
    

    View Slide

51. ࠓޙʹ͍ͭͯ
    ɾ·ͩ.)"͕ಋೖ͞Ε͍ͯͳ͍γεςϜ͕ෳ਺͋ΔͷͰɺ
    ɹ࣮੷ΛੵΈͭͭਵ࣌ಋೖΛ޿͍͖͍͛ͯͨͱࢥ͍·͢ɻ
    
    

    View Slide

52. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ
    
    

    View Slide