[B! db] Nnwwwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Nnwww id:Nnwww

dbã«é–¢ã™ã‚‹Nnwwwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£: é–‹ç™ºè€…ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è§£èª¬æ›¸
å‰æ›¸ã ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI where å¥ ç‰ä¾¡ æ¼”ç®—å ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII é–¢æ•° - where å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª ç¯„å›² æ¤œç´¢ å¤§ãªã‚Šã€å°ãªã‚Šã€ BETWEEN LIKEãƒ•ã‚£ãƒ«ã‚¿ã« å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®çµåˆ éƒ¨åˆ†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ Oracleã«ãŠã‘ã‚‹NULL NULLã«å¯¾ã™ã‚‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ NOT NULL åˆ¶ç´„ éƒ¨åˆ†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ ã‚¨ãƒŸãƒ¥ãƒ¬ãƒ¼ãƒˆã™ã‚‹ å‡¦ç†ã—ã«ãã„æ¡ä»¶ æ—¥ä»˜åž‹ æ•°å€¤æ–‡å—åˆ— åˆ—ã®é€£çµ ã‚¹ãƒžãƒ¼ãƒˆãªãƒã‚¸ãƒƒã‚¯ æ•°å¼ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ ãƒ‡ãƒ¼ã‚¿ é‡ ã‚·ã‚¹ãƒ†ãƒ è² è· ãƒ¬ã‚¹ãƒãƒ³ã‚¹ ã‚¿ã‚¤ãƒ ã¨ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ çµåˆ å‡¦ç† å…¥ã‚Œå ãƒ«ãƒ¼ãƒ— ãƒãƒƒã‚·ãƒ¥ çµåˆ ã‚½ãƒ¼ãƒˆãƒž
Nnwww 2022/04/07
book

db
ãƒªãƒ³ã‚¯
Datomic Cloud ã‚’åŠå¹´é‹ç”¨ã—ãŸæ„Ÿæƒ³ï½œhden
ã“ã‚“ã«ã¡ã¯ã€æ ªå¼ä¼šç¤¾ãƒˆãƒ¬ã‚¿ã§ Clojure ã‚’æ›¸ã„ã¦ã„ã‚‹é„§ï¼ˆã§ã‚“ï¼‰ã§ã™ã€‚ 2021 å¹´ 7 æœˆã‚ˆã‚Šæ–°è¦äº‹æ¥ã‚’ã—ã¦é£²é£Ÿåº—å‘ã‘ã®ã‚»ãƒ«ãƒ•ã‚ªãƒ¼ãƒ€ãƒ¼ã‚·ã‚¹ãƒ†ãƒ ã‚’é–‹ç™ºã—ã¦ãŠã‚Šã€ãã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã« Datomic Cloud ã¨ Clojure ã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ æŽ¡ç”¨ç†ç”±ã¯å¹¾ã¤ã‹ã‚ã‚Šã¾ã™ãŒã€ä¸»ã«å±¥æ´ã€ç›£æŸ»ãƒã‚°ã€å¤‰æ›´é€šçŸ¥å‘¨ã‚Šã®æ©Ÿèƒ½è¦ä»¶ãŒãƒžãƒƒãƒã—ã¦ã„ã‚‹ã¨è€ƒãˆã¦ãŠã‚Šã€ç¾çŠ¶ Datomic ã¨è¦ªå’Œæ€§ãŒæœ€ã‚‚é«˜ã„ Clojure ã‚‚å…±ã«æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ è‰¯ã‹ã£ãŸã¨ã“ã‚ã€æ°—ã«å…¥ã£ãŸã¨ã“ã‚ç›´æ„Ÿçš„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãŒã§ãã‚‹ ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚’ã™ã‚‹éš›ã«ã¯æ„å¤–ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è‡ªä½“ã®åˆ¶é™ã‚„æ€æƒ³ã«å½±éŸ¿ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ä¾‹ãˆã° MySQL ã‚„ PostgreSQL ãªã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBï¼‰ã«æ…£ã‚Œã¦ã„ã‚‹äººã§ã‚ã‚Œã°ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªæƒ…å ±ã‚’è¡¨ç¾ã™ã‚‹ã¨ãã« 1:1ã€1:nã€n:1ã€n:n ã®é–¢ä¿‚æ€§ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã¨ã—ã¦
Nnwww 2021/12/13
Datomic

