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

tom__bo id:tom__bo

dbã«é–¢ã™ã‚‹tom__boã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (47)

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

Data Models
Data Models: A Comprehensive Guide to Structuring Information for Optimal Insights and Decision-Making In the realm of data management, the use of effective data models plays a pivotal role in organizing and representing information in a structured and meaningful way. Data models serve as the blueprint for databases, facilitating efficient data storage, retrieval, and analysis. This article delves
tom__bo 2017/12/27
database

design

DB
ãƒªãƒ³ã‚¯
Weak Isolation in Relational Databases (evanjones.ca)
tom__bo 2017/10/22
skew

transaction

DB
ãƒªãƒ³ã‚¯
Making Snapshot Isolation Serializableã€€å†è€ƒ - æ€¥ãŒã°å›žã‚Œã€é¸ã¶ãªã‚‰è¿‘é“
Making Snapshot Isolation Serializable å†è€ƒ â– 2013å¹´çš„ãªä½ç½®ä»˜ã‘ ã¾ãšã¡ã‚‡ã†ã©å¹´åº¦ã®é–‹å§‹ãªã®ã§ã€ä»Šå¹´ã¯è‡ªåˆ†çš„ã«ã¯RDBMSé–¢é€£ã®ä½ç½®ä»˜ã‘ã¨ã‹æ•´ç†ã—ã¦ãŠãã¾ã™ã€‚åŽ»å¹´ã®å¾ŒåŠã‚ãŸã‚Šã‹ã‚‰ã®åŒ‚ã„ã§ã™ãŒã€NoSQLçš„ãªç™ºå±•ã¨åˆã‚ã›ã¦ã€æœ¬æ ¼çš„ãªDBå›žå¸°ãŒå§‹ã¾ã£ã¦ã„ã‚‹æ„Ÿã˜ã§ã™ã€‚NoSQLç³»ã®ã»ã¼è‡´å‘½çš„ãªå¼±ç‚¹ã®ä¸€ã¤ãŒtransactionå‡¦ç†ã§ã‚ã‚‹ã“ã¨ã¯æŒ‡æ‘˜ã‚‚å¤šã„ã¨ã“ã‚ã§ã™ã€‚è¦ã™ã‚‹ã«ãƒ‡ãƒ¼ã‚¿ãŒæ›¸ãè¾¼ã‚ã¦ã‚‚ä¸æ•´åˆãŒç™ºç”Ÿã—ã¾ã™ãã€ã¨ã„ã†ã“ã¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã§ã¯ãªã‹ãªã‹ä½¿ãˆãªã„ã€ã¨ã„ã†ã®ãŒç¾çŠ¶ã§ã—ã‚‡ã†ã€‚ ãªã®ã§ã€RDBMã®æœ€è‰¯ã®ãƒŽã‚¦ãƒã‚¦ã§ã‚ã‚‹transactionå‡¦ç†ã¨NoSQLçš„ãªåˆ†æ•£å‡¦ç†ã‚’ã¡ã‚ƒã‚“ã¨æ•´åˆæ€§ã¨ã‚Œã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€ã¨ã„ã†è‡ªç„¶ãªæµã‚Œã¯å¾“å‰ã‚ˆã‚Šã‚‚ã‚ˆã‚Šå¼·ã„è¦è«‹ãŒåƒãã§ã—ã‚‡ã†ã€‚(ã§ãã‚‹ã‹ã©ã†ã‹ã¯åˆ¥ã§ã™ãŒã€‚) ãã‚Œã§ã€ãã‚ãã‚ãªã‚“ã‹ãã®æ‰‹ã®ã‚‚ã®ãŒRDBMSã‚µ
tom__bo 2017/10/22
skew,SI

transaction

DB
ãƒªãƒ³ã‚¯
A Beginnerâ€™s Guide To Read and Write Skew Phenomena - DZone
tom__bo 2017/10/22
skew

transaction

