[B! DB] dgdgã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

dgdg id:dgdg

DBã«é–¢ã™ã‚‹dgdgã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

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

ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯åˆ‡ã£ãŸã»ã†ãŒã„ã„ã‚“ã˜ã‚ƒãªã‚¤ã‚«ï¼Ÿ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
KLab Advent Calendar 2011 ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã®2æ—¥ç›®ã¯ã€æ˜¨æ—¥ã«å¼•ãç¶šãã€MySQLã‚’éª¨ã¾ã§ã—ã‚ƒã¶ã‚‹ãŸã‚ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã§ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¯ä¸€èˆ¬ã‚µã‚¤ãƒˆã‚ˆã‚Šã‚‚DBã¸ã®æ›´æ–°ã‚¯ã‚¨ãƒªã®å‰²åˆãŒå¤šããªã‚ŠãŒã¡ã§ã™ã€‚æ›´æ–°ã‚¯ã‚¨ãƒªãŒå¤šã„MySQLã§ã¯ã€é€šå¸¸ã¯æœ‰ç›Šãªã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒç„¡ç›Šã©ã“ã‚ã‹æœ‰å®³ã«ãªã‚Šã¾ã™ã€‚ ãã‚‚ãã‚‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ãŒä½Žã„ã€‚20%ä»¥ä¸‹ãªã‚“ã¦ã“ã¨ã‚‚ã‚¶ãƒ©ã«ã‚ã‚‹ ã—ã‹ã‚‚ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã®æ›´æ–°ã¯ã‚°ãƒãƒ¼ãƒãƒ«ãªãƒãƒƒã‚¯ã‚’å–å¾—ã™ã‚‹ ã‹ã‚‰ã§ã™ã€‚ç‰¹ã«å¾Œè€…ã¯å•é¡Œã§ã™ã€‚ãŸã ã®å‚ç…§ã‚¯ã‚¨ãƒªã‚‚ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’æ›´æ–°ã™ã‚‹ä¸Šã«ã€æ›´æ–°ã‚¯ã‚¨ãƒªã¯ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã®å…¨ã‚¨ãƒ³ãƒˆãƒªã‚’ãƒã‚§ãƒƒã‚¯ã—ã¦ã€æ›´æ–°ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å½±éŸ¿ãŒã‚ã‚Šãã†ãªå…¨ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’discardã—ã¦ã„ããŸã‚ã§ã™ã€‚ãŸã¨ãˆã°ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¡Œå‹•åŠ›ã®ã‚ˆã†ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ãŸå‚ç…§ã‚‚æ›´æ–°ã‚‚å¤šã„ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæœ‰åŠ¹ã«ãªã£ã¦
dgdg 2011/12/02
-

mysql

db

performance
ãƒªãƒ³ã‚¯
Linuxã«ãŠã‘ã‚‹10å„„ãƒ•ã‚¡ã‚¤ãƒ«å•é¡Œ | ã‚¹ãƒ©ãƒ‰
ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãŒå¤§å®¹é‡ã«å¯¾å¿œã—ã€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®å®¹é‡ã‚ãŸã‚Šã®ä¾¡æ ¼ãŒå®‰ããªã‚‹ã«ã¨ã‚‚ãªã„ã€1ã¤ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã«å…¥ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«æ•°ã‚‚å¢—ãˆã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€Red Hatã®Ric Wheeleræ°ã«ã‚ˆã‚‹ã¨ã€100ä¸‡ãƒ•ã‚¡ã‚¤ãƒ«ã§ã¯ã—ã£ã‹ã‚Šã¨å‹•ããƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚‚ã€10å„„ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã‚‚ãªã‚‹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡ŒãŒç™ºç”Ÿã—ã¦ãã‚‹ã¨ã®ã“ã¨ã€‚ è©³ç´°ã¯Linuxcon 2010ã§ã®ç™ºè¡¨ã‚¹ãƒ©ã‚¤ãƒ‰ï¼ˆPDFï¼‰åŠã³LWNã®è¨˜äº‹ã‚’å‚ç…§ã€‚ å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã„ãŸã‘ã‚Œã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã‹ã€è¤‡æ•°ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã«åˆ†å‰²ã—ã¦ä½¿ãˆã€ã¨ã„ã†è©±ãŒã‚ã‚‹ã¨æ€ã‚ã‚Œã‚‹ãŒã€ç™ºè¡¨ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã¯ã€Œãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã¯ç„¡æ–™ã§å¤šãã®äººã€…ã«ã¨ã£ã¦è¦ªã—ã¿ã‚„ã™ãåˆ†ã‹ã‚Šã‚„ã™ã„ã€ã¾ãŸè¤‡æ•°ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã«åˆ†å‰²ã™ã‚‹ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ãŒé¢å€’ã«ãªã‚Šã€ã¾ãŸãƒ‡ã‚£ã‚¹ã‚¯ã‚·ãƒ¼ã‚¯ã®æœ€é©åŒ–ãŒé›£ã—ããªã‚‹ã€ã¨ã—ã€å¤§å®¹é‡ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®å¿…è¦æ€§ãŒèª¬ã‹ã‚Œã¦ã„ã‚‹ã€‚ ç¾åœ¨ã§ã‚‚RAIDã‚„JBO
dgdg 2010/08/31
-

