[B! RDB] phakchi0830ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

phakchi0830 id:phakchi0830

RDBã«é–¢ã™ã‚‹phakchi0830ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

é¦™å·å¤§å¦ã®å¦ç”Ÿå‘ã‘ã«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿå˜æˆ¦ç•¥ã«ã¤ã„ã¦è©±ã‚’ã—ã¾ã—ãŸ - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
7/21ã«é¦™å·å¤§å¦ã§è¬›æ¼”ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ããƒ¼ã ã„ã•ã‚“ã¨è¨€ãˆã°RDBã§ã—ã‚‡ï¼ï¼Ÿã¿ãŸã„ãªæ„Ÿã˜ã§å…ˆã«ã‚¿ã‚¤ãƒˆãƒ«ãŒæ±ºã¾ã£ãŸæ„Ÿã˜ã§ã™ãŒRDBå…¨ç„¶é–¢ä¿‚ãªã„æ„Ÿã˜ã«ãªã‚Šã¾ã—ãŸã€‚ åƒ•ãŒè¶…çµ¶ãƒªã‚¹ãƒšã‚¯ãƒˆã—ã¦ã‚‹ id:t-wada ã•ã‚“ã¨ãã“ãã“ãƒªã‚¹ãƒšã‚¯ãƒˆã—ã¦ã‚‹ä¸Šå¸ã® id:onishi ã•ã‚“ã®åè¨€ã‚’å¼•ç”¨ã•ã›ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚åƒ•ã¯ã“ã®2ã¤ã®è¨€è‘‰ãŒ10å¹´æˆ¦ãˆã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ ¸å¿ƒã‚’ã¤ã„ã¦ã‚‹ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã¤ã¾ã‚Š æŠ€è¡“ã¯èžºæ—‹ãªã®ã§ç¶™ç¶šçš„ãªçŸ¥è˜ã®æ›´æ–°ã¯å¿…é ˆ æ‰‹ã‚’å‹•ã‹ã™ï¼ˆä¸€æ©ç›®ã‚’è¸ã¿å‡ºã™ï¼‰è€…ãŒæœªæ¥ã‚’ä½œã‚‹ ã¨ã„ã†2ç‚¹ã‚’è¸ã¾ãˆãŸä¸Šã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¯ãã‚Œãžã‚Œå¾—æ‰‹ä¸å¾—æ‰‹ãŒã‚ã‚‹ã‚ã‘ã§ã™ã€‚ã“ã®å¾—æ‰‹ä¸å¾—æ‰‹ã‚’ç†è§£ã—ã¦è‡ªåˆ†ãŒã©ã®ãƒ•ã‚§ãƒ¼ã‚ºã‚’æˆ¦å ´ã¨ã—ã¦æˆ¦ã†ã‹ï¼Ÿã£ã¦è©±ã‚’ã—ã¾ã—ãŸã€‚ã“ã®è©±ã¯å‰ã‚‚ãƒ–ãƒã‚°ã«è©±ã‚’ã—ãŸå†…å®¹ã§ã™ã€‚ soudai.hatena blog.com ãã“ã§åƒ•ã®çµŒé¨“è«‡ã¨ã—ã¦DBã‚’äº¤ãˆã¦è©±ã‚’ã—ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã‚‹ã®ãŒç‰¹ã«å¥½ããªã‚¿ã‚¤ãƒ—ã§
phakchi0830 2017/07/24
é¦™å·å¤§å¦

RDB
ãƒªãƒ³ã‚¯
ã‚½ã‚·ãƒ£ã‚²é–‹ç™ºçµŒé¨“ã‹ã‚‰å¦ã‚“ã ã‚²ãƒ¼ãƒ ã« Redis ã‚’ä½¿ã†éš›ã® Tips
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? è¿‘å¹´ã® KVS ã§ã¯å‰²ã¨ Redis ãŒè¦‡æ¨©ã‚’å–ã£ã¦ã„ã‚‹ã“ã¨ã‚‚ã‚ã‚Š(å½“ç¤¾æ¯”), ç¤¾å†…ã®å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ Redis ã‚’ä½¿ç”¨ã™ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸ. ã¨ã„ã†ã“ã¨ã§ãƒŽã‚¦ãƒã‚¦çš„ãªã®ã‚‚æºœã¾ã£ã¦ããŸã®ã§ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™. (å¤§é‡ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã‚½ã‚·ãƒ£ã‚²ã«ã—ã‹å½“ã¦ã¯ã¾ã‚‰ãªã„éƒ¨åˆ†ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™) å˜ç´”ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ RDB < Redis ã¨æ€ã„è¾¼ã‚“ã§ã¨ã‚Šã‚ãˆãšã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„ ã€ŒRedis ã¯é€Ÿã„ã€ã¨è¨€ã‚ã‚Œã¾ã™ãŒ, ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¡ã‚ƒã‚“ã¨è²¼ã£ãŸ RDB ã®ã‚¯ã‚¨ãƒªã‚‚ ãã“ã¾ã§é…ã„ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“. çµå±€é€šä¿¡ã‚³ã‚¹ãƒˆã®æ–¹ãŒé¥ã‹ã«å¤§
phakchi0830 2017/06/16
redis

