[B! ssd] shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shinichitomita id:shinichitomita

ssdã«é–¢ã™ã‚‹shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

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

SSDæŠ•å…¥ã§DBMSã®ã‚³ã‚³ãŒå¤‰ã‚ã‚‹! - WEB+DB PRESS vol. 52
SSDã‚’ä½¿ã†ã¨DBMSã¯ã©ã†å¤‰ã‚ã‚‹ï¼Ÿå¾¹åº•æ¤œè¨¼ã—ãŸè¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸï¼ WEB+DB PRESS Vol.52 äºˆç´„å—ä»˜ä¸ã§ã™ã€‚ å®Ÿéš›ã«æœ€æ–°æœ€é€Ÿã®SSDã€Intel X25-Eã‚’ä½¿ã£ã¦DBMSã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã™ã‚‹ãªã©ã€ã‚ãã‚ãã—ãªãŒã‚‰è¨˜äº‹ã‚’æ›¸ãã“ã¨ãŒã§ãã¾ã—ãŸã€‚SSDã®å®ŸåŠ›ã«é©šãã¤ã¤ã‚‚ã€ä½¿ã„æ–¹ã‚’é–“é•ãˆã‚‹ã¨HDDã‚ˆã‚Šé…ããªã‚‹ï¼Ÿ ãªã©æ–°ã—ã„ç™ºè¦‹ã‚‚ã‚ã‚Šã€‚ ãã—ã¦ã€SSDã¨HDDã®é•ã„ãŒã©ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã«å½±éŸ¿ã™ã‚‹ã®ã‹ï¼Ÿãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ï¼ˆãƒ’ãƒ¼ãƒ—ã€B+-treeãªã©ï¼‰ã‹ã‚‰ãƒãƒƒãƒ•ã‚¡ç®¡ç†ãªã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ä¸èº«ã‚’è§£å‰–ã—ã¦ã‚ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¦ã„ã¾ã™ã€‚èªã¿ã‚„ã™ããªã£ãŸã®ã¯ä¸å¯§ã«æ·»å‰Šã—ã¦ãã ã•ã£ãŸæ‹…å½“æ§˜ã®ãŠã‹ã’ã§ã™ã€‚æ„Ÿè¬ã€‚ ãƒ‡ã‚£ã‚¹ã‚¯ã‚’æ´»ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ã‚½ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ï¼ˆExternal merge sortãªã©ï¼‰ã«åŠ ãˆã€2009å¹´6æœˆã«Edgar F. Codd Innovation Aw
shinichitomita 2009/08/26
hash join mapreduce

rdbms

ssd

database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› SSDä¸Šã®Oracleã®æ€§èƒ½ãƒ¬ãƒãƒ¼ãƒˆ
å„ç¨®ã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“(OSã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯)ã‚„ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã¨ã„ã£ãŸè©±é¡Œã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚è‘—è€…ã¯å°ç”°åœäºŒã€ã€Œé–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹Oracleã®ä»•çµ„ã¿ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹OS/ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸/ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ãªã©ã®è‘—ä½œã‚‚ã‚ã‚Šã¾ã™ Oracleã‚’SSDã®ä¸Šã§å‹•ã‹ã—ãŸã‚‰ã€ã©ã‚“ãªæ€§èƒ½ç‰¹æ€§ã«ãªã‚‹ã®ã‹ï¼Ÿ ã©ã‚“ãªæ³¨æ„ç‚¹ãŒã‚ã‚‹ã®ã‹ï¼Ÿã€€èˆˆå‘³ã¯å°½ãã¾ã›ã‚“ãŒã€ã€ŒOracle OpenWorldã§è¦‹ã¦ããŸæ¥å‹™ç”¨SSDè£½å“ã¾ã¨ã‚ã€ã§ã‚‚ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã€ ã€Œå ±å‘Šæ›¸ãŒãƒ‰ãƒ©ãƒ•ãƒˆç‰ˆã¨ã„ã†ã“ã¨ã§è©³ã—ã„å†…å®¹ã¯æ£å¼ç‰ˆã‚’å¾…ã¡ãŸã„ãƒ»ãƒ»ãƒ»ã€ã® å ±å‘Šæ›¸ãŒå‡ºã¦ããŸã‚ˆã†ã§ã™ã€‚ ã“ã®åº¦ã€ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦DELLã¨EMCã¨Oracleã®æ¤œè¨¼çµæžœãƒ¬ãƒãƒ¼ãƒˆãŒã§ãŸã®ã‚’è¦‹ã¤ã‘ã¾ã—ãŸã€‚http://wp.techtarget.itmedia.co.jp/ (TechTargetã‚¸ãƒ£ãƒ‘ãƒ³ã¨ã„ã†ç™»éŒ²ãŒå¿…è¦ãªã‚µã‚¤ãƒˆã§ã™) ãƒ¬ãƒãƒ¼ãƒˆ
shinichitomita 2009/05/30
> ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®writeã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚‚ä½¿ã£ã¦ã€ãƒ—ãƒãŒæ€ã„ã£ãã‚Šãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ã€ã»ã¼åŒæ€§èƒ½ã®æ€§èƒ½ã¯å‡ºã›ã‚‹ã¯ãšã§ã™(ç‰©ç†ãƒ‡ã‚£ã‚¹ã‚¯æœ¬æ•°ã‚’æƒãˆã‚‹ã¨)ã€‚ã§ã¯ã€ç¾æ™‚ç‚¹ã®SSDã«æ„å‘³ãŒãªã„ã‹ã¨ã„ã†ã¨ã€ã€Œãã“ãã“ã®ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘

oracle

ssd

database

disk
ãƒªãƒ³ã‚¯
SSD ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å°†æ¥ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
SQL ã«ç—›ç—’æ„Ÿã‚’æ„Ÿã˜ã‚‹æ—¥ã€…ã‚’éŽã”ã—ã¦ã„ã‚‹èº«ã¨ã—ã¦ã¯ã€RDBMS ãŒãƒ¬ã‚¬ã‚·ãƒ¼ã ã¨ã„ã†ã®ã¯ã€ã¾ã£ãŸãåŒæ„Ÿã§ã™ãŒã€‚ SSDã‚’å‰æã«ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¢ãƒ‡ãƒ«ã«ãªã‚Œã°ã€ãã‚‚ãã‚‚ã‚·ãƒ¼ã‚¯æ™‚é–“ã¨æˆ¦ã†ã“ã¨ã‚‚ãªãã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ„è˜ã›ãšã«ãƒ—ãƒã‚°ãƒ©ãƒ ãŒçµ„ã‚ã¾ã™ã€‚ãã†ãªã£ãŸã¨ãã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ°¸ç¶šåŒ–ã™ã‚‹ãŸã‚ã«RDBMSã‚’ã‚ã–ã‚ã–ä½¿ã†ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ 2008-12-12 ãã‚“ãªã“ã¨ãªã„ã¨æ€ã„ã¾ã™ã€‚ç†ç”±ã¯ä»¥ä¸‹ã®ï¼’ç‚¹ã€‚ ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã®æ›¸ãæ›ãˆãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã¯æ•°ã‚ãƒãƒã‚¤ãƒˆä»¥ä¸Š ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯æ„è˜ã—ã¦å®Ÿè£…ã›ã–ã‚‹ã‚’å¾—ãªã„ ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ¡ãƒ¢ãƒªã¯ãƒ©ãƒ³ãƒ€ãƒ ãƒªãƒ¼ãƒ‰ã§ãã¾ã™ãŒã€DRAM ã®ã‚ˆã†ã«ãƒ©ãƒ³ãƒ€ãƒ ãƒ©ã‚¤ãƒˆã§ãã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚æ›¸ãè¾¼ã¿ãŒéžå¸¸ã«é…ã„ã®ã«åŠ ãˆã¦æ›¸ãæ›ãˆå›žæ•°ã®åˆ¶é™ã‚‚ã‚ã‚‹ã®ã§ã€ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã¨åŒæ§˜ã®ãƒ—ãƒã‚°ãƒ©ãƒ æ‰‹æ³•ã‚’ä½¿ã†ã®ã¯é›£ã—ã„ã¨æ€ã„ã¾ã™ã€‚ æ¬¡ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã§ã™ãŒã€çµ„ã¿è¾¼ã¿åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦
shinichitomita 2008/12/12
DBMSã®ç†ç”± -> transaction, random writeã¯DRAMã¨æ¯”è¼ƒç„¡ç† / ã‚µãƒ¼ãƒã‚ˆã‚Šã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ç”Ÿãæ®‹ã‚‹ <- ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£

opinion

rdbms

database

ssd
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (5)

ssdã«é–¢ã™ã‚‹shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (5)

ssdã«é–¢ã™ã‚‹shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

SSDæŠ•å…¥ã§DBMSã®ã‚³ã‚³ãŒå¤‰ã‚ã‚‹! - WEB+DB PRESS vol. 52

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› SSDä¸Šã®Oracleã®æ€§èƒ½ãƒ¬ãƒãƒ¼ãƒˆ

SSD ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å°†æ¥ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (5)

ssdã«é–¢ã™ã‚‹shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

SSDæŠ•å…¥ã§DBMSã®ã‚³ã‚³ãŒå¤‰ã‚ã‚‹! - WEB+DB PRESS vol. 52

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› SSDä¸Šã®Oracleã®æ€§èƒ½ãƒ¬ãƒãƒ¼ãƒˆ

SSD ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å°†æ¥ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