[B! sql] iaskellã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

iaskell id:iaskell

sqlã«é–¢ã™ã‚‹iaskellã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

${{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}}

ãƒ©ãƒŽãƒ™ã‚ªãƒ¼ãƒ«ã‚¿ã‚¤ãƒ ãƒ™ã‚¹ãƒˆã¾ã¨ã‚ : ErogameScape ï¼ã‚¨ãƒã‚²ãƒ¼æ‰¹è©•ç©ºé–“ï¼ Blog
2013å¹´06æœˆ09æ—¥07:00 ã‚«ãƒ†ã‚´ãƒªãƒ©ã‚¤ãƒˆãƒŽãƒ™ãƒ«SQL ãƒ©ãƒŽãƒ™ã‚ªãƒ¼ãƒ«ã‚¿ã‚¤ãƒ ãƒ™ã‚¹ãƒˆã¾ã¨ã‚ ã¯ã˜ã‚ã« 2013å¹´5æœˆ30æ—¥ã«i_j_ã•ã‚“ã®ã¤ã¶ã‚„ãã«ã‚ˆã£ã¦ã€5æœˆ30æ—¥ã‹ã‚‰6æœˆ2æ—¥ã«ã‹ã‘ã¦ã€ãƒ©ãƒŽãƒ™ã‚¯ãƒ©ã‚¹ã‚¿ã®æ–¹ã€…ãŒã€éŽåŽ»ã®å…¨ä½œå“ã‚’é€šã—ã¦ã€é¸å‡ºã—ãŸè‰¯ãƒ©ãƒŽãƒ™10ä»¶ã‚’ã‚ã’ã¦ã„ãå–¶ã¿ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ãã®çµæžœã€ç·å‚åŠ è€…æ•°197äººã€ç·æœ‰åŠ¹æŠ•ç¥¨æ•°1776ã€ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãŒé›†ã¾ã‚Šã¾ã—ãŸãŒã€twitterã¯ä½•ã‚‚ã—ãªã„ã¨ãƒ‡ãƒ¼ã‚¿ã¯æµã‚Œã¦æ¶ˆãˆã¦è¡Œãã®ã¿ã§ã‚‚ã£ãŸã„ãªã„ã¨æ€ã„ã¾ã—ãŸã€‚ ãã“ã§ã€ã€Œ#ãƒ©ãƒŽãƒ™ã‚ªãƒ¼ãƒ«ã‚¿ã‚¤ãƒ ãƒ™ã‚¹ãƒˆã€ã§ã¤ã¶ã‚„ã‹ã‚ŒãŸæ›¸ç±ã‚’é›†è¨ˆã—å ±å‘Šã™ã‚‹ã®ãŒã“ã®æ–‡æ›¸ã®ç›®çš„ã§ã™ã€‚ ã¤ã„ã§ã«ã€é›†è¨ˆã®ãŸã‚ã«SQLã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã‚’ä½¿ã£ã¦ã¿ãŸã®ã§ã€SQLã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ã®ä½¿ã„æ–¹ã‚‚å®Ÿä¾‹ã‚’äº¤ãˆã¦æ›¸ã„ã¦ã„ãã“ã¨ã«ã—ã¾ã™ã€‚ â€»ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã«å®Ÿè£…ã•ã‚ŒãŸORMã‚’ãªã‚‹ã¹ãä½¿ã†ã“ã¨ã«ãªã‚‹(ç›´ã§SQLæ›¸ã„ãŸã‚‰è²
iaskell 2013/06/09
ãƒ©ãƒŽãƒ™

sql
ãƒªãƒ³ã‚¯
SQLã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ è¨˜äº‹ä¸€è¦§ | gihyo.jp
æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ5ï¼‰é›†åˆæŒ‡å‘ã¨æ‰‹ç¶šãåž‹ ãƒŸãƒƒã‚¯ 2010-05-28 æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ4ï¼‰OLAPé–¢æ•°ã¨é›†ç´„é–¢æ•°ã‚’çµ„ã¿åˆã‚ã›ã‚‹ ãƒŸãƒƒã‚¯ 2010-05-27
iaskell 2012/10/27
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

