[B! RDBMS] Nagiseã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Nagise id:Nagise

RDBMSã«é–¢ã™ã‚‹Nagiseã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ä¸¦åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®æ¦‚å¿µã¨åŽŸç†
3. è¬›ç¾©å†…å®¹ ï® åºè«– - ä¸¦åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‰ã« ï® ä¸¦åˆ—å‡¦ç†ã®åŸºç¤Ž ï® ï® ä¸¦åˆ—å‡¦ç†ã®Terminology ä¸¦åˆ—è¨ˆç®—æ©Ÿã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ ï® ä¸¦åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ ï® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‡¦ç†ã®ä¸¦åˆ—åŒ– ï® çµåˆå‡¦ç†ã®é«˜é€ŸåŒ– ï® ï® ï® ï® ä¸¦åˆ—ãƒãƒƒã‚·ãƒ¥çµåˆ ä¸¦åˆ—ã‚½ãƒ¼ãƒˆ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°æ‰‹æ³• å¤šé‡çµåˆã‚„è¨ˆç®—æ©Ÿé–“ã®ãƒ‡ãƒ¼ã‚¿äº¤æ›ã§ç™ºç”Ÿã™ã‚‹å•é¡Œ ï® MapReduceã«ã‚ˆã‚‹é–¢ä¿‚æ¼”ç®—ã®ä¸¦åˆ—å‡¦ç† 3 4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®æµã‚Œ ï® Coddã®è«–æ–‡: 1970å¹´ ï® ï® ï® ï® System Rã‚„Ingres: 70å¹´ä»£ä¸ç›¤ Oracle, IBM DB2, Ingres: 80å¹´ä»£åºç›¤ ä¸¦åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®éš†ç››: 80å¹´ä»£å¾ŒåŠ ï® ï® A Relational Model of Data for Large Shared Data Banks, Communications of ACM å•†ç”¨
Nagise 2014/02/03
RDBMS
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
PostgreSQLã®ãƒãƒ¼ãƒ«ç®¡ç†ã¨ãã®æ³¨æ„ç‚¹ï¼ˆOpen Source Conference 2022 Online/Osaka ç™ºè¡¨è³‡æ–™ï¼‰NTT DATA Techno logy & Innovation
Nagise 2013/11/18
RDBMS
ãƒªãƒ³ã‚¯
FacebookãŒä½•åƒå°ã‚‚ã®MySQLã‚’äººæ‰‹ã‚’ä½¿ã‚ãšè‡ªå¾‹ç®¡ç†ã™ã‚‹ä»•çµ„ã¿ã€ŒMySQL Pool Scannerï¼ˆMPSï¼‰ã€
ãŠãã‚‰ãä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚å¤§è¦æ¨¡ã«MySQLã®ã‚¯ãƒ©ã‚¹ã‚¿ã‚’å±•é–‹ã—ã€é‹ç”¨ã—ã¦ã„ã‚‹ã®ãŒFacebookã§ã—ã‚‡ã†ã€‚è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚Šä½•åƒå°ã‚‚ã®MySQLã‚µãƒ¼ãƒã‚’é‹ç”¨ã™ã‚‹ãŸã‚ã«ã€è‡ªå‹•åŒ–ã®ä»•çµ„ã¿ã¯æ¬ ã‹ã›ã¾ã›ã‚“ã€‚ ãã®è‡ªå‹•åŒ–ãŒã©ã®ã‚ˆã†ãªä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã‹ã€‚Facebookã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹Shlomo Priymakæ°ãŒã€Under the hood: MySQL Pool Scanner (MPS)ã¨ã„ã†è¨˜äº‹ã‚’Facebookã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‹ãªã‚Šé•·ã„è¨˜äº‹ãªã®ã§ã€ã“ã“ã§ã¯ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦è§£èª¬ã—ã¦ã¿ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²åŽŸæ–‡ã‚’ã‚ãŸã£ã¦ã¿ã¦ãã ã•ã„ã€‚ MPSã®ãŠã‚‚ãª3ã¤ã®æ©Ÿèƒ½ Facebookã§ç¨¼åƒã—ã¦ã„ã‚‹MySQLã¯ã€ã¤ãã«1ã¤ã®ãƒžã‚¹ã‚¿ãƒ¼ã¨ãã“ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚ŒãŸè¤‡æ•°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã‚ˆã‚‹ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã‚’æ§‹æˆã—ã¦ã„ã¾ã™ã€‚ã“ã®ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã®æ§‹é€ ã‚’ç¶æŒã—ç¶šã‘ã‚‹ã“ã¨ã§ã€å¯ç”¨æ€§ã¨
Nagise 2013/11/07
RDBMS
ãƒªãƒ³ã‚¯
Pure Javaã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³H2ãŒã‚¯ã‚¨ãƒªè¨€èªžã‚’æè¼‰ - çŸ¢é‡Žå‹‰ã®ã¯ã¦ãªæ—¥è¨˜
H2, database, Javaã™ã¹ã¦Javaã§æ›¸ã‹ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ã¯HSQL DBãŒæœ‰åã§ã™ãŒã€ã‚‚ã¨ã‚‚ã¨HSQL DBã®å‰èº«ã¨ãªã£ãŸHyperSonicã‚’ä½œã£ãŸäººãŒå§‹ã‚ãŸH2 Database Engineã¨ã„ã†ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒã‚ã‚Šã¾ã™ã€‚ HSQL DBã¯å®Ÿã¯ãƒ¬ã‚³ãƒ¼ãƒ‰æ¤œç´¢ã™ã‚‹ã®ã«ã‚‚è¡ŒãŒListã«å…¥ã£ã¦ã„ã‚‹ã®ã‚’ç·šå½¢æ¤œç´¢ã—ã¦ãŸã‚Šã¨ã‹çµæ§‹ã™ã”ã„ã¨ã“ã‚ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€H2ã¯ä½œè€…ãŒåˆ¥ã®å•†ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»•äº‹ã§å¾—ãŸçµŒé¨“ã‚’å…ƒã«ã—ã¦Hypersonicã‚’ä¸€ã‹ã‚‰ä½œã‚Šç›´ã—ãŸã‚‚ã®ã§ã€å½“ç„¶ãã®ã‚ˆã†ãªå•é¡Œã‚‚æ”¹å–„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ä¸€æ–¹ã§HSQL DBã¨åŒã˜ãã€ãƒãƒƒã‚¯ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã—ã‹ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ãªã„ã¨ã‹ã€DBã‚µãƒ¼ãƒã¨ã—ã¦ä½¿ã†ã«ã¯ã©ã†ãªã‚“ã ã‚ã€ã¨ã„ã†ã¨ã“ã‚ã‚‚æ®‹ã£ã¦ã„ã¾ã™ã€‚ãã‚Œã§ã‚‚Pure Javaã§ã‚ã‚‹ã“ã¨ã‚’ç”Ÿã‹ã—ã¦é–¢æ•°ã‚’Javaã§ä½œã£ã¦ã‚¯ãƒ©ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’DB Engineã«è¿½åŠ ã—ã¦æ‹¡å¼µã™ã‚‹æ©Ÿèƒ½ã¨ã‹ã€ãƒ•ã‚¡ãƒ³
Nagise 2008/06/23
å¾Œã§åˆ†æžã™ã‚‹

java

RDBMS
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Nagise 2008/05/29
RDBMS
ãƒªãƒ³ã‚¯
5.10. ç¶™æ‰¿
Nagise 2008/05/27
ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç¶™æ‰¿ã«ã¤ã„ã¦

RDBMS

PostgreSQL
ãƒªãƒ³ã‚¯
1