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

yutasega id:yutasega

databaseã«é–¢ã™ã‚‹yutasegaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

SQLã®è¦³ç‚¹ã‹ã‚‰ã€ŒOracle Databaseã€ã€ŒPostgreSQLã€ ã€ŒMySQLã€ã®ç‰¹å¾´ã‚’æ•´ç†ã—ã‚ˆã†ï¼
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
yutasega 2014/10/02
database
ãƒªãƒ³ã‚¯
MongoDBãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæ—¥æœ¬èªžè¨³ä¸€éƒ¨å®Œäº†ã®ãŠçŸ¥ã‚‰ã› - Masatomo Nakano Blog
ã¼ã¡ã¼ã¡é€²ã‚ã¦ããŸ Mongo DB ã®æ—¥æœ¬èªžè¨³ã§ã™ãŒã€ãã®ä¸ã®å¤§ããªã‚»ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸€ã¤ã§ã‚ã‚‹ Developer Zone ã® ç¿»è¨³ ãŒå®Œäº†ã—ã¾ã—ãŸã€‚Developer Zoneå†…ã®ã™ã¹ã¦ã®ãƒšãƒ¼ã‚¸ã¯å®Œå…¨ã«è‹±èªžç‰ˆã¨åŒæœŸã—ã¦ã„ã‚‹ã¯ãšã§ã™ã€‚ Developer Zoneã¨ã¯ ã“ã®ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€Mongo DBã®ç‰¹å¾´ã€ä»•çµ„ã¿ã€åŸºæœ¬çš„ãªæ“ä½œã€Mongo DBã‚’ä½¿ã£ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™ã‚‹é–‹ç™ºè€…ã¯ã©ã†ã„ã†ã“ã¨ã«æ„è˜ã—ãŸæ–¹ãŒã„ã„ã®ã‹ã€ã¨è¨€ã£ãŸã“ã¨ãŒæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ Mongo DBã§é–‹ç™ºã‚’ã™ã‚‹äººã¯ã¾ãšä¸€èªã—ã¦ãŠãã¹ãå†…å®¹ã§ã™ã€‚ ç›®æ¬¡ ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ« ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚³ãƒžãƒ³ãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¤‡è£½ fsync ã‚³ãƒžãƒ³ãƒ‰ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹é–¢é€£ã‚³ãƒžãƒ³ãƒ‰ Last Error ã‚³ãƒžãƒ³ãƒ‰ Windows ã‚µãƒ¼ãƒ“ã‚¹ å‹•ä½œä¸ã®å‡¦ç†ã®å‚ç…§ã¨åœæ¢ Validate ã‚³ãƒžãƒ³ãƒ‰ List of Databas
yutasega 2011/02/07
MongoDB

