[B! transaction] beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

beth321 id:beth321

transactionã«é–¢ã™ã‚‹beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

æƒ…å ±ç§‘å¦ã«ãŠã‘ã‚‹18ã®ãƒ¡ã‚¿ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
1. Kanazawa Institute of Techno logy æƒ…å ±ç§‘å¦ã«ãŠã‘ã‚‹ 18ã®ãƒ¡ã‚¿ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ 2015å¹´4æœˆ30æ—¥ é‡‘æ²¢å·¥æ¥å¤§å¦ æƒ…å ±å·¥å¦ç§‘ ä¸é‡Ž æ·³ http://www.nakanolab.net/ 2. K.I.T.æƒ…å ±ç§‘å¦ã«ãŠã‘ã‚‹18ã®ãƒ¡ã‚¿ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ 1. ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚° 2. ãƒ–ãƒãƒƒã‚ãƒ³ã‚° vs. ãƒŽãƒ³ãƒ–ãƒãƒƒã‚ãƒ³ã‚° 3. ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚° 4. ãƒ‘ã‚¤ãƒ—ãƒ©ã‚¤ãƒ‹ãƒ³ã‚° 5. æŠ•æ©Ÿçš„å®Ÿè¡Œï¼ˆäºˆæ¸¬ï¼‰ 6. æ¡ä»¶ã®ç·©å’Œ 7. ã™ãã‚„ã‚‹ vs. å…ˆå»¶ã°ã— 8. ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚° 9. å†åˆ©ç”¨ 10. ä¸¦åˆ—åŒ– 11. çµåˆ vs. åˆ†é›¢ 12. å¤šéšŽå±¤ã€ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ– 13. å…ˆèªã¿ã€å…ˆå–ã‚Š 14. å‹•çš„ï¼ˆé©å¿œï¼‰ 15. è¤‡è£½ 16. ä»®æƒ³åŒ– 17. ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã€ ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ 18. ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ é•·ã„ã“ã¨æƒ…å ±ç§‘å¦ã«é–¢ã‚ã£ã¦ãã¦ã€ä¼¼ãŸã‚ˆã†ãªæŠ€æ³•ãŒåˆ†é‡Žã‚’ã¾ãŸãŒã£ã¦ç¹°ã‚Šè¿”ã—
beth321 2015/05/02
ã‚ã¨ã§èªã‚€

transaction

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

tec

ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯

programming

è€ƒãˆæ–¹

technology

ãŠå½¹ç«‹ã¡

slide
ãƒªãƒ³ã‚¯
ãã‚“ãªãƒˆãƒ©ãƒ³ã‚µã‚™ã‚¯ã‚·ãƒ§ãƒ³ãƒžãƒãƒ¼ã‚·ã‚™ãƒ£ã¦ã‚™å¤§ä¸ˆå¤«ã‹ï¼Ÿ
10. XAãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®SQLï¼ˆMySQLã®å ´åˆï¼‰ mysql> XA START 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO account VALUES(1, 'takezoe'); Query OK, 1 row affected (0.04 sec) mysql> XA END 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> XA PREPARE 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> XA COMMIT 'xatest'; Query OK, 0 rows affected (0.00 sec)
beth321 2014/06/01
transaction

ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯

Java

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

mysql

DB

jta

database

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

slides
ãƒªãƒ³ã‚¯
STMã®è¨è¨ˆã¨é€²åŒ–
Please select the category that most closely reflects your concern about theÂ presentation, so that we can review it and determine whether it violates our Terms of Use or isn't appropriate for all viewers.
beth321 2014/05/19
stm

presentation

programming

concurrent

javaåˆå¿ƒè€…å‘ã‘

kumagi

parallel

java

