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

NoSQLã‚’ä¸Šå›žã‚‹æ€§èƒ½ã®VoltDBã€ãã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã¯

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç ”ç©¶è€…ã®å¤§å¾¡æ‰€ã€ãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ãŒé–‹ç™ºã—ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚‚ä¸Šå›žã‚‹æ€§èƒ½ã‚’ç™ºæ®ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDBã€ã€‚å‰å›žã®è¨˜äº‹ã§ã¯ã€ãã®ç‰¹å¾´ã¨ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Cassandraã¨ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯æ¯”è¼ƒã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯VoltDBã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã¤ã„ã¦èª¿ã¹ãŸã“ã¨ã‚’ã”ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚åŸºæœ¬çš„ã«ã¯VoltDBã®Webã‚µã‚¤ãƒˆã‚„ãƒªãƒ³ã‚¯å…ˆã®å†…å®¹ã‚’åŸºã«ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ãƒ–ãƒã‚°ã€Œç‹¬ã‚Šè¨€v6ã€ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒVoltDBç™»å ´ â€“ RDBMSã®ã‚ˆã†ã§RDBMSã§ã¯ãªã„æ–°ã‚·ã‚¹ãƒ†ãƒ ã€ã‚‚å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã‚·ã‚§ã‚¢ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ãªåˆ†æ•£ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ VoltDBã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¯ã€FAQã®ãƒšãƒ¼ã‚¸ã§ä»¥ä¸‹ã®ã‚ˆã†ã«èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ï¼ˆè‹±èªžã‚’è¨³ã—ãŸã‚‚ã®ã‚’å¼•ç”¨ã—ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹åŒã˜ã§ã™ï¼‰ã€‚ VoltDBã¯ã€ã‚·ã‚§ã‚¢ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ãªã‚µãƒ¼ãƒç¾¤ã‹ã‚‰æ§‹æˆã•ã‚Œã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–

twainy 2010/06/01

db

ãƒªãƒ³ã‚¯

DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹

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

twainy 2010/01/22

ER
DB

ãƒªãƒ³ã‚¯

ã©ã†ã‚‚ä¸–é–“ã§ã¯ã€æ€ã£ãŸã‚ˆã‚ŠDBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒä¸è¶³ã—ã¦ã„ã‚‹æ§˜ã : ä¸å€’åŸŽ

ã¡ã‚‡ã£ã¨æŠ€è¡“çš„ãªè©±ã€‚oracleåˆ†ã‹ã‚‹äººã«ã—ã‹åˆ†ã‹ã‚‰ãªã„ã‹ã‚‚ã€‚ æœ€è¿‘å–å¼•å…ˆã®ã‚·ã‚¹ãƒ†ãƒ ã‚’è¦‹ã‚‹æ©Ÿä¼šãŒä½•åº¦ã‹ã‚ã£ãŸã®ã ãŒã€æ˜¨æ—¥ã™ã‚“ã”ã„ã¨ã“è¦‹ãŸã€‚ DBãŒé‡ãã¦æ¥å‹™ã«ãªã‚‰ãªã„ã¨ã„ã†ã‹ã‚‰ã€ã¡ã‚‡ã£ã¨ä¸ã‚’è¦—ã‹ã›ã¦ã‚‚ã‚‰ã£ãŸã‚‰ã‚‚ã†ã‚¨ãƒ©ã„ã“ã£ã¡ã‚ƒã€‚ ãƒ»æ¥å‹™ãƒã‚¸ãƒƒã‚¯ã®æ®†ã©ã‚’ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§æ§‹æˆã—ã¦ã„ã‚‹ã€‚ãªã®ã«ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ãŒå¦™ã«ä½Žã„ã€‚ ãƒ»èª¿ã¹ã¦ã¿ã‚ˆã†ã¨æ€ã£ãŸã‚‰ä¸€å›žã‚‚statspackãŒå–å¾—ã•ã‚Œã¦ã„ãªã„ã€‚(æ‹…å½“è€…ã«ã¯ã€ã€Œstatspack?syslogãªã‚‰ã¨ã£ã¦ã‚ã‚‹ã‚“ã§ã™ãŒâ€¦ã€ã¨è¨€ã‚ã‚ŒãŸ) ãƒ»å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®indexãŒã©ã†ã„ã†è¨³ã‹å…¨åˆ—ã«è²¼ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ã¡ãªã¿ã«indexã¯å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ä¾‹å¤–ãªããã®ä¸€å€‹ã ã‘(ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’é™¤ã‘ã°ã ãŒ)ã€‚ ãƒ»ã¨æ€ã£ãŸã‚‰ã€PKãŒæ–‡å—åˆ—ã ã£ãŸã‚Šã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã¡ã‚‰ã“ã¡ã‚‰ã«ã‚ã‚‹ã€‚ ãƒ»è©¦ã—ã«ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä¸€ã¤äºŒã¤è¦‹ã¦ã¿ãŸã‚‰ã€ãªã‚“ã‹æ™®é€šã«ã‚¯ãƒã‚¹çµåˆã•ã‚Œã¾ãã£ã¦ã„ã¦ã¡ã‚‡ã£ã¨ãã‚‰ã£

