
ããã¹ã8åãé颿°ŽæºïŒããŒã¿ããŒã¹ã¹ãã·ã£ãªã¹ãïŒ
ãã®Noteã«ã¯ãé颿°ŽæºïŒISOLATION LEVELïŒãã«ã€ããŠããŸãšããŸããã
é颿°Žæºã¯ãWALãšåãã§ãã¹ãã§æ°ãã«åŠã¶ã¹ãæ°ç¥èã§ãã
4ã€ã®é颿°Žæºãš3ã€ã®ç°åžžã§ãèš7ã€èŠããã°ãªããŸãããååŸåé¡ã§ãã§ããããšãããã®ã§ããã£ããèŠããŠãã ãããååŸã§ç¥èåé¡ã§å€±ç¹ã¯ã§ããŸããã

ãã¹ãã®AMIIã¯ãã£ãã5幎åè§£ãã°ãå šãã¿ãŒã³ãææ¡ã§ããŸãã

ç§ãåæ Œããæã«ãåŠç¿ããŒãã«ãžã£ã³ã«æ¯ã«åé¡ããŸãšããŸããããã®Noteã®è§£èª¬ã¯ãåŠç¿ããŒããšãç§ã®ITå°éåŠæ ¡ã§ã®ææ¥å 容ãåºã«ããŠããŸãã
ããã§ã¯å§ããŸãããïŒ
ãã©ã³ã¶ã¯ã·ã§ã³åæå®è¡ã«ããç°åžžãšé颿°Žæº
ãã©ã³ã¶ã¯ã·ã§ã³ã®åæå®è¡ã«ãããŠã3ã€ã®ç°åžžãçºçããŸãã
ããŒãã£ãªãŒãïŒä»ã®ãã©ã³ã¶ã¯ã·ã§ã³ãæŽæ°ãããã³ãããããŠããªãæŽæ°å€ãèªã¿èŸŒãã ããä»ãã©ã³ã¶ã¯ã·ã§ã³ãããŒã«ããã¯ããŠæŽæ°åã®å€ã«ãªããèªã¿èŸŒãã å€ãšéããåºãŠããŸã£ãã
ãã³ãªããŒã¿ãã«ãªãŒãïŒãã©ã³ã¶ã¯ã·ã§ã³åŠçäžã«åãããŒã¿ãèªã¿èŸŒãã ããååãšéãå€ãèªã¿èŸŒãŸããŠããŸã£ããåŠçäžã«å¥ãã©ã³ã¶ã¯ã·ã§ã³ã«ãã£ãŠå€æŽãè¡ãããããã
ãã¡ã³ãã ãªãŒãïŒãã©ã³ã¶ã¯ã·ã§ã³åŠçäžã«åãããŒã¿ãèªã¿èŸŒãã ãšããååã¯ååšããªãã£ãè¡ãèªã¿èŸŒãŸãããåŠçäžã«å¥ãã©ã³ã¶ãŠã·ã§ã³ã«ãã£ãŠè¿œå ãè¡ãããŠãããã
é颿§æ°Žæºãšã¯ããã©ã³ã¶ã¯ã·ã§ã³ã®åæå®è¡ã«ããç°åžžãé²ãæ°Žæºã§ãã
READ UNCOMMITTEDïŒ3çš®é¡å šãŠã®ç°åžžãçºçããŸãã
READ COMMITTEDïŒããŒãã£ãªãŒããé²ããŸãã
REPEATABLE READïŒããŒãã£ãªãŒãããã³ãªããŒã¿ãã«ãªãŒããé²ã
SERIALIZABLEïŒ3çš®é¡å šãŠã®ç°åžžãé²ãã

å顿Œç¿ïŒ | åºæ¬çãªåé¡
é颿°ŽæºãREAD COMMITTEDã«ããæã«çºçããç¶æ ã¯ã©ãã
ã¢ïŒããŒãã£ãªãŒããã¢ã³ãªããŒã¿ãã«ãªãŒãããã¡ã³ãã ãªãŒããçºçãã
ã€ïŒããŒãã£ãªãŒããšã¢ã³ãªããŒã¿ãã«ãªãŒãã¯çºçããªããããã¡ã³ãã ãªãŒããçºçãã
ãŠïŒããŒãã£ãªãŒãã¯çºçããªãããã¢ã³ãªããŒã¿ãã«ãªãŒããšãã¡ã³ãã ãªãŒããçºçãã
ãšïŒããŒãã£ãªãŒããã¢ã³ãªããŒã¿ãã«ãªãŒãããã¡ã³ãã ãªãŒããçºçããªã
æ£çã¯ãŠã
READ COMMITTEDã§ã¯ãããŒãã£ãªãŒãã ãé²ããŸãã