ã„ã¤ã‹èªã‚€
ãƒªãƒ³ã‚¯
ç¬¬7å›žã€€æ€§èƒ½æ”¹å–„ã®éµã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ç‰¹æ€§ã‚’çŸ¥ã‚‹ï½žB-treeã¨ãƒãƒƒã‚·ãƒ¥ã€€ï¼ˆ1ï¼‰B-tree | gihyo.jp
SQLã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ ç¬¬7å›žæ€§èƒ½æ”¹å–„ã®éµã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ç‰¹æ€§ã‚’çŸ¥ã‚‹ï½žB-treeã¨ãƒãƒƒã‚·ãƒ¥ã€€ï¼ˆ1ï¼‰B-tree ã¯ã˜ã‚ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ä»•äº‹ã‚’ã—ã¦ã„ã‚‹ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å•é¡Œã«æ‚©ã¾ã•ã‚Œã‚‹ã“ã¨ã¯æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã€‚ã¨ãã«æœ€è¿‘ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿é‡ãŒé£›èºçš„ã«å¢—ãˆã€ã‚µãƒ¼ãƒã®CPUã‚„ãƒ¡ãƒ¢ãƒªã¨ã„ã£ãŸãƒãƒ¼ãƒ‰é¢ã®å¢—å¼·ã ã‘ã§ã¯è¿½ã„ã¤ã‹ãªã„ã“ã¨ã‚‚å¤šãã‚ã‚Šã¾ã™ã€‚ ãã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ã«å¯¾å¿œã™ã‚‹ãŸã‚ã€DBMSã¯æ€§èƒ½æ”¹å–„ã®ãŸã‚ã®æ‰‹æ®µã‚’å¤šãç”¨æ„ã—ã¦ã„ã¾ã™ã€‚ãã®ä¸ã§æœ€ã‚‚ã‚³ã‚¹ãƒˆãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è‰¯ã„æ–¹æ³•ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆç´¢å¼•ï¼‰ã§ã™ã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚‚ãƒãƒ¼ãƒ‰æ§‹æˆã«ã‚‚å½±éŸ¿ã‚’ä¸Žãˆãšã«å®Ÿè¡Œã§ãã€ã†ã¾ãã„ã‹ãªã‘ã‚Œã°ã™ãã«å‰Šé™¤ã§ãã‚‹ã¨ã„ã†æ‰‹è»½ã•ãŒå¤§ããªé…åŠ›ã§ã€åŠ¹æžœã¯ã—ã°ã—ã°çµ¶å¤§ã§ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¯ã„ã‚ã„ã‚ãªç¨®é¡žãŒã‚ã‚Šã€ã¾ãŸDBMSã«ã‚ˆã£ã¦ã‚‚ã‚µãƒãƒ¼ãƒˆã™ã‚‹ç¨®é¡žã«å·®ãŒã‚ã‚Šã¾ã™ãŒã€æœ¬ç¨¿ã§ã¯æœ€ã‚‚é‡è¦ãª2ã¤ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚ãã‚Œ
iaskell 2012/10/27
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
iaskell 2012/10/27
sql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘ã‚‹æˆ¦ã„ï¼ˆå‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ ã‚°ãƒ¼ã‚°ãƒ«ã®æ‹…å½“è€…ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…ï¼š-ï¼‰ã‚’è¡Œã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…é€±é–‹å‚¬ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„åˆ†ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚°ãƒ¼ã‚°ãƒ«ã®Alfred Fulleræ°ï¼ˆNoSQLæ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
iaskell 2012/07/09
æ¥½ã—ãã†

sql
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
iaskell 2011/08/10
sql

postgresql
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã® MySQL ã§100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹æ™‚ã«è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚
MySQL ã®å‹‰å¼·ã‚’ã›ãšã«ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ç‰ã§ SQL ã‚’æ›¸ã‹ãšã« Web ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿æ•°ã‚‚2ä¸‡ä»¶ç¨‹åº¦ã§ã—ãŸã®ã§ã€ãã“ã¾ã§å›°ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›ž100ä¸‡å¼±ã®å•†å“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†æ©Ÿä¼šãŒã§ããŸã®ã§ã€MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ç™ºè¡Œã™ã‚‹ SQL ã«ã¤ã„ã¦è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ MySQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã®ã«è¡Œã£ãŸå¯¾ç–ãªã©å‹‰å¼·ã—ãŸã‚‚ã®ã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã—ãŸã€‚ æ¡ä»¶å¼ã§æ¯”è¼ƒã™ã‚‹ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦é«˜é€ŸåŒ– å•†å“ã‚³ãƒ¼ãƒ‰ã§å˜åœ¨ã—ãªã„å•†å“ã‚’è¦‹ã¤ã‘ã¦ã€å•†å“ã‚’DBã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†å‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€4ä¸‡ä»¶è¶…ãˆãŸã“ã‚ã‹ã‚‰å‡¦ç†ã«2ç§’ä»¥ä¸Šã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã™ã€‚12ä¸‡ä»¶è¶…ãˆãŸé ƒã«ã¯10ç§’ç¨‹åº¦ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€å•†å“ã‚³ãƒ¼ãƒ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦ã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§0.2ç§’ã«çŸç¸®ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ MySQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚‚ä»¥ä¸‹ã®ã‚ˆ
iaskell 2011/07/26
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

