A Yes for a NoSQLÂ Taxonomy - High Scalability -
NorthScale's Steven Yen in his highly entertaining NoSQL is a Horseless Carriage presentation has come up with a NoSQL taxonomy that thankfully focuses a little more on what NoSQL is, than what it isn't: keyâ€valueâ€cache memcached, repcached, coherence, infinispan, eXtreme scale, jboss cache, velocity, terracoqa keyâ€valueâ€store keyspace, flare, schemaâ€free, RAMCloud eventuallyâ€consistent keyâ€valueâ€
Carsonified » Should you go Beyond Relational Databases?
News Flash FOWA Summer Sale is heating up! Grab 'em while you can. Relational databases, such as MySQL, PostgreSQL and various commercial products, have served us well for many years. Lately, however, there has been a lot of discussion on whether the relational model is reaching the end of its life-span, and what may come after it. Should you care? Which database technology should you be using? Of
スã‚ーマä¸å®šã®ãƒ‡ãƒ¼ã‚¿ã‚’RDBã«æ°¸ç¶šåŒ–ã™ã‚‹æ–¹æ³•ã®æ¯”較 — ã‚ã‚Šãˆã‚‹ãˆã‚Šã‚
Recent entries Apache2.4ã®ãƒªãƒªãƒ¼ã‚¹äºˆå®šã¯æ¥å¹´(2011å¹´)åˆã‚(ã‚ãã¾ã§äºˆå®š) inoue 2010-12-23 Herokuã®ç™ºéŸ³ inoue 2010-12-20 雑誌記事「ソフトウェア・テストPRESS Vol.9ã€ã®åŽŸç¨¿å…¬é–‹ inoue 2010-12-18 IPA未è¸ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ inoue 2010-12-15 労基法ã¨ãƒã‚ンゲームinoue 2010-12-06 フãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ inoue 2010-12-03 ASCII.technologies誌ã«MapReduceã®è¨˜äº‹ã‚’書ãã¾ã—㟠inoue 2010-11-25 æŠ€è¡“è©•è«–ç¤¾ãƒ‘ãƒ¼ãƒ•ã‚§ã‚¯ãƒˆã‚·ãƒªãƒ¼ã‚ºçµ¶è³›ç™ºå£²ä¸ inoue 2010-11-24 雑誌連載「Emacsã®ãƒˆãƒ©ãƒŽãƒžã‚ã€ã®åŽŸç¨¿(part8)公開 inoue 2010-11-22 RESTã®å½“惑 inoue 2010-11-22 「プ
Seasar Conference 2006 Spring (5) - 世界線航跡蔵
å‰ã®è¨˜äº‹ ã«ç¶šã„ã¦Seasar Conferenceをレãƒãƒ¼ãƒˆã™ã‚‹ã€‚ セッション4 DB-sideã®ã»ã†ã¯ã€ŒEJB3時代ã®ERDレッスン - Activity Based Datamodel〠Seasar-sideã®ã»ã†ã¯ã€Œç‰‡æ‰‹ã§ã‚¹ã‚¤ã‚¹ã‚¤Webアプリ2.0 - TuigwaaåŠ‡å ´ã¸ã‚ˆã†ã“ã〠ミニセッションã®ã»ã†ã¯ã€ŒS2Flex2〠Tuigwaaã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯è´è¡†ã‚’æ„Ÿå‹•ã¨èˆˆå¥®ã®æ¸¦ã«å·»ã込んã らã—ã„ã‘ã‚Œã©ã€ãã‚Œã¯æƒ³åƒã«é›£ããªã„。 åƒè‘‰æ»‹PM採択案件最終æˆæžœå ±å‘Šä¼š ã§ä¸€å¿œè©±ã¯èžã„ã¦ã€ç§ã‚‚éžå¸¸ã«æ„Ÿå‹•ã—ãŸã€‚ Tuigwaaã¯ä¸€åº¦èžã„ãŸã‹ã‚‰ã„ã„ã‚„ã¨æ€ã£ã¦ã€ç§ã¯ã€ŒERDレッスンã€ã‚’èžã„ã¦ããŸã€‚ ã¯ã¶ã•ã‚“ ERDセッションã®ç™ºè¡¨è€…ã¯ã€ã¯ã¶ã‚ãã²ã‚ã•ã‚“。御本人を見るã®ã¯åˆã‚ã¦ã§ã€å°‘ã—イメージãŒé•ã£ãŸã€‚ ã¯ã¶ã«ã£ã ã¯æ„›èªã—ã¦ã„ã‚‹ã‘ã‚Œã©ã‚‚ã€å¶ã«ã€SIerã•ã‚“ãŒæ›¸ã„ã¦ã„ã‚‹ã¨æƒ³åƒã™ã‚‹ã¨ã¡ã‚‡ã£ã¨é¼»ã«ã¤ãよã†ã«
Fumio Sekita's Blog
Azure ãªæ¯Žæ—¥ã‚’ãŸã¾ã«è¨˜éŒ²ã—ã¾ã™ï¼ˆæ”¹å®šå‰ï¼šAzure ãªæ¯Žæ—¥ã®è¨˜éŒ²ã§ã™ï¼‰ Node.js ã§ã® テーブル ストレージ entity ã®è¿½åŠ ã¯æ™®é€šã«ã‚„ã‚‹ã¨ã“ã‚“ãªæ„Ÿã˜ã§æ›¸ã‘ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ã“ã‚Œã ã¨ãƒ‡ãƒ¼ã‚¿åž‹ã¯å…¨ã¦æ–‡å—列ã«ãªã‚Šã¾ã™ã€‚ 1: var azure = require('azure') 2: , nconf =... Date: 11/26/2012 実ã¯æœå¹Œã§ã‚‚セミナーやりã¾ã™... 実ã¯ã“ã¡ã‚‰ãŒå…ˆã«é–‹å‚¬ã•ã‚Œã‚‹ã®ã§ã™ãŒã€æœå¹Œã§ã‚‚セミナー開催ã—ã¾ã™ï¼... Date: 10/09/2012 "Windows Azure Seminar in Fukuoka" ã‚„ã‚Šã¾ã™ï¼ 久々㮠blog ã§ã™ãŒã€ã‚»ãƒŸãƒŠãƒ¼å‘ŠçŸ¥ã•ã›ã¦é ‚ãã¾ã™ã€‚ 今ã¾ã§ã€ç¦å²¡ã®ä»–ã®ã‚»ãƒŸãƒŠãƒ¼ã®ä¸ã§ã¯ã‚„ã£ã¦ã„ã¾ã—ãŸãŒã€ä»Šå›žã€Windows Azure セミナーをã€å˜ç‹¬ã§å®Ÿæ–½ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚主催ã®... Date: 10
ã‚‚ã†1ã¤ã®ã€DBã®ã‹ãŸã¡ã€åˆ†æ•£Key-Valueストアã¨ã¯
ã‚‚ã†1ã¤ã®ã€DBã®ã‹ãŸã¡ã€åˆ†æ•£Key-Valueストアã¨ã¯ï¼šåˆ†æ•£Key-Valueストアã®æœ¬å‘½ã€ŒBigtableã€ï¼ˆ1）（1/3 ページ） RDBã¨ã¯åˆ¥ã®ã€ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚代ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æ³¨ç›®ã‚’æµ´ã³ã¦ã„る「分散Key-Valueストアã€ã€‚ãã®æœ¬å‘½ã¨ã‚‚ã„ãˆã‚‹ã€Googleã®æ•°ã€…ã®ã‚µãƒ¼ãƒ“スã®åŸºç›¤æŠ€è¡“「Bigtableã€ã«ã¤ã„ã¦å¾¹åº•è§£èª¬ クラウド時代ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€Œåˆ†æ•£Key-Valueストア〠グーグルãŒã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ä¸–界をã“ã“ã¾ã§å¸ã‘ã‚“ã§ããŸæœ€å¤§ã®ç†ç”±ã¯ä½•ã§ã—ょã†ã‹ã€‚実ã¯ã€ãã‚Œã¯åŒç¤¾ã®å„ªã‚ŒãŸæ¤œç´¢æŠ€è¡“ã§ã¯ã‚ã‚Šã¾ã›ã‚“。グーグルãŒæˆã—é‚ã’ãŸæœ€ã‚‚大ããªãƒ–レークスルーã®1ã¤ã¯ã€åŒç¤¾ãŒç”Ÿã¿å‡ºã—ãŸå·¨å¤§ãªåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ã€ŒBigtableã€ã«ã‚ã‚Šã¾ã™ã€‚ Bigtableã¯ã€Google検索をã¯ã˜ã‚ã€YouTubeã‚„Google Mapã€Google Earthã€Google Analyticsã€Goog
Microsoft SQL Serverã®æ—¥æœ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šãŒè§£æ•£
マイクãƒã‚½ãƒ•ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“「Microsoft SQL Serverã€ã®æ—¥æœ¬ã«ãŠã‘るユーザー会ã§ã‚る「PASSJ（SQL Serverユーザーグループ）ã€ãŒ2009å¹´6月30æ—¥ã«ç„¡æœŸé™ä¼‘会ã—ãŸã€‚7月1日付ã‘ã§Webサイトも閉鎖ã—ã€ä¼šå“¡æƒ…å ±ã‚‚å‰Šé™¤ã™ã‚‹ã€‚事実上ã®è§£æ•£ã§ã‚る。 2000å¹´5月ã«ç™ºè¶³ã—ãŸPASSJã¯ä¼šå“¡æ•°ãŒ2万人ã§ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆè£½å“ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šã®ä¸ã§ã‚‚è¦æ¨¡ãŒå¤§ãã„。2000年代åŠã°ã¾ã§ã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šä¸»å‚¬ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’毎年開催ã™ã‚‹ãªã©æ´»å‹•ã‚‚盛んã ã£ãŸã€‚è¿‘å¹´ã¯æ´»å‹•è¦æ¨¡ã‚‚縮å°ã—ã¦ãŠã‚Šã€09å¹´6月ã®ç†äº‹ä¼šã§ä¼‘会を決ã‚ãŸã€‚マイクãƒã‚½ãƒ•ãƒˆã¯ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šãŒæ±ºã‚ãŸã“ã¨ãªã®ã§ã€ã‚ã‚Œã‚ã‚Œã¯ã‚³ãƒ¡ãƒ³ãƒˆã§ããªã„ã€ï¼ˆåŒç¤¾åºƒå ±ï¼‰ã¨ã—ã¦ã„る。
Kazuho@Cybozu Labs: Pacific ã¨ã„ã†åå‰ã®åˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’作り始ã‚ãŸä»¶
大è¦æ¨¡ãªã‚¦ã‚§ãƒ–アプリケーションã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã¨ã„ã†ç‚¹ã«ã¤ã„ã¦ã¯ã€å¤šãã®åŒæ„ãŒå¾—られるã¨ã“ã‚ã ã¨æ€ã„ã¾ã™ã€‚解決ç–ã¨ã—ã¦ã¯ã€åŒã˜ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’複数㮠RDBMS ã«ä¿å˜ã™ã‚‹ã€Œsharding〠(別å：アプリケーションレベルパーティショニングï¼ãƒ¬ãƒ™ãƒ«ï¼’分散注1) ãŒä¸€èˆ¬çš„ã§ã™ãŒã€æœ€è¿‘ã§ã¯ã€åˆ†æ•£ã‚ーãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ (分散 KVS) を使ãŠã†ã¨ã™ã‚‹è©¦ã¿ã‚‚ã¿ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚ 分散 KVS ㌠RDBMS sharding ã«å¯¾ã—ã¦å„ªã‚Œã¦ã„ã‚‹è¦ç´ ã¨ã—ã¦ã¯ã€äº‹å‰ã®åˆ†å‰²è¨è¨ˆãŒä¸è¦ã§ã€å‹•çš„ãªãƒŽãƒ¼ãƒ‰è¿½åŠ （ã¨ãã‚Œã«ã¨ã‚‚ãªã†è² è·ã®å†åˆ†æ•£ï¼‰ãŒå®¹æ˜“ã€ã¨ã„ã£ãŸç‚¹ãŒæŒ™ã’られるã¨æ€ã„ã¾ã™ã€‚一方ã§ã€Kai ã‚„ Kumofs ã®ã‚ˆã†ãªæœ€è¿‘ã®å®Ÿè£…ã§ã¯ eventually consistent ã§ã“ãç„¡ããªã£ã¦ãã¦ã„ã‚‹ã‚‚ã®ã®ã€ãƒãƒƒã‚·ãƒ¥ãƒ™ãƒ¼ã‚¹ã®åˆ†æ•£ KVS ã¯ã€ãƒ¬ãƒ³ã‚¸ã‚¯ã‚¨ãƒªãŒã§ããªã‹ã£ãŸã‚Š (例:
ACM SIGMOD Online | SIGMOD Awards
2009 SIGMOD Edgar F. Codd Innovations Award Masaru Kitsuregawa Masaru Kitsuregawa is the recipient of the 2009 SIGMOD Edgar F. Codd Innovations Award for contributions to high-performance database technology. Kitsuregawa made major contributions to the development of hash-join algorithms, which significantly improved the performance of join operations in relational database systems. That work has
ã¸ã€œãŸã®ã‚ã‚‚:Hadoop 㨠RDBMS ã®æ€§èƒ½ã‚’比較ã—ã¦ã¿ãŸã€‚ã¨ã„ã†è«–文。ã®æ„Ÿæƒ³ã€‚ã®ç¿»è¨³ã€‚ - livedoor Blog（ブãƒã‚°ï¼‰
2009å¹´04月19æ—¥ Hadoop 㨠RDBMS ã®æ€§èƒ½ã‚’比較ã—ã¦ã¿ãŸã€‚ã¨ã„ã†è«–文。ã®æ„Ÿæƒ³ã€‚ã®ç¿»è¨³ã€‚ Stonebraker, DeWitt, et al. compare MapReduce to DBMS Map-Reduce (Hadoop)㨠Parallel DBMS (Vertica 㨠DBMS-X) ã®æ€§èƒ½ã‚’比較ã—ãŸã¨ã“ã‚ã€ãŠãŠã‚€ã DB ã®æ–¹ãŒæ€§èƒ½ãŒã‚ˆãã€ã‚±ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã¯ 6.5å€ã‚‚性能差ãŒã‚ã‚‹ã¨ã„ã†å®Ÿé¨“çµæžœãŒã€SIGMOD09 ã§ç™ºè¡¨ã•ã‚ŒãŸã‚‰ã—ã„。原論文ã¯ã“ã“ã‹ã‚‰ PDF ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãる。 以下㯠DBMS2 ã¨ã„ã†ãƒ–ãƒã‚°ã«æ›¸ã‹ã‚ŒãŸã€ã“ã®è«–文をèªã‚“ã 人ã®æ„Ÿæƒ³ã®ç¿»è¨³ã€‚ Stonebraker, DeWitt, et al. MapReduce 㨠DBMS ã®æ¯”較 5人ã®å…±è‘—者(主ç†è€…㯠Andy Pavlo ã£ã½ã„)ã¨ã¨ã‚‚ã«ã€Map-Reduce å«Œã„ã§çŸ¥ã‚‰ã‚Œ
Flash-Based DBMSã®æœ€å‰ç·š
フラッシュメモリーを使ã£ãŸSolid State Drive (SSD)ã®å®¹é‡ãŒ160GBã«åˆ°é”ã—ã€å¸‚å ´ä¾¡æ ¼ã‚‚ä¸‹ãŒã£ã¦ããŸã“ã¨ã«ã‚ˆã‚Šã€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®ä»£æ›¿å“ã¨ã—ã¦SSDを使ã†ç”¨é€”ãŒã„よã„よç¾å®Ÿå‘³ã‚’帯ã³ã¦ãã¾ã—ãŸã€‚低容é‡ã®ã‚‚ã®ãªã‚‰æ—¢ã«iPodやデジカメ用ã®ãƒ¡ãƒ‡ã‚£ã‚¢ãªã©èº«ã®å›žã‚Šã«ã‚‚æ™®åŠã—ã¦ãŠã‚Šã€å¸‚å ´ã§ã¯ã™ã§ã«ã€Œç ´å£Šçš„イノベーション（「イノベーションã®ã‚¸ãƒ¬ãƒ³ãƒžâ€•æŠ€è¡“é©æ–°ãŒå·¨å¤§ä¼æ¥ã‚’æ»…ã¼ã™ã¨ãã€ã‚ˆã‚Šï¼‰ã€ãŒèµ·ã“ã£ã¦ã„ã‚‹ã¨ã„ãˆã¾ã™ã€‚（HDDæ載ã®Walkmanã¨ã‹æ—¢ã«æ»…ã‚“ã§ã„る例もã‚ã‚‹ã—。。。）
プãƒã‚»ã‚¹å¿—å‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ (mark-wada blog)
ã“ã®ã‚ã„ã ã€ã€ŒSOA時代ã®ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’書ã„ãŸãŒã€ãã“ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’ã©ã†ã‚„ã‚‹ã‹ã«ã¯è¨€åŠã—ã¦ã„ãªã„。ãã‚Œã§ã€æœ€è¿‘ãã®ã“ã¨ã«ã¤ã„ã¦ãšã£ã¨è€ƒãˆã¦ã„ã‚‹ãŒã€ãªã‹ãªã‹ç”ãˆãŒè¦‹ã¤ã‹ã‚‰ãªã„。 データベースè¨è¨ˆã¨ã„ã†ã¨ã€DOAãŒæµ®ã‹ã‚“ã§ãã¾ã™ã€‚データç·ç ”ã®æ¤¿ã•ã‚“ã¯ã„ã¤ã‚‚ã€DOAã®æ¡ä»¶ã¨ã—ã¦ã€ã€Œãƒ‡ãƒ¼ã‚¿å…ˆè¡Œãƒ»ãƒªã‚½ãƒ¼ã‚¹å…ˆè¡Œãƒ»æ¦‚念先行ã€ã¨ã„ã†ã“ã¨ã‚’ãŠã£ã—ゃã£ã¦ã„ã¾ã™ã€‚データをプãƒã‚»ã‚¹ï¼å‡¦ç†ã«å…ˆè¡Œã—ã¦è€ƒãˆã€ã‚¤ãƒ™ãƒ³ãƒˆãƒ‡ãƒ¼ タ（å—注・出è·ãƒ»è«‹æ±‚ãªã©ï¼‰ã‚ˆã‚Šå…ˆã«ãƒªã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ï¼ˆç¤¾å“¡ãƒ»é¡§å®¢ãƒ»å•†å“ãªã©ï¼‰ã‚’固ã‚ã€ç‰©ç†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ˆã‚Šæ¦‚念データベースを先行ã™ã‚‹ã¨ã„ã†æ„味ã§ã™ã€‚ ã§ã¯ã€POA（ã¨ã„ã†è¨€è‘‰ãŒã‚ã‚‹ã¨ã™ã‚Œã°ï¼‰ã ã¨ã©ã†ãªã‚‹ã®ã§ã—ょã†ã‹ã€‚「プãƒã‚»ã‚¹å…ˆè¡Œãƒ»ãƒžã‚¯ãƒãƒ—ãƒã‚»ã‚¹å…ˆè¡Œãƒ»æ¦‚念先行ã€ã¨ã„ã£ãŸã¨ã“ã‚ã§ã—ょã†ã‹ã€‚ã—ã‹ã—データベースã¯ã©ã†ã™ã‚‹ã®ã ã®ç”ãˆã«ã¯ãªã£ã¦ã„ã¾ã›ã‚“。 DOAã ã¨ä¸€èˆ¬çš„ã«è¨€ã‚れるã®ã¯ã€ç”»é¢ã¨
エイプリルフールãƒã‚¿ï¼šã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹MySQL互æ›RDBMS - Scale41ãƒªãƒªãƒ¼ã‚¹ï¼ - Blog by Sadayuki Furuhashi
2009å¹´4月1æ—¥ã¯è¨˜å¿µã™ã¹ãæ—¥ã«ãªã£ãŸã¨ç¢ºä¿¡ã—ã¦ã„ã¾ã™ã€‚ 内部ã«çŠ¶æ…‹ã‚’æŒãŸãªã„アプリケーションサーãƒãƒ¼ã¯ã€ã‚µãƒ¼ãƒãƒ¼ã‚’足ã™ã ã‘ã§æ¯”較的簡å˜ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚一方ã§ACID特性ãŒæ±‚ã‚られる用途ã«ç”¨ã„ã‚‹RDBMSã¯ã€å˜ã«ã‚µãƒ¼ãƒãƒ¼ã‚’足ã™ã ã‘ã§ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã®ã¯éžå¸¸ã«å›°é›£ã§ã™ã€‚ システムãŒå¤§è¦æ¨¡ã«ãªã‚‹ã»ã©å¾ã€…ã«RDBMSã®æ€§èƒ½ãŒè¶³ã‚’引ã£å¼µã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã†ãŸã‚ã€é«˜ä¾¡ãªãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«é ¼ã£ã¦ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ãƒƒãƒ—ã›ã–ã‚‹ã‚’å¾—ãªã„ケースも多ã„ã§ã—ょã†ã€‚ データベースを水平ã«åˆ†å‰²ã—ã¦åˆ†æ•£ã•ã›ã‚‹æ–¹æ³•ã§ã¯ã€JOIN命令ãŒä½¿ãˆãªããªã‚‹ãªã©ã®åˆ¶ç´„ãŒç™ºç”Ÿã™ã‚‹ãŸã‚ã€ã‚らã‹ã˜ã‚データベースを分散ã•ã›ã‚‹ã“ã¨ã‚’念é ã«å…¥ã‚Œã¦ã‚¢ãƒ—リケーションをè¨è¨ˆã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æ—¢å˜ã®ã‚¢ãƒ—リケーションã¨ã®äº’æ›æ€§ã‚’ç¶æŒã—ãŸã¾ã¾ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’水平分割ã™ã‚‹ã®ã¯å›°é›£ã ã¨è¨€ãˆã¾ã™ã€‚ ãã“ã§ã€ã‚µãƒ¼ãƒãƒ¼ã‚’足ã™ã“ã¨ã§æ›¸ãè¾¼ã¿ãƒ»èªã¿è¾¼ã¿å…±
Yahoo!オークションã§ã®MySQL 冗長化技術
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10月1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ブãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEヤフー Tech Blog ã“ã‚“ã«ã¡ã¯ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ãƒ—ラットホーム技術ã®ãƒãƒ£ãƒƒã‚¯ã§ã™ã€‚ オークションã§ã¯ä¸€éƒ¨ã‚µãƒ¼ãƒ“ス㫠RDBMS ã® MySQL を使ã£ã¦ã‚µãƒ¼ãƒ“スをã”æä¾›ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ オークションã§ã¯å¤šãã®ãŠå®¢æ§˜ã‚ˆã‚Šã‚¢ã‚¯ã‚»ã‚¹ã‚’é ‚ã„ã¦ãŠã‚Šã¾ã™ã®ã§ã€å¤§é‡ã®æ›´æ–°ã€å‚ç…§ã®å‡¦ç†é€Ÿåº¦ã«å„ªã‚ŒãŸ MySQL ã‚’é¸æŠžã—ã€ãŠå®¢æ§˜ã«ã‚¹ãƒˆãƒ¬ã‚¹ãªãサービスをã”利用ã„ãŸã ã‘るよㆠ日々æ¥å‹™ã«å–り組ã¾ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ç²¾å¯†æ©Ÿå™¨ã«ã¯æ•…éšœãŒã¤ãã‚‚ã®ã§ã€ã‚µãƒ¼ãƒ“スé‹ç”¨ã®è¦³ç‚¹ã‹ã‚‰ã¯ 「機器ãŒæ•…éšœã™ã‚‹ã®ã¯ã—ã‹ãŸãªã„ã€ã—ã‹ã—ãれをã„ã‹ã«æ—©ã復旧ã•ã›ã‚‹ã‹ã€ ã¨ã„ã£ãŸã“ã¨ã‚’念é ã«å…¥ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ 実際ã«ã¯ã€éšœå®³ãŒèµ·ã“ã£ã¦ã‹ã‚‰å¾©æ—§ã•ã›ã‚‹ã®ã§ã¯ãªãã€éšœå®³ãŒç™ºç”Ÿã—ãŸå ´åˆã«
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL を使ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ーマレスã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL を使ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ーマレスã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ 目次 ã“ã®è¨˜äº‹ã«ã¤ã„㦠FriendFeed? ã§ã¯ MySQL を使ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ーマレスã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ 背景 概観 詳細 一貫性ã¨åŽŸå性 性能 FriendFeed? ã§ã¯ MySQL を使ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ーマレスã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„㦠"How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
bliki: Transactionless
A couple of years ago I was talking to a couple of friends of mine who were doing some work at eBay. It's always interesting to hear about the techniques people use on high volume sites, but perhaps one of the most interesting tidbits was that eBay mostly hardly ever uses database transactions. For most people, coming into a transactionless environment is quite a shock. Using transactions is a ver
Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes - Dare Obasanjo's weblog
Dare Obasanjo's weblog "You can buy cars but you can't buy respect in the hood" - Curtis Jackson Navigation for Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes - Dare Obasanjo's weblog Content Sidebar Footer Database sharding is the process of splitting up a database across multiple machines to improve the scalability of an application. The justification for databas
Leo's Chronicle: ãœã²æŠ¼ã•ãˆã¦ãŠããŸã„データベースã®æ•™ç§‘書
先日ã®ã‚¨ãƒ³ãƒˆãƒªã§å°‘ã—話ã—ãŸã®ã§ã™ãŒã€åƒ•ãŒåœ¨å¦ã—ã¦ã„ãŸã¨ãã®æ±å¤§ã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶ãŸã‚ã®ã‚³ãƒ¼ã‚¹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸï¼ˆDB関係ã®æŽˆæ¥ã¯å¹´ã«ï¼‘ã¤ã‹ï¼’ã¤ã‚る程度。ç¾åœ¨ã¯ã©ã†ãªã‚“ã ã‚ã†ï¼Ÿï¼‰ã€‚ãã‚“ãªã¨ãã«å½¹ã ã£ãŸã®ã¯ã€ã‚„ã¯ã‚Šæ•™ç§‘書。èªã¿ã‚„ã™ã„ã‚‚ã®ã‹ã‚‰é †ã«ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚（ã¨ã¯ã„ã£ã¦ã‚‚ã™ã¹ã¦è‹±èªžã®æœ¬ã§ã™ã€‚ã‚ã—ã‹ã‚‰ãšï¼‰ 一番ã®ãŠè–¦ã‚ã¯ã€Raghu Ramakrishnan先生 (ç¾åœ¨ã¯ã€Yahoo! Research) ã®ã€ŒDatabase Management Systems (3rd Edition)ã€ã€‚åˆå¦è€…ã‹ã‚‰ç ”究者ã¾ã§å¹…広ã使ãˆã¾ã™ã€‚データベース管ç†ã‚·ã‚¹ãƒ†ãƒ （DBMS）ã®åŸºæœ¬æ¦‚念ã‹ã‚‰ã€å•ã„åˆã‚ã›æœ€é©åŒ–ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ãªã©ã€ã“れらを実装・評価ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã€ã€ŒDBã®ä¸–ç•Œã§ã®å¸¸è˜ã€ãŒã€ä¸å¯§ãªèªžã‚Šå£ã§ãµã‚“ã ã‚“ã«ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®1冊をèªã‚“ã§ãŠã‘ã°ã€DBã®ä¸–ç•Œã§è°è«–ã™ã‚‹ãŸã‚ã®
Stanford大å¦ã¨U.C.Berkleyã«è¡Œã£ãŸã¨ãã®å‡ºæ¥äº‹ - yanbe.log
ã¯ã¦ãªã§ã®ç§ã«å¯¾ã™ã‚‹çš†ã•ã‚“ã®èªè˜ã¨ã„ã†ã¨ã€å¤šåˆ†Python使ã„ã¨ã‹Vimユーザã¨ã‹ã€QRコードデコーダã®é–‹ç™ºè€…ã¨ã„ã†ã®ãŒãƒ¡ã‚¤ãƒ³ã ã¨æ€ã„ã¾ã™ã€‚ãã‚Œã§ã€ã‚ã¾ã‚Šèªè˜ã•ã‚Œã¦ãªã„æ°—ãŒã—ã¾ã™ãŒã€ç§ã¯æ™®æ®µã¯å¤§å¦é™¢ç”Ÿã¨ã—ã¦å¤§å¦é™¢ã§ç ”究ã«å–り組んã§ã„ã¾ã™ã€‚ 実ã¯ã€ç¸ã‚ã£ã¦ã‚¿ã‚¤ãƒˆãƒ«ã®2ã¤ã®å¤§å¦ã«ã¯è¡Œã£ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚期間ã¯ã€å‰è€…ã¯çŸæœŸæ»žåœ¨ã§æ•°æ—¥ã€å¾Œè€…ã¯å…±åŒç ”究ã¨ã„ã†å½¢ã§6週間ã»ã©ã ã£ãŸã®ã§ã™ãŒã€ã“ã®æ™‚ã®ä½“験ãŒå®Ÿã¯ã‚·ã‚§ã‚¢ã™ã¹ãã€çµæ§‹é¢ç™½ã„ã‚‚ã®ã ã£ãŸã®ã§ã¯ãªã„ã‹ã€ã¨ã„ã†ã“ã¨ã§æ›¸ã„ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ Stanford大å¦ã§ã®å‡ºæ¥äº‹ ç§ãŒè¡Œã£ãŸã®ã¯DBLabãŒã€InfoLabã«æ”¹çµ„ã•ã‚ŒãŸå¾Œã§ã—ãŸã€‚InfoLabã¨ã„ã†ã®ã¯ã€id:taroleoã•ã‚“ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ•™ç§‘書ã®ç´¹ä»‹ã‚¨ãƒ³ãƒˆãƒª ã§ã‚‚紹介ã•ã‚Œã¦ã„ã‚‹Hector Garcia-Molina先生ãŒçŽ‡ã„るグループã§ã€éŽåŽ»ã«ã¯Googleã®å‰µå§‹è€…ãªã©ã‚’輩出ã—ãŸã“ã¨
ãŠçŸ¥ã‚‰ã›
障害
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Domain error
{{#tags}}- {{label}}
{{/tags}}