twainy 2009/01/21

db

ãƒªãƒ³ã‚¯

DBè¨è¨ˆãŒæ¥½ã—ã„ãƒ¯ã‚± : akiyan.com

DBè¨è¨ˆãŒæ¥½ã—ã„ãƒ¯ã‚± 2008-08-26 ã‚ã‚‹ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã®DBã‚¹ã‚ãƒ¼ãƒžã‚’è¨è¨ˆã‚’ã—ã¦ã„ã‚‹ã€‚æ¯Žåº¦æ€ã†ã®ã ã‘ã©ã€DBè¨è¨ˆã¯æ¥½ã—ã„ã€‚ ãªãœã“ã‚“ãªã«ã‚‚æ¥½ã—ã„ã®ã ã‚ã†ã‹ã¨æ€ã£ã¦è€ƒãˆãŸã¨ã“ã‚ã€DBè¨è¨ˆã¯ã‚ã‚‹æ„å‘³ã€Œè¨€èªžè¨è¨ˆã€ã«è¿‘ã„ã®ã§ã¯ã¨æ€ã£ãŸã€‚ è¨€èªžè¨è¨ˆã‚‚æ¥½ã—ã„ã€‚ ã‚ã‚‹DSL(Domain Specific Language, ãƒ‰ãƒ¡ã‚¤ãƒ³å›ºæœ‰è¨€èªž)ã‚’è¨è¨ˆã—ã¦å®Ÿè£…ã—ãŸæ™‚ã¯ã€ãã‚Œã¯ã‚‚ã†ã‚¨ã‚ã‚µã‚¤ãƒ†ã‚£ãƒ³ã‚°ã ã£ãŸã€‚ ãã®DSLã¯ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆè¨€èªžã§ã€ãƒ—ãƒã‚°ãƒ©ãƒžå‘ã‘ã§ã‚‚ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼å‘ã‘ã§ã‚‚ã‚ã£ãŸã€‚HTMLã‚¨ãƒ‡ã‚£ã‚¿ã§æ›¸ãã‚„ã™ã„ã‚ˆã†ã€ãªã˜ã¿ã‚„ã™ã„ã‚ˆã†ã€æ–‡æ³•ã«é…æ…®ã—ãŸã€‚å®Ÿè£…ã¯ãƒˆãƒªãƒƒã‚ãƒ¼ã§ã€å†å¸°çš„ã«å‡ºåŠ›çµæžœã‚’ãƒ‘ãƒ¼ã‚¹ã™ã‚‹ã¨ã„ã†å¤‰ã‚ã£ãŸå®Ÿè£…ã§ã€ã†ã¾ãå†å¸°ã—ã¦è¤‡é›‘ãªçµæžœãŒå‡ºåŠ›ã•ã‚ŒãŸã¨ãã®å¿«æ„Ÿã¨ã„ã£ãŸã‚‰ãªã‹ã£ãŸã€‚åŒã˜å‡ºåŠ›ã‚’æœŸå¾…ã™ã‚‹éƒ¨åˆ†ã¯ã€ã‚³ãƒ¼ãƒ‰ã‚ãƒ£ãƒƒã‚·ãƒ¥çš„ãªæ©Ÿèƒ½ã§é«˜é€ŸåŒ–ã—ãŸã€‚çˆ†é€Ÿã«ãªã£ãŸã€‚ç—ºã‚ŒãŸã€‚ï¼ˆãã®å¾Œãã®DSLã®ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯

twainy 2008/09/16

db

ãƒªãƒ³ã‚¯

DBã®ãƒªãƒ•ã‚¡ã‚¯ã‚¿ã¯ã“ã‚Œã§ - DBãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«LiquiBase 1.4ç™»å ´ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

Sundogã¯19æ—¥(ç±³å›½æ™‚é–“)ã€LiquiBaseã®æœ€æ–°ç‰ˆã¨ãªã‚‹ã€ŒLiquiBase 1.4ã€ã‚’å…¬é–‹ã—ãŸã€‚LiquiBaseã¯Javaã§é–‹ç™ºã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤‰æ›´è¿½è·¡ã‚„ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚’å®Ÿæ–½ã™ã‚‹ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¾å˜ã—ãªã„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤‰æ›´ã‚„ç®¡ç†ã€ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°ãªã©ã‚’å®Ÿç¾ã§ãã‚‹ã€‚ãƒ—ãƒãƒ€ã‚¯ãƒˆã¯GNU LESSER GENERAL PUBLIC LICENSE Version 2.1ã®ã‚‚ã¨ã§ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ã—ã¦å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ LiquiBase 1.4ã§ã¯ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒå®Ÿæ–½ã•ã‚Œã¦ã„ã‚‹ã»ã‹IntelliJãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚µãƒãƒ¼ãƒˆã®è¿½åŠ ã€ãƒã‚§ãƒ³ã‚¸ãƒã‚°ã«ãŠã‘ã‚‹ã‚¹ã‚ãƒ¼ãƒžæŒ‡å®šã‚µãƒãƒ¼ãƒˆã®è¿½åŠ ã€MaxDB/SAPDBã‚µãƒãƒ¼ãƒˆã®è¿½åŠ ã€å¤–éƒ¨ã‚ãƒ¼ã®ã‚µãƒãƒ¼ãƒˆã€Mavenã‚µãƒãƒ¼ãƒˆã®æ”¹å–„ãªã©ãŒå®Ÿæ–½ã•ã‚Œã¦ã„ã‚‹ã€‚1.4ã¸ç§»è¡Œã™ã‚‹ã«ã¯Jarãƒ•ã‚¡ã‚¤ãƒ«ã‚’æœ€æ–°ç‰ˆã«å…¥

twainy 2007/12/11

ã€ŽDBãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«LiquiBase 1.4ã€ã¸ãƒ¼ã€‚ãã‚“ãªã®ã‚ã‚‹ã®ã‹

db

ãƒªãƒ³ã‚¯

åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ12ï¼‰

