[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] abcb2ã®ãƒ

abcb2 id:abcb2

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹abcb2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

ç±³ã‚¹ã‚¿ãƒ³ãƒ•ã‚©ãƒ¼ãƒ‰å¤§å¦ãŒã€Œæ©Ÿæ¢°å¦ç¿’ã€ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã€Œäººå·¥çŸ¥èƒ½ã€ã®ç„¡æ–™ã‚ªãƒ³ãƒ©ã‚¤ãƒ³æŽˆæ¥ã‚’ä»Šç§‹ã‹ã‚‰é–‹å§‹ âˆ’ Publickey
ç±³ã‚¹ã‚¿ãƒ³ãƒ•ã‚©ãƒ¼ãƒ‰å¤§å¦ã¯ã€ä»Šç§‹ã‹ã‚‰åŒå¤§å¦ã§è¡Œã‚ã‚Œã¦ã„ã‚‹ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹ã®è¬›ç¾©ã®ã†ã¡ã€3ã¤ã®ã‚³ãƒ¼ã‚¹ã‚’ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§ç„¡æ–™å…¬é–‹ã™ã‚‹ã“ã¨ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ å…¬é–‹ã•ã‚Œã‚‹ã®ã¯ã€ã€ŒMachine Learningã€ï¼ˆæ©Ÿæ¢°å¦ç¿’ï¼‰ã€ã€ŒIntroduction to Databasesã€ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ï¼‰ã€ã€ŒIntroduction to Artificial Intelligenceã€ï¼ˆäººå·¥çŸ¥èƒ½å…¥é–€ï¼‰ã®3ã‚³ãƒ¼ã‚¹ã€‚ã©ã®ã‚³ãƒ¼ã‚¹ã‚‚ä»Šå¹´ã®10æœˆã«é–‹è¬›ã—12æœˆã«çµ‚äº†ã™ã‚‹3ã‚«æœˆé–“ã®äºˆå®šã€‚ã‚³ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã¯å®Ÿéš›ã®è¬›ç¾©ã¨ã»ã¼åŒæ§˜ã®å®¿é¡Œã‚‚ç”¨æ„ã•ã‚Œã€æå‡ºã™ã‚‹ã¨è‡ªå‹•æŽ¡ç‚¹ã—ã¦ãã‚Œã‚‹ã‚ˆã†ã§ã™ã€‚ æ©Ÿæ¢°å¦ç¿’ã®ã‚³ãƒ¼ã‚¹ã‚’æ‹…å½“ã™ã‚‹Andrew Ngå‡†æ•™æŽˆã¯ç™ºè¡¨ã®ä¸ã§æ¬¡ã®ã‚ˆã†ã«ã‚³ãƒ¡ãƒ³ãƒˆã—ã¦ã„ã¾ã™ã€‚ â€œBoth in the United States and elsewhere, many people simply do not have a
abcb2 2011/08/19
æ©Ÿæ¢°å¦ç¿’

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

