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

NOV1975 id:NOV1975

dbã«é–¢ã™ã‚‹NOV1975ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

ã€Žã‚¢ãƒ¡ãƒ–ãƒã§è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ç´¹ä»‹ã€
ã¯ã˜ã‚ã¾ã—ã¦ã€‚ãƒ–ãƒã‚°ã‚’æ‹…å½“ã—ã¦ã„ã‚‹Nã¨ç”³ã—ã¾ã™ã€‚ ãƒ–ãƒã‚°çµ¡ã¿ã®æŠ€è¡“ãƒã‚¿ã‚’ã¨ä¾é ¼ã‚’ã•ã‚Œã¾ã—ãŸãŒã€ ãƒ–ãƒã‚°ã¯æž¯ã‚ŒãŸæŠ€è¡“ã‚’å¤šãä½¿ã£ã¦ã„ã¦ç›®æ–°ã—ã„ã“ã¨ã¯ã‚ã¾ã‚Šãªã„ã®ã§ã€ ä»¥å‰è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å†…å®¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 2008å¹´ã«ãƒ–ãƒã‚°ã®è¨˜äº‹ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦è¡Œã£ãŸDB+ã‚¢ãƒ—ãƒªã§ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§ã™ã€‚ ãƒ–ãƒã‚°ã®è¨˜äº‹ãƒ‡ãƒ¼ã‚¿ã¯MySQLã®Master-Slaveæ§‹æˆã§ä¿æŒã—ã¦ã„ã¦ã€ Slaveã‚µãƒ¼ãƒãƒ¼ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã—ã¦ãƒ–ãƒã‚°ã®é–²è¦§ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã—ã¦ã„ã¾ã™ã€‚ Slaveã®MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯4.1ã§Engineã¯MyISAMã§ã™ã€‚ è¨˜äº‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã—ã¦ã„ã¾ã™ã€‚ è¨˜äº‹ID,ãƒ–ãƒã‚°ID,è¨˜äº‹ã‚¿ã‚¤ãƒˆãƒ«,æ—¥ä»˜,ãƒ†ãƒ¼ãƒž,å…¬é–‹åŒºåˆ†,ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹,ï½¥ï½¥ï½¥ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å‰ã®è¨˜äº‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªINDEXã‚’å¼µã£ã¦ã„ã¾ã—ãŸã€‚Key_name Seq_in_index Collat
NOV1975 2011/07/07
ãªã‚‹ã»ã©ã€ã“ã‚Œçµæ§‹æ±Žç”¨çš„ã«ä½¿ãˆã‚‹ã„ã„ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‹ã‚‚

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

db
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸé«˜é€ŸåŒ–ã«ã¤ã„ã¦(ORDERD BYã«ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ä¾‹) - LukeSilviaâ€™s diary
ä»Šå›žã¯ã€MySQLã®é«˜é€ŸåŒ–ã®ãƒ¡ãƒ¢ - @luke_silvia.diaryã®æ–¹æ³•ã«å¾“ã£ã¦ã‚¯ã‚¨ãƒªã®é«˜é€ŸåŒ–ã‚’ã—ãŸéš›ã«ã€MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ãŸã“ã¨ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é«˜é€ŸåŒ–å¯¾è±¡ã®ã‚¯ã‚¨ãƒª ä»Šå›žé«˜é€ŸåŒ–ã—ãŸã„ã‚¯ã‚¨ãƒªã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã€‚ SELECT users.*, students.school, workers.school FROM users LEFT JOIN students ON users.id = students.user_id LEFT JOIN workers ON users.id = workers.user_id WHERE (users.status= 1 AND ((kind = 0 AND students.school = 'test') OR (kind = 1 AND workers.school = 'test'))) ORDER BY
NOV1975 2008/05/20
ORDER BYãŒä½¿ã„ç‰©ã«ãªã‚‰ãªã„ã¨ç”¨é€”ã«ã‚ˆã£ã¦ã¯ã•ã£ã±ã‚Šã ãªã‚ã€‚

