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

hiro_y id:hiro_y

kvsã¨dbã«é–¢ã™ã‚‹hiro_yã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•.markdown #NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³• åŽŸæ–‡ï¼šNoSQL Data Modeling Techniques Â« Highly Scala ble Blog I translated this article for study. contact matope[dot]ono[gmail] if any probl em. NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ä¸€è²«æ€§ã¨ã„ã£ãŸæ§˜ã€…ãªéžæ©Ÿèƒ½è¦ä»¶ã‹ã‚‰æ¯”è¼ƒã•ã‚Œã‚‹ã€‚NoSQLã®ã“ã®å´é¢ã¯å®Ÿè·µã¨ç†è«–ã®ä¸¡é¢ã‹ã‚‰ã‚ˆãç ”ç©¶ã•ã‚Œã¦ã„ã‚‹ã€‚ã‚ã‚‹ç¨®ã®éžæ©Ÿèƒ½ç‰¹æ€§ã¯NoSQLã‚’åˆ©ç”¨ã™ã‚‹ä¸»ãªå‹•æ©Ÿã§ã‚ã‚Šã€NoSQLã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆãé©ç”¨ã•ã‚Œã‚‹CAPå®šç†ãŒãã†ã§ã‚ã‚‹ã‚ˆã†ã«åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã®åŸºæœ¬çš„åŽŸå‰‡ã ã‹ã‚‰ã ã€‚ä¸€æ–¹ã§ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯ã‚ã¾ã‚Šç ”ç©¶ã•ã‚Œã¦ãŠã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒžãƒ†ã‚£ãƒƒã‚¯
hiro_y 2012/04/17
NoSQLãƒ¢ãƒ‡ãƒªãƒ³ã‚°

kvs

db
ãƒªãƒ³ã‚¯
Webã‚¢ãƒ—ãƒªã‚’ã¨ã‚Šã¾ãæœ€è¿‘ã®KVSäº‹æƒ…ã€é›‘æ„Ÿ - Tous Les Jours æ”»é˜²è¨˜
RDBã®å¾©æ¨©ã¯ã—ã°ã‚‰ããªã„ã¨æ€ã† æœ€è¿‘ç›®ã«ã—ãŸã®ã¯ã€ã€Œã“ã‚Œã‹ã‚‰RDBãŒååˆ†é€Ÿããªã£ã¦ã„ãã®ã§ã€memcachedã«ä»£ã‚ã£ã¦RDBãŒã¾ãŸä½¿ã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€ã¨ã„ã†æ„è¦‹ã€‚ã“ã‚Œã¯ã—ã°ã‚‰ãã®é–“ã¯ç„¡ã„ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã†ã€‚å…¨ãƒ‡ãƒ¼ã‚¿ãŒã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã ã£ãŸã¨ã—ã¦ã‚‚ã€KVSã¯RDBã‚ˆã‚Šä¸€æ¡ä»¥ä¸Šé€Ÿã„ï¼ˆMemcachedã§100,000req/secå‡ºã›ã‚‹ãƒžã‚·ãƒ³ã§ã€MySQLã®pkeyã«ã‚ˆã‚‹å˜ç´”ãªSELECTã‚’ã—ãŸå ´åˆã€10,000req/secå‡ºã‚‹ã‹ã©ã†ã‹ï¼‰ã€‚SQLãƒ‘ãƒ¼ã‚µã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã‚’æ¨ã¦ãªã„é™ã‚Šã“ã®é€Ÿã•ã«ã¯å¯¾æŠ—ã§ããªã„ã€‚RDBã«ã¯ã€ï¼‘ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ï¼‘ã‚¹ãƒ¬ãƒƒãƒ‰ã¨ã„ã†ãƒ¢ãƒ‡ãƒ«ãŒæŒã¤ã€æŽ¥ç¶šæ•°ãŒã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã„ã¨ã„ã†åˆ¶ç´„ã‚‚ã‚ã‚‹ã€‚ ã¾ãŸã€memcacheãƒ—ãƒãƒˆã‚³ãƒ«ã¯ã€get_multiãŒä½¿ãˆã‚‹ã€‚get_multiã‚’åŠ¹æžœçš„ã«æ´»ç”¨ã—ãŸå ´åˆã€RDBã¨ã®å·®ã¯ã•ã‚‰ã«åºƒãŒã‚‹ã¨æ€ã†ã€‚ RDBã§å¤§ä¸ˆå¤«ãªã‚¢ãƒ—ãƒªã‚‚ Viewã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒåŠ¹æžœçš„ãªã‚¢
hiro_y 2009/11/15
KVSã®å„ªä½æ€§ã€ãã—ã¦RDBã¨é•ã£ã¦è«¦ã‚ãªã‘ã‚Œã°ã„ã‘ãªã„ã“ã¨ã€‚ã€Œãƒ¬ãƒ³ã‚¸ã‚¯ã‚¨ãƒªãŒä½¿ãˆãªã„å ´åˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ§‹é€ è‡ªä½“ã‚’KVSä¸Šã®ï¼‘ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ã—ã¦æŒã¤å¿…è¦ãŒã‚ã‚‹ã€ã¨ã‹ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æœ‰ç„¡ã¨ã‹ã€‚

