[B! DataBase][dbms] kana321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kana321 id:kana321

DataBaseã¨dbmsã«é–¢ã™ã‚‹kana321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

ç¬¬5å›žã€€SQLã§æœ¨æ§‹é€ ã‚’æ‰±ã†ï½žå…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã€€ï¼ˆ1ï¼‰å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã¨ã¯ä½•ã‹ | gihyo.jp
ã¯ã˜ã‚ã« æœ¨æ§‹é€ ã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®ä¸€ç¨®ãŒã‚ã‚Šã¾ã™ã€‚1ã¤ã®ãƒ«ãƒ¼ãƒˆï¼ˆæ ¹ï¼‰ã¨å‘¼ã°ã‚Œã‚‹ãƒŽãƒ¼ãƒ‰ã‚’å§‹ç‚¹ã¨ã—ã¦ã€ï¼ˆâ é€šå¸¸ï¼‰è¤‡æ•°ã®ãƒªãƒ¼ãƒ•ï¼ˆè‘‰ï¼‰ã¨å‘¼ã°ã‚Œã‚‹ãƒŽãƒ¼ãƒ‰ã¾ã§ã‚’çµŒè·¯ã§çµã‚“ã§ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã§ã™ã€‚ãã®åã®ã¨ãŠã‚Šè‡ªç„¶ç•Œã«ã‚ã‚‹ã€Œæœ¨ã€ã®æ§‹é€ ã§ã™ã—ã€å¦æ ¡æ™‚ä»£ã€ç¢ºçŽ‡ã®æŽˆæ¥ã§æ¨¹çŠ¶å›³ã‚’æ›¸ã„ãŸçµŒé¨“ã®ã‚ã‚‹äººã‚‚ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ ã“ã®æ§‹é€ ã¯ã€ç§ãŸã¡ã®å‘¨å›²ã«ã¨ã¦ã‚‚ãŸãã•ã‚“å˜åœ¨ã—ã¾ã™ã€‚å®¶ç³»å›³ã‚„çµ„ç¹”å›³ã‚‚æœ¨ã§ã™ã—ã€ITé–¢é€£ã®ä¾‹ã§ã¯ã€ãƒ’ãƒ¼ãƒ—ã‚„RDBã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªï¼ˆãƒ•ã‚©ãƒ«ãƒ€ï¼‰ã«ã‚ˆã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚„XMLã‚‚æœ¨æ§‹é€ ã§ã™ã€‚Webã®æŽ²ç¤ºæ¿ã§ã‚‚ã€æœ€åˆã®æ›¸ãè¾¼ã¿ã‚’ãƒ«ãƒ¼ãƒˆã¨ã—ã¦ãã‚Œã«å¯¾ã—ã¦ã‚³ãƒ¡ãƒ³ãƒˆãŒã¤ã‘ã‚‰ã‚Œã€ãã®ã‚³ãƒ¡ãƒ³ãƒˆã«ã¾ãŸã‚³ãƒ¡ãƒ³ãƒˆãŒã¤ã‘ã‚‰ã‚Œã‚‹ã¨ã„ã†ãƒ—ãƒã‚»ã‚¹ã§æœ¨æ§‹é€ ã‚’å½¢æˆã—ã¾ã™ã€‚ã“ã“ã§ã¯1ã¤ã®æ›¸ãè¾¼ã¿ãŒãƒŽãƒ¼ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ã«ã€IT æŠ€è¡“ã¨æœ¨æ§‹é€ ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„é–¢ä¿‚ã«ã‚ã‚Šã¾ã™ã—ã€å¤šãã®åˆ†é‡Žã§å¿œç”¨ã•ã‚Œã¦ã‚‚ã„ã‚‹ã®ã§ã™ãŒã€å®Ÿã¯é•·ã„
kana321 2015/01/16
SQLã§æœ¨æ§‹é€ ã‚’æ‰±ã†ï½žå…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã€€ï¼ˆ1ï¼‰å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã¨ã¯ä½•ã‹

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

!tumblr-tech

SQL

DB

database

RDB

DBMS

ãƒ‡ãƒ¼ã‚¿æ§‹é€