db
ãƒªãƒ³ã‚¯
VMwareã®3å€ã®æ€§èƒ½ã§ç„¡å„Ÿã€ã€ŒOracle VMã€ã¯æœ¬ç‰©ã‹ â€• ï¼ IT
VMwareã®3å€ã®æ€§èƒ½ã§ç„¡å„Ÿã€ã€ŒOracle VMã€ã¯æœ¬ç‰©ã‹ï¼šã‚ªãƒ©ã‚¯ãƒ«ãŒå…¨ã‚¹ã‚¿ãƒƒã‚¯ã‚’ã‚µãƒãƒ¼ãƒˆå¯èƒ½ã« æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¯3æœˆ13æ—¥ã€ã‚µãƒ¼ãƒä»®æƒ³åŒ–è£½å“ã€ŒOracle VMã€ã®æä¾›ã‚’é–‹å§‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ä¸Šã§ç›´æŽ¥ç¨¼åƒã™ã‚‹ãƒã‚¤ãƒ‘ãƒ¼ãƒã‚¤ã‚¶ãƒ¼åž‹ã®ä»®æƒ³åŒ–è£½å“ã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®Xenãƒã‚¤ãƒ‘ãƒ¼ãƒã‚¤ã‚¶ãƒ¼ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦ã„ã‚‹ã€‚Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ã€‚ã‚ªãƒ©ã‚¯ãƒ«ã¯Linux OSã‹ã‚‰ä»®æƒ³åŒ–è£½å“ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨å…¨ã‚¹ã‚¿ãƒƒã‚¯ã§è£½å“ã‚’æŒã¤ã“ã¨ãªã‚Šã€ãƒ¯ãƒ³ã‚¹ãƒˆãƒƒãƒ—ã®ã‚µãƒãƒ¼ãƒˆãŒæä¾›ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã—ã¦ã„ã‚‹ã€‚ Oracle VMã¯æ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã‚’ç¨¼åƒã•ã›ã‚‹ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚·ã‚¹ãƒ†ãƒ ç”¨ã®ä»®æƒ³åŒ–è£½å“ã€‚Red Hat Enterprise Linuxã¨Windows 2000ã€Windows Server 2003ã€Windows XPã€Red Hatã‚¯ãƒãƒ¼ãƒ³ã®
NOV1975 2008/03/18
ä»®æƒ³ã¨ã¯ã„ãˆãƒãƒ¼ãƒ‰ã‚’æä¾›ã™ã‚‹ã“ã¨ã«ãªã‚‹ã¨ã‚µãƒãƒ¼ãƒˆã®æœ‰ç„¡ã®æ‰ãˆæ–¹æ¬¡ç¬¬ã§ã¯ç‹¬ç¦æ³•ã«è§¦ã‚ŒãŸã‚Šã—ãªã„ã®ã‹ãªã€‚Oracleã®ã‚·ã‚§ã‚¢ã‚’è€ƒãˆã‚‹ã¨ã€‚

oracle

