[B! db][RDBMS] peketaminã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

peketamin id:peketamin

dbã¨RDBMSã«é–¢ã™ã‚‹peketaminã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

è«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹
ã€Œè«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°ã€ã‚’èªã‚“ã§ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ãŠã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ›¸ãæ›ãˆã‚’ã™ã‚‹ãªã€immutableãªãƒžã‚¹ã‚¿ã¨æ›´æ–°ãƒã‚°ã«ã‚ˆã£ã¦å…¨ã¦ã‚’æ§‹æˆã—ã‚ã€ã¨ã„ã†ã“ã®è¨˜äº‹ã®ä¸»å¼µã¯ãƒ¢ãƒ‡ãƒªãƒ³ã‚°è«–ã¨ã—ã¦å…¨ãæ£ã—ã„ã€‚ ã ãŒã€æ®‹å¿µãªã“ã¨ã«ã€ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ãƒ¡ãƒ¢ãƒªãŒè²´é‡ãªè³‡æºã ã£ãŸæ™‚ä»£ã®æŠ€è¡“ã§ã‚ã‚‹RDBã¯ã€ãã®ã‚ˆã†ãªãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«åŸºã¥ã„ã¦è¨è¨ˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯å¿…ãšã—ã‚‚é©ã—ã¦ã„ãªã„ã€‚ ç¬¬ä¸€ã®å•é¡Œã¯ã€RDBã«å¯¾ã—ã¦ãªã•ã‚Œã‚‹æ§˜ã€…ãªã€Œæ›´æ–°ã€ï¼ˆãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ï¼‰ã¯ä¸å®šå½¢ï¼ˆã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã©ã®ã‚ˆã†ã«ä¿®æ£ã™ã‚‹ã‹ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä¾å˜ï¼‰ã ã¨ã„ã†ç‚¹ã€‚ä¸å®šå½¢ãªã€Œæ›´æ–°ã€ã‚’æ™‚ç³»åˆ—ã«ãã£ã¦RDBã«è¨˜éŒ²ã—ã¦ã„ãã®ã¯ã€è¨è¨ˆã¨ä¸¦èµ°æ€§ã®ç‚¹ã«ãŠã„ã¦å›°é›£ã‚ã‚‹ã„ã¯ç…©é›‘ãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¿…è¦ã«ãªã‚‹ï¼ˆã¨ã„ã†ã‹ã€ãã®ã‚ˆã†ãªã€Œã‚¤ãƒ™ãƒ³ãƒˆã€ã«ã‚ˆã‚‹ã€Œå¤‰åŒ–ã€ã¯REDOãƒã‚°ã«æ›¸ãã€ãã®æ›´æ–°ã•ã‚ŒãŸã€ŒçŠ¶æ…‹ã€ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¦ã„ãã¨ã„ã†ã®ãŒ
peketamin 2015/03/26
è¨è¨ˆ

RDBMS

db
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€Œå¥å¿˜ç—‡çš„ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã€ã®ææ¡ˆ - æ¥µåŒ—ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä½œè€…: Bill Karwin,å’Œç”°å“äºº,å’Œç”°çœäºŒ,å…å³¶ä¿®å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2013/01/26ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 9äºº ã‚¯ãƒªãƒƒã‚¯: 698å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (46ä»¶) ã‚’è¦‹ã‚‹æœ¬æ›¸ã®è‘—è€…ã¯ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã«å¯¾ã—ã¦æ¶ˆæ¥µçš„ãªã®ã ã‹ã‚‰ã€ã€Œã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã®ä½¿ã„æ–¹ãŒãŠã‹ã—ã„ã€ã¨ã‹è¨€ã†ã®ã¯ãŠé–€é•ã„ãªã®ã‹ã‚‚ã—ã‚Œãªã„ãŒ... å¥å¿˜ç—‡çš„ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ç¬¬3ç« ã®è¨˜è¿°ã‚’ç·åˆã™ã‚‹ã¨ã€è‘—è€…ã¯ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã«ã¤ã„ã¦ä»¥ä¸‹ã®ã‚ˆã†ã«è€ƒãˆã¦ã„ã‚‹ã¨æ€ã†ã€‚ è‡ªç„¶ã‚ãƒ¼ã®ä¸€æ„æ€§ãƒ»ä¸å¤‰æ€§ãŒå½“ã¦ã«ãªã‚‰ãªã„å ´åˆã«ã€Œè‡ªç„¶ã‚ãƒ¼ã®å¤‰æ›´ã®å½±éŸ¿ã‚’å—ã‘ãªã„ã‚ˆã†ã«ã™ã‚‹ã€ã¨ã„ã†ç›®çš„ã§ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‚’å°Žå…¥ã™ã‚‹ã€‚ è‡ªç„¶ã‚ãƒ¼ã®é‡è¤‡ã‚’é˜²ããŸã‚ã«ã€è‡ªç„¶ã‚ãƒ¼ã«UNIQUEã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æŒ¯ã‚‹ã“ã¨ã‚’æŽ¨å¥¨ã™ã‚‹ã€‚ è‡ªç„¶ã‚ãƒ¼ã®ä»£ã‚ã‚Šã«ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‚’å¤–éƒ¨ã‚ãƒ¼ã«ã™ã‚‹ã€‚è‡ªç„¶ã‚ãƒ¼ã¯ä»–ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«è»¢
peketamin 2014/03/16
DB

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

