Slide 1

Slide 1 text

ࠓͦ͜஌Γ͍ͨɺ 2େOSSσʔλϕʔεͷ MySQLͱPostgreSQLͷҧ͍ 044ίϯιʔγΞϜɹσʔλϕʔε෦ձɹओ࠵ηϛφʔ ʮΦʔϓϯιʔεσʔλϕʔεൺֱηϛφʔʯ

Slide 2

Slide 2 text

What is it? MySQLͱPostgreSQL

Slide 3

Slide 3 text

What is it? ࠓ͸2ڧ࣌୅ʢͦʔ͍ͩௐ΂

Slide 4

Slide 4 text

What is it? ଟ෼ɺଟ͘ͷਓ͕࢖͍ͬͯΔ͸ͣ

Slide 5

Slide 5 text

What is it? ·ͨ͜Ε͔Β࢖͏ػձ͕ଟʑ͋Δ͸ͣ

Slide 6

Slide 6 text

What is it? ͦΜͳਓͨͪͷͨΊʹ ࠓ೔͔Β࢖͑Δϊ΢ϋ΢Λʂ

Slide 7

Slide 7 text

What is it?

Slide 8

Slide 8 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹMySQL ̏ɹPostgreSQL ̐ɹ࣮ફͰϋϚΔ᠘ ̑ɹ·ͱΊ

Slide 9

Slide 9 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹMySQL ̏ɹPostgreSQL ̐ɹ࣮ફͰϋϚΔ᠘ ̑ɹ·ͱΊ

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

Mackerel

Slide 13

Slide 13 text

͸ͯͳ͸஥ؒΛ୳ͯ͠·͢ curl -sIL mackerel.io | grep engineer

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹMySQL ̏ɹPostgreSQL ̐ɹ࣮ફͰϋϚΔ᠘ ̑ɹ·ͱΊ

Slide 16

Slide 16 text

MySQL .Z42-ͷಛ௃

Slide 17

Slide 17 text

MySQL .Z42-ͷಛ௃ ˣ γϯϓϧɾߴ଎

Slide 18

Slide 18 text

MySQL ߋ৽ܕΞʔΩςΫνϟ

Slide 19

Slide 19 text

MySQL Ϩίʔυ Ϩίʔυ Ϩίʔυ ςʔϒϧ ςʔϒϧ Ϩίʔυ Ϩίʔυ Ϩίʔυ

Slide 20

Slide 20 text

MySQL Ϩίʔυ Ϩίʔυ Ϩίʔυ ςʔϒϧ ςʔϒϧ Ϩίʔυ Ϩίʔυ Ϩίʔυ ಉ͡ߦΛߋ৽͢Δ

Slide 21

Slide 21 text

MySQL ετϨʔδΤϯδϯ

Slide 22

Slide 22 text

MySQL Ҿ༻ݩɿIUUQXXXTMJEFTIBSFOFUZPLVIBOEMFS !ZPLV͞Μɺ͍ͭ΋͋Γ͕ͱ͏͍͟͝·͢ɻ

Slide 23

Slide 23 text

MySQL Ҿ༻ݩɿIUUQXXXTMJEFTIBSFOFUZPLVIBOEMFS !ZPLV͞Μɺ͍ͭ΋͋Γ͕ͱ͏͍͟͝·͢ɻ

Slide 24

Slide 24 text

MySQL ετϨʔδΤϯδϯͱ͸

Slide 25

Slide 25 text

MySQL ετϨʔδΤϯδϯͱ͸ ˣ େମσʔλͷಡΈॻ͖͢Δͱ͜Ζ

Slide 26

Slide 26 text

MySQL ͔͜͜Βઌ͸*OOP%#ͷ࿩ .Z*4".ʁ஌Βͳ͍ࢠͰ͢Ͷʢന໨

Slide 27

Slide 27 text

MySQL γϯϓϧɾߴ଎

Slide 28

Slide 28 text

MySQL γϯϓϧɾߴ଎ ˣ */%&9͕ޮ͍͍ͯΔࣄ͕େࣄ

