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

hiro_y id:hiro_y

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

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

NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•.markdown #NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³• åŽŸæ–‡ï¼šNoSQL Data Modeling Techniques Â« Highly Scala ble Blog I translated this article for study. contact matope[dot]ono[gmail] if any probl em. NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ä¸€è²«æ€§ã¨ã„ã£ãŸæ§˜ã€…ãªéžæ©Ÿèƒ½è¦ä»¶ã‹ã‚‰æ¯”è¼ƒã•ã‚Œã‚‹ã€‚NoSQLã®ã“ã®å´é¢ã¯å®Ÿè·µã¨ç†è«–ã®ä¸¡é¢ã‹ã‚‰ã‚ˆãç ”ç©¶ã•ã‚Œã¦ã„ã‚‹ã€‚ã‚ã‚‹ç¨®ã®éžæ©Ÿèƒ½ç‰¹æ€§ã¯NoSQLã‚’åˆ©ç”¨ã™ã‚‹ä¸»ãªå‹•æ©Ÿã§ã‚ã‚Šã€NoSQLã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆãé©ç”¨ã•ã‚Œã‚‹CAPå®šç†ãŒãã†ã§ã‚ã‚‹ã‚ˆã†ã«åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã®åŸºæœ¬çš„åŽŸå‰‡ã ã‹ã‚‰ã ã€‚ä¸€æ–¹ã§ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯ã‚ã¾ã‚Šç ”ç©¶ã•ã‚Œã¦ãŠã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒžãƒ†ã‚£ãƒƒã‚¯
hiro_y 2012/04/17
NoSQLãƒ¢ãƒ‡ãƒªãƒ³ã‚°

kvs

db
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
ã‚¹ãƒˆãƒªãƒ¼ãƒ å‡¦ç†ã«ãŠã‘ã‚‹Apache Avroã®æ´»ç”¨ã«ã¤ã„ã¦ï¼ˆNTTãƒ‡ãƒ¼ã‚¿ ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2019 è¬›æ¼”è³‡æ–™ã€2019/09/05ï¼‰
hiro_y 2011/08/22
å‰Šé™¤ãƒ•ãƒ©ã‚°ã€ã¨ã„ã†ã‹ç‰©ç†å‰Šé™¤ã—ãªã„ã§æ®‹ã—ã¤ã¤é‹ç”¨ã™ã‚‹ä»•çµ„ã¿

