PHPerに知ってほしいRDBの事_その2.pdf

PHPerʹ஌ͬͯ΄͍͠RDBͷࣄ Version 2.0 1)1ΧϯϑΝϨϯεˏ෱Ԭ

What is it? σʔλϕʔεͷण໋͸ ΞϓϦέʔγϣϯΑΓ΋௕͍

What is it? ͦΜͳ௕͍෇͖߹͍ʹͳΔσʔλϕʔε ͷେ੾ͳࣄΛ͓఻͑͠·͢

What is it? σʔλϕʔεͰ େ੾ͳ͜ͱ ΞϓϦέʔγϣϯͰ େ੾ͳ͜ͱ

What is it? ΞϓϦέʔγϣϯͰ େ੾ͳ͜ͱ σʔλϕʔεͰ େ੾ͳ͜ͱ ͜͜ͷ࿩Λ͠·͢

What is it? ର৅ͷσʔλϕʔειϑτ΢ΣΞ

What is it? PostgreSQL 9.5ͱMySQL 5.6(InnoDB)ʹݶΔ ଞͷRDBͷ࿩͸͠·ͤΜ

What is it? ৽ػೳͷ࿩ ↓ ֤σʔλϕʔεͷίϛϡχςΟʹࢀՃ͠Α͏ https://mysql-casual-slackin.herokuapp.com/ https://postgresql-hackers-jp.herokuapp.com/ େ੾ͳ࿩͚ͩͲࠓ೔͸͠ͳ͍͜ͱ

What is it? ࠓ೔ͷ࿩͢Δ͜ͱ

What is it? RDBΛ࢖͏্Ͱ͓͍֮͑ͯͯཉ͍͜͠ͱ

What is it? RDBΛ࢖͏্Ͱ͓͍֮͑ͯͯཉ͍͜͠ͱ ↓ جૅతͳ͜ͱͰ͙࣮͢ફͰ͖Δ͜ͱ

͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹݕࡧͱINDEX ̏ɹ࡟আϑϥά ̐ɹϚςϦΞϥΠζυϏϡʔ ̑ɹ·ͱΊ

ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ31ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿגࣜձࣾɹΦϛΧϨʢCTOʣ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

What is it? d

ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ31ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿגࣜձࣾɹΦϛΧϨʢCTOʣ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

ݕࡧͱINDEX #5SFF*/%&9

ݕࡧͱINDEX #5SFF*/%&9 3%#ͷ*/%&9͸جຊతʹ͜Ε ʢ(*/΍35SFFʹ͍ͭͯ͸ࠓճ৮Εͳ͍ʣ

ݕࡧͱINDEX Ҿ༻ݩɿIUUQTKBXJLJQFEJBPSHXJLJ##&$" ΢ΟΩϖσΟΞʮ# ໦ʯ