Slide 29

Slide 29 text

MySQL #5SFF*/%&9

Slide 30

Slide 30 text

MySQL #5SFF*/%&9 .Z42-͸جຊతʹ͜Ε ʢ35SFFʹ͍ͭͯ͸ࠓճ৮Εͳ͍ʣ

Slide 31

Slide 31 text

MySQL Ҿ༻ݩɿIUUQTKBXJLJQFEJBPSHXJLJ##&$" ΢ΟΩϖσΟΞʮ#໦ʯ

Slide 32

Slide 32 text

MySQL w 8)&3&۟Ͱ࢖͏ w (3061#:۟Ͱ΋࢖͏ w 03%&3#:۟Ͱ΋࢖͏

Slide 33

Slide 33 text

MySQL w 8)&3&۟Ͱ࢖͏ w (3061#:۟Ͱ΋࢖͏ w 03%&3#:۟Ͱ΋࢖͏ ݕࡧશൠͰ࢖͏

Slide 34

Slide 34 text

MySQL w ॏෳ͕গͳ͍΄͏͕ྑ͍ w ݁Ռ͕গͳ͍΄͏͕ྑ͍ w ར༻͢Δ*/%&9͸̍5"#-&ʹݸ

Slide 35

Slide 35 text

MySQL w ॏෳ͕গͳ͍΄͏͕ྑ͍ w ݁Ռ͕গͳ͍΄͏͕ྑ͍ w ར༻͢Δ*/%&9͸̍5"#-&ʹݸ .Z42-ͷେ͖ͳಛ௃ͷҰͭ ʢΠϯσοΫε݁߹ʹ͍ͭͯ͸ࠓճ৮Εͳ͍ʣ

Slide 36

Slide 36 text

MySQL ࣮ߦܭըΛݟΔ

Slide 37

Slide 37 text

MySQL .Z42-8PSLCFODI

Slide 38

Slide 38 text

MySQL .Z42-8PSLCFODI ˣ ແྉͰ࢖͑Δ

Slide 39

Slide 39 text

MySQL

Slide 40

Slide 40 text

MySQL 0SBDMFΞΧ΢ϯτෆཁʂʂ

Slide 41

Slide 41 text

࣮ߦܭը CREATE TABLE `demo`.`users` ( `id` INT NOT NULL AUTO_INCREMENT COMMENT '', `name` VARCHAR(45) NOT NULL COMMENT '', `age` INT NOT NULL COMMENT '', `created` DATETIME NOT NULL DEFAULT NOW () COMMENT '', PRIMARY KEY (`id`) COMMENT '' ); ——શ݅Λબ୒͢ΔͷͰςʔϒϧεΩϟϯ SELECT * FROM demo.users; ——PRIMARY KEYʢINDEXʣΛར༻ͨ͠ྫ SELECT * FROM demo.users WHERE id > 100; ——INDEX͕ແ͍ͷͰςʔϒϧεΩϟϯ SELECT * FROM demo.users WHERE age > 20;

Slide 42

Slide 42 text

MySQL

Slide 43

Slide 43 text

MySQL

Slide 44

Slide 44 text

MySQL αϒΫΤϦͱ૬ؔαϒΫΤϦ

Slide 45

Slide 45 text

αϒΫΤϦ —— INDEXͱͯ͠PRIMARY KEY͕ޮ͍͍ͯΔ SELECT * FROM users WHERE id < 1000 AND id > 800 —— 1ճ͔࣮͠ߦ͞Εͳ͍ SELECT * FROM (SELECT * FROM users WHERE id < 1000 AND id > 800) AS dummy

Slide 46

Slide 46 text

MySQL

Slide 47

Slide 47 text

૬ؔαϒΫΤϦ ——஗͍૬ؔαϒΫΤϦ SELECT * FROM users WHERE age IN (SELECT age FROM users WHERE id BETWEEN 10 AND 100000)

Slide 48

Slide 48 text

MySQL

Slide 49

Slide 49 text

MySQL .Z42-͔Β."5&3*"-*;&%ʹ มΘΓɺ+0*/ͷΑ͏ͳڍಈʹͳͬͨ ੲΑΓૣ͘ͳͬͨ

Slide 50

Slide 50 text

૬ؔαϒΫΤϦ ——INDEX͕ར༻Ͱ͖Ε͹૬ؔαϒΫΤϦͰ΋଎͍ SELECT * FROM users WHERE created = '2016-02-27 04:31:32' AND id IN (SELECT id FROM users WHERE id BETWEEN 10 AND 100000)

Slide 51

Slide 51 text

MySQL

Slide 52

Slide 52 text

MySQL ૬ؔαϒΫΤϦ͸஗͍ ৔߹͕ଟ͍

Slide 53

Slide 53 text

MySQL ૬ؔαϒΫΤϦ͸஗͍ ˣ +0*/ʹॻ͖׵͑Δ

Slide 54

Slide 54 text

JOIN SELECT * FROM users INNER JOIN users AS tmp ON tmp.id = users.id AND tmp.id BETWEEN 10 AND 100000 WHERE users.created = '2016-02-27 04:31:32'

Slide 55

Slide 55 text

MySQL

Slide 56

Slide 56 text

MySQL +0*/͸ֻ͚ࢉ

Slide 57

Slide 57 text

MySQL +0*/͸ֻ͚ࢉ ˣ ߦ☓ߦ͸ߦ

Slide 58

Slide 58 text

MySQL .Z42-ʹ͸ +0*/ͷΞϧΰϦζϜ͸Ұ͔ͭ͠ͳ͍

Slide 59

Slide 59 text

MySQL .Z42-ʹ͸ +0*/ͷΞϧΰϦζϜ͸Ұ͔ͭ͠ͳ͍ ܾͯ͠ಘҙͳΘ͚Ͱ͸ແ͍ +0*/͸ϋΠίετͳΫΤϦ

Slide 60

Slide 60 text

MySQL w ग़དྷΔ͚ͩখ͔ͯ͘͞͠Β+0*/ w ෆཁͳ+0*/͸ආ͚Δ w */%&9Λར༻ͨ͠+0*/Λ͢Δ

Slide 61

Slide 61 text

MySQL γϯϓϧɾߴ଎

Slide 62

Slide 62 text

MySQL γϯϓϧɾߴ଎ ˣ ೉͍͠ࣄΛ͠ͳ͍ ઃܭྗ͕ॏཁ

Slide 63

Slide 63 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹMySQL ̏ɹPostgreSQL ̐ɹ࣮ફͰϋϚΔҧ͍ ̑ɹ·ͱΊ

Slide 64

Slide 64 text

PostgreSQL 1PTUHSF42-ͷಛ௃

Slide 65

Slide 65 text

PostgreSQL 1PTUHSF42-ͷಛ௃ ˣ ߴػೳ

Slide 66

Slide 66 text

PostgreSQL ௥هܕΞʔΩςΫνϟ

Slide 67

Slide 67 text

PostgreSQL Ϩίʔυ Ϩίʔυ Ϩίʔυ ςʔϒϧ ςʔϒϧ Ϩίʔυ Ϩίʔυ Ϩίʔυ Ϩίʔυ

Slide 68

Slide 68 text

PostgreSQL Ϩίʔυ Ϩίʔυ Ϩίʔυ ςʔϒϧ ςʔϒϧ Ϩίʔυ Ϩίʔυ Ϩίʔυ Ϩίʔυ ࢀরΛ֎͢

Slide 69

Slide 69 text

PostgreSQL Ϩίʔυ Ϩίʔυ Ϩίʔυ ςʔϒϧ ςʔϒϧ Ϩίʔυ Ϩίʔυ Ϩίʔυ Ϩίʔυ ৽ͨʹมߋ෼Λ௥Ճ͢Δ

Slide 70

Slide 70 text

PostgreSQL ͭ·Γɺߋ৽͸.Z42-ΑΓෆར ʢ%&-&5&͸.Z42-΋ࣅͨΑ͏ͳࣄͯ͠Δʣ

Slide 71

Slide 71 text

PostgreSQL ͔͠͠ɺখ೉͍͜͠ͱ͸ಘҙ

Slide 72

Slide 72 text

PostgreSQL w*/%&9͸ෳ਺ݸ࢖͑Δ wͦ΋ͦ΋*/%&9ͷछྨ͕୔ࢁ͋Δ w૬ؔαϒΫΤϦ΋଎͍ w+0*/ͷΞϧΰϦζϜ΋ෳ਺͋Δ

Slide 73

Slide 73 text

PostgreSQL w*/%&9͸ෳ਺ݸ࢖͑Δ wͦ΋ͦ΋*/%&9ͷछྨ͕୔ࢁ͋Δ w૬ؔαϒΫΤϦ΋଎͍ w+0*/ͷΞϧΰϦζϜ΋ෳ਺͋Δ ͭͷΫΤϦ಺Ͱෳ਺࢖͑Δ

Slide 74

Slide 74 text

PostgreSQL w*/%&9͸ෳ਺ݸ࢖͑Δ wͦ΋ͦ΋*/%&9ͷछྨ͕୔ࢁ͋Δ w૬ؔαϒΫΤϦ΋଎͍ w+0*/ͷΞϧΰϦζϜ΋ෳ਺͋Δ #USFFɺ(*/ɺࣜ*/%&9ͳͲγʔϯʹ߹Θͤͯ ෳ਺ͷ*/%&9Λར༻Ͱ͖Δ

Slide 75

Slide 75 text

PostgreSQL w*/%&9͸ෳ਺ݸ࢖͑Δ wͦ΋ͦ΋*/%&9ͷछྨ͕୔ࢁ͋Δ w૬ؔαϒΫΤϦ΋଎͍ w+0*/ͷΞϧΰϦζϜ΋ෳ਺͋Δ ࢖͑Δ42-ͷߏจ΋ଟ͍ ྫ͑͹΢Πϯυ΢ؔ਺ͳͲ

Slide 76

Slide 76 text

PostgreSQL w*/%&9͸ෳ਺ݸ࢖͑Δ wͦ΋ͦ΋*/%&9ͷछྨ͕୔ࢁ͋Δ w૬ؔαϒΫΤϦ΋଎͍ w+0*/ͷΞϧΰϦζϜ΋ෳ਺͋Δ /FTUFE-PPQ+PJO 4PSU.FSHF+PJO )BTI+PJO

