つらくないマルチテナンシーを求めて: 全て見せます！ SmartHR データベース移行プロジェクトの裏側 / builderscon 2018

Transcript

1. ͭΒ͘ͳ͍ϚϧνςφϯγʔΛٻΊͯ
   શͯݟͤ·͢ʂ
   4NBSU)3σʔλϕʔεҠߦ
   ϓϩδΣΫτͷཪଆ
   ΀ΓΜ͍ͨ
   ιϑτ΢ΣΞΤϯδχΞ
   CVJMEFSTDPO
   4BU
   
   

   View Slide

2. ࠓ೔͸Έͳ͞Μ͕େ޷͖ͳ
   σʔλϕʔεҠߦͷ࿩Ͱ͢ʂ
   

   View Slide

3. ͜͜Ͱ
   ϓϩδΣΫτ։࢝௚લͷ
   ࢲͷπΠʔτΛݟ·͠ΐ͏
   

   View Slide

4. View Slide

5. ΤϯδχΞਓʹฉ͖·ͨ͠
   ͋ͳͨͷਐḿΛѱԽͤ͞ΔݪҼ͸ʁ
   

   View Slide

6. πΠολʔΛ΍Ίͯ
   ѹ౗తਐḿ
   

   View Slide

7. Ұํઌिͷ
   ࢲͷπΠʔτΛݟ·͠ΐ͏
   

   View Slide

8. View Slide

9. ࠶ͼπΠολʔΛ΍Ίͯ
   ѹ౗తਐḿ
   ͔ͱࢥ͍͖΍ʜʜ
   

   View Slide

10. View Slide

11. ̍िؒμ΢ϯ͠·͕ͨ͠
    ͳΜͱ͔ؒʹ߹͍·ͨ͠
    

    View Slide

12. ࣗݾ঺հ
    )/΀ΓΜ͍ͨ
    5XJUUFS!TQBDFQSP@CF
    (JU)VC!QVSJOUBJ
    ɾ4NBSU)3ͷιϑτ΢ΣΞΤϯδχΞ ೥݄ೖࣾ
    
    ɾࠓճͷ%#ҠߦϓϩδΣΫτΛϦʔυͨ͠
    ɾಛஈ3%#.4ʹৄ͍͠Θ͚Ͱ͸ͳ͍
    

    View Slide

13. ԿނσʔλϕʔεҠߦΛʁ
    

    View Slide

14. σϓϩΠʹֻ͕͔࣌ؒΓ͗͢
    

    View Slide

15. σϓϩΠʹֻ͕͔࣌ؒΓ͗͢
    

    View Slide

16. σϓϩΠʹֻ͕͔࣌ؒΓ͗͢
    ຊ౰ʹ͔͔࣌ؒΓ·ͨ͠
    

    View Slide

17. ͳͥ͜Μͳ͜ͱʹ
    ͳͬͯ͠·ͬͨΜͩ
    

    View Slide

18. ཧ༝͸εΩʔϚมߋ
    ςʔϒϧ΍ΧϥϜͷ௥Ճɾมߋɾ࡟আFUD
    
    

    View Slide

19. Ͱ΋͔͔࣌ؒΔ
    εΩʔϚมߋͳΜͯ
    ฉ͍ͨ͜ͱ͕ͳ͍
    

    View Slide

20. Ͳ͏ͯ͜͠Μͳ͜ͱʹʁ
    ҰମͲ͏΍ͬͯղܾΛʜ
    

    View Slide

21. ΞδΣϯμ
    w Ϛϧνςφϯτͱ͸
    w 4NBSU)3ͷϚϧνςφϯτ
    w BQBSUNFOUͷམͱ݀͠
    w 4NBSU)3Ϛϧνςφϯτ೥ද
    w $JUVT$MPVEҠߦϓϩδΣΫτ
    w σʔλҠߦ͋Ε͜Ε
    w ৼΓฦΓ
    

    View Slide

22. Ϛϧνςφϯτͱ͸
    

    View Slide

23. Ϛϧνςφϯτͱ͸
    ϚϧνςφϯτʢNVMUJUFOBOUʣ
    4BB4 αʔε
    ͳͲͷαʔϏεʹ͓͍ͯɺෳ਺ͷސ٬اۀ͕
    ҰͭͷγεςϜΛڞ༗͢Δํࣜɻγϯάϧςφϯτʹൺ΂ɺ
    ௿ίετͰར༻Ͱ͖ΔɻԾ૝Խٕज़ͱαʔόʔͷੑೳͷɹ
    ޲্ʹΑͬͯΫϥ΢υίϯϐϡʔςΟϯά͕޿͘ීٴ͠ɺ
    ΑΓҰൠతʹͳͬͨɻϚϧνςφϯγʔɻ
    Ҿ༻ݩϚϧνςφϯτͱ͸ίτόϯΫ

    IUUQTLPUPCBOLKQXPSEϚϧνςφϯτ
    

    View Slide

24. Ϛϧνςφϯτͱ͸
    ࡶʹઆ໌ͯ͠͠·͏ͱ
    اۀ͝ͱʹاۀઐ༻ͷ8FC%#αʔόΛ༻ҙ͢Δ
    ɹˠγϯάϧςφϯτ
    ෳ਺ͷاۀ͕ಉ͡8FC%#αʔόΛڞ༻͢Δ
    ʢར༻اۀ͔Β͸ઐ༻ͷ؀ڥͰ͋ΔΑ͏ʹݟ͑Δʣ
    ɹˠϚϧνςφϯτ
    

    View Slide

25. Ϛϧνςφϯτͱ͸
    ͭ·Δͱ͜Ζར༻ऀؒͰܭࢉࢿݯΛڞ༗ͭͭ͠
    σʔλ ੈք؍
    ͷ෼཭Λ࣮ݱ͠ͳ͚Ε͹ͳΒͳ͍
    Ҿ༻ݩ.VMUJUFOBODZ"SDIJUFDUVSFc+FTÙT(JM)FSOÂOEF[
    IUUQKFTVTHJMIFSOBOEF[DPNNVMUJUFOBODZBSDIJUFDUVSF
    

    View Slide

26. Ϛϧνςφϯτͱ͸
    2ͳͥϚϧνςφϯτΛ΍Δͷʁ
    "Πϯϑϥʹ͓͕͔͔ۚΒͳ͍͔ΒͰ͢
    ͕ࣾαΠϯΞοϓͨ͠ͱ͖
    ηοτͷ8FC%#αʔόʹಉډͤ͞Δ
    ɹɹɹɹɹɹɹ
    ηοτͷ8FC%#αʔόΛݸผʹ༻ҙ͢Δ
    ˠ͓ۚ΋͔͔Δ͠ɺͲ͏΍ͬͯӡ༻͢Δͷʁ
    

    View Slide

27. 4NBSU)3͸
    Ϛϧνςφϯτ
    ##4BB4Ͱ͢
    

    View Slide

28. 4NBSU)3ͷ
    Ϛϧνςφϯτ
    

    View Slide

29. Ϛϧνςφϯγʔ޲͚HFN
    4NBSU)3͸3VCZPO3BJMTͰͰ͖͍ͯ·͢
    

    View Slide

30. Ϛϧνςφϯγʔ޲͚HFN
    3VCZPO3BJMTͱ͍͑͹๛෋ͳHFN QBDLBHF
    ͨͪ
    lϚϧνςφϯτzͰݕࡧ
    
    

    View Slide

31. Ϛϧνςφϯγʔ޲͚HFN
    4NBSU)3Ͱ࠾༻͞Εͨͷ͸BQBSUNFOU
    

    View Slide

32. Ϛϧνςφϯγʔ޲͚HFN
    (JU)VC4UBS΋ͨ͘͞Μ
    ϚϧνςφϯτHFNτοϓμ΢ϯϩʔυ਺
    ༷ʑͳΦεεϝهࣄ
    

    View Slide

33. ͍͚ͦ͏
    

    View Slide

34. BQBSUNFOUͷڍಈ
    BQBSUNFOU͸ςφϯτ͕࡞੒͞ΕΔͱ
    ɹɹɹɹɹʢʹར༻اۀͷαΠϯΞοϓʣ
    .Z42-ͳΒ$3&"5&%"5"#"4&
    1PTUHSF42-ͳΒ$3&"5&4$)&."͕࣮ߦ͞Ε
    ੜ੒͞Εͨର৅ʹ޲͚ͯεΩʔϚఆٛΛద༻
    TDIFNBSCΛಡΜͰ$3&"5&5"#-&Λ࣮ߦ
    ͠·͢
    

    View Slide