äººå·¥çŸ¥èƒ½
ãƒªãƒ³ã‚¯
ã€ŒMySQL Casual Talks vol.2ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
ç¬¬1å›žã«å¼•ãç¶šãã€"ã‚ã¾ã‚Šã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã§ã¯ãªã„ï¼Ÿ"ãŒå®šèª¬ã¨ãªã‚Šã¤ã¤ã‚ã‚‹ï½—ã€ŒMySQL Casual Talksã€ã®ç¬¬2å›žãŒé–‹å‚¬ã•ã‚ŒãŸã®ã§ã€è¡Œã£ã¦ãã¾ã—ãŸã€‚å‰å›žã«å¼•ãç¶šãé¢ç™½ã‹ã£ãŸã®ã§ã€è‡ªåˆ†ã®ãƒ¡ãƒ¢æ›¸ãã‚’è²¼ã‚Šä»˜ã‘ã¦ãŠãã¾ã™ã€‚ (å…¨ç„¶è¿½ã„ã¤ã„ã¦ãªã„ãƒ¡ãƒ¢ã‚‚å¤šã„ã—ã€ã‚¹ãƒ”ãƒ¼ãƒ‰æ„ŸãŸã£ã·ã‚Šã ã£ãŸã®ã§é–“é•ã£ãŸè¨˜è¼‰ã‚‚ã‚ã‚‹ã‹ã‚‚ã§ã™ãŒã€ãã“ã¯ã”äº†æ‰¿ã‚’...) # ä¾‹ã«ã‚ˆã£ã¦ã€ç™ºè¡¨è³‡æ–™ãŒå‡ºæƒã£ãŸã‚‰ãã¡ã‚‰ã‚’è¦‹ã¦ã„ãŸã ã„ãŸæ–¹ãŒè‰¯ã„ã§ã™ã€‚ ã¡ãªã¿ã«ã€ç¬¬1å›žã®ãƒ¡ãƒ¢ã‚¨ãƒ³ãƒˆãƒªã¯ã€ã€ ã€ŒMySQL Casual Talks vol.1ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… è¿½è¨˜ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã‚‚ã¾ã¨ã‚çš„ã«ã€å…¬é–‹ã•ã‚ŒãŸè³‡æ–™ã‚‚ç´¹ä»‹ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ï½— MySQLã§NoSQL (@oinume) View more presentations from Kazuhiro Oinuma ç”Ÿæ²¼ã•ã‚“ã€å®Ÿã¯MySQLã¯
abcb2 2011/08/15
MySQL

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: å›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã
ã“ã‚“ã«ã¡ã¯ã€‚ä¸æ‘ã§ã™ã€‚ MySQLã«ã¯MyISAMã€InnoDBã€CSVãªã©ã®ã„ãã¤ã‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€çš†ã•ã‚“ã¯Spiderã¨ã„ã†ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’èžã„ãŸã“ã¨ã¯ã‚ã‚Šã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚Spider Storage Engineã¯æ–¯æ³¢å¥å¾³ã•ã‚“ã«ã‚ˆã‚Šä½œæˆã•ã‚ŒãŸDatabase Shardingã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§MySQL 5.1ã§åˆ©ç”¨å¯èƒ½ã§ã™ã€‚ å…ˆæ—¥ã€æŸé›†ã¾ã‚Šã§æ–¯æ³¢ã•ã‚“ã¨ãŠä¼šã„ã—ãŸã¨ãã«Spiderã‚’ä½œã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€æ—©é€Ÿè©³ã—ã„å†…å®¹ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ â€»Spiderã«ã¤ã„ã¦ã®èª¬æ˜Žè³‡æ–™ã¯MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2009ã«ã¦æ–¯æ³¢ã•ã‚“ãŒç™ºè¡¨ã•ã‚ŒãŸã¨ãã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ã‚¹ãƒ©ã‚¤ãƒ‰ã®ç›´ãƒªãƒ³ã‚¯ï¼ˆzipï¼‰ Spider Storage Engine ã«ã¤ã„ã¦ posted by (C)ãƒ•ã‚©ãƒˆè”µ Spider Storage Engineã¨ã¯ï¼Ÿ
abcb2 2011/07/24
mysql

spider

è² è·åˆ†æ•£

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

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

mysql
ãƒªãƒ³ã‚¯
ã¼ããŒPDOã‚’æŽ¡ç”¨ã—ãªã‹ã£ãŸã‚ã‘(Shift_JISã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³)
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´7æœˆ1æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚ è¿½è¨˜(2011/06/19) ã“ã“ã«æ¥ã¦æ€¥ã«ãƒ–ã‚¯ãƒžãŒè¿½åŠ ã•ã‚Œã¯ã˜ã‚ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰çŠ¶æ³ãŒæ”¹å–„ã—ã¦ã„ã¾ã™ã€‚PHP5.3.6(2011/03/17)ã«ã¦ã€PDOã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ç‰ˆã§ã€UNIXç‰ˆã®PHPã§ã¯è§£æ±ºã—ã¾ã—ãŸãŒã€Win
abcb2 2011/06/20
PHP

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
DBI-DBDã«ã¤ã„ã¦
DBI/DBDã®ä½¿ã„æ–¹ ã“ã®æ–‡ç« ã¯ã€perlã§cgiç‰ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã§ãã€SQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã‚’çŸ¥ã£ã¦ã„ã‚‹ã²ã¨ã‚’å¯¾è±¡ã«æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ãŸã€DBI/DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ã€perl5ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ï¼ˆé¢¨ï¼‰ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ã‚‚ã‚ã‚‹ç¨‹åº¦ä»¥ä¸Šã¯å¿…è¦ã§ã™ã€‚ DBI/DBDã¨ã¯ã€perlã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“ã‚’ã¨ã‚Šã‚‚ã£ã¦ãã‚Œã‚‹æ±Žç”¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã™ã€‚ DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‹ã‚‰ã§ãã¦ãŠã‚Šã€DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«å˜åœ¨ã—ã¾ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒžã¯ã€DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ãƒ«ãƒ¼ãƒ«ã«ã—ãŸãŒã£ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹ã“ã¨ã§ã€ã©ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚ã€åŒã˜ã‚ˆã†ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ã¯ã€DBD/pgï¼ˆPostgreSQLç”¨DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼‰ã‚’ä½¿ã£ãŸä¾‹ã‚’æç¤ºã—ã¾ã™ãŒã€åŸºæœ¬çš„ã«ã¯ã€ã©ã®ã‚ˆã†ãªDBç›¸æ‰‹ã§ã‚‚åŒæ§˜ã®ã“ã¨ãŒã§ãã¾ã™ã€‚
abcb2 2011/03/18
perl

DBI

sqlite

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
abcb2 2010/10/14
ã“ã‚Œã¯ã„ã„ã‚µã‚¤ãƒˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQL

DB

