[B! DB] MAXIMUM-PROã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

MAXIMUM-PRO id:MAXIMUM-PRO

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

Mac/Windows/Linuxã§åˆ©ç”¨å¯èƒ½ãªDBå°‚ç”¨GUIãƒ„ãƒ¼ãƒ«ã€Ž0xDBEã€ã«ã¤ã„ã¦ | DevelopersIO
ã“ã‚Œã¾ã§ã«ã€(ä¸»ã«)Amazon Redshiftã§æ´»ç”¨å‡ºæ¥ã‚‹GUIãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€ŽIntellij IDEA Ultimate Editionã€ã‚„ã€ŽAginityã€ç‰ã‚’ç´¹ä»‹ã—ã¦æ¥ã¾ã—ãŸãŒã€Intellij IDEAã‚’é–‹ç™ºã—ã¦ã„ã‚‹JetBrainç¤¾ã‹ã‚‰åˆ¥ç¨®ã®DBé–¢é€£ãƒ„ãƒ¼ãƒ«ãŒé–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†æƒ…å ±ã‚’å…ˆæ—¥çŸ¥ã‚Šã¾ã—ãŸã€‚ Amazon Redshiftã®Mac OS Xå‘ã‘GUIãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€ŽIntellij IDEA Ultimate Editionã€ã®Database Toolsã‚’ä½¿ã† ï½œ Developers.IO Redshiftå°‚ç”¨ Windows GUIãƒ„ãƒ¼ãƒ«ã€ŽAginity Workbench for Amazon Redshiftã€ãŒä¾¿åˆ©ã‹ã‚‚ã—ã‚Œãªã„ä»¶ ï½œ Developers.IO ãã‚ŒãŒã“ã®ã€Ž0xDBEã€ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ã‚¢ãƒŠã‚¦ãƒ³ã‚¹è‡ªä½“ã¯1å¹´ä»¥ä¸Šå‰ã‹ã‚‰ãªã•ã‚Œã¦ã„ãŸæ§˜ã§ã€
MAXIMUM-PRO 2015/07/29
GUI

DB

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
10åˆ†ã§åˆ†ã‹ã‚‹rè¨€èªžå…¥é–€ver2.5
3. ãŠçŸ¥ã‚‰ã› Rãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼š (11/29 - 30 @çµ±æ•°ç ”) http://prcs.ism.ac.jp/useRjp/ Japan.R (12/7 @ãƒ¤ãƒ•ãƒ¼) http://atnd.org/events/44682 13å¹´11æœˆ9æ—¥åœŸæ›œæ—¥
MAXIMUM-PRO 2014/03/12
DB

R
ãƒªãƒ³ã‚¯
DB tech showcaseï¼š å™‚ã®MongoDBãã®ç”¨é€”ã¯ï¼Ÿ
19. Mongo DBã®Index å•†å“å ãƒœãƒ¼ãƒ«ãƒšãƒ³ ã‚¿ã‚° å€¤æ®µ æ—¥ç”¨å“, ç†è¨˜ç”¨å…· 198 åŒ…ä¸ æ—¥ç”¨å“, åˆƒç‰©, ã‚ãƒƒãƒãƒ³ 2980 ãƒãƒŠãƒŠ é£Ÿæ–™å“, æžœç‰© 348 ã»ã†ã‚Œã‚“è‰ é£Ÿæ–™å“, é‡Žèœ 98 ç‰›ä¹³ é£Ÿæ–™å“, 148 é£Ÿæ–™å“ã§200ä»¥ä¸‹ã®å•†å“ã‚’å–å¾— 20. Mongo DBã®Index å•†å“å ã‚¿ã‚° å€¤æ®µ ãƒœãƒ¼ãƒ«ãƒšãƒ³ æ—¥ç”¨å“, ç†è¨˜ç”¨å…· 198 åŒ…ä¸ æ—¥ç”¨å“, åˆƒç‰©, ã‚ãƒƒãƒãƒ³ 2980 ãƒãƒŠãƒŠ é£Ÿæ–™å“, æžœç‰© 348 ã»ã†ã‚Œã‚“è‰ é£Ÿæ–™å“, é‡Žèœ 98 ç‰›ä¹³ é£Ÿæ–™å“, 148 å•†å“ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE å•†å“ ( id INT PRIMARY, å•†å“å VARCHAR(100) ); ã‚¿ã‚°ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE ã‚¿ã‚° ( å•†å“id INT, ã‚¿ã‚°å VARCHAR(100), å€¤æ®µ INT, KEY(ã‚¿ã‚°å,å€¤æ®µ) ); é£Ÿæ–™å“ã§200ä»¥ä¸‹ã®å•†å“ å•†å“
MAXIMUM-PRO 2013/11/19
DB
ãƒªãƒ³ã‚¯
FuelPHPã§ã‚»ãƒ¬ã‚¯ãƒˆãƒœãƒƒã‚¯ã‚¹ã‚’è¡¨ç¤ºã™ã‚‹
ä»•äº‹ã§FuelPHPã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã€è©¦è¡ŒéŒ¯èª¤ã—ãªãŒã‚‰ã‚‚ç‰©ã‚’ä½œã£ã¦ã„ã£ã¦ã„ã¾ã™ã€‚ å…¥åŠ›ã§å¿…è¦ã¨ãªã‚‹ã‚»ãƒ¬ã‚¯ãƒˆãƒœãƒƒã‚¯ã‚¹ã§ã™ãŒã€é¸æŠžã™ã‚‹å€¤ãŒDBã‹ã‚‰å–å¾—ã—ãŸã‚‚ã®ã®å ´åˆãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ãã‚“ãªå ´åˆã®DBãŠã‚ˆã³PHPã€HTMLã®è¨˜è¿°ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãšã¯ä»Šå›žä½œã‚‹ã‚‚ã®ã«å¿…è¦ãªã‚‚ã®ã‚’ä¸‹è¨˜ã«è¨˜è¼‰ã—ã¦ã„ãã¾ã™ã€‚ ãƒ†ã‚¹ãƒˆç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ [SQL] CREATE DATABSES `test` DEFAULT CHARACTER SET utf8; [/SQL] ãƒ†ã‚¹ãƒˆç”¨ãƒ†ãƒ¼ãƒ–ãƒ« [SQL] CREATE TABLE `selects` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `value` varchar(128) DEFAULT NULL, `delete` int(1) unsigned DEFAULT â€˜0â€™, PRIMARY KE
MAXIMUM-PRO 2013/09/25
FuelPHP

