[B! db] choplinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

choplin id:choplin

dbã«é–¢ã™ã‚‹choplinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

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

Developer FAQ/ja - PostgreSQL wiki
é–‹ç™ºã¸ã®å‚åŠ ã©ã®ã‚ˆã†ã«ã™ã‚Œã° PostgreSQL ã®é–‹ç™ºã«å‚åŠ ã§ãã¾ã™ã‹? ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦èªã‚“ã§ãã ã•ã„ã€‚ è©³ç´°ã¯ã€Œæœ€æ–°ã®ã‚½ãƒ¼ã‚¹ãƒ„ãƒªãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹æ–¹æ³•ã€ã¾ãŸæœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã«è¿½éšã™ã‚‹æ–¹æ³•ã¯ï¼Ÿã€ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ã€‚ pgsql-hackers ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆ ("hackers" ã¨å‘¼ã°ã‚Œã¾ã™) ã«å‚åŠ ã—ã€èªã‚“ã§ãã ã•ã„ã€‚ã“ã“ã¯ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ä¸»è¦é–‹ç™ºè€…ã‚„ã‚³ã‚¢ãƒ¡ãƒ³ãƒãŒé–‹ç™ºã«ã¤ã„ã¦è°è«–ã™ã‚‹å ´ã§ã™ã€‚ æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ãƒ„ãƒªãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹æ–¹æ³•ã€ã¾ãŸæœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã«è¿½éšã™ã‚‹æ–¹æ³•ã¯ï¼Ÿ ã‚½ãƒ¼ã‚¹ãƒ„ãƒªãƒ¼ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã¯å¹¾ã¤ã‹ã‚ã‚Šã¾ã™ã€‚ãŸã¾ã«é–‹ç™ºã«å‚åŠ ã™ã‚‹ã ã‘ã®äººã¯æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ãƒ„ãƒªãƒ¼ãƒ»ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’ ftp://ftp.postgresql.org/pub/snapshot/ ã‹ã‚‰å–å¾—ã§ãã¾ã™ã€‚ ä¸€èˆ¬çš„ãªé–‹ç™ºè€…ã¯ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã« anonymous ã§ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦å–å¾—ã—ã¦ã„ã¾ã™
choplin 2011/02/09
DB

PostgreSQL
ãƒªãƒ³ã‚¯
é–‹ç™ºãƒ¡ãƒ¢: ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªDBï¼‹ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã§çˆ†é€Ÿæ°¸ç¶šã‚ãƒ£ãƒƒã‚·ãƒ¥
Kyoto Tycoonã«è‡ªå‹•ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ©Ÿèƒ½ãŒå®Ÿè£…ã•ã‚Œã€ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªDBã§ã‚‚æ°¸ç¶šåŒ–ã§ãã‚‹ã«ã‚ˆã«ãªã‚Šã€é«˜é€Ÿæ€§ã¨æ°¸ç¶šæ€§ã‚’ä¸¡ç«‹ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã‚ˆã¨ã„ã†è©± è‡ªå‹•ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã¨ã¯ ã€Œæ°¸ç¶šåŒ–ã—ãŸã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã€ã¨ã—ã¦ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã‚’æŽ²ã’ã‚‹Kyoto Tycoonã ãŒã€ãã‚Œã¯ãƒ¡ãƒ¢ãƒªä¸Šã§ãªããƒ•ã‚¡ã‚¤ãƒ«ä¸Šã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¡¨ç¾ã™ã‚‹ã‹ã‚‰ã§ã‚ã‚‹ã€‚ä»Šå›žã®è‡ªå‹•ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã«ã‚ˆã‚‹æ°¸ç¶šåŒ–ã¯ã€ãã‚Œã¨ã¯ç•°ãªã‚‹ã€‚ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªDBã®ä¸ã«ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å®šæœŸçš„ã«ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã™ã“ã¨ã§æ°¸ç¶šåŒ–ã™ã‚‹ã®ã ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«DBã®å ´åˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯å¸¸ã«ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚ã‚ˆã£ã¦ã€ã‚µãƒ¼ãƒãƒ—ãƒã‚»ã‚¹ã‚’å†èµ·å‹•ã—ã¦ã‚‚ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯æ¶ˆãˆãªã„ã€‚ãã®ä»£å„Ÿã¨ã—ã¦ã€ãƒ•ã‚¡ã‚¤ãƒ«ä¸Šã§æ›´æ–°ã•ã‚ŒãŸé ˜åŸŸã‚’ãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãè¾¼ã‚€ãŸã‚ã®IOå‡¦ç†ã«ã‹ã‹ã‚‹ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ãŒç„¡è¦–ã§ããªã„ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ãƒšãƒ¼ã‚¸ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã‚ˆã£ã¦ç·©å’Œã•ã‚Œã‚‹ã¨ã¯ã„ãˆã€IOå‡¦ç†ãŒãƒ©ãƒ³ãƒ€ãƒ ã‚¢
choplin 2011/01/19
db

redis

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

Kyoto Tycoon