ä¸¡ã™ãã¿ã§å‡¦ç†ãŒåœæ¢ã™ã‚‹ã“ã¨ã‚‚ ãƒãƒƒã‚¯æ©Ÿèƒ½ã¯è¤‡æ•°ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒåˆ©ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¯ä¸å¯æ¬ ãªã®ã§ã™ãŒï¼Œæ–°ãŸãªå•é¡Œã®å…ƒã«ã‚‚ãªã‚Šã¾ã™ã€‚ãã‚Œã¯ã€Œãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã€ã¨å‘¼ã°ã‚Œã‚‹ç¾è±¡ã§ã™ã€‚ å…ˆã®éŠ€è¡Œå£åº§é–“ã®æŒ¯ã‚Šè¾¼ã¿ã®ä¾‹ã§æ¬¡ã®ã‚ˆã†ãªå ´åˆã‚’è€ƒãˆã¦ãã ã•ã„ï¼ˆå›³3[æ‹¡å¤§è¡¨ç¤º]ï¼‰ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³1ã¯ï¼Œå£åº§ç•ªå·10ã®å£åº§ã‹ã‚‰å£åº§ç•ªå·20ã®å£åº§ã«1ä¸‡å††ã‚’æŒ¯ã‚Šè¾¼ã‚‚ã†ã¨ã—ã¦ã„ã¾ã™ã€‚ä¸€æ–¹ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³2ã¯ï¼Œã“ã‚Œã¨ã¯é€†ã«å£åº§ç•ªå·20ã®å£åº§ã‹ã‚‰å£åº§ç•ªå·10ã®å£åº§ã«5000å††ã‚’æŒ¯ã‚Šè¾¼ã¿ã¾ã™ã€‚ã“ã“ã§ä»®ã«ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³1ãŒï¼Œ(1)å£åº§ç•ªå·10ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã—ã¦ã‹ã‚‰ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³2ãŒ(2)å£åº§ç•ªå·20ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã—ãŸã¨ã—ã¾ã—ã‚‡ã†ã€‚ã“ã®æ™‚ç‚¹ã§ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³1ã¯å£åº§ç•ªå·10ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³2ã¯å£åº§ç•ªå·20ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŽ’ä»–ãƒãƒƒã‚¯ã—ã¾ã™ã€‚ã“ã‚Œã‚‰ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒçµ‚äº†ã™ã‚‹ã¾ã§ãƒ

twainy 2007/11/25

ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ãŒç™ºç”Ÿã—ãªã„ã‚ˆã†ã€ä¸€ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«è¦ã™ã‚‹æ™‚é–“ã‚’ã§ãã‚‹ã ã‘çŸãã™ã‚‹ã®ãŒåŸºæœ¬ã§ã™

database
db

ãƒªãƒ³ã‚¯

åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ9ï¼‰

å›³10â—ãƒ¬ã‚³ãƒ¼ãƒ‰ãƒ»ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã®ä»•çµ„ã¿ã€‚ãƒãƒƒã‚·ãƒ¥å€¤ã«ã—ãŸãŒã£ã¦ï¼Œempã¨emp_histã®äºŒã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã§åŒã˜enoã‚’æŒã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸€ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã—ã¦ã„ã‚‹ RDBMSãŒå‚™ãˆã‚‹ã•ã¾ã–ã¾ãªé«˜é€ŸåŒ–æ‰‹æ³• RDBMSã¯ï¼Œã“ã“ã¾ã§èª¬æ˜Žã—ã¦ããŸåŸºæœ¬çš„ãªãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã®ã—ã‹ãŸã‚„æ“ä½œæ–¹æ³•ã«åŠ ãˆï¼Œé«˜é€ŸåŒ–ã®ãŸã‚ã®æ‰‹æ³•ã‚’ã„ã‚ã„ã‚ç”¨æ„ã—ã¦ã„ã¾ã™ã€‚Part2ã®æœ€å¾Œã«ï¼Œã“ã‚Œã‚‰ã®æ‰‹æ³•ã‚’ã–ã£ã¨ç´¹ä»‹ã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ â—ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ»ãƒãƒƒãƒ•ã‚¡ã®ã‚µã‚¤ã‚ºã‚„ä½¿ã‚ã‚Œæ–¹ã«ã‚‚ã‚ˆã‚Šã¾ã™ãŒï¼Œä¸€èˆ¬ã«Bãƒ„ãƒªãƒ¼ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦å·¨å¤§ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹éš›ã«ã¯ï¼Œãƒ«ãƒ¼ãƒˆãƒ»ãƒŽãƒ¼ãƒ‰ã ã‘ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ»ãƒãƒƒãƒ•ã‚¡ã«ã‚ã‚‹ã®ãŒæ™®é€šã§ã™ã€‚ãã®ãŸã‚ï¼Œãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãŸã©ã‚Šã¤ãã¾ã§ã«ãƒ–ãƒ©ãƒ³ãƒãƒ»ãƒŽãƒ¼ãƒ‰ï¼Œãƒªãƒ¼ãƒ•ãƒ»ãƒŽãƒ¼ãƒ‰ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ä½•å›žã‚‚ãƒ‡ã‚£ã‚¹ã‚¯ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã‚’1å›žã®ã‚¢ã‚¯ã‚»ã‚¹ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã§ãã‚‹ã‚ˆã†ã«ã—ã‚ˆ

