2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

1.

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

2.

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

3.

What is it? લ൒ઓΛऴ͑ͯ

4.

What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ

5.

What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ ΠϯυͱΠϯυωγΞ͘Β͍ҧ͏

6.

What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏

7.

What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏ ྨࣅྫҰཡ ΠϯυͱΠϯυωγΞҧ͏
,0'ͷژͱ,0'ͷژ͘Β͍ҧ͏ ετͷϦϡ΢ͱέϯ͘Β͍ҧ͏ ए೫Ֆͱو೫Ֆ͘Β͍ҧ͏ ϙέϞϯͱ༯ո΢Υον͘Β͍ҧ͏ લా݈ଠͱલాஐಙ͘Β͍ҧ͏ ʜͳͲ

8.

What is it? ͭ·Γ͸ಉ͡3%#Ͱ΋݁ߏҧ͏

9.

What is it? Ͱ΋ػೳͷҧ͍͚ͩͰ͸ઓྗͷҧ͍ʹͳΒͳ͍

10.

What is it? Ћͷ෦෼Λ͝঺հ͠·͢

11.

What is it? લఏ৚݅ લ൒ઓͷ࿩Λௌ͍ͯΔ͜ͱ·ͨ͸ݟͯΔ͜ͱ

12.

What is it? લఏ৚݅ ଓɾ1PTUHSF42-ŧŔŕŪƂŜſ

13.

What is it? લఏ৚݅ ଓɾ1PTUHSF42-ŧŔŕŪƂŜſ ˣ ࠷৽൛ͱ͔1PTUHSF42-ͷ᠘ͷ࿩͸ͳ͍Ͱ͢

14.

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

15.


16.

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

17.

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

18.

தࠃ஍ํDBษڧձ https://dbstudychugoku.github.io/

19.


20.

ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ
ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL

21.


22.


23.

ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ

24.

ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ ࠓ೔ͷަ௨අ͸+16(ʹࢧԉͯ͠΋Βͬͯ·͢

25.

ίϛϡχςΟͷҧ͍ ϢʔβձͷΞ΢τϓοτͷҧ͍ w +16(͸υΩϡϝϯτ͸ίϛϡχςΟͰ࡞੒ w .Z/"͸ݸʑͷΞ΢τϓοτʹҕͶΔ  ެࣜυΩϡϝϯτ͸0SBDMF͕࡞੒ w ษڧձ͸ͲͪΒ΋ਵ࣌ओମͰߦ͍ͬͯΔ

26.

ίϛϡχςΟͷҧ͍ TMBDL͕ؾܰʹ࣭໰Ͱ͖ͯϨεϙϯε΋ྑ͍ .Z42-ɿIUUQNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN 1PTUHSF42-ɿIUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN

27.

ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ

28.

ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ ˣ ࠓ͙͢ϑΥϩʔ͢΂͖ΤϯδχΞϦετ

29.

ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ ˣ ࠓ͙͢ϑΥϩʔ͢΂͖ΤϯδχΞϦετ େମࠓ೔ͷ࿩͸͜ͷਓͨͪΛݟͯΕ͹ࣗવͱ֮͑Δ

30.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ

31.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !3,BKJZBNB

32.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !LBNJQP

33.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !ZZBNBTBLJ

34.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !OJQQPOEBOKJ

35.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !ZPLV

36.

ίϛϡχςΟͷҧ͍ ԶΑΓڧ͍.Z42-ΤϯδχΞʹձ͍ʹߦ͘ ೔ຊ.Z42-Ϣʔβձձʢ.Z/"ձʣಛผฤ Ϣʔβձप೥ه೦ύʔςΟ ʙϢʔβձͱ.Z42-ͷ೥ΛৼΓฦΔʂʙ ։࠵೔෇ɿ೥݄೔ ۚ ։࠵࣌ࠁɿΛ༧ఆ ձ৔ɿגࣜձࣾίϩϓϥ
ʢ౦ژɾܙൺणΨʔσϯϓϨΠελϫʔ֊ʣ

37.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ

38.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ 1PTUHSF42-ͳਓɺ5XJUUFS࢖ͬͯͳ͍໰୊

39.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !GVKJJ@NBTBP

40.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !TOBHB

41.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !T

42.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !TBXBEB@NBTBIJLP

43.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !OPCPSVT

44.

ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !OVLP@ZPLPIBNB

45.

ίϛϡχςΟͷҧ͍ 1PTUHSF42-ΧϯϑΝϨϯε ೔࣌ɿ೥݄೔ ۚ ɹʙ ৔ॴɿ"1඼઒ɹ ౦ژ౎ߓ۠ߴྠ౦ٸୈೋϏϧ ಺༰ɿޕલجௐߨԋΛؚΉߨԋΛ༧ఆ ޕޙτϥοΫʹͯߨԋఔ౓Λ༧ఆɻ
ΧϯϑΝϨϯεऴྃޙʹ࠙਌ձ͕͋Γ·͢ɻ ࢀՃਓ਺ݟࠐΈɿ໊ ҰൠࢀՃ໊ఔ౓ ࢀՃඅɿ ԁΛ༧ఆ IUUQXXXQPTUHSFTRMKQFWFOUTKQVHQHDPO

46.


47.

ϋϚϦͲ͜ΖͷTips ͓଴ͨͤ͠·ͨ͠ ຊ೔ͷϝΠϯͰ͢

48.

ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋
w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ

49.


50.

ϋϚϦͲ͜ΖͷTips 4&-&$5 '30.TBNQMF JE HSPVQ OBNF BHF ޿ౡ 4POF
޿ౡ TPOF ෱ࢁ TPVEBJ ෱ࢁ UBLFUPNP

51.

ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group`

52.

ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group` HSPVQ͕༧໿ޠͳͷͰAͰғΉ

53.

ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF ޿ౡ ෱ࢁ

54.

ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF ޿ౡ ෱ࢁ
6OJRVFͰ͸ແ͍ͷͰԿ͕ग़Δ͔͸Θ͔Βͳ͍

55.

ϋϚϦͲ͜ΖͷTips LBNJQP53"%*5*0/"-

56.

ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP
BY `group`;

57.

BY `group`;

58.

BY `group`; .Z42-ͷಠ֦ࣗுΛແޮʹ͢Δ

59.

BY `group`; ΋ͪΖΜNZDPOGʹ͔͍ͯ΋ྑ͍

60.

w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ w ࢖͑Δͷ͸ͭ

61.

root͸2౓ࢗ͢ ——ΞΧ΢ϯτΛ֬ೝ͢Δ SELECT user , host FROM user;

62.

ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU SPPU SPPU MPDBMIPTU

63.

ͦΕͧΕผϢʔβ

64.

ΞΫηεग़དྷΔIPTU

65.

QH@ICB@DPOG૬౰

66.


67.

ᐆດͳ஋ SELECT * FROM sample WHERE name = 'sone'

68.

ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF ޿ౡ 4POF
޿ౡ TPOF

69.

޿ౡ TPOF

70.

޿ౡ TPOF େจࣈখจࣈΛൺֱͯ͠ͳ͍

71.


72.

ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ
ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P

73.

ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P .Z42-ͷσϑΥϧτ

74.

ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P 1PTUHSF42-ͷσϑΥϧτ

75.

ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫ w .Z42-ͷσϑΥϧτ͸3&1&"5"#-&3&"% w *OOPEC͸ߋ৽ର৅ͷߦ͚ͩΛϩοΫͰ͸ͳ͍ʂ w ༧૝֎ͷϩοΫΛऔಘ͢Δ w ߋ৽ॲཧͳͲͰϩοΫ଴ͪ౳͕ൃੜ͢Δ͜ͱ͕͋Δ

76.

ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫ w .Z42-ͷσϑΥϧτ͸3&1&"5"#-&3&"% w *OOPEC͸ߋ৽ର৅ͷߦ͚ͩΛϩοΫͰ͸ͳ͍ʂ w ༧૝֎ͷϩοΫΛऔಘ͢Δ w ߋ৽ॲཧͳͲͰϩοΫ଴ͪ౳͕ൃੜ͢Δ͜ͱ͕͋Δ

77.

ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5
AND id <= 10 FOR UPDATE; commit;

78.

ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5
AND id <= 10 FOR UPDATE; commit; ൣғΛࢦఆͯ͠ϩοΫΛऔಘ

79.

ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test');

80.

ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35

81.

ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35
͜ͷ*/4&35͸଴ͨ͞ΕΔʂʂ

82.

ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

83.

ؒͷۭߦ΁*/4&35

84.

8)&3&JEͳͲ͸ةݥ

85.

ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ

86.

ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ ˣ ߋ৽ߦͷલޙͷϩοΫΛऔΔ

87.

ϋϚϦͲ͜ΖͷTips ௕͍ͷͰଓ͖͸8FCͰ !LBNJQP͞ΜͷϒϩάΛҾ༻ *OOP%#ͷϩοΫͷൣғͱωΫετΩʔϩοΫͷ࿩ IUUQCMPHLBNJQPOFUFOUSZ

88.


89.

MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛

90.

MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛ ˣ ͦΖͦΖਖ਼ࣜ൛͕ग़Δ

91.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ

92.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ ˣ ࢒೦ɺ๯಄Ͱ΋৮Ε·͕ͨ͠આ໌͠·ͤΜ

93.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

94.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42- ˣ ϧʔΫɺʮࣰాͷދͷרͦͷ̐ʯΛ࢖͑ ελʔɾ΢Υʔζݟͨ͜ͱແ͍͚Ͳ

95.

MySQL 5.7ͱPostgreSQL 9.5 ஶऀͷࣰా͞Μ

96.

MySQL 5.7ͱPostgreSQL 9.5 ஶऀͷࣰా͞Μ ˣ ୈճதࠃ஍ํ%#ษڧձJOग़Ӣ Ͱ1PTUHSF42-ͷ࿩Λͯ͘͠Ε·͢

97.

MySQL 5.7ͱPostgreSQL 9.5 ͋ͱᖒా͞Μ͕1PTUHSF42-ৄ͍͠

98.

MySQL 5.7ͱPostgreSQL 9.5 ͋ͱᖒా͞Μ͕1PTUHSF42-ৄ͍͠ ˣ 1PTUHSF42-৽ػೳ঺հ IUUQXXXTMJEFTIBSFOFUIBEPPQYOUUEBUBQPTUHSFTRMOFXGFBUVSFTOUUEBUB ֆͱ͔͍ͬͺ͍͋ΔͷͰॳ৺ऀʹ΋༏͍͠ࢿྉͱͳ͓ͬͯΓ·͢

99.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ΧϯϑΝϨϯε ߦͬͨΒ୭͔࿩ͯ͠ΔΑ ʢଟ෼ɺ͖ͬͱɺ.BZCFʣ

100.

MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ

101.

MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ ˣ தࠃ஍ํ%#ษڧձʹஔ͍ͯ͋ΔΑ IUUQTECTUVEZDIVHPLVHJUIVCJP

102.

MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ ˣ தࠃ஍ํ%#ษڧձʹஔ͍ͯ͋ΔΑ IUUQTECTUVEZDIVHPLVHJUIVCJP ͔͠΋ಈը෇͖

103.

MySQL 5.7ͱPostgreSQL 9.5 தࠃ஍ํ%#ษڧձ ୈճ.Z42-ͷ࠷৽ࣄ৘ ֿࢁ͞Μ ୈճ.Z42-࠷৽ࣄ৘ ֿࢁ͞Μ
ୈճ.Z42-3$ొ৔ʂ࣍ͷ.Z42-͸͕͜͜ҧ͏ͬʂ ֿࢁ͞Μ ୈճ.Z42-։ൃ࠷৽ಈ޲ ࢁ࡚͞Μ ͦͷதͰ͍͔ͭ͘ϐοΫΞοϓ

104.

MySQL 5.7ͱPostgreSQL 9.5 ιʔείʔυ͕HJUIVCͰެ։͞Εͨ ެࣜϦϙδτϦ IUUQTHJUIVCDPNNZTRM .Z42-ຊମҎ֎ʹ΋໘ന͍΋ͷ͕୔ࢁʂ

105.

MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ
w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ

106.

w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ

107.

MySQL 5.7ͱPostgreSQL 9.5

108.

MySQL 5.7ͱPostgreSQL 9.5

109.

w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ ಛʹߴෛՙ͕࣌ૣ͘ͳͬͨ

110.

MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

111.

·ͩ1PTUHSF42-ͷํ͕Ұ೔ͷ௕͕͋Δ

112.

.Z42-ຊମͰࣗಈϑΣΠϧΦʔόʔΛαϙʔτ 1PTUHSF42-ίϛολ༷ɺ·ͩͰ͔͢ʁ

113.

MySQL 5.7ͱPostgreSQL 9.5 ͦͷଞ w 4:4εΩʔϚΛαϙʔτ w 0/-:@'6--@(3061@#: .Z42- ͕σϑΥϧτ
w ೔Ͱ1BTTXPSEมߋڧ੍͕σϑΥϧτ w ͭͷςʔϒϧʹϚϧντϦΨʔΛαϙʔτ

114.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

115.

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42- ˣ ਖ਼౷೿ͳ3%#ΛΑΓ֦ு͍ͯ͘͠ײ͡

116.

MySQL 5.7ͱPostgreSQL 9.5 .Z42-

117.

MySQL 5.7ͱPostgreSQL 9.5 .Z42- ˣ ਖ਼͍͠3%#ͬΆ͘ͳͬͨ ʢͦͷӨڹͰԼҐޓ׵ੑͷແ͍มߋ΋ଟ͍ʣ ݩ͕ΏΔ;Θܥա͗ͨͷͰྑ͍ͱࢥ͏

118.

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42-

119.

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42- ΑΓେن໛ΞʔΩςΫνϟʹಛԽ͍͖ͯͦ͠͏

120.

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42- ΑΓେن໛ΞʔΩςΫνϟʹಛԽ͍͖ͯͦ͠͏ ˣ ϥΠόϧ͸1PTUHSF42-Ͱ͸ͳ͘/042-

121.

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42-

122.

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42- ਖ਼౷೿3%#ͱͯ͠ਐԽ͍͖ͯͦ͠͏

123.

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42- ਖ਼౷೿3%#ͱͯ͠ਐԽ͍͖ͯͦ͠͏ ˣ ϥΠόϧ͸.Z42-Ͱ͸ͳ͘ɺ঎༻%#

124.

MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͱ1PTUHSF42-

125.

MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͱ1PTUHSF42- ࠓ·Ͱ΋͜Ε͔Β΋ॅΈ෼͚͕ਐΜͰ͍͘

126.


127.

·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ

128.

·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ ˣ ධՁ͕࣠૿͑ͯൃ૝͕޿͕Δ

129.

·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ ˣ ධՁ͕࣠૿͑ͯൃ૝͕޿͕Δ ˣ ઃܭྗ্͕͕Δ

130.

·ͱΊ બ୒ࢶ͕૿͑Δ

131.

·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ

132.

·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍

133.

·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍ ࠓޙ΋3%#૚ͷ044ར༻͸૿͑Δ͸ͣ

134.

·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍ ࠓޙ΋3%#૚ͷ044ར༻͸૿͑Δ͸ͣ %#ΤϯδχΞͷੜ͖࢒ΓઓུͷҰͭ

135.

·ͱΊ ࠷৽൛ͷௐࠪ

136.

·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏

137.

·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏ ˣ ೔ຊޠ৘ใ΋ଟ͍

138.

·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏ ˣ ೔ຊޠ৘ใ΋ଟ͍ ߴ଎Խ΋ϝϦοτ͕ͩ ࠓࠔͬͯΔࣄΛղܾͯ͘͠ΕΔࣄ΋ଟ͍ ྫɿ1PTUHSF42-ͷ.BSHFจ .Z42-ͷτϦΨʔͳͲ

139.

·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸

140.

·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍

141.

·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍ ˣ ϕϯμʔϩοΫΠϯ͞Εͳ͍஌ࣝ͸وॏ

142.

·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍

143.

·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍ ˣ ͔ͩΒͦ͜%#ͷ஌ࣝ͸େ੾Ͱ͢

144.

·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ

145.

·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ ˣ க໋ইʹͳΔ͜ͱ΋ଟ͍

146.

·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ

147.

·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ ˣ ൺֱ͢Δ͜ͱͰؔ࿈෇͚ͨ͠هԱʹͳΔ

148.

·ͱΊ ٕज़͸ෳ਺ֶͼ·͠ΐ͏

149.

͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ

2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

Want more?

Transcript