[B! nosql] gfxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gfx id:gfx

nosqlã«é–¢ã™ã‚‹gfxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ - MySQL/Redis/MongoDB/Redshift
æœ€è¿‘ç™ºå£²ã•ã‚ŒãŸæŠ€è¡“è©•è«–ç¤¾ã®ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ã«å¯„ç¨¿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€Mongo DBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ æŠ€è¡“ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„ãƒ—ãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€Mongo DBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚è¨˜äº‹ã‚’å¯„ç¨¿ã—ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚è‡ªåˆ†ãŒå„æŠ€è¡“ã‚’ç¾æ™‚ç‚¹ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„å†…å®¹ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ»MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™
gfx 2014/04/16
RDBMS

NoSQL
ãƒªãƒ³ã‚¯
Transactd - ãƒ“ã‚ºã‚¹ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³æ ªå¼ä¼šç¤¾
Transactd Plugin 3.0 é«˜é€Ÿã‚¢ã‚¯ã‚»ã‚¹ã€é«˜æ©Ÿèƒ½ã€åˆ†æ•£ã‚¯ã‚¨ãƒªãƒ¼å¯èƒ½ MySQLç”¨NoSQLãƒ—ãƒ©ã‚°ã‚¤ãƒ³ é«˜é€Ÿã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ åž‚ç›´ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° æ°´å¹³ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° åˆ†æ•£ã‚¯ã‚¨ãƒªãƒ¼ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ SQLãƒ©ã‚¤ã‚¯ãªã‚¯ã‚¨ãƒªãƒ¼ Windows Linux Mac OS X C++ PHP Ruby ActiveX DOWNLOAD â†’ Transactd 3.0ã®æ©Ÿèƒ½ New! ã‚¹ã‚ãƒ¼ãƒžãƒ†ãƒ¼ãƒ–ãƒ«ãªã—ã§ã®ã‚¢ã‚¯ã‚»ã‚¹ New! ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®NULLå¯¾å¿œ New! ã™ã¹ã¦ã®MySQL/Mariadbãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®DATEåž‹ã€TIMEåž‹ã€DATETIMEåž‹ã€TIMESTAMPåž‹ã«å¯¾å¿œ New! ãƒ“ãƒƒãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å°‚ç”¨ã‚¯ãƒ©ã‚¹ã®è¿½åŠ New! ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã«å¯¾å¿œ New! MySQL5.7 / Mariadb10.1ã¸ã®å¯¾å¿œ Improved! SQLã¨ã®ç›¸äº’é‹ç”¨æ€§ã®å‘ä¸Š Improved! ãƒ†ã‚¹
gfx 2013/11/26
HandlerSocket, memcached pluginã¨ã®æ¯”è¼ƒã‚ã‚Š

mysql

nosql
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã€NoSQLè»½é‡ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒLevelDBã€ã‚’å…¬é–‹ã€‚Chromeãƒ–ãƒ©ã‚¦ã‚¶ã®IndexedDBã¨ã—ã¦æŽ¡ç”¨
LevelDBã¯SQLã‚’ã‚µãƒãƒ¼ãƒˆã›ãšã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼ã‚µãƒ¼ãƒåž‹ã§ã‚‚ãªãã€ã‚·ãƒ³ã‚°ãƒ«ãƒ—ãƒã‚»ã‚¹ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ã“ã¨ã‚’æƒ³å®šã—ãŸã„ã‚ã‚†ã‚‹NoSQLã®é«˜é€Ÿãªã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒˆã‚¦ã‚§ã‚¤ãƒˆãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ Chromeãƒ–ãƒ©ã‚¦ã‚¶ã§HTML5ã®ä»•æ§˜ã¨ã—ã¦ç–å®šä¸ã®IndexedDBã‚’å®Ÿè£…ã™ã‚‹ã‚‚ã®ã¨ã—ã¦é–‹ç™ºã•ã‚ŒãŸã‚ˆã†ã§ã™ï¼ˆãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ˜Žè¨˜ã•ã‚Œã¦ã„ãªã„ã®ã§ã™ãŒï¼‰ã€‚ LevelDBã‚’é–‹ç™ºã—ãŸç†ç”± LevelDBã®Webã‚µã‚¤ãƒˆã«ã‚ˆã‚‹ã¨ã€LevelDBã¯ä»¥ä¸‹ã®ä¸»ãªæ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ åŸºæœ¬çš„ãªæ“ä½œã¯ã€Put(key,value), Get(key), Delete(key) 1ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã—ã¦è¤‡æ•°ã®å¤‰æ›´æ“ä½œãŒå¯èƒ½ ãƒ‡ãƒ¼ã‚¿ã¯è‡ªå‹•çš„ã«åœ§ç¸®ã—ä¿å˜ã•ã‚Œã‚‹ Hacker Newsã®è¨˜äº‹ã«ã‚ˆã‚‹ã¨ã€å½“åˆã¯LevelDBã‚’é–‹ç™ºã™ã‚‹ä»£ã‚ã‚Šã«å¹³æž—å¹¹é›„æ°ãŒé–‹ç™ºã—ãŸTokyo Cabin
gfx 2011/05/17
NoSQL

DB
ãƒªãƒ³ã‚¯
Transactions on InnoDB Â» Blog Archive Â» Only God can make random selections
gfx 2011/04/12
MySQL