algorithm

è¨è¨ˆ
ãƒªãƒ³ã‚¯
PostgreSQL 9.4ãŒãƒªãƒªãƒ¼ã‚¹ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆDBä¸¦ã®æ€§èƒ½ã§JSONBã‚µãƒãƒ¼ãƒˆã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®é«˜åº¦åŒ–ãªã©
PostgreSQL 9.4ãŒãƒªãƒªãƒ¼ã‚¹ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆDBä¸¦ã®æ€§èƒ½ã§JSONBã‚µãƒãƒ¼ãƒˆã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®é«˜åº¦åŒ–ãªã© PostgreSQL 9.4ã®ä¸»ãªæ–°æ©Ÿèƒ½ã¯ã€ãƒã‚¤ãƒŠãƒªå½¢å¼ã®JSONã§ã‚ã‚‹JSONBã®ã‚µãƒãƒ¼ãƒˆã€é«˜åº¦ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«åˆ©ç”¨ã§ãã‚‹æ–°ã—ã„APIã€GINã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®é«˜é€ŸåŒ–ãªã©ã€‚ ä¸€èˆ¬çš„ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸¦ã®é«˜é€Ÿæ€§ PostgreSQLã§ã¯ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‹ã‚‰JSONå½¢å¼ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã—ãŸãŒã€ä»Šå›žã‚µãƒãƒ¼ãƒˆã•ã‚ŒãŸJSONBå½¢å¼ã¯ã€ãƒã‚¤ãƒŠãƒªå½¢å¼ã®JSONãƒ‡ãƒ¼ã‚¿ã¸ã®å¯¾å¿œã§ã™ã€‚JSOBã®ã‚µãƒãƒ¼ãƒˆGINã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®é«˜é€ŸåŒ–ã«ã‚ˆã£ã¦ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸¦ã¿ã®é«˜é€Ÿæ€§ã‚’å®Ÿç¾ã—ãŸã¨ã®ã“ã¨ã€‚ JSONB supports fast lookups and simple expression search queries using Generalized Inverted In
kana321 2014/12/25
PostgreSQL 9.4ãŒãƒªãƒªãƒ¼ã‚¹ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆDBä¸¦ã®æ€§èƒ½ã§JSONBã‚µãƒãƒ¼ãƒˆã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®é«˜åº¦åŒ–ãªã©

postgresql

ã‚ã¨ã§èªã‚€

rdbms

JSON

DBMS

db

database

document

binary

API
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåŒ–ã™ã‚‹ã€ŒOracle Database In-Memoryã€ã€æ€§èƒ½ã‚’æ•°ç™¾å€é«˜é€ŸåŒ–ã€æ¥æœˆå‡ºè·ã¸
ï¼»é€Ÿå ±ï¼½Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåŒ–ã™ã‚‹ã€ŒOracle Database In-Memoryã€ã€æ€§èƒ½ã‚’æ•°ç™¾å€é«˜é€ŸåŒ–ã€æ¥æœˆå‡ºè·ã¸ ç±³ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€Oracle Database 12cã‚’ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã€å¾“æ¥ã¨æ¯”è¼ƒã—ã¦æ•°ç™¾å€ã®æ€§èƒ½å‘ä¸Šã‚’å®Ÿç¾ã™ã‚‹ã€ŒOracle Database In-Memoryã€ã‚’æ¥æœˆ7æœˆã«å‡ºè·ã™ã‚‹ã¨ç™ºè¡¨ã—ã¾ã—ãŸã€‚ Oracle Database In-Memoryã¯ã€æ˜¨å¹´9æœˆã«è¡Œã‚ã‚ŒãŸOracle OpenWorld 2013ã®åŸºèª¿è¬›æ¼”ã§ç™ºè¡¨ã•ã‚ŒãŸã‚‚ã®ã€‚ä»Šå›žã®ç™ºè¡¨ã«ã¯ã€ãã®ã¨ãã¨åŒæ§˜ã«åŒç¤¾CEOã®ãƒ©ãƒªãƒ¼ãƒ»ã‚¨ãƒªã‚½ãƒ³æ°ãŒç™»å£‡ã€ç†±ã®ã“ã‚‚ã£ãŸèª¬æ˜Žã‚’è¡Œã„ã¾ã—ãŸã€‚ ã‚¨ãƒªã‚½ãƒ³æ°ã¯ã€ŒOracle Database In-Memoryã¯ã€ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹å‡¦ç†ã‚’10å€ã‚‚100å€ã‚‚é«˜é€ŸåŒ–ã—ã€OLTPã‚‚2å€ã€3å€ã¨é«˜é€ŸåŒ–ã™ã‚‹ã€‚ã—ã‹ã‚‚Oracle RACï¼ˆReal Applicat
kana321 2014/06/11
ã€ŒOracle Database In-Memoryã¯ã€ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹å‡¦ç†ã‚’10å€ã‚‚100å€ã‚‚é«˜é€ŸåŒ–ã—ã€OLTPã‚‚2å€ã€3å€ã¨é«˜é€ŸåŒ–ã™ã‚‹