35. BQBSUNFOUͷڍಈ
    ςφϯτ୯ҐͰσʔλϕʔε͕࡞੒͞ΕΔͷͰ
    ແ഑ྀʹ$SFXGJSTU 4&-&$5'30.DSFXT-*.*5
    
    ͱ͔΍ͬͯ΋ଞςφϯτͷσʔλ͕ࠞ͟Βͳ͍☺
    ΋͠BQBSUNFOUΛ࢖Θͳ͍ͳΒ
    ಉ͡ςʔϒϧʹผςφϯτͷϨίʔυ͕ࠞ͟ΔͳΒ
    $SFXXIFSF UFOBOU@JE
    GJSTUͬͯຖճࢦఆ͠ͳ͍ͱ
    4&-&$5'30.DSFXT
    8)&3&AUFOBOU@JEA-*.*5
    
    

    View Slide

36. BQBSUNFOUͷڍಈ
    ҰํςφϯτΛ·͍ͨͰऔΓѻ͍͍ͨ֓೦΋͋Δ
    ྫαϒυϝΠϯ՝ۚςφϯτͦͷ΋ͷFUD
    ςφϯτؒͰڞ༗͍ͨ͠Ϩίʔυ͸ύϒϦοΫ%#
    ͱ͍͏ಛผͳ%#্ʹ؅ཧͰ͖ΔΑ͏ࢦఆ͕Մೳ
    ٯʹڞ༗ͨ͘͠ͳ͍ςφϯτผͷϨίʔυ͸
    ઌఔ࡞੒͞ΕͨςφϯτຖͷϓϥΠϕʔτ%#Ͱ؅ཧ
    

    View Slide

37. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    

    View Slide

38. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    )551ϦΫΤετΛड͚Δ
    

    View Slide

39. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    %#ίωΫγϣϯΛׂΓ౰ͯΒΕΔ
    <ύϒϦοΫ%#>
    

    View Slide

40. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    ϦΫΤετϔομʔͷ)PTU͔ΒαϒυϝΠϯΛநग़
    )PTUFYBNQMFTNBSUISKQ͔ΒFYBNQMFΛऔΓग़͢
    <ύϒϦοΫ%#>
    

    View Slide

41. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    αϒυϝΠϯFYBNQMFʹରԠ͢Δ
    ɹςφϯτͷଘࡏΛύϒϦοΫ%#্Ͱ֬ೝ͢Δ

    4&-&$5'30.AUFOBOUTA
    8)&3&ATVCEPNBJOAFYBNQMF
    
    <ύϒϦοΫ%#>
    

    View Slide

42. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    αϒυϝΠϯFYBNQMFʹରԠ͢ΔϨίʔυΛฦ͢
    <ύϒϦοΫ%#>
    

    View Slide

43. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    Ϩίʔυʹσʔλϕʔεؚ໊͕·Ε͍ͯΔͷͰ
    ɹݱࡏ௫ΜͰ͍Δ%#઀ଓͷσʔλϕʔεΛ੾Γସ͑Δ

    VTFQSPEVDUJPO@FYBNQMF
    
    <FYBNQMF>
    

    View Slide

44. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    BQBSUNFOU͸ϦΫΤετΛॲཧ͢Δؒ
    ੾Γସ͑தͷςφϯτΛ͓֮͑ͯ͘

    "QBSUNFOU5FOBOUDVSSFOUFYBNQMF
    
    <FYBNQMF>
    <FYBNQMF>
    

    View Slide

45. <FYBNQMF>
    BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    FY3FEJTͱ4͸੾Γସ͑தͷςφϯτ*%Λ
    ͦΕͧΕOBNFTQBDFσΟϨΫτϦύεʹར༻͠෼཭
    <FYBNQMF>
    

    View Slide

46. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    ϦΫΤετΛॲཧ͢Δ
    ϓϥΠϕʔτ%#্ͰϨίʔυૢ࡞
    
    <FYBNQMF>
    <FYBNQMF>
    

    View Slide

47. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    )551ϨεϙϯεΛฦ͢
    <FYBNQMF>
    <FYBNQMF>
    

    View Slide

48. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    ݱࡏ௫ΜͰ͍Δ%#ίωΫγϣϯͷ
    ࢀরઌΛݩʹ໭͢

    VTFTNBSUIS@QSPEVDUJPO
    
    <ύϒϦοΫ%#>
    

    View Slide

49. BQBSUNFOUͷڍಈ
    4NBSU)3ͷϚϧνςφϯγʔ ೥౰࣌
    
    Amazon
    RDS
    Amazon
    ElastiCache
    AWS Elastic
    Beanstalk
    Amazon
    S3
    BQBSUNFOU
    %#ίωΫγϣϯΛฦ٫ऴྃ͠
    ࣍ͷ)551ϦΫΤετΛ଴ͭʢऴʣ
    

    View Slide

50. BQBSUNFOUศར͡ΌΜ
    ʢศར͡ΌΜʣ
    

    View Slide

51. BQBSUNFOUͷམͱ݀͠
    

    View Slide

52. BQBSUNFOUͷམͱ݀͠
    ࣌͸ḪΓ೥݄
    

    View Slide

53. BQBSUNFOUͷམͱ݀͠
    ΦοBQBSUNFOUHFNʹ͍ͭͯͷηογϣϯͰ͢Ͷ
    

    View Slide

54. BQBSUNFOUͷམͱ݀͠
    Ҿ༻ݩ1SPHSBNc3VCZ9&MJYJS$POG5BJXBO
    IUUQTSVCZDPOGUXQSPHSBNMJBOHDIJUTFOH
    

    View Slide

55. BQBSUNFOUͷམͱ݀͠
    Ҿ༻ݩ1SPHSBNc3VCZ9&MJYJS$POG5BJXBO
    IUUQTSVCZDPOGUXQSPHSBNMJBOHDIJUTFOH
    /&7&3VTFBQBSUNFOUHFN
    POBMBSHFTDBMFQSPKFDU
    
    

    View Slide

56. BQBSUNFOUͷམͱ݀͠
    Ҿ༻ݩ1SPHSBNc3VCZ9&MJYJS$POG5BJXBO
    IUUQTSVCZDPOGUXQSPHSBNMJBOHDIJUTFOH
    BQBSUNFOUΛ࢖͏ͳ
    େن໛ϓϩδΣΫτͰ
    
    

    View Slide

57. 8):
    

    View Slide

58. BQBSUNFOUͷམͱ݀͠
    ɾ%#ϚΠάϨʔγϣϯʹ͔͔Δ࣌ؒͷ૿େ
    ɾσʔλϕʔεͷىಈʹ͔͔Δ࣌ؒͷ૿େ
    ɾ"DUJWF3FDPSEͷΩϟογϡͰϝϞϦυΧ৯͍
    ɾϑΝΠϧγεςϜͷJOPEF্ݶ
    ɹ˺Πϯελϯεͷςʔϒϧ਺ͷ্ݶ
    Ҿ༻ݩ3VCZ&MJYJS$POG5BJXBO/FWFSVTF"QBSUNFOUHFNPOBMBSHFTDBMFQSPKFDUCZ-JBOH$IJ5TFOH
    IUUQTXXXZPVUVCFDPNXBUDI W%1($-UNT
    

    View Slide

59. View Slide

60. ϚΠάϨʔγϣϯ໰୊
    σʔλϕʔε͕෼཭͞Ε͍ͯͯศར
    ˠͭ·ΓϚΠάϨʔγϣϯ΋෼཭
    ˠςφϯτΛ๊͍͑ͯͨΒ
    ϚΠάϨʔγϣϯճ࣮ߦ
    ˠ ςφϯτͳΒʜʜ
    ˠ ςφϯτͳΒʜʜ
    ˠ ςφϯτͳΒʜʜ
    

    View Slide

61. ϚΠάϨʔγϣϯ໰୊
    ςφϯτ͋ͨΓͷϚΠάϨʔγϣϯʹඵ
    ςφϯτˠඵ
    ςφϯτˠඵ
    ςφϯτˠ෼
    ςφϯτˠ࣌ؒ
    

    View Slide

62. ϚΠάϨʔγϣϯ໰୊
    ςφϯτ͋ͨΓͷϚΠάϨʔγϣϯʹඵ
    ςφϯτˠඵ
    ςφϯτˠඵ
    ςφϯτˠ෼
    ςφϯτˠ࣌ؒ
    

    View Slide

63. ϚΠάϨʔγϣϯ໰୊
    ςφϯτ͋ͨΓͷϚΠάϨʔγϣϯʹඵ
    ςφϯτˠ෼
    ςφϯτˠ෼
    ςφϯτˠ࣌ؒ
    ςφϯτˠϱ݄
    

    View Slide

64. ϚΠάϨʔγϣϯ໰୊
    

    View Slide

65. %#ϒʔτλΠϜ໰୊
    ςφϯτ਺͕૿͑ΔʹͭΕ૿͑Δॾʑͷ࣌ؒʜʜ
    

    View Slide

66. %#ϒʔτλΠϜ໰୊
    

    View Slide

67. %#ϒʔτλΠϜ໰୊
    

    View Slide

68. ͜ͷ··Ͱ͸·͍ͣ
    ͳͥͳΒʜʜ
    

    View Slide

69. 4NBSU)3ͱ͍͏ΞϓϦͷಛੑ
    શը໘ͷׂ͕̔ϑΥʔϜ
    

    View Slide

