[B! database] diary193ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Cloud Spanner ã¨ CAP å®šç† | Google Cloud å…¬å¼ãƒ–ãƒã‚°

ã‚°ãƒãƒ¼ãƒãƒ«ã«åˆ†æ•£åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã„ã€ãƒ‡ãƒ¼ã‚¿ã®ä¸€è²«æ€§ã‚’ç¶æŒã—ãªãŒã‚‰é«˜å¯ç”¨æ€§ã‚’ã‚‚å®Ÿç¾ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€ãã‚Œã¯ç°¡å˜ãªã“ã¨ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚¯ãƒ©ã‚¦ãƒ‰ã®è‰¯ã„ã¨ã“ã‚ã¯ã€èª°ã‹ãŒãã‚Œã‚’æ§‹ç¯‰ã—ã¦ã€èª°ã«ã§ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¦ãã‚Œã‚‹ã“ã¨ã§ã™ã€‚ CAP å®šç†ã«ã‚ˆã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ä»¥ä¸‹ã® 3 ã¤ã®æœ›ã¾ã‚Œã‚‹ç‰¹æ€§ã®ã†ã¡ã€2 ã¤ã¾ã§ã—ã‹æŒã¦ãªã„ã¨ã‚ã‚Šã¾ã™ã€‚ Cï¼ˆConsistencyï¼‰: ä¸€è²«æ€§ã€å…±æœ‰ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒå”¯ä¸€ã®å€¤ã‚’æŒã¤ Aï¼ˆAvailabilityï¼‰: å¯ç”¨æ€§ã€èªã¿è¾¼ã¿ã¨æ›¸ãè¾¼ã¿ã®ä¸¡æ–¹ã§ 100% ã®å¯ç”¨æ€§ãŒç¢ºä¿ã•ã‚Œã¦ã„ã‚‹ Pï¼ˆPartition Toleranceï¼‰: åˆ†æ–è€æ€§ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®åˆ†æ–ã«å¯¾ã™ã‚‹è€æ€§ãŒã‚ã‚‹ã“ã“ã‹ã‚‰å°Žã‹ã‚Œã‚‹ã‚·ã‚¹ãƒ†ãƒ ã¯ 3 ç¨®é¡žã§ã€é™¤ãæ–‡å—ã«å¿œã˜ã¦ CAã€CPã€AP ã¨ãªã‚Šã¾ã™ã€‚ã“ã‚Œã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã®è¨è¨ˆè€…ã« 3 ã¤ã‹ã‚‰ 2 ã¤ã‚’é¸ã¶ã“ã¨ã‚’å¼·ã„ã‚‹ã‚‚ã®ã§ã¯ãªãã€å®Ÿéš›å¤šãã®ã‚·

diary193 2017/04/04

ãƒªãƒ³ã‚¯

Spanner

Register today for an exclusive live webinar on Databases Roadmap 2024. Learn about the latest innovations and plans for Google Cloud databases.

diary193 2017/03/30

ãƒªãƒ³ã‚¯

ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ - MySQL/Redis/MongoDB/Redshift

æœ€è¿‘ç™ºå£²ã•ã‚ŒãŸæŠ€è¡“è©•è«–ç¤¾ã®ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ã«å¯„ç¨¿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€Mongo DBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ æŠ€è¡“ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„ãƒ—ãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€Mongo DBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚è¨˜äº‹ã‚’å¯„ç¨¿ã—ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚è‡ªåˆ†ãŒå„æŠ€è¡“ã‚’ç¾æ™‚ç‚¹ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„å†…å®¹ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ»MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™

diary193 2014/03/25

aws
database

ãƒªãƒ³ã‚¯

è¤‡åˆä¸»ã‚ãƒ¼ã‚’é¿ã‘ã‚‹ã¹ãç†ç”± - è™Žå¡š

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

diary193 2013/08/16

ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã«ã¤ã„ã¦ã¯è³›å¦ä¸¡è«–ã‹ã€‚å¤–éƒ¨ã‚ãƒ¼ä½¿ã†ã®ã¯å¤§å‰æã¿ãŸã„ã ã‘ã©ã€æ˜¨ä»Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ãªã®ã‹ã—ã‚‰ï¼žå¤–éƒ¨ã‚ãƒ¼ã€‚

database

ãƒªãƒ³ã‚¯

qpstudyã§ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚

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

diary193 2013/07/29

database

ãƒªãƒ³ã‚¯

