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

f_oggy id:f_oggy

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

ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
f_oggy 2017/06/26
ã“ã®ç¨‹åº¦ã®DBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã¯å½“ãŸã‚Šå‰ã®ã“ã¨ã§ã‚‚åœŸæ–¹ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¯ãªã«ãã‚Œï¼Ÿãªã“ã¨ã£ã¦å¤šã„ã€‚ã¡ã‚‡ã£ã¨ã—ãŸæ•™è‚²ã‚’å—ã‘ã‚‹ã ã‘ã§ã‚‚é•ã£ã¦ãã‚‹ã®ã«ã‚³ã‚¹ãƒˆãŒãã‚Œã‚’è¨±ã•ãªã„ç’°å¢ƒãŒå¤šã™ãŽã‚‹

DB
ãƒªãƒ³ã‚¯
Life with IT
æŒ‡å®šã—ãŸè³‡æ–™ã¯å˜åœ¨ã—ã¾ã›ã‚“ã€‚
f_oggy 2015/07/15
ã„ã„è³‡æ–™ã ã‘ã©ã‚¤ãƒ³ãƒ•ãƒ©ã¨ã„ã†ã‹RDBMSã®ä»•æ§˜ã‚’ç†è§£ã—ã‚ã£ã¦å†…å®¹

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

database

DB

Oracle
ãƒªãƒ³ã‚¯
RDBã«ãŠã‘ã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã„ã†è€ƒãˆæ–¹
RDBã®å°‚é–€å®¶ã¨ã—ã¦æ—¥ã€…æ´»å‹•ã—ã¦ã„ã‚‹ä¸ã§æ°—ã¥ã„ãŸã“ã¨ã®ã²ã¨ã¤ã«ã€ã€ŒRDBã¯ãƒ‡ãƒ¼ã‚¿ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã®å®Ÿè£…ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é ¼ã£ã¦ã„ã‚‹ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å…¨ã¦ã®å•é¡Œã‚’è§£æ±ºã§ãã‚‹ã»ã©ä¸‡èƒ½ã§ã¯ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã„ã†ã®ã¯ã¨ã¦ã‚‚å¼·åŠ›ãªéƒ¨å“ã§ã‚ã‚Šã€ãã®ç‚¹ã«ã¯å…¨ãç•°è«–ã¯ãªã„ã€‚ã ãŒã€ä¸–ã®ä¸ã®å…¨ã¦ã®å•é¡Œï¼ˆã‚¯ã‚¨ãƒªï¼‰ã‚’è§£æ±ºã§ãã‚‹ã»ã©ã€æŸ”è»Ÿæ€§ã«å¯Œã‚“ã ã‚‚ã®ã§ã¯ãªã„ã¨ã„ã†ã“ã¨ã ã€‚RDBã¯ã€ã©ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‹ã¨ã„ã†ã“ã¨ã‚’ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã‚’ç”¨ã„ã¦åˆ¤æ–ã™ã‚‹ã€‚å¤§æŠµã®RDBè£½å“ã§ã¯ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‚ˆã„ä»•äº‹ã‚’ã™ã‚‹ã®ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã®çµ„ã¿åˆã‚ã›ã«ã‚ˆã£ã¦ã€ã»ã¨ã‚“ã©ã®å•é¡Œã«å¯¾å¿œã§ãã‚‹ã€‚ã ãŒã€100%ã§ã¯ãªã„ã®ã§ã‚ã‚Šã€ãã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ãŒã‚·ã‚¹ãƒ†ãƒ ã®æ€§èƒ½å•é¡Œã‚’å¼•ãèµ·ã“ã—ãŸã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒžï¼ˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆè€…ï¼‰ã«ã€NoSQLã¸å®Œå…¨ã«ç§»è¡Œã—ãŸã‚Šã€ã‚¯ã‚¨ãƒªé«˜é€ŸåŒ–ã®ãŸã‚ã«éžæ£è¦åŒ–ã‚’ã™ã‚‹ã¨è¨€ã£
f_oggy 2015/07/15
ãƒžãƒ†ãƒ“ãƒ¥ãƒ¼ã¯ã‚‚ã†ã¡ã‚‡ã„çŸ¥ååº¦ã‚ãŒã£ã¦ã»ã—ã„ã¨ã¯æ€ã†ã€‚ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¨ã£ã¦ç„¡çŸ¥ã¯ç½ªãªã®ã‚ˆã

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

