[B! dbms] bull2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

bull2 id:bull2

dbmsã«é–¢ã™ã‚‹bull2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Flash-Based DBMSã®æœ€å‰ç·š
ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ¡ãƒ¢ãƒªãƒ¼ã‚’ä½¿ã£ãŸSolid State Drive (SSD)ã®å®¹é‡ãŒ160GBã«åˆ°é”ã—ã€å¸‚å ´ä¾¡æ ¼ã‚‚ä¸‹ãŒã£ã¦ããŸã“ã¨ã«ã‚ˆã‚Šã€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®ä»£æ›¿å“ã¨ã—ã¦SSDã‚’ä½¿ã†ç”¨é€”ãŒã„ã‚ˆã„ã‚ˆç¾å®Ÿå‘³ã‚’å¸¯ã³ã¦ãã¾ã—ãŸã€‚ä½Žå®¹é‡ã®ã‚‚ã®ãªã‚‰æ—¢ã«iPodã‚„ãƒ‡ã‚¸ã‚«ãƒ¡ç”¨ã®ãƒ¡ãƒ‡ã‚£ã‚¢ãªã©èº«ã®å›žã‚Šã«ã‚‚æ™®åŠã—ã¦ãŠã‚Šã€å¸‚å ´ã§ã¯ã™ã§ã«ã€Œç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã€Œã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¸ãƒ¬ãƒ³ãƒžâ€•æŠ€è¡“é©æ–°ãŒå·¨å¤§ä¼æ¥ã‚’æ»…ã¼ã™ã¨ãã€ã‚ˆã‚Šï¼‰ã€ãŒèµ·ã“ã£ã¦ã„ã‚‹ã¨ã„ãˆã¾ã™ã€‚ï¼ˆHDDæè¼‰ã®Walkmanã¨ã‹æ—¢ã«æ»…ã‚“ã§ã„ã‚‹ä¾‹ã‚‚ã‚ã‚‹ã—ã€‚ã€‚ã€‚ï¼‰
bull2 2009/04/16
dbms

db

ssd

ç ”ç©¶
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«åˆ†ã‹ã£ã¦ãŠããŸã„ãƒˆãƒ©ãƒ³ã‚¸ã‚¹ã‚¿ã®ç¨®é¡ž âˆ’ ï¼ IT MONOist
ECã‚µã‚¤ãƒˆã‚’é¡Œæã«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã®å…¨å·¥ç¨‹ã‚’å¦ã¶æ–°ã‚·ãƒªãƒ¼ã‚ºã€Œã‚¤ãƒã‹ã‚‰å…¨éƒ¨ä½œã£ã¦ã¿ã‚ˆã†ã€ãŒã‚¹ã‚¿ãƒ¼ãƒˆã€‚ã‚·ãƒªãƒ¼ã‚ºç¬¬15å›žã¯ã€ã“ã“ã¾ã§ä½œæˆã—ã¦ããŸè¦æ±‚ä»•æ§˜æ›¸ã«å¯¾ã™ã‚‹ãƒ†ã‚¹ãƒˆã®ç¬¬1æ®µéšŽã¨ãªã‚‹ã€Œã‚»ãƒ«ãƒ•ãƒã‚§ãƒƒã‚¯ã€ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚
bull2 2008/05/26
db

dbms
ãƒªãƒ³ã‚¯
Tokyo Tyrantã«ã‚ˆã‚‹HAãƒãƒƒã‚·ãƒ¥DBã‚µãƒ¼ãƒã®æ§‹ç¯‰ - mixi engineer blog
æ¥å¹´ã®ãƒãƒ¬ãƒ³ã‚¿ã‚¤ãƒ³ãƒ‡ãƒ¼ã«ã€æ£ç¢ºã«ã¯ã€Œ2009-02-14T08:31:30+09:00ã€ã«ã€UNIXæ™‚é–“ãŒã€Œ1234567890ã€ã‚’è¿Žãˆã‚‹ã“ã¨ã‚’ç™ºè¦‹ã—ã¦ã¡ã‚‡ã£ã¨å¬‰ã—ã„mikioã§ã™ã€‚ã•ã¦ã€ä»Šå›žã¯é«˜åŠ¹çŽ‡ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒTokyo Tyrantã‚’ç”¨ã„ã¦HAãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ§‹ç¯‰ã™ã‚‹æ‰‹æ³•ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ã¡ã‚‡ã£ã¨é›£ã—ã„ã—éžå¸¸ã«é•·ã„å†…å®¹ãªã®ã§ã™ãŒã€æœ€å¾Œã¾ã§ãŠä»˜ãåˆã„ãã ã•ã„ã¾ã›ã€‚ å¯ç”¨æ€§ã¨ä¿å…¨æ€§ HAï¼ˆHigh Availabilityï¼šé«˜å¯ç”¨æ€§ï¼‰ã¨ã¯ã€å¯ç”¨æ€§ï¼ˆAvailabilityï¼‰ãŒé«˜ã„ã“ã¨ã§ã™ã€‚ãã‚Œã§ã¯èª¬æ˜Žã«ãªã£ã¦ã„ãªã„ã®ã§è©³ã—ãè¨€ã„æ›¿ãˆã¾ã™ã¨ã€ã‚·ã‚¹ãƒ†ãƒ ã«éšœå®³ãŒèµ·ãã«ããã™ã‚‹ã“ã¨ã¨ã€ãŸã¨ãˆéšœå®³ãŒèµ·ããŸã¨ã—ã¦ã‚‚ã§ãã‚‹ã ã‘è¿…é€Ÿã«å¾©æ—§ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã®ã‚·ã‚¹ãƒ†ãƒ ã¯ãƒ¦ãƒ¼ã‚¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ã¨ã„ã†ä¸æ ¸çš„å½¹å‰²ã‚’æ‹…ã†ãŸã‚ã€å¯ç”¨æ€§ã‚’é«˜ã‚ã‚‹ã“ã¨ã¯æœ€ã‚‚é‡è¦ãªèª²é¡Œã¨ãªã‚Šã¾
bull2 2008/02/21
db

