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

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£è¨è¨ˆã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³é›†ï½ž44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶DBã‚·ã‚¹ãƒ†ãƒ - ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢

ã€Œ44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶DBã‚·ã‚¹ãƒ†ãƒ ã€ã‚’èªã‚“ã§ã¿ã¦ã€ã¨ã¦ã‚‚å„ªã‚ŒãŸã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£è¨è¨ˆã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³é›†ã«æ€ãˆãŸã€‚ éŽåŽ»ã®çµŒé¨“ä¸Šã€ã‚ã‚‹ã‚ã‚‹ã¨æ€ã†ç®‡æ‰€ãŒãŸãã•ã‚“ã‚ã£ãŸã€‚ æ„Ÿæƒ³ã‚’ãƒ©ãƒ•ãªãƒ¡ãƒ¢æ›¸ãã€‚ ã€å…ƒãƒã‚¿ã€‘ 44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶DBã‚·ã‚¹ãƒ†ãƒ - give IT a try ã‚ãªãŸã®ç¾å ´ã«ã‚‚å¿…ãšã‚ã‚‹DBã‚·ã‚¹ãƒ†ãƒ ã®"æ‚ªã„ä¾‹"ãŒæº€è¼‰ï¼ã€Œ44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶ DBã‚·ã‚¹ãƒ†ãƒ ã€ | oracle tech.jp ã€Ž44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶DBã‚·ã‚¹ãƒ†ãƒ ã€ - è™Žå¡š 44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶DBã‚·ã‚¹ãƒ†ãƒ : è³¢è€…ã®å›³æ›¸é¤¨ (Under Construction) : livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰ ã€æœ¬ã€‘SQLã‚’ã—ã£ã‹ã‚Šå¦ç¿’ã—ãŸã„äººã«ãŠã™ã™ã‚ãƒŸãƒƒã‚¯æœ¬ã€‚ | ï¾Œï¾Ÿï¾—ï¾Œï¾Ÿï¾—å¼æŠ€è¡“ç³» Accessæµ! ã€æœ¬ã¾ã¨ã‚ã€‘44ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«å¦ã¶ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰æ™‚ã®å¤±æ•—ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ã‚‚ã£ã¨ã¯ã‚„ãè¨€ã£ã¦ã‚ˆãƒ¼ã¨ãª

voidy21 2013/01/03

db

ãƒªãƒ³ã‚¯

Jenkins+schemaSpyã§HTMLãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã‚’ç”Ÿæˆã™ã‚‹ - TrinityT's BLOG

DBã‚¹ã‚ãƒ¼ãƒžã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã‚’ç”Ÿæˆã™ã‚‹æ–¹æ³•ã‚’æŽ¢ã—ã¦ã„ãŸæ‰€ã€schemaSpyã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ç™ºè¦‹ã€‚ ã“ã‚Œã¨Jenkinsã‚’çµ„ã¿åˆã‚ã›ã¦ã€å¸¸ã«æœ€æ–°ã®HTMLãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã‚’ç”Ÿæˆã™ã‚‹æ–¹æ³•ã‚’ç¢ºç«‹ã§ããŸã€‚ å‰æ UbuntuServer11.10 MySQL5.1 JDK1.6ç³»ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ Jenkinså®Ÿè¡Œã‚µãƒ¼ãƒã§å¯¾è±¡ã®DBã«ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ãªã“ã¨ æ‰‹é † JDBCã‚³ãƒã‚¯ã‚¿ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« sudo apt-get install libmysql-java # ç¢ºèª ls /usr/share/java/mysql.jar schemaSpyã®jarã‚’é…ç½® mkdir /var/lib/jenkins/schemaSpy cd /var/lib/jenkins/schemaSpy wget http://jaist.dl.sourceforge.net/project/schemasp

voidy21 2012/07/02

jenkins
db

ãƒªãƒ³ã‚¯

cybozu.com ã®ãƒ‡ãƒ¼ã‚¿ç®¡ç† - ã‚µãƒ¼ãƒ“ã‚¹ | ã‚µã‚¤ãƒœã‚¦ã‚º ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€Œcybozu.comï¼ˆã‚µã‚¤ãƒœã‚¦ã‚ºãƒ‰ãƒƒãƒˆã‚³ãƒ ï¼‰ã€

