[B! oltp] moozã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mooz id:mooz

oltpã«é–¢ã™ã‚‹moozã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

Hekaton (database) - Wikipedia
mooz 2014/06/18
txn ã‚’ compile

database

oltp

memory

research
ãƒªãƒ³ã‚¯
ãªãœã“ã‚Œã¾ã§ã®æ±Žç”¨RDBMSã§ã¯ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã«å¯¾å¿œã§ããªã„ã®ã‹
OLTPå‡¦ç†ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ãŸæ±Žç”¨RDBMS Greenplum DBã¯ãƒ“ã‚¸ãƒã‚¹ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹ï¼ˆBIï¼‰ã‚„åˆ†æžå‡¦ç†ã«é©ã—ãŸã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°Massively Parallel Processing (MPP)ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚ä¸€æ–¹ã§ã€ã“ã‚“ã«ã¡ã®æ±Žç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBï¼‰ã®å¤§åŠã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ï¼ˆOLTPï¼‰ã«æœ€é©åŒ–ã•ã‚Œã¦ã„ã¾ã™ã€‚æ±Žç”¨RDBã¯ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã‚„BIã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¸ã®å¯¾å¿œã‚’è¬³ã£ã¦ã„ã‚‹ãŸã‚ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯å½“ãŸã‚Šå‰ã®ã“ã¨ã¨ã—ã¦ã“ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã€BIã‚„åˆ†æžã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã¯OLTPã®ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã¨ã¯æ ¹æœ¬çš„ã«ç•°ãªã‚‹ãŸã‚ã€æœ¬æ¥ãã®å‡¦ç†ã«é©ã—ãŸã‚¢ãƒ¼ã‚¯ãƒ†ã‚¯ãƒãƒ£ãŒç”¨ã„ã‚‰ã‚Œã‚‹ã¹ããªã®ã§ã™ã€‚ OLTPãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã§ã¯ã€é€Ÿã„ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã¨å°ã•ãªå˜ä½ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®æ›´æ–°æ€§èƒ½ãŒæ±‚ã‚ã‚‰ã‚Œã¾ã™ã€‚ã“ã®ã‚ˆã†ãªå‡¦ç†ã¯
mooz 2011/11/29
database

oltp

parallel
ãƒªãƒ³ã‚¯
On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems
mooz 2011/11/03
H-Store ã«ãŠã„ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚„ Undo ã®æœ‰ç„¡ãŒäº‹å‰ã«ä¸Žãˆã‚‰ã‚Œã¦ã„ãªã„å ´åˆã«ï¼Œãƒžãƒ«ã‚³ãƒ•ãƒ¢ãƒ‡ãƒ«ã‚’ä½¿ã£ã¦ãã‚Œã‚‰ã®æƒ…å ±ã‚’æŽ¨å®šï¼Žæœ€é©åŒ–ã«å½¹ç«‹ã¦ã‚‹ï¼Ž

paper

research

voltdb

database

oltp
ãƒªãƒ³ã‚¯
tpcc-mysqlã«ã‚ˆã‚‹MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹è² è·ãƒ„ãƒ¼ãƒ«ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã¯ä¸–ã®ä¸ã«ãŸãã•ã‚“ã‚ã‚‹ã®ã§ã™ãŒã€å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ä¸»ã‚ãƒ¼æ¤œç´¢ã—ã‹ã—ãªã„ã‚‚ã®ãªã©ã€CPUã‚¯ãƒãƒƒã‚¯å‹è² ã®æ¯”è¼ƒçš„å˜ç´”ãªã‚‚ã®ãŒå¤šãã‚’å ã‚ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ãã“ã§æœ¬æ—¥ã¯ã€ã‚‚ã†å°‘ã—é«˜åº¦ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä»•æ§˜ã¨ã—ã¦ã®TPC-Cã¨ã€MySQLå‘ã‘ã®ç°¡æ˜“å®Ÿè£…ã§ã‚ã‚‹tpcc-mysqlã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ TPC-Cã¨ã¯å¸å£²æ¥ã«ãŠã‘ã‚‹æ³¨æ–‡ãƒ»æ”¯æ‰•ã„ãªã©ã®å‡¦ç†ã‚’æ“¬ä¼¼çš„ã«å†ç¾ã—ãŸæ¥å‹™ãƒ¢ãƒ‡ãƒ«ã§ã€TPCã¨ã„ã†æ¥ç•Œå›£ä½“ã«ã‚ˆã£ã¦ç–å®šã•ã‚ŒãŸã‚‚ã®ã§ã™ã€‚9ç¨®é¡žã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹5ç¨®é¡žã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒãƒŸãƒƒã‚¯ã‚¹ã•ã‚Œã¦ãŠã‚Šã€ãã®ã†ã¡æ³¨æ–‡å‡¦ç†ã®ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’æ¸¬å®šçµæžœã¨ã—ã¦åˆ©ç”¨ã—ã¾ã™ã€‚å…¬å¼ã‚µã‚¤ãƒˆã§ä»•æ§˜æ›¸(PDF)ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ã¡ãªã¿ã«ã“ã®ERå›³ã¯MySQL Workbenchã§å‡ºåŠ›ã—ãŸã‚‚ã®ã§ã™ã€‚ warehouseï¼šå€‰åº«ã§ã™ã€‚å€‰åº«è¡¨ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã¯
mooz 2011/07/05
TPC-C å®Ÿè£…ã§ã‚ã‚‹ tpcc-mysql ã®ä½¿ã„æ–¹ï¼Ž

database

benchmark

oltp
ãƒªãƒ³ã‚¯
VoltDB Documentation | VoltDB
Tutorial A more complete tutorial, including source code and sample data, for learning what makes VoltDB unique. HTML or PDF (ä¸æ–‡ç‰ˆ) Planning Guide For architects and administrators. Information on sizing hardware, memory, and software to meet specific application needs. HTML or PDF
mooz 2010/12/03
VoltDB ã®ã‚¯ã‚¨ãƒªå®Ÿè¡Œãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦

database
ãƒªãƒ³ã‚¯
1