ݕࡧͱINDEX w 8)&3&۟Ͱ࢖͏ w (3061#:۟Ͱ΋࢖͏ w 03%&3#:۟Ͱ΋࢖͏

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

ݕࡧͱINDEX w 8)&3&۟Ͱ࢖͏ w (3061#:۟Ͱ΋࢖͏ w 03%&3#:۟Ͱ΋࢖͏ ݕࡧશൠͰ࢖͏ ͔͠͠.Z42-͸ͭͷ5"#-&Ͱ ͔ͭ͠*/%&9Λ࢖Θͳ͍

ݕࡧͱINDEX */%&9ΛޮՌతʹ࢖͏ʹ͸ w ॏෳ͕গͳ͍΄͏͕ྑ͍ w ݁Ռ͕গͳ͍΄͏͕ྑ͍

ݕࡧͱINDEX */%&9ΛޮՌతʹ࢖͏ʹ͸ w ॏෳ͕গͳ͍΄͏͕ྑ͍ w ݁Ռ͕গͳ͍΄͏͕ྑ͍ 6OJRVF͕ཧ૝ ॏෳ͕ଟ͍৔߹ɺ*/%&9ͷҙຯ͕ബΕΔ Α͋͘Δͷ͸%&-&5&@'-"(

ݕࡧͱINDEX */%&9ΛޮՌతʹ࢖͏ʹ͸ w ॏෳ͕গͳ͍΄͏͕ྑ͍ w ݁Ռ͕গͳ͍΄͏͕ྑ͍ ࢀরͷ5"#-&ͷશͯΛදࣔ͢ΔͳΒݩ͔Βશ ෦ݟͨ΄͏͕ྑ͍ શମͷʙ·Ͱ͕*/%&9ར༻ͷ໨҆

ݕࡧͱINDEX */%&9Λ੍͢Δऀ͸ݕࡧΛ੍͢Δ

ݕࡧͱINDEX ࣮ߦܭըΛݟΔ

ݕࡧͱINDEX &91-"*/Ͱॏཁͳ͜ͱ w ૝ఆ͢ΔϨίʔυʹ࣮σʔλΛ͋ΘͤΔ w ౷ܭ৘ใΛ࠷৽ʹ͢Δ w ࣮ߦ݁Ռ͕ਖ਼͍͜͠ͱΛ֬ೝ͢Δ

ݕࡧͱINDEX &91-"*/Ͱॏཁͳ͜ͱ w ૝ఆ͢ΔϨίʔυʹ࣮σʔλΛ͋ΘͤΔ w ౷ܭ৘ใΛ࠷৽ʹ͢Δ w ࣮ߦ݁Ռ͕ਖ਼͍͜͠ͱΛ֬ೝ͢Δ σʔλྔʹΑ࣮ͬͯߦܭը͕มΘΔ͜ͱ΋ଟ͍ ࣮ࡍΑΓগͳ͍σʔλͰ֬ೝͯ͠΋ҙຯ͕ແ͍

ݕࡧͱINDEX &91-"*/Ͱॏཁͳ͜ͱ w ૝ఆ͢ΔϨίʔυʹ࣮σʔλΛ͋ΘͤΔ w ౷ܭ৘ใΛ࠷৽ʹ͢Δ w ࣮ߦ݁Ռ͕ਖ਼͍͜͠ͱΛ֬ೝ͢Δ σʔλʹେྔͷ௥Ճɾ࡟আɾมߋ͕͋Δͱ౷ܭ৘ใ͕ෆਖ਼֬ʹͳΔ "/"-:;&5"#-&Ͱ౷ܭ৘ใΛߋ৽͔ͯ͠Β&91-"*/ʂʂ

ݕࡧͱINDEX &91-"*/Ͱॏཁͳ͜ͱ w ૝ఆ͢ΔϨίʔυʹ࣮σʔλΛ͋ΘͤΔ w ౷ܭ৘ใΛ࠷৽ʹ͢Δ w ࣮ߦ݁Ռ͕ਖ਼͍͜͠ͱΛ֬ೝ͢Δ ࣮ߦܭըͰߴ଎Խͯ͠΋࣮ߦ݁Ռ͕มΘΔͱҙຯ͕ແ͍ ࠷ऴతʹຊ൪Ͱ֬ೝ͔ͯ͠ΒϦϦʔε͢Δ͜ͱ

ݕࡧͱINDEX &91-"*/ͷ·ͱΊ w ެࣜυΩϡϝϯτΛಡ΋͏ UZQFͳͲ͸छྨ͕୔ࢁ͋Δ   IUUQTEFWNZTRMDPNEPDSFGNBOKBFYQMBJOPVUQVUIUNM  IUUQTXXXQPTUHSFTRMKQEPDVNFOUIUNMTRMFYQMBJOIUNM w ૉৼΓେࣄ

ݕࡧͱINDEX .Z42-8PSLCFODI QHBENJO

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

MySQL ૬ؔαϒΫΤϦ

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

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

૬ؔαϒΫΤϦ ——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)

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

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

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'

MySQL +0*/͸ֻ͚ࢉ

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

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

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

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

MySQL γϯϓϧɾߴ଎

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

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

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

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

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

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

PostgreSQL