db
ãƒªãƒ³ã‚¯
ä¿¡ã˜ã‚‰ã‚Œãªã„DBæ–‡åŒ–ã€Œå›ºå®šé•·DBã€ã§ã‚‚ã‚ã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
ãšã„ã¶ã‚“æ™‚é–“ãŒã‚ã„ã¦ã—ã¾ã£ãŸã‘ã©ã€å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹RDBè¨è¨ˆã®ç¶šãã€‚ åƒ•ã¯ã“ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’è‡ªåˆ†ã®RDBã®çŸ¥è˜ã‚’ä½¿ã£ã¦é©æ–°ã—ã¦ã‚„ã‚ã†ã¨æ€ã£ã¦è‡¨ã‚“ã ã€‚ ã—ã‹ã—çµæžœã¨ã—ã¦é€†ã«ã€ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã«æœ€é©åŒ–ã•ã‚ŒãŸRDBã®ä½¿ã„æ–¹ã«ã¤ã„ã¦æ•™ã‚ã‚‹ã“ã¨ã«ãªã£ãŸã€‚ â€» ã‚ã¨ã€KVSã§ã„ã„ã˜ã‚ƒã‚“ã£ã¦è¨€ã£ã¦ã‚‹äººã‚‚ã„ã‚‹ã‘ã©ã€ãã‚Œã¯KVSå°Žå…¥ã®è‹¦åŠ´ã‚’çŸ¥ã‚‰ãªã„äººã ã¨æ€ã†ã€‚KVSã®è‹¦åŠ´ã¯å¾Œã§æ›¸ãã€‚ åƒ•ã‚‰ãŒæœ€è¿‘æ‰‹ãŒã‘ã¦ã„ã‚‹ã®ã¯ã€ã¨ã¦ã‚‚å¤§è¦æ¨¡ãªã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ 100ä¸‡äººã®å¥‘ç´„ãƒ¦ãƒ¼ã‚¶ãŒä½¿ã„ã€1ãƒ†ãƒ¼ãƒ–ãƒ«ã«1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’è²¯ã‚ã€24æ™‚é–“æ¢ã‚ã‚‹ã“ã¨ãŒè¨±ã•ã‚Œãšã€ è¦æ±‚ã‹ã‚‰å¿œç”ã¾ã§ã®ã‚¿ãƒ¼ãƒ³ã‚¢ãƒ©ã‚¦ãƒ³ãƒ‰ã‚¿ã‚¤ãƒ ãŒ1ç§’ä»¥å†…ã¨ã„ã†åŽ³ã—ã„SLAã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€‚ ä¸ã§ã‚‚åƒ•ã¯DBã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®è¨è¨ˆã¨ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã£ã½ã„ã“ã¨ã‚’æ‹…å½“ã—ã¦ã„ã‚‹ã€‚ åƒ•ãŒã“ã®ç¾å ´ã«æ¥ã¦ã€é©šæ„•ã—ãŸæ–‡åŒ–ãŒ2ã¤ã‚ã‚‹ ãã‚Œã¯ã€ŒJoinç¦æ¢
hiro_y 2011/08/09
ã€Œã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢ãƒ»æ“ä½œãƒ»é›†è¨ˆã®ç¯„å›²ãŒåºƒç¯„å›²ã«ãªã‚‹ã“ã¨ã¯ãªã„ã€‚ã¾ãŸã¯è¨è¨ˆä¸Šã§å›žé¿å‡ºæ¥ã‚‹ã€ã€ŒDBã‚µãƒ¼ãƒãƒ¼ã¯åŸºæœ¬çš„ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆï¼ˆã‚µãƒ¼ãƒãƒ¼å¢—è¨ã™ã‚‹ï¼‰ãŒå‡ºæ¥ãªã„ã€

db

oracle
ãƒªãƒ³ã‚¯
24live.jpÂ -Â 24live ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
hiro_y 2011/08/08
Twitterçš„ãªã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã®å®Ÿè£…ã‚’è€ƒãˆã¦ã‚‹

db
ãƒªãƒ³ã‚¯
Big Data in Real-Time at Twitter
The document summarizes how Twitter handles and analyzes large amounts of real-time data, including tweets, timelines, social graphs, and search indices. It describes Twitter's original implementations using relational databases and the probl ems they encountered due to scale. It then discusses their current solutions, which involve partitioning the data across multiple servers, replicating and ind
hiro_y 2010/04/21
Twitterã®ã‚¹ã‚±ãƒ¼ãƒ«ã€QConç™ºè¡¨è³‡æ–™ã€‚

twitter

system

