[B! rdbms] shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shinichitomita id:shinichitomita

rdbmsã«é–¢ã™ã‚‹shinichitomitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

FathomDBã€ã€Œã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªRDBã‚’Database-as-a-Serviceã§æä¾›ã™ã‚‹ã€ã¨å®£è¨€
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å¼±ãã€ãã®ãŸã‚ã«ã‚¯ãƒ©ã‚¦ãƒ‰å¯¾å¿œã®å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦NoSQLã¨å‘¼ã°ã‚Œã‚‹ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ³¨ç›®ãŒé›†ã¾ã£ã¦ã„ã‚‹ã“ã¨ã¯ã€ã“ã‚Œã¾ã§ã«Publickeyã®è¨˜äº‹ã¨ã—ã¦ç´¹ä»‹ã—ã¦ãã¾ã—ãŸã€‚ ã€ŒNoSQLã€ã¯ã€ŒNot Only SQLã€ã§ã‚ã‚‹ã€ã¨å®šç€ã™ã‚‹ã‹ï¼Ÿ NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’40ç¨®é¡žä»¥ä¸Šãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã€ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ã«ã‚‚ã„ã‚ã„ã‚ã‚ã‚‹ MySQL+Memcachedã®æ™‚ä»£ã¯éŽãŽã€ã“ã‚Œã‹ã‚‰ã¯NoSQLãªã®ã‹ã€ã«ã¤ã„ã¦ã®è°è«– ã—ã‹ã—ã€ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹ã€ã¨å®£è¨€ã—ã¦ã€ãã‚Œã‚’å®Ÿç¾ã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ãŒã‚ã‚Šã¾ã™ã€‚FathomDBã§ã™ã€‚ Database-as-a-Serviceã‚’æä¾›ã™ã‚‹ãƒ™ãƒ³ãƒãƒ£ãƒ¼ FathomDBã¯ç¾åœ¨ã€Amazonã‚¯ãƒ©ã‚¦ãƒ‰2ã‚„Rackspaceã®ä¸Šã§MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é‹ç”¨ã‚’ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›ã—ã¦ã„ã¾ã™ã€‚
shinichitomita 2010/04/01
database

cloud

rdbms

mysql
ãƒªãƒ³ã‚¯
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
shinichitomita 2009/12/06
ä¼æ¥å‘ã‘ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚°ãƒ©ãƒ•ãŒå¯†ã€ã€Œè‡ªå‹•åŒ–ã¸ã®è¦æ±‚ã€çŸ¥æµã¨å‹‡æ°—ã¨æ ¹æ€§ãŒåŠ¹ã‹ãªã„ / Force.comã‚’åˆ†æ•£KVSã¨è¦‹ã¦ã„ã‚‹

database

rdbms

kvs

enterprise

salesforce
ãƒªãƒ³ã‚¯
Amazon Relational Database Service (Amazon RDS)
Amazon Relational Database Service (Amazon RDS) is an easy-to-manage relational database service optimized for total cost of ownership. It is simple to set up, operate, and scale with demand. Amazon RDS automates undifferentiated database management tasks, such as provisioning, configuring, backing up, and patching. Amazon RDS allows customers to create a new database in minutes and offers flexibi
shinichitomita 2009/10/27
amazon

rdbms

mysql

cloud
ãƒªãƒ³ã‚¯
ã‚¹ã‚ãƒ¼ãƒžä¸å®šã®ãƒ‡ãƒ¼ã‚¿ã‚’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 ã€Œãƒ—
shinichitomita 2009/10/05
æ§‹é€ å†™åƒï¼ãƒ¢ãƒ‡ãƒ«å†™åƒã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆç›´åˆ—ï¼†å„ãƒ—ãƒãƒ‘ãƒ†ã‚£ã«åˆ¥è¡¨ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹<= FriendFeedã€å¤šæ•°æ±Žç”¨åˆ—ï¼‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¡¨ï¼‹ã‚¹ã‚ãƒ¼ãƒžãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿è¡¨ <= Salesforce

schema

rdbms

salesforce