mysql

sql
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
iaskell 2010/09/16
sql

ãƒã‚¿
ãƒªãƒ³ã‚¯
ã‚°ãƒªãƒ¼CTOãŒèªžã‚‹ã€å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºã®èˆžå°è£
9æœˆ1æ—¥ã€ã‚²ãƒ¼ãƒ é–‹ç™ºè€…å‘ã‘ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒCEDEC 2010ã€ã«ãŠã„ã¦ã€SNSã€ŒGREEã€ã‚’é‹å–¶ã™ã‚‹ã‚°ãƒªãƒ¼æ ªå¼ä¼šç¤¾ï¼ˆä»¥ä¸‹ ã‚°ãƒªãƒ¼ï¼‰ãŒã€Žå¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ã¤ãã‚Šã‹ãŸ ï½ž60åˆ†ã§ã‚ã‹ã‚‹ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰æŠ€è¡“ï½žã€ã¨é¡Œã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’è¬›æ¼”ã—ãŸã€‚ ä¸€æ—¥ã‚ãŸã‚Šå„„å˜ä½ã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒãã‚¤ãƒ³ãƒ•ãƒ©ã¯ã©ã†ãªã£ã¦ã„ã‚‹ã®ã‹ã€‚æŠ€è¡“è€…2åãŒè§£èª¬ã—ãŸã‚¤ãƒ³ãƒ•ãƒ©æ§‹ç¯‰ã®ãƒŽã‚¦ãƒã‚¦ã‚„ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¨ä¸€èˆ¬ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚²ãƒ¼ãƒ ã¨ã®é•ã„ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚²ãƒ¼ãƒ ã¨ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¨ã®é•ã„ æœ€è¿‘ãƒ†ãƒ¬ãƒ“CMã§ã‚‚ç›®ã«ã™ã‚‹æ©Ÿä¼šãŒå¤šããªã£ã¦ããŸSNSï¼ˆã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ï¼‰ã®ã€ŒGREEï¼ˆã‚°ãƒªãƒ¼ï¼‰ã€ã€‚2010å¹´6æœˆæ™‚ç‚¹ã®æ•°å—ã§ã€ä¼šå“¡æ•°2059ä¸‡äººã€æœˆé–“353å„„ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¨ã„ã†è¨€ã‚ãšã¨ã—ã‚ŒãŸå¤§äººæ°—ã‚µã‚¤ãƒˆã ã€‚ä¸ã§ã‚‚æºå¸¯é›»è©±å‘ã‘ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒç‰¹å¾´çš„ã§ã€å°‚ç”¨æ©Ÿå‘ã‘ã®ã‚²ãƒ¼ãƒ ã¨æ¯”ã¹ã‚‹ã¨ã‚³ã‚¢ã‚²ãƒ¼ãƒžãƒ¼ä»¥å¤–ã®ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚‚å¤šãã€åˆ©
iaskell 2010/09/14
WebDev

sql
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®cassandraå…¥é–€
@marqsã•ã‚“ã¨@muranetã•ã‚“ã¨ä¸€ç·’ã«hbstudy#11ã§ç™ºè¡¨ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã“ã‚Œã‚’æ©Ÿã«ã¨ã‹è¨€ã†ã¨ã§ã‹ã™ãŽã‚‹æ°—ãŒã—ã¾ã™ãŒCassandraãŒå›½å†…ã§ã‚‚ç››ã‚Šä¸ŠãŒã‚‹ã¨ã„ã„ãªãƒ¼ã¨æ€ã„ã¾ã™ã€‚ æ‡‡è¦ªä¼šã§ã‚‚çµæ§‹ä½¿ãŠã†ã¨ã—ã¦ã„ã‚‹æ–¹ãŒã„ãŸã‚Šã—ã¦ã†ã¡ã‚‚ã†ã‹ã†ã‹ã—ã¦ã‚‰ã‚Œãªã„ã§ã™ãï½— è³‡æ–™ã‚’ã‚ã’ã¾ã—ãŸã®ã§ã“ã¡ã‚‰ã‚ˆã‚ã—ã‹ã£ãŸã‚‰ã©ã†ãžï¼ ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®cassandraå…¥é–€ View more presentations from Akihiro Kuwano. ã“ã‚Œã ã‘ã¯ã‹ã‹ãªã„ã¨ï¼ ç´ æ™´ã‚‰ã—ã„ä¼šã‚’é–‹ã„ã¦ä¸‹ã•ã£ã¦ã„ã‚‹ãƒãƒ¼ãƒˆãƒ“ãƒ¼ãƒ„ã®æ–¹ã€…ã‚„ã€ã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼ã®æ–¹ã€…ã€æ¥ã¦ã„ãŸã ã„ãŸæ–¹ã€…ã«æ„Ÿè¬ã—ã¦ãŠã‚Šã¾ã™ éžå¸¸ã«æ¥½ã—ã‹ã£ãŸã§ã™ï¼ ãŸã ã„ã¾äºŒæ—¥é…”ã„ã§ã™w
iaskell 2010/05/16
sql