70. 4NBSU)3ͱ͍͏ΞϓϦͷಛੑ
    ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏
    

    View Slide

71. 4NBSU)3ͱ͍͏ΞϓϦͷಛੑ
    ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏
    
    

    View Slide

72. ࣮ࡍिʙϖʔεͰ
    ϚΠάϨʔγϣϯͯͨ͠
    

    View Slide

73. ͦͷଞॾʑ͸ׂѪ
    ࢲୡʹର͢ΔӨڹ͸ܰඍͩͬͨ
    
    

    View Slide

74. ͜ͷ··Ͱ͸·͍ͣʜʜ
    

    View Slide

75. ౰વࢦΛ͘Θ͑ͯ
    ͨͩݟक͍ͬͯͨ
    Θ͚Ͱ͸͋Γ·ͤΜ
    

    View Slide

76. 4NBSU)3
    Ϛϧνςφϯτ೥ද
    

    View Slide

77. 4NBSU)3Ϛϧνςφϯτ೥ද
    ܧଓར༻཰
    
    
    
    
    
    
    
    
    ࣾ
    ར༻اۀ਺
    

    View Slide

78. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    

    View Slide

79. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    4NBSU)3ެ։
    ೥݄
    
    

    View Slide

80. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    4NBSU)3ެ։
    ೥݄
    
    JOJUJBMDPNNJU
    ೥݄
    
    

    View Slide

81. JOJUJBMDPNNJU
    

    View Slide

82. BQBSUNFOU͕(FNGJMFʹ௥Ճ͞Εͨͷ͸िؒޙ
    JOJUJBMDPNNJU
    

    View Slide

83. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    4NBSU)3ެ։
    ೥݄
    
    JOJUJBMDPNNJU
    ೥݄
    
    ฒྻNJHSBUF
    ࢼ࡞൛
    

    View Slide

84. ϚΠάϨʔγϣϯʹ
    ͕͔͔࣌ؒΔͳΒ
    ฒྻԽ͢Ε͹͍͍͡ΌΜ
    

    View Slide

85. ϚΠάϨʔγϣϯฒྻԽ
    

    View Slide

86. ϚΠάϨʔγϣϯฒྻԽ
    ςφϯτ͋ͨΓඵ͔͔ΔϚΠάϨʔγϣϯ͕
    ςφϯτ͋Δͱ͖ʹ ඵʹͳΔͳΒ
    ฒྻͰϚΠάϨʔγϣϯ͢Ε͹ඵʹͳΔΑͶ
    

    View Slide

87. ͜ͷ࣌͸·ͩ
    Կ΋஌Βͳ͔ͬͨ
    

    View Slide

88. ͔͜͠͠ͷ࣌఺Ͱ͸
    ࣮ઓ౤ೖͤͣ
    

    View Slide

89. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    4NBSU)3ެ։
    ೥݄
    
    JOJUJBMDPNNJU
    ೥݄
    
    ฒྻNJHSBUF
    ࢼ࡞൛
    σϓϩΠ໰୊͕
    ঃʑʹݦࡏԽ
    

    View Slide

90. σϓϩΠ໰୊͕ݦࡏԽͩ͢͠
    

    View Slide

91. σϓϩΠ໰୊͕ݦࡏԽͩ͢͠
    8FCίϯςφͷσϓϩΠ͸ऴΘͬͯΔͷʹ
    ϚΠάϨʔγϣϯ͸ऴΘͬͯͳ͍ʂ
    ϚΠάϨʔγϣϯ
    ׬ྃςφϯτ܈
    ϚΠάϨʔγϣϯ
    ະ׬ྃςφϯτ܈
    ୅ද
    8FCίϯςφ
    ϚΠάϨʔγϣϯ࣮ߦத
    $3&"5&5"#-&DPNNFOUT
    ৽͍͠
    8FCίϯςφ
    DPNNFOUT
    ςʔϒϧ͋Δ
    ৽͍͠
    8FCίϯςφ
    DPNNFOUT
    ςʔϒϧͳ͍
    

    View Slide

92. Τϥʔ
    

    View Slide

93. ͱ͸͍͑
    ςφϯτ਺΋গͳΊͰ
    ਺෼ఔ౓Ͱղফͯͨ͠
    

    View Slide

94. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    4NBSU)3ެ։
    ೥݄
    
    JOJUJBMDPNNJU
    ೥݄
    
    ฒྻNJHSBUF
    ࢼ࡞൛
    σϓϩΠ໰୊͕
    ঃʑʹݦࡏԽ
    QVSJOUBJೖࣾ
    

    View Slide

95. ͸͍
    

    View Slide

96. 4NBSU)3Ϛϧνςφϯτ೥ද
    
    
    
    
    
    
    
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ೥
    2
    ར༻اۀ਺
    4NBSU)3ެ։
    ೥݄
    
    JOJUJBMDPNNJU
    ೥݄
    
    ฒྻNJHSBUF
    ࢼ࡞൛
    σϓϩΠ໰୊͕
    ঃʑʹݦࡏԽ
    QVSJOUBJೖࣾ
    ଟஈσϓϩΠͷಋೖ
    

    View Slide

97. ଟஈσϓϩΠͷಋೖ
    

    View Slide

98. ଟஈσϓϩΠͷಋೖ
    

    View Slide

99. ଟஈσϓϩΠͷಋೖ
    ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ
    ׬ྃޙʹXFC؀ڥʹσϓϩΠ
    ϚΠάϨʔγϣϯ
    ׬ྃςφϯτ܈
    ϚΠάϨʔγϣϯ
    ະ׬ྃςφϯτ܈
    NJHSBUJPO
    ίϯςφ
    ϚΠάϨʔγϣϯ࣮ߦத
    $3&"5&5"#-&DPNNFOUT
    8FCίϯςφ
    DPNNFOUTͷ
    ଘࡏΛ஌Βͳ͍
    8FCίϯςφ
    DPNNFOUTͷ
    ଘࡏΛ஌Βͳ͍
    

    View Slide

100. ଟஈσϓϩΠͷಋೖ
     ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ
     ׬ྃޙʹXFC؀ڥʹσϓϩΠ
     ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     ϚΠάϨʔγϣϯ׬ྃ
     $3&"5&5"#-&DPNNFOUT
     8FCίϯςφ
     DPNNFOUTͷ
     ଘࡏΛ஌Βͳ͍
     8FCίϯςφ
     DPNNFOUTͷ
     ଘࡏΛ஌Βͳ͍
     

     View Slide

101. ଟஈσϓϩΠͷಋೖ
     ઌʹNJHSBUJPO؀ڥͰϚΠάϨʔγϣϯ࣮ߦ
     ׬ྃޙʹXFC؀ڥʹσϓϩΠ
     ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧ͋Δ
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧ͋Δ
     

     View Slide

102. View Slide

103. ͔ͯ࣌ؒ͠͠͸
     ͔͔ΔΑ͏ʹͳͬͨ
     

     View Slide

104. ฒྻ࣮ߦͷເ
     

     View Slide

105. ฒྻ࣮ߦͷເ
     

     View Slide

106. ฒྻ࣮ߦͷເ
     

     View Slide

107. 4NBSU)3Ϛϧνςφϯτ೥ද
     
     
     
     
     
     
     
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ར༻اۀ਺
     4NBSU)3ެ։
     ೥݄
     
     JOJUJBMDPNNJU
     ೥݄
     
     ฒྻNJHSBUF
     ࢼ࡞൛
     σϓϩΠ໰୊͕
     ঃʑʹݦࡏԽ
     QVSJOUBJೖࣾ
     ଟஈσϓϩΠͷಋೖ
     ৳ͼଓ͚Δ
     σϓϩΠ࣌ؒ
     

     View Slide

108. σϓϩΠ࣌ؒ෼Ͱ
     ௕͍ͱݴ͍ͬͯͨ
     ϱ݄લʜʜ
     

     View Slide

109. ৳ͼଓ͚ΔσϓϩΠ࣌ؒ
     

     View Slide

110. ςφϯτ਺͸ Λ
     ௒͍͑ͯͨ
     

     View Slide

111. ͍ͦͯͭ͠ʹ
     ͋ͷൿີฌث͕
     

     View Slide

112. 4NBSU)3Ϛϧνςφϯτ೥ද
     
     
     
     
     
     
     
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ར༻اۀ਺
     4NBSU)3ެ։
     ೥݄
     
     JOJUJBMDPNNJU
     ೥݄
     
     ฒྻNJHSBUF
     ࢼ࡞൛
     σϓϩΠ໰୊͕
     ঃʑʹݦࡏԽ
     QVSJOUBJೖࣾ
     ଟஈσϓϩΠͷಋೖ
     ৳ͼଓ͚Δ
     σϓϩΠ࣌ؒ
     ʁʁʁ
     

     View Slide