db

programming
ãƒªãƒ³ã‚¯
æ€¥ãŒã°å›žã‚Œã€é¸ã¶ãªã‚‰è¿‘é“ TXè¨˜äº‹ èªè§£ãƒ¡ãƒ¢ - ã±ã¨éšŠé•·æ—¥èªŒ
ç›®æ¬¡ ç›®æ¬¡ ã¯ã˜ã‚ã« å‰æçŸ¥è˜ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®åŸºç¤ŽçŸ¥è˜ æ•°å¦è¨˜å· iff Serializabilityã®é¸æŠž predicate install å‚è€ƒè³‡æ–™ æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã®è¡¨è¨˜ Welcome back to the TRANSACTION! A Critique of ANSI SQL Isolation Levelså†èª A critique of ansi sql isolation levels è§£èª¬å…¬é–‹ç”¨ ï¼ˆè§£èª¬ï¼‰Serializeã—ãŸã‚‚ã®ã¨åŒã˜ã€Œæ„å‘³ã€ã£ã¦ãªã‚“ã§ã™ã‹ï¼Ÿ ANSIã®å®šç¾©ã®æ›–æ˜§æ€§ã®æŒ‡æ‘˜ 2PLã§serializabilityã«ãªã‚‹ã“ã¨ã®è¨¼æ˜Ž Making Snapshot Isolation Serializableã€€å†è€ƒ å…¨ITé–¢ä¿‚è€…ãŒçŸ¥ã£ã¦ãŠãã¹ãã€Œ1-copy-snapshot isolationã€ Replicated Serializable Snap
Nnwww 2018/05/28
æœ€è¿‘CMU 15-721 (Spring 2018)ã‚’ãƒ™ãƒ¼ã‚¹ã«DBã«ã¤ã„ã¦å¦ã³å§‹ã‚ãŸèº«ã§ã™ãŒã€è¶³ã‚Šãªã„çŸ¥è˜ã‚’æŽ¢ã™ã®ã«å½¹ç«‹ã¡ã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚

DB
ãƒªãƒ³ã‚¯
LSM-Treeã¨RocksDBã€TiDBã€CockroachDBãŒæ°—ã«ãªã‚‹ Â· hnakamur's blog
2016-06-20 ã¯ã˜ã‚ã« ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ã«ã¤ã„ã¦èª¿ã¹ã¦ã„ãŸã‚‰LSM-Treeã¨ã„ã†ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¨RocksDBãŒæ°—ã«ãªã£ãŸã¨ã„ã†ã“ã¨ã§èª¿æŸ»ãƒ¡ãƒ¢ã§ã™ã€‚ãŸã ã—ã€ãã‚Œãžã‚Œã®æŠ€è¡“è©³ç´°ã‚’èª¿æŸ»ã—ãŸã‚Šè‡ªåˆ†ã§æ¤œè¨¼ã—ã¦ã¿ãŸã¨ã„ã†ãƒ¡ãƒ¢ã§ã¯ãªã„ã§ã™ã€‚ ãã†ã§ã¯ãªãã€ã„ã‚ã‚“ãªè¨˜äº‹ã§è¨€åŠã•ã‚Œã¦ã„ãŸã‚Šã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§æŽ¡ç”¨ã•ã‚Œã¦ã„ã‚‹ã®ãŒæ°—ã«ãªã£ãŸã¨ã„ã†ã ã‘ã®æµ…ã„ãƒ¡ãƒ¢ã§ã™ã€‚ãŒã€è„³å†…ãƒãƒƒãƒ•ã‚¡ã‹ã‚‰ã‚ãµã‚Œã‚‹é‡ã«ãªã£ãŸã®ã§è‡ªåˆ†ç”¨ã«è»½ãã¾ã¨ã‚ã€‚ LSM Tree Log-structured merge-treeã‚’ç•¥ã—ã¦LSM Treeã¨å‘¼ã¶ãã†ã§ã™ã€‚æ¦‚è¦ã¯Log-structured merge-tree - Wikipediaã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ CockroachDBã®ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®Read vs. Write Optimization Spectrumã«ã‚ˆã‚‹ã¨ã€B+ Treeã¨ã„ã†ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¯æ›¸ãè¾¼ã¿ã‚ˆã‚Šèª
Nnwww 2018/02/13
kvs