kvs
ãƒªãƒ³ã‚¯
http://agilecatcloud.com/2009/06/28/database-sharding-_1/
choplin 2010/12/29
db

è¨è¨ˆ

åˆ†æ•£

sharding
ãƒªãƒ³ã‚¯
NoSQLã‚’RDBã®ä»£ã‚ã‚Šã«ä½¿ã†ã¨ã€ã©ã†ã„ã†æã‚ã—ã„ã“ã¨ãŒèµ·ã“ã‚‹ã‹ã€‚PARTAKEã®ä½œè€…ãŒèªžã‚‹
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã„ã¾æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ã®ãŒNoSQLã€‚ç‰¹ã«ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ã€ã‚°ãƒ¼ã‚°ãƒ«ã®BigTableã€Facebookã‚„TwitterãŒå†…éƒ¨ã§åˆ©ç”¨ã—ã¦ã„ã‚‹Cassandraã‚„Amazonã‚¯ãƒ©ã‚¦ãƒ‰ãŒæä¾›ã—ã¦ã„ã‚‹SimpleDBãªã©ã€ã™ã§ã«å®Ÿéš›ã«ä½¿ã‚ã‚Œå§‹ã‚ã¦ã„ã¾ã™ã€‚ ã§ã¯ãã®NoSQLã‚’ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»£ã‚ã‚Šã«ä½¿ã£ã¦ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã™ã‚‹ã¨ã©ã†ãªã‚‹ã®ã‹ï¼Ÿ èº«ã‚’ã‚‚ã£ã¦ä½“é¨“ã—ãŸã“ã¨ã‚’è¨˜ã—ãŸShinya Kawanakaæ°ã«ã‚ˆã‚‹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã€Œé–“é•ã£ãŸæ–¹å‘ã«Cassandraã‚’ä½¿ã£ã¦ã¿ãŸã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ NoSQLã‚’ç”¨ã„ãŸã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹æ§‹ç¯‰ã©ã†é•ã†ã®ã‹ï¼Ÿ ã¨ã¦ã‚‚åˆ†ã‹ã‚Šã‚„ã™ãã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ã”æœ¬äººã®æ‰¿è«¾ã‚‚ã„ãŸã ã„ãŸã®ã§ã€ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ NoSQLã‚’ä½¿ã£ãŸã¨ãã«èµ·ã“ã‚‹æã‚ã—ã„äº‹ä¾‹ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ†ãƒ¼ãƒžã¯ã€ŒNoSQLã‚’
choplin 2010/12/21
NoSQLã¯Domain Specific Databaseã‹ã€‚ãªã‚‹ã»ã©ã€‚KVSã¨RDBã®ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ãŒåˆ†ã‹ã‚Šã‚„ã™ãç´¹ä»‹ã•ã‚Œã¦ã‚‹ã€‚

NoSQL

cassandra

DB

RDB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã„ã¾ã™ãä½¿ãˆã‚‹ç„¡æ–™ã®ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒClearDBã€
ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚‚ã—ã¦ãã‚Œã‚‹ã®ã§é‹ç”¨ã®æ‰‹é–“ãŒã‹ã‹ã‚‰ãªã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚ãã‚“ãªã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ã¦ã„ã‚‹æä¾›ã—ã¦ã„ã‚‹ã®ãŒã€ŒclearDBã€ã§ã™ã€‚ 1ã¤å‰ã®è¨˜äº‹ã§ã¯ä¼æ¥å‘ã‘ã®ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã€ŒYammerã€ã‚’ç´¹ä»‹ã—ã€ç«¶åˆã¨ãªã‚Šãã†ãªã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãƒ»ãƒ‰ãƒƒãƒˆã‚³ãƒ ã®Chatterã‚‚ç„¡æ–™ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã™ã‚‹ã¨ç´¹ä»‹ã—ã¾ã—ãŸãŒã€ä»Šå›žã®ClearDBã‚‚ã€ã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãƒ»ãƒ‰ãƒƒãƒˆã‚³ãƒ ãŒç™ºè¡¨ã—ãŸã°ã‹ã‚Šã®ã€ŒDatabase.comã€ã¨åŒæ§˜ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ç‹™ã£ãŸã‚ã‘ã§ã¯ãªã„ã®ã§ã™ãŒâ€¦â€¦ã€‚ clearDBã®Webã‚µã‚¤ãƒˆã‹ã‚‰ã€ã©ã®ã‚ˆã†ãªã‚µãƒ¼ãƒ“ã‚¹ãªã®ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§100ï¼…ACIDå¯¾å¿œã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ clearDBã¯100ï¼…ACIDã«å¯¾å¿œã—ã€è‡ªå‹•çš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚ŒãŸã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ã€ŒWhat is ClearDB?
choplin 2010/12/16
SQL

db

ã‚¯ãƒ©ã‚¦ãƒ‰

database

Webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
ã€Œç¬¬1å›ž MongoDB JP ï¼† CouchDB JP åˆåŒå‹‰å¼·ä¼š in Tokyoã€ã‚’é–‹å‚¬ã—ã¦ãã¾ã—ãŸï¼ - doryokujin's blog
ã“ã‚“ã«ã¡ã¯ã€@doryokujinã§ã™ã€‚æœ¬æ—¥ã¯12æœˆ12æ—¥ï¼ˆæ—¥ï¼‰è¡Œã‚ã‚Œã¾ã—ãŸã€Œç¬¬1å›ž Mongo DB JP ï¼† CouchDB JP åˆåŒå‹‰å¼·ä¼š in Tokyoã€ã®å ±å‘Šã‚’ã—ã¾ã™ã€‚å½“æ—¥ã¯å¿™ã—ã„æ™‚æœŸã«ã‚‚é–¢ã‚ã‚‰ãšãŸãã•ã‚“ã®äººã«å‚åŠ ã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ä¼šå ´æº–å‚™ã§è‰²ã€…ã‚’æ‰‹é–“å–ã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä¼šå ´æä¾›è€…ã®ãƒ‹ãƒ•ãƒ†ã‚£ã•ã‚“ã¨å‚åŠ è€…ã®çš†æ§˜ã®æš–ã‹ã„ã”å”åŠ›ã‚‚ã‚ã£ã¦ç„¡äº‹ã«å‹‰å¼·ä¼šã‚’çµ‚ãˆã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸï¼ã¾ãŸã€å½“æ—¥ã¯gihyo.jpã•ã‚“ã®å”åŠ›ã®ã‚‚ã¨ã€Ustreamé…ä¿¡ã‚‚è¡Œã„ã¾ã—ãŸã€‚ã“ã®Ustreamå‹•ç”»ã¨å…±ã«å‹‰å¼·ä¼šå ±å‘Šã®æ–¹ã‚’gihyo.jpã•ã‚“ã®æ–¹ã«ã‚‚æ›¸ã‹ã›ã¦ã„ãŸã ãäºˆå®šã§ã™ã®ã§ãœã²ã¨ã‚‚ãã¡ã‚‰ã®æ–¹ã‚‚å®œã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ä»Šå›žã®å‹‰å¼·ä¼šã®ãƒ„ã‚¤ãƒ¼ãƒˆãŒã¾ã¨ã‚ã‚‰ã‚ŒãŸTogetterï¼šç¬¬1å›ž Mongo DB JP & CouchDB JP åˆåŒå‹‰å¼·ä¼š in Tokyoã‚‚ãªã‹ãªã‹ãŒè‡¨å ´æ„ŸãŒã‚ã£ã¦é¢
choplin 2010/12/13
ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸï¼æ¥½ã—ã‹ã£ãŸã§ã™ã€‚æ¬¡ã¯ä½•ã‹ã—ã‚ƒã¹ã‚ŠãŸã„ã€‚

mongodb

å‹‰å¼·ä¼š

db

ã‚¤ãƒ™ãƒ³ãƒˆ

CouchDB

presentation
ãƒªãƒ³ã‚¯
XMLDBã‚„KVSã¯ç ´å£Šçš„æŠ€è¡“ã«ãªã‚Šå¾—ã‚‹ã‹ï¼Ÿ ï¼ˆ1/2ï¼‰- ï¼ IT
å¤ãŒè¿«ã£ã¦ãã¾ã—ãŸãã€‚ä»Šæœˆã¯MySQL 5.5ã€Club DB2ã«ç™»å ´ã—ãŸãƒŸãƒƒã‚¯ã•ã‚“ã€ãã‚Œã‹ã‚‰VoltDBãªã©ã«ã¤ã„ã¦ãŠä¼ãˆã—ã¾ã™ã€‚ æ€§èƒ½ã¨åˆ©ä¾¿æ€§ã¨ã‚‚ã«å‘ä¸Š MySQL 5.5 2010å¹´4æœˆã«ã‚¢ãƒ¡ãƒªã‚«ã§é–‹å‚¬ã•ã‚ŒãŸMySQL Conference ï¼† Expoã®åŸºèª¿è¬›æ¼”ã§ã€ŒMySQL 5.5ã€ãŒç´¹ä»‹ã•ã‚Œã¦ä»¥æ¥ã€æ¬¡ç¬¬ã«MySQLæ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®å§¿ãŒæ˜Žã‚‰ã‹ã«ãªã‚Šã¤ã¤ã‚ã‚Šã¾ã™ã€‚MySQLã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã¯ã‚ã‚Šã¾ã™ãŒã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºç‰ˆã‚‚ã‚ã‚Šã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨å•†ç”¨ã®2ã¤ã®é¡”ã‚’æŒã¤RDBã¨ã‚‚ã„ãˆã¾ã™ãã€‚ ã•ã¦ç¾åœ¨é–‹ç™ºä¸ã®MySQLã«ã¤ã„ã¦ã€‚ç¾è¡Œã®GAï¼ˆGenerally Availableï¼‰ç‰ˆã¯5.1ã§ã™ã€‚å°‘ã—å‰ã«5.4ã‚‚å‡ºã¾ã—ãŸãŒã€ç¾åœ¨ã¯5.5ã§é–‹ç™ºãŒé€²ã‚“ã§ã„ã¾ã™ã€‚ã€Œ5.4ã¯ã©ã“ã¸ï¼Ÿã€ã¨å¿ƒé…ã—ãªãã¦ã‚‚å¤§ä¸ˆå¤«ã€‚5.5ã«ã¯InnoDBã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸ5.4ã®æ”¹å–„äº‹é …ã‚‚ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ã é–‹ç™ºä¸
choplin 2010/12/13
programming