dbms

HA

DR
ãƒªãƒ³ã‚¯
Developers Summit(ãƒ‡ãƒ–ã‚µãƒŸ) 2008 - æš«åœä½¿ç”¨
ã“ã®æ³ã«ãªã£ã¦åˆã‚ã¦å‚åŠ â€¦ã¨ã¯è¨€ã£ã¦ã‚‚è«¸èˆ¬ã®äº‹æƒ…ã§ç”³ã—è¾¼ã¿ã¯æœ¬æ—¥ã®ã¿ã€‚ã—ã‹ã‚‚åˆå‰ä¸ã«å‡ºå‹¤ã—ãŸã›ã„ã§ç”Ÿ Joel ã‚’è¦‹é€ƒã—ãŸã®ãŒæ‚”ã—ã„ã€‚ä½•ã§ã‚‚ç«‹ã¡è¦‹ãŒå‡ºã‚‹ç¨‹ã®å¤§ç››æ³ã ã£ãŸã¨ã‹ã€‚ ãƒžã‚¤ãƒ³ãƒ‰ãƒžãƒƒãƒ—ã‚’åˆå¾Œã„ã£ã±ã„ä¸€æ‰€æ‡¸å‘½å–ã£ã¦ã„ãŸã›ã„ã§ã€ä¹…ã—ã¶ã‚Šã«ãƒšãƒ³ãƒ€ã‚³ãŒå‡ºæ¥ã‚‹ä½ç½®ãŒç—›ããªã£ãŸã€‚ä»¥ä¸‹ã€ãƒžã‚¤ãƒ³ãƒ‰ãƒžãƒƒãƒ—ã«æ›¸ã„ãŸãƒ¢ãƒŽã‚’å…ƒã«è¨˜æ†¶ã‚’å†æ§‹æˆã—ã¦ã¿ã‚ˆã†ã¨å››è‹¦å…«è‹¦ã—ãŸçµæžœã‚’æŒ™ã’ã¦ãŠãã€‚ ã€13-B-3ã€‘ãµã¤ã†ã® Ruby ãƒ—ãƒã‚°ãƒ©ãƒžã«è´ˆã‚‹ Ruby ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¬›åº§ Ruby ãƒ—ãƒã‚°ãƒ©ãƒžã˜ã‚ƒãªã„ã‘ã©è´ã„ã¦ããŸã€‚ã§ã€Ruby ãƒ—ãƒã‚°ãƒ©ãƒžã˜ã‚ƒãªãã¦ã‚‚æ¥½ã—ã‹ã£ãŸã—å‚è€ƒã«ãªã£ãŸã€‚ å…¨ä½“ã‚’é€šã˜ã¦ã®æœ€å¤§ã®ãƒ’ãƒƒãƒˆã¯ã€Œæ„å›³ã‚’æ˜Žç¢ºã«ã™ã¹ãé©åˆ‡ãªåˆ¶å¾¡æ§‹é€ ã‚’ä½¿ãˆã€ã¨ã“ã‚ã€‚ã“ã‚Œé‡è¦ã ã¨æ€ã†ã€‚ã‚¢ãƒ›ãªé€£ä¸ã«ã€Œã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã€ã¨ã‹ã‚’ä½œã‚‰ã›ã‚‹ã¨ã€çœŸã£å…ˆã«å‡ºã¦ãã‚‹ã®ãŒã€Œè§£ã‚Šã«ãããªã‚‹ã‹ã‚‰ if / while ã«é™å®šæ±ã€ã£ã¦ãƒ¢ãƒŽã€‚ã§ã‚‚å®Ÿéš›ã«
bull2 2008/02/18
çœŸã®DBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ãªã‚‹ãŸã‚ã«å¿…è¦ãªã“ã¨

devsumi

SQL

DB

