[B! DB] mamatumoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mamatumo id:mamatumo

DBã«é–¢ã™ã‚‹mamatumoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

DB2ã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªï¼ã‚«ãƒ©ãƒ ã‚¹ãƒˆã‚¢DBã®å®Ÿè£…ã§ã€Œãƒã‚¤ãƒ–ãƒªãƒƒãƒ‰ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã«ãªã‚‹
2013å¹´4æœˆ4æ—¥ã€æ—¥æœ¬IBMã¯åŒç¤¾ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ãªã‚‹DB2 V10.5ã‚’ç™ºè¡¨ã—ãŸã€‚2013å¹´6æœˆ14æ—¥ã‹ã‚‰ã€æ—¥æœ¬IBMãŠã‚ˆã³ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼çµŒç”±ã§æä¾›ã‚’é–‹å§‹ã™ã‚‹äºˆå®šã€‚æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ç›®çŽ‰ã¯ã€BLUã‚¢ã‚¯ã‚»ãƒ©ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ†ã‚¯ãƒŽãƒã‚¸ã®å®Ÿè£…ã ã€‚ å¾“æ¥ã®åˆ—æŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã®æ©Ÿèƒ½ã‚’ãã®ã¾ã¾ã«ã€åŒä¸€ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ä¸Šã§ã‚«ãƒ©ãƒ åž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã§ãã€OLTPå‡¦ç†ã¨OLAPå‡¦ç†ã‚’å˜ä¸€ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ä¸Šã§å—ã‘æŒã¦ã‚‹ã€‚ åŠ ãˆã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ã€SIMDæ‹¡å¼µå‘½ä»¤ã‚»ãƒƒãƒˆã‚’æ´»ç”¨ã—ãŸä¸¦åˆ—å‡¦ç†ã‚’å®Ÿç¾ã—ã¦ãŠã‚Šã€ãƒ‡ãƒ¼ã‚¿é †åºã‚’ä¿æŒã—ãªãŒã‚‰ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã‚’è¡Œã†ç‹¬è‡ªã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ï¼ˆã‚¢ã‚¯ã‚·ãƒ§ãƒŠãƒ«ãƒ–ã‚³ãƒ³ãƒ—ãƒ¬ãƒƒã‚·ãƒ§ãƒ³ï¼‰ã‚„ã€åŠ¹çŽ‡çš„ãªãƒ‡ãƒ¼ã‚¿ã‚¹ã‚ãƒ£ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ã‚ãƒƒãƒ”ãƒ³ã‚°ã¨ä½µã›ã¦ã€é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿åˆ†æžå‡¦ç†ãŒå¯èƒ½ã«ãªã£ã¦ã„ã‚‹ã¨ã„ã†ã€‚
mamatumo 2013/04/04
DB
ãƒªãƒ³ã‚¯
é«˜é€Ÿãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’ã†ãŸã†SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒVoltDB 3.0ã€ãƒªãƒªãƒ¼ã‚¹ | OSDN Magazine
ç±³VoltDBã¯1æœˆ22æ—¥ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã€ŒVoltDB 3.0ã€ã‚’å…¬é–‹ã—ãŸã€‚ã‚¯ãƒ©ã‚¹ã‚¿ç’°å¢ƒã«ãŠã‘ã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®æ”¹å–„ã«ã‚ˆã‚Šã€ã•ã‚‰ã«ä½Žé…å»¶ã‚’å®Ÿç¾ã™ã‚‹ã¨ã„ã†ã€‚ VoltDBã¯ã€ã€ŒPostgresã€ã‚„ã€ŒIngresã€ãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’æ‰‹ãŒã‘ãŸMichael Stonebrakeræ°ãŒè¨è¨ˆã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚é«˜é€Ÿãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’ç‰¹å¾´ã¨ã—ã€ACIDã«éµå®ˆã—ãŸæ¬¡ä¸–ä»£ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ¨™æ¦œã—ã¦ã„ã‚‹ã€‚GPLv3ã§å…¬é–‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆï¼ˆCommunity Editionï¼‰ã¨ã€ã‚µãƒ–ã‚¹ã‚¯ãƒªãƒ—ã‚·ãƒ§ãƒ³å½¢å¼ã®å•†ç”¨ç‰ˆï¼ˆEnterprise Editionï¼‰ã®2ã¤ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0ã¯2011å¹´9æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³2.0ä»¥æ¥ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒªãƒªãƒ¼ã‚¹ã€‚æ€§èƒ½å´ã§ã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å†è¨è¨ˆã—ã€ã‚¯ãƒ©ã‚¹ã‚¿ã«ãŠã‘ã‚‹
mamatumo 2013/02/06
DB
ãƒªãƒ³ã‚¯
syboos.jp
mamatumo 2012/03/15
DB