db
ãƒªãƒ³ã‚¯
PostgreSQLã§åŠ¹çŽ‡çš„ãªè² è·åˆ†æ•£ã‚’å®Ÿç¾ã—ã€ãƒ¢ãƒã‚²ãƒ¼ã‚„mixiã‚’è¿½æ’ƒ â€• TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®PostgreSQLã§ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ 10ä»£ã€20ä»£ã‚’ä¸å¿ƒã«æ€¥æ¿€ãªæ™®åŠã‚’è¦‹ã›ã‚‹â€œã‚±ãƒ¼ã‚¿ã‚¤SNSâ€ã€‚ä¼šå“¡æ•°ãŒ865ä¸‡äººã«é”ã™ã‚‹ã€Œãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã€ã‚„æœˆé–“118å„„ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼ˆPVï¼‰ã‚’èª‡ã‚‹ã€Œmixiã€ï¼ˆç´„6å‰²ãŒãƒ¢ãƒã‚¤ãƒ«çµŒç”±ï¼‰ãªã©ã€å¤§æ‰‹SNSã‚µã‚¤ãƒˆãŒå˜åœ¨æ„Ÿã‚’å¢—ã—ã¦ã„ã‚‹ï¼ˆæ•°å€¤ã¯ã„ãšã‚Œã‚‚2007å¹´12æœˆç¾åœ¨ï¼‰ã€‚ãã†ã—ãŸä¸ã§å…ˆè¡Œçµ„ã‚’æ¿€ã—ãè¿½æ’ƒã—ã¦ã„ã‚‹ã®ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ãƒ‰ã‚¢ãŒé‹å–¶ã™ã‚‹æºå¸¯é›»è©±å‘ã‘ã®SNSã‚µã‚¤ãƒˆã€Œå¤§é›†åˆNEOã€ã ã€‚ 2007å¹´1æœˆã«ã‚¹ã‚¿ãƒ¼ãƒˆã—ãŸå¤§é›†åˆNEOã¯ã€SNSã®ã¿ãªã‚‰ãšã€ã‚¢ãƒã‚¿ãƒ¼ã‚„ã‚²ãƒ¼ãƒ ã€å°èª¬ã€å‹•ç”»ã€æ—¥è¨˜ã€ãƒãƒ£ãƒƒãƒˆãªã©ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã™ã¹ã¦ç„¡æ–™ã§æ¥½ã—ã‚ã‚‹ã®ãŒç‰¹å¾´ã ã€‚ã‚¢ãƒã‚¿ãƒ¼ã‚„ã‚µã‚¤ãƒˆå†…é€šè²¨ã®ä½¿ã„å‹æ‰‹ã®è‰¯ã•ã§å…ˆè¡Œã‚µã‚¤ãƒˆã¨å·®åˆ¥åŒ–ã‚’å›³ã‚Šã€2007å¹´å¤ã«50ä¸‡äººã ã£ãŸä¼šå“¡æ•°ãŒ2008å¹´2æœˆæ™‚ç‚¹ã§2å€ã®100ä¸‡äººã«é”ã—ã¦ã„ã‚‹ã€‚ ãã®å¤§é›†åˆNEOã®ã‚·ã‚¹ãƒ†ãƒ åŸºç›¤ã‚’æ‹…ã£ã¦ã„ã‚‹ã®ã¯ã€MySQLã¨ã‚ª
NOV1975 2008/03/03
åˆã‚ã¦èžã„ãŸã‚ˆã“ã®SNSï¼å˜ãªã‚‹äº‹ä¾‹ç´¹ä»‹ã ãªã‚³ãƒ¬ã¯ã€‚

db
ãƒªãƒ³ã‚¯
CodeZineï¼šHAVINGå¥ã®åŠ›ï¼ˆHAVINGï¼ˆé›†è¨ˆï¼‰, HAVINGå¥, é–¢ä¿‚é™¤ç®—, HAVING, SQLï¼‰
ã¯ã˜ã‚ã«ã€€SQLã¨ã„ã†ã®ã¯å¤‰ã‚ã£ãŸè¨€èªžã§ã™ã€‚ã“ã†ã„ã†å°è±¡ã¯äººã«ã‚ˆã£ã¦å·®ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ãŠãã‚‰ãæœ€åˆã«æ‰‹ç¶šãåž‹è¨€èªžã‚’å¦ã‚“ã æ£çµ±æ´¾ã®ãƒ—ãƒã‚°ãƒ©ãƒžã‚„SEã»ã©å¼·ããã†æ„Ÿã˜ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã€€SQLã«é•å’Œæ„Ÿã‚’æ„Ÿã˜ã‚‹ç†ç”±ã¯ã€ã„ãã¤ã‹è€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ç¬¬ä¸€ã«ã€SQLãŒã€Œé›†åˆæŒ‡å‘ã€ã¨ã„ã†ç™ºæƒ³ã«åŸºã¥ã„ã¦è¨è¨ˆã•ã‚ŒãŸè¨€èªžã§ã€ã“ã®è¨è¨ˆæ–¹é‡ã‚’æŒã¤è¨€èªžãŒå°‘ãªã„ã“ã¨ã§ã™ã€‚ãã—ã¦ç¬¬äºŒã«ã€ãã‚Œã«åŠ£ã‚‰ãšå¤§ãã„ã®ãŒã€æœ€åˆã«å¦ã‚“ã è¨€èªžã®ã‚¹ã‚ãƒ¼ãƒžï¼ˆæ¦‚å¿µã®æž çµ„ã¿ï¼‰ãŒå¿ƒç†çš„ãƒ¢ãƒ‡ãƒ«ã¨ã—ã¦å›ºå®šã•ã‚Œã€ãã‚Œã‚’é€šã—ã¦ä¸–ç•Œã‚’è¦‹ã‚‹ã‚ˆã†ã«ãªã‚‹ãŸã‚ã€ç•°ãªã‚‹ã‚¹ã‚ãƒ¼ãƒžã‚’æŒã¤è¨€èªžã®ç†è§£ãŒå¦¨ã’ã‚‰ã‚Œã‚‹ã“ã¨ã§ã™ã€‚ã€€æœ¬ç¨¿ã§ã¯ã€HAVINGå¥ã®ã•ã¾ã–ã¾ãªå¿œç”¨æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ãŒã€ãã®éš›ã€æ‰‹ç¶šãåž‹è¨€èªžã¨SQLã®è€ƒãˆæ–¹ã‚’æ¯”è¼ƒã—ã¾ã™ã€‚ãã‚Œã«ã‚ˆã£ã¦ã€ç§ãŸã¡ãŒæ‰‹ç¶šãåž‹è¨€èªžã§èº«ã«ä»˜ã‘ãŸç„¡æ„è˜ã®å¿ƒç†çš„ãƒ¢ãƒ‡ãƒ«ã‚’è‡ªè¦šã—ã€é›†åˆæŒ‡å‘ã¨ã„ã†ç™ºæƒ³ã«æ„Ÿã˜ã‚‹é•å’Œæ„Ÿã‚’è»½æ¸›ã—ãŸã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ã€€ä»Šå›žã¯
NOV1975 2007/07/12
ç ”ä¿®ã«ä½¿ãˆã‚‹ã‹ãªï¼Ÿã¨æ€ã£ã¦ãƒ–ã‚¯ãƒžã€‚ä¸èº«ã¯èªã‚“ã§ãªã„