db
ãƒªãƒ³ã‚¯
ãªãœTwitterã¯ä½Žé…å»¶ã®ã¾ã¾ã‚¹ã‚±ãƒ¼ãƒ«ã§ããŸã®ã‹ ç§’é–“120ä¸‡ã¤ã¶ã‚„ãã‚’å‡¦ç†ã€Twitterã‚·ã‚¹ãƒ†ãƒ ã®â€œä»Šâ€ âˆ’ ï¼ IT
ãƒ¦ãƒ¼ã‚¶ãƒ¼åŒå£«ã®ã¤ãªãŒã‚Šã‚’å…ƒã«æ™‚ç³»åˆ—ã«140æ–‡å—ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’20å€‹ã»ã©è¡¨ç¤ºã™ã‚‹â€•â€•ã€‚Twitterã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€æ–‡å—ã«ã—ã¦ã—ã¾ã†ã¨å®Ÿã«ã‚·ãƒ³ãƒ—ãƒ«ã ãŒã€èƒŒå¾Œã«ã¯éžå¸¸ã«å¤§ããªæŠ€è¡“çš„ãƒãƒ£ãƒ¬ãƒ³ã‚¸ãŒæ¨ªãŸã‚ã£ã¦ã„ã‚‹ã€‚ã¤ã¶ã‚„ãæ•°ã¯æœˆé–“10å„„ä»¶ã‚’çªç ´ã€Twitterã‚’æµã‚Œã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸æ•°ã¯ç§’é–“120ä¸‡ã«ã‚‚é”ã—ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼åŒå£«ã®ã¤ãªãŒã‚Šã‚’è¡¨ã™ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ»ã‚°ãƒ©ãƒ•ã§ã™ã‚‰ãƒ¡ãƒ¢ãƒªã«è¼‰ã‚‹é‡ã‚’è¶…ãˆã¦ã„ã‚‹ã€‚é€”æ–¹ã‚‚ãªã„ã‚¹ã‚±ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¤ãªã„ã§ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€0.1ç§’ä»¥ä¸‹ã§Webãƒšãƒ¼ã‚¸ã®è¡¨ç¤ºã‚’å®Œäº†ã•ã›ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ãã®ãŸã‚ã«å„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯1ï½ž5msç¨‹åº¦ã§å¿œç”ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ Twitterã®ãƒªã‚¹ãƒˆæ©Ÿèƒ½ã®å®Ÿè£…ã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒªãƒ¼ãƒ€ãƒ¼ã‚’å‹™ã‚ãŸã“ã¨ã‚‚ã‚ã‚‹Nick Kallenæ°ãŒæ¥æ—¥ã—ã€2010å¹´4æœˆ19æ—¥ã‹ã‚‰2æ—¥é–“ã®äºˆå®šã§é–‹å‚¬ä¸ã®ã€ŒQCon Tokyo 2010ã€ã§åŸºèª¿è¬›æ¼”ã‚’è¡Œã£ãŸã€‚ã€ŒData Architecture
hiro_y 2010/04/21
Twitterã®ã‚¹ã‚±ãƒ¼ãƒ«ã®ä»•çµ„ã¿ã€‚ã€Œé€”æ–¹ã‚‚ãªã„ã‚¹ã‚±ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¤ãªã„ã§ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€0.1ç§’ä»¥ä¸‹ã§Webãƒšãƒ¼ã‚¸ã®è¡¨ç¤ºã‚’å®Œäº†ã•ã›ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ãã®ãŸã‚ã«å„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯ 1ã€œ5msç¨‹åº¦ã§å¿œç”ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ã€

twitter

system

