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

tatsu1010 id:tatsu1010

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (7)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

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

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

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
tatsu1010 2010/05/11
database

reference
ãƒªãƒ³ã‚¯
ActiveRecord ã®ãŠå‹‰å¼· - elm200 ã®æ—¥è¨˜(æ—§ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼)
Rails ã‚’å‹‰å¼·ã™ã‚‹ï¼ã¨ã“ã®ãƒ–ãƒã‚°ã‚’ç«‹ã¡ä¸Šã’ã¦ä»¥æ¥ã€æ®‹å¿µãªãŒã‚‰ Rails ã®å‹‰å¼·ã¯ã‚ã¾ã‚Šé€²ã‚“ã§ã„ãªã„ã€‚ãã®å¤§ããªç†ç”±ã¯ã€Rails ã¯ã‹ãªã‚Šå¤§ãã„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã ã‹ã‚‰ã§ã¯ãªã„ã‹ã€‚Javaã§è¨€ã£ãŸã‚‰ Struts + Hybernate + JUnit ã¨ã„ã£ãŸæ„Ÿã˜ã§ã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯æ•°å€‹åˆ†ã«ç›¸å½“ã™ã‚‹ã®ã ã€‚ å€‹äººçš„ãªæ„Ÿæƒ³ã¨ã—ã¦ã¯ã€ä¸ã§ã‚‚ Model éƒ¨åˆ†ã«ç›¸å½“ã™ã‚‹ O/R ãƒžãƒƒãƒ‘ãƒ¼ã® ActiveRecord ãŒã‚ˆãã§ãã¦ã„ã‚‹ã¨æ„Ÿã˜ãŸã€‚ãã“ã§ã€ã‚‹ã³ã¾ã®è¨˜äº‹ãªã©ã‚’å‚è€ƒã« ActiveRecord ã®å¦ç¿’ã«æŒ‘æˆ¦ã€‚ ActiveRecord::Base ã® rdoc ãŒéžå¸¸ã«ã‚ã‹ã‚Šã‚„ã™ã„ã€‚ã“ã‚Œã¯ã€(Ruby ã®ãƒ«ãƒ¼ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªï¼‰/lib/ruby/gems/1.8/doc/activerecord(ãƒãƒ¼ã‚¸ãƒ§ãƒ³)/rdoc/index.htmlã‹ã‚‰æŽ¢ã—ã ã›ã‚‹ã€‚ ActiveRecord::Bas
tatsu1010 2007/11/28
å®¶å¸°ã£ãŸã‚‰å‹‰å¼·ã™ã‚‹

database

rails

ruby
ãƒªãƒ³ã‚¯
ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ - ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã€‚ã©ã‚“ãªSQLæ–‡ã‚’æŠ•ã’ãŸã‚‰ã©ã‚“ãªçµæžœãŒè¿”ã£ã¦ãã‚‹ã‹ã•ãˆçŸ¥ã£ã¦ã„ã‚Œã°ã‚ˆã„ã€---ãã†æ€ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œæœ¬ç‰©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã™ã®ã§ã‚ã‚Œã°ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‹•ãä»•çµ„ã¿ã‚’å¦ã¶ã“ã¨ã¯é¿ã‘ã¦é€šã‚Œã¾ã›ã‚“ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã©ã«å•é¡ŒãŒç”Ÿã˜ãŸã¨ãã©ã“ã‹ã‚‰æ‰‹ã‚’ä»˜ã‘ã¦ã„ã„ã®ã‹çš†ç›®è¦‹å½“ãŒã¤ã‹ãªã„ï¼Œã¨ã„ã£ãŸäº‹æ…‹ã«é™¥ã‚Šã‹ãã¾ã›ã‚“ã€‚ å¸‚è²©ã®RDBMSã®å†…éƒ¨ã¯ã‹ãªã‚Šè¤‡é›‘ã§ã™ãŒï¼ŒåŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’ç†è§£ã™ã‚‹ã®ã¯ãã‚Œã»ã©é›£ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã®ç‰¹é›†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹•ãä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒˆãƒ â—ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ1ï¼‰ ï¼°ï½ï½’ï½”ï¼‘ â—SQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ2ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ3ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰ åŸº
tatsu1010 2007/11/25
ã“ã‚Œã¯ã„ã„å‹‰å¼·ã«ãªã‚Šãã†ã€‚ã¡ã‚ƒã‚“ã¨åŸºç¤ŽæŠ¼ã•ãˆã¦ãŠã‹ãªãã‚ƒã€‚

DB

database

sql

study
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ãŒå¥½ãï¼
Oracle RDBMSã®åŸºæœ¬æ§‹é€ ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ Oracleã®ä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ã¿ã¾ã—ã‚‡ã†ï¼ ( 21p)
tatsu1010 2007/05/19
å¾Œå¦ã®ãŸã‚ã«ä¸€é€šã‚Šèªã‚“ã§ã¿ãŸã„æ‰€å˜ã€‚

database

oracle
ãƒªãƒ³ã‚¯
1