ã‚ã¨ã§èªã‚€

db

sql
ãƒªãƒ³ã‚¯
Martin Fowler's Bliki in Japanese - ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒ¬ã‚¹
http://martinfowler.com/bliki/Transactionless.html 2007/3/18 (æ›´æ–°ï¼šBill Caputoã‹ã‚‰ã‚‚çµŒé¨“è«‡ã‚’ã„ãŸã ã„ãŸ) æ•°å¹´å‰ã«eBayã§åƒãå‹äººãŸã¡ã¨è©±ã—ã¦ã„ãŸã¨ãã®ã“ã¨ã ã€‚ å¤§è¦æ¨¡ã‚µã‚¤ãƒˆã§ä½¿ã‚ã‚Œã‚‹æŠ€è¡“ã®è©±ã‚’èžãã®ã¯ã„ã¤ã‚‚æ¥½ã—ã„ãŒã€ç‰¹ã«èˆˆå‘³æ·±ã‹ã£ãŸã®ãŒã€eBayã§ã¯æ»…å¤šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ãªã„ã¨ã„ã†è©±ã ã£ãŸã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒãªã„ç’°å¢ƒã¨ã„ã†ã®ã¯é©šãã¹ãã“ã¨ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ã¨ãã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ã†ã®ã¯ã”ãã”ãä¸€èˆ¬çš„ãªã“ã¨ã ã€‚ å¤šãã®äººã«ã¨ã£ã¦ï¼ˆç§ã‚‚ãã†ã ãŒï¼‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†åˆ©ç‚¹ã®ã²ã¨ã¤ã ã€‚ eBayãŒãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ã‚ãªã„ã®ã¯ã€ã‚ã®ã‚ˆã†ãªè¦æ¨¡ã§ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å½±éŸ¿ãŒå‡ºã¦ã—ã¾ã†ã‹ã‚‰ã ã¨ã„ã†ã‚‚ã®ã ã£ãŸã€‚ eBayã§ã¯ãƒ‡ãƒ¼ã‚¿ã‚’ã„ãã¤ã‚‚ã®ç‰©ç†çš„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‘ãƒ¼ãƒ†ã‚·ãƒ§
NOV1975 2007/03/23
ã“ã€ã“ã‚Œã¯å¤§äº‹ãªè©±ã ã€‚ã©ã†ã‚„ã£ã¦å®Ÿç¾ã—ã¦ã„ã‚‹ã‹å…·ä½“çš„ãªæ–¹æ³•ãŒçŸ¥ã‚ŠãŸã„ãªã€‚

db