db
ãƒªãƒ³ã‚¯
Schedule - CMU 15-721 :: Advanced Database Systems (Spring 2017)
Course Introduction and History of Database Systems M. Stonebraker, et al., What Goes Around Comes Around, in Readings in Database Systems, 4th Edition, 2006 (Optional) A. Pavlo, et al., What's New with NewSQL?, in SIGMOD Record (vol. 45, iss. 2), 2016 (Optional) In-Memory Databases H. Garcia-Molina, et al., Main Memory Database Systems: An Overview, in IEEE Trans. on Knowl. and Data Eng., 1992 S.
Nnwww 2017/03/22
SQLã‚„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ä»£æ•°ã¯æ—¢çŸ¥ã¨ã—ã¦å®Ÿè·µçš„ãªå®Ÿè£…æŠ€è¡“ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹CMUã®è¬›ç¾©ã€‚ã“ã†ã„ã†ã®ãŒå—ã‘ãŸã‹ã£ãŸã€‚

DB

MOOC
ãƒªãƒ³ã‚¯
é–¢æ‰‹ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ï¼åœè«–ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼š ãã®å¾Œã®ç™ºå±•ã¨ç¾çŠ¶ (2016) - æªœå±±æ£å¹¸ã®ã‚ãƒžã‚¤ãƒ©é£¼è‚²è¨˜ (ã¯ã¦ãªBlog)
2013å¹´ã®åˆé ã«ã€ãƒ‡ã‚¤ãƒ´ã‚£ãƒƒãƒ‰ãƒ»ã‚¹ãƒ”ãƒ´ã‚¡ãƒƒã‚¯ã®é–¢æ‰‹ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ï¼ˆfunctorial data modelï¼‰ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ãƒ‡ã‚¤ãƒ´ã‚£ãƒƒãƒ‰ãƒ»ã‚¹ãƒ”ãƒ´ã‚¡ãƒƒã‚¯ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç•Œã®é©å‘½å…ã‹ -- é–¢æ‰‹çš„ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« è¡æ’ƒçš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç†è«–ãƒ»é–¢æ‰‹çš„ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« å…¥é–€ ã‚ã‚Œã‹ã‚‰3å¹´3ãƒ¶æœˆãŒçµŒéŽã—ã¦ã€ä»Šã€é–¢æ‰‹ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚„åœè«–ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆcategorical databaseï¼‰ã®çŠ¶æ³ã¯ã©ã†ãªã£ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ ä¸€è¨€ã§ã„ãˆã°ã€ æ´¾æ‰‹ã«å–§ä¼ã¯ã•ã‚Œã¦ãªã„ãŒã€ç€å®Ÿã«ç™ºå±•ã—ã¦ã„ã‚‹ ã¨ãªã‚‹ã§ã—ã‚‡ã†ã€‚ãã®é€²å±•ã®æ§˜åã‚’æ¬¡ã®3ã¤ã®å´é¢ã‹ã‚‰æ¦‚è¦³ã—ã¦ã¿ã¾ã™ã€‚ ãƒ“ã‚¸ãƒã‚¹ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ ç†è«– å†…å®¹ï¼š ãƒ“ã‚¸ãƒã‚¹ï¼š Categorical Informatics, Inc ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼š FQL IDE ç†è«–ï¼š ç‰å¼è«–ç†ã¨ä»£æ•°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ â€» ãƒªãƒ³ã‚¯ã¨æ³¨é‡ˆãŒãŸãã•ã‚“ã‚ã‚‹ã®ã¯ã€ã“ã®è¨˜äº‹ãŒã€ã“ã®è©±é¡Œã«é–¢ã™ã‚‹èª¬æ˜Žä»˜ããƒ–ãƒƒã‚¯ãƒž
Nnwww 2016/05/11
category

math

programming

functional

DB
ãƒªãƒ³ã‚¯
1