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

mattarin id:mattarin

databaseã«é–¢ã™ã‚‹mattarinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã™ãŒã€B-treeã§ã¯ãªãB+treeã‚’ä½¿ç”¨ã™ã‚‹ã®ã¯ã©ã†ã—ã¦ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ | mond
MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã™ãŒã€B-treeã§ã¯ãªãB+treeã‚’ä½¿ç”¨ã™ã‚‹ã®ã¯ã©ã†ã—ã¦ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ç«¯çš„ã«è¨€ã†ã¨æ€§èƒ½ãŒè‰¯ã„ã‹ã‚‰ã§ã™ã€‚ ã“ã‚Œã‚’ç†è§£ã™ã‚‹ã«ã¯ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¸ã®ç†è§£ãŒå¿…è¦ã§ã™ã€‚ãƒ‡ã‚£ã‚¹ã‚¯æŒ‡å‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸Šã§ã¯æœ‰é™ã®ãƒ¡ãƒ¢ãƒªã‚’æœ€å¤§é™æ´»ç”¨ã™ã‚‹ã“ã¨ã§ãƒ¡ãƒ¢ãƒªã«å…¥ã‚Šåˆ‡ã‚‰ãªã„å·¨å¤§ãªãƒ‡ãƒ¼ã‚¿ç¾¤ã«å¯¾ã—ã¦è‰¯å¥½ãªå‚ç…§æ€§èƒ½ã‚’å‡ºã™å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¨ã¯ãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã®ç¾…åˆ—ã‚’å›ºå®šã‚µã‚¤ã‚ºã®ãƒšãƒ¼ã‚¸ï¼ˆInnoDBã®å ´åˆ16KBï¼‰ã®ç¾…åˆ—ã§ã‚ã‚‹ã¨ã—ã¦èªã¿æ›¸ãã«å¿…è¦ãªåˆ†ã ã‘ã‚’ãƒ¡ãƒ¢ãƒªã«ç§»ã—å–ã‚Šè¤‡æ•°ã®æ›¸ãè¾¼ã¿ã‚’ã§ãã‚‹é™ã‚Šãƒ¡ãƒ¢ãƒªå†…ã§å—ã‘æ¢ã‚ã¦å¾Œã§ã¾ã¨ã‚ã¦ãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãæˆ»ã™ã¨ã„ã†ã€ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯åž‹ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ã‚ˆã†ãªæ©Ÿæ§‹ã§ã™ã€‚ ã“ã®ä¸ã«ãŠã„ã¦ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯æœ‰é™ã®ã‚µã‚¤ã‚ºã—ã‹ç„¡ã„ã®ã§é©å®œãƒ—ãƒ¼ãƒ«å†…ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãæˆ»ã—ã¦å…¥ã‚Œæ›¿ãˆãªãŒã‚‰ä¸Šæ‰‹ãã‚„ã£ã¦ã„ãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã•ã¦B+treeã¨B-treeã®æœ€å¤§ã®é•ã„ã¯æœ¨ã®ãƒª
mattarin 2023/10/02
database

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹çš„ãªè¦³ç‚¹ã§ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ç‰¹å¾´ ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« ãƒ»ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã«å¾“æ¥åž‹RDBMSã‚’ä½¿ã†ã¹ãã‹ã€ï¿½æµè¡Œã‚Šã®NoSQLã§è¡Œãã¹ãã‹ ãƒ»è² è·å¯¾ç– (ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£é¢) ãƒ»è² è·å¯¾ç– (ãƒ„ãƒ¼ãƒ«é¢) ãƒ»ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ãƒ£ãƒªã‚¢ã«ã¤ã„ã¦
mattarin 2011/01/24
database
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªäº‹æ¥è€…å‘ã‘ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ - ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ | ãƒãƒƒãƒˆ | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ã¯1æ—¥ã€ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã‚µãƒ¼ãƒ“ã‚¹ã€ŒDATAHOTELã€ã«ãŠã„ã¦ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æä¾›äº‹æ¥è€…å‘ã‘ã®ãƒ—ãƒ©ãƒ³ã€ŽDATAHOTEL for Socialã€ã‚’é–‹å§‹ã™ã‚‹ã¨ç™ºè¡¨ã—ãŸã€‚ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªå¸‚å ´ã®æ‹¡å¤§ã«ã¨ã‚‚ãªã„ã€ã‚¢ã‚¯ã‚»ã‚¹æ€¥å¢—ãªã©ã«å¯¾å¿œå¯èƒ½ãªã‚¤ãƒ³ãƒ•ãƒ©ã‚’æä¾›ã™ã‚‹ã€‚ DATAHOTEL for Socialã¯ã€SNSãªã©ã§åˆ©ç”¨ã•ã‚Œã‚‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æä¾›äº‹æ¥è€…ã«ç‰¹åŒ–ã—ãŸãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°&ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€‚æœ€çŸ1æ—¥ã§ã®ã‚µãƒ¼ãƒè¿½åŠ ãªã©ã€æ€¥ãªã‚¢ã‚¯ã‚»ã‚¹å¢—ã«ã‚‚å¯¾å¿œã§ãã‚‹ã‚¤ãƒ³ãƒ•ãƒ©ä½“åˆ¶ã‚’æä¾›ã™ã‚‹ã“ã¨ã§ã€äº‹æ¥è€…ã¯ã‚¢ãƒ—ãƒªã®é–‹ç™ºã‚„ãƒ—ãƒãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ã«å°‚å¿µã§ãã‚‹ã¨ã—ã¦ã„ã‚‹ã€‚å°‚é–€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹24æ™‚é–“365æ—¥ã®ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚‚æä¾›ã•ã‚Œã‚‹ã€‚
mattarin 2010/03/04
database
ãƒªãƒ³ã‚¯
Twitterã€ã€Œæ‹¡å¼µæ€§ã¨å¯ç”¨æ€§ã€ã‚’æ±‚ã‚ã¦MySQLã‹ã‚‰Cassandraã¸ä¹—ã‚Šæ›ãˆã‚‹
Twitterã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒMySQLã‹ã‚‰ã€FacebookãŒé–‹ç™ºã—ãŸã€ŒCassandraã€ã«ç§»è¡Œã—ã¦ã„ã‚‹ã¨ã„ã†ã€‚ç¾åœ¨ã€ã€Œãƒ„ã‚¤ãƒ¼ãƒˆã€ã‚„ã€Œãƒªãƒ„ã‚¤ãƒ¼ãƒˆã€ã‚’å«ã‚€æœ€å¤§è¦æ¨¡ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’Cassandraã«ç§»è¡Œä¸ã§ã€ãã®å¾Œã»ã‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚‚ç§»è¡Œã•ã›ã‚‹ã¨ã„ã†ã€‚ äººæ°—ã®ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€ŒTwitterã€ã‚’æä¾›ã™ã‚‹ç±³TwitterãŒã€ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’FacebookãŒé–‹ç™ºã—ãŸã€ŒCassandraã€ã«ç§»è¡Œã—ã¦ã„ã‚‹ã¨ã„ã†ã€‚ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—åŠ ã«è‡ªå‹•çš„ã«å¯¾å¿œã§ãã‚‹æ‹¡å¼µæ€§ã‚„å¯ç”¨æ€§ãªã©ã‚’è©•ä¾¡ã—ãŸçµæžœã®ã‚ˆã†ã ã€‚ Twitterã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºè€…ã€ãƒ©ã‚¤ã‚¢ãƒ³ãƒ»ã‚ãƒ³ã‚°ã‚¹æ°ãŒMyNoSQLã®å–æã«å¿œã˜ã¦æ˜Žã‚‰ã‹ã«ã—ãŸã€‚MyNoSQLã¯SQLã§ã¯ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç·ç§°ã€ŒNoSQLã€ã«é–¢ã™ã‚‹æƒ…å ±ã‚’é›†ã‚ãŸãƒ–ãƒã‚°ã€‚ ã‚ãƒ³ã‚°ã‚¹æ°ã«ã‚ˆã‚‹ã¨ã€Twitterã¯ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰MySQLã¨Memchacheã‚’çµ„ã¿åˆã‚ã›ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ©ç”¨
mattarin 2010/03/02
twitter