Slide 77

Slide 77 text

ෳ਺ར༻ͨ͠INDEX CREATE TABLE public.users ( id integer NOT NULL DEFAULT nextval('users_id_seq'::regclass), name text NOT NULL, age integer NOT NULL, created timestamp without time zone NOT NULL DEFAULT now(), CONSTRAINT users_pkey PRIMARY KEY (id)); CREATE INDEX users_created_idx ON public.users USING tree (created); ——idͱcreatedͷINDEXΛར༻͢Δ SELECT * FROM users WHERE id < 100 AND created < '2016-02-27 05:41:28';

Slide 78

Slide 78 text

PostgreSQL

Slide 79

Slide 79 text

PostgreSQL

Slide 80

Slide 80 text

ࣜINDEX ——ࣜINDEXΛ࡞੒ CREATE INDEX test_idx ON users (substr(name,10,12)); ——ࣜͷ݁ՌͰINDEX͕ޮ͘ SELECT name FROM users WHERE substr(name,10,12) = '10'

Slide 81

Slide 81 text

PostgreSQL

Slide 82

Slide 82 text

PostgreSQL

Slide 83

Slide 83 text

૬ؔαϒΫΤϦ SELECT * FROM users WHERE age IN (SELECT age FROM users WHERE id BETWEEN 10 AND 100000)