RDB
ãƒªãƒ³ã‚¯
RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ // Speaker Deck
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2016ã®è³‡æ–™ã§ã™ http://phpcon.php.gr.jp/2016/
phakchi0830 2016/11/04
RDB

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQLã‚°ãƒ©ãƒ•åŽŸè«–ã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
ä»Šæœˆä¸‹æ—¬ã«ã€J.ã‚»ãƒ«ã‚³ã®ã€ŽTrees and Hierarchies 2nd Editionã€ã®é‚¦è¨³ãŒåˆŠè¡Œã•ã‚Œã¾ã™ã€‚åŒè‘—è€…ã®ä»£è¡¨ä½œã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬4ç‰ˆã€ã®ã‚¹ãƒ”ãƒ³ã‚ªãƒ•ã®ä¸€ã¤ã§ã€RDB/SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ãŸã‚ã®æ–¹æ³•è«–ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ãŸãªã‹ãªã‹ãƒžãƒ‹ã‚¢åº¦ã®é«˜ã„ä¸€å†Šã§ã™ã€‚ä¸»çœ¼ã¨ãªã‚‹ã€Œå…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã€ã«ã¤ã„ã¦ã¯ã€ç§ã‚‚ã‚ã¡ã“ã¡ã®è¨˜äº‹ã‚„æ›¸ç±ã§ç´¹ä»‹ã—ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã€ã”å˜ã˜ã®æ–¹ã‚‚ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚ˆã‚ŠåŒ…æ‹¬çš„ã‹ã¤ç†è«–é¢ã¾ã§ã‚«ãƒãƒ¼ã—ãŸæœ¬æ ¼æ´¾ã®å†…å®¹ã«ãªã£ã¦ã„ã¾ã™ã€‚ è¡¨ç´™ã®å¥³æ€§ã¯ãƒžãƒªã‚¢æ§˜ã§ã—ã‚‡ã†ã‹ã€‚æœ¬å®¶ã®æ–¹ãŒåˆŠè¡Œã•ã‚ŒãŸã¨ãã‚‚ã€Œã“ã®ãŠã£ã•ã‚“èª°ï¼Ÿã€ã¨ã„ã†è³ªå•ãŒç›¸æ¬¡ãŽã¾ã—ãŸãŒã€ã‚¬ãƒªãƒ¬ã‚ªã¨ã„ã†èª¬ãŒæœ‰åŠ›ãªã‚ˆã†ã§ã™ã€‚ãã†è¨€ã‚ã‚Œã¦ã¿ã‚‹ã¨æœ¬å®¶ã¯ã€Žæ˜Ÿç•Œã®å ±å‘Šã€ã®ã‚ˆã†ãªæ ¼èª¿ã‚’æ„Ÿã˜ã¾ã™ã€‚æœ¬æ›¸ã®æ–¹ã¯ã€é•·ã‚‰ãå®šèª¬ã¨ã•ã‚Œã¦ããŸãƒ¢ãƒ‡ãƒ«ã‚’ã²ã£ãã‚Šè¿”ãã†ã¨ã„ã†æ„å‘³ã§ã¯ã€Žå¤©ä½“ã®å›žè»¢ã«ã¤ã„ã¦ã€ã¿ãŸã„ãªæ€§æ ¼ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€å¤§åž‹æœ¬
phakchi0830 2016/08/16
RDB