friendfeed
ãƒªãƒ³ã‚¯
SSDæŠ•å…¥ã§DBMSã®ã‚³ã‚³ãŒå¤‰ã‚ã‚‹! - WEB+DB PRESS vol. 52
SSDã‚’ä½¿ã†ã¨DBMSã¯ã©ã†å¤‰ã‚ã‚‹ï¼Ÿå¾¹åº•æ¤œè¨¼ã—ãŸè¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸï¼ WEB+DB PRESS Vol.52 äºˆç´„å—ä»˜ä¸ã§ã™ã€‚ å®Ÿéš›ã«æœ€æ–°æœ€é€Ÿã®SSDã€Intel X25-Eã‚’ä½¿ã£ã¦DBMSã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã™ã‚‹ãªã©ã€ã‚ãã‚ãã—ãªãŒã‚‰è¨˜äº‹ã‚’æ›¸ãã“ã¨ãŒã§ãã¾ã—ãŸã€‚SSDã®å®ŸåŠ›ã«é©šãã¤ã¤ã‚‚ã€ä½¿ã„æ–¹ã‚’é–“é•ãˆã‚‹ã¨HDDã‚ˆã‚Šé…ããªã‚‹ï¼Ÿ ãªã©æ–°ã—ã„ç™ºè¦‹ã‚‚ã‚ã‚Šã€‚ ãã—ã¦ã€SSDã¨HDDã®é•ã„ãŒã©ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã«å½±éŸ¿ã™ã‚‹ã®ã‹ï¼Ÿãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ï¼ˆãƒ’ãƒ¼ãƒ—ã€B+-treeãªã©ï¼‰ã‹ã‚‰ãƒãƒƒãƒ•ã‚¡ç®¡ç†ãªã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ä¸èº«ã‚’è§£å‰–ã—ã¦ã‚ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¦ã„ã¾ã™ã€‚èªã¿ã‚„ã™ããªã£ãŸã®ã¯ä¸å¯§ã«æ·»å‰Šã—ã¦ãã ã•ã£ãŸæ‹…å½“æ§˜ã®ãŠã‹ã’ã§ã™ã€‚æ„Ÿè¬ã€‚ ãƒ‡ã‚£ã‚¹ã‚¯ã‚’æ´»ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ã‚½ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ï¼ˆExternal merge sortãªã©ï¼‰ã«åŠ ãˆã€2009å¹´6æœˆã«Edgar F. Codd Innovation Aw
shinichitomita 2009/08/26
hash join mapreduce

rdbms

ssd

