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

relax4u id:relax4u

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

çª“ã®æœ - ã€REVIEWã€‘SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆã«å„ªã‚ŒãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€ŒA5:SQL Mk-2ã€
ã€ŒA5:SQL Mk-2ã€ã¯ã€SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆãªã©ã®æ©Ÿèƒ½ã‚’å‚™ãˆãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€‚Windows 98/2000/XP/Server 2003/Vista/Server 2008/Vista x64ã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ æœ¬ã‚½ãƒ•ãƒˆã¯ã€SQLæ–‡ã®ä½œæˆãƒ»å®Ÿè¡Œã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚ADOã‚„ODBCãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã‚’åˆ©ç”¨ã—ã¦å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ã§ã€æœ¬ã‚½ãƒ•ãƒˆã§ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿè¡Œã—ã€ãã®çµæžœã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ã¾ãŸã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€å®Ÿè¡Œçµæžœã‚’ã€ŒExcelã€ã¸å‡ºåŠ›ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ ç”»é¢ã¯ã‚µã‚¤ãƒ‰ãƒãƒ¼ã¨ç·¨é›†ç”»é¢ã®2ã¤ã«åˆ†å‰²ã•ã‚Œã¦ãŠã‚Šã€ã‚µã‚¤ãƒ‰ãƒãƒ¼ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŠã‚ˆã³é–¢é€£ã™ã‚‹ã‚¹ã‚ãƒ¼ãƒžãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ãƒ“ãƒ¥ãƒ¼ã¨ã„ã£ãŸé …ç›®ãŒãƒ„ãƒªãƒ¼å½¢å¼ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ç·¨é›†ç”»é¢ã¯ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆå¼ã«ãªã£ã¦ãŠã‚Šã€SQLæ–‡ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ãªã©ã‚’è¤‡æ•°é–‹ã„ã¦
relax4u 2008/12/03
tool

free

windows

database
ãƒªãƒ³ã‚¯
MOONGIFT: Â» ãŸã£ãŸ1ãƒ•ã‚¡ã‚¤ãƒ«ã®MySQLãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã€ŒphpMinAdminã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
MySQLã‚’ä½¿ã£ãŸé–‹ç™ºã«ãŠã„ã¦ã€ãã®ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã‚ˆãä½¿ã‚ã‚Œã‚‹ã®ãŒphpMyAdminã ã€‚ã¨ã¦ã‚‚ä¾¿åˆ©ã§ä½¿ã„ã‚„ã™ã„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã¯ã‚ã‚‹ãŒã€é•·ã„é–‹ç™ºã®æ´å²ã®ä¸ã§è‚¥å¤§åŒ–ã—ã€æ§˜ã€…ãªãƒ‹ãƒ¼ã‚ºã«å¯¾å¿œã—ã€ãã®ãƒ•ã‚¡ã‚¤ãƒ«æ•°ã‚‚æ•°å¤šããªã£ã¦ãã¦ã„ã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã®è¡¨ç¤º ä¾¿åˆ©ã«ãªã‚‹ã“ã¨ã¯æ‚ªã„ã“ã¨ã§ã¯ãªã„ãŒã€ã‚ã¾ã‚Šè‚¥å¤§åŒ–ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯è¨ç½®ã®æ‰‹é–“ã‚„ã€å•é¡ŒãŒç™ºç”Ÿã—ãŸæ™‚ã®è§£æ±ºæ‰‹æ®µãŒåˆ†ã‹ã‚‰ãªã‹ã£ãŸã‚Šã¨å•é¡Œã‚‚å‡ºã¦ãã¦ã—ã¾ã†ã€‚ãã“ã§ä¸€æ°—ã«ã‚¹ãƒªãƒ ãªã“ã‚Œã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯phpMinAdminã€1ãƒ•ã‚¡ã‚¤ãƒ«ã®MySQL ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ phpMinAdminã¯PHPè£½ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€ãŸã£ãŸ1ãƒ•ã‚¡ã‚¤ãƒ«ã—ã‹é…å¸ƒã•ã‚Œã¦ã„ãªã„ã€‚ã“ã‚Œã‚’è¨ç½®ã™ã‚‹ã ã‘ã§MySQLã®ç®¡ç†ãŒè¡Œãˆã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ãƒ¦ãƒ¼ã‚¶ã®æ¨©é™è¨å®šã‚„ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é¸æŠžã‹ã‚‰ã¯ã˜ã¾ã‚Šã€ä¸€é€šã‚Šã®æ“ä½œãŒã§ãã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ä¸€è¦§è¡¨ç¤º ãƒ†ãƒ¼ãƒ–
relax4u 2008/07/28
tool