db
ãƒªãƒ³ã‚¯
Webã‚¢ãƒ—ãƒªã‚’ã¨ã‚Šã¾ãæœ€è¿‘ã®KVSäº‹æƒ…ã€é›‘æ„Ÿ - Tous Les Jours æ”»é˜²è¨˜
RDBã®å¾©æ¨©ã¯ã—ã°ã‚‰ããªã„ã¨æ€ã† æœ€è¿‘ç›®ã«ã—ãŸã®ã¯ã€ã€Œã“ã‚Œã‹ã‚‰RDBãŒååˆ†é€Ÿããªã£ã¦ã„ãã®ã§ã€memcachedã«ä»£ã‚ã£ã¦RDBãŒã¾ãŸä½¿ã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€ã¨ã„ã†æ„è¦‹ã€‚ã“ã‚Œã¯ã—ã°ã‚‰ãã®é–“ã¯ç„¡ã„ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã†ã€‚å…¨ãƒ‡ãƒ¼ã‚¿ãŒã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã ã£ãŸã¨ã—ã¦ã‚‚ã€KVSã¯RDBã‚ˆã‚Šä¸€æ¡ä»¥ä¸Šé€Ÿã„ï¼ˆMemcachedã§100,000req/secå‡ºã›ã‚‹ãƒžã‚·ãƒ³ã§ã€MySQLã®pkeyã«ã‚ˆã‚‹å˜ç´”ãªSELECTã‚’ã—ãŸå ´åˆã€10,000req/secå‡ºã‚‹ã‹ã©ã†ã‹ï¼‰ã€‚SQLãƒ‘ãƒ¼ã‚µã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã‚’æ¨ã¦ãªã„é™ã‚Šã“ã®é€Ÿã•ã«ã¯å¯¾æŠ—ã§ããªã„ã€‚RDBã«ã¯ã€ï¼‘ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ï¼‘ã‚¹ãƒ¬ãƒƒãƒ‰ã¨ã„ã†ãƒ¢ãƒ‡ãƒ«ãŒæŒã¤ã€æŽ¥ç¶šæ•°ãŒã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã„ã¨ã„ã†åˆ¶ç´„ã‚‚ã‚ã‚‹ã€‚ ã¾ãŸã€memcacheãƒ—ãƒãƒˆã‚³ãƒ«ã¯ã€get_multiãŒä½¿ãˆã‚‹ã€‚get_multiã‚’åŠ¹æžœçš„ã«æ´»ç”¨ã—ãŸå ´åˆã€RDBã¨ã®å·®ã¯ã•ã‚‰ã«åºƒãŒã‚‹ã¨æ€ã†ã€‚ RDBã§å¤§ä¸ˆå¤«ãªã‚¢ãƒ—ãƒªã‚‚ Viewã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒåŠ¹æžœçš„ãªã‚¢
hiro_y 2009/11/15
KVSã®å„ªä½æ€§ã€ãã—ã¦RDBã¨é•ã£ã¦è«¦ã‚ãªã‘ã‚Œã°ã„ã‘ãªã„ã“ã¨ã€‚ã€Œãƒ¬ãƒ³ã‚¸ã‚¯ã‚¨ãƒªãŒä½¿ãˆãªã„å ´åˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ§‹é€ è‡ªä½“ã‚’KVSä¸Šã®ï¼‘ãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ã—ã¦æŒã¤å¿…è¦ãŒã‚ã‚‹ã€ã¨ã‹ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æœ‰ç„¡ã¨ã‹ã€‚

kvs

db
ãƒªãƒ³ã‚¯
ã‚¹ã‚ãƒ¼ãƒžä¸å®šã®ãƒ‡ãƒ¼ã‚¿ã‚’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.techno logiesèªŒã«MapReduceã®è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸ inoue 2010-11-25 æŠ€è¡“è©•è«–ç¤¾ãƒ‘ãƒ¼ãƒ•ã‚§ã‚¯ãƒˆã‚·ãƒªãƒ¼ã‚ºçµ¶è³›ç™ºå£²ä¸ inoue 2010-11-24 é›‘èªŒé€£è¼‰ã€ŒEmacsã®ãƒˆãƒ©ãƒŽãƒžã‚ã€ã®åŽŸç¨¿(part8)å…¬é–‹ inoue 2010-11-22 RESTã®å½“æƒ‘ inoue 2010-11-22 ã€Œãƒ—
hiro_y 2009/11/06
ã‚¹ã‚ãƒ¼ãƒžãŒæ±ºã¾ã£ã¦ãªã„ãƒ‡ãƒ¼ã‚¿ã‚’ã©ã†DBã«ã¤ã£ã“ã‚€ã‹ã€‚