twainy 2007/11/25

ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ãƒ»ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°(è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’åŒä¸€ãƒšãƒ¼ã‚¸ã«æ ¼ç´ã™ã‚‹)ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(å–ã‚Šå¾—ã‚‹å€¤ã®æ•°ãŒå°‘ãªã„ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦è¤‡é›‘ãªæ¤œç´¢ã‚’è¡Œã†)

database
db

ãƒªãƒ³ã‚¯

åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ5ï¼‰ï¼šITpro

SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹éš›ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’åŠã¼ã™ã‚‚ã®ã¨ã—ã¦ï¼Œã‚‚ã†ä¸€ã¤ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¯ï¼Œã©ã†å®šç¾©ã™ã¹ãã‹ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆä¸Šã®å•é¡Œã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æœ‰åŠ¹ã«ä½¿ã†ãŸã‚ã®SQLæ–‡ã‚’ã©ã†æ›¸ãã¹ãã‹ã¨ã„ã†ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ä¸Šã®å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆä¸Šã®å•é¡Œã‚’ä¸»ã«å–ã‚Šä¸Šã’ã¾ã™ã€‚SQLæ–‡ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«ã¤ã„ã¦ã¯å›²ã¿è¨˜äº‹ã€ŒSQLæ–‡ã‚’æœ€é€Ÿã«ã™ã‚‹11ã®ãƒã‚¤ãƒ³ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¤œç´¢é€Ÿåº¦ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ãã‚Œãžã‚Œã®SQLæ–‡ã«å¯¾ã—ã¦æœ€é©ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹ã®ãŒç†æƒ³çš„ã§ã™ãŒï¼Œå®Ÿéš›ã«ã¯ã‚ã‚‹ç¨‹åº¦é™ã‚‰ã‚ŒãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ï¼Œå¿…è¦ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¦ä»¶ã‚’æº€ãŸã™ã‚ˆã†ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŠ ãˆã¦ï¼Œã©ã‚“ãªSQLæ–‡ãŒå®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã®ã‹ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‹ã£ã¦ã„ãªã„å ´åˆã¯ï¼Œé©å½“ãªæƒ³å®šã«åŸºã¥ã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã—ã¦ãŠã‹ãªãã¦ã¯

twainy 2007/11/25

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ•°ã‚’åˆ¶é™ã™ã‚‹ã€‚WHEREã®å·¦è¾ºã§ç®—è¡“æ¼”ç®—åã‚„é–¢æ•°ã‚’ä½¿ã‚ãªã„ã€‚ã€Œå¾Œæ–¹ä¸€è‡´ã€æ¤œç´¢ã¯ãªã‚‹ã¹ãé¿ã‘ã‚‹ã€‚DISTINCTã®ä»£ã‚Šã«EXISTSã‚’ä½¿ã†ã€‚ç‰å·ã¨ä¸ç‰å·ã§ã¯ï¼Œç‰å·ã®ã¿ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®åˆ¥åã‚’åˆ©ç”¨ã™

database
db

ãƒªãƒ³ã‚¯

åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰

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

twainy 2007/11/25