次ã®(1)(2)ã«è©²åœããé颿°Žæºã¯ã©ããã
(1)ïŒããŒãã£ãªãŒãã¯çºçããªã
(2)ïŒ1ã€ã®ãã©ã³ã¶ã¯ã·ã§ã³äžã§ãããè¡ã2å以äžåç §ããå Žåã1åç®ã®èªã¿èŸŒã¿ãš2åç®ã®èªã¿èŸŒã¿ã®åå€ãåãã§ããããšãä¿èšŒãããªã
ã¢ïŒREAD COMMITTED
ã€ïŒREAD UNCOMMITTED
ãŠïŒREPEATABLE READ
ãšïŒSERIALIZABLE
å¹³æ31幎åå2å09ããæ¹å€
什å03幎åå2å07ããæ¹å€
æ£çã¯ã¢ã
(1)ãããã€ãæ¶ããŸãã
(2)ã¯ããã³ãªããŒã¿ãã«ãªãŒããçºçããããšããã£ãŠãã¢ã®READ COMMITTEDã§ãã

峿 Œãª2çžããã¯ãããã³ã«ã§ã衚ããã¯ãããåæå®è¡ãããã©ã³ã¶ã¯ã·ã§ã³ã«åœ±é¿ãäžããªãããã«ããé颿°Žæºã¯ã©ãã
ã¢ïŒREAD UNCOMMITTED
ã€ïŒREAD COMMITTED
ãŠïŒREPEATABLE READ
ãšïŒSERIALIZABLE
æ£çã¯ãšã
ä»ã®ãã©ã³ã¶ã¯ã·ã§ã³ãšã®åœ±é¿ãå®å šã«é²ãã«ã¯ããšã®SERIALIZABLEã®æ°ŽæºãããããŸããã

ãã©ã³ã¶ã¯ã·ã§ã³T2ã§ããŒãã£ãªãŒããçºçããŠããèšè¿°ã¯ã©ããã
ã¢ïŒT1ãè¡ãæ€çŽ¢ããT2ãåœè©²è¡ãæŽæ°ããT1ã¯ãã£ãã«èªã¿èŸŒãã è¡ãæŽæ°ããããã®åŸT2ãåãè¡ãèªã¿èŸŒãã§ããT2ã«ããæŽæ°ãåæ ãããŠããªãå€ãåŸã
ã€ïŒT1ãè¡ãæŽæ°ããT2ãåœè©²è¡ãæ€çŽ¢ããT1ãããŒã«ããã¯ããããT2ã¯åœè©²è¡ã«ååšããªãå€ãèªã¿èŸŒãã ããšã«ãªã
ãŠïŒT2ãæ¡ä»¶ãæºããè¡ãæ€çŽ¢ããT1ãT2ã®æ€çŽ¢æ¡ä»¶ãæºããè¡ãæ¿å ¥ããããã®åŸT2ã忡件ã§å床æ€çŽ¢ãããšããååã¯ååšããªãã£ãè¡ãèªãããšã«ãªã
ãšïŒT2ãè¡ãæ€çŽ¢ããT1ãåœè©²è¡ãæŽæ°ãã³ããããããT2ãåãè¡ãæ€çŽ¢ãããšããç°ãªãå€ãåŸãããšã«ãªãã
æ£çã¯ã€ã
ã€ïŒããŒãã£ãªãŒãïŒä»ãã©ã³ã¶ã¯ã·ã§ã³ã«ããããŒã«ããã¯ãåå
ãŠïŒãã¡ã³ãã ãªãŒãïŒä»ãã©ã³ã¶ã¯ã·ã§ã³ã«ããæ¿å ¥ãåå
ãšïŒãã³ãªããŒã¿ãã«ãªãŒãïŒä»ãã©ã³ã¶ã¯ã·ã§ã³ã®æŽæ°ãåå