free

web

database

mysql

php
ãƒªãƒ³ã‚¯
ãã‚‚ãã‚‚ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ä½•ã‹ï¼Ÿ
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨ã¯ä½•ã‹ï¼Ÿ ä¼æ¥ã«ã¯ã€é¡§å®¢ã«é–¢ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚„å•†å“ã®åœ¨åº«æ•°ãªã©ã€ä¼æ¥æ´»å‹•ã§ç”Ÿã˜ãŸã€Œã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ã€ãŒå˜åœ¨ã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã‚’å…±æœ‰åˆ©ç”¨ã™ã‚‹ãŸã‚ã«1ã¤ã«ã¾ã¨ã‚ãŸãƒ‡ãƒ¼ã‚¿ã®é›†åˆä½“ãŒã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã§ã™ã€‚ ã©ã“ã®ä¼šç¤¾ã§ã‚‚è¡Œã£ã¦ã„ã‚‹ã€Œå£²ä¸Šç®¡ç†ã€ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è€ƒãˆã¦ã¿ã¾ã—ã‚‡ã†ã€‚ä¼šç¤¾ã®è¦æ¨¡ãŒå°ã•ã„ã†ã¡ã¯ã€ã€Œè¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€ç°¡å˜ã«ç®¡ç†ã§ãã‚‹ã€ã¨æ€ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã—ã‹ã—ã€å£²ã‚Šä¸Šã’ãŒä¼¸ã³ã€å–å¼•å…ˆãŒå¢—ãˆã€å¾“æ¥å“¡æ•°ã‚‚å¢—ãˆã¦ã„ãã«å¾“ã£ã¦ã€ã“ã‚Œã ã‘ã§ã¯å•é¡ŒãŒç™ºç”Ÿã™ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ä¾‹ãˆã°ã€è¤‡æ•°ã®å¾“æ¥å“¡ãŒåŒã˜ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã‚’ã€ãã‚Œãžã‚Œç‹¬è‡ªã®ã‚„ã‚Šæ–¹ã§ä½œæˆï¼ä¿æŒã—ã¦ã„ã‚‹ã¨ã€ã€Œã©ã‚ŒãŒæœ€æ–°ã®ãƒ‡ãƒ¼ã‚¿ã‹åˆ†ã‹ã‚‰ãªã„ã€ã€Œã©ã‚ŒãŒæ£ã—ã„ãƒ‡ãƒ¼ã‚¿ãªã®ã‹åˆ†ã‹ã‚‰ãªã„ã€ã€Œã‚ã‚‹æœˆã®ç‰¹å®šã®æ—¥ã®å£²ã‚Šä¸Šã’ãƒ‡ãƒ¼ã‚¿ã ã‘ãŒçŸ¥ã‚ŠãŸã‹ã£ãŸã®ã«ã€æŽ¢ã™ã®ã«æ™‚é–“ãŒã‹ã‹ã‚‹ã€ã€ã¨ã„ã£ãŸã‚ˆã†ã«ã€ãƒ‡ãƒ¼ã‚¿ç®¡ç†ãŒå¾ã€…ã«é›£ã—ããªã‚Šã€å¿…è¦ã‹ã¤æ£ç¢ºãªãƒ‡ãƒ¼ã‚¿ã‚’ã™ãã«
relax4u 2008/07/19
lecture