db
ãƒªãƒ³ã‚¯
MySQL Clusteré€²åŒ–ã®æ´å²
MySQL Clusteré–‹ç™ºè€…ã®ä¸€äººã§ã‚ã‚‹Frazer Clementæ°ãŒãã®æ´å²ã«ã¤ã„ã¦ã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ã‚¨ãƒ³ãƒˆãƒªã‚’è‡ªèº«ã®ãƒ–ãƒã‚°ã§ç¶´ã£ã¦ã„ã‚‹ã®ã ãŒã€ã„ã‹ã‚“ã›ã‚“è‹±èªžã®é•·æ–‡ã§æ—¥æœ¬äººã«ã¯è¾›ã„ã‹ã‚‚çŸ¥ã‚Œãªã„ã®ã§ä»Šæ—¥ã¯ãã®æ—¥æœ¬èªžè¨³ã‚’çš†ã•ã‚“ã«ã‚‚ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã†ã€‚é€²åŒ–ã®æ´å²ã¨ãã®çµæžœç”Ÿã˜ãŸæ§‹é€ ã‚’çŸ¥ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€MySQL Clusterã®ä»•çµ„ã¿ã«èˆˆå‘³ã‚’æŒã£ã¦é ‚ã‘ã‚‹ã¨å¹¸ã„ã§ã‚ã‚‹ã€‚ï¼ˆã‚ã‹ã‚Šè¾›ã„ã¨ã“ã‚ã«ã¯ã¨ã“ã‚ã©ã“ã‚è¨³è€…ã«ã‚ˆã‚‹æ³¨é‡ˆã‚’å…¥ã‚Œã¦ã‚ã‚‹ã€‚ãŸã ã—ç¿»è¨³ã¯çµæ§‹å¤§ã–ã£ã±ãªã®ã§ã€è‹±èªžãŒé”è€…ã§ã‚ã‚Œã°ç´°ã‹ã„ãƒ‹ãƒ¥ã‚¢ãƒ³ã‚¹ãªã©ã¯ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚¨ãƒ³ãƒˆãƒªã‚’å‚ç…§ã—ã¦é ‚ããŸã„ã€‚ãªãŠã€æ—¥æœ¬èªžè¨³ã‚’ã™ã‚‹ã“ã¨ã«é–¢ã—ã¦ã¯Frazeræ°ã®äº†è§£ã‚’å¾—ã¦ã„ã‚‹ã®ã§ã‚ã—ã‹ã‚‰ãšã€‚ï¼‰ NDBï¼ˆMySQL Clusterã®ç•¥ç§°ã€‚å…ƒã€…ã¯Network DBã¨ã„ã†åç§°ã§ã‚ã£ãŸã€‚ï¼‰ã®é–‹ç™ºã®æ£ç¢ºãªæ´å²ã«ã¤ã„ã¦ã€ãã£ã¨ä»–ã®èª°ã‹ã®ã»ã†ãŒä¸Šæ‰‹ãè§£èª¬ã§ãã‚‹ã¨æ€ã†ã®ã ãŒã€é™ã‚‰ã‚Œã¦
hiro_y 2009/10/21
MySQL Clusterã®æ´å²ã€ä»•çµ„ã¿ã€‚

mysql

db
ãƒªãƒ³ã‚¯
Richard Jones | Anti-RDBMS: A list of distributed key-value stores | Richard Jones, Esq.
Please Note: this was written January 2009 - see the comments for updates and additional information. A lot has changed since I wrote this. Perhaps youâ€™re considering using a dedicated key-value or document store instead of a traditional relational database. Reasons for this might include: You're suffering from Cloud-computing Mania. You need an excuse to 'get your Erlang on' You heard CouchDB was
hiro_y 2009/10/20
KVSæ¯”è¼ƒã€‚æ—¥æœ¬ã‹ã‚‰ã¯KaiãŒã€‚MemcacheDBã®è©•ä¾¡é«˜ã„ã€‚

kvs

db
ãƒªãƒ³ã‚¯
https://memcachedb.org/
hiro_y 2009/10/07
ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«Berkeley DBã‚’ä½¿ã†memcachedãƒ—ãƒãƒˆã‚³ãƒ«äº’æ›ã®KVSã€‚

db

kvs