WebDev

Cassandra
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€NoSQLã€ãã—ã¦Cassandraã¨ã¯ | gihyo.jp
NoSQLãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®ç‰¹å¾´ã‚’ã‚‚ã†å°‘ã—ç´°ã‹ãæŒ™ã’ã¦ã¿ã¾ã™ã€‚åˆ†é‡ã®éƒ½åˆã‚‚ã‚ã‚Šå€‹åˆ¥ã«ã¯è§¦ã‚Œã¾ã›ã‚“ãŒã€ãã‚Œãžã‚Œã®NoSQLãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§å·®åˆ¥åŒ–éƒ¨åˆ†ã«é–¢ã—ã¦ã¯ã‹ãªã‚Šè©³ç´°ã«èª¬æ˜ŽãŒã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ãœã²ãã¡ã‚‰ã‚’å‚ç…§ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ é«˜é€Ÿã«å‹•ä½œã™ã‚‹ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¢ãƒ‡ãƒ«ã§ã¯ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆåž‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ ã‚³ãƒ¢ãƒ‡ã‚£ãƒ†ã‚£ã‚µãƒ¼ãƒã«ã‚ˆã£ã¦æ§‹ç¯‰ã•ã‚Œã‚‹ ã‚¹ã‚ãƒ¼ãƒžãƒ•ãƒªãƒ¼ SPOFï¼ˆå˜ä¸€æ•…éšœç‚¹ï¼‰ã‚’æŒãŸãªã„ è‡ªå‹•çš„ã«è¤‡æ•°å°ã¸ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹ ã‚¤ãƒ™ãƒ³ãƒãƒ¥ã‚¢ãƒ«ã‚³ãƒ³ã‚·ã‚¹ãƒ†ãƒ³ã‚·ã¾ãŸã¯ä¸€è²«æ€§ã®é¸æŠžãŒå¯èƒ½ SQLã®ã‚ˆã†ãªå¼·åŠ›ãªã‚¯ã‚¨ãƒªè¨€èªžã‚’æŒãŸãšã€ã‚·ãƒ³ãƒ—ãƒ«ãªå•ã„åˆã‚ã›ã—ã‹ã§ããªã„ Cassandraã¨ã¯ä½•ã‹ NoSQLãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®ç†é ã¨ã„ãˆã°Google BigTableã‚„Amazon Dynamoã§ã™ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã‚‚ã„ã‚ã„ã‚ãªã‚‚ã®ãŒå‡ºã¦ãã¦ã„ã¾ã™ã€‚ãã®ä¸ã§ã‚‚æœ€è¿‘ç‰¹ã«æ³¨ç›®ã‚’é›†ã‚ã¦ã„ã‚‹ã®ãŒã€Apach
iaskell 2010/04/28
SQL