transaction

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®4ã¤ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’è©¦ã™ - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ 1ã¤ã®ä½œæ¥å˜ä½ã¨ã—ã¦æ‰±ã‚ã‚Œã‚‹SQLã‚¯ã‚¨ãƒªã®é›†ã¾ã‚Šã§ã™ã€‚ è¤‡æ•°ã®UPDATEã‚„INSERTã‚’ã²ã¨ã¤ã®é›†ã¾ã‚Šã¨ã—ã¦ã€ ãã‚Œã‚‰ã®ã‚¯ã‚¨ãƒªãŒã™ã¹ã¦é©ç”¨ã§ããŸå ´åˆã®ã¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åæ˜ ã—ã¾ã™ã€‚ ã²ã¨ã¤ã§ã‚‚é©ç”¨ã«å¤±æ•—ã—ãŸã‚¯ã‚¨ãƒªãŒã‚ã£ãŸå ´åˆã¯ã€ãã®ã¾ã¨ã¾ã‚Šã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã®çµæžœã¯åæ˜ ã—ã¾ã›ã‚“ã€‚ ACIDç‰¹æ€§ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«æ±‚ã‚ã‚‰ã‚Œã‚‹4ã¤ã®ç‰¹æ€§ã§ã™ã€‚ åŽŸåæ€§ (Atomicity) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ‰‹é †ãŒã€Œã™ã¹ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‹ã€ã€Œã™ã¹ã¦ã•ã‚Œãªã„ã‹ã€ã®ã©ã¡ã‚‰ã‹ã«ãªã‚‹æ€§è³ªã€‚ ä¸€è²«æ€§ (Consistency) ã©ã‚“ãªçŠ¶æ³ã§ã‚‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‰å¾Œã§ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ãŒçŸ›ç›¾ãªãä¿ãŸã‚Œã‚‹æ€§è³ªã€‚ åˆ†é›¢æ€§ (Isolation) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿè¡Œä¸ã¯ã€å‡¦ç†é€”ä¸ã®ãƒ‡ãƒ¼ã‚¿ã¯å¤–éƒ¨ã‹ã‚‰éš è”½ã•ã‚Œã¦ä»–ã®å‡¦ç†ã«å½±éŸ¿ã‚’ä¸Žãˆãªã„æ€§è³ªã€‚ æ°¸ç¶šæ€§ (Durability) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒå®Œäº†ã—ãŸã‚‰ã€ã‚·ã‚¹
beth321 2014/02/12
transaction

ãƒ‡ãƒ¼ã‚¿

PC

MySQL

DB

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

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

SQL

ã‚ã¨ã§èªã‚€

acid
ãƒªãƒ³ã‚¯
å…¨ITé–¢ä¿‚è€…ãŒçŸ¥ã£ã¦ãŠãã¹ãã€Œ1-copy-snapshot isolationã€ - æ€¥ãŒã°å›žã‚Œã€é¸ã¶ãªã‚‰è¿‘é“
snapshot isolationã‚’åˆ†æ•£ç’°å¢ƒã«é©ç”¨ã™ã‚‹å ´åˆã®ã€ŒåŸºæœ¬ã€ã®å†…å®¹ã®ã¾ã¨ã‚ã«ãªã‚Šã¾ã™ã€‚ï¼ˆåŸºæœ¬è‡ªåˆ†ç”¨ã®ãƒ¡ãƒ¢ãªã®ã§ã€é–“é•ã£ã¦ã„ãŸã‚‰ã™ã¿ã¾ã›ã‚“ï¼‰ ã¾ãšãƒ¯ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®æ•´ç† ãƒ»snapshot isolation TXã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã—ã¦ã®snapshot isolationï¼ˆä»¥ä¸‹SIï¼‰ã¯ã€ç¾åœ¨ã®RDBMSã®TXç®¡ç†ã§ã¯ã€ã»ã¼å®Ÿè£…çš„ã«ã¯ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã¨è¦‹ã¦ã„ã„ã¨æ€ã„ã¾ã™ã€‚ãŸã ã—ANSIã®è¦å®šã®ISOLATION_LEVELã«ã¯å®šç¾©ãŒãªã„ã®ã§ã€ã©ã®ã‚ãŸã‚Šã«ä½ç½®ã¥ã‘ã‚‹ã®ã‹ã¯ã€DBå®Ÿè£…ã®ãã‚Œãžã‚Œã®å–ã‚Šæ‰±ã„ã«ã‚ˆã‚Šç•°ãªã‚Šã¾ã™ã€‚ã¨ã¯ã„ãˆã€ã©ã®DBã§ã‚‚ã»ã¼SERIALIZABLEã«è¿‘ã„ä½ç½®ã¥ã‘ã«ã—ã¦ã„ã‚‹ã¨ã“ã‚ãŒå¤šã„ã§ã™ãã€ã¨ã„ã†ã‹ã€SIï¼ˆç‰¹ã«Serializable SIï¼‰ãã‚‰ã„ã§ãªã„ã¨serializableã«ç¾å®Ÿçš„ã«ã¯è¿‘ã¥ã‘ãªã„ã¨ã„ã†ã®ãŒå®Ÿæ…‹ã‹ã¨æ€ã„ã¾ã™ã€‚ï¼ˆå‹¿è«–ç†è«–ä¸Šã¯S2PLã§å®Ÿè£…ã¯å¯èƒ½ã§ã™ãŒã€ã¾ããƒ‘ãƒ•
beth321 2013/05/13
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ

IT

transaction

RDBMS

db

programming

memo

SI

åŸºæœ¬
ãƒªãƒ³ã‚¯
1