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

fujya id:fujya

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

C34 ãƒ‹ãƒƒãƒã ã‘ã©ã€ç¤¾ä¼šã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€HiRDB ï½žHiRDBã‚’é¸ã¶äººã€é¸ã°ãªã„äººã€ãã®é¸æŠžåŸºæº–ã¨ã¯ï½ž by Taichi Ishikawa
C34 ãƒ‹ãƒƒãƒã ã‘ã©ã€ç¤¾ä¼šã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€HiRDB ï½žHiRDBã‚’é¸ã¶äººã€é¸ã°ãªã„äººã€ãã®é¸æŠžåŸºæº–ã¨ã¯ï½ž by Taichi Ishikawa 1. Â© Hitachi, Ltd. 2013. All rights reserved. æ ªå¼ä¼šç¤¾ æ—¥ç«‹è£½ä½œæ‰€ æƒ…å ±ãƒ»é€šä¿¡ã‚·ã‚¹ãƒ†ãƒ ç¤¾ ITãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ äº‹æ¥æœ¬éƒ¨ é–‹ç™ºçµ±æ‹¬æœ¬éƒ¨ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºæœ¬éƒ¨ DBè¨è¨ˆéƒ¨ ä¸»ä»»æŠ€å¸« çŸ³å· å¤ªä¸€ ãƒ‹ãƒƒãƒã ã‘ã©ã€ ç¤¾ä¼šã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ï¼¨ï½‰ï¼²ï¼¤ï¼¢ã‚’é¸ã¶äººã€é¸ã°ãªã„äºº ãã®é¸æŠžåŸºæº–ã¨ã¯ 5æœˆ31æ—¥(é‡‘) Session4ï¼š16:00ï½ž16:45 db tech showcase 2013 Osaka
fujya 2014/06/07
HiRDBï¼ï¼

ã‚¤ãƒ³ãƒ•ãƒ©

DB

database

RDBMS

HiRDB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ - MySQL/Redis/MongoDB/Redshift
æœ€è¿‘ç™ºå£²ã•ã‚ŒãŸæŠ€è¡“è©•è«–ç¤¾ã®ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ã«å¯„ç¨¿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€Mongo DBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ æŠ€è¡“ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„ãƒ—ãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€Mongo DBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚è¨˜äº‹ã‚’å¯„ç¨¿ã—ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚è‡ªåˆ†ãŒå„æŠ€è¡“ã‚’ç¾æ™‚ç‚¹ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„å†…å®¹ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ»MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™
fujya 2014/03/24
â€œã€Œã‚µãƒ¼ãƒ“ã‚¹ãŒå¤±æ•—ã—ãŸã‚‰MongoDBã®å‹ã¡ã€æˆåŠŸã—ãŸã‚‰RDBMSã®å‹ã¡ã€â€ã²ãƒ

MongoDB

database

redshift

mysql

redis
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã€MariaDBã€PostgreSQLã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿æ¯”è¼ƒ - interdbâ€™s blog
https://mariadb.com/kb/en/optimizer-switch/ã«ã‚ã‚‹ã‚ˆã†ã«ã€MariaDBã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‹ãªã‚Šæ”¹è‰¯ã•ã‚Œã¦ã„ã‚‹ã€‚ ã§ã¯ã€MariaDBã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿ã¯ã©ã®ç¨‹åº¦å„ªç§€ã‹ã€ï¼”ã¤ã®SELECTæ–‡ã®å®Ÿè¡Œã‚’é€šã—ã¦MySQLã¨(ã¤ã„ã§ã«PostgreSQLã¨)æ¯”è¼ƒã—ã¦ã¿ã‚‹ã€‚ (2014.12.3è¿½è¨˜ï¼šã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«ã¤ã„ã¦ã¯çœç•¥ã—ã¦ã¾ã™ãŒã€ã“ã‚“ãªæœ¬ãŒã§ã¾ã™ã€‚) çµè«–ã‚’å…ˆã«ã„ãˆã°ã€ŒMySQLã¯æ¤œç´¢ãŒé€Ÿã„ã€ã¨ã„ã†ã®ã¯éƒ½å¸‚ä¼èª¬ã€‚MariaDBã¯ãŒã‚“ã°ã£ã¦ã‚‹ã‘ã©PostgreSQLã«ã¯ã¾ã ã¾ã åŠã°ãšã€‚ ï¼Šå¿µã®ãŸã‚ã€‚ã“ã‚Œã¯ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã˜ã‚ƒãªã„ã‚ˆã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿ã®æ©Ÿèƒ½æ¯”è¼ƒã§ã™ã€‚ è‡ªåˆ†ã§å†ç¢ºèªã—ãŸã„å ´åˆã¯ã“ã¡ã‚‰ã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆç¾¤ã¨å®Ÿé¨“ã®ã‚„ã‚Šæ–¹ã‚’ç°¡å˜ã«æ›¸ã„ãŸã®ã§å‚ç…§ã®ã“ã¨ã€‚ èª¿æŸ»ç’°å¢ƒ åŒä¸€ãƒžã‚·ãƒ³ã«MySQL5.6.14ã€MariaDB10.0.4ã€
fujya 2013/10/23
PostgreSQL

DB

sql

database

Performance
ãƒªãƒ³ã‚¯
New explain | explain.depesz.com
Optional title for plan: Paste output of EXPLAIN (ANALYZE, BUFFERS, ...) your query; here: Optionally paste your query here: Optionally add some comments (such as table definitions) here:
fujya 2013/06/28
explainã®çµæžœã‚’é›†è¨ˆã—ã¦ãã‚Œã‚‹ã€‚ä½¿ãˆãã†

tool

PostgreSQL

database

SQL
ãƒªãƒ³ã‚¯
ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒšãƒ¼ã‚¸ç§»è»¢ã®ãŠçŸ¥ã‚‰ã›ï¼šãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ï¼šã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼šæ—¥ç«‹
æ—¥ç«‹ã‚ªãƒ¼ãƒ—ãƒ³ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¯ã€ãŠå®¢æ§˜ã®æ—¢å˜ã®è²¡ç”£ã‚’ç”Ÿã‹ã—ãªãŒã‚‰ã€é«˜ã„ä¿¡é ¼æ€§ã¨æŸ”è»Ÿæ€§ã€è‡ªå¾‹æ€§ã‚’å‚™ãˆãŸITã‚·ã‚¹ãƒ†ãƒ ã®å®Ÿç¾ã‚’æ”¯ãˆã¦ã„ã¾ã™ã€‚
fujya 2013/06/26
ã‚ã‹ã‚Šã‚„ã™ã„

db

database

join
ãƒªãƒ³ã‚¯
1