jdbc

BoneCP
ãƒªãƒ³ã‚¯
Commons DBCP ã®ãƒ¡ãƒ¢
Author : snbhsmt at ps dot ksky dot ne dot jp Last-Modified : 2004/06/29 16:00 JST Commons DBCP ã«ã¤ã„ã¦ Commons DBCP (Database Connection Pool API) ã¯ã€JDBC ã‚’åˆ©ç”¨ã—ã¦ DB ã¨ã®æŽ¥ç¶šã® ãƒ—ãƒ¼ãƒªãƒ³ã‚°æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã€‚ å®Ÿéš›ã®ãƒ—ãƒ¼ãƒªãƒ³ã‚°æ©Ÿèƒ½ã¯ Jakarta Commons Pool API ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã€‚ è©³ç´°ã¯ã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–å†…ã® README.txt ã‚„ docs/ å†…ã®ã‚½ãƒ¼ã‚¹ã€ ã‚ã‚‹ã„ã¯ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ç‰ã‚’å‚ç…§ã€‚ Jakarta Commons DBCP Home (æ—¥æœ¬èªžè¨³) http://jakarta.terra-intl.com/commons/dbcp.html Jakarta Commons DBCP 1.0
mamatumo 2011/11/03
apache

DB

commons
ãƒªãƒ³ã‚¯
Commons DBCP
Commons DBCP ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’æ‰±ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ Tomcat ã§æ¨™æº–æŽ¡ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ å‹•ä½œèª¬æ˜Ž å‹•ä½œã‚’ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰æŽ¥ç¶šè¦æ±‚ãŒç™ºç”Ÿã—ãŸå ´åˆ â€¦ getConnection() 1. DBCPã¯ã€ãƒ—ãƒ¼ãƒ«å†…ã«ç©ºãæŽ¥ç¶šãŒã‚ã‚‹ã‹ç¢ºèª 2. ã‚ã‚Œã°ãã‚Œã‚’è¿”ã™ã€‚ã“ã®æ™‚ãã®æŽ¥ç¶šã¯ ã‚¢ã‚¯ãƒ†ã‚£ãƒ– ã¨ãªã‚‹ 3. ãƒ—ãƒ¼ãƒ«å†…ã«ç©ºãæŽ¥ç¶šãŒç„¡ã‘ã‚Œã°ã€æ–°ãŸã«æŽ¥ç¶šã‚’ä½œã£ã¦è¿”ã™ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰åˆ‡æ–è¦æ±‚ãŒç™ºç”Ÿã—ãŸå ´åˆ â€¦ conn.close() 1. åˆ‡æ–è¦æ±‚ã®ã‚ã£ãŸæŽ¥ç¶šã‚’ãƒ—ãƒ¼ãƒ«å†…ã«ä¿ç®¡ã™ã‚‹ã€‚ã“ã®æ™‚ãã®æŽ¥ç¶šã¯ ã‚¢ã‚¤ãƒ‰ãƒ« ã¨ãªã‚‹ 2. ã‚‚ã—ãƒ—ãƒ¼ãƒ«å†…ã« maxIdle ä»¥ä¸Šã®æŽ¥ç¶šãŒæºœã¾ã£ãŸã‚‰ã€ãã‚Œä»¥ä¸Šã«ãªã‚‰ãªã„ã‚ˆã†ã«æŽ¥ç¶šã‚’å‰Šé™¤ã™ã‚‹ æŽ¥ç¶šç›£è¦–ã‚¹ãƒ¬ãƒƒãƒ‰ DBCPã«ã¯æŽ¥ç¶šç›£è¦–ã‚¹ãƒ¬ãƒƒãƒ‰ã¨ã„ã†ã‚‚ã®ãŒå˜åœ¨ã—ã¾ã™ã€‚ ã“ã‚Œã¯ä¸€å®šæ™‚é–“æ¯Žã«ãƒ—ãƒ¼ãƒ«å†…ã®ã‚¢ã‚¤ãƒ‰ãƒ«æŽ¥ç¶šã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‚‚
mamatumo 2011/11/03
apache