PostgreSQL ͜ͷຊ͕͘͢͝ྑ͍ ͔͠͠ͷ࿩ IUUQXXXBNB[PODPKQ಺෦ߏ଄͔ΒֶͿ1PTUHSF42-ઃܭɾӡ༻ܭըͷమଇ4PGUXBSF%FTJHOQMVTEQ

ෳ਺ར༻ͨ͠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';

PostgreSQL

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

PostgreSQL

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

PostgreSQL

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

PostgreSQL

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

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

ͱΓ͋͑ͣ࡟আϑϥά IUUQXXXTMJEFTIBSFOFUU@XBEBSPOTBLVDBTVBM

ͱΓ͋͑ͣ࡟আϑϥά ͜ΜͳΧϥϜ໊Λ ࡞ͬͨ͜ͱ͋Γ·ͤΜ͔ʁ

ͱΓ͋͑ͣ࡟আϑϥά IPHF@EFMFUF@qBH

ͱΓ͋͑ͣ࡟আϑϥά ձһ࡟আϑϥάʜ ސ٬࡟আϑϥάʜ IPHFσʔλ࡟আϑϥάʜ

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আͱݴ͏໊ͷҋ

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আͷཧ༝

ͱΓ͋͑ͣ࡟আϑϥά w ΤϯυϢʔβ͔Βݟ͑ͳ͍͕ͨ͘͠σʔλ͸ফͨ͘͠ͳ͍ w ࡟আͨ͠σʔλΛݕࡧ͍ͨ͠ w σʔλΛফͣ͞ʹϩάʹ࢒͍ͨ͠ w ޡͬͨૢ࡞Λͳ͔ͬͨ͜ͱʹ͍ͨ͠ɺ௚͙ʹݩʹ໭͍ͨ͠

ͱΓ͋͑ͣ࡟আϑϥά ͦͯ͠ੜ·ΕΔ%&-&5&@'-"(

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আ͸ͳͥμϝͳͷ͔ʁ

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আͷσϝϦοτ

ͱΓ͋͑ͣ࡟আϑϥά w ੵΈॏͳΔ8)&3&EFMFUF@qBH w 6OJRVF੍໿͕࢖͑ͳ͘ͳΔ w ෳࡶͳදࣔ৚݅ʢ2VFSZʣͷݪҼ

ੵΈॏͳΔWHERE۟ ϒϩάΛऔ͖͍ͬͯͨ৔߹ 4&-&$5 '30. CMPH 8)&3& CMPHEFMFUF@qBH

ੵΈॏͳΔWHERE۟ ϒϩάΛऔ͖͍ͬͯͨ৔߹ 4&-&$5 '30. CMPH 8)&3& CMPHEFMFUF@qBH ϒϩάͷ࡟আϑϥάΛݟΔ

ੵΈॏͳΔWHERE۟ ϒϩάΛऔ͖͍ͬͯͨ৔߹ 4&-&$5 '30. CMPH 8)&3& CMPHEFMFUF@qBH ϒϩάͷ࡟আϑϥάΛݟΔ
ߋ৽ऀΞΧ΢ϯτ͕࡟আ͞ΕͯͨΒʁ

ੵΈॏͳΔWHERE۟ ༗ޮͳΞΧ΢ϯτͷϒϩάΛऔ͖͍ͬͯͨ৔߹ 4&-&$5 '30. CMPH *//&3+0*/VTFST 0/VTFSTJECMPHVTFS@JE "/%VTFSTEFMFUF@qBH
8)&3& CMPHEFMFUF@qBH

8)&3& CMPHEFMFUF@qBH Ϣʔβͷ࡟আϑϥάΛݟΔ

8)&3& CMPHEFMFUF@qBH Ϣʔβͷ࡟আϑϥάΛݟΔ ॴଐ͕࡟আ͞ΕͯͨΒʁ

ੵΈॏͳΔWHERE۟ ༗ޮͳॴଐͷ༗ޮͳΞΧ΢ϯτͷϒϩάΛऔ͖͍ͬͯͨ৔߹ 4&-&$5 '30. CMPH *//&3+0*/VTFST 0/VTFSTJECMPHVTFS@JE "/%VTFSTEFMFUF@qBH
*//&3+0*/DVTUPNFST 0/DVTUPNFSTJEVTFSTDVTUPNFS@JE "/%DVTUPNFSTEFMFUF@qBH 8)&3& CMPHEFMFUF@qBH