database
ãƒªãƒ³ã‚¯
æ–°ã—ããªã£ãŸAutoPagerizeã®SITEINFOãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰wedata - bits and bytes
AutoPagerizeã®SITEINFOãŒwedataã¨ã„ã†ã€ã‚ãƒ¼ã¨å€¤ã‚’ç®¡ç†ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã¨ã—ãŸwikiã®ã‚ˆã†ãªã‚‚ã®ã§ç®¡ç†ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®wedataã¯ã‚ãƒ¼ã¨å€¤ã‚’ç®¡ç†ã™ã‚‹ã ã‘ã®å˜ç´”ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸ç‰¹å®šå¤šæ•°ã§ç·¨é›†ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ä»•çµ„ã¿ã§ã™ã€‚æ–°ã—ãè‡ªåˆ†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚Œã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã®ã§AutoPagerizeã®SITEINFOã ã‘ã§ãªãã€è‡ªåˆ†ã§ä½œã£ãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ãŸã‚ã®SITEINFOã‚’ã‹ã‚“ãŸã‚“ã«ä½œã£ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ç§ãŒä½œã£ãŸã‚ã‘ã§ã¯ãªã„ã®ã§ã™ãŒã€åŽ»å¹´ã®ã¯ã˜ã‚ã‹ã‚‰ã“ã‚“ãªä»•çµ„ã¿ãŒã»ã—ã„ãªã¨æ€ã£ã¦ã„ãŸã‚ˆã†ãªã‚‚ã®ã«ãªã£ã¦ã„ã¦ã¨ã¦ã‚‚ã†ã‚Œã—ã„ã®ã§ã€ã¡ã‚‡ã£ã¨é•·ã„ã§ã™ãŒwedataã®ç´¹ä»‹ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ AutoPagerizeã¨ãã®ã—ãã¿ ã„ã‚ã‚“ãªã‚µã‚¤ãƒˆã§æ¬¡ã®ãƒšãƒ¼ã‚¸ã‚’è‡ªå‹•çš„ã«è¡¨ç¤ºã™ã‚‹ãŸã‚ã®Greasemonkeyã‚¹ã‚¯ãƒªãƒ—ãƒˆã®AutoPagerizeã¯ã€wiki
mattarin 2008/04/26
wedata