hdd

linux

db
ãƒªãƒ³ã‚¯
ã¼ããŒPDOã‚’æŽ¡ç”¨ã—ãªã‹ã£ãŸã‚ã‘(Shift_JISã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³)
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´7æœˆ1æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚ è¿½è¨˜(2011/06/19) ã“ã“ã«æ¥ã¦æ€¥ã«ãƒ–ã‚¯ãƒžãŒè¿½åŠ ã•ã‚Œã¯ã˜ã‚ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰çŠ¶æ³ãŒæ”¹å–„ã—ã¦ã„ã¾ã™ã€‚PHP5.3.6(2011/03/17)ã«ã¦ã€PDOã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ç‰ˆã§ã€UNIXç‰ˆã®PHPã§ã¯è§£æ±ºã—ã¾ã—ãŸãŒã€Win
dgdg 2010/07/03
-

php

security

db
ãƒªãƒ³ã‚¯
Essential Database Naming Conventions (and Style) - Justinsomnia
style use lowercase characters eliminates question of proper case as well as errors related to case-sensitivity speeds typing rate and accuracy differentiates table and column names from uppercase SQL keywords separate words and prefixes with underlines, never use spaces promotes readability (e.g. book_name vs. bookname) avoid having to bracket names (e.g. [book name] or `book name`) offers greate
dgdg 2010/06/14
-

naming

DB

design
ãƒªãƒ³ã‚¯
Not Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
Webã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€ä¸–ç•Œä¸ã‹ã‚‰ã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒãå¿…è¦ãŒã‚ã‚‹ãŸã‚ã€ã„ãã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã‚ˆã†ã¨ã‚‚ä¸€å°ã®RDBMSã§ã¯æŒããã‚‹ã“ã¨ãŒå‡ºæ¥ãªã„ã®ãŒå¸¸ã ã€‚MySQLã¯æœ€åˆã‹ã‚‰ãƒžã‚¹ã‚¿ãƒ¼ãƒ»ã‚¹ãƒ¬ãƒ¼ãƒ–åž‹ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ãŒæè¼‰ã•ã‚Œã¦ãŠã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ãŸãã•ã‚“ã¶ã‚‰ä¸‹ã’ã‚‹ã“ã¨ã«ã‚ˆã£ã¦å‚ç…§ã®è² è·ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«å‰²ã‚ŠæŒ¯ã‚‹ã¨ã„ã†ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã«ã‚ˆã£ã¦ãã®å•é¡Œã«å¯¾å‡¦ã—ã¦ããŸã€‚ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã‚ˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã¯ã€å‚ç…§ï¼ˆï¼PVï¼‰ãŒå¤šã„Webã‚µã‚¤ãƒˆã¨éžå¸¸ã«ç›¸æ€§ãŒè‰¯ãã€å¹¾å¤šã®Webã‚µã‚¤ãƒˆã«ãŠã„ã¦å®Ÿç¸¾ã‚’ä½œã£ã¦ãã¦ã„ã‚‹ã—ã€ã¾ã ã¾ã åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚µã‚¤ãƒˆã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ãŒåŠ‡çš„ã«å¢—åŠ ã—ã¦ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹è² è·åˆ†æ•£ã§ã¯è¿½ã„ã¤ã‹ãªããªã£ã¦ããŸã€‚ãã“ã§äººã€…ãŒã¨ã£ãŸé¸æŠžè‚¢ã¯ã€memcachedã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã‚ã‚‹ã€‚memcachedã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåž‹ã®é«˜é€ŸãªKVSã§ã‚ã‚Šã€å‚ç…§ãƒ»æ›´æ–°æ€§èƒ½ã¯MySQLã‚ˆã‚Šæ ¼æ®µã«é«˜ã„ã€‚M
dgdg 2010/03/25
DB
ãƒªãƒ³ã‚¯
Tags: Database schemas
An online tech community is the most exciting place for a software developer to spend their time. It not only offers the chance to work and interact remotely, but also helps in honing oneâ€™s own skills and becoming a well-rounded programmer. Whether you are a budding software developer or simply passionate about techno logy, here are the best online software development communities you can join. The
dgdg 2010/02/10
-