*//&3+0*/DVTUPNFST 0/DVTUPNFSTJEVTFSTDVTUPNFS@JE "/%DVTUPNFSTEFMFUF@qBH 8)&3& CMPHEFMFUF@qBH +0*/͕ͲΜͲΜੵΈॏͳΔ

*//&3+0*/DVTUPNFST 0/DVTUPNFSTJEVTFSTDVTUPNFS@JE "/%DVTUPNFSTEFMFUF@qBH 8)&3& CMPHEFMFUF@qBH +0*/͕ͲΜͲΜੵΈॏͳΔ 2VFSZ͕ϘτϧωοΫʹ

ͱΓ͋͑ͣ࡟আϑϥά 2VFSZͷෳࡶ౓ʹର͢Δରࡦ

ͱΓ͋͑ͣ࡟আϑϥά 2VFSZͷෳࡶ౓ʹର͢Δରࡦ ˣ ༗ޮͳσʔλͷ7JFXΛ࡞Δ

ͱΓ͋͑ͣ࡟আϑϥά 2VFSZͷෳࡶ౓ʹର͢Δରࡦ ˣ ༗ޮͳσʔλͷ7JFXΛ࡞Δ 2VFSZͷߴ଎Խʹ͸ͳΒͳ͍

ͱΓ͋͑ͣ࡟আϑϥά શͯͷ*/%&9ͷηΧϯμϦʹ %&-&5&@'-"(ΛೖΕΔඞཁ͕͋Δ

ͱΓ͋͑ͣ࡟আϑϥά શͯͷ*/%&9ͷηΧϯμϦʹ %&-&5&@'-"(ΛೖΕΔඞཁ͕͋Δ .Z42-͸*/%&9Λͭͷ5"#-&Ͱ͔ͭ͠࢖Θͳ͍ 8)&3&EFMFUF@qBH͸ΧʔσΟφϦςΟ͕ภΔ

ͱΓ͋͑ͣ࡟আϑϥά શͯͷ*/%&9ͷηΧϯμϦʹ %&-&5&@'-"(ΛೖΕΔඞཁ͕͋Δ 1PTUHSF42-΋*/%&9Λෳ਺ޮ͔ͤΔ 2VFSZΛॻ͘ͷ͕େม ΧʔσΟφϦςΟͷ໰୊͸ಉ༷

ͱΓ͋͑ͣ࡟আϑϥά w ੵΈॏͳΔ8)&3&EFMFUF@qBH w 6OJRVF੍໿͕࢖͑ͳ͘ͳΔ w ෳࡶͳදࣔ৚݅ʢ2VFSZʣͷݪҼ ͭ·Γ֎෦,FZ੍໿΋ࢮ͵

ͱΓ͋͑ͣ࡟আϑϥά JE OBNF BHF EFMFUFE TPVEBJ
TPVEBJ TPOF UBLFUPNP

TPVEBJ TPOF UBLFUPNP ಉ͡Ϣʔβ໊͕͍ΔͷͰ 6OJRVF੍໿Ͱ͖ͳ͍

TPVEBJ TPOF UBLFUPNP ಉ͡Ϣʔβ໊͕͍ΔͷͰ 6OJRVF੍໿Ͱ͖ͳ͍ ΋ͪΖΜ֎෦Ωʔ੍໿΋Ͱ͖ͳ͍

TPVEBJ TPOF UBLFUPNP αϩήʔτΩʔͰ֎෦Ωʔ੍໿ͨ͠৔߹͸ ؔ࿈ͨ͠σʔλ͸ผਓѻ͍ʹͳΔ

TPVEBJ TPOF UBLFUPNP αϩήʔτΩʔͰ֎෦Ωʔ੍໿ͨ͠৔߹͸ ؔ࿈ͨ͠σʔλ͸ผਓѻ͍ʹͳΔ φνϡϥϧΩʔͷ৔߹͸ࢮ͵