åŠ¹çŽ‡ã®è‰¯ã„å®Ÿè¡Œè¨ˆç”»ã‚’ç«‹ã¦ã‚‹ã«ã¯ï¼Œå®šæœŸçš„ã«çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã™ã‚‹ã“ã¨ãŒé‡è¦ãªãƒã‚¤ãƒ³ãƒˆã¨ãªã‚Šã¾ã™ã€‚ãƒã‚¹ãƒˆãƒ»ãƒ«ãƒ¼ãƒ—çµåˆã€‚ãƒžãƒ¼ã‚¸çµåˆã€‚ãƒãƒƒã‚·ãƒ¥çµåˆ

database
db

ãƒªãƒ³ã‚¯

åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ3ï¼‰

å›³3â—Oracleä»˜å±žã®SQLï¼ŠPlusã§å®Ÿè¡Œè¨ˆç”»ã‚’è¡¨ç¤ºã—ãŸã¨ã“ã‚ã€‚ç”»é¢ä¸‹éƒ¨ã®ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã¯å›³2ã®ãƒ„ãƒªãƒ¼ã®è¦ªåé–¢ä¿‚ã‚’è¡¨ã—ã¾ã™ åŠ¹çŽ‡ã®è‰¯ã„å®Ÿè¡Œè¨ˆç”»ã‚’ä½œæˆã™ã‚‹ æ¬¡ã¯ï¼Œå®Ÿè¡Œè¨ˆç”»ã®ä½œæˆã§ã™ã€‚ã“ã¡ã‚‰ã‚‚ä¾‹ã‚’æŒ™ã’ã¦èª¬æ˜Žã—ãŸã»ã†ãŒã‚ã‹ã‚Šã‚„ã™ã„ã§ã—ã‚‡ã†ã€‚Oracleã«ä»˜å±žã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã®å¾“æ¥å“¡ãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆempï¼‰ã¨éƒ¨ç½²ãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆdeptï¼‰ã‹ã‚‰ï¼Œå¾“æ¥å“¡ã®ä¸€è¦§ã‚’å–ã‚Šå‡ºã™ä»¥ä¸‹ã®ã‚ˆã†ãªSQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã—ã¾ã™ã€‚ SELECT ename, job, sal, dname FROM emp, dept WHERE emp.deptno = dept.deptno ãƒ†ãƒ¼ãƒ–ãƒ«deptã§ã¯éƒ¨ç½²ç•ªå·deptnoãŒä¸»ã‚ãƒ¼ã§ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹pk_deptnoãŒå®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ä¸€æ–¹ãƒ†ãƒ¼ãƒ–ãƒ«empã§ã¯ï¼ŒdeptnoãŒå¤–éƒ¨ã‚ãƒ¼ï¼Š5ã«ãªã‚Šã¾ã™ãŒï¼Œã“ã‚Œã«å¯¾ã—ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®šç¾©ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ï¼Œã“ã®SQLæ–‡ã«å¯¾ã—ã¦ï¼ˆå›³2[æ‹¡

twainy 2007/11/25

å®Ÿè¡Œè¨ˆç”»ã®å‡ºã—æ–¹set autotrace traceonly exlpain;

database
db

ãƒªãƒ³ã‚¯

Home - SymmetricDS

Fast & Flexible Database Replication SymmetricDS is open source database replication software that focuses on features and cross platform compatibility.

twainy 2007/11/13

ã€ŽSymmetricDS is web-enabled, database independent, data synchronization softwareã€ä½¿ã†ã‹ã‚‰ã„ã¾ã™ãPostgreSQLã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ãã‚Œï¼ˆåˆ‡å®Ÿ

db

ãƒªãƒ³ã‚¯

ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãƒ‰ãƒƒãƒˆ ã‚¸ãƒ£ãƒ‘ãƒ³ | åæ’ƒã®ã®ã‚ã—ã‚’ä¸Šã’ã‚‹PostgreSQL

ã‚„ã‚„æ—§èžã«å±žã™ã‚‹ãŒ@ITã®è¨˜äº‹ã«ã‚ˆã‚‹ã¨ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¨ã—ã¦ãšã£ã¨MySQLã®å¾Œå¡µã‚’æ‹ã—ã¤ã¥ã‘ã¦ããŸPostgreSQLãŒã€æœ€è¿‘ã«ãªã£ã¦æ€¥é€Ÿã«å‹¢åŠ›ã‚’ä¼¸ã°ã—ã¦ã„ã‚‹ã¨è¨€ã†ã€‚2006å¹´ã®IOUGèª¿æŸ»ã§ã¯PostgreSQLã‚’ä½¿ã£ã¦ã„ã‚‹å‰²åˆã¯ã‚ãšã‹ã«9%ã ã£ãŸãŒã€2007å¹´10æœˆã«ç™ºè¡¨ã•ã‚ŒãŸæœ€æ–°ã®èª¿æŸ»çµæžœã§ã¯(ä¾ç„¶74%ã¯MySQLãƒ¦ãƒ¼ã‚¶ã§ã‚ã‚‹ã‚‚ã®ã®)PostgreSQLã®åˆ©ç”¨ã¯20%ã«ã¾ã§æ‹¡å¤§ã—ãŸãã†ã ã€‚ ã“ã‚Œã¯ã€é«˜é€ŸåŒ–ãªã©PostgreSQLãã®ã‚‚ã®ã®æ”¹è‰¯ãŒæ€¥ãƒ”ãƒƒãƒã§é€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã“ã¨ã«åŠ ãˆã€Sonyã‚„AppleãŒPostgreSQLãƒ™ãƒ¼ã‚¹ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã“ã¨ãŒçŸ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Š(æ—¥æœ¬ã ã¨R25.jpã‚‚)ã€çŸ¥ååº¦ãŒä¸ŠãŒã£ãŸã®ãŒä¸€å› ã ã¨è¨€ã†ã€‚ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„æ•™è‚²ç”¨æ›¸ç±ã‚’å……å®Ÿã•ã›ã¦ã„ãã®ãŒä»Šå¾Œã®èª²é¡Œã¨è€ƒãˆã‚‰ã‚Œã‚‹ã¨ã®ã“ã¨ã€‚

twainy 2007/11/13

ã¾ã˜ã§ã™ã‹ã€‚ãªã‚“ã¨ãªãæ—¥æœ¬ã§ã¯é€†ã®å°è±¡ãªã‚“ã§ã™ãŒ

db

ãƒªãƒ³ã‚¯

æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå¾Œç·¨ï¼‰

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

twainy 2007/09/18

DBã‚¢ã‚¯ã‚»ã‚¹æœ€é©åŒ–ã®ä»•çµ„ã¿

db

ãƒªãƒ³ã‚¯

DBã‚¢ã‚¯ã‚»ã‚¹ã®ãƒˆãƒ©ãƒ–ãƒ«ã¯çµ‚ç›¤ã§ç™ºè¦šã—ãŒã¡â€¦â€¦

ä»Šå›žã®æ¦‚è¦ æœ¬ç¨¿ã§ã¯ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§å®Ÿéš›ã«ç›´é¢ã—ãŸDBã‚¢ã‚¯ã‚»ã‚¹å‡¦ç†ã«é–¢ã™ã‚‹ã‚ˆãã‚ã‚‹ãƒˆãƒ©ãƒ–ãƒ«äº‹ä¾‹ã‚’é¡Œæã«ã€DBã‚¢ã‚¯ã‚»ã‚¹å‡¦ç†ã«é–¢ã™ã‚‹Tipsã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ä»Šæ—¥ã¯ã€å†…ç·šã§åŠ©ã‘ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ ã‚ã‚‹ç©ã‚„ã‹ãªæœã€çªç„¶é›»è©±ãŒé³´ã‚‹ã€‚ä»Šæ—¥ã®ç›¸æ‰‹ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ†ã‚¹ãƒˆã‚’å®Ÿæ–½ã—ã¦ã„ã‚‹ç¤¾å†…ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒžãƒãƒ¼ã‚¸ãƒ£ã§ã‚ã‚‹ã€‚ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ†ã‚¹ãƒˆã‚’å®Ÿæ–½ã—ã¦ã„ã‚‹ãŒã€ã„ãã¤ã‹ã®æ¥å‹™å‡¦ç†ã§ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒæ‚ªéŽãŽã¦å›°ã£ã¦ã„ã‚‹ã€‚ãƒªãƒªãƒ¼ã‚¹ã‚‚è¿‘ã„ã®ã§ã€æ—©æ€¥ã«ãªã‚“ã¨ã‹åŽŸå› ã‚’æŽ¢ã£ã¦ã»ã—ã„ã€ ã¨ã¯ã„ãˆã€ã•ã™ãŒã«ã“ã‚Œã ã‘ã®æƒ…å ±ã§ã¯ã€å•é¡Œã¯è§£æ±ºã§ããªã„ãŸã‚ã€ç›´æŽ¥ç¾å ´ã«æ€¥è¡Œã™ã‚‹ã“ã¨ã¨ãªã£ãŸã€‚ ç¾å ´ã«åˆ°ç€ã—ã€ãƒˆãƒ©ãƒ–ãƒ«ã®è©³ç´°ã‚’ç¢ºèª ç¾å ´ã«åˆ°ç€ã—ã€ã¾ãšã¯ç¾çŠ¶åˆ†æžã®ãŸã‚ã€æ‹…å½“è€…ã«ç°¡å˜ã«ãƒ’ã‚¢ãƒªãƒ³ã‚°ã‚’è¡Œã£ãŸã€‚ãƒ’ã‚¢ãƒªãƒ³ã‚°ã—ãŸçµæžœã‚’ã¾ã¨ã‚ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ãªçŠ¶æ³ã®ã‚ˆã†ã ã€‚ Javaã§é–‹ç™ºã—ã¦ã„ã‚‹Webã‚·ã‚¹ãƒ†ãƒ ã§ã€Webå±¤ã«ã¯Strut

twainy 2007/07/12

db

ãƒªãƒ³ã‚¯

ã‚¯ãƒªãƒªãƒ³ï¼‹ã‚»ãƒ«ï¼ã‚»ãƒ«ãƒªãƒ³

PS2ç”¨ã‚½ãƒ•ãƒˆã€Œãƒ‰ãƒ©ã‚´ãƒ³ãƒœãƒ¼ãƒ«Zã€ã‚ªãƒªã‚¸ãƒŠãƒ«ã‚ãƒ£ãƒ©ã®ã‚»ãƒ«ãƒªãƒ³ã§ã™ã€‚ ã‚¯ãƒªãƒªãƒ³ã®æ°—ã‚’å¸åŽã—ãŸçµæžœå¼±ä½“åŒ–ã—ã¦ã—ã¾ã†ã¨ã¯ãƒ»ãƒ»ãƒ»ã‚¯ãƒªãƒªãƒ³ãŒå¯æ„›ãã† å‹•ç”»æœ€å¾Œã®ãƒ¤ãƒ ãƒãƒ£ã¯å½¼ã®æ€¨éœŠã§ã™ã€‚

twainy 2007/03/11

DB

ãƒªãƒ³ã‚¯

ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç§»è¡Œè¨˜#2 VPNè¶Šã—ã®MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

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

twainy 2007/03/09

db
server

ãƒªãƒ³ã‚¯

not found

twainy 2006/12/27

ãƒªãƒ³ã‚¯

Web2.0ãƒŠãƒ“: SQL-DESIGNERãŒã‚¹ã‚´ã‚¤

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

twainy 2006/10/31

ãƒªãƒ³ã‚¯

http://www.wakhok.ac.jp/biblion/old/DB/DB.html

twainy 2006/09/18

db

ãƒªãƒ³ã‚¯

ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›

ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚

twainy 2006/09/18

db
book

ãƒªãƒ³ã‚¯

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

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

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

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

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

dbã«é–¢ã™ã‚‹twainyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (34)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

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

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

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