newsmemo

oracle

database

æ™‚é–“

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

in-memory

Publickey

DBMS

memory
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ãŒæ–°ãŸã«ç«‹ã¡ä¸Šã’ãŸã€ŒTamrã€ã¯ã€ã°ã‚‰ã°ã‚‰ã«å˜åœ¨ã™ã‚‹ä¼æ¥å†…å¤–ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ©Ÿæ¢°å¦ç¿’ã§è‡ªå‹•çš„ã«æ•´ç†çµ±åˆ
ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ãŒæ–°ãŸã«ç«‹ã¡ä¸Šã’ãŸã€ŒTamrã€ã¯ã€ã°ã‚‰ã°ã‚‰ã«å˜åœ¨ã™ã‚‹ä¼æ¥å†…å¤–ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ©Ÿæ¢°å¦ç¿’ã§è‡ªå‹•çš„ã«æ•´ç†çµ±åˆ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤§å¾¡æ‰€ã¨ã—ã¦çŸ¥ã‚‰ã‚Œã‚‹ãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ã€‚Ingresã‚„Postgresã¨ã„ã£ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…ˆé§†ã‘ã¨ãªã‚‹è£½å“ã‚’é–‹ç™ºã€Informixã®CTOã‚’å‹™ã‚ã€ã¾ãŸã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Verticaã‚’å‰µæ¥ã€æœ€è¿‘ã§ã¯VoltDBã‚’å‰µæ¥ã™ã‚‹ãªã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…ˆç«¯æŠ€è¡“ã‚’å•†ç”¨åŒ–ã—ç¶šã‘ã¦ãã¾ã—ãŸã€‚ ãã®ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ãŒå…±åŒå‰µæ¥è€…ã¨ã—ã¦ç«‹ã¡ä¸Šã’ãŸä¼æ¥ãŒã€ŒTamrã€ï¼ˆãƒ†ã‚¤ãƒžãƒ¼ã¨ç™ºéŸ³ã™ã‚‹ã‚ˆã†ã§ã™ï¼‰ã§ã™ã€‚åŒç¤¾ã¯5æœˆ19æ—¥ã€Google Venturesãªã©ã‹ã‚‰1600ä¸‡ãƒ‰ãƒ«ï¼ˆç´„16å„„å††ï¼‰ã®æŠ•è³‡ã‚’å—ã‘ã‚‹ã®ã¨åŒæ™‚ã«ã€åŒç¤¾è£½å“ï¼ˆç¤¾åã¨åŒã˜Tamrï¼‰ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ é«˜åº¦ãªãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã‚’ã»ã¼è‡ªå‹•çš„ã«ä½œã£ã¦ãã‚Œã‚‹ Tamrã¨ã¯ã€ã“ã‚Œã¾ã§ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ãŒ
kana321 2014/05/21
é«˜åº¦ãªãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã‚’ã»ã¼è‡ªå‹•çš„ã«ä½œã£ã¦ãã‚Œã‚‹

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

intranet

publickey

æ–‡æ›¸æ•´ç†

database

tamr

BigData

ã‚·ã‚¹ãƒ†ãƒ

Tech