db

database
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåŒ–ã™ã‚‹ã€ŒOracle Database In-Memoryã€ã€æ€§èƒ½ã‚’æ•°ç™¾å€é«˜é€ŸåŒ–ã€æ¥æœˆå‡ºè·ã¸
ï¼»é€Ÿå ±ï¼½Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåŒ–ã™ã‚‹ã€ŒOracle Database In-Memoryã€ã€æ€§èƒ½ã‚’æ•°ç™¾å€é«˜é€ŸåŒ–ã€æ¥æœˆå‡ºè·ã¸ ç±³ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€Oracle Database 12cã‚’ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã€å¾“æ¥ã¨æ¯”è¼ƒã—ã¦æ•°ç™¾å€ã®æ€§èƒ½å‘ä¸Šã‚’å®Ÿç¾ã™ã‚‹ã€ŒOracle Database In-Memoryã€ã‚’æ¥æœˆ7æœˆã«å‡ºè·ã™ã‚‹ã¨ç™ºè¡¨ã—ã¾ã—ãŸã€‚ Oracle Database In-Memoryã¯ã€æ˜¨å¹´9æœˆã«è¡Œã‚ã‚ŒãŸOracle OpenWorld 2013ã®åŸºèª¿è¬›æ¼”ã§ç™ºè¡¨ã•ã‚ŒãŸã‚‚ã®ã€‚ä»Šå›žã®ç™ºè¡¨ã«ã¯ã€ãã®ã¨ãã¨åŒæ§˜ã«åŒç¤¾CEOã®ãƒ©ãƒªãƒ¼ãƒ»ã‚¨ãƒªã‚½ãƒ³æ°ãŒç™»å£‡ã€ç†±ã®ã“ã‚‚ã£ãŸèª¬æ˜Žã‚’è¡Œã„ã¾ã—ãŸã€‚ ã‚¨ãƒªã‚½ãƒ³æ°ã¯ã€ŒOracle Database In-Memoryã¯ã€ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹å‡¦ç†ã‚’10å€ã‚‚100å€ã‚‚é«˜é€ŸåŒ–ã—ã€OLTPã‚‚2å€ã€3å€ã¨é«˜é€ŸåŒ–ã™ã‚‹ã€‚ã—ã‹ã‚‚Oracle RACï¼ˆReal Applicat
f_oggy 2014/06/13
ã©ã†ã›EEã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¨ã‹ãªã‚“ã ã‚ã†ãªãã€‚SEã§ã‚‚ä½¿ã‚ã›ã¦æ¬²ã—ã„ã¨ã“ã‚ã ãŒ

DB

