[B! database][ACID] yassã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yass id:yass

databaseã¨ACIDã«é–¢ã™ã‚‹yassã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

ç‘æ³¢å¤§å¦ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è©±ã‚’ã—ã¦ãã¾ã—ãŸ - kuenishi's blog
ç‘æ³¢å¤§å¦ã®å·å³¶å…ˆç”Ÿã«å‘¼ã°ã‚Œã¦æœ¨ã€é‡‘ã¨æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ç‰¹åˆ¥è¬›ç¾©Dã¨ã„ã†ã‚„ã¤ã«å‚åŠ ã—ã¦ããŸã€‚ã“ã‚“ãªã“ã¨ã«ãªã‚‹ã¨ã¯æ€ã£ã¦ã„ãªã‹ã£ãŸãŒã€ã‚ã‚ã†ã“ã¨ã‹è¬›å¸«å´ã§å‘¼ã°ã‚Œã¦ã—ã¾ã„ã€æ€ãˆã°é ãã¸æ¥ãŸã‚‚ã®ã ã¨æ„Ÿæ…¨æ·±ã„ã€‚ãƒ•ãƒªã¯ã€ŒRiakã¨NoSQLã®è©±ã‚’ã—ã¦ã‚‚ã‚‰ãˆãŸã‚‰ã€ã¨ã„ã†éžå¸¸ã«è‡ªç”±åº¦ã®é«˜ã„å†…å®¹ãªã®ã§ã€ã›ã£ã‹ããªã®ã§åƒ•ã®çŸ¥ã£ã¦ã„ã‚‹ã“ã¨ã‚’å…¨éƒ¨è©°ã‚è¾¼ã‚“ã§è©±ã—ã¦ã‚„ã‚ã†ã¨æ€ã£ãŸã‚‰10åˆ†å»¶é•·ã—ã¦ã•ã‚‰ã«ã‚¹ãƒ©ã‚¤ãƒ‰10æžšåˆ†ãã‚‰ã„ã‚’æ¶ˆåŒ–ä¸è‰¯ã§çµ‚äº†ã¨ã„ã†ã€ã¿ã£ã¨ã‚‚ãªã„æ„Ÿã˜ã«ãªã£ã¦ã—ã¾ã£ãŸã€‚ã‹ãªã‚Šç«¯æŠ˜ã£ã¦ãƒã‚¤ãƒ³ãƒˆã ã‘èª¬æ˜Žã—ãŸã®ã§æµã‚ŒãŒåˆ†ã‹ã‚‰ãšè‹¦åŠ´ã—ãŸæ–¹ã‚‚å¤šã„ã¨æ€ã†ãŒã€ã¾ã‚åƒ•ã®æ€§æ ¼ãªã®ã§è¨±ã—ã¦ã»ã—ã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¬›ç¾©ã‚’ã²ã¨é€šã‚Šçµ‚ãˆãŸé™¢ç”Ÿãƒ¬ãƒ™ãƒ«ã‚’æƒ³å®šã—ã¦ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ä½œã£ãŸã®ã§ã€ã‚‚ã—ã‹ã™ã‚‹ã¨ã€ã‚ã‚Šã¨é›£ã—ã‹ã£ãŸã‚Šåˆ†ã‹ã‚Šã«ãã‹ã£ãŸã‚Šã™ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã®ã§ã€ã‚ã‹ã‚‰ãªã„ã“ã¨ãŒã‚ã£ãŸã‚‰é©å½“ã«è³ªå•ã—ã¦ãã ã•ã„ã€‚ è¨€ã„ãŸã‹ã£ãŸã“ã¨ã®æµã‚Œã‚’åƒ•ãªã‚Šã«ã¾ã¨ã‚ã‚‹ã¨
yass 2014/02/02
database

nosql

riak

cap

ACID
ãƒªãƒ³ã‚¯
é«˜é€Ÿãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’ã†ãŸã†SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDB 3.0ã€ãƒªãƒªãƒ¼ã‚¹ | OSDN Magazine
ç±³VoltDBã¯1æœˆ22æ—¥ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã€ŒVoltDB 3.0ã€ã‚’å…¬é–‹ã—ãŸã€‚ã‚¯ãƒ©ã‚¹ã‚¿ç’°å¢ƒã«ãŠã‘ã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®æ”¹å–„ã«ã‚ˆã‚Šã€ã•ã‚‰ã«ä½Žé…å»¶ã‚’å®Ÿç¾ã™ã‚‹ã¨ã„ã†ã€‚ VoltDBã¯ã€ã€ŒPostgresã€ã‚„ã€ŒIngresã€ãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’æ‰‹ãŒã‘ãŸMichael Stonebrakeræ°ãŒè¨è¨ˆã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚é«˜é€Ÿãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’ç‰¹å¾´ã¨ã—ã€ACIDã«éµå®ˆã—ãŸæ¬¡ä¸–ä»£ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ¨™æ¦œã—ã¦ã„ã‚‹ã€‚GPLv3ã§å…¬é–‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆï¼ˆCommunity Editionï¼‰ã¨ã€ã‚µãƒ–ã‚¹ã‚¯ãƒªãƒ—ã‚·ãƒ§ãƒ³å½¢å¼ã®å•†ç”¨ç‰ˆï¼ˆEnterprise Editionï¼‰ã®2ã¤ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0ã¯2011å¹´9æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³2.0ä»¥æ¥ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒªãƒªãƒ¼ã‚¹ã€‚æ€§èƒ½å´ã§ã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å†è¨è¨ˆã—ã€ã‚¯ãƒ©ã‚¹ã‚¿ã«ãŠã‘ã‚‹
yass 2013/01/28
VoltDB