database
ãƒªãƒ³ã‚¯
MOONGIFT: Â» Firefoxä¸Šã§å‹•ä½œã™ã‚‹SQLiteãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã€ŒSQLite Managerã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Ruby on Railsã§é–‹ç™ºã‚’è¡Œã†éš›ã«ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æŽ¡ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒSQLiteã«ãªã£ã¦ã„ã‚‹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸è¦ã§ä½¿ãˆã‚‹ã¨ã‚ã£ã¦ã€æœ€è¿‘ã§ã¯Pythonãªã©ã§ã‚‚åˆ©ç”¨ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“PHPã€Javaã€Perlãªã©ã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ ãƒ¡ã‚¤ãƒ³ç”»é¢ Ruby on Railsã®é–‹ç™ºã‚’è¡Œã†ã¨ã„ã†ã“ã¨ã¯ã€é€šå¸¸ã¯ãƒ–ãƒ©ã‚¦ã‚¶ãƒ™ãƒ¼ã‚¹ã®ã‚·ã‚¹ãƒ†ãƒ ã«ãªã‚‹ã€‚ãã—ã¦SQLiteã§é–‹ç™ºã¨ãªã‚Œã°ã€ã“ã®é¸æŠžã‚‚ã‚ã‚‹æ„å‘³æ£ã—ã„ã®ã‹ã‚‚ã—ã‚Œãªã„ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SQLite Managerã€Firefoxã‚¢ãƒ‰ã‚ªãƒ³ã¨ã—ã¦å‹•ä½œã™ã‚‹SQLite ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ SQLite Managerã¯Firefoxã‚„Thunderbirdã€Seamonkeyã€ã¯ãŸã¾ãŸSongbirdã‚„Komodo IDEã§ã‚‚å‹•ä½œã™ã‚‹SQLiteç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã ã€‚ã•ã‚‰ã«XULRunnerã‚’ä½¿ã£ã¦ä¸€ã¤ã®ã‚¢
relax4u 2008/07/18
firefox

addon

database

sqlite
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹DBã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚
ã¿ãªã•ã‚“ã¯æ™®æ®µãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ERå›³ã‚’æ›¸ãã®ã«ã©ã‚“ãªã‚½ãƒ•ãƒˆã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ä»Šå›žã¯ç„¡å„Ÿã§åˆ©ç”¨å¯èƒ½ãªãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦è‰²ã€…ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚
relax4u 2008/05/31
tool

free

windows

modeling

database
ãƒªãƒ³ã‚¯
ç¬¬11å›ž ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«è©³ã—ããªã‚ã†
å¯Œå±±çœŒé«˜å²¡å¸‚ æ ªå¼ä¼šç¤¾ã‚¤ãƒ¼ã‚¶ãƒ¼å‰¯ç¤¾é•·ã€‚æ˜”ã¯1æœˆåˆæ—¬ã«ç©é›ªãŒãªã„ã¨ã€Œã„ã„æ£æœˆã‚„ãã€‚é›ªãªãƒ¼ã¦ã€ã¨å¯Œå±±å¼ã§ã‚ã„ã•ã¤ã—ãŸã‚‚ã®ã ãŒï¼Œç¾åœ¨ã¯åœ°çƒæ¸©æš–åŒ–ã‚’ç›®ã®ã‚ãŸã‚Šã«ã™ã‚‹ã‚ˆã†ã§ä¸æ°—å‘³ã ã€‚ã§ã‚‚ï¼Œä¼šç¤¾ã¾ã§å…¬å…±äº¤é€šæ©Ÿé–¢ã¯ãªãï¼Œé›¨ã‚„ã¨ããŠã‚Šé›ªãŒé™ã‚‹ã®ã§è»Šã§é€šå‹¤ã—ã¦ã„ã‚‹ã€‚å¾’æ©ã‚„è‡ªè»¢è»Šã«å¤‰ãˆãªã‘ã‚Œã°ã¨æ€ã†ã®ã ãŒï¼Œå†¬å ´ã¯ã‚„ã¯ã‚Šå„„åŠ«ã ã€‚ ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã¯é–¢é€£ã™ã‚‹è¤‡æ•°ã®å‡¦ç†ã‚’ã¾ã¨ã‚ã¦ï¼Œä¸€ã¤ã®ãƒ¦ãƒ‹ãƒƒãƒˆã¨ã—ã¦å®Ÿè¡Œã™ã‚‹å‡¦ç†æ–¹å¼ã§ã™ã€â”€â”€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¥é–€æ›¸ã«ã¯ãŸã„ã¦ã„ã“ã‚“ãªé¢¨ã«æ›¸ã„ã¦ã‚ã‚Šã¾ã™ã€‚ èª¬æ˜Žç”¨ã®æœ€ã‚‚å¤šã„å›³è§£ãŒï¼Œå›³1ã®ã‚ˆã†ãªéŠ€è¡Œã®å£åº§é–“ã®æŒ¯æ›¿å‡¦ç†ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚Aã•ã‚“ã®å£åº§ã‹ã‚‰5ä¸‡å††å‡ºé‡‘ã—ãŸå¾Œã§ï¼Œä½•ã‚‰ã‹ã®åŽŸå› ã§Bã•ã‚“ã®å£åº§ã«å…¥é‡‘ã™ã‚‹ã“ã¨ãŒã§ããªã‹ã£ãŸã‚‰ï¼Œ5ä¸‡å††ãŒå®™ã«æµ®ã„ã¦ã—ã¾ã„ã¾ã™ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã—ã¦ä¸€ã¤ã®ãƒ¦ãƒ‹ãƒƒãƒˆã¨ã—ã¦å®Ÿè¡Œã™ã‚‹ã“ã¨ã§ï¼Œæ›´æ–°å‡¦ç†ã‚’ALL or Nothingã®çŠ¶æ…‹ã«ã§ãã‚‹ã®ã§ï¼Œä¸é€”åŠç«¯ãª
relax4u 2008/05/30
explanation

