[B! database] mako-28ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mako-28 id:mako-28

databaseã«é–¢ã™ã‚‹mako-28ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

Database Isolation Levels And Their Effects on Performance andÂ Scalability - High Scalability -
Some of us are not aware of the tremendous job databases perform, particularly their efforts to maintain the Isolation aspect of ACID. For example, some people believe that transactions are only related to data manipulation and not to queries, which is an incorrect assumption. Transaction Isolation is all about queries, and the consistency and completeness of the data retrieved by queries. This is
mako-28 2011/02/11
ã‚ã‹ã‚Šã‚„ã™ã„ã€‚

database

transaction
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜
â– ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(ç´¢å¼•)ã¨ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ é«˜é€Ÿã«å–ã‚Šå‡ºã™ç‚ºã®ä»•çµ„ã¿ã‚’æ„å‘³ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦SQLæ–‡ã®å¿œç”æ™‚é–“ãŒåŠ‡çš„ã«æ”¹å–„ ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¯B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¯ã˜ã‚ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ãŒã€ã“ã“ã§ã¯æœ€ã‚‚ä¸€èˆ¬çš„ã«ä½¿ã‚ã‚Œã€ã‹ã¤ ã»ã¨ã‚“ã©ã®DBMSã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ â€» CREATE INDEXæ–‡ã§ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã—ãªã„å ´åˆã¯é€šå¸¸B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒ ä½œæˆã•ã‚Œã¾ã™ã€‚ â– B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã—ãã¿ B-Tree(Balanced Tree)ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ¬¡ã®ã‚ˆã†ãªãƒ„ãƒªãƒ¼çŠ¶ã®æ§‹é€ ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ„ãƒªãƒ¼ã®å…ˆé ã¯ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã§ã¯ã€ã‚ãƒ¼å€¤ã® ç¯„å›²
mako-28 2008/12/31
database
ãƒªãƒ³ã‚¯
cl.pocari.org - ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ãªã£ãŸ Fastladder ã® ER å›³ã‚’æã„ã¦ã¿ãŸ
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ãªã£ãŸ Fastladder ã® ER å›³ã‚’æã„ã¦ã¿ãŸ 2008-02-10-1: [SQLite] Livedoor ã® Fastladder ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ãªã£ãŸã¨ã„ã†ã“ã¨ã§ã€å‹‰å¼·ã‚’å…¼ãã¦ ER å›³ã‚’æã„ã¦ã¿ã¾ã—ãŸã€‚ (ã‚¯ãƒªãƒƒã‚¯ã§å¤§ãããªã‚Šã¾ã™) ä½¿ã£ãŸãƒ„ãƒ¼ãƒ«ã¯ DBDesigner 4 (æ—¥æœ¬èªžç‰ˆ) ã§ã™ã€‚ DBDesigner 4 ã§ã¯ã€SQLite 3.x ã®ãƒ‡ãƒ¼ã‚¿ãŒèªã‚ãªã„ã‚ˆã†ãªã®ã§ã€SQLite ODBC Driver ã‚’ä½¿ã£ã¦ã€ODBC ã§èªã¿è¾¼ã¿ã€ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã—ã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã¯ã‚½ãƒ¼ã‚¹ã‚’è¦‹ãªãŒã‚‰ä½œæˆä¸ã§ã™ãŒã€ã‚ã¾ã‚Š Ruby ãŒåˆ†ã‹ã£ã¦ã„ãªã„ã®ã§æ™‚é–“ãŒã‹ã‹ã‚Šãã†ã§ã™ã€‚ã€‚ã€‚ãã®ã†ã¡å…¬é–‹ã—ã¾ã™ã€‚ - Fastladder Open Source http://fastladder.org/
mako-28 2008/02/14
database

fastladder
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
mako-28 2007/09/02
algorithm

database

sql
ãƒªãƒ³ã‚¯
[LAC]ãƒ©ãƒƒã‚¯ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶æ‰€ãŒæä¾›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®‰å…¨ã‚¬ã‚¤ãƒ‰
æƒ…å ±ã‚’å®ˆã‚Šã€æœªæ¥ã‚’å‰µé€ ã™ã‚‹ãƒ‘ã‚¤ã‚ªãƒ‹ã‚¢ã¨ã—ã¦ã®ä¿¡é ¼ã¨è‡ªä¿¡ã§ã€ã‚‚ã£ã¨å…ˆã¸ æœ€é«˜å³°ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚µãƒ¼ãƒ“ã‚¹ã¨ã€ITãƒˆãƒ¼ã‚¿ãƒ«ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚‚ã£ã¨çŸ¥ã‚‹
mako-28 2006/10/23
ã‚ã¨ã§èªã‚‚ã†ã€‚

database

security

document
ãƒªãƒ³ã‚¯
Lazybase
mako-28 2006/07/08
database

web
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
mako-28 2006/02/21
ã¾ã¨ã‚

database
ãƒªãƒ³ã‚¯
1