db

design

schema
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ï¼šãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç„¡æ–™ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒERMasterã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã¨ãã«çš†ã•ã‚“ã¯ã€ã©ã®ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã„ãã¤ã‹ã®ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç†è€…ã¯ãã‚Œã‚‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ã€ŒERMasterã€ã¨å‘¼ã°ã‚Œã‚‹Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®å˜åœ¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ERMasterã¯ã€ã»ã‹ã®ãƒ„ãƒ¼ãƒ«ã«æ¯”ã¹ã€ç›´æ„Ÿçš„ã§åˆ†ã‹ã‚Šã‚„ã™ã„UIï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã«ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ãªã€Excelã§å‡ºåŠ›ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€è¾žæ›¸æ©Ÿèƒ½ãªã©ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±ŠãERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®ERMasterã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ERMasterã®ä¸»ãªç‰¹å¾´ã€8ã¤ ERMasterã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ã€1ã€‘ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„
dgdg 2010/01/22
-

eclipse

rdbms

design

db
ãƒªãƒ³ã‚¯
scale out ã®æŠ€è¡“ (in UNIX magazine, April 2009)
scale outã®æŠ€è¡“ é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ é¦–è—¤ä¸€å¹¸, "ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æŠ€è¡“", ã‚¯ãƒ©ã‚¦ãƒ‰ã®æŠ€è¡“, pp.88-101, (æ ª)ã‚¢ã‚¹ã‚ãƒ¼ãƒ»ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ¯ãƒ¼ã‚¯ã‚¹, ISBN978-4-04-868064-6, 2009å¹´ 11æœˆ 6æ—¥ ã‚¢ã‚¹ã‚ãƒ¼ãƒ»ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ¯ãƒ¼ã‚¯ã‚¹ç¤¾ã® æ›¸ç±ç´¹ä»‹ãƒšãƒ¼ã‚¸ Amazon.co.jp ã® ãƒšãƒ¼ã‚¸ é¦–è—¤ä¸€å¹¸, "ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æŠ€è¡“", UNIX magazine 2009å¹´ 4æœˆå·, pp.78-91, (æ ª)ã‚¢ã‚¹ã‚ãƒ¼ãƒ»ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ¯ãƒ¼ã‚¯ã‚¹, 2009å¹´ 3æœˆ 18æ—¥ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ±‚ã‚ã‚‰ã‚Œã‚‹æ€§èƒ½ã‚’è©¦ç®—ã—ãŸã¨ã“ã‚ã€ åå°ã€ç™¾å°â€¦æ•°ä¸‡å°ã®ã‚µãƒ¼ãƒãŒå¿…è¦ã«ãªã£ãŸã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã‚’æ§‹ç¯‰ã™ã‚‹å´ã¯ã“ã†ã„ã†å•é¡Œã«ç›´é¢ã—ã€è§£æ±ºã—ã‚ˆã†ã¨ã—ã¦ããŸã€‚ å°æ•°ã«æ¯”ä¾‹ã—ãŸæ€§èƒ½ã‚’å¼•ãå‡ºã™ã“ã¨ã€ã¤ã¾ã‚Šsca
dgdg 2010/01/20
*

scalability

db