DB
ãƒªãƒ³ã‚¯
Electron + vue + neDBã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ãƒ„ãƒ¼ãƒ«ä½œæˆ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? æ˜¨å¹´ã®ã‚ã¾ã‚Šã«ã‚‚ç„¡è¨ˆç”»ãªé–‹ç™ºã‚’çœã¿ã¦æ£æœˆã«ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ãƒŸãƒ‹ãƒžãƒ ã§ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªã‚‚ã®ã‚’ç›®æŒ‡ã—ãŸå˜ä½“ã‚¢ãƒ—ãƒªã§ã™ã€‚ ä¸€éƒ¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹çš„ã«ã¾ãšã„ã‚‚ã®ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãŸã‚å¼•ãå‰¥ãŒã—ãŸå¾Œgitã«ã‚¢ãƒƒãƒ—ã•ã›ã¦é ‚ãã¾ã™ã€‚ ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¨é¸å®šç†ç”±ã‚„ãƒ¡ãƒªãƒƒãƒˆç‰ã¯ä»¥ä¸‹ã€‚ ã©ã‚Œã‚‚å¤§ããªãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯æŽ¡ç”¨ã¯è¦‹é€ã‚‰ã‚Œãã†ãªã‚‚ã®ã°ã‹ã‚Šã§ã™ãŒ ãƒ‘ãƒ¼ã‚½ãƒŠãƒ«ãƒ¦ãƒ¼ã‚¹ã§å°è¦æ¨¡ãªã‚‚ã®ã§ã‚ã‚Œã°ä½¿ãˆã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ #ä»•æ§˜ã«ã¤ã„ã¦ ä¸‹ã®èª¬æ˜Žã§å¿…è¦ã«ãªã‚‹ãŸã‚ã‚¶ãƒƒã‚¯ãƒªã¨ä»•æ§˜èª¬æ˜Žã€‚ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ã€ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ >> ãƒ—ãƒã‚»ã‚¹ >> ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ >
tom__bo 2017/09/23
electron

db
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®æ–°ã—ã„ACIDã€ãã—ã¦BASEãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨CAPå®šç† - Fight the Future
ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã¯ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ¢ãƒ‡ãƒ«ãŒä»Šã¾ã§ã¨å¤‰ã‚ã‚‹ã€‚ QConã§ã¯è¤‡æ•°ã®äººã‹ã‚‰ãã†ã„ã†è©±ãŒå‡ºã¦ã„ãŸã€‚ ã¡ã‚‡ã£ã¨è‡ªåˆ†ãªã‚Šã«ã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚é–“é•ã£ã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã®ã§ã€è¦‹ã¤ã‘ãŸäººã¯ã”æŒ‡æ‘˜ãã ã•ã„ã€‚ æ–°ã—ã„ACID å¾“æ¥ã®ãƒ¢ãƒ‡ãƒ«ã§ã®ACIDã¯ã€ç‰¹ã«RDBMSé–¢é€£ã§ã‚ˆãè€³ã«ã™ã‚‹ã¨æ€ã†ã€‚ Atomic(åŽŸåæ€§) Consistent(ä¸€è²«æ€§) Isolated(ç‹¬ç«‹æ€§) Durable(æ°¸ç¶šæ€§) ã ã€‚ QConã§Googleã®Gregor Hohpeæ°ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã„ã¦ACIDã¯æ¬¡ã®ã‚ˆã†ãªæ„å‘³ã«ãªã‚‹ã¨è¨€ã£ã¦ã„ãŸã€‚ è³‡æ–™ã¯ã“ã“ã€‚https://sites.google.com/site/gcodejp/slides/ProgrammingCloud_QCon.pdf?attredirects=0 Associative(çµåˆã®) Commutative(ç›¸äº’ã®) Idempotent(
tom__bo 2017/09/21
cap

db

database

acid

