[B! database] yohjizzz-backupã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yohjizzz-backup id:yohjizzz-backup

databaseã«é–¢ã™ã‚‹yohjizzz-backupã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

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

erd
ãƒªãƒ³ã‚¯
ER Master
<body> <span>ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ å¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã”è¦§ãã ã•ã„ã€‚</span> </body>
yohjizzz-backup 2010/02/20
ã‹ãªã‚Šä½¿ãˆã‚‹ï¼

ermaster

database

eclipseplugin

erd
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
yohjizzz-backup 2010/01/22
kvs

cloud

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

erd

database
ãƒªãƒ³ã‚¯
ITã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã®ã€Œã‚„ã£ã¦ã¯ã„ã‘ãªã„ã€ï¼šITpro
ITã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆãŒçŸ¥ã£ã¦ãŠãã¹ãã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å¾¹åº•è§£èª¬ æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚„å®Ÿè£…æ–¹å¼ã‚’æ±ºå®šã™ã‚‹ITã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ï¼Œãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãªã©ï¼Œã•ã¾ã–ã¾ãªæŠ€è¡“åˆ†é‡Žã®çŸ¥è˜ã‚’æŒã¡ï¼Œå…¨ä½“æœ€é©ã§ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’æˆåŠŸã«å°Žã‹ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ã—ã‹ã—ãã“ã«ã¯ï¼Œã¤ã„é™¥ã‚ŠãŒã¡ãªã€Œã‚„ã£ã¦ã¯ã„ã‘ãªã„ã“ã¨ã€ï¼ˆã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ï¼‰ãŒï¼Œæ•°å¤šãæ½œã‚“ã§ã„ã‚‹ã€‚ãã“ã§ã“ã“ã§ã¯ï¼ŒITã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆãŒçŸ¥ã£ã¦ãŠãã¹ãã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’è§£èª¬ã™ã‚‹ã€‚ãƒ†ãƒ¼ãƒžã”ã¨ã«ã€Œã©ã‚Œãã‚‰ã„ã‚„ã£ã¦ã¯ã„ã‘ãªã„ã‹ã€ã®ãƒ¬ãƒ™ãƒ«ã‚‚è¡¨ã—ãŸã€‚ãƒ¬ãƒ™ãƒ«3ï½žãƒ¬ãƒ™ãƒ«1ã®3æ®µéšŽã‚ã‚Šï¼Œãƒ¬ãƒ™ãƒ«ã®æ•°å—ãŒå¤§ãã„ã»ã©ï¼Œã‚„ã£ã¦ã¯ã„ã‘ãªã„åº¦åˆã„ã‚‚å¤§ãã„ã€‚ é–¢é€£ã‚µã‚¤ãƒˆï¼š â– æ©Ÿå™¨å¢—è¨ç·¨ â– æ¥å‹™åˆ†æžç·¨ â– Windows 7ç·¨ â– Android/iPhoneç·¨ â– ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚¯ãƒ©ã‚¦ãƒ‰ç·¨ â– ãƒ‘ãƒ–ãƒªãƒƒã‚¯ã‚¯ãƒ©ã‚¦ãƒ‰ç·¨ â– æ¬¡ä¸–ä»£DBç·¨ â– é‹ç”¨ç®¡ç†ç·¨ â– ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ç·¨ â– ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç·¨
yohjizzz-backup 2009/06/04
database

architecture
ãƒªãƒ³ã‚¯
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ç³»ã¯ãƒ–
yohjizzz-backup 2009/05/13
oracle

postgresql

mysql

sql

database
ãƒªãƒ³ã‚¯
1