ͱΓ͋͑ͣ࡟আϑϥά ֎෦Ωʔ੍໿͕ࢮ͵

ͱΓ͋͑ͣ࡟আϑϥά ֎෦Ωʔ੍໿͕ࢮ͵ ˣ ςʔϒϧͷؔ࿈ੑͷ୲อ͕ࢮ͵

ͱΓ͋͑ͣ࡟আϑϥά σʔλͷෆ੔߹Λ๷͛ͳ͍

ͱΓ͋͑ͣ࡟আϑϥά σʔλͷෆ੔߹Λ๷͛ͳ͍ ˣ όάͷԹচʹͳΔ

ͱΓ͋͑ͣ࡟আϑϥά σʔλͷෆ੔߹Λ๷͛ͳ͍ ˣ ώϡʔϚϯΤϥʔ΋๷͛ͳ͍

ͱΓ͋͑ͣ࡟আϑϥά σʔλͷෆ੔߹͕ى͖ͨΒʁ

ͱΓ͋͑ͣ࡟আϑϥά σʔλͷෆ੔߹͕ى͖ͨΒʁ ˣ ݩʹ໭͢ͷ͸ࢸ೉ͷٕ

ͱΓ͋͑ͣ࡟আϑϥά ਖ਼͍͠σʔλΛ දࣔͤ͞Δ৚͕݅ଟ͍

*//&3+0*/DVTUPNFST 0/DVTUPNFSTJEVTFSTDVTUPNFS@JE "/%DVTUPNFSTEFMFUF@qBH 8)&3& CMPHEFMFUF@qBH දࣔͤ͞ΔͨΊʹ ͭͷςʔϒϧ͕ؔ܎͍ͯ͠Δ

ͱΓ͋͑ͣ࡟আϑϥά ͭͷσʔλΛऔΔͨΊʹ ؔ܎͢Δ5"#-&͕ଟ͗͢Δ

ͱΓ͋͑ͣ࡟আϑϥά ʮ͋ͷσʔλऔΔʹ͸˓˓ͱ☓☓ͱ ˚˚Λ+0*/ͯ͠8)&3&ͯ͠4&-&$5 ۟ʹ"4Ͱผ໊Λ෇͚ͯʜʯ Έ͍ͨͳࣄ͕සൃ͢Δ

ͱΓ͋͑ͣ࡟আϑϥά ࢓༷มߋͷ࣌ͷӨڹൣғ͕޿͍

ͱΓ͋͑ͣ࡟আϑϥά ࢓༷มߋͷ࣌ͷӨڹൣғ͕޿͍ ˣ ͭ·ΓόάͷԹচʹͳΔ

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আ͸࢖Θͳ͍΄͏͕ྑ͍

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আ͸࢖Θͳ͍΄͏͕ྑ͍ ˣ 5"#-&ʹঢ়ଶΛ࣋ͨͤͳ͍

ͱΓ͋͑ͣ࡟আϑϥά ࿦ཧ࡟আ͸࢖Θͳ͍΄͏͕ྑ͍ ˣ 5"#-&ʹঢ়ଶΛ࣋ͨͤͳ͍ ϦϨʔγϣφϧϞσϧͰදݱ͢Δ

ͱΓ͋͑ͣ࡟আϑϥά ॲํᝦ

ͱΓ͋͑ͣ࡟আϑϥά ༗ޮͳσʔλͷΈΛ࢒͢

ͱΓ͋͑ͣ࡟আϑϥά ༗ޮͳσʔλͷΈΛ࢒͢ ˣ ྫ͑͹࡟আࡁΈ5"#-&Λ࡞Δ

ͱΓ͋͑ͣ࡟আϑϥά EFMFUFE@VTFST VTFST

ͱΓ͋͑ͣ࡟আϑϥά EFMFUFE@VTFST VTFST TPVEBJ TPOF UBLFUPNP

ͱΓ͋͑ͣ࡟আϑϥά EFMFUFE@VTFST VTFST TPVEBJ TPOF UBLFUPNP ࡟আ %&-&5&จ

ͱΓ͋͑ͣ࡟আϑϥά EFMFUFE@VTFST VTFST TPVEBJ TPOF UBLFUPNP TPVEBJ τϦΨʔͰҠ͢