db

kvs
ãƒªãƒ³ã‚¯
SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ SSDãŒHDDã«ä»£ã‚ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦æ™®åŠã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã“ã¨ã‚’èƒŒæ™¯ã«ã€SSDã«ç‰¹åŒ–ã—ãŸã¾ã£ãŸãæ–°ã—ã„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å‚™ãˆãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é–‹ç™ºã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ä¼æ¥ãŒã‚ã‚Šã¾ã™ã€‚ã€ŒReThinkDBã€ã§ã™ã€‚ æ˜¨å¹´7æœˆã«ã€Publickeyã§ã¯ReThinkDBã®æ¦‚è¦ã‚’è¨˜äº‹ã€ŒSSDã«æœ€é©åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒRethinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿç¾ã€ã§ä¼ãˆã¾ã—ãŸã€‚ ãã®è¨˜äº‹ã®ä¸ã§ã¯ã€ReThinkDBãŒãƒãƒƒã‚¯ã‚’ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨ä¸ã§ã‚‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒã¨ã‚Œã€ã¾ãŸç•°å¸¸çµ‚äº†ã—ã¦ã‚‚å®¹æ˜“ã«å¾©å¸°ã§ãã‚‹æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ 4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§ã«è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Ex
choplin 2010/12/13
SSD

db

ReThinkDB

architecture

è¨è¨ˆ
ãƒªãƒ³ã‚¯
ç‹¬ã‚Šè¨€v6 Â» SSDæ™‚ä»£ã«ãªã£ã¦RDBMSã®é€†è¥²ã¯ã‚ã‚‹ã‹ã€€ãƒ¼ã€€ReThinkDBã®è©¦ã¿ã‚’èªã¿è§£ã
ä»Šæ—¥ã‚‚çªç„¶Twitterã§RDBMSã¨NoSQLå‘¨ã‚Šã®ä¼šè©±ã«è‹¥å¹²å·»ãè¾¼ã¾ã‚ŒãŸã‚ã‘ã ã‘ã©ã€å®Ÿéš›ã«ã©ã£ã¡ãŒå‹ã¤ã®ã‹ã®å¸°çµã‚’äºˆæ¸¬ã™ã‚‹ã®ã¯éžå¸¸ã«é›£ã—ã„ã€‚ NoSQLã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨å¯ç”¨æ€§ã¯å¤§å¤‰ç´ æ™´ã‚‰ã—ã„ã—ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘è¨€èªžã¨ã®ç›¸æ€§ã‚‚O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã«æ¯”ã¹ã‚Œã°æŠœç¾¤ã«ã‚ˆã„ã€‚ã—ã‹ã—ä¸€æ–¹ã§ã€SQLã¨è¨€ã†è¨€èªžã¨ãã®å®Ÿè£…ã«ã¯ç™–ãŒã‚ã‚‹ã¨ã¯ã„ãˆã€RDBMSã§å®Ÿç¾ã§ãã‚‹æŸ”è»Ÿæ€§ã¯æ¨ã¦ãŒãŸã„ã—ã€ACIDãŒä¿è¨¼ã•ã‚Œã¦ã„ã‚‹ã—ã€æ—¢å˜è³‡ç”£ãŒæµç”¨ã§ãã‚‹ã“ã¨ã‚‚å¤§ãã„ã€‚ãƒã‚¤ãƒ³ãƒˆã¯ãã®ACIDãŒã©ã‚Œã ã‘é‡è¦ã§ã‚ã‚‹ã‹ã¨ã„ã†ã“ã¨ã¨ã€æ€§èƒ½é¢ã ã‚ã†ã¨æ€ã£ã¦ã„ã‚‹ã€‚ã¤ã¾ã‚ŠNoSQLã§ãªã„ã¨ã‚³ã‚¹ãƒˆãƒ¡ãƒªãƒƒãƒˆãŒå‡ºãªã„ã»ã©å¤§è¦æ¨¡ã§ã‚ã‚Œã°NoSQLå„ªå‹¢ã€ãã†ã§ãªã„éƒ¨åˆ†ã¯RDBMSã§ã€ã¨ã„ã†ã“ã¨ã ã€‚ã‚ã¾ã‚Šã«æ™®é€šã§å¤±æœ›ã—ãŸã€ã¨è¨€ã‚ã‚Œãã†ã ãŒã€‚ ã¾ã‚ãã‚Œã¯ãŠã„ã¦ãŠã„ã¦ã€æœ€è¿‘RDBMSã®æ€§èƒ½ã‚’å¾ŒæŠ¼ã—ã™ã‚‹ã ã‚ã†ã¨è€ƒãˆã‚‰ã‚Œã¦ã„ã‚‹å˜åœ¨ãŒã€ãƒžãƒ«ãƒã‚³ã‚¢CPUã¨SSD
choplin 2010/12/13
RDBMS