Slide 84

Slide 84 text

PostgreSQL

Slide 85

Slide 85 text

PostgreSQL

Slide 86

Slide 86 text

PostgreSQL ΦϓςΟϚΠβ͕ αϒΫΤϦΛ+0*/ʹॻ͖׵͑ͯΔ

Slide 87

Slide 87 text

૬ؔαϒΫΤϦ ——INDEXΛར༻ͨ͠αϒΫΤϦ SELECT * FROM users WHERE id IN (SELECT id FROM users WHERE id BETWEEN 10 AND 100000)

Slide 88

Slide 88 text

PostgreSQL ΦϓςΟϚΠβ͕+0*/ʹʢ͈́

Slide 89

Slide 89 text

૬ؔαϒΫΤϦ ——σϞͰINDEXΛ࢖ͬͯ͘Εͳ͍ͷͰINDEXΛ༏ઌతʹར༻͢ΔΑ͏ʹࢦఆ SET ENABLE_SEQSCAN=OFF; SELECT * FROM users WHERE id IN (SELECT id FROM users WHERE id BETWEEN 10 AND 100000)

Slide 90

Slide 90 text

PostgreSQL

Slide 91

Slide 91 text

PostgreSQL

Slide 92

Slide 92 text

PostgreSQL 1PTUHSF42-ͷ૬ؔαϒΫΤϦ͸ ൺֱత଎͍