database
ãƒªãƒ³ã‚¯
å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆæƒ…å ±ã‚’ã‚µã‚¤ã‚ºé †ã«ä¸€è¦§è¡¨ç¤ºã™ã‚‹
MySQLã«ãŠã„ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã€å¹³å‡ãƒ¬ã‚³ãƒ¼ãƒ‰é•·ãªã©ã®çµ±è¨ˆæƒ…å ±ã‚’çŸ¥ã‚‹ä¸Šã§show table statusã¯å®šç•ªã§ã™ã€‚ãŸã é›‘å¤šãªè¡¨ç¤ºé …ç›®ã‚‚å¤šã„ã®ã§ã€ãŸãã•ã‚“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆã‚’è¦‹ã‚‹å ´åˆã€å¿…è¦ãªæƒ…å ±ã ã‘ã‚’è¿”ã—ãŸã„ã“ã¨ã¯å¤šã„ã§ã™ã€‚ã¾ãŸå…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã†ã¡ã€ã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒä¸€ç•ªå¤§ãã„ã®ã‹ã‚’çŸ¥ã‚ŠãŸã„ã¨ã‹ã€ã‚µã‚¤ã‚ºãŒå¤šã„é †ã«ä¸€è¦§è¡¨ç¤ºã—ãŸã„ã¨ã‹ã€ä¸€ç›®ã§åˆ†ã‹ã‚‹ã‚ˆã†ãªæƒ…å ±ãŒã»ã—ã„ã“ã¨ã‚‚å¤šã„ã§ã™ã€‚ ã“ã†ã„ã†ã¨ãã¯information_schema.tablesã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€appãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚º+ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã€ã®å¤§ãã„é †ã«ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã€å¹³å‡ãƒ¬ã‚³ãƒ¼ãƒ‰é•·ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚º(MB)ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚º(MB)ãªã©ã‚’è¿”ã—ã¦ã„ã¾ã™ã€‚ use app; select table_name, engine, table_
yutasega 2010/11/15
database
ãƒªãƒ³ã‚¯
DBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/Oæ€§èƒ½ã‚’æ³¨è¦–ã™ã‚‹
DBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦ã€æ°—ã‚’é…ã‚‹ã¹ãã¨ã“ã‚ã¯æ•°å¤šãã‚ã‚Šã¾ã™ãŒã€ä¸ã§ã‚‚çœŸã£å…ˆã«è¦‹ã‚‹ã¹ãã¨ã“ã‚ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/Oã§ã—ã‚‡ã†ã€‚ãªãœã‹ã¨ã„ã†ã¨ã€ãƒ¡ãƒ¢ãƒªã‚¢ã‚¯ã‚»ã‚¹ã«æ¯”ã¹ã¦HDDã®æ–¹ãŒåœ§å€’çš„ã«é…ãã€æœ€ã‚‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é˜»å®³è¦å› ã«ãªã‚Šã‚„ã™ã„ãŸã‚ã§ã™ã€‚ãƒ‡ã‚£ã‚¹ã‚¯I/Oãƒãƒƒã‚¯ã®è§£æ±ºæ–¹æ³•ã‚’æŽ¢ã£ã¦ã„ãã¨ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«/ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆã‚„SQLæ–‡ã®è¦‹ç›´ã—ã€ã«è¡Œãç€ãã“ã¨ã‚‚ã¾ãŸå¤šã„ã§ã™ã€‚ã“ã‚Œã‚‰ãŒä¸é©åˆ‡ã ã¨ã€çµæžœã¨ã—ã¦å¤§é‡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒå¤šãç™ºç”Ÿã—ã¦ã—ã¾ã†ãŸã‚ã§ã™ã€‚æ ¹æœ¬çš„ãªåŽŸå› ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/Oã«ã‚ã‚Šã¾ã™(CPUãƒãƒƒã‚¯ã«ãªã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ãŒã€ãã®ä¾‹ã¯åˆ¥ã®æ©Ÿä¼šã«å–ã‚Šä¸Šã’ã¾ã™)ã€‚ ãƒ‡ã‚£ã‚¹ã‚¯I/Oã«ã¯å¤§ããåˆ†ã‘ã¦ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¢ã‚¯ã‚»ã‚¹ã¨ãƒ©ãƒ³ãƒ€ãƒ ã‚¢ã‚¯ã‚»ã‚¹ã®2ç¨®é¡žã®ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€RDBMSã§ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ãŒä¸»ä½“ã¨ãªã‚‹ãŸã‚ã€ãƒ«ãƒ¼ãƒˆâ†’ãƒ–ãƒ©ãƒ³ãƒâ†’ãƒªãƒ¼ãƒ•â†’å®Ÿãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ã„ã†çµŒè·¯ã§ã®ãƒ©ãƒ³ãƒ€ãƒ
yutasega 2010/11/15
database
ãƒªãƒ³ã‚¯
HDDã‚’SSDã«ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚Œã ã‘é€Ÿããªã‚‹ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå®Ÿé¨“
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹éš›ã«ã¯ã€é«˜ã„æ€§èƒ½ã‚’å¼•ãå‡ºã™ãŸã‚ã«ç‰©ç†è¨è¨ˆã‚’ã—ã€ã‚¹ã‚ãƒ¼ãƒžã‚’å·¥å¤«ã—ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ãŒã¤ãã«è¡Œã‚ã‚Œã¦ãã¾ã—ãŸã€‚ æ€§èƒ½ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ãŸã„ãŒã„HDDã«ã‚ã‚Šã€ã„ã‹ã«ãã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ã‹ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã§ã™ãŒã€æœ€è¿‘ã§ã¯æ€§èƒ½å‘ä¸Šã®ãŸã‚ã®æ¦å™¨ã¨ã—ã¦ã€HDDã‚ˆã‚Šã‚‚ãšã£ã¨ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã®é«˜ã„SSDãŒæ³¨ç›®ã•ã‚Œã¦ã„ã¾ã™ã€‚SSDã¯HDDã¨ç½®ãæ›ãˆã‚‹ã ã‘ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã£ãŸãæ‰‹ã‚’åŠ ãˆãšã«æ€§èƒ½å‘ä¸Šã‚’å¯èƒ½ã«ã™ã‚‹æ‰‹æ®µã¨ã—ã¦éžå¸¸ã«é…åŠ›çš„ã§ã™ã€‚ HDDã®ä»£ã‚ã‚Šã«SSDã‚’åˆ©ç”¨ã—ãŸã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã¯ã©ã‚Œã ã‘å‘ä¸Šã™ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå…±åŒæ¤œè¨¼ã‚’è¡Œã„ã€ãã®çµæžœã‚’ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦å…ˆé€±ç™ºè¡¨ã—ã¾ã—ãŸï¼ˆå‚è€ƒã€Œæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€š ãƒ•ãƒ©ãƒƒã‚·ãƒ¥æŠ€è¡“æ´»ç”¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–ã‚’å…±åŒæ¤œè¨¼ã€ï¼‰ã€‚ ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã§ã¯ã€HDDã®ä»£ã‚ã‚Š
yutasega 2010/04/26
database