113. ฒྻϚΠάϨʔγϣϯ࣮ઓ౤ೖ
     

     View Slide

114. ͖ͨʂ͜ΕͰউͭΔʂ
     

     View Slide

115. ࣮ઓ౤ೖޙ
     

     View Slide

116. ͋ͬ
     

     View Slide

117. ͋ͬ
     

     View Slide

118. ىͬͨ͜͜ͱ
     NJHSBUJPO؀ڥ্ͰฒྻϚΠάϨʔγϣϯΛ࣮ߦ
     ͓΍ʜʜNJHSBUJPO؀ڥͷ༷ࢠ͕ʜʜʁ
     ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     ϚΠάϨʔγϣϯ
     ະ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     ฒྻϚΠάϨʔγϣϯ࣮ߦத
     $3&"5&5"#-&DPNNFOUT
     

     View Slide

119. ىͬͨ͜͜ͱ
     ϝϞϦෆ଍ͰNJHSBUJPO؀ڥࢮ๢ ˞ͨͩͷߟྀ࿙Ε
     
     "-5&35"#-&͕த్൒୺ͳঢ়ଶͰऴΘΔ
     ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     ϚΠάϨʔγϣϯ
     ະ׬ྃςφϯτ܈
     

     View Slide

120. ىͬͨ͜͜ͱ
     

     View Slide

121. ىͬͨ͜͜ͱ
     

     View Slide

122. ·ͨผͷ೔͸
     ผͷཧ༝Ͱཱͯଓ͚ʹ
     σϓϩΠࣦഊ
     

     View Slide

123. ࿈೔ͷো֐ൃੜ
     ೔த̔࣌ؒͷ
     αʔϏεఀࢭ
     

     View Slide

124. View Slide

125. ਃ͠༁͍͟͝·ͤΜ
     Ͱͨ͠
     

     View Slide

126. ͜ΕΛ͖͔͚ͬʹ
     ਂ໷ఆظϝϯςφϯε͕
     ͸͡·Δʜʜ
     

     View Slide

127. εϥΠυલ൒ऴྃ
     ʢͪΐͬͱٳܜʣ
     

     View Slide

128. ٳܜ͕ͯΒ
     ͜͜·Ͱͷ໰୊ͷ੔ཧ
     

     View Slide

129. ໰୊ͷ࠶੔ཧ
     ɾฒྻσϓϩΠ͸࣮ઓ౤ೖ͞Εͨ͹͔ΓͰ·ͩෆ҆ఆ
     ɾجຊతʹଟஈσϓϩΠͰ໰୊ແ͍͸͕ͣͩ
     ɹಛఆ৚݅ԼͰෆ҆ఆʹͳΔ
     ɾԿΒ͔ͷཁҼͰϚΠάϨʔγϣϯ͕தஅ͞ΕΔͱ
     ɹςφϯτ͝ͱͷεΩʔϚ͕όϥόϥʹͳΓ
     ɹௐࠪ෮چ͕େม
     ɾԿΑΓσϓϩΠʹ͕͔͔࣌ؒΓ͗͢Δ
     

     View Slide

130. ໰୊ͷ࠶੔ཧ
     ͳʹ͕Ұ൪ղফ͞ΕΔͱ͏Ε͍͠ͷ͔
     ɹˠϚΠάϨʔγϣϯ͕ര଎ʹͳΔͱ͏Ε͍͠
     ɹˠͦͷͨΊʹ͸BQBSUNFOUΛ΍ΊΔඞཁ͕͋Δ
     ɹˠBQBSUNFOUΛ΍Ίͨޙͷ͜ͱΛߟ͑Δͱʜʜ
     εΩʔϚ౷߹ޙʹͲ͏΍ͬͯϚϧνςφϯτΛकΔʁ
     ओΩʔ͕࿈൪͔ͩΒ౷߹͢Δͱিಥ͢Δ͠ʜʜ
     ༬͔͍ͬͯΔ৘ใ͕৘ใ͚ͩʹ࿙ΕͨΒᔬམʹͳΒͳ͍
     

     View Slide

131. ϚΠάϨʔγϣϯΛ
     ര଎ʹ͢Δํ๏ͷߟ࡯
     ʢτϥΠΞϯυΤϥʔʣ
     

     View Slide

132. ΠϯελϯεαΠζΛένͬͪΌμϝ
     NJHSBUJPO؀ڥ͸NYMBSHF
     3%4 .Z42-
     ͸SYMBSHF (#44%ʹมߋ
     ͜Ε͚ͩͰҰ࣌తʹ਺ഒߴ଎Խͨ͠
     ʢςφϯτ਺૿͑ͯ·ͨ஗͘ͳ͚ͬͨͲʣ
     ۚͷ஄ؙ
     

     View Slide

133. ͢΂ͯͷςφϯτ͕
     ೔ৗతʹར༻͞Ε͍ͯΔΘ͚Ͱ͸ͳ͍
     ༏ઌϚΠάϨʔγϣϯ
     ϚΠάϨʔγϣϯ
     ະ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     

     View Slide

134. ςφϯτ܈ʹ༏ઌ౓Λ෇༩͢Δ
     ྫ՝ۚதτϥΠΞϧதແྉϓϥϯ
     ೔Ҏ಺ϩάΠϯ೔Ҏ಺ϩάΠϯϩάΠϯͳ͠
     ༏ઌϚΠάϨʔγϣϯ
     ϚΠάϨʔγϣϯ
     ະ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     ༏ઌ౓ߴ ༏ઌ౓த ༏ઌ౓௿
     

     View Slide

135. ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     ༏ઌ౓ߴ͕ऴྃͨ͠Βݟ੾ΓσϓϩΠͯ͠͠·͏ɹɹɹɹ
     ༏ઌϚΠάϨʔγϣϯ
     ϚΠάϨʔγϣϯ
     ະ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     ༏ઌ౓ߴ ༏ઌ౓த ༏ઌ౓௿
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧ͋Δ
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧͳ͍
     

     View Slide

136. ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     ༏ઌ౓தɾ௿܈͕ΞΫηε͢ΔͱΤϥʔʹͳΔ͕
     ࣮ࡍΞΫηεස౓͕௿͍܈ͳͷͰ໰୊͕ى͖ͳ͍
     ༏ઌϚΠάϨʔγϣϯ
     ϚΠάϨʔγϣϯ
     ະ׬ྃςφϯτ܈
     NJHSBUJPO
     ίϯςφ
     ༏ઌ౓ߴ ༏ઌ౓த ༏ઌ౓௿
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧ͋Δ
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧͳ͍
     

     View Slide

137. ϚΠάϨʔγϣϯ
     ׬ྃςφϯτ܈
     ༏ઌ౓தɾ௿܈ͷਓ͕ΞΫηεͯ͘͠Δࠒʹ͸
     ϚΠάϨʔγϣϯ͸ऴΘ͍ͬͯΔʢϋζʣ
     ༏ઌϚΠάϨʔγϣϯ
     ະ
     ׬
     NJHSBUJPO
     ίϯςφ
     ༏ઌ౓ߴ ༏ઌ౓த ༏ઌ౓௿
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧ͋Δ
     ৽͍͠
     8FCίϯςφ
     DPNNFOUT
     ςʔϒϧ͋Δ
     

     View Slide

138. গ͠ޮՌ͸͋ͬͨ
     

     View Slide

139. ͕ͩશମͱ͕ͯ࣌ؒ͠
     ͔͔Δͷ͸มΘΒͣ
     

     View Slide

140. ݩͷߏ੒
     ΞʔΩςΫνϟͷมߋݕ౼
     MySQL DB
     instance
     BQBSUNFOU
     ύϒϦοΫ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     instance
     

     View Slide

141. ෳ਺%#ʹ͢Ε͹ϚΠάϨʔγϣϯ଎͘ͳΔͷͰ͸ʁ
     ΞʔΩςΫνϟͷมߋݕ౼
     MySQL DB
     instance
     BQBSUNFOU
     ύϒϦοΫ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     instance
     MySQL DB
     instance
     ύϒϦοΫ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     

     View Slide

142. ͪΐͬͱ଴ͪͨ·͑
     

     View Slide

143. ͦ΋ͦ΋4NBSU)3͸
     

     View Slide

144. ࣮͸ैۀһͱϢʔβΛ
     σʔλϕʔεލ͍Ͱ+0*/͍ͯ͠Δ
     ΞʔΩςΫνϟͷมߋݕ౼
     MySQL DB
     instance
     BQBSUNFOU
     ύϒϦοΫ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     ϓϥΠϕʔτ%#
     instance
     ैۀһςʔϒϧ
     ͸ͬͪ͜
     Ϣʔβςʔϒϧ
     ͸ͬͪ͜
     

     View Slide