NoSQL

SSD

db

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
kumofsã‚’ãƒ™ãƒ¼ã‚¹ã«RDBMSç”¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã£ã¦ä½œã‚Œãªã„ã‚‚ã®ã‹ | ç‹¬ã‚Šè¨€v6
ã¾ã è‡ªåˆ†ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ç¢ºã‹ã‚ã¦ã„ãªã„ãŒã€kumofsã«èˆˆå‘³æ´¥ã€…ã§ã‚ã‚‹ã€‚ä½•ãŒèˆˆå‘³æ·±ã„ã‹ã¨ã„ã†ã¨ã€ã¾ã‚ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã§ä¸”ã¤è€éšœå®³æ€§ã«å„ªã‚Œã‚‹ã¨ã“ã‚ã ã€‚ã‚‚ã¡ã‚ã‚“ãã‚Œã ã‘ãªã‚‰åˆ†æ•£KVSã¨ã„ã†ã“ã¨ã§ã‚ã‚‹ç¨‹åº¦äºˆæƒ³ã•ã‚ŒãŸæ©Ÿèƒ½ã§ã‚ã‚‹ã€‚å€‹äººçš„ãªèˆˆå‘³ã¨ã—ã¦ã¯ã€Œã“ã®ç¨®ã®KVSã‚’ä½¿ã£ã¦RDBMSã‚‚ã©ããŒä½œã‚Œãªã„ã‹ã€ã¨ã„ã†ã¨ã“ã‚ã«ã‚ã‚‹ã€‚ ã“ã®æ§‹æƒ³ã¯ è¶… ä¸¦åˆ—RDBMSã¯æˆç«‹ã™ã‚‹ã‹ â€“ L.starçš„ãƒ‡ã‚¶ã‚¤ãƒ³ï¼ˆï¼‘ï¼‰ ã§ãšã„ã¶ã‚“å‰ã‹ã‚‰æš–ã‚ã¦ã„ã‚‹ã‚‚ã®ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã„ã†ãƒªã‚½ãƒ¼ã‚¹ãƒŽãƒ¼ãƒ‰ã‚’kumofsã§ä»£ç”¨ã§ããªã„ã‹ã¨ã„ã†ã‚‚ã®ã ã€‚å¼•ç”¨ã—ã¦ã€æ©Ÿèƒ½çš„ãªå®Ÿè£…ã®å¿…è¦ã§ãªã„ã‚‚ã®ã‚’é™¤ãã¨ ãƒªã‚½ãƒ¼ã‚¹ãƒŽãƒ¼ãƒ‰ storage engineã§ã‚ã‚‹ DDLçš„ã«ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«è¿‘ã„ä½ç½®ã¥ã‘ã¨ã—ã¦å®šç¾©å¯èƒ½ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã€‚ sequential scan, index scan, seq scan+sortã‚’è¡Œã„ã€ãã®çµæžœã‚’è¿”ã™DBã§ã‚ã‚‹ã€‚M
choplin 2010/12/13
RDBMS

kvs

db

KVS

åˆ†æ•£

kumofs
ãƒªãƒ³ã‚¯
Comparing VoltDB to Postgres
I've been asked a few times recently for my opinion on VoltDB, the new database server architected by the 'father' of Postgres, Dr Michael Stonebraker so rather than repeating myself over and over again it seems like a good idea to write it all down. VoltDB is an in-memory, lockless relational database that maintains ACID compliance, has a SQL interface and claims to offer massive performance incr
choplin 2010/12/13
voltdb

postgres

db

kvs

rdb

æ¯”è¼ƒ

postgresql
ãƒªãƒ³ã‚¯
Volt Active Data and YCSB - Volt Active Data
YCSB is a well known benchmark that was devised by a group at Yahoo! Research led by Brian F. Cooper. It came about because the proliferation of what the authors call â€˜cloud serving systemsâ€™, and the need to be able to do â€˜apples to applesâ€™ comparisons between them. Between 2005 and 2015 we saw an explosion of new database techno logies being released. As Iâ€™ve pointed out before, a lot of these are
choplin 2010/12/13
NoSQL

voltdb

kvs

performance

benchmark

cassandra