DBã®ä¸–ç•Œã«èµ·ã“ã‚‹å¤‰é© | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç‹¬ã‚Šè¨€

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

diary193 2013/01/06

ã€ŒDRAMãŒä¸æ®ç™ºã«ãªã‚‹ã€ã€Œã‚¸ãƒ£ãƒ¼ãƒŠãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ›´æ–°ã›ãšã€œç›´æŽ¥ãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ï¼‰ã‚’æ›´æ–°ã€ï¼IOé »åº¦ã®é«˜ã„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¸æ®ç™ºãƒ¡ãƒ¢ãƒªã«ç½®ãã¨ã„ã£ãŸç‰©ç†è¨è¨ˆãŒå¿…è¦ã«ãªã‚‹ã®ã‹

database

ãƒªãƒ³ã‚¯

ãªãœBTreeãŒIndexã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‹ - maru source

ã“ã®å†…å®¹ã¯å€‹äººçš„ãªè€ƒå¯Ÿãªã®ã§ã€é–“é•ã£ã¦ã„ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†éƒ¨åˆ†ã‚’è¦‹ã¤ã‘ãŸéš›ã¯ãœã²æ•™ãˆã¦ä¸‹ã•ã„ã€‚ RDBMSã®æ¤œç´¢ã‚’æ—©ãã™ã‚‹ãŸã‚ã«Indexã£ã¦ä½¿ã„ã¾ã™ã‚ˆãã€‚ä¾‹ãˆã°ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ« 1 2 3 4 5 CREATE TABLE user ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, PRIMARY KEY (id) )ENGINE=InnoDB; idã‚«ãƒ©ãƒ ã«Index(PRIMARY KEY)ã‚’å¼µã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯idã§ã®æ¤œç´¢ã‚’é«˜é€Ÿã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ã“ã“ã§idã‚«ãƒ©ãƒ ã«IndexãŒè²¼ã£ã¦ã„ãªã„å ´åˆã¨æ¯”ã¹ã‚‹ã¨æ¤œç´¢æ™‚é–“ãŒå¤§å¹…ã«å¤‰ã‚ã£ã¦ãã¦ã—ã¾ã„ã¾ã™ï¼ˆç‰¹ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå¤šããªã£ãŸæ™‚) ã§ã¯ãªãœIndexã‚’è²¼ã‚‹ã¨æ¤œç´¢ãŒæ—©ããªã‚‹ã‚“ã§ã—ã‚‡ã†ï¼Ÿï¼Ÿ Indexã¨ã¯ãã®åã®é€šã‚Šç´¢å¼•ã‚’æ„å‘³ã—ã¾ã™ã€‚ç‰¹å®šã®ã‚«ãƒ©ãƒ

diary193 2012/07/06

BTreeã®è‰¯ã„å¦ç¿’è³‡æ–™ã€‚ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã¨ã®ç›¸æ€§ã£ã¦ç†ç”±ã¯çŸ¥ã‚‰ãªã‹ã£ãŸã€‚ãªã‚‹ã»ã©ï½ž

database

ãƒªãƒ³ã‚¯

DBã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆã‚’èªå®šã™ã‚‹è³‡æ ¼ OSS-DBæŠ€è¡“è€…èªå®šè©¦é¨“

2018.12.11OSS-DB Silverå‡ºé¡Œç¯„å›²ã€Œé‹ç”¨ç®¡ç† - ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ï¼ˆinit dbã‚³ãƒžãƒ³ãƒ‰ã®ä½¿ã„æ–¹ï¼‰ã€ã«é–¢ã™ã‚‹ä¾‹é¡Œè§£èª¬ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ 2018.12.10å¹´æœ«å¹´å§‹ä¼‘æ¥ã®ã”æ¡ˆå†…ã€€Holiday Closing Notice 2018.12.08ãƒ“ã‚¸ãƒã‚¹ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼åˆ¶åº¦èª¬æ˜Žä¼šé–‹å‚¬ã®ãŠçŸ¥ã‚‰ã›ï¼ˆ12/11ã€12/18ã€1/8ã€1ï¼15ã€1ï¼22ã€1ï¼29ã€2/5ã€2ï¼12ã€2ï¼19ã€2/26ï¼‰ 2018.12.07ã‚¢ã‚«ãƒ‡ãƒŸãƒƒã‚¯èªå®šæ ¡åˆ¶åº¦èª¬æ˜Žä¼šé–‹å‚¬ã®ãŠçŸ¥ã‚‰ã›ï¼ˆ12/13ã€12/20ã€1/10ã€1/17ã€1/24ã€1ï¼31ã€2/7ã€2ï¼14ã€2ï¼21ã€2ï¼28ï¼‰ 2018.12.05ã€ŽOSS-DB Exam Gold æŠ€è¡“è§£èª¬ç„¡æ–™ã‚»ãƒŸãƒŠãƒ¼ã€ï¼ æ±äº¬ 12/2ï¼ˆæ—¥ï¼‰é–‹å‚¬çµæžœã®ã”å ±å‘Š 2018.11.27OSS-DB Silverå‡ºé¡Œç¯„å›²ã€Œé–‹ç™º/SQL - SQLã‚³ãƒžãƒ³ãƒ‰ï¼ˆSELECTæ–‡ï¼‰

