[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] heppokonekoã®ãƒ

heppokoneko id:heppokoneko

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹heppokonekoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
heppokoneko 2012/07/23
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
heppokoneko 2011/08/10
éžè¡¨ç¤ºãƒ•ãƒ©ã‚°ã¨ã‹

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

IT
ãƒªãƒ³ã‚¯
ä¿¡ã˜ã‚‰ã‚Œãªã„DBæ–‡åŒ–ã€ŒJoinç¦æ¢ã€ã«ã€Œå›ºå®šé•·DBã€ã€ã€ã§ã‚‚ã€åˆã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
åƒ•ã‚‰ãŒæœ€è¿‘æ‰‹ãŒã‘ã¦ã„ã‚‹ã®ã¯ã€ã¨ã¦ã‚‚å¤§è¦æ¨¡ãªã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ 100ä¸‡äººã®å¥‘ç´„ãƒ¦ãƒ¼ã‚¶ãŒä½¿ã„ã€1ãƒ†ãƒ¼ãƒ–ãƒ«ã«1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’è²¯ã‚ã€24æ™‚é–“æ¢ã‚ã‚‹ã“ã¨ãŒè¨±ã•ã‚Œãšã€ è¦æ±‚ã‹ã‚‰å¿œç”ã¾ã§ã®ã‚¿ãƒ¼ãƒ³ã‚¢ãƒ©ã‚¦ãƒ³ãƒ‰ã‚¿ã‚¤ãƒ ãŒ1ç§’ä»¥å†…ã¨ã„ã†åŽ³ã—ã„SLAã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€‚ ä¸ã§ã‚‚åƒ•ã¯RDBã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’æ‹…å½“ã—ã¦ã„ã‚‹ã€‚ åƒ•ãŒã“ã®ç¾å ´ã«æ¥ã¦ã€é©šæ„•ã—ãŸæ–‡åŒ–ãŒ2ã¤ã‚ã‚‹ ãã‚Œã¯ã€ŒJoinç¦æ¢ã€ã¨ã€Œå›ºå®šé•·DBã€ã ã€‚ ã‚ã‚Šãˆãªã„ã€‚ ã¨ã¯ã„ãˆã€æ£ç›´ã«è¨€ãˆã°ã€Œã¾ãŸã‹ã€ã€ã€ã€ã¨ã„ã†æ„Ÿæƒ³ã§ã‚‚ã‚ã‚‹ã€‚ RDBã‚’çŸ¥ã‚‰ãªã„ãƒ¬ã‚¬ã‚·ãƒ¼ãªäººãŸã¡ãŒè¨è¨ˆã—ãŸDBã§ã¯ã‚ˆãã‚ã‚ŠãŒã¡ãªè¨è¨ˆã ã‹ã‚‰ã ã€‚ ã¨åƒ•ã¯æ—©ã€…ã«ã“ã®æ–‡åŒ–ã¨æˆ¦ã£ã¦ã€çµ¶å¯¾ã«è¦†ã—ã¦ã‚„ã‚ã†ã¨è€ƒãˆã¦ãŸã€‚ éŽåŽ»ã®çµŒé¨“ä¸Šãã‚Œã¯ãŸã‚„ã™ã„ãƒã‚ºã ã£ãŸã€‚ ã—ã‹ã—ã€ã“ã®æ–‡åŒ–ã¨æˆ¦ã†ã“ã¨3ãƒ¶æœˆé–“ã€‚ å±ˆã—ãŸã€‚åˆã‚ã¦å±ˆã—ãŸã€‚ã„ã‚„ã€å±ˆã—ãŸã¨ã„ã†ã‚ˆã‚Šã¯ç†è§£ã—ãŸã€‚ å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBã¨ã„ã†
heppokoneko 2011/08/09
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DBè¨è¨ˆ
ãƒªãƒ³ã‚¯
ã‚¢ãƒ”ã‚¿ãƒ«ï¼ˆåŒ»ç™‚ãƒ»å¥åº·ãƒ»ä»‹è·ï¼‰ï¼šæœæ—¥æ–°èžãƒ‡ã‚¸ã‚¿ãƒ«
heppokoneko 2011/08/01
åŒ»ç™‚

æ¯ç§‘

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
å¤‰åŒ–ã™ã‚‹DBã®å¿…é ˆçŸ¥è˜
ç†è€…ãŒæ—¥çµŒã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã«ç•°å‹•ã—ã¦ããŸã®ã¯5å¹´å‰ã€‚å½“æ™‚ã€æ—¥çµŒã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã§ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶ä¼ç”»ã€ã¨è¨€ãˆã°ã€ç±³Oracleã®Oracle Databaseã‚„MySQLã€ç±³Microsoftã®SQL Serverã‚’ä¸å¿ƒã«å–ã‚Šä¸Šã’ã‚‹ã‚‚ã®ã ã£ãŸã€‚ ã“ã‚Œã‚‰ã¯ã¿ãªã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨ã„ã†ç†è«–ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRelational Database Management Systemã€RDBMSï¼‰ã§ã‚ã‚‹ã€‚ä¸€æ˜”å‰ã§ã¯RDBMSã•ãˆç†è§£ã—ã¦ãŠã‘ã°ã€æ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰å€‹äººå‘ã‘ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«è‡³ã‚‹ã¾ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã«äº‹æ¬ ãã“ã¨ã¯ãªã‹ã£ãŸã€‚ ã‚¹ãƒžãƒ›ï¼†ã‚¯ãƒ©ã‚¦ãƒ‰ã®æ™®åŠã§å¤‰åŒ– ã‚ã‚Œã‹ã‚‰5å¹´ã®æœˆæ—¥ãŒæµã‚ŒãŸä»Šã€æ€¥é€Ÿã«æ‹¡å¤§ã™ã‚‹ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ï¼†ã‚¯ãƒ©ã‚¦ãƒ‰å¸‚å ´ã«ã‚ˆã£ã¦ã€é–‹ç™ºè€…ãŒå¦ã¶ã¹ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¤‰åŒ–ãŒç”Ÿã˜ã¦ã„ã‚‹ã€‚å¾“æ¥ã®RDBMSã®çŸ¥è˜ã«åŠ ãˆã¦
heppokoneko 2011/07/28
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB
ãƒªãƒ³ã‚¯
1