db
ãƒªãƒ³ã‚¯
ç‹¬ã‚Šè¨€v6 Â» VoltDBã¯ä½•æ•…æ—©ã„ã®ã‹ã¯å•é¡Œã§ã¯ãªã„ã€‚ä½•ã‚’ã™ã‚‹ãŸã‚ã®ã‚·ã‚¹ãƒ†ãƒ ãªã®ã‹ãŒå•é¡Œã
ã¡ã‚‡ã£ã¨å°æ—…è¡Œã«å‡ºã¦ã„ã‚‹é–“ã«ã‚¢ã‚¯ã‚»ã‚¹ãŒä¼¸ã³ã¦ã„ã¦ã€ãŠã‹ã’ã•ã¾ã§å‰å›žã®VoltDBã®ã‚¨ãƒ³ãƒˆãƒªãŒå¤§äººæ°—ã ã£ãŸã‚ˆã†ã ã€‚ã¾ã ã¾ã æ›¸ãè¶³ã‚Šãªã„éƒ¨åˆ†ãŒã„ã£ã±ã„ã‚ã£ãŸã®ã§ã€è£œè¶³ã™ã‚‹æ„å‘³ã‚‚è¾¼ã‚ã¦æ›¸ãè¶³ã—ã¦ã¿ãŸã„ã€‚ãã‚Œã¯ã€H-StoreãŒå¾“æ¥åž‹RDBMSã¨ã©ã‚Œã»ã©ç•°ãªã£ãŸã‚·ã‚¹ãƒ†ãƒ ã‹ã€ã¨ã„ã†ã“ã¨ã ã€‚ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã®è©±ã‚„å¤§ã¾ã‹ãªè©±ã¯ã—ãŸãŒã€å‰æã¨ãªã‚‹éƒ¨åˆ†ã®è©±ã¯ãšã„ã¶ã‚“æŠœã‘ã¦ã—ã¾ã£ã¦ã„ãŸã€‚ NoSQLã‚’è¶…ãˆã‚‹SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDBã€ã€‚Cassnadraã¨ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯å¯¾æ±ºï¼ ã§ã€å®Ÿéš›ã«Cassandraã¨æ¯”ã¹ã¦æ¤œè¨Žã—ã¦ã„ã‚‹ Key-Value Benchmarking ã¨ã„ã†è¨˜äº‹ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¦èˆˆå‘³æ·±ã„ã€‚ã§ã€ãªãŠã‹ã¤å‹ã£ã¦ã„ã‚‹ã¨è¨€ã†ã‹ã‚‰ç—›å¿«ã ã€‚ã¾ã‚å€‹äººçš„ã«ã¯ã“ã®å‹è² ã¯é«˜ã€…ï¼“ãƒŽãƒ¼ãƒ‰ã—ã‹ä½¿ã£ã¦ã„ãªã„æ™‚ç‚¹ã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å‹ã‚‹KVSã«ãšã„ã¶ã‚“ä¸åˆ©ãªå†…å®¹ã ãªã€ã¨è¨€ã‚ã–ã‚‹ã‚’å¾—ãªã„ã€‚ã›ã„ãœã„12ãƒŽãƒ¼ãƒ‰ãã‚‰ã„ã§ã—ã‹
choplin 2010/12/13
NoSQL

SQL

RDBMS

postgres

db

voltdb
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
choplin 2010/10/08
db

postgreSQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ã‚·ã‚§ãƒ«
ãƒªãƒ³ã‚¯
TwitterãŒåˆ†æ•£ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒGizzardã€å…¬é–‹ï¼ Scalaã§æ›¸ã‹ã‚ŒãŸShardingã‚’å®Ÿç¾ã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢
TwitterãŒåˆ†æ•£ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒGizzardã€å…¬é–‹ï¼ Scalaã§æ›¸ã‹ã‚ŒãŸShardingã‚’å®Ÿç¾ã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ Twitterã¯ç‹¬è‡ªã«é–‹ç™ºã—ãŸåˆ†æ•£ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ã€ŒGizzardã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚Gizzardã¯Scalaã§æ›¸ã‹ã‚ŒãŸJavaVMä¸Šã§å‹•ä½œã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã€PHPã‚„Rubyã¨ã„ã£ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®è¦æ±‚ã‚’è‡ªå‹•çš„ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åˆ†æ•£ã™ã‚‹ã“ã¨ã§ã€å¤§è¦æ¨¡ã§å¯ç”¨æ€§ã®é«˜ã„åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®¹æ˜“ã«å®Ÿç¾ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ Gizzardï¼šãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆãªåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ The Twitter Engineering Blog: Introducing Gizzard, a framework for creating distributed datastores Twitterã®ãƒ–ãƒã‚°ã«ãƒã‚¹ãƒˆã•ã‚ŒãŸã€ŒIntroducing Gizzard
choplin 2010/10/08
DB

sharding

gizzard

framework

ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯

åˆ†æ•£