cybozu.com ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ cybozu.comã¯æ±æ—¥æœ¬ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã§é‹ç”¨ã—ã€è¥¿æ—¥æœ¬ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã‚’ä¿ç®¡ã—ã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã¯è‡ªå®¶ç™ºé›»è£…ç½®ã‚’å‚™ãˆã€ä¸æ„ã®åœé›»ã®éš›ã«ã‚‚ã‚µãƒ¼ãƒ“ã‚¹ã«å½±éŸ¿ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã¾ãŸã€24æ™‚é–“365æ—¥ã®æœ‰äººç›£è¦–ä½“åˆ¶ã‚’å–ã£ã¦ãŠã‚Šã¾ã™ã€‚ cybozu.com ã®ã‚µãƒ¼ãƒãƒ¼æ§‹æˆãŠã‚ˆã³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç’°å¢ƒ ãŠå®¢æ§˜ã®ãƒ‡ãƒ¼ã‚¿ã¯3å°1çµ„ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒãƒ¼ç¾¤ã§é‹ç”¨ã™ã‚‹ã“ã¨ã§ã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆåŒæœŸï¼‰ã‚„ã€ç„¡åœæ¢ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å®Ÿç¾ã—ã¦ã„ã¾ã™ã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒãƒ¼ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯æ§‹æˆ ã¾ãšã¯ã˜ã‚ã«ã€å„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒãƒ¼ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯æ§‹æˆã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒãƒ¼ã¯ã€1ã‚µãƒ¼ãƒãƒ¼ã«ã¤ã12å°ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã§æ§‹æˆã•ã‚Œã¦ã„ã¾ã™ã€‚ ãã®ã†ã¡10å°ã‚’RAID 6ã§å†—é•·åŒ–ã—ã¦ã„ã‚‹ã®ã§ã€ä¸‡ãŒä¸€ã€åŒæ™‚ã«10å°ä¸2å°ãŒæ•…éšœã—ã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãŒ

voidy21 2012/07/02

db

ãƒªãƒ³ã‚¯

ã¯ã˜ã‚ã¦ã®MongoDB