ACID

database
ãƒªãƒ³ã‚¯
When is "ACID" ACID? Rarely. | Peter Bailis
RC: read committed, RR: repeatable read, S: serializability, SI: snapshot isolation, CS: cursor stability, CR: consistent read Instead of providing serializability, many these databases provide one of several weaker variants,2 often when marketing material and documentation claim otherwise.3 There is no fundamental reason why a database shouldnâ€™t support serializabilityâ€”we have the algorithms, and
yass 2013/01/26
ACID

database

nosql

concurrency

transaction

voltdb
ãƒªãƒ³ã‚¯
12å¹´å¾Œã®CAPå®šç†: "æ³•å‰‡"ã¯ã©ã®ã‚ˆã†ã«å¤‰ã‚ã£ãŸã‹
è¨è¨ˆè€…ã¯åˆ†å‰²ãŒç™ºç”Ÿã—ãŸã¨ãä¸€è²«æ€§ã¨å¯ç”¨æ€§ã®ã©ã¡ã‚‰ã‹ã‚’é¸ã¶å¿…è¦ãŒã‚ã‚Šã¾ã™ãŒã€åˆ†å‰²ã®æ‰±ã„æ–¹ã¨åˆ†å‰²ã®å¾©æ—§ã«ã¯æŸ”è»Ÿãªå¯¾å‡¦æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ç¾åœ¨ã®CAPã®ç›®çš„ã¯ç‰¹å®šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¿…è¦ã¨ã™ã‚‹ä¸€è²«æ€§ã¨å¯ç”¨æ€§ã‚’æœ€é©åŒ–ã™ã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ã“ã®ã‚ˆã†ãªæ–¹æ³•ã«ã¯åˆ†å‰²ç™ºç”Ÿä¸ã®è¨ˆç”»ã‚„åˆ†å‰²ã®å¾©æ—§è¨ˆç”»ãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€è¨è¨ˆè€…ã¯ã“ã®ã‚ˆã†ãªæ–¹æ³•ã‚’æŽ¡ç”¨ã™ã‚‹ã“ã¨ã§ã€å¾“æ¥å—ã‘å–ã‚‰ã‚Œã¦ããŸCAPã®é™ç•Œã‚’è¶…ãˆã¦CAPã«ã¤ã„ã¦è€ƒãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãªãœ"3ã¤ã®ã†ã¡2ã¤"ãŒãƒŸã‚¹ãƒªãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãªã®ã‹ CAPã‚’ç†è§£ã™ã‚‹æœ€ã‚‚ç°¡å˜ãªæ–¹æ³•ã¯åˆ†å‰²ã®ä¸¡å´ã«ã²ã¨ã¤ãšã¤ãƒŽãƒ¼ãƒ‰ãŒã‚ã‚‹å ´åˆã‚’è€ƒãˆã‚‹ã“ã¨ã§ã™ã€‚ç‰‡æ–¹ã®ãƒŽãƒ¼ãƒ‰ã ã‘çŠ¶æ…‹ã‚’æ›´æ–°ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨ã€2ã¤ã®ãƒŽãƒ¼ãƒ‰ã«ä¸€è²«æ€§ãŒãªããªã‚Šã¾ã™ã€‚ã¤ã¾ã‚Šã€CãŒå¤±ã‚ã‚Œã¾ã™ã€‚ä¸€è²«æ€§ã‚’ç¶æŒã—ã‚ˆã†ã¨ã™ã‚Œã°ã€ä¸€æ–¹ã®ãƒŽãƒ¼ãƒ‰ã¯åˆ©ç”¨ã§ããªã„çŠ¶æ…‹ã§ã‚ã‚‹ã‹ã®ã‚ˆã†ã«å‹•ä½œã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ã“ã®å ´åˆã€AãŒå¤±ã‚ã‚Œã¾ã™ã€‚ä¸€è²«æ€§ã¨
yass 2012/06/23
CAP

database

nosql

ACID
ãƒªãƒ³ã‚¯
1