database

transaction

introduction
ãƒªãƒ³ã‚¯
çµµã§è¦‹ã‚‹ãƒ†ã‚¯ãƒŽãƒã‚¸----ç›®æ¬¡ï¼šITpro
ã€ŒæŠ€è¡“ã®èª¬æ˜Žæ–‡ç« ã‚’èªã‚“ã§ã‚‚ã‚‚ã†ä¸€ã¤é£²ã¿è¾¼ã‚ãªã„ã€ã€Œã„ã–ï¼Œèª¬æ˜Žã—ã‚ˆã†ã¨ã—ã¦ã‚‚èª¬æ˜Žã§ããªã„ã€â€•â€•ã€‚ãã‚“ãªçµŒé¨“ã¯ãªã„ã ã‚ã†ã‹ã€‚ãã®ã‚ˆã†ãªã¨ãï¼Œã€Œå›³è§£ã€ãŒå¤§ããªåŠ›ã‚’ç™ºæ®ã—ã¾ã™ã€‚èª¬æ˜Žã§ããã†ã§èª¬æ˜Žã§ããªã‹ã£ãŸâ€œã‚ã®â€æŠ€è¡“ã‚’ï¼Œåˆ†ã‹ã‚Šã‚„ã™ãä¸å¯§ã«è§£èª¬ã—ã¾ã™ã€‚ é–¢é€£ã‚µã‚¤ãƒˆï¼š ï¼œç›®æ¬¡ï¼ž â– ã‚µãƒ¼ãƒãƒ¼ã®çœé›»åŠ›æŠ€è¡“ ç¬¬1å›žã€€æ¶ˆè²»é›»åŠ›ãŒæ€§èƒ½ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã« ç¬¬2å›žã€€ãƒ—ãƒã‚»ãƒƒã‚µã®å‘¨æ³¢æ•°ã‚’åˆ¶å¾¡ã™ã‚‹ ç¬¬3å›žã€€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯å†…éƒ¨ã®æ¶ˆè²»é›»åŠ›ã‚’æŠ‘ãˆã‚‹ ç¬¬4å›žã€€ã‚µãƒ¼ãƒãƒ¼ä»®æƒ³åŒ–ã¯çœé›»åŠ›ã®åˆ‡ã‚Šæœ â– SOAã®ã‚·ã‚¹ãƒ†ãƒ é€£æºåŸºç›¤ã€ŒESBã€ å‰ç·¨ å¾Œç·¨ â– ãƒ—ãƒã‚°ãƒ©ãƒ é–“ã«ãƒœã‚¿ãƒ³ã‚’æŽ›ã‘ã‚‹ã€ŒDI/AOPã€ å‰ç·¨ å¾Œç·¨ â– å¯ç”¨æ€§ã‚’é«˜ã‚ã‚‹ã€Œã‚µãƒ¼ãƒãƒ¼å¤šé‡åŒ–ã€ å‰ç·¨ å¾Œç·¨ â– å…ˆäººã®çŸ¥æµã‚’é›†ã‚ãŸã€Œã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ãƒ‘ã‚¿ãƒ¼ãƒ³ã€ ç¬¬1å›ž é©ç”¨ç¯„å›²ãŒæ‹¡å¤§ã™ã‚‹ã€Œã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ãƒ‘ã‚¿ãƒ¼ãƒ³ã€ ç¬¬2å›ž ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£é…ç½®ã®ã²ãªåž‹ã€Œãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ãƒ»ãƒ‘ã‚¿ãƒ¼ãƒ³ã€ ç¬¬3å›ž æˆæžœç‰©ã‚„çµ„ç¹”
relax4u 2008/05/30
*study