NoSQL
ãƒªãƒ³ã‚¯
NoSQLã®æˆåŠŸã¯1:10å•é¡Œã«ã‹ã‹ã£ã¦ã„ã‚‹:Kenn's Clairvoyance
ã“ã“2-3å¹´ã»ã©ã€ã„ã‚ã‚†ã‚‹éžSQLç³»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒãƒ›ãƒƒãƒˆãªè©±é¡Œã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚ã“ã®ãƒ ãƒ¼ãƒ–ãƒ¡ãƒ³ãƒˆã‚’ç·ç§°ã—ã¦ã€ŒNoSQL (Not-only SQL)ã€ã¨å‘¼ã°ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã‚ˆã†ã§ã™ã€‚ã¾ã‚‹ã§SQLã‚’å¦å®šã—ã¦ã„ã‚‹ã‹ã®ã‚ˆã†ãªèª¤è§£ã‚’æ‹›ãã‚„ã™ã„ç”¨èªžã§ã™ãŒã€ã‹ã¨ã„ã£ã¦ã‚ãƒ¼ãƒ»ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚„åˆ—æŒ‡å‘DBã‚’ç·ç§°ã§ãã‚‹ä»–ã®å‘¼ã³æ–¹ã‚‚ãªã„ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯NoSQLã¨ã„ã†ç”¨èªžã‚’ä½¿ã†ã“ã¨ã«ã—ã¾ã™ã€‚ Oracleã‚„MySQLãªã©ã®SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæˆç†Ÿã—ã¦ã„ãä¸€æ–¹ã§ã€SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç‰¹å¾´ã¥ã‘ã‚‹å¼±ç‚¹ã§ã‚ã‚‹æŸ”è»Ÿæ€§ã®ãªã•ã€å …ç‰¢ã•ã¨å¼•ãæ›ãˆã«çŠ ç‰²ã«ãªã£ãŸæ›´æ–°æ€§èƒ½ã®ä½Žã•ã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®é›£ã—ã•ãªã©ã‹ã‚‰ã€ã€Œä½•ã§ã‚‚ã‹ã‚“ã§ã‚‚RDBã€ã‹ã‚‰ã€Œç›®çš„ã«å¿œã˜ãŸæ°¸ç¶šåŒ–ã€ãŒæ¨¡ç´¢ã•ã‚Œã‚‹æµã‚Œã«ãªã£ã¦ãã¾ã—ãŸã€‚ æ™‚ã‚’åŒã˜ãã—ã¦ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã®ä¸–ç•Œã§ã‚‚ã€Memcachedã®ã‚‚ã¤ã‚·ãƒ³ãƒ—ãƒ«ãªAPIã®ä½¿ã„ã‚„ã™ã•ãŒè©•ä¾¡ã•ã‚Œã‚‹ä¸€æ–¹ã€LRUã«ã‚ˆ
gfx 2010/09/21
nosql

sql

kvs
ãƒªãƒ³ã‚¯
CouchDBã¨MongoDBã‚’æ¯”è¼ƒã—ã¦ã¿ãŸ - Masatomo Nakano Blog
ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ãªKVSã£ã¦ã“ã¨ã¨ã€å—é¢ãŒä¼¼ã¦ã„ã‚‹ã¨è¨€ã†ã“ã¨ãã‚‰ã„ã—ã‹æ¯”è¼ƒã™ã‚‹æ„å‘³ãŒãªã•ãã†ãªCouchDBã¨Mongo DBã ã‘ã©ã€ã“ã“2ï¼Œ3ãƒ¶æœˆã§ä¸¡æ–¹ã‚’ãã‚Œãªã‚Šã«çªã£è¾¼ã‚“ã§è¦‹ã¦ããŸã®ã§æ¯”è¼ƒã—ã¦ã¿ãŸã€‚å®Ÿè£…é¢ã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ã¨ã„ã†ã“ã¨ã‚ˆã‚Šã¯ã©ã¡ã‚‰ã‹ã¨ã„ã†ã¨(ç§ãŒæ„Ÿã˜ã‚‹)æ€æƒ³çš„ãªã‚‚ã®ã‚„ã€ãƒ¦ãƒ¼ã‚¶å´ã‹ã‚‰ã®è¦–ç‚¹ã§ã®æ¯”è¼ƒã€‚ å…±é€šã™ã‚‹ã¨ã“ã‚ ã“ã‚Œã¯ã‚‚ã†ç°¡å˜ã«ã€ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - RDBMSã®ã‚ˆã†ãªã‚«ãƒ©ãƒ ã¨è¨€ã£ãŸã‚‚ã®ã‚’æŒãŸãšã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã§å¥½ããªæƒ…å ±ã‚’å…¥ã‚Œã‚‰ã‚Œã‚‹ Javascript/JSONã‚’ä½¿ç”¨ - ãƒ‡ãƒ¼ã‚¿è‡ªä½“ã‚‚JSONã¨ã„ã†Javascriptç”±æ¥ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§æŒã¡(Mongo DBã¯JSONã‚’å…ƒã«ã—ãŸBSONã¨ã„ã†ã‚‚ã®ã ãŒ)ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ã‚¯ã‚»ã‚¹ã«ã¯Javascriptã‚’ä½¿ç”¨ã™ã‚‹ ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã‚ˆã†ã«è€ƒãˆã‚‰ã‚Œã¦ã„ã‚‹ NoSQLãªæµè¡Œ CouchDBã®ç‰¹å¾´ æ©Ÿèƒ½ã‚’é™å®šã—ã¦ã„ã‚‹
gfx 2010/08/29
DB

kvs

CouchDB

MongoDB

nosql
ãƒªãƒ³ã‚¯
1