diary193 2012/04/27

10å¹´è¿‘ãPostgreSQLã‚’ä½¿ã£ã¦ã„ãªã„ã‹ã‚‰ã€æœ€è¿‘ã®çŠ¶æ³ã‚’æŠŠæ¡ã™ã‚‹ã«ã¯ã„ã„ã‹ã‚‚ã€‚Silver + Gold ã§å—é¨“æ–™3ä¸‡å††ãƒ»ãƒ»ãƒ»Oracleã«æ¯”ã¹ãƒªãƒ¼ã‚ºãƒŠãƒ–ãƒ«ã¨ã¨ã‚‹ã¹ãã€ã‹ã€‚

ãƒªãƒ³ã‚¯

ãƒšãƒ¼ã‚¸ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ | æ—¥æœ¬HP

diary193 2011/06/01

ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ™ãƒ³ãƒ€ãŒANSIæº–æ‹ ã—ã¦ã€Oracleä¾å˜ã˜ã‚ƒãªããªã‚‰ãªã„é™ã‚Šãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã¯é›£ã—ã„

ãƒªãƒ³ã‚¯

é«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ - ä¸‰è±å›³æ›¸é¤¨ã‚·ã‚¹ãƒ†ãƒ MELILæ—§åž‹ã®æ¬ é™¥ã€ã‚¢ãƒ‹ãƒ¡åŒ– - å²¡å´Žå›³æ›¸é¤¨äº‹ä»¶(7)

â– ä¸‰è±å›³æ›¸é¤¨ã‚·ã‚¹ãƒ†ãƒ MELILæ—§åž‹ã®æ¬ é™¥ã€ã‚¢ãƒ‹ãƒ¡åŒ– - å²¡å´Žå›³æ›¸é¤¨äº‹ä»¶(7) 21æ—¥ã®æ—¥è¨˜ã§ç¤ºã—ãŸMELIL/CSï¼ˆæ—§åž‹ï¼‰ã®æ§‹é€ ä¸Šã®æ¬ é™¥ã«ã¤ã„ã¦ã€ãã®ä»•çµ„ã¿ã‚’ã‚¢ãƒ‹ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ã§è¡¨ç¾ã—ã¦ã¿ã‚‹ã€‚ ã¾ãšã€Webã‚¢ã‚¯ã‚»ã‚¹ã®ä»•çµ„ã¿ã€‚ãƒ–ãƒ©ã‚¦ã‚¶ã¨Webã‚µãƒ¼ãƒã¯HTTPã§é€šä¿¡ã™ã‚‹ãŒã€ã‚¢ã‚¯ã‚»ã‚¹ã”ã¨ã«HTTPæŽ¥ç¶šã¯åˆ‡æ–ã•ã‚Œã‚‹*1ã€‚ä»¥ä¸‹ã®ã‚¢ãƒ‹ãƒ¡1ã¯ãã®æ§˜åã‚’è¡¨ã—ã¦ã„ã‚‹ã€‚ ã“ã®ã‚ˆã†ã«ã€ã‚¢ã‚¯ã‚»ã‚¹ãŒçµ‚ã‚ã‚‹ã¨æŽ¥ç¶šãŒåˆ‡æ–ã•ã‚Œã¦ã€æ¬¡ã®ã‚¢ã‚¯ã‚»ã‚¹ã§å†ã³æŽ¥ç¶šã™ã‚‹ã®ã§ã‚ã‚‹ãŒã€ãƒ–ãƒ©ã‚¦ã‚¶ã”ã¨ã«æ¯Žå›žåŒã˜ã€Œã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€ã«ç¹‹ãŒã‚‹ã‚ˆã†ã€ã€Œã‚»ãƒƒã‚·ãƒ§ãƒ³IDã€ã¨å‘¼ã°ã‚Œã‚‹å—ä»˜ç•ªå·ã‚’ç”¨ã„ã¦åˆ¶å¾¡ã•ã‚Œã¦ã„ã‚‹ã€‚ ãªãŠã€èµ¤ã„ç·šã¯ã€ãã®æŽ¥ç¶šãŒä½¿ç”¨ä¸ã§ã‚ã‚‹ã“ã¨ã‚’è¡¨ã—ã¦ã„ã‚‹ã€‚ æ¬¡ã«ã€ã€Œ3å±¤ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨å‘¼ã°ã‚Œã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£æºã—ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å®Ÿç¾æ–¹å¼ã«ã¤ã„ã¦ã€‚3å±¤ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã¯ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã€Webã‚µãƒ¼ãƒã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼

diary193 2010/08/31

ãƒ¡ãƒªãƒ«æ–¹å¼ã¯ã€DBæŽ¥ç¶šã‚’Webã‚µãƒ¼ãƒã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€Œæ¯Žã«ã€ä¿æŒã™ã‚‹ã€‚ï¼ã€Œä½¿ã‚ãªã„æŽ¥ç¶šã‚’ç¶æŒã—ç¶šã‘ã‚‹ã®ã¯ç„¡é§„ã€

database

ãƒªãƒ³ã‚¯

Bigtable: A Distributed Storage System for Structured Data - steps to phantasien t(2006-09-11)

2006-09-11 è¿‘æ³ ä»Šæœˆã¯è²§ä¹ãªã®ã§æ…Žã—ãæš®ã‚‰ã—ã¦ã„ã‚‹. é€±æœ«ã‚‚ã²ãã“ã‚‚ã‚Šã¨ã—ã¦ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®è¨˜äº‹ã‚’èªã‚“ã§éŽã”ã™ã“ã¨ã«. ã‚¦ã‚§ãƒ–ã‚’çœºã‚ã¦ã„ã‚‹ã¨ã„ã„ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ Google ã®æ–°ä½œè«–æ–‡ãŒå‡ºã¦ã„ãŸ. ã‚ã‚ŠãŒã¨ã†, Google ã®ä¸ã®äºº. ã“ã‚Œ. GFS, MapReduce, Sawzall ã¨ã¤ã¥ã Google ã‚¤ãƒ³ãƒ•ãƒ© N éƒ¨ä½œã® 4 ç« ãŒå¹•ã‚’ã‚ã’ãŸ. å®Ÿã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ä½œã£ã¦ã‚‹ã‚“ã ãœ, ã¨ã„ã†è©±. BigTable ã¨ã„ã†åå‰ã ã‘ã¯ä»¥å‰ã‹ã‚‰ O'Reilly Radar ãªã©ã«ç™»å ´ã—ã¦ã„ãŸ. ã‚ˆã†ã‚„ãå…¬å¼ãªæ–‡æ›¸ãŒã‚ã‚‰ã‚ã‚ŒãŸ. BigTable ã¯ GFS ã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ Google ã‚¤ãƒ³ãƒ•ãƒ©ã®ä¸Šã«ä½œã‚‰ã‚ŒãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹. å°‘ã—å¤‰ã‚ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨, é‹ç”¨ã¾ã§ãƒ¯ãƒ³ã‚»ãƒƒãƒˆã®ãƒ˜ãƒ“ãƒ¼ãªå®Ÿè£…ã‚’æŒã¤. å®Ÿè£…ã®è©±ã‚‚ã¾ã‚é¢ç™½ã„ã‚“ã ã‘ã‚Œã©, ãã‚Œã‚ˆã‚Šãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ãŒå°è±¡çš„ã ã£ãŸ. å…ˆã«ãã®

diary193 2010/03/10

ãƒªãƒ³ã‚¯

A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«

A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL

diary193 2009/10/02

ãƒªãƒ³ã‚¯

SQL -TECHSCORE-