å‚™å¿˜
ãƒªãƒ³ã‚¯
ã€ç‰¹é›†ã€‘MySQLã®æ–°ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ Falconå¾¹åº•ãƒªã‚µãƒ¼ãƒ (1) Falconã¨ã¯ (MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ«)
2007å¹´1æœˆã«ã€MySQL ABã¯æ–°ã—ã„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³â€»ã§ã‚ã‚‹ã€ŒFalconã€ã®ã‚¢ãƒ«ãƒ•ã‚¡ç‰ˆã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚Falconã¯ã€ç¾åœ¨åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒInnoDBã€ã«ä»£ã‚ã‚‹é¸æŠžè‚¢ã®ã²ã¨ã¤ã¨ã—ã¦æœŸå¾…ã•ã‚Œã¦ã„ã‚‹ã€‚æœ¬ç¨¿ã¯ã€ã“ã®Falconã®æŠ€è¡“çš„ãªç‰¹å¾´ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã€‚ â€»ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç¨®é¡žã®ã“ã¨ã€‚MySQLã§ã¯ã€InnoDBã‚„MyISAMãªã©ã€ã•ã¾ã–ã¾ãªç¨®é¡žã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã§ã©ã‚Œã‚’ä½¿ã†ã‹é¸æŠžã§ãã‚‹ã€‚ Falconã®æ¦‚è¦ - InnoDBã¨æ¯”è¼ƒã™ã‚‹ Falconã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(RDBMS)ç•Œã®æ¨©å¨ã§ã‚ã‚‹Jim Starkeyæ°ã¨ã€å½¼ã®å¦»ã§ã‚ã‚‹Ann Harrisonæ°ã‚’ä¸å¿ƒã«é–‹ç™ºãŒé€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚Jim Starkeyæ°ã¯Interbaseã®ç”Ÿã¿ã®è¦ªã§ã‚ã‚Šã€ã¾ãŸAnn Harrisonæ°ã¨ã¨ã‚‚ã«Firebirdã®ãƒ¡ã‚¤ãƒ³ã‚³ãƒŸãƒƒã‚¿ã¨ã—ã¦ã‚‚æ´»èºã—ã¦ã„ã‚‹ã€‚å½¼ã‚‰
NOV1975 2007/03/04
èªã¿ã¥ã‚‰ã„ã€‚ã“ã‚Œã ã‘æ›¸ããªã‚‰InnoDBã¨ã®ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•éƒ¨åˆ†ã¨ã‹ã‚’è¡¨ã«ã—ã¦ã¾ã¨ã‚ã¦ãã‚Œã‚Œã°ã‚ˆã„ã®ã«ã€‚

db
ãƒªãƒ³ã‚¯
Infoseek[ã‚¤ãƒ³ãƒ•ã‚©ã‚·ãƒ¼ã‚¯] - æ¥½å¤©ãŒé‹å–¶ã™ã‚‹ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ
äººæ°—å†ç‡ƒï¼ãƒã‚±ãƒ¢ãƒ³ GOã‚’ã‚ˆã‚Šæ¥½ã—ã‚€ã‚¦ã‚§ã‚¢ãƒ©ãƒ–ãƒ«ãƒ‡ãƒã‚¤ã‚¹4é¸ è¡—ä¸ã§ã€Žãƒã‚±ãƒ¢ãƒ³ GOã€ã‚’éŠã¶ã«ã—ã¦ã‚‚ã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚’å‡ºã—ãŸã‚Šã—ã¾ã£ãŸã‚Šã—ãªãŒã‚‰æ©ãã®ã¯ãªã‹ãªã‹é›£ã—â€¦
NOV1975 2007/01/28
ã‚ã¨ã§èªã‚€

db

sql