base
ãƒªãƒ³ã‚¯
Google Spanner ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’çŸ¥ã‚‹ - Yuichi Murata's Engineering Blog
æœ€è¿‘ Cloud Spanner ã®ãƒ™ãƒ¼ã‚¿å…¬é–‹ã«ã‚ˆã£ã¦è©±é¡Œã® Spannerã€‚ æ°—ã«ãªã£ã¦ã„ãŸã®ã§è«–æ–‡ã‚’èªã‚“ã ã‚Šå‹‰å¼·ä¼šãªã©ã§æƒ…å ±åŽé›†ã—ã¦ã„ã¾ã—ãŸã€‚æ—¥æœ¬èªžã®ãƒªã‚½ãƒ¼ã‚¹ã‚‚ãã“ã¾ã§å¤šããªã„ã®ã§ã€èª¿ã¹ã¦ã‚ã‹ã£ãŸã“ã¨ã‚’çºã‚ã¦ãŠãã¾ã™ã€‚ ç°¡å˜ã«ã¾ã¨ã‚ã‚‹ã¨ç‰¹å¾´ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ Bigtable / Datastore ã¨é¡žä¼¼ã—ãŸã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ã¨ã£ã¦ãŠã‚Š Tablet ç¾¤ã«ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æ•£ä¿å˜ã—ã¦ã„ã‚‹ â†‘ã®ä»•çµ„ã¿ã§ã‚ã‚‹ã®ä¸Šã« Lock Table ã‚’å®Ÿè£…ã—ã¦åŒæœŸå‡¦ç†ã®ãŸã‚ã®ãƒãƒƒã‚¯ã‚’å‡¦ç†ã—ã¦ã„ã‚‹ ã•ã‚‰ã«â†‘ã®ä»•çµ„ã¿ã®ä¸Šã«åˆ†æ•£ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒžãƒã‚¸ãƒ£ãƒ¼ã‚’å®Ÿè£…ã—ã€ã‚°ãƒ«ãƒ¼ãƒ—æ¨ªæ–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ç®¡ç†ã™ã‚‹ ä»¥ä¸‹ã§ã€ç´°ã‹ã„èª¬æ˜Žã‚’ç¶šã‘ã¦ã„ãã¾ã™ã€‚ Spanner ã®å…¨ä½“æ§‹æˆ Universe ã¨ Zone Zone ã¨ Spanserver Spanserver ã®æ§‹æˆ Spanserver ã¨ Replica Rep
tom__bo 2017/09/17
Spanner

DB
ãƒªãƒ³ã‚¯
ã€ŒGoogle Cloud Spannerã€ç™ºè¡¨ã€‚åœ°çƒè¦æ¨¡ã®å¤§è¦æ¨¡åˆ†æ•£ç’°å¢ƒã§ç¨¼åƒã™ã‚‹ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«DBã€‚NoSQLä¸¦ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã§SQLå¯¾å¿œã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’å®Ÿç¾
ã€ŒGoogle Cloud Spannerã€ç™ºè¡¨ã€‚åœ°çƒè¦æ¨¡ã®å¤§è¦æ¨¡åˆ†æ•£ç’°å¢ƒã§ç¨¼åƒã™ã‚‹ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«DBã€‚NoSQLä¸¦ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã§SQLå¯¾å¿œã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’å®Ÿç¾ Googleã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§é«˜åº¦ãªã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å®Ÿç¾ã™ã‚‹ã€ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªæ¥å‹™ã«å¯¾å¿œã—ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒGoogle Cloud Spannerã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ Google Cloud Spannerã¯ã€åœ°çƒè¦æ¨¡ã®å¤§è¦æ¨¡åˆ†æ•£å‡¦ç†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€NoSQLä¸¦ã®éžå¸¸ã«é«˜ã„ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨é«˜ã„å¯ç”¨æ€§ã€ãã—ã¦é«˜é€Ÿãªå‡¦ç†ã‚’å®Ÿç¾ã—ã¤ã¤ã€SQLã«å¯¾å¿œã€‚å¼·ã„ä¸€è²«æ€§ã‚’æŒã¤ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚‚å®Ÿç¾ã€‚ä¼æ¥ã®ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªæ¥å‹™ã«ã‚‚ä½¿ãˆã‚‹ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ åœ°çƒè¦æ¨¡ã«åˆ†æ•£ã—ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ä¸€èˆ¬ã«ã€ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªæ¥å‹™ã«å¯¾å¿œã—ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡
tom__bo 2017/09/17
Spanner