database
ãƒªãƒ³ã‚¯
2009-03-14
@ntamaoki ãŒã†ã¡ã®è‹¥æ‰‹ã¨é£²ã¿ã¾ã—ã‚‡ã†ã‚ˆã€ã¨è¨€ã£ã¦ããŸã®ã§ã€ã»ã„ã»ã„ãã‚Œã«ä¹—ã£ã¦æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®è‹¥æ‰‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ä¼šã£ã¦ããŸã€‚å®Ÿã®ã¨ã“ã‚ã€ERPã APPSã ã¨ã„ã†ã®ã¯ã€ã‚ˆãã‚ã‹ã‚‰ãªã„ã€‚ã‚ãŸã—ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã ã£ãŸã‚ã‘ã§ã€è·ç¨®ã‚‚ã‚³ãƒ³ã‚µãƒ«ã¨ã‹ã§ã¯ãªãã€ã‚µãƒãƒ¼ãƒˆã®ã•ã‚‰ã«ä¸‹ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®ã‚µãƒãƒ¼ãƒˆã ã£ãŸã‚ã‘ã§ã€‚ æ–°ç¤¾å±‹ã¯ç´ æ•µã ã£ãŸã€‚äºŒéšŽã®å—ä»˜ã¾ã§è¡Œã£ã¦ã€è«¸èˆ¬ã®äº‹æƒ…ã§ç¤¾å†…ã«ã¯ã¯ã„ã‚Œãªãã¦æ®‹å¿µã€‚ ã¾ã‚ã€ãã‚Œã¯ã€ã©ãƒ¼ã§ã‚‚ã„ã„è©±ãªã®ã ãŒã€åŸºç›¤ç³»ã„ã„ã‚ˆã€œã€RDBMSã®é–‹ç™ºãŠã‚‚ã—ã‚ã„ã‚ˆã€œã¨ã„ã†è©±ã‚’ãŠè…¹ã„ã£ã±ã„è©±ã—ã¦ããŸã€‚ ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚µãƒãƒ¼ãƒˆã®ä¸€æ—¥ã¤ãƒ¼ã®ã¯ã€å‡ºç¤¾ã—ã¦bugdbè¦‹ã¦ã€è‡ªåˆ†ã®æ‹…å½“éƒ¨åˆ†ã®ãƒã‚°ã‚’ã–ã£ã¨è¦‹ã¦ã€æ–°ã—ã„ãƒã‚°ãŒã‚ã‚Œã°ã€æ‹¾ã£ã¦ã€åœ°å‘³ã«å›žç”ã‚’ä½œã‚‹ã€‚ãƒ‘ãƒƒãƒã‚’ä½œã‚‹å ´åˆã‚‚ã‚ã‚‹ã—ã€ãƒã‚°ã˜ã‚ƒãªã‹ã£ãŸã‚Šã€ãƒã‚°ã ã£ãŸã¨ã—ã¦ã‚‚ã€ç°¡å˜ãªãƒ¯ãƒ¼ã‚¯ã‚¢ãƒ©ã‚¦ãƒ³ãƒ‰ãŒã‚ã£ãŸã‚Šã—ã¦ã€ãã‚Œã‚’å›žç”ã—ãŸã‚Šã¨ã„ã†æ„Ÿã˜ã§ã‚ã‚‹ã€‚
shinichitomita 2009/03/14
database

oracle

rdbms

development
ãƒªãƒ³ã‚¯
Microsoft and FathomDB target 'relational' clouds - CNET
Tech Industry Microsoft and FathomDB target 'relational' clouds Two seemingly unconnected pieces of news signal an interesting market test: can standard relational-database software be effectively delivered from the cloud? There were two very interesting pieces of news to come out in the last week related to the availability of relational databases in the cloud. One involved a start-up you have al
shinichitomita 2009/03/08
rdbms