server
ãƒªãƒ³ã‚¯
åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã€Œkumofsã€ã‚’å…¬é–‹ã—ã¾ã—ãŸï¼ - Blog by Sadayuki Furuhashi
åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ kumofs ã‚’ã€æœ¬æ—¥ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ã—ã¦ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸï¼ kumofs@SourceForge kumofsé–¢é€£è³‡æ–™ã¾ã¨ã‚ kumofsã¨ã¯ï¼Ÿ kumofsï¼ˆã‚¯ãƒ¢ã‚¨ãƒ•ã‚¨ã‚¹ï¼‰ã¯ã€å®Ÿç”¨æ€§ã‚’é‡è¦–ã—ãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã§ã™ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’å‚™ãˆã€ä¸€éƒ¨ã®ã‚µãƒ¼ãƒãƒ¼ã«éšœå®³ãŒç™ºç”Ÿã—ã¦ã‚‚å‹•ä½œã—ç¶šã‘ã¾ã™ã€‚å˜ä½“ã§ã‚‚é«˜ã„æ€§èƒ½ã‚’æŒã¡ãªãŒã‚‰ã€ã‚µãƒ¼ãƒãƒ¼ã‚’è¿½åŠ ã™ã‚‹ã“ã¨ã§èªã¿ãƒ»æ›¸ãä¸¡æ–¹ã®æ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ç‰¹å¾´ã‚’æŒã¡ã€ä½Žã‚³ã‚¹ãƒˆã§æ¥µã‚ã¦é«˜é€Ÿãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ãƒ»é‹ç”¨ã§ãã¾ã™ã€‚ kumofsã®å¤§ããªç‰¹å¾´ã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã®æ§‹æˆã®ç°¡å˜ã«å¤‰æ›´ã§ãã‚‹ç‚¹ã§ã™ã€‚ã‚·ã‚¹ãƒ†ãƒ ã‚’æ¢ã‚ã‚‹ã“ã¨ãªãã€ç°¡å˜ãªæ‰‹é †ã§ã‚µãƒ¼ãƒãƒ¼ã‚’è¿½åŠ ã—ãŸã‚Šå¾©æ—§ã—ãŸã‚Šã§ãã¾ã™ã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¯ä¸€åˆ‡å½±éŸ¿ã‚’ä¸Žãˆã¾ã›ã‚“ã€‚ ã¾ãŸkumofsã¯ã€åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹åˆ†æ•£ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚·ã‚¹ãƒ†ãƒ ã®ã€Œmemcachedã€ã¨äº’æ›æ€§ã®ã‚ã‚‹ãƒ—ãƒãƒˆã‚³ãƒ«ã‚’å®Ÿè£…
dgdg 2010/01/18
-

key-value

db

kumofs
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
dgdg 2010/01/18
*

key-value

db

nosql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: é«˜åº¦ã«é€²åŒ–ã—ãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ RDBMS ã¨è¦‹åˆ†ã‘ãŒã¤ã‹ãªã„ï¼Ÿ (shibuya.pm #12 ã‚¹ãƒ©ã‚¤ãƒ‰)
é–‹ç™ºã—ã¦ã„ã‚‹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ Incline ã¨ Pacific ã«ã¤ã„ã¦ã¯ YAPC::Asia 2009 ã‚’å§‹ã‚ã„ã‚ã„ã‚ãªæ‰€ã§è©±ã‚’ã™ã‚‹æ©Ÿä¼šã‚’ã„ãŸã ã„ã¦ããŸã®ã§ã€ä»Šå›žã¯ã€ãªãœ RDBMS ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æŽ¡ç”¨ã—ãŸã®ã‹ã¨ã„ã†èƒŒæ™¯ã‚’ä¸å¿ƒã«èª¬æ˜Žã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚æ¦‚å¿µçš„ãªè©±ãŒå¤šãã¦åˆ†ã‹ã‚Šã«ãã‹ã£ãŸã¨æ€ã„ã¾ã™ï¼ˆã™ã¿ã¾ã›ã‚“ï¼‰ãŒã€ç´°ã‹ãªç‚¹ã«ã¤ã„ã¦ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)ã‚’å‚ç…§ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸã€ä¸ã§å‡ºã¦ããŸã€Œå®Ÿä½“åŒ–ãƒ“ãƒ¥ãƒ¼ã€ã«ã¤ã„ã¦ã¯ã€Materialized view - Wikipedia, the free encyclopediaãŒè‰¯ãã¾ã¨ã¾ã£ã¦ã„ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚Incline ã¯ä¸€è¨€ã§ã„ã†ã¨ã€RDBã§æ§‹æˆã•ã‚Œã‚‹shardç¾¤ã®ä¸Šã§ read-only ã‹ã¤ eventually co
dgdg 2009/12/02
-