16. { "_id" : ObjectId("4dcd3ebc9278000000005158"), "timestamp" : ISODate("2011-05-13T14:22:46.777Z"), "binary" : BinData(0,""), "string" : "abc", "number" : 3, "subobj" : {"subA": 1, "subB": 2 }, "array" : [1, 2, 3], "dbref" : [_id1, _id2, _id3] } 17. { "_id" : ObjectId("4dcd3ebc9278000000005158"), "timestamp" : ISODate("2011-05-13T14:22:46.777Z"), "binary" : BinData(0,""), "string" : "abc", "num

voidy21 2011/09/11

db

ãƒªãƒ³ã‚¯

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

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

voidy21 2011/06/12

db

ãƒªãƒ³ã‚¯

åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜

ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚

voidy21 2010/09/17

db

ãƒªãƒ³ã‚¯

ã¤ã¿ãWeb

voidy21 2010/06/21

db

ãƒªãƒ³ã‚¯

jssst.dvi

voidy21 2010/05/15

ãƒªãƒ³ã‚¯

SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£

SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ SSDãŒHDDã«ä»£ã‚ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦æ™®åŠã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã“ã¨ã‚’èƒŒæ™¯ã«ã€SSDã«ç‰¹åŒ–ã—ãŸã¾ã£ãŸãæ–°ã—ã„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å‚™ãˆãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é–‹ç™ºã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ä¼æ¥ãŒã‚ã‚Šã¾ã™ã€‚ã€ŒReThinkDBã€ã§ã™ã€‚ æ˜¨å¹´7æœˆã«ã€Publickeyã§ã¯ReThinkDBã®æ¦‚è¦ã‚’è¨˜äº‹ã€ŒSSDã«æœ€é©åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒRethinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿç¾ã€ã§ä¼ãˆã¾ã—ãŸã€‚ ãã®è¨˜äº‹ã®ä¸ã§ã¯ã€ReThinkDBãŒãƒãƒƒã‚¯ã‚’ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨ä¸ã§ã‚‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒã¨ã‚Œã€ã¾ãŸç•°å¸¸çµ‚äº†ã—ã¦ã‚‚å®¹æ˜“ã«å¾©å¸°ã§ãã‚‹æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ 4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§ã«è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Ex

voidy21 2010/05/15

db

ãƒªãƒ³ã‚¯

FriendFeedã«ãŠã‘ã‚‹MySQLã¸ã®å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿æ ¼ç´ - masayang's diary

éžRDBã ã®Key-Valueã ã®ã¨é¨’ãŒã—ã„ä»Šæ—¥ã“ã®é ƒã§ã™ãŒçš†æ§˜ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ç§ã¯å…ƒæ°—ã§ã™ã€‚å…ˆæ—¥ã€ãƒ™ã‚¤ã‚¨ãƒªã‚¢ã‚¯ãƒ©ã‚¦ãƒ‰å‹‰å¼·ä¼šã§æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸHow FriendFeed uses MySQL to store schema-less data(FriendFeedæµãƒ»ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãƒ‡ãƒ¼ã‚¿ã®MySQLã¸ã®æ ¼ç´)ã‚’é©å½“ã«ç¿»è¨³ã—ã¦ã¿ã¾ã™ã‚ˆã€‚(åŽŸæ–‡ã¯Creative Commonsãƒ©ã‚¤ã‚»ãƒ³ã‚¹) èƒŒæ™¯ FriendFeedã§ã¯ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã«æ ¼ç´ã—ã¦ã„ã‚‹ã€‚åˆ©ç”¨è€…ã®å¢—åŠ ã«ä¼´ã„ã€FriendFeedã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚æ‹¡å¤§ã—ã¦ããŸã€‚ç¾æ™‚ç‚¹ã§ã¯2å„„5000ä¸‡ä»¶ä»¥ä¸Šã®è¨˜äº‹ãŒç™»éŒ²ã•ã‚Œã¦ãŠã‚Šã€ã“ã‚Œã«ã‚³ãƒ¡ãƒ³ãƒˆã‚„ãŠå‹é”ä¸€è¦§ã®ãŠæ°—ã«å…¥ã‚Šãªã©ã®ãƒ‡ãƒ¼ã‚¿ãŒåŠ ã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€¥æˆé•·ã«ä¼´ãªã„ã€è¦æ¨¡ã«é–¢ã™ã‚‹èª²é¡Œã«ã‚‚æ®µéšŽçš„ã«å¯¾å‡¦ã—ã¦ããŸã€‚åŸºæœ¬çš„ãªå¯¾å‡¦ã¯ãŠã“ãªã£ã¦ããŸã¤ã‚‚ã‚Šã ã€‚å…·ä½“çš„ã«ã¯ã€èªã¿å–ã‚Šå°‚ç”¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã®

voidy21 2010/02/17

db

ãƒªãƒ³ã‚¯

kumofsã‚’ãƒ™ãƒ¼ã‚¹ã«RDBMSç”¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã£ã¦ä½œã‚Œãªã„ã‚‚ã®ã‹ | ç‹¬ã‚Šè¨€v6

ã¾ã è‡ªåˆ†ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ç¢ºã‹ã‚ã¦ã„ãªã„ãŒã€kumofsã«èˆˆå‘³æ´¥ã€…ã§ã‚ã‚‹ã€‚ä½•ãŒèˆˆå‘³æ·±ã„ã‹ã¨ã„ã†ã¨ã€ã¾ã‚ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã§ä¸”ã¤è€éšœå®³æ€§ã«å„ªã‚Œã‚‹ã¨ã“ã‚ã ã€‚ã‚‚ã¡ã‚ã‚“ãã‚Œã ã‘ãªã‚‰åˆ†æ•£KVSã¨ã„ã†ã“ã¨ã§ã‚ã‚‹ç¨‹åº¦äºˆæƒ³ã•ã‚ŒãŸæ©Ÿèƒ½ã§ã‚ã‚‹ã€‚å€‹äººçš„ãªèˆˆå‘³ã¨ã—ã¦ã¯ã€Œã“ã®ç¨®ã®KVSã‚’ä½¿ã£ã¦RDBMSã‚‚ã©ããŒä½œã‚Œãªã„ã‹ã€ã¨ã„ã†ã¨ã“ã‚ã«ã‚ã‚‹ã€‚ ã“ã®æ§‹æƒ³ã¯ è¶… ä¸¦åˆ—RDBMSã¯æˆç«‹ã™ã‚‹ã‹ â€“ L.starçš„ãƒ‡ã‚¶ã‚¤ãƒ³ï¼ˆï¼‘ï¼‰ ã§ãšã„ã¶ã‚“å‰ã‹ã‚‰æš–ã‚ã¦ã„ã‚‹ã‚‚ã®ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã„ã†ãƒªã‚½ãƒ¼ã‚¹ãƒŽãƒ¼ãƒ‰ã‚’kumofsã§ä»£ç”¨ã§ããªã„ã‹ã¨ã„ã†ã‚‚ã®ã ã€‚å¼•ç”¨ã—ã¦ã€æ©Ÿèƒ½çš„ãªå®Ÿè£…ã®å¿…è¦ã§ãªã„ã‚‚ã®ã‚’é™¤ãã¨ ãƒªã‚½ãƒ¼ã‚¹ãƒŽãƒ¼ãƒ‰ storage engineã§ã‚ã‚‹ DDLçš„ã«ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«è¿‘ã„ä½ç½®ã¥ã‘ã¨ã—ã¦å®šç¾©å¯èƒ½ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã€‚ sequential scan, index scan, seq scan+sortã‚’è¡Œã„ã€ãã®çµæžœã‚’è¿”ã™DBã§ã‚ã‚‹ã€‚M

voidy21 2010/02/12

db

ãƒªãƒ³ã‚¯

Kazuho@Cybozu Labs: é«˜åº¦ã«é€²åŒ–ã—ãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯ RDBMS ã¨è¦‹åˆ†ã‘ãŒã¤ã‹ãªã„ï¼Ÿ (shibuya.pm #12 ã‚¹ãƒ©ã‚¤ãƒ‰)

é–‹ç™ºã—ã¦ã„ã‚‹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ Incline ã¨ Pacific ã«ã¤ã„ã¦ã¯ YAPC::Asia 2009 ã‚’å§‹ã‚ã„ã‚ã„ã‚ãªæ‰€ã§è©±ã‚’ã™ã‚‹æ©Ÿä¼šã‚’ã„ãŸã ã„ã¦ããŸã®ã§ã€ä»Šå›žã¯ã€ãªãœ RDBMS ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æŽ¡ç”¨ã—ãŸã®ã‹ã¨ã„ã†èƒŒæ™¯ã‚’ä¸å¿ƒã«èª¬æ˜Žã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚æ¦‚å¿µçš„ãªè©±ãŒå¤šãã¦åˆ†ã‹ã‚Šã«ãã‹ã£ãŸã¨æ€ã„ã¾ã™ï¼ˆã™ã¿ã¾ã›ã‚“ï¼‰ãŒã€ç´°ã‹ãªç‚¹ã«ã¤ã„ã¦ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)ã‚’å‚ç…§ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸã€ä¸ã§å‡ºã¦ããŸã€Œå®Ÿä½“åŒ–ãƒ“ãƒ¥ãƒ¼ã€ã«ã¤ã„ã¦ã¯ã€Materialized view - Wikipedia, the free encyclopediaãŒè‰¯ãã¾ã¨ã¾ã£ã¦ã„ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚Incline ã¯ä¸€è¨€ã§ã„ã†ã¨ã€RDBã§æ§‹æˆã•ã‚Œã‚‹shardç¾¤ã®ä¸Šã§ read-only ã‹ã¤ eventually co

voidy21 2009/12/01

db

ãƒªãƒ³ã‚¯

Bigtableã¨åˆ†æ•£KVSãƒ»ãã®2 - ã‚¹ãƒ†ã‚£ãƒ«ãƒã‚¦ã‚¹ã®æ›¸åº«ã®æ›¸åº«

ã‚ã‚ŠãŒãŸã„ã“ã¨ã«å¤æ©‹ã•ã‚“ã«å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã‚’ã”è¦§ã„ãŸã ã„ãŸã‚ˆã†ã§ã€å¤§å¤‰ãŸã‚ã«ãªã‚‹ã¤ã¶ã‚„ãã‚’ã•ã‚Œã¦ãŸã®ã§ã€ã“ã“ã§å¼•ç”¨ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ @frsyukiã•ã‚“ï¼š ã€Œåˆ†æ•£KVSã€ã¨ã„ã†åå‰ã¯ä½•ã‚‚è€ƒãˆã¦ã„ãªãã¦ã€åˆ¥ã«åˆ†æ•£KVSã«BigTableã‚’å«ã‚ã¦ã‚‚è‰¯ãã¦ã€åŠ¹çŽ‡ã®è©±ã‚’å•é¡Œã«ã—ã¦ã„ãŸã‘ã©ã€åˆ†ã‹ã‚Šã«ãã‹ã£ãŸã ã‚ã†ã‹â€¦ï¼šhttp://bit.ly/IMFUs ãã‚Œã¯ãã‚Œã¨ã—ã¦ã€åŠ¹çŽ‡ã«ã¤ã„ã¦ã€‚æ¦‚å¿µçš„ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ãŒmultidimentionalã§ã‚ã‚‹ã“ã¨ã§ã€BigTableã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ä¾å˜ã—ãŸæƒ…å ±ã‚’ã‚ˆã‚Šå¤šãçŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã“ã‚Œã«ã‚ˆã£ã¦æœ€é©åŒ–ã‚’ã—ã‚„ã™ããªã‚Šã€åŠ¹çŽ‡ãŒä¸ŠãŒã‚‹ã€‚ ä¾‹ãˆã°ã€Every read or write of data under a single row key is atomic ã‚’åŠ¹çŽ‡çš„ã«ä¿è¨¼ã™ã‚‹ã€reads of short row ranges are effi

voidy21 2009/11/30

db

ãƒªãƒ³ã‚¯

æœ€é€Ÿä¸¦ã³æ›¿ãˆç ”ç©¶ä¼š - Yappo::ã‚¿ãƒ¯ã‚·

1000ä¸‡è¡Œã¨ã‹10å„„è¡Œã§ã‚‚ä½•ã§ã‚‚ã„ã„ã‘ã©ã€ã„ã£ã±ã„ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®sortã‚«ãƒ©ãƒ ã®å€¤ã‚’ä¸¦ã³æ›¿ãˆãŸã„ã€‚ ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«sort_testãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ use strict; use warnings; use DBI; my $dbi = DBI->connect('DBI:mysql:database=test'); $dbi->do('DROP TABLE IF EXISTS sort_test'); $dbi->do(<<SQL); CREATE TABLE sort_test ( id INT, sort INT, index(id), index(sort) ) ENGINE=InnoDB SQL my $sth = $dbi->prepare('INSERT INTO sort_test VALUES' . join(', ', ('(?,?)')x10_000

voidy21 2009/11/15

db
perl

ãƒªãƒ³ã‚¯

XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - Wikipedia

ã“ã®è¨˜äº‹ã¯æ¤œè¨¼å¯èƒ½ãªå‚è€ƒæ–‡çŒ®ã‚„å‡ºå…¸ãŒå…¨ãç¤ºã•ã‚Œã¦ã„ãªã„ã‹ã€ä¸ååˆ†ã§ã™ã€‚ å‡ºå…¸ã‚’è¿½åŠ ã—ã¦è¨˜äº‹ã®ä¿¡é ¼æ€§å‘ä¸Šã«ã”å”åŠ›ãã ã•ã„ã€‚ï¼ˆã“ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½¿ã„æ–¹ï¼‰ å‡ºå…¸æ¤œç´¢?:Â "XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹"Â â€“Â ãƒ‹ãƒ¥ãƒ¼ã‚¹Â Â· æ›¸ç±Â Â· ã‚¹ã‚«ãƒ©ãƒ¼Â Â· CiNiiÂ Â· J-STAGEÂ Â· NDLÂ Â· dlib.jpÂ Â· ã‚¸ãƒ£ãƒ‘ãƒ³ã‚µãƒ¼ãƒÂ Â· TWL (2023å¹´2æœˆ) XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã€XMLã‚’æ‰±ã†ãŸã‚ã®æ©Ÿèƒ½ã‚’æŒã¤ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã€‚ ç‹ç¾©ã§ã¯XMLã®ãƒ„ãƒªãƒ¼æ§‹é€ ã‚’ãã®ã¾ã¾ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¨ã—ã¦æŒã¤ç‰©ã‚’è¨€ã†ãŒã€å®Ÿéš›ã¯ä¼çµ±çš„ãªé–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«XMLã‚’æ ¼ç´ã™ã‚‹ã‚‚ã®ã‚„ã€å˜ã«ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦XMLã‚’æ ¼ç´ã™ã‚‹ã‚‚ã®ãªã©æ§˜ã€…ã§ã‚ã‚‹ã€‚ç¾åœ¨ã§ã¯XPathã€XQueryã§æ¤œç´¢ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨å‘¼ã¶ã“ã¨ãŒå¤šã„ã€‚ ç¾åœ¨ã§ã‚‚åºƒãç”¨ã„ã‚‰ã‚Œã¦ã„ã‚‹é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€ä¸€åº¦ä½œæˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’é‹ç”¨ä¸ã«å¤‰æ›´ã™ã‚‹ã“ã¨ãŒä¸€èˆ¬

voidy21 2009/11/13

ãƒªãƒ³ã‚¯

ç¬¬1å›žã€€æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã¯ | gihyo.jp

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

voidy21 2009/11/13

db

ãƒªãƒ³ã‚¯

çœŸã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ãã†ï¼ï¼ˆ1/3ï¼‰ â€• ï¼ IT

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

voidy21 2009/10/28

ãƒªãƒ³ã‚¯

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜

â– ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(ç´¢å¼•)ã¨ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ é«˜é€Ÿã«å–ã‚Šå‡ºã™ç‚ºã®ä»•çµ„ã¿ã‚’æ„å‘³ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦SQLæ–‡ã®å¿œç”æ™‚é–“ãŒåŠ‡çš„ã«æ”¹å–„ ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¯B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¯ã˜ã‚ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ãŒã€ã“ã“ã§ã¯æœ€ã‚‚ä¸€èˆ¬çš„ã«ä½¿ã‚ã‚Œã€ã‹ã¤ ã»ã¨ã‚“ã©ã®DBMSã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ â€» CREATE INDEXæ–‡ã§ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã—ãªã„å ´åˆã¯é€šå¸¸B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒ ä½œæˆã•ã‚Œã¾ã™ã€‚ â– B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã—ãã¿ B-Tree(Balanced Tree)ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ¬¡ã®ã‚ˆã†ãªãƒ„ãƒªãƒ¼çŠ¶ã®æ§‹é€ ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ„ãƒªãƒ¼ã®å…ˆé ã¯ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã§ã¯ã€ã‚ãƒ¼å€¤ã® ç¯„å›²

voidy21 2009/10/25

db

ãƒªãƒ³ã‚¯

ã‚µãƒ¼ãƒã¯ä»®æƒ³åŒ–ã•ã‚Œã‚‹ã¹ãã ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯æ°—ã‚’ã¤ã‘ã‚ ï¼ Publickey

StorageIOblog Â» Blog Archive Â» Should Everything Be Virtualized? The Server Storage IO Groupã®ã‚¢ãƒŠãƒªã‚¹ãƒˆãŒæ›¸ã„ã¦ã„ã‚‹ãƒ–ãƒã‚°ã€ŒStorageIOblogã€ã«ã€ã€ŒShould Everything Be Virtualized?ã€ï¼ˆã™ã¹ã¦ã¯ä»®æƒ³åŒ–ã•ã‚Œã‚‹ã¹ããªã®ã‹ï¼Ÿï¼‰ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãŒãƒã‚¹ãƒˆã•ã‚Œã¾ã—ãŸã€‚ ã™ã¹ã¦ã®ã‚µãƒ¼ãƒã€I/Oã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯ä»®æƒ³åŒ–ã•ã‚Œã‚‹ã¹ããªã®ã‹ï¼Ÿ ã¨ã„ã†å•ã„ã«ç”ãˆã‚‹ã‚¨ãƒ³ãƒˆãƒªã«ãªã£ã¦ã„ã¾ã™ã€‚ Unfortunately consolidation is commonly misunderstood to be the sole function or value proposition of server virtualization given its first wave focus.

voidy21 2009/10/25

db

ãƒªãƒ³ã‚¯

Kazuho@Cybozu Labs: ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)

å…ˆé€±é‡‘æ›œæ—¥ã€BPStudy#25ã§ã€ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨ã„ã†é¡Œç›®ã§è©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®éš›ã«ä½¿ç”¨ã—ãŸç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ 1. Happy Optimization æœ€åˆã«ã€æœ€é©åŒ–ã®è€ƒãˆæ–¹ã¨ã—ã¦ã€ä¸Šé™å€¤ã‚’äºˆæ¸¬ã—ã€ãã‚Œã‚’å…ƒã«ãƒªã‚½ãƒ¼ã‚¹é…åˆ†ã‚’è€ƒãˆã‚‹ã€ã¨ã„ã†æ‰‹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚

voidy21 2009/09/28

db

ãƒªãƒ³ã‚¯

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

ã‚¿ã‚°

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

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

ãŠçŸ¥ã‚‰ã›

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

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

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

ã‚¿ã‚°

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

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

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

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

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

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

å…¬å¼Twitter

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

å…¬å¼Twitter

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

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

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

ãŠçŸ¥ã‚‰ã›

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

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

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

å…¬å¼Twitter

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

å…¬å¼Twitter

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