oracle
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚°ãƒ©ãƒ å†…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‡¦ç†é«˜é€ŸåŒ–TIPS:phpspoté–‹ç™ºæ—¥èªŒ
10 sql tips to speed up your database ãƒ—ãƒã‚°ãƒ©ãƒ å†…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‡¦ç†é«˜é€ŸåŒ–TIPSãŒ10å€‹ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã‚¨ãƒ³ãƒˆãƒªã®ã”ç´¹ä»‹ã§ã™ã€‚ SQLãŒé©åˆ‡ã«è¨è¨ˆã•ã‚Œã¦ã„ãªã„ã¨ã™ãã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‡¦ç†ãŒCPUã‚’åœ§è¿«ã—ã¦ã—ã¾ã„ã¾ã™ã®ã§å¯èƒ½ãªé™ã‚ŠçŸ¥ã£ã¦ãŠããŸã„ã§ã™ãã€‚ åŸºæœ¬çš„ãªäº‹ã‹ã‚‰å¿œç”¨çš„ãªäº‹ã¾ã§å‚è€ƒã«ãªã‚Šãã†ã ã£ãŸã®ã§ãƒ¡ãƒ¢ç¨‹åº¦ã«ã”ç´¹ä»‹ã€‚ explainã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ã‚‹ã‹ã‚’èª¿ã¹ã‚‹ æœ€ã‚‚é€Ÿã„ã‚¯ã‚¨ãƒªã¯ã€ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã—ãªã„ã“ã¨ã€ã¨ã„ã†ã“ã¨ã§ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã‚ˆã† Memcached, CSQL Cache, AdoDB ãªã©ã§ãã‚ŒãŒå¯èƒ½ å¿…è¦ã˜ã‚ƒãªã„ãƒ¢ãƒŽã‚’select ã—ãªã„ã‚ˆã†ã«ã™ã‚‹ select * from table; â†“ select id from table; limit ã‚’ä½¿ã£ã¦å–å¾—ã™ã‚‹çµæžœã‚’å°‘ãªãã™ã‚‹ foreach ãƒ«ãƒ¼ãƒ—ãªã©ã®ä¸ã§sqlã‚¯ã‚¨ãƒªã‚’
yutasega 2010/03/12
database
ãƒªãƒ³ã‚¯
Twitterã¨DiggãŒNoSQLã®ã€ŒCassandraã€ã‚’é¸ã¶ç†ç”±
ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã™ã‚‹æ‰‹æ®µã¨ã—ã¦ã€ŒSharding MySQL plus memcachedã€ãŒã‚ˆãçŸ¥ã‚‰ã‚Œã‚‹æ–¹æ³•ã ã¨ã¯ã€1ã¤å‰ã®è¨˜äº‹ã€ŒMySQL+Memcachedã®æ™‚ä»£ã¯éŽãŽã€ã“ã‚Œã‹ã‚‰ã¯NoSQLãªã®ã‹ã€ã«ã¤ã„ã¦ã®è°è«–ã€ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ã¡ãªã¿ã«ã€ŒShardingã€ï¼ˆã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ï¼‰ã¨ã¯è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æ•£ã—ã¦é‹ç”¨ã™ã‚‹ã“ã¨ã§ã€ã–ã£ãã‚Šã„ãˆã°Shared Nothingçš„ãªåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹æˆã®ã“ã¨ã§ã™ï¼ˆã“ã®è¨˜äº‹ã§ç´¹ä»‹ã™ã‚‹è‹±æ–‡ä¸ã«ã¯ã€ŒShared MySQLã€ï¼ˆå…±æœ‰MySQLï¼‰ã¨ã®è¨˜è¿°ãŒã‚ã‚Šã¾ã™ãŒã€ã“ã‚Œã¯æã‚‰ãã€ŒSharded MySQLã€ï¼ˆShardã•ã‚ŒãŸMySQLï¼‰ã®ãƒŸã‚¹ã‚¹ãƒšãƒ«ã§ã¯ãªã„ã¨æŽ¨æ¸¬ã—ã¾ã™ï¼‰ã€‚ æ—¥æœ¬ã§ï¼ˆãŸã¶ã‚“ï¼‰ã‚‚ã£ã¨ã‚‚MySQLã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¦ã‚ã‚‹ãƒ–ãƒã‚°ã€Œæ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã€ã®ã‚¨ãƒ³ãƒˆãƒªã€Œã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•ã€ã§ã¯ã€Sh
yutasega 2010/03/12
database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ç›®çš„åˆ¥ã«ä½¿ã„åˆ†ã‘ã‚‹ã¹ã—
å…ƒãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®SQL Serveré–‹ç™ºãƒãƒ¼ãƒ ã®ä¸€å“¡ã§ã‚ã‚Šã€ãã®å¾Œãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã¨ã—ã¦æ´»èºã€‚æ˜¨å¹´ã‚¢ãƒžã‚¾ãƒ³ã«ç§»ç±ã—ã¦ã€ç¾åœ¨ã¯Amazon Web Servicesã®ä¸Šç´šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹James Hamiltonæ°ãŒã€è‡ªèº«ã®ãƒ–ãƒã‚°ã®ã€ŒOne Size Does Not Fit Allã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã‘ã«ã¨ã©ã¾ã‚‰ãªã„å¹…åºƒã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡žã‚’4ã¤ã«åˆ†é¡žã—ã¦ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ 4ã¤ã®ç¨®é¡žã¨ã¯ã€Œæ©Ÿèƒ½å„ªå…ˆã€ã€Œã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£å„ªå…ˆã€ã€Œã‚·ãƒ³ãƒ—ãƒ«ã€ã€Œç›®çš„åˆ¥ã€ã§ã™ã€‚ Hamiltonæ°ã¯ã€ã‚¢ãƒžã‚¾ãƒ³ãŒAmazonã‚¯ãƒ©ã‚¦ãƒ‰ã§MySQLã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ãŸã¨ã“ã‚ã€ä»¥å‰ã‹ã‚‰æä¾›ã—ã¦ã„ãŸã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ã€ŒSimpleDBã€ã¯çµ‚äº†ã™ã‚‹ã®ã§ã¯ãªã„ã‹ã¨å¿ƒé…ã™ã‚‹å£°ãŒã‚ã£ãŸã“ã¨ã‚’æŒ™ã’ã€ I can understand why some might co
yutasega 2009/11/09
database
ãƒªãƒ³ã‚¯
ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ãƒ»ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®è½ã¨ã—ç©´ã€ãã®ï¼’
ãšã„ã¶ã‚“å‰ã«ã€ã€Œãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ãƒ»ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®è½ã¨ã—ç©´ã€ãã®ï¼‘ï¼ˆã‹ã‚‚ã—ã‚Œãªã„ï¼‰ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ãŸãŒã€ä»Šå›žã¯PhotoShareã‚µãƒ¼ãƒãƒ¼ã‚’é‹å–¶ã—ã¦ã„ã¦ã€ã¾ã•ã«ã“ã®ã‚ãŸã‚Šã®æ·±ã„è€ƒå¯ŸãŒå¿…è¦ã«ãªã£ã¦æ¥ãŸã®ã§ã€è‰¯ã„æ©Ÿä¼šãªã®ã§ç¶šç·¨ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€‚ PhotoShareã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®ã‚ˆã†ã«CRUDï¼ˆCreate/Read/Update/Deleteï¼‰ã®APIã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’ä½œã‚‹å ´åˆã€Create/Update/Deleteã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã«å¯¾ã—ã¦ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®APIã‚³ãƒ¼ãƒ«æ™‚ã«ã™ãã«ï¼ˆHTTP Requestã«è¿”äº‹ã‚’ã™ã‚‹å‰ã«ï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¤‰æ›´ã‚’åŠ ãˆã€Readã®éš›ã«ã‚‚ï¼ˆã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã†ãƒ»ä½¿ã‚ãªã„ã‚’åˆ¥ã«ã—ã¦ï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æœ€æ–°ã®çŠ¶æ³ã‚’åæ˜ ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’è¿”ã™ã‚ˆã†ã«è¨è¨ˆã™ã‚‹ã®ãŒæ™®é€šã§ã‚ã‚‹ã€‚ ã“ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®å•é¡Œã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ãŒå¢—ãˆãŸæ™‚ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„I/OãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨
yutasega 2008/09/23
database
ãƒªãƒ³ã‚¯
1