database
ãƒªãƒ³ã‚¯
ã‚¢ãƒžã‚¾ãƒ³ã€ã‚¦ã‚§ãƒ–ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒSimpleDBã€ã®å…¬é–‹ãƒ†ã‚¹ãƒˆã‚’é–‹å§‹
Amazon.comã¯åŒç¤¾ãŒæä¾›ã™ã‚‹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã«ã¨ã£ã¦3ç•ªç›®ã¨ãªã‚‹è¦ç´ ã®å…¬é–‹ãƒ†ã‚¹ãƒˆã‚’é–‹å§‹ã—ãŸã€‚ã“ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã¯ã€ã€ŒSimpleDBã€ã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ©Ÿèƒ½ã§ã‚ã‚‹ã€‚ Amazonã¯2006å¹´ã«ä»–ã®2ã¤ã®Webã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ã¦ã„ã‚‹ã€‚2ã¤ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã¯ã€ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã®ã€ŒElastic Computing Cloudï¼ˆEC2ï¼‰ã€ã¨ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®ã€ŒSimple Storage Serviceï¼ˆS3ï¼‰ã€ã§ã‚ã‚Šã€èª°ã§ã‚‚æ–™é‡‘ã‚’æ‰•ãˆã°ä½¿ç”¨ã§ãã‚‹ã€‚Amazonã®ç±³å›½æ™‚é–“12æœˆ14æ—¥ã®ç™ºè¡¨ã«ã‚ˆã‚‹ã¨ã€SimpleDBã¯ã“ã‚Œã‚‰ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨é€£ä¿‚ã—ã¦å‹•ä½œã—ã€é¡§å®¢ã¯ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã€ä¿®æ£ã—ãŸã‚Šã€ã‚¯ã‚¨ãƒªãƒ¼ã‚’è¡Œã£ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ã€‚ ã€ŒAmazon SimpleDBã¯ãƒ‡ãƒ¼ã‚¿ã®è¿…é€Ÿã§åŠ¹çŽ‡çš„ãªä¿å˜ã¨æ¤œç´¢ã‚’å¯èƒ½ã«ã—ã¦ã€é«˜æ€§èƒ½ãªã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã€
mattarin 2007/12/17
amazon