ã“ã“ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«å¿…é ˆã¨ãªã‚‹ä¸–ç•Œæ¨™æº–è¨€èªž SQL ã«ã¤ã„ã¦ã€åŸºç¤Žã‹ã‚‰å¿œç”¨ã¾ã§è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€SQL ã®ã¿ã«ã¨ã©ã¾ã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã®æŒã¤æ§˜ã€…ãªæ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ æœ€å¾Œã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã«é–¢ã™ã‚‹éžå¸¸ã«é‡è¦ãªè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã“ã‚Œã‚‰ã‚’å…¨ã¦å¦ç¿’ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã‹ã‚‰è¨è¨ˆã¾ã§å¹…åºƒã„çŸ¥è˜ã‚’èº«ã«ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ SQL INDEX 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¦‚è¦ 1.1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ 1.2. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹å¾´ 1.3. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã®é•ã„ 1.4. ä»£è¡¨çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« 1.5. ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 1.6. ã¾ã¨ã‚ 2. SQL 2.1. SQL ã®æ´å² 2.2. SQL ã¨ã¯ 2.3. SQL ã®æ©Ÿèƒ½ 2.

diary193 2009/08/13

SQLã®åŸºç¤Žã‹ã‚‰å¿œç”¨ã¾ã§

database

ãƒªãƒ³ã‚¯

Works Index

Works Index Last Updated. 05-Apr-2007 What's New ? 2007/04/05ã€€ç¿”æ³³ç¤¾ã•ã‚“ã®CodeZineã«è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸ é€†å¼•ãSQLæ¯”è¼ƒ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ã¦ã„ã¾ã™ã€‚ RDBMS Reverse Reference ã‚³ãƒ©ãƒ [CodeZine] GUIã®ãƒ€ã‚¤ã‚¢ãƒã‚°ã‚’ä½¿ã£ãŸã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶å‘ã‘å¯¾è©±ãƒãƒƒãƒã®å®Ÿç¾ DOSã®ãƒãƒƒãƒã‹ã‚‰ã€VBScriptã‚„Cã§ä½œæˆã—ãŸç°¡æ˜“ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å‘¼ã³å‡ºã—ã¦å¯¾è©±åž‹ã®å‡¦ç†ã‚’è¡Œã†æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ 2007/04/05 ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãƒ’ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ãŸãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°âˆ’ï¼’ ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãƒ’ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ãŸSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦å†åº¦ã€‚ 2005/11/23 ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚„Excelã‚·ãƒ¼ãƒˆã‚’SELECTæ–‡ã§è¦‹ã¦ã¿ã‚‹âˆ’ï¼’ Exc

diary193 2009/08/13

ãƒªãƒ³ã‚¯

ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ

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

diary193 2009/03/19

ãƒªãƒ³ã‚¯

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

ã‚‚ã—ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ãŸã‚‰

diary193 2009/02/24

ã€Œidempotentã¨ã¯ã€ä½•åº¦å®Ÿè¡Œã—ã¦ã‚‚ä¸€å›žã ã‘å®Ÿè¡Œã—ãŸã®ã¨åŒã˜çµæžœã«ãªã‚‹æ€§è³ªã®ã“ã¨ã€/ã€Œidempotentãªæ€§è³ªã‚’ä¿è¨¼ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã¨ã—ã¦ã¯ã€Version Numberãƒ‘ã‚¿ãƒ¼ãƒ³ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã€

database

ãƒªãƒ³ã‚¯

HOWSã€ŒISSEIï¼ˆã‚¤ãƒƒã‚»ã‚¤ï¼‰ã€

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

diary193 2008/01/21

database

ãƒªãƒ³ã‚¯

RDBMSã§ã¯ä¸ååˆ†

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

diary193 2007/12/07

RDDB Rubyã§å®Ÿè£…ã•ã‚ŒãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒªãƒ³ã‚¯

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

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

diary193 2007/09/13

ãƒãƒƒã‚·ãƒ¥ã‚¸ãƒ§ã‚¤ãƒ³ã€çµ±è¨ˆæƒ…å ±ã€ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªDBã€T-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

database

ãƒªãƒ³ã‚¯

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

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

diary193 2007/09/11

ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°

database

ãƒªãƒ³ã‚¯

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

ã‚¿ã‚°

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

databaseã«é–¢ã™ã‚‹diary193ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

ãŠçŸ¥ã‚‰ã›

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

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

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

ã‚¿ã‚°

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

databaseã«é–¢ã™ã‚‹diary193ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

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

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

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

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

å…¬å¼Twitter

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

å…¬å¼Twitter

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

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

databaseã«é–¢ã™ã‚‹diary193ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

ãŠçŸ¥ã‚‰ã›

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

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

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

å…¬å¼Twitter

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

å…¬å¼Twitter

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