memcache
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: PostgreSQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
å…ˆæ—¥æ›¸ã„ãŸã€ŒMySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•ã€ã«ã¤ã„ã¦ã€PostgreSQL ã§ã‚‚ pg_stat_activity ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’å–å¾—ã§ãã‚‹ã¨ higepon ã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ % ppdump > ppdump.txt ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã‚’ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚° (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§100ç§’é–“ç¨‹åº¦) ã—ã¦ã€ % ppfilter < ppdump.txt | ppreport ã®ã‚ˆã†ã«ã™ã‚‹ã¨ã€å¹³å‡è² è·ã®é«˜ã„ã‚¯ã‚¨ãƒªã‹ã‚‰é †ã«ã‚½ãƒ¼ãƒˆã•ã‚Œã¦è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚è©³ã—ã„ä½¿ã„æ–¹ã‚„è€ƒãˆæ–¹ã«ã¤ã„ã¦ã¯ã€mprofile ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ã”å‚ç…§ãã ã•ã„ã€‚ pprofile ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã€/platform/postgresql/pprofile â€“ CodeRepos::Share â€“ Tracã«ç½®ã„ã¦ã‚ã‚Šã¾ã™ã€‚è² è·ãŒé«˜ã„ PostgreSQL ç’°å¢ƒãŒæ‰‹å…ƒã«ãªã„ã®
hiro_y 2009/07/27
PostgreSQLã®ã‚¯ã‚¨ãƒªã®å‡¦ç†çŠ¶æ³ã‚’å®šæœŸçš„ã«æŽ¡å–â†’è§£æžã€‚

postgresql

db
ãƒªãƒ³ã‚¯
up and running with cassandra
Cassandra is a hybrid non-relational database in the same class as Googleâ€™s BigTable. It is more featureful than a key/value store like Riak, but supports fewer query types than a document store like Mongo DB. Cassandra was started by Facebook and later transf erred to the open-source community. It is an ideal runtime database for web-scale domains like social networks. This post is both a tutorial
hiro_y 2009/07/07
Cassandraã®Rubyã‹ã‚‰ã®ä½¿ã„æ–¹ã€‚Twitterã§ä½¿ã†ã®ã‹ãªã€‚ã€ŒWe're beginning to use Cassandra at Twitterã€

db

kvs

ruby

twitter
ãƒªãƒ³ã‚¯
Facebookã€Googleã®BigTableãƒ©ã‚¤ã‚¯ãªãƒ—ãƒãƒ€ã‚¯ãƒˆã€ŒCassandraã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–
Code Archive Skip to content Google About Google Privacy Terms
hiro_y 2009/07/07
Facebookã«ã‚ˆã‚‹BigTableã¿ãŸã„ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€‚

db

kvs

facebook
ãƒªãƒ³ã‚¯
ã‚‚ã†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
hiro_y 2009/07/04
åˆ†æ•£åž‹ã®key-valueã‚¹ãƒˆã‚¢ã«ã¤ã„ã¦ã€‚

