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

yanbow id:yanbow

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

#ronsakucasual DBã®è«–ç†å‰Šé™¤ã«ã¤ã„ã¦ã²ãŸã™ã‚‰å…±æœ‰ã™ã‚‹ è«–ç†å‰Šé™¤ Casual Talks #1 ã«ã„ã£ã¦ããŸã¾ã¨ã‚ - ã‚‚ãã‚ã½ã‚ã
åå‰ ã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚° ç›®çš„ ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦‹ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒãªã„ã“ã¨ã«ã—ãŸã„ã‘ã©ã€å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã¯æ¶ˆã—ãŸããªã„ å‰Šé™¤ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ãŸã„ ãƒ‡ãƒ¼ã‚¿ã‚’æ¶ˆã•ãšã«ãƒã‚°ã«æ®‹ã—ãŸã„ èª¤ã£ãŸæ“ä½œã‚’ãªã‹ã£ãŸã“ã¨ã«ã—ãŸã„ã€ç›´ãã«å…ƒã«æˆ»ã—ãŸã„ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä¾‹ãˆã°is_deletedã¨ã„ã†ã‚«ãƒ©ãƒ ãŒtrueã®å ´åˆã¯å‰Šé™¤ã•ã‚Œã¦ã„ã‚‹ã¨ã¿ãªã™ ãƒ¡ãƒªãƒƒãƒˆ updateæ–‡ãªã‚‰ãƒ‡ãƒ¼ã‚¿ãŒç°¡å˜ã«å…ƒã«æˆ»ã›ã‚‹æ°—ãŒã™ã‚‹ã®ã§ãªã‚“ã¨ãªãå®‰å¿ƒ -> ä¿ºã®updateæ–‡ã§ãªã‚“ã¨ã‹ãªã‚‹ï¼ï¼ èµ·ã“ã‚‹ã“ã¨ SELECTã™ã‚‹ã¨ãã«ã¯å¸¸ã«WHEREå¥ãŒè¿½åŠ ã§å¿…è¦ã«ãªã‚Šã€ã‚³ãƒ¼ãƒ‰ãŒå‰Šé™¤ãƒ•ãƒ©ã‚°ã ã‚‰ã‘ã«ãªã‚‹ å…¨å“¡ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã«ç²¾é€šã—ã¦ã‚‹ã‚ã‘ã§ã¯ãªã„ã®ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚ˆã£ã¦å‰Šé™¤ãƒ•ãƒ©ã‚°ã®æœ‰ç„¡ãŒã‚ã£ãŸã‚Šã—ãŸå ´åˆã€èªè˜ã®é½Ÿé½¬ã‚’ç”Ÿã¿ã‚„ã™ã„ ä¾‹ãˆã°rubyã§default_scopeã‚’ç”¨ã„ã¦ã€ã‚ˆã‹ã‚Œã¨ãŠã‚‚ã£ã¦ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ™ãƒ«ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚’å¤‰ãˆãŸã‚‰ãƒã‚°ãŒãŸãã•ã‚“å‡ºã¦ãã‚‹
yanbow 2015/09/01
ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

DB
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - é–‹ç™ºè€…ã‚’å¾…ã¡å—ã‘ã‚‹25ã®è½ã¨ã—ç©´ (æ‹¡å¤§ç‰ˆ)
14. SELECT c1.*, c2.*, c3.*, c4.* FROM Comments c1 -- 1éšŽå±¤ç›® LEFT OUTER JOIN Comments c2 ON c2.parent_id = c1.comment_id -- 2éšŽå±¤ç›® LEFT OUTER JOIN Comments c3 ON c3.parent_id = c2.comment_id -- 3éšŽå±¤ç›® LEFT OUTER JOIN Comments c4 ON c4.parent_id = c3.comment_id -- 4éšŽå±¤ç›® ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚ˆã‚Šèµ·ã“ã‚‹ã“ã¨ ç´ æœ´ã™ãŽã‚‹æ•…ã« ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
yanbow 2013/04/23
ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

SQL