æƒ…å ±
ãƒªãƒ³ã‚¯
å¾…æœ›ã®Java SE 6 ã§ãƒ‘ãƒ¼ã‚·ã‚¹ãƒ†ãƒ³ã‚¹ - ï¼ IT
æ•™è‚²ç•Œã€æŠ€è¡“è€…ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã§Javaè¨€èªžã®æ•™è‚²ã¨å•“è’™ã«é•·å¹´æºã‚ã£ã¦ããŸç†è€…ãŒã€ç‹¬è‡ªã®è¦–ç‚¹ã‹ã‚‰Javaã®é¢ç™½ã•ã‚’æŽ˜ã‚Šä¸‹ã’ã¦ã„ãã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ Java2 SE 1.4ã¨Java SE 5ã®é–“ã«ã¯ã€æ©Ÿèƒ½å·®ãŒã‚ã‚ŠéŽãŽãŸãŸã‚ã€ç¾å ´ã§å°Žå…¥ãŒã§ããšã«ã€ã“ã‚Œã¾ã§ç§»è¡Œã‚’è¦‹é€ã£ã¦ããŸèªè€…ã‚‚å¤šã„ã“ã¨ã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ã€ä»Šå›žã®Java SE 6ï¼ˆé–‹ç™ºã‚³ãƒ¼ãƒ‰åï¼šMustangï¼‰ã®ç™»å ´ã§ã€ãã‚ãã‚ Java2 SE 1.4 ã‹ã‚‰ Java SE 5 ã‚‚ã—ãã¯ 6 ã¸ç§»è¡Œã—ã¦ã‚‚ã„ã„æ™‚æœŸã«ãªã‚Šã¾ã—ãŸã€‚Java SE 5 ãŒç™»å ´ã—ãŸã¨ãã»ã©ã®æ©Ÿèƒ½è¿½åŠ ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€Java SE 6 ã«ã‚‚æ³¨ç›®ã®æ©Ÿèƒ½ãŒã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€æ³¨ç›®åº¦ãŒé«˜ã„ãƒ‘ãƒ¼ã‚·ã‚¹ãƒ†ãƒ³ã‚¹ï¼ˆæ°¸ç¶šåŒ–ï¼‰ã«é–¢ä¿‚ã™ã‚‹ã‚‚ã®ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ãŸã ã—ã€æœ¬ç¨¿åŸ·ç†æ™‚ç‚¹ï¼ˆ2006å¹´12æœˆ5æ—¥ï¼‰ã§ã¯Java SE 6ã¯RCï¼ˆRelease Candidateï¼‰ç‰ˆã§ã™ã®ã§ã€ãƒªãƒª
NOV1975 2006/12/18
ãµã¸ãƒ¼ã€‚ç°¡å˜ãªç”¨é€”ã«ãªã‚‰å®Ÿç”¨ã«è€ãˆã‚‹ã‚‚ã®ã§ã‚ã‚Œã°ã€å€‹äººã‚„ç ”ä¿®ã§ä½¿ã†ã«ã¯å……åˆ†ã‹ã‚‚ãã€‚

db

java
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
NOV1975 2006/11/27
ã‚„ã£ã¨ãã¹ãæ¨™æº–ã¿ãŸã„ãªæ„Ÿã˜ã‹ã€‚ã“ã†ã„ã†ã¾ã¨ã‚ã¯ä¾¿åˆ©ã ã€‚

æŠ€è¡“

db
ãƒªãƒ³ã‚¯
Web2.0ãƒŠãƒ“: SQL-DESIGNERãŒã‚¹ã‚´ã‚¤
ã„ã„ãï¼ 0 ãƒ„ã‚¤ãƒ¼ãƒˆ B! ã¯ã¦ãƒ– 447 Pocket 2 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆæ™‚ã«ERå›³ã‚’ã‹ãã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€SQL-designerã¨ã„ã†ã‚¦ã‚§ãƒ–ãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ãŒéžå¸¸ã«ä½¿ã„ã‚„ã™ã„ãã€ãƒ‡ã‚¶ã‚¤ãƒ³çš„ã«ã‚‚ç¶ºéº—ã§ä¾¿åˆ©ã€‚ MSprojectç‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’è¡Œã†å°‚ç”¨ã‚½ãƒ•ãƒˆã¯éžå¸¸ã«å¤šãã‚ã‚‹ãŒã€ã©ã‚Œã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¿…è¦ã ã£ãŸã‚Šã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ãŒå¿…è¦ã ã£ãŸã‚Šã€ã‚½ãƒ•ãƒˆãŒé‡ã‹ã£ãŸã‚Šã€ç’°å¢ƒä¾å˜ãŒæ¿€ã—ã‹ã£ãŸã‚Šã—ã¦ã€ä½¿ã„ã«ãã„ã€‚ ä½¿ã„ã‹ãŸã¯ç°¡å˜ã§ã€ ï¼‘ï¼Žã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«ã„ã£ã¦ ï¼’ï¼Žãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’è¿½åŠ ã™ã‚‹ ï¼“ï¼Žãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆorXMLã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ã ã‘ã€‚ ãƒ‡ãƒ¼ã‚¿ã®åž‹ãªã©ã‚‚é¸æŠžã§ãã¦ã€è¨è¨ˆãŒçµ‚ã‚ã£ãŸã‚‰ã€SQLæ–‡ã‚’ãã®ã¾ã¾ç™ºè¡Œã—ãŸã‚Šã€ä½œã£ãŸEQå›³ã‚’XMLã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã‚„ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚Javascriptãƒ™ãƒ¼ã‚¹ãªã®ã§ã€ã‚ã‚“ã©ãã•ã„ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚„ç’°å¢ƒä¾å˜ã‚‚ãªã—ã€‚ ã‚¦ã‚§ãƒ–ä¸Šã§ã‚„ã‚‹ã®ã¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
NOV1975 2006/10/29
ã“ã‚Œã¯ã„ã„ã‹ã‚‚ã€‚