Slide 93

Slide 93 text

΢Πϯυ΢ؔ਺ SELECT rank() OVER (PARTITION BY age ORDER BY id) , * FROM users WHERE age BETWEEN 10 AND 30 LIMIT 100

Slide 94

Slide 94 text

PostgreSQL

Slide 95

Slide 95 text

PostgreSQL

Slide 96

Slide 96 text

PostgreSQL ෳࡶͳूܭ͸ಘҙ

Slide 97

Slide 97 text

PostgreSQL ΢Πϯυ΢ؔ਺ʹ͍ͭͯ ߹ΘͤͯಡΉͱྑ͍ࢿྉ 8FCΤϯδχΞ͕1PTUHSF42-ΛબͿͭͷཧ༝ IUUQXXXTMJEFTIBSFOFU4PVEBJ4POFXFCQPTUHSFTRM

Slide 98

Slide 98 text

PostgreSQL ෳࡶͳूܭ͸ಘҙ ˣ Ͱ΋3%#ͷجຊ͸.Z42-ͱҰॹ

Slide 99

Slide 99 text

PostgreSQL ෳࡶͳूܭ͸ಘҙ ˣ Ͱ΋3%#ͷجຊ͸.Z42-ͱҰॹ ਖ਼نԽ͕ॏཁ */%&9Λར༻͠ͳ͍ͱ஗͍ +0*/͸ϋΠίετͳΫΤϦ ࣮ߦܭը͸ݟΕΔΑ͏ʹͳΖ͏ʂ

Slide 100

Slide 100 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹMySQL ̏ɹPostgreSQL ̐ɹ࣮ફͰϋϚΔ᠘ ̑ɹ·ͱΊ

Slide 101

Slide 101 text

࣮ફͰϋϚΔ᠘ աڈͷ৘ใʢϊΠζʣ

Slide 102

Slide 102 text