kvs

db
ãƒªãƒ³ã‚¯
key-value stores: Anti-RDBMS: A list of distributed key-value stores | Richard Jones, Esq.
Please Note: this was written January 2009 - see the comments for updates and additional information. A lot has changed since I wrote this. Perhaps youâ€™re considering using a dedicated key-value or document store instead of a traditional relational database. Reasons for this might include: You're suffering from Cloud-computing Mania. You need an excuse to 'get your Erlang on' You heard CouchDB was
hiro_y 2009/10/20
KVSæ¯”è¼ƒã€‚æ—¥æœ¬ã‹ã‚‰ã¯KaiãŒã€‚MemcacheDBã®è©•ä¾¡é«˜ã„ã€‚

kvs

db
ãƒªãƒ³ã‚¯
https://memcachedb.org/
hiro_y 2009/10/07
ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«Berkeley DBã‚’ä½¿ã†memcachedãƒ—ãƒãƒˆã‚³ãƒ«äº’æ›ã®KVSã€‚

db

kvs

memcache
ãƒªãƒ³ã‚¯
up and running with cassandra
Cassandra is a hybrid non-relational database in the same class as Googleâ€™s BigTable. It is more featureful than a key/value store like Riak, but supports fewer query types than a document store like Mongo DB. Cassandra was started by Facebook and later transf erred to the open-source community. It is an ideal runtime database for web-scale domains like social networks. This post is both a tutorial
hiro_y 2009/07/07
Cassandraã®Rubyã‹ã‚‰ã®ä½¿ã„æ–¹ã€‚Twitterã§ä½¿ã†ã®ã‹ãªã€‚ã€ŒWe're beginning to use Cassandra at Twitterã€

db

kvs

ruby

twitter
ãƒªãƒ³ã‚¯
Facebookã€Googleã®BigTableãƒ©ã‚¤ã‚¯ãªãƒ—ãƒãƒ€ã‚¯ãƒˆã€ŒCassandraã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–
Code Archive Skip to content Google About Google Privacy Terms
hiro_y 2009/07/07
Facebookã«ã‚ˆã‚‹BigTableã¿ãŸã„ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€‚

db

kvs