ãã©ã³ã¶ã¯ã·ã§ã³TAãšTBãå®è¡ããããšããããŒãã£ãªãŒãã®èšè¿°ã¯ã©ãã
ã¢ïŒTAãæ€çŽ¢æ¡ä»¶ãæºããè¡ã®éåãåç §ããTBãTAãšåãæ¡ä»¶ãæºããæ°ããè¡ãæ¿å ¥ãã³ããããããTAãåãæ¡ä»¶ã§å床æ€çŽ¢ãããšååã«ã¯ååšããªãã£ãè¡ãåºçŸããã
ã€ïŒTAãããè¡ã®åãåç §ããTBãåœè©²åã®å€ãæŽæ°ãã³ããããããTAãåœè©²è¡ãå床åç §ãããšååã®åå€ãšã¯ç°ãªã£ãã
ãŠïŒTAãšTBããããã2çžããã¯ãããããããããã¯ãçºçããã
ãšïŒã³ãããåã®TAã®æŽæ°åŸããŒã¿ãTBãåç §ããåŸãæŽæ°åŸããŒã¿ã¯TAã«ãã£ãŠããŒã«ããã¯ãããã
æ£çã¯ãšã
ããŒãã£ãªãŒãã¯ãä»ãã©ã³ã¶ã¯ã·ã§ã³ã®æŽæ°ãããŒã«ããã¯ã«ãã£ãŠãååèªã¿èŸŒãã æŽæ°å€ããå ã®å€ã«æ»ãã®ã§äžæŽåãèµ·ããããšã§ãã
ã¢ïŒãã¡ã³ãã ãªãŒã
ã€ïŒãã³ãªããŒã¿ãã«ãªãŒã
ãŠïŒãããããã¯ã®çºçã¯ãé颿°Žæºãšã¯é¢ä¿ãããŸããã
ãšïŒããŒãã£ããŒã

ãã©ã³ã¶ã¯ã·ã§ã³T1ãšT2ããããšããæ¬¡ã®çŸè±¡ãé²ãé颿°Žæºã®ãã¡æãäœãæ°Žæºã®ãã®ã¯ã©ãããT1ãè¡Xãèªã¿èŸŒãã åŸãT2ãè¡Xã®å€ãæŽæ°ãã³ãããããT1ãè¡Xãå床èªã¿èŸŒããšãååãšç°ãªãå€ãåŸãããã
ã¢ïŒREAD COMMITTED
ã€ïŒREAD UNCOMMITTED
ãŠïŒREPEATABLE READ
ãšïŒSERIALIZABLE
æ£çã¯ãŠã
ãã³ãªããŒã¿ãã«ãªãŒããé²ãã®ã¯ãé«ã2ã€ã®æ°Žæºã§ãããã¡äžçªäœãã®ã¯ãŠãREPEATABLE READãã

å顿Œç¿ïŒ | å°ãé£ããåé¡

æ£çã¯ãšã
ããŒã¿ããŒã¹ã«ããããç»é²ããšã¯æ°ããããŒã¿ïŒè¡ïŒã®æ¿å ¥ã§ãã
ãã£ãŠT1ã®åŠçäžã«ãT2ãæ¿å ¥ïŒâ¡â¢ïŒããããšã§ãT1â£ã§T1â ã§ã¯èªã¿èŸŒãŸããªãã£ãæ°ããªè¡ãèªã¿èŸŒãã§ããã®ã§ããã¡ã³ãã ãªãŒãã
é颿°Žæºã¯READ UNCOMMITTEDãªã®ã§ãã©ã®é害ãé²ããŸããã


ããŒã¿ããŒã¹ã¹ãã·ã£ãªã¹ãã什å05幎åå2å16ãã
æ£çã¯ãšã
äžæŽåãªããŒã¿ã®èªã¿èŸŒã¿æžããã«ã¯ãé颿°Žæºãé«ããŸããåæå®è¡ã«ããé害ãé²ãã®ã§ãåæå®è¡ãåŸ ãããããšãå€ããªããŸãã
åæå®è¡ã§ããé »åºŠãæžãã®ã§ãäžå®æéåœããã«å®è¡ã§ãããã©ã³ã¶ã¯ã·ã§ã³æ°ãæžããŸãã
ãŸãšã
ãç²ãæ§ã§ããïŒ
ã©ãã±ãããŒããšãŸãšããŸãã