database
ãƒªãƒ³ã‚¯
ç¤¾ä¼šå®Ÿæƒ…ãƒ‡ãƒ¼ã‚¿å›³éŒ² Honkawa Data Tribune
ãƒã‚¸ãƒ†ã‚£ãƒ–ãªæƒ…å ±ã‚ˆã‚Šã‚‚ãƒã‚¬ãƒ†ã‚£ãƒ–ãªæƒ…å ±ã«æ³¨æ„ãŒå‘ã‹ã„ã‚„ã™ã„ãƒã‚¬ãƒ†ã‚£ãƒ“ãƒ†ã‚£ãƒ»ãƒã‚¤ã‚¢ã‚¹ã«ã‚ˆã£ã¦ã€äººã€…ã¯ã€å¯Œã®æ ¼å·®ã€ç§»æ°‘æ¯”çŽ‡ã€ã‚¤ã‚¹ãƒ©ãƒ æ¯”çŽ‡ãªã©ã‚’å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã‚ˆã‚ŠéŽå¤§ãªã‚‚ã®ã¨èªè˜ã—ã¦ã„ã‚‹ã€‚ã“ã‚ŒãŒãƒ•ã‚¡ã‚¯ãƒˆã‚ˆã‚Šãƒ•ã‚§ã‚¤ã‚¯ãŒç›®ç«‹ã¤æ˜¨ä»Šã®çŠ¶æ³ã®1ã¤ã®è¦å› ã¨ãªã£ã¦ã„ã‚‹ã€‚
mattarin 2007/10/02
database

æƒ…å ±
ãƒªãƒ³ã‚¯
ã€Žç”»åƒã‚‚DBã«æ ¼ç´ã—ã¦ç®¡ç†ã™ã‚‹ ï¼æ‰±ã„ãŒã‚ã‚“ã©ã†ãªLOB(ãƒ©ãƒ¼ã‚¸ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ)ã¯ä½¿ã‚ãªã„æ–¹æ³•ã‚‚å«ã‚ã€ã¸ã®ã‚³ãƒ¡ãƒ³ãƒˆ
ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã—ã¾ã—ãŸ ã“ã“ã«ãƒ„ã‚¤ãƒ¼ãƒˆå†…å®¹ãŒè¨˜è¼‰ã•ã‚Œã¾ã™ https://b.hatena.ne.jp/URLã¯spanã§å›²ã‚“ã§ãã ã•ã„ Twitterã§å…±æœ‰
mattarin 2007/08/13
æœ¬æ–‡é•·ã„ã‹ã‚‰ã“ã£ã¡ã‚’ãƒ–ã‚¯ãƒž

database

mogilefs
ãƒªãƒ³ã‚¯
1