࣮ફͰϋϚΔ᠘ աڈͷ৘ใʢϊΠζʣ ˣ (PPHMFݕࡧͷݹ͍هࣄ΍ ޱ఻ʹ࿭Θ͞ΕΔ

Slide 103

Slide 103 text

࣮ફͰϋϚΔ᠘ աڈͷ৘ใʢϊΠζʣ ˣ (PPHMFݕࡧͷݹ͍هࣄ΍ ޱ఻ʹ࿭Θ͞ΕΔ 3%#͕ۤखͳͳઌഐ΍্͕࢘ ෇͍͕ͨ࣌ͱͯ΋ةݥ

Slide 104

Slide 104 text

࣮ફͰϋϚΔ᠘ w"-5&3จͰϩοΫΛऔΔʢ.Z42-ʣ w7"$66.͸खಈʢ1PTUHSF42-ʣ

Slide 105

Slide 105 text

࣮ફͰϋϚΔ᠘ w"-5&3จͰϩοΫΛऔΔʢ.Z42-ʣ w7"$66.͸खಈʢ1PTUHSF42-ʣ .Z42-͔ΒΦϯϥΠϯ "-5&3จΛαϙʔτ

Slide 106

Slide 106 text

࣮ફͰϋϚΔ᠘ w"-5&3จͰϩοΫΛऔΔʢ.Z42-ʣ w7"$66.͸खಈʢ1PTUHSF42-ʣ 1PTUHSF42-͔Β "VUP7"$66.Λαϙʔτ

Slide 107

Slide 107 text

࣮ફͰϋϚΔ᠘ ࣗ෼ͷ࢖͍ͬͯΔόʔδϣϯΛ ͔ͬ͠Γ֬ೝ͢Δ͜ͱ

Slide 108

Slide 108 text

࣮ફͰϋϚΔ᠘ ग़དྷΔ͚ͩ৽͍͠όʔδϣϯ͕ྑ͍ ϝδϟʔόʔδϣϯʹؔͯ͠͸ ೥ޙ͙Β͍ͷόʔδϣϯ͕͍͍ײ͡

Slide 109

Slide 109 text

࣮ફͰϋϚΔ᠘ ৽ػೳΛ࢖͏

Slide 110

Slide 110 text

࣮ફͰϋϚΔ᠘ ৽ػೳΛ࢖͏ ˣ 3%#ͷ৽ػೳ͸஍ཕʢόάʣΛ ౿Ή֮ޛ͕ඞཁ

Slide 111

Slide 111 text

࣮ફͰϋϚΔ᠘ ৽ػೳΛ࢖͏ ˣ 3%#ͷ৽ػೳ͸஍ཕʢόάʣΛ ౿Ή֮ޛ͕ඞཁ خʑͱͯ͠஍ཕΛ౿Έൈ͘Α͏ʹͳͬͨΒ ͦΕ͸Ұྲྀͷূʢଟ෼

Slide 112

Slide 112 text

࣮ફͰϋϚΔ᠘ ࢥ͍ࠐΈ

Slide 113

Slide 113 text

࣮ફͰϋϚΔ᠘ ࢥ͍ࠐΈ ˣ ޓ׵ੑͷແ͍มߋͰ ΧδϡΞϧʹࢮ͵

Slide 114

Slide 114 text

࣮ફͰϋϚΔ᠘ ࢥ͍ࠐΈ ˣ ޓ׵ੑͷແ͍มߋͰ ΧδϡΞϧʹࢮ͵ όʔδϣϯҧ͍΍ҧ͏%#Λ ࢖ͬͨ࣌ʹΑ͘ൃੜ͢Δ

Slide 115

Slide 115 text

࣮ફͰϋϚΔ᠘ ֎෦Ωʔ੍໿ͷҧ͍

Slide 116

Slide 116 text

࣮ફͰϋϚΔ᠘ .Z42-͸֎෦Ωʔ੍໿ͷ ਌ʹ΋ࢠʹ΋*/%&9Λ࡞Δ

Slide 117

Slide 117 text

࣮ફͰϋϚΔ᠘ 1PTUHSF42-͸֎෦Ωʔ੍໿ʹΑΔ */%&9Λ࡞Βͳ͍

Slide 118

Slide 118 text

࣮ફͰϋϚΔ᠘ 1PTUHSF42-͸ */%&9Λ࡞Βͳ͍ Ϛελʔදଆʹ͸ϢχʔΫ੍໿͕ඞਢ ϢχʔΫ੍໿ΛϢχʔΫ*/%&9Λੜ੒͢Δ ͔͠͠ࢠଆ͸*/%&9͕͋Δͱ͸ݶΒͳ͍

Slide 119

Slide 119 text

࣮ફͰϋϚΔ᠘ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ

Slide 120

Slide 120 text

࣮ફͰϋϚΔ᠘ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ .Z42-ͷσϑΥϧτ͸͜͜

Slide 121

Slide 121 text

࣮ફͰϋϚΔ᠘ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ 1PTUHSF42- 0SBDMF%# 42-4FSWFS ͷσϑΥϧτ͸͜͜

Slide 122

Slide 122 text

࣮ફͰϋϚΔ᠘ τϥϯβΫγϣϯ෼཭Ϩϕϧ ໊લ ෼཭Ϩϕϧ આ໌ 4&3*"-*;"#-& ͍ͭ͞Α ௚ྻతʹॲཧ 3&1&"5"#-&3&"% ڧ͍ ಡΈऔΓର৅ͷσʔλ ΛৗʹಡΈऔΔ 3&"%$0..*55&% ·͊·ڧ͍ ֬ఆͨ͠࠷৽σʔλΛ ৗʹಡΈऔΔ 3&"% 6/$0..*55&% ऑ͍ ଞͷॲཧʹΑͬͯߦΘ Ε͍ͯΔɺॻ͖͔͚ͷ σʔλ·ͰಡΈऔΔɻ 1PTUHSF42- 0SBDMF%# 42-4FSWFS ͷσϑΥϧτ͸͜͜ ϑΝϯτϜϦʔυ΍μʔςΟϦʔυͳͲͷ࿩͸ࠓ೔͸͠·ͤΜ ʮ͑ʁͳʹͦΕʯͬͯਓ͸ࠓ͙͢άάοͯษڧͨ͠ํ͕͍͍Ͱ͢

Slide 123

Slide 123 text

࣮ફͰϋϚΔ᠘ wυΩϡϝϯτΛݟΔ w࣮ߦܭըΛݟΔ wਪଌΑΓ΋ܭଌ

Slide 124

Slide 124 text

࣮ફͰϋϚΔ᠘ %#ͷ໰୊͸๨Εͨࠒʹ΍ͬͯ͘Δ

Slide 125

Slide 125 text

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹMySQL ̏ɹPostgreSQL ̐ɹ࣮ફͰϋϚΔ᠘ ̑ɹ·ͱΊ

Slide 126

Slide 126 text

·ͱΊ ͭͷ%#Λ஌Δ͜ͱͰ ҧ͍͔Βݸੑ͕ݟ͑ͯ͘Δ

Slide 127

Slide 127 text

·ͱΊ %#ͷݸੑΛ஌Δ͜ͱͰ ઃܭͷ෯͕޿͕Δ

Slide 128

Slide 128 text

·ͱΊ ઃܭͷ෯͕޿͕Δ͜ͱͰ ࢓ࣄͷ෯΋޿͕Δ

Slide 129

Slide 129 text

·ͱΊ 3%#ͷ࢖Θͳ͍γεςϜ͸ແ͍ ʢҰ෦ྫ֎͋Γʣ

Slide 130

Slide 130 text

·ͱΊ 3%#ͷ஌ࣝ͸ण໋͕௕͍

Slide 131

Slide 131 text

·ͱΊ 3%#ͷ஌ࣝ͸ण໋͕௕͍ ˣ ֮͑Ε͹࢓ࣄͰ௕͍ؒ໾ʹཱͭ

Slide 132

Slide 132 text

·ͱΊ %#ͷ໰୊͸ΫϦςΟΧϧ

Slide 133

Slide 133 text

·ͱΊ %#ͷ໰୊͸ΫϦςΟΧϧ ˣ ͭ·Γղܾ͢Ε͹ӳ༤

Slide 134

Slide 134 text

·ͱΊ ۪ऀ͸ܦݧʹֶͿ ݡऀ͸աڈʹֶͿ

Slide 135

Slide 135 text

·ͱΊ 3%#͸ྺ࢙͕௕͍

Slide 136

Slide 136 text

·ͱΊ 3%#͸ྺ࢙͕௕͍ ˣ ৭Μͳܦݧஊ͔Βֶ΂Δ

Slide 137

Slide 137 text

·ͱΊ 3%#͸͍͍ͧɻ

Slide 138

Slide 138 text

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