ç°åžžçŸè±¡ã¯ä»¥äžã®éãã
ããŒãã£ãªãŒãïŒä»ã®ãã©ã³ã¶ã¯ã·ã§ã³ãæŽæ°ãããã³ãããããŠããªãæŽæ°å€ãèªã¿èŸŒãã ããä»ãã©ã³ã¶ã¯ã·ã§ã³ãããŒã«ããã¯ããŠæŽæ°åã®å€ã«ãªããèªã¿èŸŒãã å€ãšéããåºãŠããŸã£ãã
ãã³ãªããŒã¿ãã«ãªãŒãïŒãã©ã³ã¶ã¯ã·ã§ã³åŠçäžã«åãããŒã¿ãèªã¿èŸŒãã ããååãšéãå€ãèªã¿èŸŒãŸããŠããŸã£ããåŠçäžã«å¥ãã©ã³ã¶ã¯ã·ã§ã³ã«ãã£ãŠå€æŽãè¡ãããããã
ãã¡ã³ãã ãªãŒãïŒãã©ã³ã¶ã¯ã·ã§ã³åŠçäžã«åãããŒã¿ãèªã¿èŸŒãã ãšããååã¯ååšããªãã£ãè¡ãèªã¿èŸŒãŸãããåŠçäžã«å¥ãã©ã³ã¶ãŠã·ã§ã³ã«ãã£ãŠè¿œå ãè¡ãããŠãããã
åå ãã€ã¡ãŒãžã§ããŠãããšè¯ãã§ããã
ã€ïŒããŒãã£ãªãŒãïŒä»ãã©ã³ã¶ã¯ã·ã§ã³ã«ããããŒã«ããã¯ãåå
ãŠïŒãã¡ã³ãã ãªãŒãïŒä»ãã©ã³ã¶ã¯ã·ã§ã³ã«ããæ¿å ¥ãåå
ãšïŒãã³ãªããŒã¿ãã«ãªãŒãïŒä»ãã©ã³ã¶ã¯ã·ã§ã³ã®æŽæ°ãåå
çŸè±¡ãšåå ã®ã©ã¡ãããç¥ã£ãŠããã ãã§éããŸããç§ã¯åå ã®æ¹ãèŠããŠãã©ããªçŸè±¡ãèµ·ããããèããããã«ããŠããŸãã
ç§ãåæ ŒããŠããå匷æ³ã«ã€ããŠãNoteã«ããŸããã
ãŸãã¯æžç±ã®èªã¿åãæ¹ãAMIIã®å匷ã ãã§ãåèã«ããŠé ããã°ãå¬ããã§ãã
p.s. æ®æ®µã¯ >> å°éåŠæ ¡ãšITå°±è·ã®ããã° << ããã£ãŠãŸãã
ã§ãã§ãïŒã»Ïã»âŒïŒãã·
ãã®èšäºãåå ããŠããåé
- #ã¹ãããŠã¿ãŠ
- #æ å ±
- #ããŒã¿
- #IT
- #è³æ Œ
- #è³æ Œè©Šéš
- #ç¬åŠ
- #åæ Œ
- #è³æ ŒååŸ
- #æŽæ°
- #詊éšå¯Ÿç
- #å°éåŠæ ¡
- #ããŒã¿ããŒã¹
- #è³æ Œè©Šéšå匷
- #çºç
- #ç¬åŠåæ Œ
- #è³æ Œè©Šéšå匷æ³
- #æ¿å ¥
- #DB
- #ãã©ã³ã¶ã¯ã·ã§ã³
- #ããŒã¿ããŒã¹ã¹ãã·ã£ãªã¹ã
- #ããŒã¿ããŒã¹ã¹ãã·ã£ãªã¹ã詊éš
- #ããŒã«ããã¯
- #RDB
- #é¢ä¿ããŒã¿ããŒã¹
- #ããŒãã£ãªãŒã
- #ãã³ãªããŒã¿ãã«ãªãŒã
- #ãªã¬ãŒã·ã§ãã«ããŒã¿ãŒããŒã¹
- #é颿°Žæº
- #ãã¡ã³ãã ãªãŒã