145. ͳͥϢʔβ͕
     ύϒϦοΫ%#্ʹʁ
     

     View Slide

146. ཧ༝ࣾ࿑࢜޲͚ػೳͱͯ͠ෳ਺ͷςφϯτʹ
     ୯ҰϢʔβ͕ϩάΠϯͰ͖Δػೳ͕͋Δ͔Β
     ΞʔΩςΫνϟͷมߋݕ౼
     

     View Slide

147. ͦͯ͠ෳ਺%#ߏ੒͸
     ઌߦࣄྫΛௐࠪ͢Δʹ
     পͬΆ͍ʜʜ
     

     View Slide

148. ͭΒ͍΍Γํ͸
     ͍͔ͭࣗ෼ͨͪͷ଍Λ
     Ҿͬுͬͯ͘Δ
     

     View Slide

149. ଞʹ΋༷ʑ͋Γ
     ෳ਺%#ܭը͸
     ͓ଂೖΓ
     

     View Slide

150. ͱ͜ΖͰ
     

     View Slide

151. CVJMEFSTDPOͷςʔϚ͸
     ʮ஌Βͳ͔ͬͨΛɺฉ͘ʯ
     Ͱ͕͢
     

     View Slide

152. օ͞Μ͓ؾ͖ͮ
     Ͱͨ͠Ͱ͠ΐ͏͔
     

     View Slide

153. શ͘ޮՌ͕ग़ͳ͔ͬͨ
     ͋ͷൿີฌثͷ͜ͱΛʜ
     

     View Slide

154. ࢥ͍ग़͢γϦʔζ
     

     View Slide

155. ಥવͰ͕͢
     ͜͜ͰΫΠζͰ͢
     

     View Slide

156. ͋Δ"843%4 .Z42-
     ͷΠϯελϯε্ʹ
     ଘࡏ͢Δෳ਺ͷ%"5"#"4&ʹڞ௨Ͱଘࡏ͢Δ
     ςʔϒϧʹΧϥϜΛ௥Ճ͠Α͏ͱࢥ͍·͢ɻ
     %"5"#"4&ͷ਺͕ͩͬͨ৔߹ʹฒྻͰ
     "-5&35"#-&Λ࣮ߦͨ͠ΒԿඵͰऴΘΔͰ͠ΐ͏͔ɻ
     ୯ମͰ࣮ߦͨ͠৔߹͸ඵ͔͔Δ΋ͷͱ͠ɺ
     Φʔόʔϔου͸ৗʹඵͱ͢Δɻ
     ಥવͷΫΠζ
     

     View Slide

157. ਖ਼ղ͸ʜʜ
     

     View Slide

158. ਖ਼ղ͸ʜʜඵͰ͢
     

     View Slide

159. ฒྻ%%-ͷ࣮ߦͬͯ
     ͦ΋ͦ΋ແཧͩͬͨ
     গͳ͘ͱ΋ςʔϒϧΧϥϜͷ௥Ճ࡟আ͕൐͏ͱ
     
     

     View Slide

160. ஌Βͳ͔ͬͨ
     

     View Slide

161. ஌Βͳ͔ͬͨ
     

     View Slide

162. ஌Βͳ͔ͬͨ
     Λฉ͚·͔ͨ͠ʁ
     

     View Slide

163. ։ൃνʔϜ͕
     ͜ͷࣄ࣮ʹؾͮ͘ͷ͸
     ΋͏গ͠ઌͷ࿩
     

     View Slide

164. ͓͋ͱ͕ΑΖ͍͠Α͏Ͱ
     

     View Slide

165. εϥΠυޙ൒ελʔτ
     

     View Slide

166. ଓɾ4NBSU)3
     ϚΠάϨʔγϣϯ೥ද
     

     View Slide

167. 4NBSU)3Ϛϧνςφϯτ೥ද
     
     
     
     
     
     
     
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ར༻اۀ਺
     4NBSU)3ެ։
     ೥݄
     
     JOJUJBMDPNNJU
     ೥݄
     
     ฒྻNJHSBUF
     ࢼ࡞൛
     σϓϩΠ໰୊͕
     ঃʑʹݦࡏԽ
     QVSJOUBJೖࣾ
     ଟஈσϓϩΠͷಋೖ
     ৳ͼଓ͚Δ
     σϓϩΠ࣌ؒ
     αʔϏεো֐ൃੜ
     ఆظϝϯςମ੍
     ελʔτ
     

     View Slide

168. 4NBSU)3Ϛϧνςφϯτ೥ද
     
     
     
     
     
     
     
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ར༻اۀ਺
     4NBSU)3ެ։
     ೥݄
     
     JOJUJBMDPNNJU
     ೥݄
     
     ฒྻNJHSBUF
     ࢼ࡞൛
     σϓϩΠ໰୊͕
     ঃʑʹݦࡏԽ
     QVSJOUBJೖࣾ
     ଟஈσϓϩΠͷಋೖ
     ৳ͼଓ͚Δ
     σϓϩΠ࣌ؒ
     αʔϏεো֐ൃੜ
     ఆظϝϯςମ੍
     ελʔτ
     %JTDPWFS
     4PNFUIJOH/FX
     

     View Slide

169. ͦΕ͸)FSPLV1PTUHSFTΛௐ΂͍ͯͨ࣌ͷ࿩
     $JUVTͱͷग़ձ͍
     

     View Slide

170. $JUVTͱͷग़ձ͍
     

     View Slide

171. $JUVTͱ͸IUUQTHJUIVCDPNDJUVTEBUBDJUVT
     ɾΦʔϓϯιʔεͷ1PTUHSF42-֦ு GPSLͰ͸ͳ͍
     
     ɾߴ͍εέʔϥϏϦςΟ
     ɾΫΤϦฒྻԽͷͨΊͷ෼ࢄΤϯδϯ
     ɾϚϧνςφϯτΞϓϦΛߟྀͨ͠ઃܭ
     ɾͱʹ͔͘ϚΠάϨʔγϣϯ͕଎͍
     ɾΞϓϦέʔγϣϯ͔Β͸୯ҰͷσʔλϕʔεͷΑ͏ʹݟ͑Δ
     $JUVTͱͷग़ձ͍
     

     View Slide

172. $JUVT͸ͭͷίʔσΟωʔλʔϊʔυͱ
     ෳ਺ͷϫʔΧʔϊʔυʹ෼͔Ε͍ͯΔ
     $JUVTͱͷग़ձ͍
     

     View Slide

173. ΞϓϦέʔγϣϯ͔Β͸
     ίʔσΟωʔλϊʔυʹର͠ΫΤϦΛ࣮ߦ͢Δ
     $JUVTͱͷग़ձ͍
     

     View Slide

174. ίʔσΟωʔλϊʔυ͸ड͚औͬͨΫΤϦΛ
     ద੾ͳϫʔΧʔϊʔυʹ౤͛௚͢
     $JUVTͱͷग़ձ͍
     

     View Slide

175. ϫʔΧʔϊʔυ͸ίʔσΟωʔλϊʔυʹ
     ΫΤϦͷ࣮ߦ݁ՌΛฦ٫͢Δ
     $JUVTͱͷग़ձ͍
     

     View Slide

176. ίʔσΟωʔλϊʔυ͸
     ϫʔΧʔϊʔυ͔Βͷ݁ՌΛΞϓϦέʔγϣϯʹฦ͢
     $JUVTͱͷग़ձ͍
     

     View Slide

177. ΫΤϦ͕ෳ਺ͷϊʔυΛ·͙ͨ৔߹΋
     ίʔσΟωʔλϊʔυ͕͏·͘ूܭͯ݁͠ՌΛฦ͢
     $JUVTͱͷग़ձ͍
     

     View Slide

178. "-5&35"#-&΋౰વ͍͚Δ
     $JUVTͱͷग़ձ͍
     

     View Slide

179. ͍͢͝ʜʜ
     

     View Slide

180. Ͱ΋ࣗ෼Ͱཱͯͳ͍ͱ
     ͍͚ͳ͍ΜͰ͠ΐʁ
     

     View Slide

181. $JUVT$MPVEIUUQTXXXDJUVTEBUBDPNQSPEVDUDMPVE
     $JUVTࣾެࣜͷ%BUBCBTFBTB4FSWJDF
     "84౦ژϦʔδϣϯ্ʹ΋ϗεςΟϯάՄೳ
     $JUVTͱͷग़ձ͍
     

     View Slide

182. έʔΩ৯ͬͯΔ
     ৔߹͡ΌͶ͑
     

     View Slide

183. $JUVTͱͷग़ձ͍
     

     View Slide