oracle
ãƒªãƒ³ã‚¯
ä»Šã¾ã§è¦‹ãŸã‚‚ã£ã¨ã‚‚ã‚¯ã‚½ãªãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ - ä½•ã‹ç€ã¦ã„ã‚Œã°ã„ã„ã‚ˆ
ã‚ã‚Œã¯ã€åƒ•ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ã†ã¡æœ€åˆã‹ã‚‰ï¼“ä»¶ç›®ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã ã£ãŸã€‚ C++ã®ã‚½ãƒ¼ã‚¹ãŒé›£è§£ã§ç«ã‚’å¹ã„ã¦ã„ã‚‹ã¨ã„ã†è©±ã§ã€è‡ªåˆ†ã¯ä½Žã‚¹ã‚ãƒ«ã®è‹¥é€ ã€‚ç«ã«ãã¹ã‚‹ã«ã¯ä¸åº¦è‰¯ã„ç¨‹åº¦ã®ã‚„ã‚‹æ°—ã¨è²¬ä»»æ„Ÿã‚’ã‚‚ã£ã¦ã„ãŸã€‚æŠ˜æ‚ªãåˆ¥ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒçµ‚äº†ã—ãŸç›´å¾Œã ã£ãŸã‚‚ã®ã§æŠ•å…¥ã•ã‚ŒãŸã®ã§ã—ãŸã€‚ ç¾å ´ã§ã€ŽDBã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å¸ã„å‡ºã™ãƒ„ãƒ¼ãƒ«ã‹SQLã‚’ä½œã£ã¦ãã‚Œã€ã¨ã„ã‚ã‚Œè©±ã‚’ããã¨ä»–ç¤¾ãŒä½œã£ãŸDBå®šç¾©ãŒã™ã“ã¶ã‚‹ä½¿ã„ã¥ã‚‰ã„ã¨ã„ã†ã€‚ ERå›³ã‚„DBå®šç¾©ã‚’è¦‹ã›ã¦ãã ã•ã„ã¨è¨€ã£ãŸã®ã ã‘ã©ã€ãã‚“ãªã‚‚ã®ã¯ç„¡ã„ã¨ã„ã†è¿”äº‹ã€‚ ä»Šãªã‚‰ã‚‚ã†ã“ã“ã‚‰è¾ºã§é€ƒã’å‡ºã™ã¨ã“ã‚ã§ã™ãŒã€å½“æ™‚ã¯ã€Žãµãƒ¼ã‚“ã€‚ã€ã¦ãªã‚‚ã‚“ã§ãã†ã„ã†ã“ã¨ã‚‚ã‚ã‚‹ã®ã‹ãã‚‰ã„ã®è»½ã„æ°—æŒã¡ã§è€ƒãˆã¦ã„ã¾ã—ãŸã€‚ ã§ã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è³‡æ–™ã‚’ã‚ã•ã‚Šã¾ãã£ã¦ä½•ã¨ã‹DBå®šç¾©ã®ã‚ˆã†ãªã‚‚ã®ã‚‚è¦‹ã¤ã‘DBã®ãƒ‡ãƒ¼ã‚¿ã‚’èª¿æŸ»ã—å§‹ã‚ãŸã®ã§ã™ãŒä½•ã‹ãŒãŠã‹ã—ã„ã€‚ æ©Ÿèƒ½ã®æ•°ã«æ¯”ã—ã¦ç•°æ§˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ãŒå°‘ãªã„ã®ã§ã™ã€‚ ãµã¨å‘¨ã‚Šã‚’è¦‹ã‚‹ã¨ã€çš†
f_oggy 2014/03/05
å¤ã„ã‚·ã‚¹ãƒ†ãƒ ã ã¨EAVã½ã„ã®ã¯ã¡ã‚‡ã„ã¡ã‚‡ã„è¦‹ã‹ã‘ã‚‹ã€‚é¬±é™¶ã—ã„ã€‚

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º