DB
ãƒªãƒ³ã‚¯
1åˆ†ã§ã§ãã‚‹ï¼mysqlslapã§DBã®ã‹ã‚“ãŸã‚“æ€§èƒ½èª¿æŸ»ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ - Qiita
æ¥å‹™ä¸ã«ãã“ãã“å¤§ããªã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã™ã‚‹ã“ã¨ã«ãªã‚Šã€å®Ÿéš›ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤‰åŒ–ãŒã‚ã‚‹ã‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å–ã‚‹å¿…è¦ãŒå‡ºã¦ãã¾ã—ãŸã€‚ jmeterã¨ã‹ã§ã”ã‚Šã‚‡ã”ã‚Šã‚‡ã¨ã‹ã—ãªã„ã¨ãªã®ã‹ãƒ¼ã¨ã‹æ€ã£ãŸã®ã§ã™ãŒã€ ä»Šå›žã¯ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã®ã¿ãªã®ã§ã€å˜ç´”ã«DBã®ã¿ã®æ¸¬å®šã§ã‚ˆã„ã®ã§ã€ãªã‚“ã‹ã„ã„ãƒ„ãƒ¼ãƒ«ã¯ãªã„ã‹ã¨æŽ¢ã—ãŸã¨ã“ã‚ã€ mysqlslapãªã‚‹ã‚‚ã®ãŒã‚ã‚‹ã‚ˆã†ãªã®ã§è©¦ã—ã¦ã¿ã¾ã—ãŸ 4.5.7 mysqlslap â€” Load Emulation Client mysqlslapã¯MySQLã‚µãƒ¼ãƒã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆè² è·ã‚’ã‚¨ãƒŸãƒ¥ãƒ¬ãƒ¼ãƒˆã—ã€å„ã‚¹ãƒ†ãƒ¼ã‚¸ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’å ±å‘Šã™ã‚‹è¨ºæ–ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚ã‚µãƒ¼ãƒã«ãŸã„ã—ã¦è¤‡æ•°ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã‹ã®ã‚ˆã†ã«ä½œå‹•ã—ã¾ã™ã€‚mysqlslapã¯MySQL 5.1.4.ã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã•ã£ããè©¦ã—ã¦ã¿ãƒ¼ã‚‹ ä½¿ã„æ–¹ mysqlãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚Œã°æ¨™æº–ã§mysqlslapã‚‚ã‚¤ãƒ³
tom__bo 2017/09/16
benchmark

DB
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 10.13 Measuring Performance (Benchmarking)
tom__bo 2017/09/16
tpc

benchmark