explanation

soa

tcp

database
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå¾Œç·¨ï¼‰
ï¼žï¼žå‰ç·¨ ãƒãƒƒã‚·ãƒ¥åˆ©ç”¨ã§æ¯”è¼ƒã‚’æ¸›ã‚‰ã™ å¾Œç·¨ã§ã¯ã¾ãšï¼Œã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒé¸æŠžã™ã‚‹æœ€çŸçµŒè·¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…±é€šã®ã‚ãƒ¼ã‚’ç”¨ã„ã¦çµåˆã™ã‚‹ã€Œã‚¸ãƒ§ã‚¤ãƒ³ã€ã¯ã„ãã¤ã‹ã®æ–¹å¼ãŒã‚ã‚‹ã€‚ãã®ä¸€ã¤ã§ã‚ã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¸ãƒ§ã‚¤ãƒ³ã¯ï¼Œãƒãƒƒã‚·ãƒ¥é–¢æ•°ã‚’ä½¿ã£ã¦ï¼Œä¸€ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ãƒ¼ã‹ã‚‰ãƒãƒƒã‚·ãƒ¥å€¤ã‚’è¨ˆç®—ã™ã‚‹ï¼ˆå›³4ï¼‰ã€‚ã•ã‚‰ã«ï¼Œãƒãƒƒã‚·ãƒ¥å€¤ã¨è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã§æ§‹æˆã™ã‚‹ã€Œãƒãƒƒã‚·ãƒ¥ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚’ä½œæˆã™ã‚‹ã€‚åŒæ§˜ã«äºŒã¤ç›®ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒãƒƒã‚·ãƒ¥å€¤ã‚’è¨ˆç®—ã—ï¼Œãã®å€¤ã‚’åŸºã«æ¤œç´¢ã™ã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç‰¹å®šã™ã‚‹ã€‚ãƒãƒƒã‚·ãƒ¥å€¤ã‚’è¨ˆç®—ã™ã‚‹ã ã‘ã§æ¯”è¼ƒå¯¾è±¡ã®ãƒ‡ãƒ¼ã‚¿ãŒçµžã‚Šè¾¼ã‚ã‚‹ã®ã§ï¼Œã»ã‹ã®ã‚¸ãƒ§ã‚¤ãƒ³æ–¹å¼ã‚ˆã‚Šã‚‚é«˜é€Ÿã«ãªã‚‹å ´åˆãŒã‚ã‚‹ã€‚ãŸã ã—ï¼Œã€Œå„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å±•é–‹ã§ãã‚‹ã ã‘ã®ãƒ¡ãƒ¢ãƒªãƒ¼å®¹é‡ãŒå¿…è¦ã«ãªã‚‹ã€‚ãƒ¡ãƒ¢ãƒªãƒ¼ãŒè¶³ã‚Šãªã„ã¨é€†ã«é…ããªã‚‹ã€ï¼ˆä¼Šè—¤å¿ ãƒ†ã‚¯ãƒŽã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚º ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ æŠ€è¡“éƒ¨ éƒ¨é•·ä»£è¡Œ å®®ç”°æ¦æ°ï¼‰ã¨ã„ã£ãŸæ³¨æ„ç‚¹ãŒã‚ã‚‹ã€‚ å›³4â—ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¸ãƒ§ã‚¤ãƒ³
relax4u 2008/05/30
tips

tuning

database

performance
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
relax4u 2008/05/30
tips

tuning

database

performance
ãƒªãƒ³ã‚¯
1