Upgrade to Pro — share decks privately, control downloads, hide ads and more …

2大OSSデータベースのMySQLとPostgreSQLの違い(前半)

 2大OSSデータベースのMySQLとPostgreSQLの違い(前半)

第32回 PostgreSQL 勉強会(2015年10月10日)の資料です

https://www.postgresql.jp/wg/shikumi/pgstudy_32/view

soudai sone

April 02, 2016
Tweet

More Decks by soudai sone

Other Decks in Technology

Transcript

  1. 2େOSSσʔλϕʔεͷ
    MySQLͱPostgreSQLͷҧ͍
    (લ൒)
    ୈ32ճ PostgreSQL ษڧձ

    View full-size slide

  2. What is it?
    ͜ͷεϥΠυͷ
    గਖ਼Օॴ
    ΛؚΊͨϒϩά͸ͪ͜Β
    IUUQTPVEBJCMPHTQPUKQPTTNZTRMQPTUHSFTRMIUNM

    View full-size slide

  3. What is it?
    0SBDMF͔ΒҠߦ͠Α͏͔ͳʜ

    View full-size slide

  4. What is it?
    0SBDMF͔ΒҠߦ͠Α͏͔ͳʜ
    42-4FSWFS͔ΒҠߦ͠Α͏͔ͳʜ

    View full-size slide

  5. What is it?
    0SBDMF͔ΒҠߦ͠Α͏͔ͳʜ
    42-4FSWFS͔ΒҠߦ͠Α͏͔ͳʜ
    ࣍ͷ৽نҊ݅Ͱ044࢖͓͏͔ͳʜ

    View full-size slide

  6. What is it?
    Ͱ΋Ͳͷ044Λબ΂͹͍͍͔Θ͔Βͳ͍

    View full-size slide

  7. What is it?
    044ͷ3%#ͱݴ͑͹ʁ

    View full-size slide

  8. What is it?
    044ͷ3%#ͱݴ͑͹ʁ
    ˣ
    .Z42-ͱ1PTUHSF42-

    View full-size slide

  9. What is it?
    ͜ΜͳਓͷͨΊʹ

    View full-size slide

  10. What is it?
    ͜ΜͳਓͷͨΊʹ
    w ͭͷҧ͍͕Α͘Θ͔ͳ͍

    View full-size slide

  11. What is it?
    ͜ΜͳਓͷͨΊʹ
    w ͭͷҧ͍͕Α͘Θ͔ͳ͍
    w Կͱͳ͘બΜ͚ͩͲ͜ΕͰྑ͔ͬͨͷʁ

    View full-size slide

  12. What is it?
    ͜ΜͳਓͷͨΊʹ
    w ͭͷҧ͍͕Α͘Θ͔ͳ͍
    w Կͱͳ͘બΜ͚ͩͲ͜ΕͰྑ͔ͬͨͷʁ
    w ͜Ε͔Βར༻͢Δʹ͸ͲͪΒΛબ΂͹͍͍ͷʁ

    View full-size slide

  13. What is it?
    ͦΜͳٙ໰ʹ͓౴͑͠·͢ʂ

    View full-size slide

  14. What is it?
    લఏ৚݅
    .Z42-ʢ*OOP%#ʣ
    1PTUHSFT42-

    View full-size slide

  15. What is it?
    લఏ৚݅
    ΈΜͳ1PTUHSF42-͸ŧŔŕŪƂŜſ

    View full-size slide

  16. What is it?
    લఏ৚݅
    ΈΜͳ1PTUHSF42-͸ŧŔŕŪƂŜſ
    ˣ
    1PTUHSF42-ͷઆ໌͸͋·Γ͠·ͤΜ
    Α͘Θ͔Βͳ͍৔߹͸ྡͷਓʹௌ͍͍ͯͩ͘͞

    View full-size slide

  17. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹΞʔΩςΫνϟͷҧ͍
    ̏ɹSQLͷҧ͍
    ̐ɹػೳͷҧ͍
    ̑ɹ·ͱΊ

    View full-size slide

  18. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹΞʔΩςΫνϟͷҧ͍
    ̏ɹSQLͷҧ͍
    ̐ɹػೳͷҧ͍
    ̑ɹ·ͱΊ

    View full-size slide

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

    View full-size slide

  20. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹΞʔΩςΫνϟͷҧ͍
    ̏ɹSQLͷҧ͍
    ̐ɹػೳͷҧ͍
    ̑ɹ·ͱΊ

    View full-size slide

  21. ΞʔΩςΫνϟͷҧ͍
    ߲໨%# .Z42- 1PTUHSF42-
    αʔόΞʔΩςΫνϟ ϚϧνεϨου Ϛϧνϓϩηε
    ετϨʔδΞʔΩςΫνϟ ߋ৽ܕ ௥هܕ
    ֦ுಛ௃ ετϨʔδΤϯδϯ ΤΫεςϯγϣϯ
    %JTD*0ΞʔΩςΫνϟ ϥϯμϜ γʔέϯγϟϧ

    View full-size slide

  22. ΞʔΩςΫνϟͷҧ͍
    ߲໨%# .Z42- 1PTUHSF42-
    αʔόΞʔΩςΫνϟ ϚϧνεϨου Ϛϧνϓϩηε
    ετϨʔδΞʔΩςΫνϟ ߋ৽ܕ ௥هܕ
    ֦ுಛ௃ ετϨʔδΤϯδϯ ΤΫεςϯγϣϯ
    %JTD*0ΞʔΩςΫνϟ ϥϯμϜ γʔέϯγϟϧ

    View full-size slide

  23. ΞʔΩςΫνϟͷҧ͍
    αʔόΞʔΩςΫνϟͷҧ͍
    w جຊతʹϚϧνεϨου .Z42-
    ͷํ͕༗ར
    w ίωΫγϣϯͷίετʹ͕ࠩग़Δ
    w ΫΤϦͷฒྻॲཧೳྗʹ͕ࠩग़Δ

    View full-size slide

  24. ΞʔΩςΫνϟͷҧ͍
    αʔόΞʔΩςΫνϟͷҧ͍
    w جຊతʹϚϧνεϨου .Z42-
    ͷํ͕༗ར
    w ίωΫγϣϯͷίετʹ͕ࠩग़Δ
    w ΫΤϦͷฒྻॲཧೳྗʹ͕ࠩग़Δ

    View full-size slide

  25. ΞʔΩςΫνϟͷҧ͍
    αʔόΞʔΩςΫνϟͷҧ͍
    w جຊతʹϚϧνεϨου .Z42-
    ͷํ͕༗ར
    w ίωΫγϣϯͷίετʹ͕ࠩग़Δ
    w ΫΤϦͷฒྻॲཧೳྗʹ͕ࠩग़Δ

    View full-size slide

  26. ΞʔΩςΫνϟͷҧ͍
    αʔόΞʔΩςΫνϟͷҧ͍
    w جຊతʹϚϧνεϨου .Z42-
    ͷํ͕༗ར
    w ίωΫγϣϯͷίετʹ͕ࠩग़Δ
    w ΫΤϦͷฒྻॲཧೳྗʹ͕ࠩग़Δ
    1PTUHSF42-͸ίωΫγϣϯͷͨͼʹϓϩηεੜ੒ GPSL
    ͕૸Δ

    View full-size slide

  27. ΞʔΩςΫνϟͷҧ͍
    αʔόΞʔΩςΫνϟͷҧ͍
    w جຊతʹϚϧνεϨου .Z42-
    ͷํ͕༗ར
    w ίωΫγϣϯͷίετʹ͕ࠩग़Δ
    w ΫΤϦͷฒྻॲཧೳྗʹ͕ࠩग़Δ

    View full-size slide

  28. ΞʔΩςΫνϟͷҧ͍
    αʔόΞʔΩςΫνϟͷҧ͍
    w جຊతʹϚϧνεϨου .Z42-
    ͷํ͕༗ར
    w ίωΫγϣϯͷίετʹ͕ࠩग़Δ
    w ΫΤϦͷฒྻॲཧೳྗʹ͕ࠩग़Δ
    .Z42-͸ಉҰεΩʔϚ಺Ͱ͸ϚϧνεϨουॲཧ͞Εͳ͍

    View full-size slide

  29. ΞʔΩςΫνϟͷҧ͍
    ߲໨%# .Z42- 1PTUHSF42-
    αʔόΞʔΩςΫνϟ ϚϧνεϨου Ϛϧνϓϩηε
    ετϨʔδΞʔΩςΫνϟ ߋ৽ܕ ௥هܕ
    ֦ுಛ௃ ετϨʔδΤϯδϯ ΤΫεςϯγϣϯ
    %JTD*0ΞʔΩςΫνϟ ϥϯμϜ γʔέϯγϟϧ

    View full-size slide

  30. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ

    View full-size slide

  31. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ

    View full-size slide

  32. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ
    σʔλͷҰ؏ੑΛ୲อͤ͞ΔͨΊͷ࣮ݱํ๏ͷ͜ͱ
    42-4FSWFS΍%#͸ϩοΩϯάϝΧχζϜ

    View full-size slide

  33. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ

    View full-size slide

  34. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ
    1PTUHSF42-͸.Z42-ΑΓ΋61%"5&͸஗͍ʢ͜ͱ͕ଟ͍
    ͔͠͠'*--'"$503Λௐ੔ͯ͠)05Λޮ͔͢ࣄͰ࠷ద͸ग़དྷΔ

    View full-size slide

  35. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ

    View full-size slide

  36. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ
    *OOP%#΋7"$66.Έ͍ͨͳύʔδॲཧ͕࣮͸͋Δ
    .Z42-͸ෳ਺ͷύʔδεϨου͕ฒྻ࣮ߦ͍ͯ͠Δ
    .Z42-͸ઐ༻εϨου͕ॲཧ͍ͯ͠Δ
    ͱ͸͍ͬͯ΋1PTUHSF42-ͷ7"$66.ΑΓ͸ѹ౗తʹϩʔίετ

    View full-size slide

  37. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ
    *OOP%#΋7"$66.Έ͍ͨͳύʔδॲཧ͕࣮͸͋Δ
    .Z42-͸ෳ਺ͷύʔδεϨου͕ฒྻ࣮ߦ͍ͯ͠Δ
    .Z42-͸ઐ༻εϨου͕ॲཧ͍ͯ͠Δ
    ͱ͸͍ͬͯ΋1PTUHSF42-ͷ7"$66.ΑΓ͸ѹ౗తʹϩʔίετ
    1PTUHSF42-ͷ7"$66.ͷΑ͏ʹؾʹ͢Δඞཁ͸΄ͱΜͲແ͍

    View full-size slide

  38. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ
    7"$66.ͬͯԿͬͯਓ͸ּݪ͞ΜͷԼهͷ63-ΛΫϦοΫ
    IUUQTECTUVEZDIVHPLVHJUIVCJPFWFOUTFWFOUIUNM

    View full-size slide

  39. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΞʔΩςΫνϟͷҧ͍
    w .7$$ͷ࣮ݱํ๏ͷҧ͍
    w ߋ৽ॲཧ 61%"5&ͱ%&-&5&
    ʹ͕ࠩग़Δ
    w ௥هܕ͔ͩΒ"VUP7"$66.ͱ)05͕͋Δ
    )05ͬͯԿͬͯਓ͸ּݪ͞Μͷ-FU`T1PTUHSFTͷهࣄΛΫϦοΫ
    IUUQMFUTQPTUHSFTRMKQEPDVNFOUTUVUPSJBMIPUIPU@

    View full-size slide

  40. ΞʔΩςΫνϟͷҧ͍
    ಺෦ߏ଄͔ΒֶͿ1PTUHSF42-

    View full-size slide

  41. ΞʔΩςΫνϟͷҧ͍
    ಺෦ߏ଄͔ΒֶͿ1PTUHSF42-
    1PTUHSF42-ͷΞʔΩςΫνϟΛΑ͘Θ͔Βͳ͍ਓʹΦεεϝ
    ͷ࿩ͳͷͰରԠͷվగ͕଴ͨΕΔ

    View full-size slide

  42. ΞʔΩςΫνϟͷҧ͍
    ߲໨%# .Z42- 1PTUHSF42-
    αʔόΞʔΩςΫνϟ ϚϧνεϨου Ϛϧνϓϩηε
    ετϨʔδΞʔΩςΫνϟ ߋ৽ܕ ௥هܕ
    ֦ுಛ௃
    ετϨʔδΤϯδϯ
    ϓϥάΠϯ
    '%8
    ΤΫεςϯγϣϯ
    %JTD*0ΞʔΩςΫνϟ ϥϯμϜ γʔέϯγϟϧ

    View full-size slide

  43. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΤϯδϯͱ'%8ͷҧ͍
    w ετϨʔδΤϯδϯ

    IBOEMFSϨΠϠʔΑΓ্Ͱ͋Ε͹ԿͰ΋ग़དྷΔ
    w '%8

    1PTUHSF42-ͷ֎෦ςʔϒϧͷΠϯλʔϑΣΠε

    View full-size slide

  44. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΤϯδϯͱ'%8ͷҧ͍
    w ετϨʔδΤϯδϯ

    IBOEMFSϨΠϠʔΑΓ্Ͱ͋Ε͹ԿͰ΋ग़དྷΔ
    w '%8

    1PTUHSF42-ͷ֎෦ςʔϒϧͷΠϯλʔϑΣΠε

    View full-size slide

  45. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΤϯδϯͱ'%8ͷҧ͍
    w ετϨʔδΤϯδϯ

    IBOEMFSϨΠϠʔΑΓ্Ͱ͋Ε͹ԿͰ΋ग़དྷΔ
    w '%8

    1PTUHSF42-ͷ֎෦ςʔϒϧͷΠϯλʔϑΣΠε
    *OOP%#Ұ୒ͳͷͰ࢖͏ൣғͰ͸͋·Γؾʹ͠ͳͯ͘ྑ͍
    ͨͩ͠.Z*4".͕γεςϜςʔϒϧ಺ʹ͸·ͩ࢒͍ͬͯΔ

    View full-size slide

  46. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΤϯδϯͱ'%8ͷҧ͍
    w ετϨʔδΤϯδϯ

    IBOEMFSϨΠϠʔΑΓ্Ͱ͋Ε͹ԿͰ΋ग़དྷΔ
    w '%8

    1PTUHSF42-ͷ֎෦ςʔϒϧͷΠϯλʔϑΣΠε

    View full-size slide

  47. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΤϯδϯͱ'%8ͷҧ͍
    w ετϨʔδΤϯδϯ

    IBOEMFSϨΠϠʔΑΓ্Ͱ͋Ε͹ԿͰ΋ग़དྷΔ
    w '%8

    1PTUHSF42-ͷ֎෦ςʔϒϧͷΠϯλʔϑΣΠε
    ଞͷ%#ͷςʔϒϧΛࣗ෼ͷςʔϒϧͷΑ͏ʹݟΔࣄ͕ग़དྷΔ
    ੵۃతʹ࢖͏ػձ͕ແ͍

    View full-size slide

  48. ΞʔΩςΫνϟͷҧ͍
    ετϨʔδΤϯδϯͱ'%8ͷҧ͍
    w ετϨʔδΤϯδϯ

    IBOEMFSϨΠϠʔΑΓ্Ͱ͋Ε͹ԿͰ΋ग़དྷΔ
    w '%8

    1PTUHSF42-ͷ֎෦ςʔϒϧͷΠϯλʔϑΣΠε
    ଞͷ%#ͷςʔϒϧΛࣗ෼ͷςʔϒϧͷΑ͏ʹݟΔࣄ͕ग़དྷΔ
    ੵۃతʹ࢖͏ػձ͕ແ͍
    .Z/"ɾ+16(ɹ߹ಉ%#ษڧձJO౦ژͰ'%8ͷൃදΛͨ͠ͷͰ
    ڵຯ͕͋Δਓ͸ͦͪΒΛࢀߟʹ
    IUUQECTUVEZDIVHPLVHJUIVCJPFWFOUTUPLZPIUNM

    View full-size slide

  49. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    View full-size slide

  50. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    View full-size slide

  51. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    View full-size slide

  52. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    View full-size slide

  53. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    .Z42-ͰNSPPOHB શจݕࡧ
    ͸ར༻͞ΕΔࣄ͕ଟ͍

    View full-size slide

  54. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    1PTUHSF42-͸QH@TUBU@TUBUFNFOUTΛ࢝Ίɺؾܰʹ࢖ΘΕͯΔ

    View full-size slide

  55. ΞʔΩςΫνϟͷҧ͍
    ϓϥάΠϯͱΤΫεςϯγϣϯͷҧ͍
    w ͲͪΒ΋$ͰΰϦΰϦॻ͍ͯ࡞Δ
    w ͲͪΒ΋ԿͰ΋ग़དྷΔ 3%#ͷൣғͰ

    w 1PTUHSF42-ͷํ͕࡞੒ྔ͕ଟ͍

    ࢲͷ؍ଌൣғͰ

    ͔͠͠"843%4Λ࢖ͬͯͨΓ͢ΔͱͲͬͪͷ%#΋ແྗ
    ͳͷͰશจݕࡧ͸$MPVE4FBSDIʹؙ౤͕͛ଟ͍

    View full-size slide

  56. ΞʔΩςΫνϟͷҧ͍
    ߲໨%# .Z42- 1PTUHSF42-
    αʔόΞʔΩςΫνϟ ϚϧνεϨου Ϛϧνϓϩηε
    ετϨʔδΞʔΩςΫνϟ ߋ৽ܕ ௥هܕ
    ֦ுಛ௃ ετϨʔδΤϯδϯ ΤΫεςϯγϣϯ
    %JTD*0ΞʔΩςΫνϟ ϥϯμϜ γʔέϯγϟϧ

    View full-size slide

  57. ΞʔΩςΫνϟͷҧ͍
    %JTD*0ΞʔΩςΫνϟͷҧ͍
    w .Z42-͸ϥϯμϜΞΫηεॏࢹ

    44%ͱ૬ੑ͕ྑ͍
    w 1PTUHSF42-͸γʔέϯγϟϧΞΫηεॏࢹ

    )%%ʹಛԽͨ͠࢓૊Έ

    View full-size slide

  58. ΞʔΩςΫνϟͷҧ͍
    %JTD*0ΞʔΩςΫνϟͷҧ͍
    w .Z42-͸ϥϯμϜΞΫηεॏࢹ

    44%ͱ૬ੑ͕ྑ͍
    w 1PTUHSF42-͸γʔέϯγϟϧΞΫηεॏࢹ

    )%%ʹಛԽͨ͠࢓૊Έ

    View full-size slide

  59. ΞʔΩςΫνϟͷҧ͍
    %JTD*0ΞʔΩςΫνϟͷҧ͍
    w .Z42-͸ϥϯμϜΞΫηεॏࢹ

    44%ͱ૬ੑ͕ྑ͍
    w 1PTUHSF42-͸γʔέϯγϟϧΞΫηεॏࢹ

    )%%ʹಛԽͨ͠࢓૊Έ
    'VTJPO*0ͱಛʹ૬ੑ͕ྑ͍
    )%%͔Β୅͑Δͱ਺ेഒͷύϑΥʔϚϯε͕ग़ͨΓ͢Δ

    View full-size slide

  60. ΞʔΩςΫνϟͷҧ͍
    %JTD*0ΞʔΩςΫνϟͷҧ͍
    w .Z42-͸ϥϯμϜΞΫηεॏࢹ

    44%ͱ૬ੑ͕ྑ͍
    w 1PTUHSF42-͸γʔέϯγϟϧΞΫηεॏࢹ

    )%%ʹಛԽͨ͠࢓૊Έ

    View full-size slide

  61. ΞʔΩςΫνϟͷҧ͍
    %JTD*0ΞʔΩςΫνϟͷҧ͍
    w .Z42-͸ϥϯμϜΞΫηεॏࢹ

    44%ͱ૬ੑ͕ྑ͍
    w 1PTUHSF42-͸γʔέϯγϟϧΞΫηεॏࢹ

    )%%ʹಛԽͨ͠࢓૊Έ
    )%%ʹ߹ΘͤΔͨΊฒ΂ସ͑ͯॻࠐ͍ͯ͠Δ
    44%ͷ࣌͸͜ͷฒ΂ସ͑ͷΦʔόʔϔου͕େ͖͍
    ͳͷͰ44%ʹͯ͠΋Կेഒ΋ߴ଎Խ͠ͳ͍ ໨҆͸਺ഒఔ౓

    View full-size slide

  62. ΞʔΩςΫνϟͷҧ͍
    ΞʔΩςΫνϟͷҧ͍ͷ·ͱΊ
    w .Z42-ͷํ͕εϐʔυॏࢹ
    w 1PTUHSF42-͸ػೳੑͱݎ࿚ੑॏࢹ
    w ΞʔΩςΫνϟ͔Βطʹํ޲ੑ͕໌ന

    View full-size slide

  63. ΞʔΩςΫνϟͷҧ͍
    ΞʔΩςΫνϟͷҧ͍ͷ·ͱΊ
    w .Z42-ͷํ͕εϐʔυॏࢹ
    w 1PTUHSF42-͸ػೳੑͱݎ࿚ੑॏࢹ
    w ΞʔΩςΫνϟ͔Βطʹํ޲ੑ͕໌ന
    1PTUHSF42-͸஗͍͔ʁͱ͍͏ͱͦ͏Ͱ͸ແ͍
    )%%ͰίωΫγϣϯ͕1PTUHSF42-ڐ༰ൣғͷ࣌͸.Z42-ͱൺֱͯ͠΋ૣ͍
    ಛʹ4&-&$5ʹؔͯ͠͸1PTUHSF42-ͷํ͕ૣ͍͜ͱ΋ଟ͍
    ͳͷͰ଎౓Λॏࢹͯ͠.Z42-ΛબͿ࣌͸େن໛Ҋ݅

    View full-size slide

  64. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹΞʔΩςΫνϟͷҧ͍
    ̏ɹSQLͷҧ͍
    ̐ɹػೳͷҧ͍
    ̑ɹ·ͱΊ

    View full-size slide

  65. SQLͷҧ͍
    .Z42-ͱ1PTUHSF42-ͷؒʹ
    ޓ׵ੑ͸ແ͍ʹ౳͍͠

    View full-size slide

  66. SQLͷҧ͍
    .Z42-͸গػೳͰ1PTUHSF42-͕ଟػೳ
    ˣ
    ͭ·Γ42-ʹؔͯ͠͸.Z42-1PTUHSF42-

    View full-size slide

  67. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕͷൺֱ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍

    View full-size slide

  68. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕͷൺֱ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍

    View full-size slide

  69. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕͷൺֱ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ௨ৗͷ4&-&$5ɺ*/4&35ɺ61%"5&ɺ%&-&5&͸໰୊ͳ͠
    όϧΫΠϯαʔτ΋ରԠ
    Ұൠతͳؔ਺͸͋Δ͕1PTUHSF42-ͱ͸໊લ͕ҧ͏΋ͷ΋ଟ͍
    ࣅͨΑ͏ͳ໊લͰ΋ڍಈ͕ҧͬͨΓ͢Δ

    View full-size slide

  70. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕͷൺֱ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ௨ৗͷ4&-&$5ɺ*/4&35ɺ61%"5&ɺ%&-&5&͸໰୊ͳ͠
    όϧΫΠϯαʔτ΋ରԠ
    Ұൠతͳؔ਺͸͋Δ͕1PTUHSF42-ͱ͸໊લ͕ҧ͏΋ͷ΋ଟ͍
    ࣅͨΑ͏ͳ໊લͰ΋ڍಈ͕ҧͬͨΓ͢Δ
    ɹྫɿ༵೔ΛऔΓग़ؔ͢਺
    ɾ.Z42-ˠEBUF@GPSNBU UJNF zX

    ɹ͔Β࢝·Γɺ೔༵೔ʹ֘౰͢Δ
    ɾ1PTUHSF42-ˠɹUP@DIBS UJNF `%

    ɹ͔Β࢝·Γɺ೔༵೔ʹ֘౰͢Δ

    View full-size slide

  71. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ͪͳΈʹ.Z42-͸τϥϯβΫγϣϯதʹ%%-Λྲྀ͢ͱDPNNJU͕૸Δ
    ͭ·ΓϩʔϧόοΫग़དྷͳ͍ʂʂ

    View full-size slide

  72. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍

    View full-size slide

  73. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    */4&35࣌ʹະࢦఆͳ஋Λࣗಈิ׬ͨ͠Γ͢Δ
    ྫEBUFUJNFͳΧϥϜʹ/6--ˠ

    (3061#:ͷ4&-&$5۟ʹະࢦఆͳΧϥϜΛࢦఆͰ͖Δ
    ର৅͕ϢχʔΫͰͳ͍৔߹͸Կ͕ग़Δ͔͸Θ͔Βͳ͍ͷͰόάͷԹচ

    View full-size slide

  74. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    */4&35࣌ʹະࢦఆͳ஋Λࣗಈิ׬ͨ͠Γ͢Δ
    ྫEBUFUJNFͳΧϥϜʹ/6--ˠ

    (3061#:ͷ4&-&$5۟ʹະࢦఆͳΧϥϜΛࢦఆͰ͖Δ
    ର৅͕ϢχʔΫͰͳ͍৔߹͸Կ͕ग़Δ͔͸Θ͔Βͳ͍ͷͰόάͷԹচ

    ͦ΋ͦ΋1PTUHSF42-Ͱ͸͸Τϥʔ
    ʢJOpOJUZ૬౰ʣ
    ͪͳΈʹ1)1ͷEBUFUJNFΦϒδΣΫτͰ΋Τϥʔ

    View full-size slide

  75. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    */4&35࣌ʹະࢦఆͳ஋Λࣗಈิ׬ͨ͠Γ͢Δ
    ྫEBUFUJNFͳΧϥϜʹ/6--ˠ

    (3061#:ͷ4&-&$5۟ʹະࢦఆͳΧϥϜΛࢦఆͰ͖Δ
    ର৅͕ϢχʔΫͰͳ͍৔߹͸Կ͕ग़Δ͔͸Θ͔Βͳ͍ͷͰόάͷԹচ

    4&-&$5JE BHF'30.VTFS(3061#:JE
    ্هͷΫΤϦͰBHFʹͱ͕͋Δ৔߹ʹͲͪΒ͕ग़Δ͔͸ෆ໌
    Ϩίʔυͷঢ়ଶʹΑͬͯ஋͕มΘΔͷͰόάͷݩʹΑ͘ͳΔ
    42-ΞϯνύλʔϯͷΞϯΪϡΞεάϧʔϓ ᐆດͳάϧʔϓ
    ͱͯ͠༗໊

    View full-size slide

  76. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    */4&35࣌ʹະࢦఆͳ஋Λࣗಈิ׬ͨ͠Γ͢Δ
    ྫEBUFUJNFͳΧϥϜʹ/6--ˠ

    (3061#:ͷ4&-&$5۟ʹະࢦఆͳΧϥϜΛࢦఆͰ͖Δ
    ର৅͕ϢχʔΫͰͳ͍৔߹͸Կ͕ग़Δ͔͸Θ͔Βͳ͍ͷͰόάͷԹচ

    42-ϞʔυͰ্هͷ໰୊Λղܾग़དྷΔ
    ݫ੍͍͠໿ʹมߋग़དྷΔ

    ௨শɿLBNJQP53"%*5*0/"-

    View full-size slide

  77. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    จࣈྻͷൺֱ͸1PTUHSF42-͸ӳࣈͷখจࣈͱେจࣈΛ۠ผ͢Δ
    .Z42-͸ӳࣈͷখจࣈͱେจࣈΛ۠ผ͠ͳ͍
    ΋۠͠ผ͍ͤͨ͞৔߹͸όΠφϦܕΛར༻͢Δ
    ·ͨσϑΥϧτͷর߹ॱংͰ͸ʮϋϋύύόόʯ໰୊͕ൃੜ͢Δ
    ֆจࣈ΋۠ผ͠ͳ͍

    VUGNC@VOJDPEF@DJΛࢦఆ͢Ε͹্هͷ໰୊͸ൃੜ͠ͳ͍
    ٯʹ1PTUHSF42-ͰখจࣈͱେจࣈΛൺֱ͠ͳ͍ܕ͸ແ͍ͷͰ࡞Δ͔͠ແ͍

    View full-size slide

  78. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ͪͳΈʹ.Z42-͸4+*4ͩͱEBUFUJNFܕʹ*/%&9͕ޮ͔ͳ͍ͷͰ65'Ұ୒
    ܕʹؔ͢Δ໰୊͸1PTUHSF42-࢖͍͕Ұ൪࠷ॳʹυϋϚϦ͢Δ᠘͕ଟ͍෦෼

    View full-size slide

  79. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍

    View full-size slide

  80. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    8JOEPXؔ਺͕ແ͍ͷͰQBSUJUJPOࢦఆͷू໿͸42-ͰରԠ͢Δͷ͸೉͍͠
    $0//&$5#:΋ແ͍ͷͰઃܭʹ͓͍ͯ਌ࢠؔ܎Λදݱ͢Δࡍ͸ཁݕ౼
    ࢉज़ԋࢉࢠ΋ҧ͍Λଟ͍ͷͰ஫ҙ ͋Μ·Γ࢖Θͳ͍͚Ͳ

    View full-size slide

  81. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    αϒΫΤϦ΋1PTUHSF42-ʹൺ΂Δͱ஗͍
    ͦΕͰ΋.Z42-Ͱେ෼ૣ͘ͳͬͨ
    ૬ؔαϒΫΤϦ͸࢖Θͳ͍ํ͕ྑ͍
    ʢ.Z42-Ҏલ͸αϒΫΤϦΛ౤͛Δͱ%#ݻ·ͬͨΓͯͨ͠ʣ
    ͋ͱ.Z42-ʹ͸8*5)۟΋3&563/*/(۟ແ͍

    View full-size slide

  82. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ΫΤϦͰؤுΒͣʹΞϓϦέʔγϣϯଆͰॲཧͨ͠ํ͕ૣ͍৔߹͕ଟ͍
    ʢྫϥϯΩϯάදࣔͳͲʣ
    γϯϓϧͳΫΤϦͰࡁΉΑ͏ͳઃܭྗ͕໰ΘΕΔ

    View full-size slide

  83. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ͪͳΈʹ.Z42-ͷ+0*/ͷΞϧΰϦζϜ͸/FTUFE-PPQ+PJO͔͠ͳ͍
    ͋ͱ.Z42-ʹ͸'VMM0VUFS+0*/΋ແ͍
    ଞʹ΋*/5&34&$5ͱ&9$&15΋ͳ͍

    View full-size slide

  84. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍
    ͪͳΈʹ.Z42-ͷ+0*/ͷΞϧΰϦζϜ͸/FTUFE-PPQ+PJO͔͠ͳ͍
    ͋ͱ.Z42-ʹ͸'VMM0VUFS+0*/΋ແ͍
    ଞʹ΋*/5&34&$5ͱ&9$&15΋ͳ͍
    42-ྗ͕ߴ͍ਓ΄Ͳ.Z42-Ͱෆຬ͕ग़Δ
    ઃܭ͕͔ͬ͠Γ͍ͯ͠Ε͹͋·Γ࢖Θͳ͍ͷͰ໰୊͸গͳ͍

    View full-size slide

  85. SQLͷҧ͍
    .Z42-ͷ42-
    w ؔ਺΍ߏจͷҧ͍͕ଟ͍ 3&1-"$&จͳͲ

    w ܕ͕؇͍ 42-ϞʔυͰมߋ͸ग़དྷΔ

    w 8JOEPXTؔ਺ͳͲະ࣮૷΋ଟ͍

    View full-size slide

  86. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .FSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-

    View full-size slide

  87. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .FSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-
    ݱঢ়Ͱ΋8*5)۟ʴ3&563/*/(۟Ͱ࣮ݱ͸ग़དྷΔ
    ૣ͘ແ͍ͷͰඞཁͳΒτϦΨʔॻ͍ͨํ͕͍͍͔΋

    View full-size slide

  88. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .BSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-
    ݱঢ়Ͱ΋8*5)۟ʴ3&563/*/(۟Ͱ࣮ݱ͸ग़དྷΔ
    ૣ͘ແ͍ͷͰඞཁͳΒτϦΨʔॻ͍ͨํ͕͍͍͔΋
    ͔͠͠1PTUHSF42-Ͱ
    */4&350/$0/'-*$5%0/05)*/(61%"5&
    ͕ग़དྷΔͷͰࠓޙ͸όοτϊ΢ϋ΢ͳͷͰ֮͑Δඞཁͳ͠

    View full-size slide

  89. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .BSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-

    View full-size slide

  90. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .BSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-
    .BSHFจͷ࿩΋ؚΊɺ42-ͷ࿩͸
    ୈ۝ճதࠃ஍ํ%#ษڧձJOถࢠ
    Ͱ࿩Λͨ͠ͷͰڵຯ͕͋Δਓ͸Լهͷ63-ΛΫϦοΫ
    IUUQTECTUVEZDIVHPLVHJUIVCJPFWFOUTFWFOUIUNM

    View full-size slide

  91. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .BSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-

    View full-size slide

  92. SQLͷҧ͍
    1PTUHSF42-ͷ42-
    w .BSHFจ͕ແ͍ ͰͦΕ૬౰ͷߏจ͕௥Ճ

    w Ϣʔβఆٛม਺͕ແ͍
    w 42-ʹؔͯ͠ݴ͑͹1PTUHSF42-.Z42-
    ಉ͡ײ֮ͰΫΤϦΛॻ͘ͱ௧͍໨ʹ͋͏
    ࣮ߦܭըΛݟΔ͜ͱ͸େࣄ
    */%&9ͷޮ͖ํ΋ҧ͏͜ͱ͕͋Δ

    View full-size slide

  93. SQLͷҧ͍
    42-ٯҾ͖େશͷۃҙ

    View full-size slide

  94. SQLͷҧ͍
    42-ٯҾ͖େશͷۃҙ
    .Z42-ͱ1PTUHSF42-ͷ*/%&9ͷҧ͍ΛؚΊͨ42-ͷॻ͖ํ͕·ͱ·ͬͨຊ
    ͨͩ͠ɺ಺༰͕ͪΐͬͱݹ͍ ͷຊ

    ˞࠷৽൛ͷվగ·ͩͰ͔͢ʁ

    View full-size slide

  95. SQLͷҧ͍
    42-࣮ફೖ໳

    View full-size slide

  96. SQLͷҧ͍
    42-࣮ફೖ໳
    1PTUHSF42-Λϕʔεʹͨ͠42-ͷجૅతͳ࢖͍ํͷຊ
    8JOEPXTؔ਺΍$"4&ͷ࢖͍ํ΍αϒΫΤϦͷ࢖͍ํͷษڧʹͳΔ
    .Z42-͔Β1PTUHSF42-ʹདྷͨਓʹΦεεϝ
    ˞͔͠͠ݪஶ͕ݹ͍
    8)&3&ʹ*4/6--͋Δͱ*/%&9ޮ͔ͳ͍ͱ͔ॻ͍ͯ͋Δ
    ͪͳΈʹ1PTUHSF42- Ҏ߱
    ΋.Z42- ܥ͸࣮֬
    ΋*/%&9ޮ͖·͢
    ͪͳΈʹ*4/05/6--΋ޮ͖·͢

    View full-size slide

  97. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹΞʔΩςΫνϟͷҧ͍
    ̏ɹSQLͷҧ͍
    ̐ɹػೳͷҧ͍
    ̑ɹ·ͱΊ

    View full-size slide

  98. ػೳͷҧ͍
    42-ͱಉ༷ͷؔ܎

    View full-size slide

  99. ػೳͷҧ͍
    42-ͱಉ༷ͷؔ܎
    ˣ
    .Z42-1PTUHSF42-

    View full-size slide

  100. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल

    View full-size slide

  101. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल

    View full-size slide

  102. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल
    ͭͷςʔϒϧʹτϦΨʔ
    .Z42-ͷτϦΨʔ͸'03&"$)308ͷΈΛαϙʔτ
    ͦ΋ͦ΋.Z42-ͰετΞυ͕ඞཁͳ࣌͸ઃܭΛ࠶ݕ౼ͨ͠ํ͕͍͍

    View full-size slide

  103. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल

    View full-size slide

  104. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल
    7JFXʹ଎౓తͳݶք͕དྷͨΒதؒςʔϒϧΛ࡞Δ͔͠ແ͍
    ͦ΋ͦ΋7JFXΛඞཁ͢ΔΑ͏ͳΫΤϦ͸଎౓͕ग़ͳ͍

    View full-size slide

  105. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल

    View full-size slide

  106. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल
    .)"GPS.Z42-͕͍͢͝
    ࣗಈϑΣΠϧΦʔόʔ
    ϚελʔͷແఀࢭϝϯςφϯεՄೳ
    1(3&9ͷੌ͍൛

    View full-size slide

  107. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल
    QHBENJOͱ͸ൺֱʹͳΒͳ͍΄Ͳ༏ल
    &3ਤͷϦόʔεΤϯδχΞϦϯά΋Մೳ
    ϚϧνϓϥοτϑΥʔϜͰಈ͘ .BD΋8JOEPXT΋Մ

    View full-size slide

  108. ػೳͷҧ͍
    .Z42-ͷػೳ
    w ετΞυ΋τϦΨʔ΋ॻ͚Δ
    w ϚςϏϡʔ͕ແ͍
    w ϨϓϦέʔγϣϯ͸Ұ೔ͷ௕͕͋Δ
    w (6*πʔϧ .Z42-8PSLCFODI
    ͕༏ल
    QHBENJOͱ͸ൺֱʹͳΒͳ͍΄Ͳ༏ल
    &3ਤͷϦόʔεΤϯδχΞϦϯά΋Մೳ
    ϚϧνϓϥοτϑΥʔϜͰಈ͘ .BD΋8JOEPXT΋Մ

    ࣍ͷσϞ͠·͢
    w 6*্Ͱͷ%%-૬౰ͷૢ࡞
    w ϦόʔεΤϯδχΞϦϯά
    w ϑΥʔϚολͱ7JTVBM&YQMBJO


    View full-size slide

  109. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋

    View full-size slide

  110. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋

    View full-size slide

  111. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋
    (JUIVCͰ؅ཧͯ͠ΔͷͰޡࣈ୤ࣈΛݟ͚ͭͨΒϓϧϦΫΤετʂ
    ಡΜͰҙຯ͕Θ͔Βͳ͍৔߹͸JTTVFTΛ࡞Δʂʂ
    IUUQTHJUIVCDPNQHTRMKQKQVHEPD

    View full-size slide

  112. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋

    View full-size slide

  113. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋
    ᖒా͞Μͱ͵͜͞Μʹฉ͚͹େମڭ͑ͯ͘ΕΔ
    ͋ͱʮࣰాͷދͷרʯͰάάΔͱ޾ͤʹͳΕΔʢଟ෼
    ͜Εʹ׳ΕΔͱ1PTUHSF42-͔Βग़Εͳ͘ͳΔ
    ࠷ۙͩͱωοτϫʔΫΞυϨεܕʹٹΘΕͨ *1WରԠ

    View full-size slide

  114. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋
    ᖒా͞Μͱ͵͜͞Μʹฉ͚͹େମڭ͑ͯ͘ΕΔ
    ͋ͱʮࣰాͷދͷרʯͰάάΔͱ޾ͤʹͳΕΔʢଟ෼
    ͜Εʹ׳ΕΔͱ1PTUHSF42-͔Βग़Εͳ͘ͳΔ
    ࠷ۙͩͱωοτϫʔΫΞυϨεܕʹٹΘΕͨ *1WରԠ

    શ෦ղܾͯ͘͠Εͨ
    w *1WΛΠϯΫϦϝϯτ͍͚ͨ͠ͲJOUʹग़དྷͳ͍໰୊
    w *1WͰιʔτ͢Δͷ໘౗͍͘͞໰୊
    w *1WͰൣғݕࡧ͢Δͷେม໰୊

    View full-size slide

  115. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋

    View full-size slide

  116. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋
    .Z42-ʹ͸$)&$,੍໿͕ແ͍
    ͚ͲΫΤϦ͸௨Δʂ8IZ.Z42-QFPQMFʂ
    .Z42-͸σʔλΛकΔ࢓૊Έ͸গͳ͍

    View full-size slide

  117. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋

    View full-size slide

  118. ػೳͷҧ͍
    1PTUHSF42-ͷػೳ
    w ೔ຊޠυΩϡϝϯτΛࢀߟ
    w ๛෋ͳܕͱઐ༻ͷݕࡧػೳʢ+40/ܕͳͲʣ
    w $)&$,੍໿
    w */%&9ͷछྨ͕๛෋
    .Z42- *OOP%#
    ͸#USFFΠϯσοΫε͔͠ແ͍
    .Z42-͸ΫΤϦͰ࢖͑ΔΠϯσοΫε͸Ұͭ
    .Z42-ʹ͸ࣜΠϯσοΫε͕ແ͍
    .Z42-ʹ͸෦෼ΠϯσοΫε΋ແ͍

    View full-size slide

  119. ͋͐͡Μͩ
    ̍ɹࣗݾ঺հ
    ̎ɹΞʔΩςΫνϟͷҧ͍
    ̏ɹSQLͷҧ͍
    ̐ɹػೳͷҧ͍
    ̑ɹ·ͱΊ

    View full-size slide

  120. ·ͱΊ
    .Z42-͸εϐʔυॏࢹ

    View full-size slide

  121. ·ͱΊ
    .Z42-͸εϐʔυॏࢹ
    ˣ
    γϯϓϧ͕ͩػೳ͕গͳ͍

    View full-size slide

  122. ·ͱΊ
    1PTUHSF42-͸ػೳੑͱݎ࿚ੑॏࢹ

    View full-size slide

  123. ·ͱΊ
    1PTUHSF42-͸ػೳੑͱݎ࿚ੑॏࢹ
    ˣ
    ߴػೳ͕ͩݶք஋͸.Z42-ΑΓ௿͍

    View full-size slide

  124. ·ͱΊ
    IUUQTUXJUUFSDPNTPVEBJTUBUVT

    View full-size slide

  125. ·ͱΊ
    .Z42-ͷϚον͢Δར༻γʔϯ
    w େྔͷߋ৽΍ࢀর͕ඞཁͳ৔߹
    w ୯७ͳΫΤϦΛେྔʹࡹ͘ඞཁ͕͋Δ৔߹
    w ϨϓϦέʔγϣϯ΍ύʔςʔγϣϯΛར༻
    ͨ͠ෛՙ෼ࢄ͕ඞཁͳ৔߹
    w αϙʔτ 0SBDMF
    Λ͓ۚͰԥΓ͍ͨ৔߹

    View full-size slide

  126. ·ͱΊ
    1PTUHSF42-ͷϚον͢Δར༻γʔϯ
    w খن໛ͳαʔϏε ελʔτΞοϓͱ͔

    w ूܭ΍෼ੳ͕ඞཁͳαʔϏε
    w σʔλͷ੔߹ੑ͕ॏཁͳαʔϏε
    w தখاۀͷۀ຿ܥαʔϏε
    w ͱΓ͋͑ͣ1PTUHSF42-

    View full-size slide

  127. ·ͱΊ
    .Z42-
    ˣ
    աڈɿ8FCαʔϏε

    View full-size slide

  128. ·ͱΊ
    .Z42-
    ˣ
    աڈɿ8FCαʔϏε
    ˣ
    ݱࡏɿτϥϯβΫγϣϯ͕ඞཁͳେن໛Ҋ݅

    View full-size slide

  129. ·ͱΊ
    1PTUHSF42-

    View full-size slide

  130. ·ͱΊ
    1PTUHSF42-
    ˣ
    աڈɿۀ຿ܥ

    View full-size slide

  131. ·ͱΊ
    1PTUHSF42-
    ˣ
    աڈɿۀ຿ܥ
    ˣ
    ݱࡏɿσʔλͷར༻ͱอक͕ඞཁͳҊ݅

    View full-size slide

  132. ·ͱΊ
    8FC΋ۀ຿ܥ΋ؔ܎ͳ͍

    View full-size slide

  133. ·ͱΊ
    8FC΋ۀ຿ܥ΋ؔ܎ͳ͍
    ˣ
    8FC΋ෳࡶԽۀ຿ܥͷϏοΫσʔλԽ

    View full-size slide

  134. ·ͱΊ
    αʔϏεͷछྨͰ͸ͳ͘
    σʔλͷར༻ํ๏
    Ͱ3%#ΛબͿ͕ྑ͍

    View full-size slide

  135. ·ͱΊ
    దࡐదॴͰબͼ·͠ΐ͏

    View full-size slide

  136. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ

    View full-size slide