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

holysugar id:holysugar

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

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

Flash-Based DBMSã®æœ€å‰ç·š
ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ¡ãƒ¢ãƒªãƒ¼ã‚’ä½¿ã£ãŸSolid State Drive (SSD)ã®å®¹é‡ãŒ160GBã«åˆ°é”ã—ã€å¸‚å ´ä¾¡æ ¼ã‚‚ä¸‹ãŒã£ã¦ããŸã“ã¨ã«ã‚ˆã‚Šã€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®ä»£æ›¿å“ã¨ã—ã¦SSDã‚’ä½¿ã†ç”¨é€”ãŒã„ã‚ˆã„ã‚ˆç¾å®Ÿå‘³ã‚’å¸¯ã³ã¦ãã¾ã—ãŸã€‚ä½Žå®¹é‡ã®ã‚‚ã®ãªã‚‰æ—¢ã«iPodã‚„ãƒ‡ã‚¸ã‚«ãƒ¡ç”¨ã®ãƒ¡ãƒ‡ã‚£ã‚¢ãªã©èº«ã®å›žã‚Šã«ã‚‚æ™®åŠã—ã¦ãŠã‚Šã€å¸‚å ´ã§ã¯ã™ã§ã«ã€Œç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã€Œã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¸ãƒ¬ãƒ³ãƒžâ€•æŠ€è¡“é©æ–°ãŒå·¨å¤§ä¼æ¥ã‚’æ»…ã¼ã™ã¨ãã€ã‚ˆã‚Šï¼‰ã€ãŒèµ·ã“ã£ã¦ã„ã‚‹ã¨ã„ãˆã¾ã™ã€‚ï¼ˆHDDæè¼‰ã®Walkmanã¨ã‹æ—¢ã«æ»…ã‚“ã§ã„ã‚‹ä¾‹ã‚‚ã‚ã‚‹ã—ã€‚ã€‚ã€‚ï¼‰
holysugar 2009/04/24
database

ssd
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - 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/
holysugar 2009/03/05
mysql

database
ãƒªãƒ³ã‚¯
æº€è¶³ã›ã‚‹è±šã€‚çœ ãŸã’ãªãƒãƒã€‚:ãƒ¬ãƒ™ãƒ«1åˆ†æ•£ã§ã‚‚ DB ã§ JOIN ã•ã›ã‚‹æ–¹æ³•
ã„ã‚ã‚†ã‚‹ mixi ã®ãƒ¬ãƒ™ãƒ«1åˆ†æ•£ã¨ã„ã†ã‚‚ã®ãŒã‚ã£ã¦ã€ã€Œjoin ã¯ä½¿ã‚ãªã„(æ–¹ãŒã„ã„ã‚±ãƒ¼ã‚¹ã‚‚ã‚ã‚‹)ã€ã¨ã„ã†ã‚ˆã†ãªè©±ã‚‚å‡ºã¦ããŸã‚Šã™ã‚‹ã‚“ã§ã™ãŒã€join ã§è§£æ±ºã§ãã‚‹å•é¡Œã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰æ›¸ãã‚ˆã‚Šã‚‚ DB ã«ã‚„ã‚‰ã›ãŸã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ ä¸€æ–¹ã§ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯åˆ¥ã® DB ä¸Šã«è¼‰ã£ã¦ã„ã‚‹ã®ã§ã€ãµã¤ã†ã« join ã™ã‚‹ã‚ã‘ã«ã¯ã„ãã¾ã›ã‚“ã€‚ ã¦ã“ã¨ã§ã€ç„¡ç†ã‚„ã‚Š join ã—ã‚ˆã†ã¨ã‚„ã£ã¦ã¿ãŸæ‰‹ã€‚ ã¾ãšã€db_a ã«è¼‰ã£ã¦ã„ã‚‹ table_a ã®å¿…è¦ãªãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã—ã¾ã™ã€‚ ã‚“ã§ã€ãã„ã¤ã®1ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ã¤ãä¸€ã¤ã® select å¥ã‚’ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ç”Ÿæˆã—ã¾ã™ã€‚ select v1 as name1 , v2 as name2 , v3 as name3 , v4 as name4 ãã—ã¦ã§ãã‚ãŒã£ãŸ select å¥ã‚’ union all. ãƒãƒ¼ã‚¿ãƒ–ãƒ«ãªå³å¸ view ã®ã§ãã‚ãŒã‚Šã€‚ ã“ã®ã§ãã‚
holysugar 2009/01/27
database