DB
ãƒªãƒ³ã‚¯
tpcc-mysqlã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ï½žè¨ˆæ¸¬ æ‰‹é †ãƒ¡ãƒ¢
å¿…è¦ãªãƒ‘ãƒƒã‚±ãƒ¼ã‚¸(yumã§ä¾å˜é–¢ä¿‚ã‚’è¿½ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹å¥´ã¯é™¤ãï¼‰ ãƒ»MySQL-serverï¼ˆCentOSã®ãƒªãƒã‚¸ãƒˆãƒªä½¿ã†ãªã‚‰ã€mysql-serverï¼‰ ãƒ»MySQL-develï¼ˆCentOSã®ãƒªãƒã‚¸ãƒˆãƒªä½¿ã†ãªã‚‰ã€mysql-develï¼‰ ãƒ»MySQL-shredï¼ˆCentOSã®ãƒªãƒã‚¸ãƒˆãƒªä½¿ã†ãªã‚‰ã€mysql-libsï¼‰ ãƒ»bzr ãƒ»make ãƒ»gcc MySQL-serverãŒå…¥ã£ã¦ãªã„çŠ¶æ…‹ã ã¨ã€ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¯å‡ºæ¥ãŸã‘ã©å®Ÿè¡Œã—ã‚ˆã†ã¨ã™ã‚‹ã¨Segmentation Faultã—ãŸã€‚ ã‚½ãƒ¼ã‚¹ã®å…¥æ‰‹ï¼†ã‚³ãƒ³ãƒ‘ã‚¤ãƒ« $ bzr branch lp:~percona-dev/perconatools/tpcc-mysql ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ã«tpcc-mysqlãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’æŒã£ã¦ãã¦ãã‚Œã‚‹ã€‚ $ cd tpcc-mysql/src $ make ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå…¨éƒ¨æƒã£ã¦ã„ã‚Œã°makeä¸€ç™º
tom__bo 2017/09/16
tpc

benchmark

DB
ãƒªãƒ³ã‚¯
tpcc-mysql: Simple usage steps and how to build graphs with gnuplot - DZone
tom__bo 2017/09/16
tpc

benchmark

DB
ãƒªãƒ³ã‚¯
https://courses.cs.duke.edu/fall13/cps296.4/838-CloudPapers/ycsb.pdf
tom__bo 2017/09/16
YCSB

benchmark

db

NoSQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬2å›žã§ã™ã€‚ å‰å›žã¯TPC-Bãƒ™ãƒ¼ã‚¹ã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ã‚‚ã®ã‹ã‚‰6ã¤ã®ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã—ãŸã€‚ä»Šå›žã¯TPC-Cãƒ™ãƒ¼ã‚¹ã®ã‚‚ã®ã«ã¤ã„ã¦è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ tpcc-mysql å¯¾å¿œRDBMSï¼šMySQL å¯¾å¿œOSï¼šLinuxãªã© è¨€èªžï¼šC ä½œè€…ï¼šPercona Inc. ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ï¼šä¸æ˜Ž(ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«é–¢ã™ã‚‹è¨˜è¿°ãŒãªã„) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ä»•æ§˜ï¼šTPC-Cãƒ™ãƒ¼ã‚¹ URLï¼šhttps://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql tpcc-mysqlã¯MySQLã®ã‚³ãƒ³ã‚µãƒ«ä¼šç¤¾ã§ã‚ã‚‹Percona Inc.ã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã§ã€TPC-Cã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚TPC-Cã®ä»•æ§˜ã‚„tpcc-mysqlã«ã¤ã„ã¦ã¯ä»¥å‰ã®ã‚¨ãƒ³ãƒˆãƒªã§è©³ã—ãæ‰±ã£ã¦ã„ã‚‹ã®ã§ã€ãã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚ tpc
tom__bo 2017/09/12
DB

Benchmark

tpc
ãƒªãƒ³ã‚¯
Microsoft Azureã®NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒCosmos DBã€ã«ãŠã‘ã‚‹å®Ÿè£…æ–¹æ³•ã‚’çŸ¥ã‚‹
ã¯ã˜ã‚ã« Cosmos DBã¯ã€Œãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ã€Œã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã€ã€Œã‚°ãƒ©ãƒ•ã€ã€Œåˆ—æŒ‡å‘ã€ã®4ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ãã®ä¸ã‹ã‚‰ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚’å¯¾è±¡ã¨ã—ã¾ã™ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®æ“ä½œã«ã¯ã€ŒDocumentDB APIã€ã‚’ä½¿ã„ã¾ã™ã€‚ DocumentDB APIã¯ã€SQLã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å‚ç…§ã™ã‚‹ã“ã¨ãŒã§ãã‚‹APIã§ã€.NETã€Javaã€NodeJSã€Pythonç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®å…¥ã‚Œç‰©ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã®ä½œæˆã€å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã§ã‚ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ä½œæˆã¾ã§ã‚’é †ã«ã€.NETï¼ˆC#ï¼‰ã§å®Ÿè£…ã—ã¦ã„ãã¾ã™ã€‚ã¾ãŸã€Cosmos DBã¯ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã§å‹•ä½œã™ã‚‹ã€ŒCosmos DB Emulatorã€ã®ä½¿ç”¨ã‚’å‰æã¨ã—ã¦ã„ã¾ã™ã€‚Cosmos DB Emulatorã¯ç„¡å„Ÿã§ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ãŸã‚ã€ä»Šå›žã®ã‚ˆã†ãªã‚µãƒ³
tom__bo 2017/09/06
DB

MicrosoftAzure

Microsoft
ãƒªãƒ³ã‚¯
How Does a Database Work?
tom__bo 2017/09/05
db

rdb

sqlite
ãƒªãƒ³ã‚¯
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼ŸÂ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚ˆãæ¯”è¼ƒã•ã‚Œã‚‹PostgreSQLã¨MySQLã€‚ã©ã‚“ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼ŸÂ ãã‚Œãžã‚Œã®å°‚é–€å®¶ã«ã‚ˆã‚‹å¯¾è«‡ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨å¿…ãšç›´é¢ã™ã‚‹æ‚©ã¿ã€‚ãã‚Œã¯ã€ã€Œã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDBï¼‰ã‚’é¸ã¶ã®ãŒæœ€å–„ãªã®ã‹ï¼Ÿã€ã§ã™ã€‚ RDBã”ã¨ã«é•·æ‰€ã¨çŸæ‰€ã¯ç•°ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚è‡ªç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«ãƒžãƒƒãƒã—ãªã„RDBã‚’é¸ã‚“ã§ã—ã¾ã†ã¨ã€ãã‚ŒãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šé–‹ç™ºãƒ»é‹ç”¨ã«ãƒˆãƒ©ãƒ–ãƒ«ãŒç”Ÿã˜ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‹ã§ã‚‚ã‚ˆãæ¯”è¼ƒæ¤œè¨Žã•ã‚Œã‚‹ã®ãŒã€PostgreSQLã¨MySQLã€‚ã¨ã‚‚ã«ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„æ€§èƒ½ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ã
tom__bo 2017/09/05
postgresql

MySQL

DB

RDB
ãƒªãƒ³ã‚¯
multi-versionã®åŸºç¤Ž - æ€¥ãŒã°å›žã‚Œã€é¸ã¶ãªã‚‰è¿‘é“
multiversionã®åŸºç¤Ž è‡ªåˆ†ç”¨ã®Multi Version Concurrency Controlã®ã¾ã¨ã‚ MVCCã®åŸºç¤Žç†è«–ã‚’ã¾ã¨ã‚ã¦ãŠãã€‚ä»Šå¾Œã¯ã“ã“ã‚’å‚ç…§ã™ã‚‹ã€‚ åŸºæœ¬çš„ã«TXæœ¬ã¨CCæœ¬ã‹ã‚‰å¿…è¦ãªéƒ¨åˆ†ã‚’ã¾ã¨ã‚ã¦ã„ã‚‹ã€‚ ï¼ˆä¸€å›žã¾ã¨ã‚ã¦ã‚‹ã‘ã©ã€Multi-version Conflict Serializability - æ€¥ãŒã°å›žã‚Œã€é¸ã¶ãªã‚‰è¿‘é“ å‰å›žã¯ãã‚‚ãã‚‚CSRã¨ã®æ··ç·šã‚’é˜²ãã¨ã„ã†æ„å‘³ã ã£ãŸã®ã§ã€ä»Šå›žã¯ã‚‚ã£ã¨åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰ã•ã‚‰ã«ã€‚ä»Šå›žã¯CSRã¨ã®é–¢ä¿‚ã¯ã‚¬ãƒ³ç„¡è¦–ã€‚ï¼‰ å‰ç½®ãï¼šè‡ªåˆ†ã®è€ƒãˆã‚’è¨˜éŒ²çš„ã« åŸºæœ¬çš„ã«Multi Version Concurrency Control ï¼ˆä»¥ä¸‹MVCCï¼‰ã¯ç†è«–å…ˆè¡Œã ã£ãŸã€‚ã“ã‚Œã¯MVCCã®ã‚ªãƒ¼ãƒã¸ãƒ¼ãƒ‰ãŒsingle-versionã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‡Œé§•ã§ããªã‹ã£ãŸã“ã¨ã«ã‚ˆã‚‹ã€‚ä»¥ä¸‹ã®ç†ç”±ã«ã‚ˆã‚ŠMVCCãŒä»Šå¾Œã¯ä¼¸å¼µã™ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã€‚ 1.ãƒ¡ãƒ¢ãƒªãƒ¼
tom__bo 2017/08/05
MVCC

DB
ãƒªãƒ³ã‚¯
Schedule
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?, 2015 (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. Harizopoulos, et al., OLTP Through
tom__bo 2017/08/04
db
ãƒªãƒ³ã‚¯
ç©ºé–“ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(R-tree)å…¥é–€ - ãŸã«ã—ãã‚“ããƒ€ãƒ
R-treeã¨ã¯ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã‚’åŠ¹çŽ‡è‰¯ãæ¤œç´¢ã™ã‚‹ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ§‹é€ ã€‚R-tree ã«ã¤ã„ã¦èª¿ã¹ãŸã®ã¾ã¨ã‚ã¦ãŠãã€‚ ç›®æ¬¡ ç›®æ¬¡ å‚è€ƒè³‡æ–™ ãƒŠã‚¤ãƒ¼ãƒ–ãªä¾‹ R-tree ã®æ¦‚è¦ å„ãƒŽãƒ¼ãƒ‰ã®è¦ç´ æ•° å‚ç…§å‡¦ç† ç‚¹æ¤œç´¢ ç¯„å›²æ¤œç´¢ ãƒ‡ãƒ¼ã‚¿ã®æŒ¿å…¥ãƒ»å‰Šé™¤ æŒ¿å…¥å‡¦ç† ãƒŽãƒ¼ãƒ‰ã®åˆ†å‰² Exhaustive Algorithm Quadratic-Cost Algorithm Linear-Cost Algorithm å‰Šé™¤ æœ¨ã®å†æ§‹ç¯‰ã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ æ›´æ–°å‡¦ç† ã¾ã¨ã‚ å‚è€ƒè³‡æ–™ Guttman, Antonin. R-trees: a dynamic index structure for spatial searching. Vol. 14. No. 2. ACM, 1984. MySQL 5.7 Reference Manual - Creating Spatial Indexes PostGIS 2.3.3d
tom__bo 2017/06/08
tree

DB
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