WebDev
ãƒªãƒ³ã‚¯
ãªãœTwitterã¯ä½Žé…å»¶ã®ã¾ã¾ã‚¹ã‚±ãƒ¼ãƒ«ã§ããŸã®ã‹ ç§’é–“120ä¸‡ã¤ã¶ã‚„ãã‚’å‡¦ç†ã€Twitterã‚·ã‚¹ãƒ†ãƒ ã®â€œä»Šâ€ âˆ’ ï¼ IT
ãƒ¦ãƒ¼ã‚¶ãƒ¼åŒå£«ã®ã¤ãªãŒã‚Šã‚’å…ƒã«æ™‚ç³»åˆ—ã«140æ–‡å—ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’20å€‹ã»ã©è¡¨ç¤ºã™ã‚‹â€•â€•ã€‚Twitterã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€æ–‡å—ã«ã—ã¦ã—ã¾ã†ã¨å®Ÿã«ã‚·ãƒ³ãƒ—ãƒ«ã ãŒã€èƒŒå¾Œã«ã¯éžå¸¸ã«å¤§ããªæŠ€è¡“çš„ãƒãƒ£ãƒ¬ãƒ³ã‚¸ãŒæ¨ªãŸã‚ã£ã¦ã„ã‚‹ã€‚ã¤ã¶ã‚„ãæ•°ã¯æœˆé–“10å„„ä»¶ã‚’çªç ´ã€Twitterã‚’æµã‚Œã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸æ•°ã¯ç§’é–“120ä¸‡ã«ã‚‚é”ã—ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼åŒå£«ã®ã¤ãªãŒã‚Šã‚’è¡¨ã™ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ»ã‚°ãƒ©ãƒ•ã§ã™ã‚‰ãƒ¡ãƒ¢ãƒªã«è¼‰ã‚‹é‡ã‚’è¶…ãˆã¦ã„ã‚‹ã€‚é€”æ–¹ã‚‚ãªã„ã‚¹ã‚±ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¤ãªã„ã§ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€0.1ç§’ä»¥ä¸‹ã§Webãƒšãƒ¼ã‚¸ã®è¡¨ç¤ºã‚’å®Œäº†ã•ã›ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ãã®ãŸã‚ã«å„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯1ï½ž5msç¨‹åº¦ã§å¿œç”ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ Twitterã®ãƒªã‚¹ãƒˆæ©Ÿèƒ½ã®å®Ÿè£…ã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒªãƒ¼ãƒ€ãƒ¼ã‚’å‹™ã‚ãŸã“ã¨ã‚‚ã‚ã‚‹Nick Kallenæ°ãŒæ¥æ—¥ã—ã€2010å¹´4æœˆ19æ—¥ã‹ã‚‰2æ—¥é–“ã®äºˆå®šã§é–‹å‚¬ä¸ã®ã€ŒQCon Tokyo 2010ã€ã§åŸºèª¿è¬›æ¼”ã‚’è¡Œã£ãŸã€‚ã€ŒData Architecture
iaskell 2010/04/20
scale

WebDev

sql
ãƒªãƒ³ã‚¯
å¿«é©ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆç”Ÿæ´»ã¸ã®ç¬¬ä¸€æ©ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼
å…ˆæœˆã€Not Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆãŒå‡„ã„ï¼ã¨ã„ã†è©±ã‚’æ›¸ã„ãŸã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯å‡„ã„ãƒ¤ãƒ„ã ãŒã€ãƒŽã‚¦ãƒã‚¦ãŒã‚ã¾ã‚Šã‚¦ã‚§ãƒ–ä¸Šã§è¦‹ã¤ã‹ã‚‰ãªã„ã€‚å”¯ä¸€è¦‹ã¤ã‹ã‚‹æ—¥æœ¬èªžã®è¨˜äº‹ã¯ã€ã‚¦ãƒŽã‚¦ãƒ©ãƒœã«ã‚ˆã‚‹ã€Œå›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã ã€ã ã‘ã§ã‚ã‚‹ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯æ–¯æ³¢æ°ã«ã‚ˆã‚‹å˜ç‹¬ã®ä½œå“ã§ã‚ã‚‹ãŸã‚ã€æ–¯æ³¢æ°ã¯é–‹ç™ºã ã‘ã§æ‰‹ã„ã£ã±ã„ã§ã‚ã‚Šã€ä½¿ã„æ–¹ã®ç´¹ä»‹è¨˜äº‹ã‚’æ›¸ãã“ã¨ã¾ã§ã¯æ‰‹ãŒå›žã‚‰ãªã„ã®ã§ã‚ã‚ã†ã€‚ã“ã‚“ãªå‡„ã„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒè¶³ã‚Šãªã„ã›ã„ã§ä½¿ã£ã¦è²°ãˆãªã„ãªã‚“ã¦å‹¿ä½“ãªã„ï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€ä»Šæ—¥ã¯SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚å°‘ã—é•·ã„ã‚¨ãƒ³ãƒˆãƒªã§ã‚ã‚‹ãŒã€æœ€å¾Œã¾ã§ãŠä»˜ã
iaskell 2010/04/15
sql

WebDev