sql
ãƒªãƒ³ã‚¯
Google Research Publication: Bigtable: A Distributed Storage System for Structured Data
Bigtable: A Distributed Storage System for Structured Data Fay Chang, Jeffrey Dean, Sanjay Ghemawat, Wilson C. Hsieh, Deborah A. Wallach, Mike Burrows, Tushar Chandra, Andrew Fikes, and Robert E. Gruber Abstract Bigtable is a distributed storage system for managing structured data that is designed to scale to a very large size: petabytes of data across thousands of commodity servers. Many projec
holysugar 2006/09/13
Google

BigTable

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 ã‚¤ãƒ³ãƒ•ãƒ©ã®ä¸Šã«ä½œã‚‰ã‚ŒãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹. å°‘ã—å¤‰ã‚ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨, é‹ç”¨ã¾ã§ãƒ¯ãƒ³ã‚»ãƒƒãƒˆã®ãƒ˜ãƒ“ãƒ¼ãªå®Ÿè£…ã‚’æŒã¤. å®Ÿè£…ã®è©±ã‚‚ã¾ã‚é¢ç™½ã„ã‚“ã ã‘ã‚Œã©, ãã‚Œã‚ˆã‚Šãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ãŒå°è±¡çš„ã ã£ãŸ. å…ˆã«ãã®
holysugar 2006/09/13
Bigtableã«ã¤ã„ã¦

google

bigtable

database
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

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

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

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

ã‚¿ã‚°

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

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

ãŠçŸ¥ã‚‰ã›

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

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

ã€iOSã‚¢ãƒ—ãƒªã€‘ã‚¢ãƒ—ãƒªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®ãŠçŸ¥ã‚‰ã›ï¼šç‰¹å®šç”»é¢ã§ã‚¢ãƒ—ãƒªãŒå¿œç”ã—ãªããªã‚‹å•é¡Œã‚’ä¿®æ£ã—ã¾ã—ãŸ

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

ã‚¿ã‚°

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

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

Flash-Based DBMSã®æœ€å‰ç·š

HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚­ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å­˜ã—ã¦ã„ã‚‹ã®ã‹

æº€è¶³ã›ã‚‹è±šã€‚çœ ãŸã’ãªãƒãƒã€‚:ãƒ¬ãƒ™ãƒ«1åˆ†æ•£ã§ã‚‚ DB ã§ JOIN ã•ã›ã‚‹æ–¹æ³•

Google Research Publication: Bigtable: A Distributed Storage System for Structured Data

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

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

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

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

ã€iOSã‚¢ãƒ—ãƒªã€‘ã‚¢ãƒ—ãƒªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®ãŠçŸ¥ã‚‰ã›ï¼šç‰¹å®šç”»é¢ã§ã‚¢ãƒ—ãƒªãŒå¿œç­”ã—ãªããªã‚‹å•é¡Œã‚’ä¿®æ­£ã—ã¾ã—ãŸ

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

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

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

Flash-Based DBMSã®æœ€å‰ç·š

HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹

æº€è¶³ã›ã‚‹è±šã€‚çœ ãŸã’ãªãƒãƒã€‚:ãƒ¬ãƒ™ãƒ«1åˆ†æ•£ã§ã‚‚ DB ã§ JOIN ã•ã›ã‚‹æ–¹æ³•

ãŠçŸ¥ã‚‰ã›

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

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

ã€iOSã‚¢ãƒ—ãƒªã€‘ã‚¢ãƒ—ãƒªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®ãŠçŸ¥ã‚‰ã›ï¼šç‰¹å®šç”»é¢ã§ã‚¢ãƒ—ãƒªãŒå¿œç”ã—ãªããªã‚‹å•é¡Œã‚’ä¿®æ£ã—ã¾ã—ãŸ

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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