mysql
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹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ã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
abcb2 2010/09/16
SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Cassandraå…¥é–€ã¨ã€ã•ã‚‰ã«è©³ã—ãçŸ¥ã‚‹ãŸã‚ã®ãƒªã‚½ãƒ¼ã‚¹é›†
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€éžãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªæ§‹é€ ã‚’æŒã¤NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ï¼ˆNoSQLï¼Not Only SQLã€‚å‘½åã®çµŒç·¯ã¯ã“ã¡ã‚‰ï¼‰ã€‚ãã®NoSQLã®ä¸ã§ã€ã‚‚ã£ã¨ã‚‚æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®1ã¤ãŒApacheã®Cassandraã§ã™ã€‚ Cassandraã¯ã€Facebookã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®ãŸã‚ã«é–‹ç™ºã•ã‚Œã€ãã®å¾Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ãªã‚Šã€ç¾åœ¨ã§ã¯Apache Software Foundationã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¾åœ¨ã€Cassandraã¯Facebookã‚„Diggãªã©ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ã‚‚ã—ãã¯ä½¿ã†ã“ã¨ãŒæ¤œè¨Žã•ã‚Œã¦ã„ã‚‹ã¨ã•ã‚Œã€Twitterã§ã‚‚ï¼ˆãƒ„ã‚¤ãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã«ã¯ä½¿ã‚ã‚Œãªã„ã‚ˆã†ã§ã™ãŒã€ãã‚Œä»¥å¤–ã®ç”¨é€”ã§ï¼‰åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ Twitterã¨DiggãŒNoSQLã®ã€ŒCassandraã€ã‚’é¸ã¶ç†ç”± TwitterãŒã€Cassandr
abcb2 2010/07/28
cassandra

apache

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

NoSQL
ãƒªãƒ³ã‚¯
æ—¥æœ¬æ³•ä»¤å¤–å›½èªžè¨³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ - æ³•ä»¤æ¤œç´¢ - [æ³•ä»¤åã§æ¤œç´¢]
ç¿»è¨³ã«ã¤ã„ã¦ ã“ã®ã€Œæ—¥æœ¬æ³•ä»¤å¤–å›½èªžè¨³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã€ã«æŽ²è¼‰ã—ã¦ã„ã‚‹æ³•ä»¤ç¿»è¨³ã¯ã€æ£æ–‡ã§ã¯ãªãã€æœ€çµ‚æ”¹æ£ç‰ˆã§ãªã„æ³•ä»¤ã‚‚å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚æ³•çš„åŠ¹åŠ›ã‚’æœ‰ã™ã‚‹ã®ã¯æ—¥æœ¬èªžã®æ³•ä»¤è‡ªä½“ã§ã‚ã‚Šã€ç¿»è¨³ã¯ã‚ãã¾ã§ãã®ç†è§£ã‚’åŠ©ã‘ã‚‹ãŸã‚ã®å‚è€ƒè³‡æ–™ã§ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã®åˆ©ç”¨ã«ä¼´ã£ã¦ç™ºç”Ÿã—ãŸå•é¡Œã«ã¤ã„ã¦ã€ä¸€åˆ‡ã®è²¬ä»»ã‚’è² ã„ã‹ãã¾ã™ã®ã§ã€æ³•å¾‹ä¸Šã®å•é¡Œã«é–¢ã—ã¦ã¯ã€å®˜å ±ã«æŽ²è¼‰ã•ã‚ŒãŸæ—¥æœ¬èªžã®æ³•ä»¤ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã€Œæš«å®šç‰ˆã€ã«ã¤ã„ã¦ æ³•ä»¤åã«ã€Œï¼ˆæš«å®šç‰ˆï¼‰ã€ã¨è¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ç¿»è¨³ã¯ã€ãƒã‚¤ãƒ†ã‚£ãƒ–ã‚„æ³•ä»¤ç¿»è¨³å°‚é–€å®¶ã«ã‚ˆã‚‹ãƒã‚§ãƒƒã‚¯åŠã³ä¿®æ£å‰ã®ç¿»è¨³ã§ã‚ã‚Šã€ä»Šå¾Œã€ä¿®æ£ã•ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ å¼•ç”¨ã€è¤‡è£½ã€è»¢è¼‰ã«ã¤ã„ã¦ ã“ã®ã€Œæ—¥æœ¬æ³•ä»¤å¤–å›½èªžè¨³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã€ã«æŽ²è¼‰ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã€åˆ©ç”¨è¦ç´„ã«å¾“ã„ã€å¼•ç”¨ã—ã€è¤‡è£½ã—åˆã¯è»¢è¼‰ã—ã¦å·®ã—æ”¯ãˆã‚ã‚Šã¾ã›ã‚“ã€‚
abcb2 2010/07/23
è¶…ä¾¿åˆ©

æ³•å¾‹

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

kvs

SQL
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
abcb2 2010/06/25
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQL
ãƒªãƒ³ã‚¯
1