db
ãƒªãƒ³ã‚¯
DBã®ä¸–ç•Œã«èµ·ã“ã‚‹å¤‰é© | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç‹¬ã‚Šè¨€
ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚·ã‚¹ãƒ†ãƒ ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã‚„ã£ã¦ï¼‘ï¼å¹´ä»¥ä¸Šã€‚æ€ã†ã¨ã“ã‚ã‚’æ›¸ã„ã¦ã„ãã¾ã™ã€‚ãã®ä»–è¶£å‘³ã‚’å°‘ã€…ã€‚ã€‚ã€‚ DBã®ä¸–ç•Œã«èµ·ããŸå¤§ããªæ³¢ ç¾åœ¨ã€ã©ã®è£½å“ã‚’ä½¿ã£ãŸã¨ã—ã¦ã‚‚RDBã®æ€§èƒ½å•é¡Œã¯å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©ç™ºç”Ÿã™ã‚‹ã€‚ç†ç”±ã¯ç°¡å˜ã§ã€CPUã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒé«˜é€ŸåŒ–ï¼ˆCPUã¯ãƒžãƒ«ãƒã‚³ã‚¢åŒ–ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã¯10G-Ethernetã®ä¸€èˆ¬åŒ–ã‚„InfiniBandãªã©ï¼‰ã™ã‚‹ã®ã«ãƒ‡ã‚£ã‚¹ã‚¯ï¼ˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ï¼‰ãŒé«˜é€ŸåŒ–ã«è¿½ã„ã¤ã„ã¦ã„ãªã„ã‹ã‚‰ã ã€‚ãã®å·®ã‚’åŸ‹ã‚ã‚‹å½¹å‰²ã¨ã—ã¦ã€RDBãŒæ‹…ã£ã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ãŒå¤šãã€æ€§èƒ½å•é¡Œã«ãªã‚‹ã‚±ãƒ¼ã‚¹ãŒæ•£è¦‹ã•ã‚Œã‚‹ã€‚ ã ãŒã€ãã†ã„ã†æ™‚ä»£ã®æµã‚Œã«å¯¾ã—ã¦å¤§ããªå¤‰é©ãŒèµ·ãã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã€‚SSDã¯ã‹ãªã‚Šã‚³ãƒ¢ãƒ‡ã‚£ãƒ†ã‚£åŒ–ã—ã¦ããŸã®ã§è¨€ã†ã«åŠã°ãšã¨ã„ã£ãŸæ„Ÿã˜ã ãŒã€å€‹äººçš„ã«ã¯é€Ÿã„ã‚‚ã®ã®ãƒ‡ã‚£ã‚¹ã‚¯ã®ç½®ãæ›ãˆã«ã™ãŽãªã„ã¨æ€ã£ã¦ã„ã‚‹ã€‚ã¤ã¾ã‚Šã€SSDã¯é€Ÿã„ãŒDBã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«å¤§ããªå¤‰é©ã‚’ã‚‚ãŸã‚‰ã™ã‚‚ã®ã§ã¯ãªã„ã€‚ãŒã€ã“ã“ã«ãã¦
f_oggy 2013/01/06
ã†ãƒ¼ã‚“ã€ãã†ã¯ã„ã£ã¦ã‚‚ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã®ãŠè©±ã ã‚ˆãã‡ã€‚SE Oneã‚’ä½¿ã‚ã–ã‚‹ã‚’ãˆãªã„ã‚ˆã†ãªã‚¾ãƒ¼ãƒ³ã«ã¯é–¢ä¿‚ãªã„ã‚ˆã†ãªæ°—ã‚‚ã™ã‚‹ã‘ã©ã‚ãƒ£ãƒƒãƒã‚¢ãƒƒãƒ—ã¯ã—ã¦ãŠã‹ãªã„ã¨ã‹ãªã€‚

db

SSD

database

oracle

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2012/10/31/20121027big-data-right-now-five-trendy-open-source-technologies/
f_oggy 2012/11/01
ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