DBMS
ãƒªãƒ³ã‚¯
æ€§èƒ½å¤§å¹…ã‚¢ãƒƒãƒ—ã®ã€ŒPostgreSQL 8.3ã€ãŒãƒªãƒªãƒ¼ã‚¹ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
PostgreSQLã‚°ãƒãƒ¼ãƒãƒ«é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—ã¯4æ—¥ (ç±³å›½æ™‚é–“)ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã®æœ€æ–°ç‰ˆã€ŒPostgreSQL 8.3ã€ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚åŒãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®Webã‚µã‚¤ãƒˆã§ã¯ã€å„ç¨®OSã«å¯¾å¿œã™ã‚‹ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®ã»ã‹ã€Windowsã€Red Hat Linuxã€Solarisç”¨ã®ãƒã‚¤ãƒŠãƒªãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ ä»Šå›žã®ãƒªãƒªãƒ¼ã‚¹ã§ã¯ã€Heap Only Tuples (HOT) ã‚’æ–°ãŸã«ã‚µãƒãƒ¼ãƒˆã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è‚¥å¤§åŒ–ãŒæŠ‘åˆ¶ã•ã‚Œã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹æ›´æ–°å‡¦ç†æ€§èƒ½ãŒå¤§å¹…ã«å‘ä¸Šã€ç®¡ç†ä¸Šã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã®3/4ãŒå–ã‚Šé™¤ã‹ã‚Œã‚‹ã¨ã„ã†ã€‚åŒæœŸã‚¹ã‚ãƒ£ãƒ³ã«ã‚‚å¯¾å¿œã€è¤‡æ•°ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ãŒåŒæ™‚ã«å·¨å¤§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é †ã‚¹ã‚ãƒ£ãƒ³ã™ã‚‹ã¨ãã®æ€§èƒ½å‘ä¸Šã«è²¢çŒ®ã™ã‚‹ã€‚ ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã‚’é˜²ãç›®çš„ã§ã€ã€Œè² è·åˆ†æ•£ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã€ã‚‚è¿½åŠ ã€‚å®šæœŸçš„ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒãƒ•ã‚¡ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
bull2 2008/02/05
database

db

dbms

postgresql
ãƒªãƒ³ã‚¯
DBMã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ - mixi engineer blog
DSã®ã‚¹ã‚¿ãƒ¼ãƒ•ã‚©ãƒƒã‚¯ã‚¹ã¨ã„ã†ã‚²ãƒ¼ãƒ ã«ã¯ã¾ã‚Šã¾ãã‚Šã®mikioã§ã™ã€‚æœ€è¿‘ç¤¾å†…å¤–ã§ã€Œä¿ºã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒã€ã‚’ä½œã‚‹ã®ãŒæµè¡Œã£ã¦ã„ã‚‹ã‚ˆã†ãªã®ã§ç§ã‚‚å‚æˆ¦ã—ã¦ã¿ã¾ã—ãŸã€‚ä»Šå›žã¯DBMã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯å±¤ã‚’ã»ã¼ã‚¹ã‚¯ãƒ©ãƒƒãƒã§ä½œã£ãŸè©±ã‚’ã—ã¾ã™ã€‚ Tokyo Tyrant Tokyo Tyrantï¼ˆä»¥ä¸‹TTï¼‰ã¯Tokyo Cabinetï¼ˆä»¥ä¸‹TCï¼‰ã‚’ãƒ©ãƒƒãƒ—ã—ã¦ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯è¶Šã—ã«æ“ä½œã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã‚ãƒ£ãƒ“ãƒãƒƒãƒˆï¼ˆå†…é–£ï¼‰ã‚’å‚€å„¡ã«ã™ã‚‹ã‚¿ã‚¤ãƒ©ãƒ³ãƒˆï¼ˆåƒä¸»ï¼‰ã¨ã„ã†ã“ã¨ã§åä»˜ã‘ã¾ã—ãŸã€‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã€‚ TCã¯é«˜æ€§èƒ½ãªDBMã§ã€ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ãƒ¢ãƒ‡ãƒ«ã§é«˜ã„ä¸¦åˆ—æ€§ã‚’å®Ÿç¾ã—ã¦ã„ã¾ã™ãŒã€é€†ã«ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹ãƒ¢ãƒ‡ãƒ«ã ã¨ãƒ•ã‚¡ã‚¤ãƒ«ãƒãƒƒã‚¯ãŒã‹ã‹ã‚‹ã®ã§ä¸¦åˆ—æ€§ãŒä½Žããªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ã¤ã¾ã‚Šã€æ›¸ãè¾¼ã¿ãƒ¢ãƒ¼ãƒ‰ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ãƒ—ãƒã‚»ã‚¹ãŒã„ã‚‹ã¨ã€ãã®é–“ã¯ä»–ã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã‚ˆã†ã¨ã™ã‚‹ã¨ãƒ–ãƒãƒƒã‚¯ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚
bull2 2008/01/27
db

dbms

memcached
ãƒªãƒ³ã‚¯
1