db
ãƒªãƒ³ã‚¯
XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ç¬¬2æ¬¡é»„é‡‘æœŸã®äºˆæ„Ÿï¼ˆ1/2ï¼‰ â€• ï¼ IT
Database Watch 10æœˆç‰ˆã€€Page 1/2 XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ç¬¬2æ¬¡é»„é‡‘æœŸã®äºˆæ„Ÿ åŠ å±±æµç¾Ž 2006/10/14 ã“ã‚Œã¾ã§ã‚‚XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯è©±é¡Œã«ã—ã¦ãã¾ã—ãŸãŒã€2006å¹´ã¯XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢ä¿‚ã®è©±é¡Œã‚’ã‚ˆãè€³ã«ã—ã¾ã™ã€‚ä»Šå¾Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã®ã‚ˆã†ãªXMLæ©Ÿèƒ½ã‚’æŒã¤ã‹ãŒéµã«ãªã£ã¦ããã†ã§ã™ã€‚ â– 2006å¹´ã¯W3Cã§XMLã®åŸºæœ¬ä»•æ§˜ã«å‹•ããŒ XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è©±ã®å‰ã«ã€2006å¹´ã®W3Cã®XMLå‹•å‘ã‚’å°‘ã—æŒ¯ã‚Šè¿”ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚2006å¹´ã¯åŸºæœ¬çš„ãªæŠ€è¡“ä»•æ§˜ã«å‹•ããŒã‚ã‚Šã¾ã—ãŸã€‚8æœˆã«ã¯XMLã®æ ¹å¹¹ã¨ãªã‚‹XML 1.0 ç¬¬4ç‰ˆã‚„åå‰ç©ºé–“ 1.0 ç¬¬2ç‰ˆãŒå‹§å‘Šã«ãªã‚Šã¾ã—ãŸã€‚ã“ã‚Œã‚‰ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ãªãã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã®æ›´æ–°ãªã®ã§ç´°ã‹ãªä¿®æ£ã‚„æ”¹è‰¯ã«ã™ãŽã¾ã›ã‚“ãŒã€å®Œæˆåº¦ã‚’é«˜ã‚ã‚‹ãŸã‚ã®åŠªåŠ›ãŒç¶™ç¶šã•ã‚Œã¦ã„ã‚‹ã“ã¨ã¯è¨˜æ†¶ã«ã¨ã©ã‚ã¦ãŠããŸã„ã¨ã“ã‚ã§ã™ã€‚ ä¸€æ–¹ã€ä¸»è¦ãªä»•æ§˜ã§æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒè¿‘ã¥ã„ã¦ã„ã‚‹ã‚‚
NOV1975 2006/10/15
è¦æ ¼~1.1ã€ï½ž1.1ã€ï½ž2.0ã¨ã‹ãªã£ã¦ã„ã‚‹ã®ã¯è©±ãŒæ‹¡æ•£ã—ã¦ã‚ˆããªã„ã€‚Xã£ã¦ä½•ã§ã‚‚å‡ºæ¥ã‚‹ã‘ã©ä½•ã«ã‚‚å‡ºæ¥ãªã„ã®ç½ ã«é™¥ã‚‰ãªã„ã‚ˆã†é¡˜ã†ã€‚

xml

db
ãƒªãƒ³ã‚¯
1