db
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã‚’ä»•äº‹ã«ã™ã‚‹äººã®ç”Ÿæ…‹ç³» - dataminer.me
ã€Œãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã‚’ä»•äº‹ã¨ã™ã‚‹äººï¼ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒŠãƒ¼ã€ã¯ã©ã†ã„ã†äººãŸã¡ãŒã„ã‚‹ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦ ãƒ“ãƒƒã‚¯ãƒ‡ãƒ¼ã‚¿ã¨ã‹ã§ä¸–ã®ä¸ãŒãƒã‚ºã£ã¦ã‚‹ã‘ã©ã€Œåƒ•ã¯ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã‚’ã‚„ã£ã¦ã¾ã™ï¼ã€ã¨ã„ã£ãŸã¨ãã«é©åˆ‡ã«ãã®äººãŒã‚„ã£ã¦ã„ã‚‹æ¥å‹™é ˜åŸŸã‚’æŠŠæ¡ã—ã¦ã„ã‚‹äººã£ã¦ã‹ãªã‚Šå°‘ãªã„ã¨æ€ã†ã€‚ ã‚°ãƒªãƒ¼ã§åƒã„ã¦ã„ãŸã¨ãã‚‚ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒŠãƒ¼ã¯ã©ã†ã„ã£ãŸä»•äº‹ã‚’ã—ã¦ã„ã¦ã€ä½•ã‚’ã‚„ã£ã¦ã„ã¦ä½•ãŒã§ãã‚‹ã®ã‹ã£ã¦ã„ã†ã“ã¨ã‚’ç†è§£ã—ã¦ã„ãªãã¦ãƒŸã‚¹ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç”Ÿã¾ã‚Œã¦ã„ãŸã¨æ€ã†ã®ã§ã¡ã‚‡ã£ã¨ãã®ç”Ÿæ…‹ç³»ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ãŸã€‚ãŠãã‚‰ãã€ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒŠãƒ¼ã¨ã„ã‚ã‚Œã‚‹äººã¯ä»¥ä¸‹ã®ã‚¿ã‚¤ãƒ—ãŒã„ã‚‹ï¼š ç ”ç©¶é–‹ç™ºã‚’ã™ã‚‹äºº çµ±è¨ˆå¦çš„ã«æ–°ã—ã„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã‚’èµ·ã“ã›ã‚‹äººã€‚Google ã®PageRankã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’ä½œã‚Šã¾ã—ãŸã¨ã‹ã€Netfrixã‚„Amazonã®ãƒ¬ã‚³ãƒ¡ãƒ³ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ³ä½œã‚Šã¾ã—ãŸã¨ã‹ã„ã†äººãŒã“ã‚Œã«ã‚ãŸã‚‹ã€‚ã‚¹ã‚ãƒ«çš„ã«ã¯çµ±è¨ˆå¦ã«ã‹ãªã‚Šé•·ã‘ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã€ãã®ä»–
f_oggy 2012/10/23
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢

ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°

db

ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿
ãƒªãƒ³ã‚¯
DeNAã«ã‚ˆã‚‹å¤§è¦æ¨¡ãªMySQLãƒŽãƒ³ã‚¹ãƒˆãƒƒãƒ—é‹ç”¨ã®è£å´ã«ã‚ã‚‹ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«
4æœˆ11æ—¥ã‹ã‚‰ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Expo 2011ã€ã€‚ã“ã®ã‚¤ãƒ™ãƒ³ãƒˆã§DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒã€åŒç¤¾ã®å¤§è¦æ¨¡ãªMySQLã®é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹æŠ€è¡“ã¨ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒAutomated, Non-Stop MySQL Operations and Failoverã€ã‚’è¡Œã„ã¾ã—ãŸã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸ã§ã€ç¤¾å†…ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã®è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ã™ã‚‹ã“ã¨ã«ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ï¼ˆè‹±èªžã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚‚ä½œæˆä¸ã¨ã®ã“ã¨ï¼‰ã€‚ MySQLã®å¤§è¦æ¨¡é‹ç”¨ã«ãŠã‘ã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¯ã€ç‰¹ã«ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®MySQLã®åˆ©ç”¨ãŒå¢—ãˆã‚‹ã«ã¤ã‚Œã¦ãƒ‹ãƒ¼ã‚ºãŒé«˜ã¾ã‚‹åˆ†é‡Žã¨æ€ã‚ã‚Œã¾ã™ã€‚ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ è‡ªå‹•åŒ–ã•ã‚ŒãŸãƒŽãƒ³ã‚¹ãƒˆãƒƒãƒ—ãªMySQLã®é‹ç”¨ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã§ã¯é«˜å¯ç”¨æ€§ãŒå¼·ãæ±‚
f_oggy 2011/04/15
MySQLã¯ã“ã†ã„ã†æŠ€è¡“æƒ…å ±ãŒã‚ªãƒ¼ãƒ—ãƒ³ã§ã„ã„ãã‡ã€‚ãã‚ãã‚Oracleã ã‘ã˜ã‚ƒãªãã¦MySQLã‚‚ã‚„ã‚‰ãªã„ã¨ã‚ãƒ£ãƒƒãƒã‚¢ãƒƒãƒ—å‡ºæ¥ãªããªã‚‹ãªããƒ¼â€¦