DB

commons
ãƒªãƒ³ã‚¯
Commons DBCPã‚’ä½¿ã£ã¦ã¿ã‚‹ - Murayama blog.
Commons DBCPã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ã¡ã‚‡ã£ã¨å‰ç½®ãã‹ã‚‰ã‚¹ã‚¿ãƒ¼ãƒˆã—ã¾ã™ã€‚ Connectionã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ç”Ÿæˆã«ã¤ã„ã¦ Javaã¯ã€DBã¨ã®æŽ¥ç¶šã‚’java.sql.Connectionåž‹ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦å–ã‚Šæ‰±ã„ã¾ã™ã€‚ JDBCãƒ‰ãƒ©ã‚¤ãƒã‚’ä½¿ã£ãŸä¸€èˆ¬çš„ãªãƒ—ãƒã‚°ãƒ©ãƒ ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521/ORCL", "scott", "tiger"); Connectionã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ç”Ÿæˆã«ã‹ã‹ã‚‹è² è· ä¸Šè¨˜ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®å ´åˆã€ Connection con = DriverManager.getConnection( "jdbc:o
mamatumo 2011/11/03
apache

DB

commons
ãƒªãƒ³ã‚¯
DBViewer Plugin for Eclipse
DBViewer Plugin 1.2.1.v20100421 Released. 2010.04.21New DBViewer Plugin 1.2.0.v20091112 Released. 2009.11.12 DBViewer Plugin 1.1.0.v20090121 Released. 2009.01.21 DBViewer Plugin 1.0.9.v20080914 Released. 2008.09.14 User's Manual "Capter 3:Registrateion of Database Define. And Connect Database" (PDF,94KB) 2008.07.11 User's Manual "Capter 2:Open DBViewer Perspective." (PDF,58KB) 2008.07.11 User's Ma
mamatumo 2011/10/17
Eclipse

DB
ãƒªãƒ³ã‚¯
eclipsewiki.netÂ -Â eclipsewiki ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
mamatumo 2011/10/17
Eclipse