scala
ãƒªãƒ³ã‚¯
ä¼æ¥ã¯ãªãœNoSQLã«èˆˆå‘³ãŒãªã„ã®ã‹ï¼Ÿ
ä¼æ¥ã®ITæ‹…å½“è€…ã®44ï¼…ãŒNoSQLã‚’çŸ¥ã‚‰ãšã€ã¾ãŸ17ï¼…ã¯èˆˆå‘³ãŒãªã„ã€ã¨ã„ã†çµæžœãŒã€ReadWrite Webã®è¨˜äº‹ã€ŒNoSQL? Never Heard of It, Say Most IT Prosã€ï¼ˆNoSQLï¼Ÿ èžã„ãŸã“ã¨ãªã„ãªã‚ã€ã¨å¤šãã®ITæ‹…å½“è€…ï¼‰ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯ç±³Information WeekãŒ755äººã®ITæ‹…å½“è€…ã«å¯¾ã—ã¦è¡Œã£ãŸçµæžœã‚’ç´¹ä»‹ã—ãŸã‚‚ã®ã€‚é€†ã«ã€NoSQLã‚’ã™ã§ã«åˆ©ç”¨ã—ã¦ã„ã‚‹ã€ã‚‚ã—ãã¯ãƒ†ã‚¹ãƒˆã—ã¦ã„ã‚‹ä¼æ¥ã¯5ï¼…ã—ã‹ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ ãªãœNoSQLã¯ä¼æ¥ã®ITæ‹…å½“è€…ã«ã¨ã£ã¦èˆˆå‘³ãŒãªã„ã‚‚ã®ãªã®ã‹ï¼Ÿ è‘—åãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç ”ç©¶è€…ã§ã‚ã‚Šã€ã¾ãŸWebã‚¹ã‚±ãƒ¼ãƒ«ã«å¯¾å¿œã—ãŸæ–°ãŸãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDBã€ã®é–‹ç™ºãªã©ã‚‚è¡Œã£ã¦ã„ã‚‹ãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ãŒã€ç±³å›½ã®è¨ˆç®—æ©Ÿå¦ä¼šã§ã‚ã‚‹ACMã®Webã‚µã‚¤ãƒˆã€ŒCommunications of the ACMã€ã«æŽ²
choplin 2010/10/08
NoSQL

ITæ¥ç•Œ

ä¼æ¥

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

SQL

DB

DBMS
ãƒªãƒ³ã‚¯
NoSQLã«ã¤ã„ã¦çŸ¥ã£ã¦ãŠãã¹ã10ã®äº‹æŸ„
TechRebublicã«ã€Œ10 things you should know about NoSQL databasesã€ï¼ˆNoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦çŸ¥ã£ã¦ãŠãã¹ã10ã®äº‹æŸ„ï¼‰ã¨ã„ã†è¨˜äº‹ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ã®ç¾çŠ¶ãŒã‚ˆãã¾ã¨ã¾ã£ã¦ã„ã‚‹å†…å®¹ã§ã—ãŸã®ã§ã€è¦‹å‡ºã—ã¨ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 10ã®äº‹æŸ„ã¯å‰åŠã¨å¾ŒåŠã®2ã¤ã«åˆ†ã‹ã‚Œã¦ã„ã¦ã€å‰åŠã®5ã¤ã§ã¯NoSQLã®åˆ©ç‚¹ã«ã¤ã„ã¦èª¬æ˜Žã•ã‚Œã¦ãŠã‚Šã€å¾ŒåŠã®5ã¤ã¯èª²é¡Œã«ã¤ã„ã¦èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚åŽŸæ–‡ã¯ãã‚Œãªã‚Šã«é•·ã„èª¬æ˜ŽãŒã•ã‚Œã¦ã„ã‚‹ã®ã§ã€è©³ã—ãã¯åŽŸæ–‡ã‚’ãœã²è¦‹ã¦ã¿ã¦ãã ã•ã„ã€‚ä»¥ä¸‹ã¯ãã‚Œã‚’1è¡Œç¨‹åº¦ã«è¦ç´„ã—ãŸã‚‚ã®ã§ã™ã€‚ 5ã¤ã®NoSQLã®åˆ©ç‚¹ Five advantages of NoSQL 1ï¼šElastic scaling ï¼ˆå¼¾åŠ›æ€§ã®ã‚ã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ï¼‰ NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€ãƒŽãƒ¼ãƒ‰ã®è¿½åŠ ã«ã‚ˆã‚‹æ‹¡å¼µæ€§ã«æŸ”è»Ÿã«å¯¾
choplin 2010/09/09
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

NoSQL

DB

kvs

hadoop
ãƒªãƒ³ã‚¯
java2perl6api â€“ Java to Perl 6 API translation â€“ What, Why, and Whereto
In this post Iâ€™m going to talk about the java2perl6api project. What its goals are, why I think itâ€™s important, how it relates to a Perl 6 DBI, what exists now, whatâ€™s needs doing, and how you can help. Firstly Iâ€™d like to point out that, funnily enough, Iâ€™m not very familiar with Java or Perl6. Itâ€™s entirely possible that Iâ€™ll make all sorts of errors in the following details. If you spot any do
choplin 2010/08/18
perl6

java

perl