MySQL

DB
ãƒªãƒ³ã‚¯
åƒ•ã¨æœˆåˆŠASCIIã¨iPadã€€ã¾ãŸã¯ã€åƒ•ãŒ10,000å††ã®ã‚¢ãƒ—ãƒªã‚’ä½œã£ãŸç†ç”± - Keep Crazy;shi3zã®æ—¥è¨˜
f_oggy 2010/09/15
ã“ã€ã“ã‚Œã¯å‡„ã„â€¦ã€‚ï¼‘ä¸‡ã¨ã‹æ¿€å®‰ã˜ã‚ƒãªã„ã‹ã€‚çš„ç¢ºãªåŸºç¤Žãƒ‡ãƒ¼ã‚¿ã‚’å‰µã‚Šå‡ºã—ãŸé è—¤ã•ã‚“ã‚‚å‡„ã„ã—ã€ãã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ã«åˆ†ã‹ã‚‹å½¢ã«è½ã¨ã—è¾¼ã‚€çµ±è¨ˆãƒ„ãƒ¼ãƒ«ã‚’å‰µã‚Šå‡ºã—ãŸæ¸…æ°´ã•ã‚“ã‚‚å‡„ã„ã€‚å«‰å¦¬ã—ã¡ã‚ƒã†ãªã€‚

iPad

çµ±è¨ˆ

DB

é–‹ç™º
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒé…ããªã£ãŸåŽŸå› ã‚’è‡ªå‹•çš„ã«ã‚¹ã‚ãƒ£ãƒ³ã—ã¦åˆ†æžã™ã‚‹ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã€ŒTrace Analyzer for SQL Serverã€
Windows XP SP1/Vistaã¨Windows Server 2003/2008ã®32ãƒ“ãƒƒãƒˆãŠã‚ˆã³64ãƒ“ãƒƒãƒˆç‰ˆã§å‹•ä½œã—ã€SQL Server 2005/2008ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ†æžã™ã‚‹ã“ã¨ã§é€Ÿåº¦ãŒé…ããªã£ã¦ã—ã¾ã£ãŸåŽŸå› ã‚’è¦‹ã¤ã‘ã¦ãã‚Œã‚‹ã®ãŒã“ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã€ŒTrace Analyzer for SQL Serverã€ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦èµ·å‹•ã•ã›ã‚‹ã«ã¯ä»–ã«ã€Œ.Net Framework 3.5 SP1ã€ã¨ã€ŒMicrosoft SQL Server Compact 3.5 SP1ã€ã‚‚å¿…è¦ã§ã™ã€‚ æ•°ç™¾ã‚ã‚‹ã„ã¯æ•°åƒã‚‚ã‚ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚¤ãƒ™ãƒ³ãƒˆã‚’ãƒˆãƒ¬ãƒ¼ã‚¹ã—ãŸã‚Šã€ã‚µãƒ¼ãƒã«éŽè² è·ã‚’ã‹ã‘ã¦ã„ã‚‹ãƒãƒƒãƒãŒã©ã‚ŒãŒç‰¹å®šã—ãŸã‚Šã™ã‚‹ã‚ãšã‚‰ã‚ã—ã•ã‹ã‚‰è§£æ”¾ã—ã¦ãã‚Œã‚‹ã¯ãšã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ DBSophic | Trace Analyzer for SQL Server http://www.dbsoph
f_oggy 2009/07/31
db

GIGAZINE
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
f_oggy 2009/07/22
db
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
f_oggy 2009/05/12
db
ãƒªãƒ³ã‚¯
1