184. Ϛϧνςφϯγʔͷݕূ༻ΞϓϦΛ࡞੒
     ࡶʹ ςφϯτΛ࡞੒ͯ͠
     ద౰ʹ਺ઍສϨίʔυੜ੒ޙECNJHSBUFΛ͔͚Δ
     $JUVTͱͷग़ձ͍
     

     View Slide

185. BQBSUNFOUHFN͔Βൺֱత৐Γ׵͕͑༰қͳ
     $JUVT͕ࣾఏڙ͢ΔBDUJWFSFDPSENVMUJUFOBOUHFN
     IUUQTHJUIVCDPNDJUVTEBUBBDUJWFSFDPSENVMUJUFOBOU
     $JUVTͱͷग़ձ͍
     

     View Slide

186. ݟ͚ͭͨͧʜʜ
     ۜͷ஄ؙʜʜ
     

     View Slide

187. %#ϨΠϠͷ໰୊͕
     %#ϨΠϠͰղܾ͢Δͬͯ
     ࠷ߴ͡ΌΜʜʜ
     

     View Slide

188. $JUVT$MPVEҠߦ
     ϓϩδΣΫτ
     

     View Slide

189. ·ͣ͸Ҡߦର৅Λ੔ཧ
     

     View Slide

190. Ҡߦલ
     ҠߦલͱҠߦޙͷࠩ෼
     1PTUHSF42-
     $JUVT$MPVE
     Ҡߦޙ
     .Z42-
     "843%4
     

     View Slide

191. Ҡߦલ
     ҠߦલͱҠߦޙͷࠩ෼
     1PTUHSF42-
     $JUVT$MPVE
     QHHFN
     BDUJWFSFDPSENVMUJUFOBOUHFN
     ୯ҰεΩʔϚ
     Ҡߦޙ
     .Z42-
     "843%4
     NZTRMHFN
     BQBSUNFOUHFN
     ෼ࢄεΩʔϚ
     

     View Slide

192. ͋ͬɺओΩʔͲ͏͠Α
     

     View Slide

193. ڧ͍ؾ࣋ͪͰ
     ࣗ෼Ͱ࣮૷͠ͳ͍
     

     View Slide

194. Ҡߦલ
     ҠߦલͱҠߦޙͷࠩ෼
     1PTUHSF42-
     $JUVT$MPVE
     QHHFN
     BDUJWFSFDPSENVMUJUFOBOUHFN
     ୯ҰεΩʔϚ
     ओΩʔ66*%
     4ͷΩʔ66*%
     Ҡߦޙ
     .Z42-
     "843%4
     NZTRMHFN
     BQBSUNFOUHFN
     ෼ࢄεΩʔϚ
     ओΩʔ࿈൪
     4ͷΩʔ࿈൪
     

     View Slide

195. ͦ΋ͦ΋.Z42-ͱ1PTUHSF42-ͷҧ͍
     Α͘஌ΒΜ͠ͳ͋ʜʜ
     ࠩ෼ΛຒΊΔํ๏
     

     View Slide

196. ࠩ෼ΛຒΊΔํ๏
     

     View Slide

197. ͸͍
     

     View Slide

198. ࠩ෼ΛຒΊΔํ๏
     

     View Slide

199. ࠩ෼ΛຒΊΔํ๏
     

     View Slide

200. ੟ਓ͔ʜʜ
     

     View Slide

201. ͱ͸͍͑·ͣ͸
     σʔλҠߦͳ͠Ͱ֬ೝ
     

     View Slide

202. ॳख͸ECDPOOFDUPS͔Β
     

     View Slide

203. BQBSUNFOUHFN͸࢒ͨ͠·· NZTRM͸
     
     QHBDUJWFSFDPSENVMUJUFOOBUHFNΛ௥Ճ
     ॳख͸ECDPOOFDUPS͔Β
     

     View Slide

204. ॳख͸ECDPOOFDUPS͔Β
     ͜͏͍͏ͷˣ
     

     View Slide

205. ೥໌͚͔Β̏िؒ
     ಈ࡞֬ೝ੒ޭ
     

     View Slide

206. ͔͜͜͠͠Ͱ໰୊͕
     

     View Slide

207. ࢥ͍ग़͢γϦʔζ
     ͭ·Γػೳվम͸جຊతʹϚΠάϨʔγϣϯΛ൐͏
     

     View Slide

208. ͏Θͬʜʜ
     ػೳ։ൃʹ൐͏
     εΩʔϚมߋଟ͗͢ʜʜ
     

     View Slide

209. σʔλϕʔεҠߦϓϩδΣΫτΛ΍͍ͬͯΔͷʹ
     ຖिεΩʔϚมߋ͕ى͜Δঢ়ଶͰ
     Ͳ͏΍ͬͯσʔλҠߦ͕
     Ͱ͖͍ͯΔ͜ͱΛݕূ͢Δͷ͔ʜʜ
     ͱ͸͍͑ػೳ։ൃΛࢭΊΔΘ͚ʹ͸ʜʜ
     %#ࠩ෼͕ຖिൃੜ
     

     View Slide

210. ͍΍
     ͜͜͸ڧ͍ؾ࣋ͪͰ
     ࢭΊͳ͚Ε͹
     

     View Slide

211. ϓϩμΫτνʔϜ૬ஊͷ΋ͱ̑ʙ݄̒ʹ͔͚ͯ
     ʮ4NBSU)3ຊମͷ։ൃΛҰϲ݄ఀࢭ͠·͢ʯ
     Λશࣾతʹڞ༗
     ίʔυϑϦʔζ·Ͱʹؒʹ߹Θ͍ͤͨνέοτͷ
     ༏ઌ౓ௐ੔΍ɺظؒதͷෆ۩߹ରԠํ਑ʹ͍ͭͯ੔උ
     ίʔυϑϦʔζͷ༧ࠂ
     

     View Slide

212. ·ͨɺίʔυϑϦʔζظؒத͸
     ΧελϚʔαϙʔτνʔϜ͕2"ΛόοΫΞοϓ
     ଞ෦ॺͷํʑ΋ࣄ৘Λঝ஌ͷ্Ͱద੾ͳಈ͖Λݕ౼
     ίʔυϑϦʔζͷ༧ࠂ
     

     View Slide

213. ͓٬༷޲͚ͷࠂ஌ϒϩά΋هड़
     αʔϏεαΠτͷ͓஌ΒͤͱςοΫϒϩάهࣄͰ
     าௐΛ߹ΘͤΔͷ͸ྑ͍ࢼΈͰͨ͠
     ίʔυϑϦʔζͷ༧ࠂ
     

     View Slide

214. σʔλҠߦʹ޲͚ͨ
     ૊৫ମ੍͕੔͖ͬͯͨ
     

     View Slide

215. σʔλҠߦ΋
     ४උ͠ͳ͚Ε͹
     

     View Slide

216. σʔλҠߦޙ͸ओΩʔΛ66*%ʹ͢Δ͚Ͳ
     ༧Ί࠾൪͓͍ͯͨ͠ํ͕Կ͔ͱศརͩΑͶ
     ʢϦϨʔγϣϯͷுΓ௚͠ͱ͔ʣ
     ˠશςʔϒϧʹVVJEΧϥϜΛੜ΍͢
     ˠVVJEΛ࠾൪ࣗಈͰ࠾൪͞ΕΔΑ͏ʹ
     ˠVVJEʹ/05/6--੍໿Λ෇༩
     σʔλҠߦʹ޲͚ͨ४උ
     

     View Slide

217. શςʔϒϧʹ
     VVJEΧϥϜΛੜ΍͢
     ʜʜ͋ͬʢ࡯͠ʣ
     

     View Slide