DB
ãƒªãƒ³ã‚¯
Rediså…¥é–€ (å…¨14å›ž) - ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãªã‚‰ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚µãƒ¼ãƒãƒ¼ã¨ã‚‚å‘¼ã°ã‚Œã‚‹ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Redisã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚
MAXIMUM-PRO 2013/07/10
redis

DB
ãƒªãƒ³ã‚¯
memcachedã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—phpã‹ã‚‰ä½¿ç”¨ã™ã‚‹ - é©å½“ãªæ—¥ã€…
ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã§webã®ä»•äº‹ã‚’ã—ãªãŒã‚‰webã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã‚’ä½œã£ãŸã‚Šä½œã‚‰ãªã‹ã£ãŸã‚Šã€æˆé•·ã¨æŒ«æŠ˜ã®è¨˜éŒ²ãƒ»ãƒ»ãƒ»ã‹ã‚‚ã—ã‚Œãªã„é©å½“ãªæ—¥ã€… ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã§webã®ä»•äº‹ã‚’ã—ãªãŒã‚‰webã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã‚’ä½œã£ãŸã‚Šä½œã‚‰ãªã‹ã£ãŸã‚Šã€æˆé•·ã¨æŒ«æŠ˜ã®è¨˜éŒ²ãƒ»ãƒ»ãƒ»ã‹ã‚‚ã—ã‚Œãªã„ ã‚µãƒ¼ãƒãƒ¼ã«memcachedã‚’å…¥ã‚Œã¦phpã‹ã‚‰ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã‚ã£ãŸã®ã§ã€ä»Šæ›´ã ã‘ã©ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ¡ãƒ¢ã€‚ memcachedã¨ã¯ä½•ã‹ã¨ã„ã†ã¨ã€ç‹¬ç«‹ã—ãŸã‚µãƒ¼ãƒãƒ—ãƒã‚°ãƒ©ãƒ ã§ã€ãƒ¡ãƒ¢ãƒªä¸Šã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ¡ãƒ¢ãƒªç©ºé–“ã‚’ä½¿ç”¨ã™ã‚‹ã®ã§ã€ã¨ã«ã‹ããƒ‡ãƒ¼ã‚¿ã®å‘¼ã³å‡ºã—ãŒDBã¨æ¯”è¼ƒã—ã¦æ ¼æ®µã«æ—©ã„ã§ã™ã€‚ ã“ã“ã§ã¯ã€ãƒ‡ãƒ¼ãƒ¢ãƒ³ã¨ã—ã¦å¸¸é§ã™ã‚‹memcachedã¨phpã‹ã‚‰æ“ä½œã™ã‚‹ç‚ºã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹Memcacheãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ã¾ãšã¯ã€memcachedã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« wget http://www.danga.com/memcached/di
MAXIMUM-PRO 2013/01/07
DB

php