db
ãƒªãƒ³ã‚¯
ã“ã‚Œã‚’çŸ¥ã£ã¦ãŠã‹ãªã„ã¨ã€MySQLã‚µãƒ¼ãƒã®å†èµ·å‹•ã§DBãƒ‡ãƒ¼ã‚¿ã®ä¸æ•´åˆãŒç™ºç”Ÿã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ - ã‚ˆã‹ã‚ã†ã‚‚ã‚“ï¼
Railsã«é™ã‚‰ãšã€MySQL(Innodb)ã‚’åˆ©ç”¨ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™º/é‹ç”¨ã—ã¦ã„ã‚‹ãªã‚‰ã€ã“ã‚Œã‹ã‚‰è§£èª¬ã™ã‚‹å†…å®¹ã‚’çŸ¥ã£ã¦ãŠã‹ãªã„ã¨ã€äºˆæœŸã—ãªã„ãƒ‡ãƒ¼ã‚¿ä¸æ•´åˆã‚’ç™ºç”Ÿã•ã›ã¦ã—ã¾ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ãƒ‡ãƒ¼ã‚¿ä¸æ•´åˆãŒç™ºç”Ÿã—ã¦ã—ã¾ã£ãŸã‚‰ã€æœ¬æ¥ã‚ã‚‹ã¹ãçŠ¶æ…‹ã«æˆ»ã™ã®ã¯ã‹ãªã‚Šé›£æ˜“åº¦ãŒé«˜ã„ãŸã‚ã€é–‹ç™º/é‹ç”¨ã‚’ã—ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã€ãƒ‡ãƒ¼ã‚¿ä¸æ•´åˆã‚’èµ·ã“ã•ãªã„ã‚ˆã†ã«ã™ã¹ãã§ã™ã€‚ ã§ã¯ã€ã©ã®ã‚ˆã†ãªã“ã¨ã‚’ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ä¸æ•´åˆã‚’ã„ã¨ã‚‚ç°¡å˜ã«ç™ºç”Ÿã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã¾ãšã¯ã€ä½•ãŒåŽŸå› ã§ãƒ‡ãƒ¼ã‚¿ä¸æ•´åˆãŒç™ºç”Ÿã™ã‚‹ã‹ã®ç°¡å˜ãªãƒ¢ãƒ‡ãƒ«ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªUserã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’createã—ã—ãŸã¨ã—ã¾ã™ã€‚ User.create(:name => "interu, :age => "27") ã™ã‚‹ã¨ã€Userãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ãŒè¿½åŠ ã•ã‚Œã¾ã™ã€‚ â– Userãƒ†ãƒ¼ãƒ–ãƒ« id name age 1 user_a 30 2 use
choplin 2010/08/18
ã‚µãƒ¼ãƒ

mysql

innodb

DB

rails

ruby

é‹ç”¨
ãƒªãƒ³ã‚¯
Hadoopãƒ¢ãƒ‡ãƒªãƒ³ã‚°åº§è«‡ä¼š#2 - ç§‘å¦ã¨éžç§‘å¦ã®è¿·å®®
æ¦‚è¦ ã‚¤ãƒ™ãƒ³ãƒˆå Hadoopã‚’ä¸å¿ƒã¨ã—ãŸåˆ†æ•£ç’°å¢ƒã§ã®é–‹ç™ºæ–¹æ³•è«–ãƒ»ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ»è¨è¨ˆæ‰‹æ³•ç‰ã«ã¤ã„ã¦ã®åº§è«‡ä¼š(ç¬¬äºŒå›ž) URL http://atnd.org/events/5987 æ—¥æ™‚ 2010/07/26 18:00 - 20:00 å ´æ‰€ ã‚¹ã‚¿ãƒ¼ç ”ä¿®ã‚»ãƒ³ã‚¿ãƒ¼ã€€å¾¡èŒ¶ãƒŽæ°´ Sunï¼ˆã‚µãƒ³ï¼‰1F twitterãƒãƒƒã‚·ãƒ¥ã‚¿ã‚° #hadoopModeling ã‚¹ãƒ¼ãƒ„è‹¥å¹²å¤šã‚ å¹´é½¢ã‚„ã‚„é«˜ã‚ å¥³æ€§ã»ã¼çš†ç„¡ #1 @shot6 å¤§è°·æ™‹å¹³ ç¾çŠ¶ã¨ç‰¹å¾´ Hadoop ã®ç¾çŠ¶ ä¸Šä½ãƒ¬ã‚¤ãƒ¤ã®é–‹ç™ºãŒãƒ›ãƒƒãƒˆ æ—¥æœ¬èªžã‚‚å……å®Ÿ Nosql ã®ç¾çŠ¶ åŠ ç†±ã—éŽãŽ Twitter ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã¯ã„ã„å†·å´å‰¤ RDBMS ã®ç¾çŠ¶ æˆç†Ÿ Mysql ã®é–‹ç™ºè€…ã¯Mariadb & Drizzle ã¸ ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚‚æ–°è¦å‚å…¥è€…ã‚‚æ¸›å°‘ Hadoop ã®ç‰¹å¾´ big data Yahoo 3PB/day Facebook 90TB/day Nos
choplin 2010/07/29
é–‹ç™º

hadoop

åˆ†æ•£å‡¦ç†

ã‚¤ãƒ™ãƒ³ãƒˆ

db
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