æœªèª
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: InnoDBã§COUNT()ã‚’æ‰±ã†éš›ã®æ³¨æ„äº‹é …ã‚ã‚Œã“ã‚Œã€‚
InnoDBã‚’ä½¿ã†ã¨ãã€MyISAMã¨æ¯”è¼ƒã—ã¦åº¦ã€…ã‚„ã‚ŠçŽ‰ã«æŒ™ã’ã‚‰ã‚Œã‚‹ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã€ŒCOUNT()ãŒé…ã„ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ç¢ºã‹ã«InnoDBã«ãŠã„ã¦è¡Œæ•°ã‚’å¼¾ãå‡ºã™ã®ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒå¿…è¦ãªã®ã ãŒã€ãã‚‚ãã‚‚MyISAMã®COUNT()ãŒé€Ÿã„ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œæ•°ã‚’ä¿æŒã—ã¦ã‚‹ï¼‰ã®ãŒç‰¹æ®Šãªã®ã§ã‚ã£ã¦ã€InnoDBãŒé…ã„ã‚ã‘ã§ã¯ãªã„ã®ã§ã‚ã‚‹ã€‚ã¨ã¯ã„ãˆã€é«˜é€ŸãªCOUNT()ã«ã¤ã„ã¦ã¯éœ€è¦ãŒå¤šãã€ã“ã®å•é¡Œã«ã¯å¤šãã®äººå–ã‚Šçµ„ã‚“ã§ãŠã‚‰ã‚Œã‚‹ã‚ˆã†ã ã€‚ã—ã‹ã—ãªãŒã‚‰ã€COUNT()ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯æœªã èªžã‚‰ã‚Œã¦ã„ãªã„ç‚¹ãŒã‚ã‚‹ã‚ˆã†ã«è¦‹å—ã‘ã‚‰ã‚Œã‚‹ã®ã§ã€ä»Šæ—¥ã¯COUNT()ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ COUNT(*)ã€COUNT(col)ã€COUNT(1)ã®é•ã„åŸºæœ¬çš„ãªã“ã¨ã§ã¯ã‚ã‚‹ãŒã€COUNT(*)ã¨COUNT(col)ã§ã¯æ„å‘³ãŒç•°ãªã‚‹ãŸã‚ã€ç•°ãªã‚‹çµæžœãŒè¿”ã•ã‚Œã‚‹å ´åˆãŒã‚ã‚‹ã€‚COUNT(*)ã¯ãƒ•ã‚§ãƒƒ
iaskell 2010/03/09
sql

å‰²ã¨ã©ã†ã§ã‚‚ã„ã„
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ç›®çš„åˆ¥ã«ä½¿ã„åˆ†ã‘ã‚‹ã¹ã—
å…ƒãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®SQL Serveré–‹ç™ºãƒãƒ¼ãƒ ã®ä¸€å“¡ã§ã‚ã‚Šã€ãã®å¾Œãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã¨ã—ã¦æ´»èºã€‚æ˜¨å¹´ã‚¢ãƒžã‚¾ãƒ³ã«ç§»ç±ã—ã¦ã€ç¾åœ¨ã¯Amazon Web Servicesã®ä¸Šç´šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹James Hamiltonæ°ãŒã€è‡ªèº«ã®ãƒ–ãƒã‚°ã®ã€ŒOne Size Does Not Fit Allã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã‘ã«ã¨ã©ã¾ã‚‰ãªã„å¹…åºƒã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡žã‚’4ã¤ã«åˆ†é¡žã—ã¦ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ 4ã¤ã®ç¨®é¡žã¨ã¯ã€Œæ©Ÿèƒ½å„ªå…ˆã€ã€Œã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£å„ªå…ˆã€ã€Œã‚·ãƒ³ãƒ—ãƒ«ã€ã€Œç›®çš„åˆ¥ã€ã§ã™ã€‚ Hamiltonæ°ã¯ã€ã‚¢ãƒžã‚¾ãƒ³ãŒAmazonã‚¯ãƒ©ã‚¦ãƒ‰ã§MySQLã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ãŸã¨ã“ã‚ã€ä»¥å‰ã‹ã‚‰æä¾›ã—ã¦ã„ãŸã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ã€ŒSimpleDBã€ã¯çµ‚äº†ã™ã‚‹ã®ã§ã¯ãªã„ã‹ã¨å¿ƒé…ã™ã‚‹å£°ãŒã‚ã£ãŸã“ã¨ã‚’æŒ™ã’ã€ I can understand why some might co
iaskell 2010/03/09
WebDev

sql
ãƒªãƒ³ã‚¯
1