DBMS
ãƒªãƒ³ã‚¯
ãªãœBTreeãŒIndexã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‹ - maru source
â€»ã“ã®å†…å®¹ã¯å€‹äººçš„ãªè€ƒå¯Ÿãªã®ã§ã€é–“é•ã£ã¦ã„ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†éƒ¨åˆ†ã‚’è¦‹ã¤ã‘ãŸéš›ã¯ãœã²æ•™ãˆã¦ä¸‹ã•ã„ã€‚ RDBMSã®æ¤œç´¢ã‚’æ—©ãã™ã‚‹ãŸã‚ã«Indexã£ã¦ä½¿ã„ã¾ã™ã‚ˆãã€‚ä¾‹ãˆã°ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE user ( id INT UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX (id) ); idã‚«ãƒ©ãƒ ã«Indexã‚’å¼µã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯idã§ã®æ¤œç´¢ã‚’é«˜é€Ÿã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ã“ã“ã§idã‚«ãƒ©ãƒ ã«IndexãŒè²¼ã£ã¦ã„ãªã„å ´åˆã¨æ¯”ã¹ã‚‹ã¨æ¤œç´¢æ™‚é–“ãŒå¤§å¹…ã«å¤‰ã‚ã£ã¦ãã¦ã—ã¾ã„ã¾ã™ï¼ˆç‰¹ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå¤šããªã£ãŸæ™‚) ã§ã¯ãªãœIndexã‚’è²¼ã‚‹ã¨æ¤œç´¢ãŒæ—©ããªã‚‹ã‚“ã§ã—ã‚‡ã†ï¼Ÿï¼Ÿ Indexã¨ã¯ãã®åã®é€šã‚Šç´¢å¼•ã‚’æ„å‘³ã—ã¾ã™ã€‚ç‰¹å®šã®ã‚«ãƒ©ãƒ ã®ç´¢å¼•ã‚’ä½œæˆã—ã¦ãŠãã“ã¨ã§æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã—ã¾ã™ã€‚ (æœ¬ã®æœ€å¾Œã«ã‚ˆã¿ãŒãªé †ã§å˜èªžãŒä¸¦ã¹ã‚‰ã‚ŒãŸã‚Šã—ã¦ã„ã¾ã™
kana321 2014/03/28
DB

æ¤œç´¢

dbms

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

btree

algorithm

RDBMS

index

MySQL

database
ãƒªãƒ³ã‚¯
RDBMSã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒå¿…è¦ãªç†ç”±ã€ã‚ã‹ã‚‰ãªã„ã€‚
Takayuki Shimizukawa @shimizukawa @masa_edw ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒç„¡ã„å ´åˆã€ä½¿ã„çµ‚ã‚ã£ãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå³è§£æ”¾ã•ã‚Œãªã„ï¼ˆè§£æ”¾ã¾ã§å¤šå°‘é…å»¶ã™ã‚‹ï¼‰ã®ã§å®Ÿéš›ã«ä½¿ã£ã¦ã„ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®æ•°ã‚ˆã‚Šå¤šãå˜åœ¨ã™ã‚‹ã€‚ãã®åˆ†ãƒ¡ãƒ¢ãƒªã‚’åœ§è¿«ã—ã¦åŠ¹çŽ‡ãŒæ‚ªã„ã€‚ã£ã¦ã„ã†è©±ã¯èžã„ãŸã“ã¨ãŒã‚ã‚‹ã‚ˆï¼ˆè¦å‡ºå…¸ 2013-09-04 09:27:28 ãƒã‚¤ãƒ‘ãƒ¼ã‚€ã¨ã† @masa_edw @voluntas ç¾çŠ¶ã§å¿…è¦ãªçŠ¶æ³ã¯ç†è§£ã—ã¦ã„ã¾ã™ãŒã€ãªãœãã†ãªã‚‹ã®ã‹ç†è§£ã—ã¦ã„ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ä»–ã«ã‚‚ãŸã¨ãˆã°ã€bitlyã®å‘¼ã³å‡ºã—ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ä½¿ã†ã¹ãã‹ï¼Ÿãªãœ(ã¹ãã€ã¹ãã§ãªã„)ã®ã‹ï¼Ÿã©ã†ã„ã†è¦è«‹ã§ãã†ãªã®ã‹ï¼Ÿã¨è¨€ã†å•ã„ã«åƒ•ã¯ç”ãˆã‚‰ã‚Œã¾ã›ã‚“ã€‚ 2013-09-04 09:31:22
kana321 2013/09/04
togetter

DBMS

mysql

db

RDBMS

tcp

database

programming

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

architecture

DB

database

è¨è¨ˆ

dbms

ReThinkDB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨PostgreSQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã©ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ã‹ã€æ˜¨æ—¥ã€ä¸€æ˜¨æ—¥ã®2æœ¬ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” PostgreSQLã®ç¾çŠ¶ã¨æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.1ã®æ–°æ©Ÿèƒ½ã€‚MySQL Conference & Expo 2011 ã“ã®2ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å…±é€šã—ã¦ã„ã‚‹ã®ãŒã€NoSQLã®æ©Ÿèƒ½ã‚’å–ã‚Šè¾¼ã‚“ã§ã„ã‚‹ã“ã¨ã§ã™ã€‚NoSQLã«å¯¾ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹åæ’ƒãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒNoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.6ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã®1
kana321 2013/08/04
MySQL

postgresql

NoSQL

DBMS

MySQL

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

newsql

database

memcached
ãƒªãƒ³ã‚¯
ã€ãƒãƒ©è£ã€‘ã‚ãªãŸã¯æœ¬å½“ã«ãã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ãŒå¥½ãã§ä½¿ã†ã‚“ã§ã™ã‹ï¼Ÿ - oranie's blog
ãƒãƒ©ã‚·ã®è£çš„ãªé›‘è¨˜ã§ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã«æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’é¸ã¶éš›ã«ã“ã®è¾ºã‚’æƒ…ç†±ã‚’æŒã£ã¦èª¬æ˜Žã—ã¦ãã‚Œã‚‹äººãŒå¥½ãã€ã¨ã„ã†è©±ã§ã™ã€‚ ãã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’ä½¿ã†ç†ç”±ã¯ãªã‚“ã§ã™ã‹ï¼Ÿã¿ã‚“ãªãŒä½¿ã„æ…£ã‚Œã¦ã„ã‚‹ç‰©ã‹ã‚‰å¤‰ãˆã‚‹ç†ç”±ã¯ã€Œæœ‰åãªä¼šç¤¾ãŒä½¿ã£ã¦ã„ã¦ï¼¾ï¼¾ã€ã€Œä»–ã®ãƒãƒ¼ãƒ ãŒä½¿ã£ã¦ã„ã¦ï¼¾ï¼¾ã€ã¨ã‹ã§ã¯ãªãã¦ã€æ—¢å˜ã®ç‰©ã§ã¯è§£æ±ºå‡ºæ¥ãªã„å•é¡Œã‚’è§£æ±ºã™ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã«ãªã£ã¦ã„ã¾ã™ã‹ï¼Ÿ ã‚‚ã—å˜ç´”ã«ã‚ãƒ£ãƒƒãƒã‚¢ãƒƒãƒ—ã—ã¦ãŠããŸã„ã¨ã„ã†ãƒ¬ãƒ™ãƒ«ãªã‚‰ã€ã‚ãªãŸã®è¶£å‘³ã§ä½œã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§é‹ç”¨ã™ã‚‹ã€ã§ã¯æ¬²æ±‚ã‚’æº€ãŸã›ã¾ã›ã‚“ã‹ï¼Ÿ åŒã˜ã‚ˆã†ãªãƒ—ãƒãƒ€ã‚¯ãƒˆã¯ä»–ã«ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ãã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã§ç„¡ã‘ã‚Œã°ã„ã‘ãªã„ç†ç”±ã¯ãªã‚“ã§ã™ã‹ï¼Ÿ ã¾ã æ–°ã—ã„ãƒ—ãƒãƒ€ã‚¯ãƒˆã ã£ãŸå ´åˆã€ã‚ãªãŸã¯ãã®ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã€ãƒã‚°ã‚’å ±å‘Šã—ã¦ã€å¿…è¦ã§ã‚ã‚Œã°ãƒ‘ãƒƒãƒã‚’æ›¸ãè¦šæ‚Ÿã‚’æŒã£ã¦ã„ã¾ã™ã‹ï¼Ÿ ã‚ãªãŸã¯ãƒãƒ¼ãƒ å†…ã§ãã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ç¬¬ä¸€äººè€…ã«ãªã‚‹ã€ã¨ã„ã†è¦šæ‚ŸãŒã‚ã‚Šã¾ã™ã‹ï¼Ÿä»–ã®ãƒ¡ãƒ³ãƒãƒ¼ã¸ã®å•“è’™ã‚„æƒ…å ±å…±æœ‰ã‚’çŽ‡å…ˆ
kana321 2013/04/25
DB

ã‚·ã‚¹ãƒ†ãƒ

é‹ç”¨

database

ãƒ‡ãƒ¼ã‚¿

ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢

development

DBMS

work

ã‚ã¨ã§ã¿ã‚‹
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã§ã¯RDBMSã®ã©ã“ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã®ã‹ï¼Ÿ | gihyo.jp
RDBMSã¯ã‚ªãƒ¯ã‚³ãƒ³ï¼Ÿ ã€Œå³ã‚’å‘ã„ã¦ã‚‚å·¦ã‚’å‘ã„ã¦ã‚‚â€œâ ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿â â€ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ãŒé—Šæ©ã™ã‚‹æ™‚ä»£ã«ã€ã„ã¾ã•ã‚‰RDBMSã®è©±é¡Œï¼Ÿã€ æœ¬é€£è¼‰ã®ã‚¿ã‚¤ãƒˆãƒ«ã‚’è¦‹ã¦ãã†æ€ã‚ã‚ŒãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã€Œãƒ‡ã‚£ã‚¹ã‚¯ãƒ™ãƒ¼ã‚¹ã®RDBMSã¯ã‚ªãƒ¯ã‚³ãƒ³ã€ã“ã‚Œã‹ã‚‰ã¯â—‹â—‹ï¼ˆãŠå¥½ããªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å…¥ã‚Œã¦ãã ã•ã„ï¼‰ã®æ™‚ä»£ã ï¼ã€ ã¨ãŠã£ã—ã‚ƒã‚‹æ–¹ã‚‚ã„ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ã€ã‚€ã—ã‚å¤šãã®ä¼æ¥ãŒãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã«æ³¨ç›®ã—ã¦ã„ã‚‹ãŠã‹ã’ã§ã€RDBMSå´ã§ã‚‚å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šæ‰±ã†ãƒ‹ãƒ¼ã‚ºãŒå¢—ãˆã¦ã„ã¾ã™ã€‚ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šæ‰±ã†æ™‚ã«ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚‹5ã¤ã®ãƒã‚¤ãƒ³ãƒˆ æ•°ç™¾ã‚®ã‚¬ãƒã‚¤ãƒˆã¨ã„ã£ãŸãƒ¬ãƒ™ãƒ«ã®RDBMSã§ã‚ã‚Œã°ã€ç¾å ´ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã«ã¨ã£ã¦ã¯ã‚ãŸã‚Šã¾ãˆã®ä¸–ç•Œã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ã€ãƒ†ãƒ©ãƒã‚¤ãƒˆã‚’å¤§ããè¶…ãˆãŸãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†å ´åˆã«ã¯ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®å‚¾å‘ãŒå¤‰åŒ–ã™ã‚‹ã®ã¯ã”å˜ã˜ã§ã—ã‚‡ã†ã‹ã€‚ æ¬¡ã®å›³ã¯ã€RDBMSã«ã¾ã¤ã‚ã‚‹ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç¤ºã—ãŸã‚‚ã®ã§ã™ã€‚ å›³1ã€€å¤§è¦
kana321 2012/12/18
gihyo

DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

performance

RDBMS

database

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

DBMS

ã‚ã¨ã§èªã‚€

ãƒœãƒˆãƒ«ãƒãƒƒã‚¯
ãƒªãƒ³ã‚¯
1