db
ãƒªãƒ³ã‚¯
SQLã®likeæ¼”ç®—åã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…è¦ãªæ–‡å— - teraccâ€™s blog
ã¾ã¨ã‚ã‚‹ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ Oracle % _ ï¼…(å…¨è§’ï¼‰ï¼¿(å…¨è§’) DB2 % _ ï¼…(å…¨è§’ï¼‰ï¼¿(å…¨è§’) MS SQL Server % _ [ MySQL % _ PostgreSQL % _ æ³¨æ„ç‚¹ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã€‚ DB2ã€Oracleã¯ã€ã€Œï¼…ã€ã€Œï¼¿ã€ï¼ˆå…¨è§’ï¼‰ã‚‚ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã¨ã—ã¦è§£é‡ˆã™ã‚‹ SQL Serverã¯ã€[a-z]ã®ã‚ˆã†ãªæ£è¦è¡¨ç¾çš„ãªè¨˜è¿°ã‚’è§£é‡ˆã™ã‚‹ å½“ç„¶ã€ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰çš„ãªæ©Ÿèƒ½ã‚’æŒãŸã›ãŸã„ã€Œ%ã€ã‚„ã€Œ_ã€ç‰ã¯ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…±é€šã®è©±ã¨ã—ã¦ã€ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—è‡ªä½“ã‚‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ï¼ˆMySQLã€Postgresã§ã¯ã€Œ\ã€ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—ï¼‰ likeã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã‚’ã—ãŸå¾Œã«ã€Prepared Statementã§å€¤ã‚’SQLã«ãƒã‚¤ãƒ³ãƒ‰ã™ã‚‹ ï¼ˆé–¢é€£ï¼‰2008-07-10 - T.Teradaã®æ—¥è¨˜
hiro_y 2009/07/04
likeã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…è¦ãªæ–‡å—ã¾ã¨ã‚ã€‚

sql

db

mysql

postgresql

oracle

sqlserver

db2
ãƒªãƒ³ã‚¯
MySQLã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹æ§‹ç¯‰
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã€ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã®Wangã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ï¼ˆä»¥ä¸‹DWHï¼‰ã¨ã„ã†è¨€è‘‰ã«ãªã˜ã¿ã®ãªã„æ–¹ã¯æ¤œç´¢ã—ã¦ã„ãŸã ã„ãŸã»ã†ãŒã‚ˆã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ æ¤œç´¢ã™ã‚‹ã®ãŒã‚ã‚“ã©ã„ã€ã¨ã„ã†æ–¹ã¯ã€ã‹ã¿ç •ã„ãŸè¡¨ç¾ãŒã§ããªãã¦æç¸®ã§ã™ãŒã€ åŸºå¹¹ç³»ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰æŠ½å‡ºã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ç›®çš„ã‚’ã‚‚ã£ã¦å†æ§‹æˆã—ã€ ä½¿ç”¨å¯èƒ½ãªçŠ¶æ…‹ã«ä¿ç®¡ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã®é›†åˆä½“ã€ã¨ãŠè€ƒãˆãã ã•ã„ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€å…·ä½“çš„ã«ã¯å‡ºå“ã€å…¥æœã€è½æœãªã©ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã‚„ã€ ãã‚Œã‚’ã„ã‚ã„ã‚ãªå˜ä½ã§é›†è¨ˆã—ãŸãƒ‡ãƒ¼ã‚¿ãªã©ãŒè©²å½“ã—ã¾ã™ã€‚ ã“ã“ã§ã„ã†å˜ä½ã¨ã„ã†ã®ã¯ãŸã¨ãˆã°ã€æ—¥ã”ã¨ã€é€±ã”ã¨ã€æœˆã”ã¨ã‚„ã€ä»¥å‰ã®è¨˜äº‹ã§ã‚‚ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ ã‚«ãƒ†ã‚´ãƒªã¨ã„ã£ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ ã“ã†ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ã¯ã€é‹ç”¨ã€é‹å–¶ã€
hiro_y 2009/06/24
DWHã¨ã—ã¦ã®MyISAMã€‚ãƒãƒƒãƒå‡¦ç†ãŒä¸å¿ƒã ã‹ã‚‰ç„¡å•é¡Œã€‚

mysql

db
ãƒªãƒ³ã‚¯
Google Fusion Tables (Beta)
Upload small or large data sets from spreadsheets or CSV files. Visualize your data on maps, timelines and charts. Pick who can access your data; hide parts of your data if needed. Merge data from multiple tables. Discuss your data with others. Track changes and discussions. Take a tour
hiro_y 2009/06/24
ãƒ‡ãƒ¼ã‚¿/DBå…±æœ‰ã€‚http://www.computerworld.jp/topics/google/150389.html

service

google

db
ãƒªãƒ³ã‚¯
Project Voldemort
Voldemort is a distributed key-value storage system Data is automatically replicated over multiple servers. Data is automatically partitioned so each server contains only a subset of the total data Server failure is handled transparently Pluggable serialization is supported to allow rich keys and values including lists and tuples with named fields, as well as to integrate with common serialization
hiro_y 2009/06/23
LinkedInã§ä½¿ã‚ã‚Œã¦ã‚‹key-valueã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€‚

db

java
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
hiro_y 2009/05/26
MySQLã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã¾ã¨ã‚ã€‚ã€Œ--single-transaction ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã—ã¦dump ä¸ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒãƒƒã‚¯ã‚’ã‹ã‘ãªã„ã€

mysql

db
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