ͱΓ͋͑ͣ࡟আϑϥά EFMFUFE@VTFST VTFST TPOF UBLFUPNP TPVEBJ ςʔϒϧʹ͸࣮ࡍͷσʔλͷΈ͕࢒Δ

ͱΓ͋͑ͣ࡟আϑϥά ஫ҙ఺

ͱΓ͋͑ͣ࡟আϑϥά ஫ҙ఺ ˣ τϦΨʔ͸࢓༷มߋʹऑ͍

ͱΓ͋͑ͣ࡟আϑϥά ஫ҙ఺ ˣ τϦΨʔ͸࢓༷มߋʹऑ͍ ྫ͑͹"-5&3จͰΧϥϜΛ૿΍͢ͱ τϦΨʔ͕ࢮ͵

ͱΓ͋͑ͣ࡟আϑϥά έʔεόΠέʔεͰख๏͸બͿ͜ͱ

ͱΓ͋͑ͣ࡟আϑϥά έʔεόΠέʔεͰख๏͸બͿ͜ͱ ˣ ࿦ཧ࡟আ͸࢖Θͳ͍

ͱΓ͋͑ͣ࡟আϑϥά ؔ࿈ͨ͠ςʔϒϧ͸ʁ

ͱΓ͋͑ͣ࡟আϑϥά ؔ࿈ͨ͠ςʔϒϧ͸ʁ ˣ ඞཁͳΒ࡟আࡁΈ5"#-&Λ࡞Δ ෆཁͳΒ%&-&5&͢Δ

ͱΓ͋͑ͣ࡟আϑϥά ؔ࿈ͨ͠ςʔϒϧ͸ʁ ˣ ඞཁͳΒ࡟আࡁΈ5"#-&Λ࡞Δ ෆཁͳΒ%&-&5&͢Δ ֎෦Ωʔ੍໿͕࢖͑Ε͹$"4$"%&΋ग़དྷΔ

ͱΓ͋͑ͣ࡟আϑϥά ؔ࿈ͨ͠ςʔϒϧ͸ʁ ˣ ඞཁͳΒ࡟আࡁΈ5"#-&Λ࡞Δ ෆཁͳΒ%&-&5&͢Δ ֎෦Ωʔ੍໿͕࢖͑Ε͹$"4$"%&΋ग़དྷΔ ࣄ࣮ͷΈΛอଘ͢Δ

ͱΓ͋͑ͣ࡟আϑϥά wϢʔβͷঢ়ଶ TUBUVTΧϥϜʣ w՝ۚঢ়ଶʢ༩৴ɺ੥ٻࡁΈʣ wΧʔτ৘ใʢΧΰͷதɺߪೖࡁΈʣ ྨࣅྫ

ͱΓ͋͑ͣ࡟আϑϥά %#ʹঢ়ଶΛ࣋ͨͤΔͷ͸ةͳ͍

ͱΓ͋͑ͣ࡟আϑϥά %#ʹঢ়ଶΛ࣋ͨͤΔͷ͸ةͳ͍ ˣ %#ʹ͸ࣄ࣮ͷΈΛอଘ͢Δ

ϚςϦΞϥΠζυϏϡʔ 1PTUHSF42-ʹ͸ ϚςϦΞϥΠζυɾϏϡʔ͕͋Δ

ϚςϦΞϥΠζυϏϡʔ ͳ͓ɺ.Z42-ʹ͸ͳ͍

ϚςϦΞϥΠζυϏϡʔ ϚςϏϡʔͱ͸ʁ 7JFXΛ࣮ମԽͤ͞Δ ͭ·ΓΫΤϦͷ݁Ռͷ5"#-&Λ࡞Δ

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ $3&"5&

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ूܭ݁Ռ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ $3&"5&

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ूܭ݁Ռ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ ूܭ݁ՌΛࢀর͢ΔͷͰߴ଎Ͱγϯϓϧʂʂ

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ूܭ݁Ռ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ ՝ۚ

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ूܭ݁Ռ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ ϦϑϨογϡ ՝ۚ

ϚςϦΞϥΠζυϏϡʔ ूܭࡁΈද ՝ۚMPH ՝ۚ ूܭ݁Ռ ܭࢉ݁ՌΛϚςϏϡʔʹ͢Δ ՝ۚ ϦϑϨογϡ ՝ۚ ϦϑϨογϡ͠ͳ͍ͱूܭ݁Ռ͸มΘΒͳ͍

ϚςϦΞϥΠζυϏϡʔ wෳࡶͳςʔϒϧΛγϯϓϧʹ w஗͍ΫΤϦΛߴ଎ʹ w*/%&9νϡʔχϯά΋Մೳ ϝϦοτ

ϚςϦΞϥΠζυϏϡʔ wදྖҬΛ࢖͏ wϦϑϨογϡ͕ඞཁ wϦϑϨογϡͷίετ͕ߴ͍ σϝϦοτ

ϚςϦΞϥΠζυϏϡʔ wදྖҬΛ࢖͏ wϦϑϨογϡ͕ඞཁ wϦϑϨογϡͷίετ͕ߴ͍ σϝϦοτ ࣮ମΛ࣋ͭͷͰσʔλϑΝΠϧ͕࡞੒͞ΕΔ ࡞ͬͨ෼͚ͩσΟεΫεϖʔεΛѹഭ͢Δ

ϚςϦΞϥΠζυϏϡʔ wදྖҬΛ࢖͏ wϦϑϨογϡ͕ඞཁ wϦϑϨογϡͷίετ͕ߴ͍ σϝϦοτ ࣮ମΛ࣋ͭͷͰσʔλϑΝΠϧ͕࡞੒͞ΕΔ ࡞ͬͨ෼͚ͩσΟεΫεϖʔεΛѹഭ͢Δ ࢀরݩͷςʔϒϧͷ૿Ճͱ߹ΘͤͯϚςϏϡʔ͕૿͑Ε͹ ࢦ਺తʹσΟεΫεϖʔεͷ࢖༻ྔ͕૿͑Δ

ϚςϦΞϥΠζυϏϡʔ wදྖҬΛ࢖͏ wϦϑϨογϡ͕ඞཁ wϦϑϨογϡͷίετ͕ߴ͍ σϝϦοτ ߋ৽͕ࣦഊͨ࣌͠ͷॲཧΛ๨Εͣʹʂ

ϚςϦΞϥΠζυϏϡʔ wදྖҬΛ࢖͏ wϦϑϨογϡ͕ඞཁ wϦϑϨογϡͷίετ͕ߴ͍ σϝϦοτ

ϚςϦΞϥΠζυϏϡʔ wදྖҬΛ࢖͏ wϦϑϨογϡ͕ඞཁ wϦϑϨογϡͷίετ͕ߴ͍ σϝϦοτ 1PTUHSF42-ʹ͸ࠩ෼ߋ৽͸ແ͍ ˠσʔλ͕ΫΤϦͷ࣮ߦ଎౓͕஗͚Ε͹ߋ৽΋஗͍

ϚςϦΞϥΠζυϏϡʔ ͦΜͳσϝϦοτΛഎෛͬͯ΋ ૉ੖Β͍͠ޮՌ͕ϚςϏϡʔ͸͋Δ

ϚςϦΞϥΠζυϏϡʔ ϚςϏϡʔͰ࡟আϑϥάͷ ༗ޮσʔλ7JFXΛ࡞Δ

ϚςϦΞϥΠζυϏϡʔ ϚςϏϡʔͰ༗ޮσʔλ7JFXΛ࡞Δ

ϚςϦΞϥΠζυϏϡʔ ϚςϏϡʔͰ༗ޮσʔλ7JFXΛ࡞Δ ˣ ߴ଎Ͱ2VFSZ΋γϯϓϧ

ϚςϦΞϥΠζυϏϡʔ ϚςϏϡʔͰ༗ޮσʔλ7JFXΛ࡞Δ ˣ ߴ଎Ͱ2VFSZ΋γϯϓϧ 4&-&$5 '30.BDUJWF@CMPH