218. 4NBSU)3ͷ౰࣌ͷςʔϒϧ਺͸
     ͦΕΒશͯʹରͯ͠
     6/*26&੍໿෇͖
     TUSJOHΧϥϜΛ௥Ճ
     શςʔϒϧʹΧϥϜΛੜ΍͢
     

     View Slide

219. ϚΠάϨʔγϣϯ౰೔
     શςʔϒϧʹΧϥϜΛੜ΍͢
     

     View Slide

220. ͦͯ͜͠ͷϚΠάϨʔγϣϯͰΑ͏΍͘ؾ͕ͭ͘
     શςʔϒϧʹΧϥϜΛੜ΍͢
     

     View Slide

221. ͦͯ͜͠ͷϚΠάϨʔγϣϯͰΑ͏΍͘ؾ͕ͭ͘
     ฒྻϚΠάϨʔγϣϯʹ
     ʢ͋·Γʣҙຯ͕ͳ͔ͬͨ͜ͱΛʜʜ
     શςʔϒϧʹΧϥϜΛੜ΍͢
     

     View Slide

222. ͪͳΈʹ.Z42-෇ଐͷ66*%ؔ਺͸
     66*%W UJNFTUBNQ෇
     ͳͷͰ
     66*%WܗࣜͰࣗಈ࠾൪͍ͨ͠ͳΒ
     "DUJWF3FDPSEଆͰҰ޻෉͢Δඞཁ͋Γ
     BGUFS@JOJUJBMJ[F͸BDUJWFSFDPSEJNQPSU޲͚
     
     .Z42-Ͱ΋66*%ࣗಈ࠾൪
     

     View Slide

223. શͯͷϨίʔυʹ66*%͕࠾൪͞ΕΔΑ͏ʹͳΓ
     σʔλҠߦલޙͷಈ࡞֬ೝΛָʹ͢ΔͨΊϓνIBDL
     .Z42-Ͱ΋66*%ࣗಈ࠾൪
     

     View Slide

224. ͕ͯ͜͜͞େҰ൪
     

     View Slide

225. σʔλҠߦ͋Ε͜Ε
     

     View Slide

226. σʔλҠߦํ๏ͷௐࠪ
     MySQL DB
     instance
     Amazon
     RDS
     Postgre SQL
     instance
     ԿΒ͔ͷํ๏
     

     View Slide

227. σʔλҠߦํ๏ͷௐࠪ
     ཁ݅
     ɹ׬શͳΔఀࢭ͕ڐ༰͞ΕΔ࣌ؒ಺ʹ
     ɹશͯͷσʔλҠߦ޻ఔ͕׬ྃ͢Δ͜ͱ
     ˠଟ෼ɺ౔೔ͷ̎೔͕ؒݶ౓͡Όͳ͍͔ͳ
     

     View Slide

228. σʔλҠߦํ๏ͷௐࠪ
     ·ͣ͸$JUVT 1PTUHSF42-
     Λௐࠪͯ͠ΈΑ͏
     Postgre SQL
     instance
     

     View Slide

229. σʔλҠߦํ๏ͷௐࠪ
     

     View Slide

230. σʔλҠߦํ๏ͷௐࠪ
     

     View Slide

231. σʔλҠߦํ๏ͷௐࠪ
     $JUVTͷ$01:จʹΑΔΠϯϙʔτ͸࣮ࡍ଎͍
     ϫβϚΤʂʢඵؒສϨίʔυͬͯ
     
     Ҿ༻ݩ$01:JOUPEJTUSJCVUFE1PTUHSF42-UBCMFT VQUPd.SPXTTFD$JUVT%BUB
     IUUQTXXXDJUVTEBUBDPNCMPHDPQZQPTUHSFTRMEJTUSJCVUFEUBCMFT
     

     View Slide

232. σʔλҠߦํ๏ͷௐࠪ
     $JUVT΁ͷΠϯϙʔτʹର͢Δෆ҆͸ͳ͘ͳͬͨ
     "843%4 .Z42-
     ͔Β
     $JUVT$MPVEʹऔΓࠐΊΔܗࣜͰ
     ΤΫεϙʔτ͢Δํ๏Λௐࠪ͢Δ͜ͱʹ
     MySQL DB
     instance
     Amazon
     RDS
     

     View Slide

233. .Z42-͔Β$47Ͱ
     ΤΫεϙʔτͱݴ͑͹
     NZTRMEVNQͰ͕͢
     

     View Slide

234. σʔλҠߦํ๏ͷௐࠪ
     NZTRMEVNQ͸࢒೦ͳ͕Β"843%4Ͱ͸࢖͑ͳ͍
     ʢσΟεΫ্΁ͷॻ͖ࠐΈݖ͕ͳ͍ͷͰʣ
     ಉ༷ʹ4&-&$5d*/50065'*-&౳΋ෆՄ
     ૉ௚ʹநग़༻ͷεΫϦϓτॻ͔͘͠
     MySQL DB
     instance
     Amazon
     RDS
     

     View Slide

235. 3VCZͰॻ͍ͨΒ
     ऴΘΒͳ͍ʢ௚ײʣ
     

     View Slide

236. ͜ͷΑ͏ͳ42-ϑΝΠϧΛςʔϒϧຖʹ༻ҙͯ͠ʜʜ
     σʔλҠߦεΫϦϓτࢼ࡞
     MySQL DB
     instance
     Amazon
     RDS
     

     View Slide

237. ͜ͷΑ͏ͳγΣϧεΫϦϓτΛॻ͍ͯ
     σʔλҠߦεΫϦϓτࢼ࡞
     MySQL DB
     instance
     Amazon
     RDS
     

     View Slide

238. நग़͘Μࢼ࡞Ұ߸ػͷڍಈ
     ύϒϦοΫ%#্ͷ5FOBOUςʔϒϧ͔Β

     શςφϯτͷ%#໊Λશ෦நग़
     ϧʔϓ͠ͳ͕ΒύΠϓ্Ͱ

     Ҿ਺ల։ͯ͠઀ଓઌ%#੾ସ
     NZTRMίϚϯυͷ࣮ߦ݁ՌΛඪ४ग़ྗ
     ϦμΠϨΫτͰ೚ҙͷϑΝΠϧʹॻࠐ
     
     σʔλҠߦεΫϦϓτࢼ࡞
     MySQL DB
     instance
     Amazon
     RDS
     

     View Slide

239. நग़͘Μࢼ࡞Ұ߸ػͷ൓ল
     ɾύοτݟՄಡੑ௿͍͠ϝϯςੑ΋௿͍
     ɾύΠϓͰγΣϧҾ਺ల։͕τϦοΩʔ͗͢
     ɾςφϯτͷ਺͚ͩNZTRMDNE͕࣮ߦ͞Ε஗͍
     σʔλҠߦεΫϦϓτࢼ࡞
     

     View Slide

240. Ϙπ
     

     View Slide

241. ࢼߦࡨޡͷ຤
     

     View Slide

242. ҠߦεΫϦϓτ͸3VCZͰॻ͘
     42-ϑΝΠϧ͸FSCͰςϯϓϨʔτԽ͢Δ
     σʔλநग़͸QPQFOܦ༝ͰNZTRMίϚϯυୟ͘
     σʔλҠߦεΫϦϓτ7
     

     View Slide

243. Αͦ͞͏
     

     View Slide

244. ςʔϒϧ͝ͱͷ42-ϑΝΠϧͷςϯϓϨʔτΛ

     σʔλϕʔεεΩʔϚ͔Βࣗಈੜ੒͠FSCͰग़ྗ

     ΧϥϜͷछྨͰѻ͍Λม͍͑ͯΔ
     
     σʔλҠߦεΫϦϓτ7ྲྀΕ
     

     View Slide

245. ग़ྗ͞ΕͨFSCΛ໨ࢹͰ֬ೝ͠
     ɹϦϨʔγϣϯϙϦϞʔϑΟοΫؔ࿈ΧϥϜ
     Λ͍͍ײ͡ʹ΍Δ
     ͱΓ͋͑ͣࡶʹ-&'5065&3+0*/ͯ͠
     $0"-&4$&Ͱฒ΂͓͚ͯ͹େৎ෉ʂ
     σʔλҠߦεΫϦϓτ7ྲྀΕ
     

     View Slide

246. 5FOBOUςʔϒϧ͔Βσʔλϕʔε໊Λશநग़͠
     FSCςϯϓϨʔτʹࠩ͠ࠐΜͩ΋ͷΛ
     ςʔϒϧ୯ҐͷϑΝΠϧʹ௥هग़ྗ
     ͢Δͱςʔϒϧͷ਺͚ͩͷ42-ϑΝΠϧ͕Ͱ͖Δ
     ࢼ࡞ܕͱҧ͏ͷ͸ɺͭͷ42-ϑΝΠϧʹ
     શςφϯτ෼ͷ4&-&$5จ͕ग़ྗ͞Ε͍ͯΔ͜ͱ
     σʔλҠߦεΫϦϓτ7ྲྀΕ
     

     View Slide

247. ग़ྗ͞Εͨ42-ϑΝΠϧΛ
     NZTRMίϚϯυͰ౤͛
     ඪ४ग़ྗΛϑΝΠϧʹॻ͖ग़͢
     ͪͳΈʹNZTRMίϚϯυͷΦϓγϣϯ͸"/S

     "%#੾ସ࣌ʹςʔϒϧఆٛΛಡΈࠐ·ͳ͍ߴ଎Խ
     /ΧϥϜͷϔομʔΛग़ྗ͔ΒӅ͢
     Sग़ྗ஋ͷΤεέʔϓม׵Λ͠ͳ͍
     σʔλҠߦεΫϦϓτ7ྲྀΕ
     

     View Slide

248. View Slide

249. ࠔͬͨॴ
     

     View Slide

250. TUSJOHUFYUΧϥϜʹEPVCMFRVPUFؚ͕·Εͨ৔߹
     NZTRMίϚϯυ͸཯ّʹΤεέʔϓॲཧ<>ˠ<>Λ
     ͯ͘͠Ε͸͠ͳ͍ͷͰɺࣗྗͰ΍Δඞཁ͕͋Δʜʜ
     Ͳ͏΍ͬͯʁ
     EPVCMFRVPUFͷΤεέʔϓ໰୊
     

     View Slide