SQL
ãƒªãƒ³ã‚¯
Embulkã‚’æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã£ãŸè©± - ä»Šæ—¥ã‚‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
èƒŒæ™¯ è‡ªåˆ†ã¯SIerã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ã€‚ ã„ã‚ã„ã‚ãªãŠå®¢æ§˜ã®ã€ã„ã‚ã„ã‚ãªæ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã¨æ ¼é—˜ã™ã‚‹ã®ãŒãŠä»•äº‹ã§ã‚ã‚‹ã€‚ ã¾ãŸã€ä»Šã¯embulk-input-jdbcã¨ã‹embulk-output-jdbcã®ã‚³ãƒŸãƒƒã‚¿ã‚‚ã‚„ã£ã¦ã„ã‚‹ã€‚ æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã¨RDBã¨ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ« æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€ãŸã„ã¦ã„RDBã‚’ä½¿ã£ã¦ã„ã‚‹ã€‚ ãã—ã¦ã€ã‚µãƒ¼ãƒé–“ã§ãƒ‡ãƒ¼ã‚¿ã‚’é€£æºã™ã‚‹ãŸã‚ã«ã€RDBã‹ã‚‰ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ãŸã‚Šã€ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’RDBã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒçµæ§‹ã‚ã‚‹ã€‚ ãã‚“ãªã¨ãã©ã†ã™ã‚‹ã‹ã¨è¨€ã†ã¨ã€RDBä»˜å±žã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã€‚ ä¾‹ãˆã°ã€Oracleã¸ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ã‚ã‚Œã°SQL*Loaderã€MySQLã¸ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ã‚ã‚Œã°mysqlimportã€ã¨ã„ã†ã‚ˆã†ã«ã€‚ RDBä»˜å±žã®ãƒ„ãƒ¼ãƒ«ã®å•é¡Œç‚¹ ã„ã‚ã„ã‚ãªãŠå®¢æ§˜ãŒã„ã¦ã€ã„ã‚ã„ã‚ãªã‚·ã‚¹ãƒ†ãƒ ãŒã‚ã‚‹ã®ã§ã€RDBã‚‚ã„ã‚ã„ã‚ã§ã‚ã‚‹ã€‚ ã¡ãªã¿ã«ã€ã†ã¡ã®ä¼šç¤¾ã§
phakchi0830 2016/08/12
embulk

RDB
ãƒªãƒ³ã‚¯
RDB - å®Ÿä¾‹ã§å¦ã¶ã€JOIN (NLJ) ãŒé…ããªã‚‹ç†å±ˆã¨å¯¾å‡¦æ³• - Qiita
"Nested Loop Joinã—ã‹å–ã‚Šä¸Šã’ã¦ç„¡ã„ã®ã«ã‚¿ã‚¤ãƒˆãƒ«ãŒå¤§ãã™ãŽãªã„ã‹" ã¨æŒ‡æ‘˜ã‚’é ‚ã„ãŸã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚Merge Joinã¨Hash Joinã®ã“ã¨ã¯ã¾ãŸä»Šåº¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ŒJOINã¯é…ã„ã€ã¨ã‚ˆãè¨€ã‚ã‚Œã¾ã™ã€‚ç‰¹ã«RDBã‚’ä½¿ã„å§‹ã‚ã¦é–“ãŒãªã„å†…ã«ãã†ã„ã†è¨€èª¬ã«è§¦ã‚ŒãŸçµæžœã€ŒJOIN=æ‚ªã€ã¨ã„ã†èªè˜ã§å›ºå®šåŒ–ã•ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‚ˆã†ã«æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãŸã—ã‹ã«ã€JOINã‚’å«ã‚€ã‚ˆã†ãªSELECTæ–‡ã¯ã€å«ã¾ãªã„ã‚‚ã®ã«æ¯”ã¹ã¦é‡ãŸããªã‚‹å‚¾å‘ãŒã‚ã‚‹ã“ã¨ã¯äº‹å®Ÿã§ã™ã€‚ã¾ãŸã€æœ¬è³ªçš„ã«å•ã„åˆã‚ã›ãŸã„å†…å®¹ãŒè¤‡é›‘ã§ã€å¯¾å‡¦ã™ã‚‹ã“ã¨ãŒé›£ã—ã„ã‚‚ã®ã‚‚å˜åœ¨ã—ã¾ã™ã€‚ã—ã‹ã—ã€RDBã®ä¸ã§ä¸€ä½“ã©ã†ã„ã†ã“ã¨ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚Šã€ãã‚Œã«åŸºã„ã¦å¯¾å‡¦ã™ã‚Œã°é«˜é€ŸåŒ–ã§ãã‚‹ã“ã¨ã‚‚å°‘ãªããªã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ æœ¬ç¨¿ã§ã¯ã€JOINã®å†…éƒ¨å‹•ä½œã‚’è§£èª¬ã—ãŸä¸Šã§ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã‚ˆãå‡ºã¦ãã‚‹JOIN SQLã‚’ä¾‹é¡Œã«
phakchi0830 2016/07/13
RDB
ãƒªãƒ³ã‚¯
ã“ã®RDBã«ã¤ã„ã¦ç§ã¯é©šãã¸ã‚™ãé—‡ã‚’è¦‹ã¤ã‘ãŸã‹ã‚™ãã“ã‚’ç™ºè¡¨ã™ã‚‹ã«ã¯ãƒãƒƒãƒˆã¯æ€–ã™ãã‚™ã‚‹
YAP(achimon)C::Asia Hachioji 2016midã®è³‡æ–™ã§ã™ã€‚
phakchi0830 2016/07/04
RDB
ãƒªãƒ³ã‚¯
1