db
ãƒªãƒ³ã‚¯
54è¡Œã§åˆ†æ•£KVSã‚’å®Ÿè£…ã™ã‚‹ï¼ˆãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ä»˜ãï¼‰ - Blog by Sadayuki Furuhashi
Ruby ã¨ MessagePack-RPC ãŒã‚ã‚Œã°ã€ç°¡å˜ãªkey-valueã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯ç°¡å˜ã«ä½œã‚Œã¾ã™ã€‚54è¡Œã§æ›¸ã‘ã¾ã™ï¼ˆãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨è² è·åˆ†æ•£æ©Ÿèƒ½ä»˜ãã€‚ã‚µãƒ¼ãƒãƒ¼38è¡Œã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ16è¡Œï¼‰ã€‚ ç°¡å˜ãªKVSã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦ã€ãƒã‚°é›†è¨ˆã‚„é éš”ãƒ‡ãƒ—ãƒã‚¤ã€é éš”ç®¡ç†æ©Ÿèƒ½ãªã©ã®æ©Ÿèƒ½ã‚’è¿½åŠ ã—ã¦ã„ã‘ã°ã€ã¡ã‚‡ã£ã¨ä¾¿åˆ©ãªã‚µãƒ¼ãƒãƒ¼ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ã‚µã‚¯ã‚µã‚¯è‡ªä½œã§ãã‚‹ãƒã‚ºã€‚ ã“ã®åˆ†æ•£KVSã¯ã€ï¼ˆkeyã®ãƒãƒƒã‚·ãƒ¥å€¤ % ã‚µãƒ¼ãƒãƒ¼ã®å°æ•°ï¼‰ç•ªç›®ã®ã‚µãƒ¼ãƒãƒ¼ã«keyã‚’ä¿å˜ã—ã¾ã™ã€‚ã¾ãŸã€ã‚µãƒ¼ãƒãƒ¼ã®åå‰é †ã§ã‚½ãƒ¼ãƒˆã—ãŸã¨ãã®ã€Œæ¬¡ã®ã‚µãƒ¼ãƒãƒ¼ã€ã¨ã€Œæ¬¡ã®æ¬¡ã®ã‚µãƒ¼ãƒãƒ¼ã€ã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¾ã™ã€‚ ã™ã¹ã¦ã®ã‚µãƒ¼ãƒãƒ¼ã§åŒã˜è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã„ã¾ã™ã€‚ã‚µãƒ¼ãƒãƒ¼ã”ã¨ã®è¨å®šã¯å¼•æ•°ã‚’è‡ªåˆ†ã®ãƒ›ã‚¹ãƒˆåã«æ›¸ãæ›ãˆã‚‹ã ã‘ãªã®ã§ã€ãƒ‡ãƒ—ãƒã‚¤ãŒå®¹æ˜“ã§ã™ã€‚ MessagePack-RPC for Ruby ã‚’ä½¿ã†ã¨ã€åˆ†æ•£ã—ãªã„key-valueã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸*1ã¯
dgdg 2009/11/27
-

ruby

KVS

db
ãƒªãƒ³ã‚¯
Spiceworks Community
dgdg 2009/11/20
-

db

design

thinking
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
dgdg 2009/10/23
-

db

mysql

server
ãƒªãƒ³ã‚¯
http://wedata.net/
dgdg 2009/06/11
-

-ing

web