251. ग़ྗޙʹTFEͳͲͰ΍Δํ๏΋͋Δ͕
     ετΞυϑΝϯΫγϣϯΛ࢖ͬͨΒָͰͨ͠
     ͨͩ୯ʹEPVCMFRVPUF͕͋ͬͨΒ̎ͭʹ͢Δ͚ͩ
     
     ͳ͓ܕ͸-0/(5&95ʹ͠ͳ͍ͱจࣈҎ಺ʹॖΊΒΕͯ͠·͏
     EPVCMFRVPUFͷΤεέʔϓ໰୊
     CREATE FUNCTION
     sys.CSVSTR(str LONGTEXT CHARSET utf8mb4)
     RETURNS LONGTEXT CHARSET utf8mb4 DETERMINISTIC
     RETURN CONCAT('"', REPLACE(str, '"', '""'), '"');
     

     View Slide

252. ετΞυϑΝϯΫγϣϯ࡞ͬͨΒ
     UFYUܥΛͻͨ͢ΒғΉ
     EPVCMFRVPUFͷΤεέʔϓ໰୊
     SELECT
     t.uuid AS id,
     '<%= tenant_id %>' AS tenant_id,
     CONCAT('"', t.id, '"') AS old_id,
     CONCAT('"', DATE_FORMAT(t.created_at, '%Y-%m-%d %T'), '"') AS created_at,
     CONCAT('"', DATE_FORMAT(t.updated_at, '%Y-%m-%d %T'), '"') AS updated_at,
     sys.CSVSTR(t.country_number) AS country_number,
     sys.CSVSTR(t.zip_code) AS zip_code,
     sys.CSVSTR(t.pref) AS pref,
     sys.CSVSTR(t.city) AS city,
     sys.CSVSTR(t.street) AS street,
     sys.CSVSTR(t.building) AS building,
     sys.CSVSTR(t.literal_yomi) AS literal_yomi
     FROM
     <%= dbname %>.addresses AS t
     ORDER BY t.id ASC;
     

     View Slide

253. ྫ͑͹ͱ͋ΔϢʔβͷট଴ऀϢʔβ͕࡟আ͞Εͯͨ
     ҰԠট଴ऀͷ*%ͷ਺஋͕ΧϥϜʹ࢒͍ͬͯΔ͕ɺ
     66*%Ҡߦʹ൐͍Ͳ͏ʹ͔͠ͳ͍ͱ͍͚ͳ͍
     ͔ͱ͍ͬͯϥϯμϜͳ66*%Λ࠾൪͢ΔΘ͚ʹ͸
     ͜Ε΋ετΞυϑΝϯΫγϣϯͰͳΜͱ͔͠·͠ΐ͏
     ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍
     

     View Slide

254. ফ͑ͨࢀরઌͷςʔϒϧ໊JEςφϯτJEΛ౉͢ͱ
     66*%Λฦͯ͘͠ΕΔϋογϡؔ਺
     ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍
     DELIMITER //
     CREATE FUNCTION sys.GHOSTUUID(table_name TEXT, id BIGINT, tenant_id TEXT)
     RETURNS TEXT CHARSET utf8mb4 DETERMINISTIC
     BEGIN
     SET @sha2 = SHA2(CONCAT('table_name:',table_name,'::id:',id,'::tenant_id:',tenant_id), 512);
     SET @uuid = CONCAT(
     SUBSTR(@sha2 from 10 for 8),
     '-',
     SUBSTR(@sha2 from 18 for 4),
     '-4',
     SUBSTR(@sha2 from 22 for 3),
     '-',
     LOWER(CONV(CONV(SUBSTR(@sha2 from 26 for 1), 16, 10) & 3 | 8, 10, 16)),
     SUBSTR(@sha2 from 27 for 3),
     '-',
     SUBSTR(@sha2 from 40 for 12)
     );
     RETURN @uuid;
     END;
     //
     DELIMITER ;
     

     View Slide

255. ଘࡏ͠ͳ͍͔΋͠Εͳ͍΍ͭ͸
     ͱΓ͋͑ͣғΜͰ͓͜͏ʂ
     ϦϨʔγϣϯઌͷϨίʔυ͕ͳ͍
     SELECT
     t.uuid AS id,
     '<%= tenant_id %>' AS tenant_id,
     CONCAT('"', t.id, '"') AS old_id,
     CONCAT('"', DATE_FORMAT(t.created_at, '%Y-%m-%d %T'), '"') AS created_at,
     CONCAT('"', DATE_FORMAT(t.updated_at, '%Y-%m-%d %T'), '"') AS updated_at,
     COALESCE(s.uuid, sys.GHOSTUUID('Payslip', t.payslip_id, '<%= tenant_id %>')) AS payslip_id,
     sys.CSVSTR(t.name) AS name,
     t.amount AS amount
     FROM
     <%= dbname %>.deductions AS t
     LEFT OUTER JOIN <%= dbname %>.payslips AS s
     ON t.payslip_id = s.id
     ORDER BY t.id ASC
     ;
     

     View Slide

256. ετΞυϑΝϯΫγϣϯ
     ศརա͗Δ
     

     View Slide

257. ͦͯ͠Ҡߦ౰೔
     

     View Slide

258. View Slide

259. View Slide

260. View Slide

261. View Slide

262. ಛʹେ͖ͳτϥϒϧ΋ͳ͘
     

     View Slide

263. View Slide

264. View Slide

265. 46$$&44
     

     View Slide

266. View Slide

267. View Slide

268. View Slide

269. ৼΓฦΓ
     

     View Slide

270. ৼΓฦΓ
     ੒ޭͷҰ൪ͷཁҼ͸πΠολʔઈͪ
     

     View Slide

271. ৼΓฦΓ
     ੒ޭͷҰ൪ͷཁҼ͸πΠολʔઈͪ
     ʜʜΛؚΊͨɺ͜ͷϓϩδΣΫτ͚ͩʹ
     ूதͰ͖Δ؀ڥΛपғʹ੔͑ͯ΋Βͬͨ͜ͱ
     ݕূʹे෼ͳ͕࣌ؒ͋ͬͨ͜ͱͰ
     ෆ҆ͳ͘ҠߦΛ͢Δ͜ͱ͕Ͱ͖ͨ
     

     View Slide

272. ৼΓฦΓ
     ޙ͸ແཧΛͨ͠࡞ΓࠐΈΛ͠ͳ͔ͬͨ͜ͱ
     ʢద੾ͳଥڠ͕Ͱ͖ͨʣ
     ݩ͕γϯϓϧͳঢ়ଶͰ͋Ε͹
     ผͷঢ়ଶʹ͍࣋ͬͯ͘͜ͱ΋ͨ΍͍͢
     ٕज़બఆ͸ͨͩબͿ࡞Δ͚ͩͰ͸ͳ͘
     ͔ͦ͜Βޙ໭Γ͕Ͱ͖Δ͔Ͳ͏͔ͱ͍͏ᄿ֮΋େࣄ
     

     View Slide

273. ৼΓฦΓ
     ࠓճ͸͍ͬͱ͖ͷ੒ޭΛऩΊ·͕ͨ͠
     কདྷͷ͋Δ࣌఺ʹ͓͍ͯ੒ޭ͔Ͳ͏͔͸෼͔Βͳ͍
     ຊ౰ͷධՁʹ͸ྺ࢙ͷ൑அ͕ඞཁ
     ͱ͸͍͑๻ͨͪ͸͜Ε͔Β$JUVTͱ΍͍͖ͬͯ·͢
     

     View Slide

274. Զͨͪͷઓ͍͸
     ·ͩ·ͩ͜Ε͔Βͩ
     

     View Slide

275. 4NBSU)3Ϛϧνςφϯτ೥ද
     
     
     
     
     
     
     
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ೥
     2
     ར༻اۀ਺
     4NBSU)3ެ։
     ೥݄
     
     JOJUJBMDPNNJU
     ೥݄
     
     ฒྻNJHSBUF
     ࢼ࡞൛
     σϓϩΠ໰୊͕
     ঃʑʹݦࡏԽ
     QVSJOUBJೖࣾ
     ଟஈσϓϩΠͷಋೖ
     ৳ͼଓ͚Δ
     σϓϩΠ࣌ؒ
     αʔϏεো֐ൃੜ
     ఆظϝϯςମ੍
     ελʔτ
     $JUVTͱͷग़ձ͍
     $JUVT$MPVE
     Ҡߦ1+ελʔτ
     ίʔυϑϦʔζ❄
     $JUVT$MPVE
     Ҡߦ੒ޭʂ
     ͝ਗ਼ௌ
     ͋Γ͕ͱ͏͍͟͝·ͨ͠
     

     View Slide