ϚςϦΞϥΠζυϏϡʔ ߋ৽ͨ͠ΒϚςϏϡʔΛߋ৽ ˣ DVTUPNFSTͰ΋VTFSTͰ΋CMPHͰ΋ ߋ৽͕͋Ε͹ϚςϏϡʔ΋ߋ৽ ˞஫ҙ఺ 3&'3&4)."5&3*"-*;&%7*&8͕සൃ͢Δͱ 4FSWFSͷϦιʔεΛ৯͏ 1PTUHSF42-ʹ͸·ͩࠩ෼ߋ৽͕ແ͍ͨΊ

ϚςϦΞϥΠζυϏϡʔ ͝ར༻͸ܭըతʹ

·ͱΊ wυΩϡϝϯτΛݟΔ w࣮ߦܭըΛݟΔ wਪଌΑΓ΋ܭଌ

·ͱΊ ͋Δ೔ಥવ஗͘ͳΔ

·ͱΊ ͋Δ೔ಥવ஗͘ͳΔ ˣ σʔλྔ͕ϝϞϦʹ৐Βͳ͘ͳΔ

࣮ફͰϋϚΔ᠘ w ूܭର৅͕େ͖͘ͳͬͯूܭ࣌ʹϝϞϦʹ৐Βͳ͍  ˠ5FNQPSBSZΛ%JTLʹు͘ͷͰॏ͘ͳΔ w */%&9͕ແ͘5"#-&εΩϟϯΛ͍ͯͨ͠  ˠςετ࣌͸σʔλ͕খ͔ͬͨ͞ͷͰ໰୊ʹؾ͔ͮͳ͔ͬͨ w ϓϩάϥϜ͕ϧʔϓͷ਺͚ͩΫΤϦΛ౤͍͛ͯͨ  ˠߦ਺͕૿͑Δͱϧʔϓճ਺͕૿͑ͯॏ͘ͳΔ
w ߋ৽͕ܹ͘͠*/%&9ͷஅยԽ͕ൃੜͨ͠  ˠ61%"5&΍%&-&5&ʹΑͬͯ*/%&9͕அยԽͯ͠஗͘ͳΔ

࣮ફͰϋϚΔ᠘ w ूܭର৅͕େ͖͘ͳͬͯूܭ࣌ʹϝϞϦʹ৐Βͳ͍  ˠ5FNQPSBSZΛ%JTLʹు͘ͷͰॏ͘ͳΔ w */%&9͕ແ͘5"#-&εΩϟϯΛ͍ͯͨ͠  ˠςετ࣌͸σʔλ͕খ͔ͬͨ͞ͷͰ໰୊ʹؾ͔ͮͳ͔ͬͨ w ϓϩάϥϜ͕ϧʔϓͷ਺͚ͩΫΤϦΛ౤͍͛ͯͨ  ˠߦ਺͕૿͑Δͱϧʔϓճ਺͕૿͑ͯॏ͘ͳΔ
w ߋ৽͕ܹ͘͠*/%&9ͷஅยԽ͕ൃੜͨ͠  ˠ61%"5&΍%&-&5&ʹΑͬͯ*/%&9͕அยԽͯ͠஗͘ͳΔ ࣮ߦܭըΛ ݟΕΔΑ͏ʹͳΖ͏

·ͱΊ %#ͷ໰୊͸๨Εͨࠒʹ΍ͬͯ͘Δ

·ͱΊ

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

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

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

·ͱΊ σʔλͷࢮ͸αʔϏεͷࢮ

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

·ͱΊ ۪ऀ͸ܦݧʹֶͿ ݡऀ͸աڈʹֶͿ

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

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

·ͱΊ ӡ༻ͱઃܭͱཧ࿦ͷ࿩ ↓ SQLΞϯνύλʔϯͱDB࣮ફೖ໳Λಡ΋͏

·ͱΊ

·ͱΊ 3%#͸͍͍ͧɻ

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

PHPerに知ってほしいRDBの事_その2.pdf

PHPerに知ってほしいRDBの事_その2.pdf

More Decks by soudai sone

Featured

Transcript