db
ãƒªãƒ³ã‚¯
PostgreSQLã‚’æœ¬å½“ã«é«˜é€ŸåŒ–ã—ãŸã„äººã®ãŸã‚ã®10ã®ãƒã‚¤ãƒ³ãƒˆ | ç‹¬ã‚Šè¨€v6
ç©ºæ°—ã‚’èªã¾ãšã«PostgreSQLã®ã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®ãƒã‚¤ãƒ³ãƒˆ - è±¡ã¨æˆ¯ã‚Œ -ç©ºæ°—ã‚’èªã¾ãšã«PostgreSQLã®ã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®ãƒã‚¤ãƒ³ãƒˆ - è±¡ã¨æˆ¯ã‚Œ - postgresqlã‚°ãƒ«ãƒ¼ãƒ—.ã®å…ƒã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§æ€ã†ã¨ã“ã‚ãŒã‚ã£ãŸã®ã ãŒã€ PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆ ã ã‹ã‚‰ãã‚“ãªã›ã¾ã£ãã‚‹ã—ã„ã¨ã“ã‚ã§ãƒˆãƒ³ãƒãƒ³ã‚«ãƒ³ã«disã‚‹æš‡ã‚ã‚‹ã‚“ã ã£ãŸã‚‰è‡ªåˆ†ã®ãƒ–ãƒã‚°ã§ãŠå¥½ã¿ã®è°è«–ã‚’æ›¸ãã‹ã•ã‚‚ãªãã‚ƒ/dev/nullã«ã§ã‚‚åã‘ã¨ã‚„ã‚“ã‚ã‚Šã¨è¨€ã£ã¦ã‚‹ã‚“ã ã‚ˆãƒã‚²ã€‚ ã¨ã„ã†ã‚ã‘ã§ï½—ã€‚ ã ã‚ˆãï½—ã€‚ ã¾ã‚æ£ç›´ã€ä¸Šè¨˜å…ƒãƒã‚¿ã®ã»ã†ã«ã¯è‰²ã€…çªã£è¾¼ã¿ã©ã“ã‚æº€è¼‰ãªã®ã ãŒã€ãã‚Œã¯ç½®ã„ã¦ãŠãã¨ã—ã¦L.starãªã‚Šã®é«˜é€ŸåŒ–ãƒã‚¤ãƒ³ãƒˆã‚’ä¸€åº¦æ›¸ã„ã¦ãŠã‹ãªã„ã¨ã€ã¨æ€ã£ãŸã®ã§è¨˜ã™ã€‚ãŸã ã€L.starã¯ã‚‚ã†PostgreSQLç•Œéšˆã‹ã‚‰é›¢ã‚Œã¦ä¹…ã—ã„ã®ã§ã€å¿…ãšã—ã‚‚æœ€æ–°ã®å†…å®¹ã‚’ç¶²ç¾…ã—ã¦ã„ãªã„ã“ã¨ã«æ³¨æ„ã•ã‚ŒãŸã—ã€‚ã¾ãŸã€å‡ºæ¥ã‚‹ã ã‘Pos
dgdg 2009/02/26
-

db

performance

postgresql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
dgdg 2009/02/26
ãƒãƒƒãƒˆã‹ã‚‰æ–çµ¶ã—ã¦ã„ãŸã‚‰ã™ã£ã‹ã‚Šå–ã‚Šæ®‹ã•ã‚Œã¦ã„ãŸâ€¦ã€‚çµæžœçš„ã«ãƒŽã‚¦ãƒã‚¦è©±ãŒå¢—ãˆã¦ãƒ›ã‚¯ãƒ›ã‚¯ã§ã™ã€‚æ„Ÿè¬

-

db

performance