db
ãƒªãƒ³ã‚¯
ã„ã¾ã™ãä½¿ãˆã‚‹ç„¡æ–™ã®ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒClearDBã€
ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚‚ã—ã¦ãã‚Œã‚‹ã®ã§é‹ç”¨ã®æ‰‹é–“ãŒã‹ã‹ã‚‰ãªã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚ãã‚“ãªã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ã¦ã„ã‚‹æä¾›ã—ã¦ã„ã‚‹ã®ãŒã€ŒclearDBã€ã§ã™ã€‚ 1ã¤å‰ã®è¨˜äº‹ã§ã¯ä¼æ¥å‘ã‘ã®ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã€ŒYammerã€ã‚’ç´¹ä»‹ã—ã€ç«¶åˆã¨ãªã‚Šãã†ãªã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãƒ»ãƒ‰ãƒƒãƒˆã‚³ãƒ ã®Chatterã‚‚ç„¡æ–™ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã™ã‚‹ã¨ç´¹ä»‹ã—ã¾ã—ãŸãŒã€ä»Šå›žã®ClearDBã‚‚ã€ã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãƒ»ãƒ‰ãƒƒãƒˆã‚³ãƒ ãŒç™ºè¡¨ã—ãŸã°ã‹ã‚Šã®ã€ŒDatabase.comã€ã¨åŒæ§˜ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ç‹™ã£ãŸã‚ã‘ã§ã¯ãªã„ã®ã§ã™ãŒâ€¦â€¦ã€‚ clearDBã®Webã‚µã‚¤ãƒˆã‹ã‚‰ã€ã©ã®ã‚ˆã†ãªã‚µãƒ¼ãƒ“ã‚¹ãªã®ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§100ï¼…ACIDå¯¾å¿œã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ clearDBã¯100ï¼…ACIDã«å¯¾å¿œã—ã€è‡ªå‹•çš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚ŒãŸã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ã€ŒWhat is ClearDB?
yanbow 2010/12/16
DB

ã‚¯ãƒ©ã‚¦ãƒ‰
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
ã€5ã€‘è¡¨è¨˜æ–¹æ³•ã«IEã¨IDEF1Xã‚’ã‚µãƒãƒ¼ãƒˆ ERãƒ€ã‚¤ã‚¢ã‚°ãƒ©ãƒ ã®è¡¨è¨˜æ–¹æ³•ã«ãŠã„ã¦ã¯ã€ã€ŒIEï¼ˆInformation Engineeringï¼‰ã€ã€ŒIDEF1Xã€ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã§ã€æ…£ã‚ŒãŸè¡¨è¨˜æ–¹æ³•ã§åˆ©ç”¨ã§ãã¾ã™ã€‚IEè¡¨è¨˜æ³•ã®ä¾‹ã¯ã€æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚æœ¬ç¨¿ã®ã»ã‹ã®å›³ã¯ã€ã™ã¹ã¦IDEF1Xæ³•ã®è¡¨è¨˜ãƒ¢ãƒ¼ãƒ‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚
yanbow 2010/11/15
DB

é–‹ç™º

DBè¨è¨ˆ

ER
ãƒªãƒ³ã‚¯
MongoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’Berkeley DB, H2, MySQLã¨æ¯”è¼ƒ - kaisehã®ãƒ–ãƒã‚°
ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€Mongo DBãŒã¨ã¦ã‚‚é¢ç™½ãã†ã ã£ãŸã®ã§ã€Javaã‹ã‚‰ä½¿ç”¨ã—ãŸå ´åˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚ Mongo DBã¯CouchDBã«ä¼¼ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ä»»æ„ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä¿å˜ã§ãã¾ã™ãŒã€MVCCã‚„REST APIã‚’æŽ¡ç”¨ã—ãªã„ã“ã¨ã§é«˜ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¿½æ±‚ã—ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚µãƒãƒ¼ãƒˆã‚‚å……å®Ÿã—ã¦ã„ã¾ã™ã€‚ RDBMSã‚’Key-Value Storageã¨ã—ã¦ä½¿ã†å ´åˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¨ˆæ¸¬ï¼ˆH2, MySQLç·¨ï¼‰ - kaisehã®ãƒ–ãƒã‚° å‰ã«ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§Berkeley DB, H2, MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ¯”è¼ƒã—ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã™ãŒã€ãã®ã¨ãã¨åŒç‰ã®æ¡ä»¶ã«ãªã‚‹ã‚ˆã†ã«ã—ã¦è¨ˆæ¸¬ã—ã¾ã—ãŸã€‚ å…·ä½“çš„ãªè¨ˆæ¸¬æ–¹æ³•ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Mac OS 10.5.7, 2GHz Intel Core 2 Duo, 4GB Me
yanbow 2010/05/19
MongoDB

DB

performance
ãƒªãƒ³ã‚¯
1