cloud
ãƒªãƒ³ã‚¯
RDBMSã‚’Key-Value Storageã¨ã—ã¦ä½¿ã†å ´åˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¨ˆæ¸¬ï¼ˆH2, MySQLç·¨ï¼‰ - kaisehã®ãƒ–ãƒã‚°
Tokyo Cabinet, QDBM, Lux IOãªã©ã€DBMåŒå£«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã¯Webã§è‰¯ãè¦‹ã‹ã‘ã‚‹ã®ã§ã™ãŒã€MySQLã®ã‚ˆã†ãªæ™®é€šã®RDBMSã‚’Key-Value Storageçš„ã«ä½¿ç”¨ã—ãŸå ´åˆã€DBMã¨æ¯”ã¹ã¦ã©ã‚Œãã‚‰ã„å·®ãŒä»˜ãã‚‚ã®ãªã®ã‹ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒæ¹§ã‹ãªã‹ã£ãŸã®ã§ã€å®Ÿéš›ã«è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚ Javaãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ã€Berkeley DBã€H2ã€MySQLã®3ç¨®é¡žã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚æ¡ä»¶ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Berkeley DB Java Edition 3.3.75 ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®š H2 1.1.106 jdbc:h2:file:~/dbmbench Embeddedãƒ¢ãƒ¼ãƒ‰ã§ä½¿ç”¨ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®š DDLã¯ä»¥ä¸‹ã‚’ä½¿ç”¨ create table casket ( id integer auto_increment primary key, key_ varchar(255
shinichitomita 2009/01/14
rdbms

database

berkeleydb

mysql

h2
ãƒªãƒ³ã‚¯
RDBMSã®æ™‚ä»£ã®çµ‚ã‚ã‚ŠãŒè¦‹ãˆã¦ããŸ - ãã—ã ã®ã¯ã¦ãª
ã‚¯ãƒ©ã‚¦ãƒ‰ã¨ä¸€ç·’ã«ã‚„ã£ã¦ããŸã‚‚ã® æœ€è¿‘ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒæµè¡Œã£ã¦ã¾ã™ã€‚ Googleã®MapResuceã‹ã‚‰å§‹ã¾ã£ã¦ã€Microsoftã®Azureã¾ã§ã€å¤§æ‰‹ã®ã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ãŒå‡ºæƒã£ãŸæ„Ÿã˜ã€‚ ã§ã€ãã“ã§ã€ã“ã‚“ãªã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ãŒå‡ºã¾ã—ãŸã¨ã„ã†ã¨ãã«ã€å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©ãã®ã‚¯ãƒ©ã‚¦ãƒ‰ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®èª¬æ˜ŽãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€ãã‚Œã¯RDBMSã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ Googleã ã¨BigTableã€Microsoftã ã¨SQL Data Servicesã€ã‚ã¨ã¯Amazonã®SimpleDBã€‚ã©ã‚Œã‚‚ã€åŸºæœ¬çš„ã«ã¯ã²ã¨ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒãƒƒã‚·ãƒ¥ã‚³ãƒ¼ãƒ‰ã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã»ã‹ã®ã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ã‚‚ã€Oracle Coherenceã ã£ãŸã‚Šã€æ¥½å¤©ã®Romaã ã£ãŸã‚Šã€éžRDBMSã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¨ã„ã†ã‚ã‘ã§ã¯ãªã„ã‘ã©ã€mixiã®Tokyo Tyrantã‚„Apache CouchDBã‚‚ã€RDB
shinichitomita 2008/12/12
Salesforceã¯ã¾ã˜ã§è¦³æ¸¬ã®ç¯„ç–‡å¤–ï¼Ÿ

rdbms

database

cloud
ãƒªãƒ³ã‚¯
SSD ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å°†æ¥ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
SQL ã«ç—›ç—’æ„Ÿã‚’æ„Ÿã˜ã‚‹æ—¥ã€…ã‚’éŽã”ã—ã¦ã„ã‚‹èº«ã¨ã—ã¦ã¯ã€RDBMS ãŒãƒ¬ã‚¬ã‚·ãƒ¼ã ã¨ã„ã†ã®ã¯ã€ã¾ã£ãŸãåŒæ„Ÿã§ã™ãŒã€‚ SSDã‚’å‰æã«ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¢ãƒ‡ãƒ«ã«ãªã‚Œã°ã€ãã‚‚ãã‚‚ã‚·ãƒ¼ã‚¯æ™‚é–“ã¨æˆ¦ã†ã“ã¨ã‚‚ãªãã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ„è˜ã›ãšã«ãƒ—ãƒã‚°ãƒ©ãƒ ãŒçµ„ã‚ã¾ã™ã€‚ãã†ãªã£ãŸã¨ãã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ°¸ç¶šåŒ–ã™ã‚‹ãŸã‚ã«RDBMSã‚’ã‚ã–ã‚ã–ä½¿ã†ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ 2008-12-12 ãã‚“ãªã“ã¨ãªã„ã¨æ€ã„ã¾ã™ã€‚ç†ç”±ã¯ä»¥ä¸‹ã®ï¼’ç‚¹ã€‚ ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã®æ›¸ãæ›ãˆãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã¯æ•°ã‚ãƒãƒã‚¤ãƒˆä»¥ä¸Š ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯æ„è˜ã—ã¦å®Ÿè£…ã›ã–ã‚‹ã‚’å¾—ãªã„ ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ¡ãƒ¢ãƒªã¯ãƒ©ãƒ³ãƒ€ãƒ ãƒªãƒ¼ãƒ‰ã§ãã¾ã™ãŒã€DRAM ã®ã‚ˆã†ã«ãƒ©ãƒ³ãƒ€ãƒ ãƒ©ã‚¤ãƒˆã§ãã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚æ›¸ãè¾¼ã¿ãŒéžå¸¸ã«é…ã„ã®ã«åŠ ãˆã¦æ›¸ãæ›ãˆå›žæ•°ã®åˆ¶é™ã‚‚ã‚ã‚‹ã®ã§ã€ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã¨åŒæ§˜ã®ãƒ—ãƒã‚°ãƒ©ãƒ æ‰‹æ³•ã‚’ä½¿ã†ã®ã¯é›£ã—ã„ã¨æ€ã„ã¾ã™ã€‚ æ¬¡ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã§ã™ãŒã€çµ„ã¿è¾¼ã¿åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦
shinichitomita 2008/12/12
DBMSã®ç†ç”± -> transaction, random writeã¯DRAMã¨æ¯”è¼ƒç„¡ç† / ã‚µãƒ¼ãƒã‚ˆã‚Šã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ç”Ÿãæ®‹ã‚‹ <- ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£

opinion

rdbms

database

ssd
ãƒªãƒ³ã‚¯
å‚æœ¬å¤šèžã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢æ¥ç•Œã‚¤ãƒ³ã‚µã‚¤ãƒ‰ã‚¢ã‚¦ãƒˆ GoogleãŒOracleã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã§è¡çªã™ã‚‹æ—¥ï¼šBigtable vs Berkeley DB
CNET Japanèªè€…ãƒ–ãƒã‚¬ãƒ¼ sparklegateã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼RDBMSã¯æœ¬å½“ã«ä¾¿åˆ©ãªã®ã‹ã¯å•é¡Œæèµ·ã¨ã—ã¦ãã—ã¦ã€ã„ã‚ã„ã‚å¯„ã›ã‚‰ã‚ŒãŸã‚³ãƒ¡ãƒ³ãƒˆãŒéžå¸¸ã«èˆˆå‘³æ·±ãé¢ç™½ã‹ã£ãŸã€‚CPUãƒãƒƒã‚¯ã¨ãƒ‡ã‚£ã‚¹ã‚¯ãƒãƒƒã‚¯ã¨ã„ã†ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ã¤ã„ã¦å¯„ã›ã‚‰ã‚ŒãŸä¸¡æ–¹ã®æ„è¦‹ã¯RDBMSã‚’ã©ã†ä½¿ã£ã¦ã„ã‚‹ã‹ã¨ã„ã†ä½¿ã„æ–¹ã®å·®ã§ã‚‚ã‚ã‚Šã€ã€Œä½•ã§ã‚‚å…¥ã‚‹ä¾¿åˆ©ãªå…¥ã‚Œã‚‚ã®ã€ã§ã‚ã‚‹RDBMSã®ç‰¹é•·ãŒã‚ˆãç¾ã‚Œã¦ã„ã‚‹è¨¼å·¦ã ã‚ã†ã€‚ãã—ã¦ã€ã‚ã¾ã‚Šã«ä¾¿åˆ©ã™ãŽã‚‹ãŒã‚†ãˆã«ã€è‹¦æ‰‹ãªé ˜åŸŸã«ã‚‚ä½¿ã‚ã‚Œã¦ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ï¼ˆæ‹¡å¤§æ€§ï¼‰ã®å•é¡Œã«ã¶ã¤ã‹ã‚Šã€ã€Œæœ¬å½“ã«ä¾¿åˆ©ãªã®ã‹ã€ã¨ã„ã†ç´ æœ´ãªå˜†ãã«è‡³ã‚‹ã¨ã„ã†çŠ¶æ³ã¯ã€çš®è‚‰ãªã®ã‹æœ¬æ°—ãªã®ã‹ã€ã„ãšã‚Œã«ã—ã‚ã‚ã‚ŠãŒã¡ãªã“ã¨ã ã‚ã†ã€‚ ã²ã£ãã‚Šã¨è¡¨ã«å‡ºã¦ããŸGoogleã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šBigtable ãã‚“ãªãŠã‚Šã€steps to phantasienã®2006-9-11ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§Googleã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
shinichitomita 2006/09/19
google

oracle

bigtable

berkeleydb

database

rdbms
ãƒªãƒ³ã‚¯
1