è¨è¨ˆ

RDBMS
ãƒªãƒ³ã‚¯
RDBã®æ©Ÿèƒ½ã‚’NoSQLã§å®Ÿç¾ã™ã‚‹ï¼ˆ1ï¼‰
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯RDBMSã«æ¯”ã¹ã¦ä¸¦åˆ—å‡¦ç†ã§æ€§èƒ½ã‚’ä¸Šã’ã¦ã„ã‘ã‚‹ã¨ã„ã†ç‰¹é•·ãŒã‚ã‚‹åé¢ã€å˜ç´”ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã—ã‹æ‰±ãˆãªã„ã¨ã‹ã€ãƒ‡ãƒ¼ã‚¿ã®ä¸¦ã¹æ›¿ãˆãªã©ãŒé›£ã—ã„ã¨ã„ã†é›£ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã‹ã‚‰ã¯ã€NoSQLã‚’ä½¿ã„ãªãŒã‚‰ã‚‚ã€RDBMSãŒå‚™ãˆã‚‹æ©Ÿèƒ½ã‚’éƒ¨åˆ†çš„ã«å®Ÿç¾ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ é«˜é€Ÿãªåˆ†ã€è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿åŠ å·¥ãŒè‹¦æ‰‹ãªNoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ å‰å›žã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å‡ºã™æµã‚Œã‚’è©³ã—ãè¦‹ã¦ã„ãã¾ã—ãŸã€‚å•ã„åˆã‚ã›ã‚’å—ã‘ã¦ã‹ã‚‰çµæžœã‚»ãƒƒãƒˆã‚’å‹•çš„ã«ä½œã£ã¦è¿”ã™RDBMSã®ã‚„ã‚Šæ–¹ã§ã¯ã€åˆ†æ•£ç’°å¢ƒã«ãŠã„ã¦ã¯ååˆ†ãªå‡¦ç†æ€§èƒ½ã‚’ç™ºæ®ã§ããªã„ã¨ã„ã†ã“ã¨ãŒã”ç†è§£é ‚ã‘ãŸã‹ã¨æ€ã„ã¾ã™ã€‚ RDBMSã¯ãƒ‡ãƒ¼ã‚¿ã®çµåˆã‚„æ¤œç´¢ã®ã»ã‹ã«ã‚‚ã€ãƒ‡ãƒ¼ã‚¿é›†è¨ˆã‚„ä¸¦ã¹æ›¿ãˆãªã©ã€SQLã‚’ä½¿ã£ãŸå•ã„åˆã‚ã›å†…å®¹ã«å¿œã˜ã¦ã•ã¾ã–ã¾ãªå½¢ã«ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã™ã‚‹æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚å¤šæ§˜ãªè¦æ±‚ã«å¿œãˆã¦ãã‚Œã‚‹å•ã„åˆ
peketamin 2013/10/18
nosql

rdbms

db
ãƒªãƒ³ã‚¯
ã¨ã—ã®ä»Šæ—¥ã§ã
peketamin 2010/12/10
mapreduce

nosql

å¤§é‡ãƒ‡ãƒ¼ã‚¿

ä¸¦åˆ—å‡¦ç†

åˆ†æ•£å‡¦ç†

DB

DBMS

RDBMS

ä¸–ä»£
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
peketamin 2010/11/16
mysql

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

ã‚ã¨ã§èªã‚€

DeNA

database

db

performance

tips

RDBMS
ãƒªãƒ³ã‚¯
1