postgresql
ãƒªãƒ³ã‚¯
RubyGemã§Sqld4rã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸ
æœå¹Œã®ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚µãƒ¼ã¾ã„ã‚€ãžã†ã®ãƒ–ãƒã‚°ã€‚Androidé–¢é€£ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ“ã‚¸ãƒ§ãƒ³ã€IoTã€ãƒãƒœãƒ†ã‚£ã‚¯ã‚¹ã‚ãŸã‚Šã‚’ã‚„ã£ã¦ã„ã¾ã™ã€‚ Sqld4rã¨ã¯ä½•ã®äº‹ã‹ã¨ã„ã†ã¨ã€SQLDesignerã®ãƒ‡ãƒ¼ã‚¿ä¿å˜ç”¨XMLãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã€Railsã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ¢ãƒ‡ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ã¦ãã‚Œã‚‹gemã®äº‹ã§ã™ã€‚ ä»¥å‰ã‹ã‚‰railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°å‰ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’æ±ºã‚ã‚‹ã‚“ã§ã™ãŒã€ãã®æ™‚ã«ä½¿ã†ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦SQLDesignerã‚’ä½¿ã£ã¦ã„ã¾ã—ãŸã€‚ ä»–ã«ã‚‚è‰²ã€…DBã®è¨è¨ˆãƒ„ãƒ¼ãƒ«ã¯ã‚ã‚‹ã‚“ã§ã™ãŒã€SQLDesignerã‚’å¥½ã‚“ã§ã„ã‚‹ã®ã¯ä»¥ä¸‹ã®ç†ç”±ã§ã™ã€‚ ç‰¹å®šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚ç”¨ã¨ã„ã†ã“ã¨ã§ã¯ãªãã€å¹…åºƒãå¯¾å¿œã—ã¦ã„ã‚‹ ActiveRecordã®è¨è¨ˆã‚’ã™ã‚‹å ´åˆã€(å˜æ•°å½¢ãƒ†ãƒ¼ãƒ–ãƒ«å)_idã¨ã„ã†è¡¨ç¾ã‚’ã‚ˆãä½¿ã†ãŒã€ã“ã®ã‚µãƒãƒ¼ãƒˆæ©Ÿèƒ½ãŒã‚ã‚‹ Webä¸Šã§è¨è¨ˆã§ãã‚‹ã®ã§ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆOSã«ä¾å˜ã—ãªã„ã€‚(å®Ÿéš›ã«ã¯ãƒ–ãƒ©ã‚¦
dgdg 2009/01/26
-

db

rails
ãƒªãƒ³ã‚¯
Leo's Chronicle: ãœã²æŠ¼ã•ãˆã¦ãŠããŸã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ•™ç§‘æ›¸
å…ˆæ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã§å°‘ã—è©±ã—ãŸã®ã§ã™ãŒã€åƒ•ãŒåœ¨å¦ã—ã¦ã„ãŸã¨ãã®æ±å¤§ã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶ãŸã‚ã®ã‚³ãƒ¼ã‚¹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸï¼ˆDBé–¢ä¿‚ã®æŽˆæ¥ã¯å¹´ã«ï¼‘ã¤ã‹ï¼’ã¤ã‚ã‚‹ç¨‹åº¦ã€‚ç¾åœ¨ã¯ã©ã†ãªã‚“ã ã‚ã†ï¼Ÿï¼‰ã€‚ãã‚“ãªã¨ãã«å½¹ã ã£ãŸã®ã¯ã€ã‚„ã¯ã‚Šæ•™ç§‘æ›¸ã€‚èªã¿ã‚„ã™ã„ã‚‚ã®ã‹ã‚‰é †ã«ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆã¨ã¯ã„ã£ã¦ã‚‚ã™ã¹ã¦è‹±èªžã®æœ¬ã§ã™ã€‚ã‚ã—ã‹ã‚‰ãšï¼‰ ä¸€ç•ªã®ãŠè–¦ã‚ã¯ã€Raghu Ramakrishnanå…ˆç”Ÿ (ç¾åœ¨ã¯ã€Yahoo! Research) ã®ã€ŒDatabase Management Systems (3rd Edition)ã€ã€‚åˆå¦è€…ã‹ã‚‰ç ”ç©¶è€…ã¾ã§å¹…åºƒãä½¿ãˆã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã®åŸºæœ¬æ¦‚å¿µã‹ã‚‰ã€å•ã„åˆã‚ã›æœ€é©åŒ–ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ãªã©ã€ã“ã‚Œã‚‰ã‚’å®Ÿè£…ãƒ»è©•ä¾¡ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã€ã€ŒDBã®ä¸–ç•Œã§ã®å¸¸è˜ã€ãŒã€ä¸å¯§ãªèªžã‚Šå£ã§ãµã‚“ã ã‚“ã«ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®1å†Šã‚’èªã‚“ã§ãŠã‘ã°ã€DBã®ä¸–ç•Œã§è°è«–ã™ã‚‹ãŸã‚ã®
dgdg 2009/01/08
èªã‚ãªã„ã‘ã©ãƒã‚¤ãƒ³ã‚¿ã¨ã—ã¦

-

db

book

-logical
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
dgdg 2008/12/24
ã“ã®ã‚µã‚¤ãƒˆãŒç„¡ã‹ã£ãŸã‚‰SQLã‚„ã£ã¦ãªã‹ã£ãŸã‹ã‚‚

-

db

sql

tips
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