Slide 1
Slide 1 text
͜ͷRDBʹ͍ͭͯ
ࢲڻ͖͘ҋΛݟ͚͕ͭͨ
ͦ͜Λൃද͢Δʹωοτා͗͢Δ
:"1$"TJB)BDIJPKJ
Slide 2
Slide 2 text
What is it?
σʔλϕʔεͷण໋
ΞϓϦέʔγϣϯΑΓ͍
Slide 3
Slide 3 text
What is it?
ͭ·Γɾɾɾ
Slide 4
Slide 4 text
What is it?
ҋଟ͍
Slide 5
Slide 5 text
What is it?
ͦΜͳࢲͷ ۪ஒ ܦݧஊΛ͓͠·͢
Slide 6
Slide 6 text
͋͐͡Μͩ
̍ɹࣗݾհ
̎ɹMySQL
̏ɹPostgreSQL
̐ɹΞϯνύλʔϯ
̑ɹ·ͱΊ
Slide 7
Slide 7 text
͋͐͡Μͩ
̍ɹࣗݾհ
̎ɹMySQL
̏ɹPostgreSQL
̐ɹΞϯνύλʔϯ
̑ɹ·ͱΊ
Slide 8
Slide 8 text
ࣗݾհ
໊લɿીࠜɹେʢͦͶɹ͚ͨͱʣ
ྸɿ31ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
৬ۀɿגࣜձࣾɹΦϛΧϨʢCTOʣ
ॴଐɿຊPostgreSQLϢʔβձ
ɹɹɹதࠃࢧ෦ ࢧ෦
ɹɹٕज़తʹLLܥݴޠͱ͔RDB͕͖Ͱ͢
Slide 9
Slide 9 text
ࣗݾհ
໊લɿીࠜɹେʢͦͶɹ͚ͨͱʣ
ྸɿ31ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
৬ۀɿגࣜձࣾɹΦϛΧϨʢCTOʣ
ॴଐɿຊPostgreSQLϢʔβձ
ɹɹɹதࠃࢧ෦ ࢧ෦
ɹɹٕज़తʹLLܥݴޠͱ͔RDB͕͖Ͱ͢
Slide 10
Slide 10 text
What is it?
d
Slide 11
Slide 11 text
ࣗݾհ
໊લɿીࠜɹେʢͦͶɹ͚ͨͱʣ
ྸɿ31ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ
৬ۀɿגࣜձࣾɹΦϛΧϨʢCTOʣ
ॴଐɿຊPostgreSQLϢʔβձ
ɹɹɹதࠃࢧ෦ ࢧ෦
ɹɹٕज़తʹLLܥݴޠͱ͔RDB͕͖Ͱ͢
Slide 12
Slide 12 text
͋͐͡Μͩ
̍ɹࣗݾհ
̎ɹMySQL
̏ɹPostgreSQL
̐ɹΞϯνύλʔϯ
̑ɹ·ͱΊ
Slide 13
Slide 13 text
MySQL
ͦʔౖ͍ܹͩͨ͠ɻ
Slide 14
Slide 14 text
MySQL
ͦʔ͍ͩ.Z42-Θ͔Β͵ɺ
͚ΕͲܕʹਓҰ൪හײͰ͋ͬͨ
Slide 15
Slide 15 text
ܕม
-- ςʔϒϧͷߏ `hoge`
CREATE TABLE IF NOT EXISTS `hoge` (
`id` int(11) NOT NULL,
`val` varchar(255) NOT NULL
);
mysql> SELECT * FROM hoge;
+----+--------+
| id | val |
+----+--------+
| 1 | ONE |
| 2 | 2 |
| 3 | Three3 |
| 4 | 4Four |
+----+--------+
4 rows in set (0,00 sec)
Slide 16
Slide 16 text
ܕม
mysql> SELECT * FROM hoge WHERE val = "0";
Empty set (0,00 sec)
mysql> SELECT * FROM hoge WHERE val = 2;
+----+-----+
| id | val |
+----+-----+
| 2 | 2 |
+----+-----+
1 row in set, 3 warnings (0,00 sec)
Slide 17
Slide 17 text
ܕม
mysql> SELECT * FROM hoge WHERE val = 4;
+----+-------+
| id | val |
+----+-------+
| 4 | 4Four |
+----+-------+
1 row in set, 3 warnings (0,00 sec)
mysql> SELECT * FROM hoge WHERE val = 3;
Empty set, 3 warnings (0,00 sec)
Slide 18
Slide 18 text
ܕม
-- ςʔϒϧͷߏ `hoge`
CREATE TABLE IF NOT EXISTS `hoge` (
`id` int(11) NOT NULL,
`val` varchar(255) NOT NULL
);
mysql> SELECT * FROM hoge;
+----+--------+
| id | val |
+----+--------+
| 1 | ONE |
| 2 | 2 |
| 3 | Three3 |
| 4 | 4Four |
+----+--------+
4 rows in set (0,00 sec)
Slide 19
Slide 19 text
ܕม
mysql> SELECT * FROM hoge WHERE val = 4;
+----+-------+
| id | val |
+----+-------+
| 4 | 4Four |
+----+-------+
1 row in set, 3 warnings (0,00 sec)
mysql> SELECT * FROM hoge WHERE val = 3;
Empty set, 3 warnings (0,00 sec)
ઌ಄͕ࣈ
ඌ͕ࣈ
Slide 20
Slide 20 text
MySQL
8IZ
.Z42-1FPQMFʂʂ
Slide 21
Slide 21 text
MySQL
ࠔͬͨΒ!ZPLV͞Μʹฉ͘
Slide 22
Slide 22 text
MySQL
ԶʮόάͰ͢ΑͶʂʯ
Slide 23
Slide 23 text
MySQL
ԶʮόάͰ͢ΑͶʂʯ
ˣ
!ZPLV͞Μʮ༷Ͱ͢ʈʈʯ
Slide 24
Slide 24 text
MySQL
WBMͷ߹ɺΛจࣈྻʹΩϟετ͢ΔͷͰͳ͘ɺ
WBMΛ%06#-&ʹΩϟετͯ͠ͱൺֱ͍ͯ͠·͢ɻ
ӳࣈͰ࢝·Δ453*/(%06#-&ʹΩϟετͰ͖ͣʹΩϟετޙͷ͕ʹͳ
Γ·͕͢ɺBCDͷΑ͏ͳจࣈྻʮͰ͖Δͱ͜Ζ·ͰΩϟετ͢ΔʯͷͰ
ΩϟετޙͷʹͳΓ·͢ɻ
ͭ·ΓͰ͢
ͬͯ͜ͱͰɺʮࣈͰ࢝·Βͳ͍WBMʯͷͷ͚͕ͩݕࡧʹҾ͔͔ͬΔΘ͚Ͱ͢ɻ
ͦͯ͠ٯʹࣈ͔Β࢝·Βͳ͍จࣈྻ8)&3&WBMʹ֘͢ΔΘ͚Ͱ͢ɻ
Slide 25
Slide 25 text
MySQL
ܕ
Slide 26
Slide 26 text
MySQL
%"5&5*.&ܕ͕4+*4ͩͱ
*/%&9͕ޮ͔ͳ͍Ṗ
Slide 27
Slide 27 text
MySQL
%"5&5*.&ܕ͕4+*4ͩͱ
*/%&9͕ޮ͔ͳ͍Ṗ
ˣ
·͊65'͑
Slide 28
Slide 28 text
MySQL
.Z42-ҎԼͩͱ%"5&5*.&ܕ
ͷσϑΥϧτʹ
$633&/5@%"5&5*.&͑ͳ͍
Slide 29
Slide 29 text
MySQL
Slide 30
Slide 30 text
MySQL
Slide 31
Slide 31 text
MySQL
ͦΜͳ༷ཁΒͳ͍ͩΖ͆
Slide 32
Slide 32 text
MySQL
Slide 33
Slide 33 text
MySQL
ͦΜͳ༷ඞཁͩͬͨʜ
Slide 34
Slide 34 text
MySQL
ਏ͍ʢ͔Β͍
Slide 35
Slide 35 text
MySQL
1PTUHSF42-ͱҧ͏ͱ͜Ζ
Slide 36
Slide 36 text
MySQL
bTPOF`b40/&`
Slide 37
Slide 37 text
MySQL
bTPOF`b40/&`
σϑΥϧτͰ۠ผ͠ͳ͍
όΠφϦܕΛࢦఆͨ͠Βग़དྷΔ
Slide 38
Slide 38 text
MySQL
$)&$,੍ͱ*/%&9ͷ߱ॱ
Slide 39
Slide 39 text
MySQL
$)&$,੍ͱ*/%&9ͷ߱ॱ
ˣ
ͦΜͳͷແ͍
Slide 40
Slide 40 text
MySQL
$)&$,੍ͱ*/%&9ͷ߱ॱ
ˣ
ͦΜͳͷແ͍
ͰΫΤϦ௨Δ
Slide 41
Slide 41 text
MySQL
·͊ͦΜͳࡉ͔͍͜ͱྑ͍
Slide 42
Slide 42 text
MySQL
ֆจࣈ
Slide 43
Slide 43 text
MySQL
Slide 44
Slide 44 text
MySQL
Slide 45
Slide 45 text
MySQL
ͦͦֆจࣈΓऔΒΕ
Slide 46
Slide 46 text
MySQL
VOJDPEF@DJͳ߹
ʢྫ͑VUG@HFOFSBM@DJͷ߹ʣ
Slide 47
Slide 47 text
MySQL
ֆจࣈΛؚΊͨҎ߱ͷจࣈ͕
શ෦ࣺͯΒΕͯอଘ͞Ε·͢
Slide 48
Slide 48 text
MySQL
ରࡦͱͯ͠
VUGNC@CJOΛ͏
Slide 49
Slide 49 text
͋͐͡Μͩ
̍ɹࣗݾհ
̎ɹMySQL
̏ɹPostgreSQL
̐ɹΞϯνύλʔϯ
̑ɹ·ͱΊ
Slide 50
Slide 50 text
PostgreSQL
QHBENJO
Slide 51
Slide 51 text
PostgreSQL
Slide 52
Slide 52 text
PostgreSQL
Slide 53
Slide 53 text
PostgreSQL
Slide 54
Slide 54 text
PostgreSQL
Slide 55
Slide 55 text
PostgreSQL
ͰෆຬͷΛฉ͔ͳ͍
Slide 56
Slide 56 text
PostgreSQL
ΞϯέʔτͱͬͯΈͨ
Slide 57
Slide 57 text
PostgreSQL
Slide 58
Slide 58 text
PostgreSQL
Slide 59
Slide 59 text
PostgreSQL
গͩͬͨ
Slide 60
Slide 60 text
PostgreSQL
ࣾͷ
ˣ
QIQ.Z"ENJOͰ͢Α
Slide 61
Slide 61 text
PostgreSQL
ࣾͷ
ˣ
ۀதʹ5XJUUFSͷΞϯέʔτʹ
͑ΕΔਓ͕গͰ͢Αɻ
Slide 62
Slide 62 text
PostgreSQL
ਖ਼ͩͬͨ
Slide 63
Slide 63 text
PostgreSQL
ϩέʔϧ
Slide 64
Slide 64 text
PostgreSQL
ϩέʔϧ
σϑΥϧτ04ͷϩέʔϧΛར༻͢Δɻ
ͦͷͨΊιʔτ͕ఆͱมΘΔ
ˠϩέʔϧʹ$Λࢦఆ͢Δඞཁ͕͋Δ
Slide 65
Slide 65 text
PostgreSQL
04ʹΑͬͯίϚϯυ͕ҧ͏
Slide 66
Slide 66 text
PostgreSQL
04ʹΑͬͯίϚϯυ͕ҧ͏
ͪΐͬͱͨ͠ύονΛͯΔͱ͖ʹࠔΔ
ಛʹ"OTJCMF͕ࠔΔ
Slide 67
Slide 67 text
PostgreSQL
ϚςϏϡʔͷޭࡑ
Slide 68
Slide 68 text
PostgreSQL
ͩͱϩοΫ͕ΩπΠ
Ͱͪΐͬͱྑ͘ͳ͚ͬͨͲ
Slide 69
Slide 69 text
PostgreSQL
ϚςϏϡʔͷࠩߋ৽ͳͲͳ͍
Slide 70
Slide 70 text
PostgreSQL
ࣗಈߋ৽ͳ͍
Slide 71
Slide 71 text
PostgreSQL
!ZPLV
ʮͦΕී௨ʹςʔϒϧ࡞Ε͍͍͡ΌΜʯ
Slide 72
Slide 72 text
PostgreSQL
͙͎ਖ਼
Slide 73
Slide 73 text
PostgreSQL
ࠪϩάແ͍
Slide 74
Slide 74 text
PostgreSQL
Ϛϧνϓϩηεͷͤ͘ʹόοΫΤϯ
υϓϩηε͕མͪͨΒશ෦མͪΔ
Slide 75
Slide 75 text
PostgreSQL
44%ͳͷʹ͍
Slide 76
Slide 76 text
PostgreSQL
'SFF[Fॲཧ
7"$66.ͷࡍʹ
9*%ͷ࠶ઃఆͷͨΊʹ'6--4$"/͕Δ
Slide 77
Slide 77 text
PostgreSQL
ͦͦ9*%͕CJUͳͷ͕ฅ
Slide 78
Slide 78 text
PostgreSQL
ϙετ0SBDMF%#ʢসʣ
Slide 79
Slide 79 text
͋͐͡Μͩ
̍ɹࣗݾհ
̎ɹMySQL
̏ɹPostgreSQL
̐ɹΞϯνύλʔϯ
̑ɹ·ͱΊ
Slide 80
Slide 80 text
Ξϯνύλʔϯ
%&-&5&@'"-(
Slide 81
Slide 81 text
Ξϯνύλʔϯ
ϑϥά໊ͬͯલ4&-&$5ͨ͠Β
ͱ͔/6--͕͍Δ
Slide 82
Slide 82 text
Ξϯνύλʔϯ
ϑϥά໊ͬͯલ4&-&$5ͨ͠Β
ͱ͔/6--͕͍Δ
ΧϥϜ໊ͱσʔλ͕ണ͍ͯ͠Δ
TUBUVTͷJOU͕ϚδοΫφϯόʔԽ
Slide 83
Slide 83 text
Ξϯνύλʔϯ
ඇਖ਼نԽ
Slide 84
Slide 84 text
Ξϯνύλʔϯ
ඇਖ਼نԽ
ͱਖ਼نԽτϨʔυΦϑͱ
ݴ͏߹͋Δ͕ਖ਼͍͠σʔλΛ࡞Ζ͏
Slide 85
Slide 85 text
Ξϯνύλʔϯ
ඇਖ਼نԽ
ͱਖ਼نԽτϨʔυΦϑͱ
ݴ͏߹͋Δ͕ਖ਼͍͠σʔλΛ࡞Ζ͏
ϚςϏϡʔͩͬͨΓΩϟογϡͰ
ղܾग़དྷΔࣄଟ͍
Slide 86
Slide 86 text
Ξϯνύλʔϯ
֎෦ΩʔϨεઃܭ
Slide 87
Slide 87 text
Ξϯνύλʔϯ
֎෦ΩʔϨεઃܭ
ਖ਼نԽ֎෦Ωʔ੍
σʔλΛकΔͨΊʹ͋Δʂʂ
Slide 88
Slide 88 text
Ξϯνύλʔϯ
͓ͦͦલΒ42-ษڧ͠Ζ
Slide 89
Slide 89 text
Ξϯνύλʔϯ
͋Δಥવ͘ͳΔ
Slide 90
Slide 90 text
Ξϯνύλʔϯ
͋Δಥવ͘ͳΔ
ˣ
σʔλྔ͕ϝϞϦʹΒͳ͘ͳΔ
Slide 91
Slide 91 text
࣮ફͰϋϚΔ᠘
w ूܭର͕େ͖͘ͳͬͯूܭ࣌ʹϝϞϦʹΒͳ͍
ˠ5FNQPSBSZΛ%JTLʹు͘ͷͰॏ͘ͳΔ
w */%&9͕ແ͘5"#-&εΩϟϯΛ͍ͯͨ͠
ˠςετ࣌σʔλ͕খ͔ͬͨ͞ͷͰʹؾ͔ͮͳ͔ͬͨ
w ϓϩάϥϜ͕ϧʔϓͷ͚ͩΫΤϦΛ͍͛ͯͨ
ˠߦ͕૿͑Δͱϧʔϓճ͕૿͑ͯॏ͘ͳΔ
w ߋ৽͕ܹ͘͠*/%&9ͷஅยԽ͕ൃੜͨ͠
ˠ61%"5&%&-&5&ʹΑͬͯ*/%&9͕அยԽͯ͘͠ͳΔ
Slide 92
Slide 92 text
࣮ફͰϋϚΔ᠘
w ूܭର͕େ͖͘ͳͬͯूܭ࣌ʹϝϞϦʹΒͳ͍
ˠ5FNQPSBSZΛ%JTLʹు͘ͷͰॏ͘ͳΔ
w */%&9͕ແ͘5"#-&εΩϟϯΛ͍ͯͨ͠
ˠςετ࣌σʔλ͕খ͔ͬͨ͞ͷͰʹؾ͔ͮͳ͔ͬͨ
w ϓϩάϥϜ͕ϧʔϓͷ͚ͩΫΤϦΛ͍͛ͯͨ
ˠߦ͕૿͑Δͱϧʔϓճ͕૿͑ͯॏ͘ͳΔ
w ߋ৽͕ܹ͘͠*/%&9ͷஅยԽ͕ൃੜͨ͠
ˠ61%"5&%&-&5&ʹΑͬͯ*/%&9͕அยԽͯ͘͠ͳΔ
࣮ߦܭըΛ
ݟΕΔΑ͏ʹͳΖ͏
Slide 93
Slide 93 text
͋͐͡Μͩ
̍ɹࣗݾհ
̎ɹMySQL
̏ɹPostgreSQL
̐ɹΞϯνύλʔϯ
̑ɹ·ͱΊ
Slide 94
Slide 94 text
·ͱΊ
%#ͷΕͨࠒʹͬͯ͘Δ
Slide 95
Slide 95 text
·ͱΊ
Slide 96
Slide 96 text
·ͱΊ
3%#ͷࣝण໋͕͍
Slide 97
Slide 97 text
·ͱΊ
3%#ͷࣝण໋͕͍
ˣ
֮͑ΕࣄͰ͍ؒʹཱͭ
Slide 98
Slide 98 text
·ͱΊ
3%#ͷࣝण໋͕͍
ˣ
֮͑ΕࣄͰ͍ؒʹཱͭ
͔ͩΒͦ͜एऀঁੑʹੋඇڵຯΛ࣋ͬͯཉ͍͠
Slide 99
Slide 99 text
·ͱΊ
%#ͷΫϦςΟΧϧ
Slide 100
Slide 100 text
·ͱΊ
σʔλͷࢮαʔϏεͷࢮ
Slide 101
Slide 101 text
·ͱΊ
%#ͷΫϦςΟΧϧ
ˣ
ͭ·Γղܾ͢Εӳ༤
Slide 102
Slide 102 text
·ͱΊ
۪ऀܦݧʹֶͿ
ݡऀաڈʹֶͿ
Slide 103
Slide 103 text
·ͱΊ
3%#ྺ࢙͕͍
Slide 104
Slide 104 text
·ͱΊ
3%#ྺ࢙͕͍
ˣ
৭Μͳܦݧஊ͔ΒֶΔ
Slide 105
Slide 105 text
·ͱΊ
ͬͱΈΜͳࣦഊஊΛڞ༗͠Α͏ʂ
Slide 106
Slide 106 text
·ͱΊ
3%#͍͍ͧɻ
Slide 107
Slide 107 text
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