facebook
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ãƒžã‚¸ã‚«ã‚¸ãƒ£ãƒ‘ãƒ³ã®ç¾½ç”Ÿç« æ´‹ãŒæ›¸ã„ã¦ã‚‹ãƒ–ãƒã‚°:ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
ã¨ã„ã†ãŠé¡Œã§åŽŸç¨¿ã‚’æ›¸ãã¾ã›ã‚“ã‹ï¼Ÿã€€ã¨ã„ã†ãƒ¡ãƒ¼ãƒ«ãŒã“ã®é€±æœ«ã«æŸèªŒã®æŸç·¨é›†ã•ã‚“ã‹ã‚‰æ¥ãŸã®ã§ã™ãŒã€æŠ€è¡“çš„ãªã“ã¨ã«ã¤ã„ã¦ã¯æ£ç›´ãªã¾ãã‚‰ã«ãªã£ã¦ã„ã‚‹ã®ã§åŽŸç¨¿æ–™ã‚’é ‚ã‘ã‚‹ãƒ¬ãƒ™ãƒ«ã§ã¯ã¡ã‚‡ã£ã¨æ›¸ã‘ãªã„ãªãã€ã¨è…°ãŒå¼•ã‘ã¦ã„ã¾ã™ã€‚ã¨ã¯ã„ãˆã€ä½•ã‚‚æ€ã„ãŒãªã„ã‚ã‘ã§ã‚‚ãªã„ã®ã§ã€æˆ¯ã‚Œè¨€ã‚’åž‚ã‚Œæµã—ã¦ã¿ã¾ã™ã€‚å°šã€æœ¬å½“ã«åž‚ã‚Œæµã—ã§ã‚ã£ã¦çµè«–ã‚‚ä½•ã‚‚ãªã„ã®ã§äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ ãƒ»æ“ä½œè¨€èªž æœ€åˆã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨ã„ã†ã®ã¯ã€RDBMSã ã¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã§ã‚ã‚‹ã€ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‹éšŽå±¤åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‹XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‹è‰²ã€…ã¨ã‚ã‚Šã¾ã™ãŒã€è¦ã™ã‚‹ã«ã©ã†ã„ã†æ¦‚å¿µã«åŸºã¥ã„ã¦ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã®ã‹ã¨ã„ã†è€ƒãˆæ–¹ã«ã¤ã„ã¦ã®è©±ã§ã™ã€‚ã‚ˆãã€Œãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã€ã¨ã„ã†è¨€è‘‰ãŒã‚ã‚Šã¾ã™ãŒã€ã‚ã‚Œã¯ãƒ¢ãƒ‡ãƒªãƒ³ã‚°è¨€èªžï¼ˆå›³è¨€èªžï¼‰ã‚’åˆ©ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆæ‰‹æ³•ã®è©±ã§
hiro_y 2009/04/20
key-valueã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨RDBMSã¨ã€‚

db

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

db

kvs

system

mysql
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
hiro_y 2009/02/27
ãƒ¡ãƒ¢ãƒªä¸Šã«ä¿å˜ã™ã‚‹key-value storageã€‚ãƒ‡ã‚£ã‚¹ã‚¯æ›¸ãå‡ºã—ã«ã‚‚å¯¾å¿œã€å€¤ã¨ã—ã¦ãƒªã‚¹ãƒˆã‚„ã‚»ãƒƒãƒˆã‚‚è¨å®šå¯èƒ½ã€‚http://www.atmarkit.co.jp/news/200902/26/redis.html

redis

kvs

db
ãƒªãƒ³ã‚¯
RDBMSã‚’Key-Value Storageã¨ã—ã¦ä½¿ã†å ´åˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¨ˆæ¸¬ï¼ˆH2, MySQLç·¨ï¼‰ - kaisehã®ãƒ–ãƒã‚°
Tokyo Cabinet, QDBM, Lux IOãªã©ã€DBMåŒå£«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã¯Webã§è‰¯ãè¦‹ã‹ã‘ã‚‹ã®ã§ã™ãŒã€MySQLã®ã‚ˆã†ãªæ™®é€šã®RDBMSã‚’Key-Value Storageçš„ã«ä½¿ç”¨ã—ãŸå ´åˆã€DBMã¨æ¯”ã¹ã¦ã©ã‚Œãã‚‰ã„å·®ãŒä»˜ãã‚‚ã®ãªã®ã‹ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒæ¹§ã‹ãªã‹ã£ãŸã®ã§ã€å®Ÿéš›ã«è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚ Javaãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ã€Berkeley DBã€H2ã€MySQLã®3ç¨®é¡žã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚æ¡ä»¶ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Berkeley DB Java Edition 3.3.75 ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®š H2 1.1.106 jdbc:h2:file:~/dbmbench Embeddedãƒ¢ãƒ¼ãƒ‰ã§ä½¿ç”¨ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®š DDLã¯ä»¥ä¸‹ã‚’ä½¿ç”¨ create table casket ( id integer auto_increment primary key, key_ varchar(255
hiro_y 2009/02/26
Berkeley DB/H2/MySQLã‚’å˜ç´”ãªkey-value storeã¨ã—ã¦ä½¿ã£ãŸå ´åˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã€‚ã€Œvalueã®ã‚µã‚¤ã‚ºãŒå¢—åŠ ã—ãŸã¨ãã€H2ã¨MySQLã§ã¯ã‚ã‚‹åœ°ç‚¹ã‚’å¢ƒã«æ€¥ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒåŠ£åŒ–ã™ã‚‹ã€

db

h2

mysql

kvs
ãƒªãƒ³ã‚¯
1