DB
ãƒªãƒ³ã‚¯
Rapid SQL Developerã«ã‚ˆã‚‹ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ãƒ‡ãƒãƒƒã‚°
Rapid SQL Developerã«ã‚ˆã‚‹ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ãƒ‡ãƒãƒƒã‚° By: Kenji Umeda Abstract: Rapid SQL Developerã«ã‚ˆã‚‹ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒãƒ¼ã‚¸ãƒ£ã®ãƒ‡ãƒãƒƒã‚°ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ Rapid SQL Developerã¯ã€Eclipseãƒ™ãƒ¼ã‚¹ã®SQL IDEã§ã€ç›´æ„Ÿçš„ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã‚’æŒã¡ã€ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ç®¡ç†ã€SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã€æ§‹æ–‡ãƒã‚§ãƒƒã‚¯ã€ã‚¯ã‚¤ãƒƒã‚¯ä¿®æ£ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã€SQLãƒ‡ãƒãƒƒã‚°ã¨ã„ã£ãŸSQLé–‹ç™ºã‚’æ”¯æ´ã™ã‚‹å¼·åŠ›ãªæ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ ç‰¹ã«SQLãƒ‡ãƒãƒƒã‚°æ©Ÿèƒ½ã§ã¯ã€ä¸»ã«ä»¥ä¸‹ã®ï¼’é€šã‚Šã®ãƒ‡ãƒãƒƒã‚°æ–¹æ³•ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ (1) ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã€ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€ãƒˆãƒªã‚¬ãƒ¼ãªã©ã®ãƒ—ãƒã‚°ãƒ©ãƒ å¯èƒ½ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ãƒ‡ãƒãƒƒã‚° (2)Javaãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ã‚·ãƒ¼ãƒ ãƒ¬ã‚¹ã«(1)ã¸ã‚¹ãƒ†ãƒƒãƒ—ã‚¤ãƒ³ã—ã€å†åº¦Javaã‚³ãƒ¼ãƒ‰ã¸æˆ»ã‚‹ (ã“ã“ã§ã¯ã€Java-To
mamatumo 2011/10/14
Eclipse

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å·®åˆ†è¡¨ç¤ºÂ·DiffKit MOONGIFT
DiffKitã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹/CSVãƒ•ã‚¡ã‚¤ãƒ«é–“ã®å·®åˆ†ã‚’æŠ½å‡ºã™ã‚‹ã€‚ [/s2If] DiffKitã¯Javaè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚é©åˆ‡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚’è¡Œã£ã¦ã„ãªã„çŠ¶æ…‹ã§é‹ç”¨ã‚’ç¶šã‘ã¦ã„ã‚‹ã¨ã€ã„ã¤ã®é–“ã«ã‹é–‹ç™ºç’°å¢ƒã¨å®Ÿè¡Œç’°å¢ƒã§æ§‹é€ ã®ä¸ä¸€è‡´ãŒãŠã“ã‚‹ã€‚ã‚«ãƒ©ãƒ ã®é †ç•ªãŒé•ã†ç¨‹åº¦ãªã‚‰ã„ã„ãŒã€ãªãœã‚ã‚‹ã®ã‹åˆ†ã‹ã‚‰ãªã„ã‚«ãƒ©ãƒ ãŒå‡ºã¦ããŸã‚Šã™ã‚‹ã¨åŽ„ä»‹ã ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ä¸ä¸€è‡´ã¯æ§˜ã€…ãªå•é¡Œã‚’å¼•ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚æ—©ã‚ã®å¯¾å‡¦ãŒå¿…è¦ã ã€‚ãã®ãŸã‚ã«ã¯ã¾ãšç¾çŠ¶åˆ†æžã‚’è¡Œã†å¿…è¦ãŒã‚ã‚‹ã ã‚ã†ã€‚æ‰‹ä½œæ¥ã§è¡Œã†å¿…è¦ã¯ãªã„ã€DiffKitã‚’ä½¿ãˆã°å®¹æ˜“ã«çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ DiffKitã¯äºŒã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–“ã«ãŠã‘ã‚‹æ§‹é€ ä¸ä¸€è‡´ã‚’è¡¨ç¤ºã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã ã€‚Diffãƒ„ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰ˆã¨ã‚‚ã„ãˆã‚‹ã€‚ç‰¹å¾´ã¨ã—ã¦JDBCã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ä»–ã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã“ã¨ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã€‚ç‰‡æ–¹ãŒCSVã€ç‰‡æ–¹ãŒãƒ‡ãƒ¼
mamatumo 2011/06/02
oracle

Java

DB
ãƒªãƒ³ã‚¯
1