memcached
ãƒªãƒ³ã‚¯
MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®š - ã¨ã¿ãžãƒ¼ãƒŽãƒ¼ãƒˆ
1.2 ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å‹•ä½œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æœ€åˆã«DBã®å†…å®¹ã‚’åŒæœŸã•ã›ãŸå¾Œã€Masterã‚µãƒ¼ãƒãƒ¼ã§å®Ÿè¡Œã•ã‚ŒãŸæ›´æ–°ç³»ã®ã‚¯ã‚¨ãƒª(UPDATEã¨ã‹)ã‚’Slaveã«æ¸¡ã—ã¦Slaveã§ã‚‚åŒã˜ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦ã„ãã“ã¨ã§ã€DBã‚’åŒæœŸã•ã›ã¦ã„ã‚‹(å›³1)ã€‚ Masterå´ã§å®Ÿè¡Œã•ã‚ŒãŸæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã«è“„ãˆã‚‰ã‚Œã¦ãŠã‚Šã€Slaveå´ãŒæŽ¥ç¶šã—ã¦ããŸã‚‰ã€å‰å›žã®æŽ¥ç¶šã‹ã‚‰ã®å¤‰æ›´åˆ†ã‚’Slaveå´ã«é€ä¿¡ã™ã‚‹ã€‚Slaveå´ã¯å—ã‘å–ã£ãŸã‚¯ã‚¨ãƒªã‚’ä¸€æ—¦ãƒªãƒ¬ãƒ¼ãƒã‚°ã«è“„ãˆã¦é †æ¬¡ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦DBã‚’åŒæœŸã•ã›ã¦ã„ãã€‚ãƒªãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‹•ä½œã«ã¯BinlogDump,I/O,SQLã®3ã¤ã®ã‚¹ãƒ¬ãƒƒãƒ‰ãŒé€£æºã—ã¦å‹•ä½œã™ã‚‹ã€‚ 2.è¨å®šæ‰‹é † (Master-Slaveæ§‹æˆ) 2.1 Masterå´ã®è¨å®šã®ç¢ºèªMasterå´ã§ã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æŽ¡å–ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚‹ã®ã§ã€Masterå´ã®my.cnfã«log-binã®è¨å®šãŒå…¥ã£ã¦ã„ã‚‹ã“ã¨ã‚’ç¢º
MAXIMUM-PRO 2012/07/17
mysql

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

DB
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªã®æ”¹å–„ã«ã€‚MySQLã®Slow Query Logã‚’å¯è¦–åŒ–ã™ã‚‹Â·MySQL slow-query-log Visualizer MOONGIFT
MySQL slow-query-log Visualizerã¯MySQLã®æ™‚é–“ã®ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªã‚’Webä¸Šã§é–²è¦§ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ MySQLã«ã¯å®Ÿè¡Œæ™‚é–“ã®é…ã„ã‚¯ã‚¨ãƒªã‚’ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã™æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚å˜ç´”ã«ãƒ†ã‚ã‚¹ãƒˆã«åã‹ã‚Œã‚‹ã ã‘ãªã®ã§åˆ†æžã«æ™‚é–“ãŒã‹ã‹ã£ã¦ã—ã¾ã†ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã“ã§ä½¿ã£ã¦ã¿ãŸã„ã®ãŒWebãƒ–ãƒ©ã‚¦ã‚¶ãƒ™ãƒ¼ã‚¹ã®è§£æžã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢MySQL slow-query-log Visualizerã§ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿é‡ãŒå¤šããªã„ã¨ã‚ã¾ã‚Šé¢ç™½ããªã„ã§ã™ãã€‚ å…¬å¼ã‚µã‚¤ãƒˆã‚ˆã‚Šã€‚æ›œæ—¥ã”ã¨ã«ç™ºç”Ÿå›žæ•°ã‚’ã‚°ãƒ©ãƒ•åŒ–ã—ã¦ã„ã¾ã™ã€‚ ã‚¯ã‚¨ãƒªãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’Webãƒ–ãƒ©ã‚¦ã‚¶ã®ç”»é¢ã«ãƒ‰ãƒãƒƒãƒ—ã™ã‚‹ã ã‘ã§è§£æžå‡¦ç†ãŒè¡Œã‚ã‚Œã¾ã™ã€‚ãã®çµæžœã¯ã‚°ãƒ©ãƒ•ã«æã‹ã‚Œã‚‹ä»•çµ„ã¿ã§ã™ã€‚ã¾ãŸã€ã‚¯ã‚¨ãƒªã¯ä¸€è¦§ã§è¡¨ç¤ºã•ã‚Œã€ä»»æ„ã®æ–‡å—ã§ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚æ›œæ—¥ã¨æ™‚é–“ã«ã‚ˆã£ã¦åˆ†æžã•ã‚Œã‚‹ã®ã§å¯¾å¿œã™ã¹ããƒã‚¤ãƒ³ãƒˆãŒåˆ†ã‹ã‚Šã‚„ã™ããª
MAXIMUM-PRO 2012/06/19
mysql

db
ãƒªãƒ³ã‚¯
DB-ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼°ï¼¬ï¼ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ä»˜ãã®å®Ÿè·µçš„ãªï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ ï¼°ï¼¬ï¼ï¼³ï¼±ï¼¬ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚
MAXIMUM-PRO 2012/01/08
ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

Oracle

DB
ãƒªãƒ³ã‚¯
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
MAXIMUM-PRO 2011/10/29
é–‹ç™º

eclipse

DB

java
ãƒªãƒ³ã‚¯
1