InterSystems IRIS DBMS ã¯ãããŒã¿ãä¿åããããã®èå³æ·±ãæ§é ãã€ãŸãã°ããŒãã«ããµããŒãããŠããŸãã åºæ¬çã«ããããã¯ããã©ã³ã¶ã¯ã·ã§ã³ãããŒã¿ ããªãŒã暪æããããã®é«éé¢æ°ãããã¯ãããã³ç¬èªã® ObjectScript èšèªã®åœ¢åŒã§ããŸããŸãªè¿œå æ©èœãåãããã«ãã¬ãã« ããŒã§ãã
ã°ããŒãã«ã«ã€ããŠè©³ããã¯ããã°ããŒãã«ã¯ããŒã¿ãä¿åããããã®å®å£ã§ãããã·ãªãŒãºã®èšäºãã芧ãã ããã
ã°ããŒãã«ã§ãã©ã³ã¶ã¯ã·ã§ã³ãã©ã®ããã«å®è£
ãããŠããã®ããã©ã®ãããªæ©èœãããã®ãââã«èå³ãæã¡ãŸããã çµå±ã®ãšãããããã¯ããŒã¿ãä¿åããããã®éåžžã®ããŒãã«ãšã¯ãŸã£ããç°ãªãæ§é ã§ãã ã¯ããã«äœãã¬ãã«ã§ãã
ãªã¬ãŒã·ã§ãã« ããŒã¿ããŒã¹ã®çè«ããç¥ãããŠããããã«ããã©ã³ã¶ã¯ã·ã§ã³ãé©åã«å®è£
ããã«ã¯ã次ã®èŠä»¶ãæºããå¿
èŠããããŸãã
A - ã¢ãããã¯ïŒååæ§ïŒã ãã©ã³ã¶ã¯ã·ã§ã³ã§è¡ãããå€æŽã¯ãã¹ãŠèšé²ããããããŸã£ããèšé²ãããŸããã
C - äžè²«æ§ã ãã©ã³ã¶ã¯ã·ã§ã³ãå®äºããåŸã¯ãããŒã¿ããŒã¹ã®è«çç¶æ ãå éšçã«äžè²«ããŠããå¿ èŠããããŸãã å€ãã®ç¹ã§ããã®èŠä»¶ã¯ããã°ã©ãã«é¢ä¿ããŸãããSQL ããŒã¿ããŒã¹ã®å Žåã¯å€éšããŒã«ãé¢ä¿ããŸãã
ç§ - éé¢ããŸãã 䞊è¡ããŠå®è¡ãããŠãããã©ã³ã¶ã¯ã·ã§ã³ã¯ãçžäºã«åœ±é¿ãäžããã¹ãã§ã¯ãããŸããã
D - èä¹ æ§ããããŸãã ãã©ã³ã¶ã¯ã·ã§ã³ãæ£åžžã«å®äºããåŸã¯ãäžäœã¬ãã«ã®åé¡ (é»æºé害ãªã©) ããã©ã³ã¶ã¯ã·ã§ã³ã«ãã£ãŠå€æŽãããããŒã¿ã«åœ±é¿ãäžããããšã¯ãããŸããã
ã°ããŒãã«ã¯éãªã¬ãŒã·ã§ãã« ããŒã¿æ§é ã§ãã ãããã¯ãéåžžã«éãããããŒããŠã§ã¢ã§è¶
é«éã«åäœããããã«èšèšãããŠããŸãã ã䜿çšããŠã°ããŒãã«ã§ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®å®è£
ãèŠãŠã¿ãŸãããã
IRIS ã§ãã©ã³ã¶ã¯ã·ã§ã³ããµããŒãããã«ã¯ã次ã®ã³ãã³ãã䜿çšãããŸãã
1. ååæ§
ãã§ãã¯ããæãç°¡åãªæ¹æ³ã¯ã¢ãããã¯æ§ã§ãã ããŒã¿ããŒã¹ã³ã³ãœãŒã«ãã確èªããŠã¿ãŸãã
Kill ^a
TSTART
Set ^a(1) = 1
Set ^a(2) = 2
Set ^a(3) = 3
TCOMMIT
ãããŠã次ã®ããã«çµè«ä»ããŸãã
Write ^a(1), â â, ^a(2), â â, ^a(3)
æã ãåŸãïŒ
1 2 3
ãã¹ãŠé 調ã ååæ§ã¯ç¶æããããã¹ãŠã®å€æŽãèšé²ãããŸãã
ã¿ã¹ã¯ãè€éã«ããŠãšã©ãŒãå°å ¥ãããã©ã³ã¶ã¯ã·ã§ã³ãéšåçã«ãŸãã¯ãŸã£ããä¿åãããªãããã«ã©ã®ããã«ä¿åãããããèŠãŠã¿ãŸãããã
ååæ§ãããäžåºŠç¢ºèªããŠã¿ãŸãããã
Kill ^A
TSTART
Set ^a(1) = 1
Set ^a(2) = 2
Set ^a(3) = 3
次ã«ãã³ã³ããã匷å¶çã«åæ¢ããèµ·åããŠç¢ºèªããŸãã
docker kill my-iris
ãã®ã³ãã³ãã¯ãSIGKILL ã·ã°ãã«ãéä¿¡ããŠããã»ã¹ãå³æã«åæ¢ããããã匷å¶ã·ã£ããããŠã³ãšã»ãŒåçã§ãã
ãããããã©ã³ã¶ã¯ã·ã§ã³ã¯éšåçã«ä¿åãããŸããã?
WRITE ^a(1), ^a(2), ^a(3)
^
<UNDEFINED> ^a(1)
- ããããçãæ®ã£ãŠããŸããã
ããŒã«ãã㯠ã³ãã³ããè©ŠããŠã¿ãŸãããã
Kill ^A
TSTART
Set ^a(1) = 1
Set ^a(2) = 2
Set ^a(3) = 3
TROLLBACK
WRITE ^a(1), ^a(2), ^a(3)
^
<UNDEFINED> ^a(1)
äœãçãæ®ã£ãŠããŸããã
2.äžè²«æ§
ã°ããŒãã«ã«åºã¥ãããŒã¿ããŒã¹ã§ã¯ãããŒãã°ããŒãã«ã§äœæããããã (ã°ããŒãã«ã¯ãªã¬ãŒã·ã§ãã« ããŒãã«ãããããŒã¿ãæ ŒçŽããããã®äœã¬ãã«ã®æ§é ã§ããããšãæãåºããŠãã ãã)ãäžè²«æ§ã®èŠä»¶ãæºããã«ã¯ãããŒã®å€æŽãå«ããå¿ èŠããããŸããã°ããŒãã«ã®å€æŽãšåããã©ã³ã¶ã¯ã·ã§ã³å ã§ã
ããšãã°ãã°ããŒãã« ^person ããããããã«ããŒãœããªãã£ãä¿åããTIN ãããŒãšããŠäœ¿çšããŸãã
^person(1234567, âfirstnameâ) = âSergeyâ
^person(1234567, âlastnameâ) = âKamenevâ
^person(1234567, âphoneâ) = â+74995555555
...
å§ãšåã§ç°¡åã«æ€çŽ¢ã§ããããã«ã^index ããŒãäœæããŸããã
^index(âKamenevâ, âSergeyâ, 1234567) = 1
ããŒã¿ããŒã¹ã®äžè²«æ§ãä¿ã€ããã«ã次ã®ããã«ãã«ãœããè¿œå ããå¿ èŠããããŸãã
TSTART
^person(1234567, âfirstnameâ) = âSergeyâ
^person(1234567, âlastnameâ) = âKamenevâ
^person(1234567, âphoneâ) = â+74995555555
^index(âKamenevâ, âSergeyâ, 1234567) = 1
TCOMMIT
ãããã£ãŠãåé€ãããšãã¯ãã©ã³ã¶ã¯ã·ã§ã³ã䜿çšããå¿ èŠããããŸãã
TSTART
Kill ^person(1234567)
ZKill ^index(âKamenevâ, âSergeyâ, 1234567)
TCOMMIT
èšãæããã°ãäžè²«æ§èŠä»¶ãæºããããšã¯ãã¹ãŠããã°ã©ãã®è©ã«ããã£ãŠããŸãã ããããã°ããŒãã«ã«é¢ããŠã¯ããã®äœã¬ãã«ã®æ§è³ªã®ãããããã¯æ£åžžã§ãã
3. éé¢
ãããããèéã®å§ãŸãã§ãã å€ãã®ãŠãŒã¶ãŒãåãããŒã¿ããŒã¹ã§åæã«äœæ¥ããåãããŒã¿ãå€æŽããŸãã
ãã®ç¶æ³ã¯ãå€ãã®ãŠãŒã¶ãŒãåãã³ãŒã ãªããžããªãåæã«æäœããå€ãã®ãã¡ã€ã«ãžã®å€æŽãäžåºŠã«åæã«ã³ãããããããšããå Žåã«äŒŒãŠããŸãã
ããŒã¿ããŒã¹ã¯ãã¹ãŠããªã¢ã«ã¿ã€ã ã§æŽçããå¿ èŠããããŸãã æ¬æ ŒçãªäŒæ¥ã§ã¯ãããŒãžã§ã³ç®¡ç (ãã©ã³ãã®ããŒãžã競åã®è§£æ±ºãªã©) ãæ åœããç¹å¥ãªæ åœè ããããŠãããŒã¿ããŒã¹ãããããã¹ãŠããªã¢ã«ã¿ã€ã ã§å®è¡ããå¿ èŠãããããšãèæ ®ãããšãã¿ã¹ã¯ã®è€éããšããŒã¿ããŒã¹ã®æ£ç¢ºæ§ã¯éåžžã«éèŠã§ããããŒã¿ããŒã¹ã®èšèšãšãããæäŸããã³ãŒãã
ããŒã¿ããŒã¹ã¯ããŠãŒã¶ãŒãåãããŒã¿ãæäœããŠããå Žåã競åãé¿ããããã«ãŠãŒã¶ãŒãå®è¡ããã¢ã¯ã·ã§ã³ã®æå³ãç解ã§ããŸããã å¥ã®ãã©ã³ã¶ã¯ã·ã§ã³ãšç«¶åãã XNUMX ã€ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ã¿ãå ã«æ»ãããšããããããé çªã«å®è¡ããããšãã§ããŸãã
ãã XNUMX ã€ã®åé¡ã¯ããã©ã³ã¶ã¯ã·ã§ã³ã®å®è¡äž (ã³ãããå) ã«ããŒã¿ããŒã¹ã®ç¶æ ãççŸããå¯èœæ§ããããããä»ã®ãã©ã³ã¶ã¯ã·ã§ã³ãããŒã¿ããŒã¹ã®ççŸããç¶æ ã«ã¢ã¯ã»ã¹ã§ããªãããšãæãŸããããšã§ããããã¯ãªã¬ãŒã·ã§ãã« ããŒã¿ããŒã¹ã§å®çŸãããŸããã¹ãããã·ã§ããã®äœæãè¡ã®ãã«ãããŒãžã§ã³ç®¡çãªã©ãããŸããŸãªæ¹æ³ã§ã
ãã©ã³ã¶ã¯ã·ã§ã³ã䞊è¡ããŠå®è¡ããå Žåãçžäºã«å¹²æžããªãããšãéèŠã§ãã ãããå€ç«ã®ç¹æ§ã§ãã
SQL ã§ã¯ 4 ã€ã®åé¢ã¬ãã«ãå®çŸ©ãããŠããŸãã
- ãèªã¿ãã ãã
- ã³ããããèªã
- å埩èªã¿åã
- ã·ãªã¢ã«åå¯èœ
åã¬ãã«ãåå¥ã«èŠãŠã¿ãŸãããã åã¬ãã«ã®å®è£ ã³ã¹ãã¯ãã»ãŒææ°é¢æ°çã«å¢å ããŸãã
ãèªã¿ãã ãã - ããã¯æãäœãã¬ãã«ã®åé¢ã§ãããåæã«æãé«éã§ãã ãã©ã³ã¶ã¯ã·ã§ã³ã¯ãçžäºã«è¡ãããå€æŽãèªã¿åãããšãã§ããŸãã
ã³ããããèªã ã¯æ¬¡ã®ã¬ãã«ã®åé¢ã§ããã劥åã§ãã ãã©ã³ã¶ã¯ã·ã§ã³ã¯ãã³ãããåã«çžäºã®å€æŽãèªã¿åãããšã¯ã§ããŸããããã³ãããåŸã«å ããããå€æŽãèªã¿åãããšã¯ã§ããŸãã
é·ããã©ã³ã¶ã¯ã·ã§ã³ T1 ãããããã®éã«ãã©ã³ã¶ã¯ã·ã§ã³ T2ãT3 ... Tn ã§ã³ããããçºçããT1 ãšåãããŒã¿ãåŠçããå ŽåãT1 ã§ããŒã¿ããªã¯ãšã¹ããããšãæ¯åç°ãªãçµæãåŸãããŸãã ãã®çŸè±¡ã¯éå埩èªã¿åããšåŒã°ããŸãã
å埩èªã¿åã â ãã®åé¢ã¬ãã«ã§ã¯ãããŒã¿ã®èªã¿åããªã¯ãšã¹ãããšã«çµæããŒã¿ã®ã¹ãããã·ã§ãããäœæãããåããã©ã³ã¶ã¯ã·ã§ã³ã§åå©çšãããå Žåãã¹ãããã·ã§ããã®ããŒã¿ãäœæããããããå埩äžå¯èœãªèªã¿åããšããçŸè±¡ã¯çºçããŸããã䜿çšãããŠããã ãã ãããã®åé¢ã¬ãã«ã§ããã¡ã³ãã ããŒã¿ãèªã¿åãããšã¯å¯èœã§ãã ããã¯ã䞊åã³ãããããããã©ã³ã¶ã¯ã·ã§ã³ã«ãã£ãŠè¿œå ãããæ°ããè¡ãèªã¿åãããšãæããŸãã
ã·ãªã¢ã«åå¯èœ â æé«ã¬ãã«ã®æç±æ§ã ããã¯ããã©ã³ã¶ã¯ã·ã§ã³å ã§äœããã®æ¹æ³ (èªã¿åããŸãã¯å€æŽ) ã§äœ¿çšãããããŒã¿ããæåã®ãã©ã³ã¶ã¯ã·ã§ã³ã®å®äºåŸã«ã®ã¿ä»ã®ãã©ã³ã¶ã¯ã·ã§ã³ã§äœ¿çšå¯èœã«ãªããšããäºå®ã«ãã£ãŠç¹åŸŽä»ããããŸãã
ãŸãããã©ã³ã¶ã¯ã·ã§ã³å ã®æäœãã¡ã€ã³ ã¹ã¬ããããåé¢ãããŠãããã©ããã確èªããŠã¿ãŸãããã 2 ã€ã®ã¿ãŒããã« ãŠã£ã³ããŠãéããŠã¿ãŸãããã
Kill ^t
Write ^t(1)
2
TSTART
Set ^t(1)=2
å€ç«ã¯ãããŸããã XNUMX ã€ã®ã¹ã¬ããã¯ããã©ã³ã¶ã¯ã·ã§ã³ãéãã XNUMX çªç®ã®ã¹ã¬ãããäœãããŠãããã確èªããŸãã
ããŸããŸãªã¹ã¬ããã®ãã©ã³ã¶ã¯ã·ã§ã³ãå éšã§äœãèµ·ãã£ãŠãããã確èªããŠã¿ãŸãããã
2 ã€ã®ã¿ãŒããã« ãŠã£ã³ããŠãéããŠã2 ã€ã®ãã©ã³ã¶ã¯ã·ã§ã³ã䞊è¡ããŠéããŸãã
kill ^t
TSTART
Write ^t(1)
3
TSTART
Set ^t(1)=3
䞊åãã©ã³ã¶ã¯ã·ã§ã³ã¯çžäºã®ããŒã¿ãåç §ããŸãã ããã§ãæãåçŽã§ãããªããæéã®åé¢ã¬ãã«ã§ãã READ UNCOMMITED ãååŸããŸããã
åççã«ã¯ãããã¯ããã©ãŒãã³ã¹ãåžžã«åªå ãããŠããã°ããŒãã«äŒæ¥ã§ã¯äºæ³ãããããšã§ãã
ã°ããŒãã«ã§ã®æäœã«ãããŠããé«ãã¬ãã«ã®åé¢ãå¿ èŠãªå Žåã¯ã©ãããã°ããã§ãããã?
ããã§ããªãåé¢ã¬ãã«ãå¿ èŠãªã®ãããããŠãããã©ã®ããã«æ©èœããã®ããèããå¿ èŠããããŸãã
æãé«ãåé¢ã¬ãã«ã§ãã SERIALIZE ã¯ã䞊åå®è¡ããããã©ã³ã¶ã¯ã·ã§ã³ã®çµæãé次å®è¡ãšåçã§ããããšãæå³ããè¡çªããªãããšãä¿èšŒãããŸãã
ããã¯ãObjectScript ã®ã¹ããŒã ããã¯ã䜿çšããŠå®è¡ã§ããŸããã¹ããŒã ããã¯ã«ã¯ããŸããŸãªçšéããããŸããã³ãã³ãã䜿çšããŠãå®æçãå¢åçãè€æ°ã®ããã¯ãå®è¡ã§ããŸãã
åé¢ã¬ãã«ãäœãããããšã¯ãããŒã¿ããŒã¹ã®é床ãäžããããã«èšèšããããã¬ãŒããªãã§ãã
ããã¯ã䜿çšããŠããŸããŸãªã¬ãã«ã®åé¢ãå®çŸããæ¹æ³ãèŠãŠã¿ãŸãããã
ãã®æŒç®åã䜿çšãããšãããŒã¿ã®å€æŽã«å¿ èŠãªæä»ããã¯ã ãã§ãªããããããå ±æããã¯ãååŸã§ããŸããå ±æããã¯ã¯ãèªã¿åãããã»ã¹äžã«ä»ã®ããã»ã¹ã«ãã£ãŠå€æŽãããã¹ãã§ã¯ãªãããŒã¿ãèªã¿åãå¿ èŠãããå Žåã«ãè€æ°ã®ã¹ã¬ããã䞊è¡ããŠååŸã§ããŸãã
XNUMX 段éããããã³ã°æ¹æ³ã®è©³çŽ°æ å ± (ãã·ã¢èªãšè±èª):
â
â
åé¡ã¯ããã©ã³ã¶ã¯ã·ã§ã³äžã«ããŒã¿ããŒã¹ã®ç¶æ ãäžæŽåã«ãªãå¯èœæ§ããããããã®äžæŽåãªããŒã¿ãä»ã®ããã»ã¹ããèŠããããšã§ãã ãããåé¿ããã«ã¯ã©ãããã°ããã§ãããã?
ããã¯ã䜿çšããŠãããŒã¿ããŒã¹ã®ç¶æ ãäžè²«ããŠããå¯èŠæ§ãŠã£ã³ããŠãäœæããŸãã ãããŠãåæãããç¶æ ãå¯èŠåãããã®ãããªãŠã£ã³ããŠãžã®ãã¹ãŠã®ã¢ã¯ã»ã¹ã¯ããã¯ã«ãã£ãŠå¶åŸ¡ãããŸãã
åãããŒã¿ã«å¯Ÿããå ±æããã¯ã¯åå©çšå¯èœã§ãããè€æ°ã®ããã»ã¹ãå ±æããã¯ãååŸã§ããŸãã ãããã®ããã¯ã¯ãä»ã®ããã»ã¹ãããŒã¿ãå€æŽããããšãé²ããŸãã ãããã¯ãäžè²«ããããŒã¿ããŒã¹ç¶æ ã®ãŠã£ã³ããŠã圢æããããã«äœ¿çšãããŸãã
æä»çããã¯ã¯ããŒã¿å€æŽã«äœ¿çšãããŸãããã®ãããªããã¯ãååŸã§ããã®ã¯ XNUMX ã€ã®ããã»ã¹ã ãã§ãã æä»ããã¯ã¯æ¬¡ã®æ¹æ³ã§ååŸã§ããŸãã
- ããŒã¿ãç¡æã§ããã°ã©ã®ãããªåŠçã§ãå¯èœ
- ãã®ããŒã¿ã«å¯ŸããŠå ±æããã¯ãæã¡ãæåã«æä»ããã¯ãèŠæ±ããããã»ã¹ã®ã¿ã
å¯èŠæ§ãŠã£ã³ããŠãçãã»ã©ãä»ã®ããã»ã¹ããããåŸ
ã€å¿
èŠãããæéãé·ããªããŸããããã®äžã®ããŒã¿ããŒã¹ã®ç¶æ
ã®äžè²«æ§ã¯ããé«ããªããŸãã
READ_COMMITTED â ãã®ã¬ãã«ã®æ¬è³ªã¯ãä»ã®ã¹ã¬ããããã³ããããããããŒã¿ã®ã¿ã衚瀺ãããããšã§ãã å¥ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ããŒã¿ããŸã ã³ããããããŠããªãå Žåã¯ããã®å€ãããŒãžã§ã³ã衚瀺ãããŸãã
ããã«ãããããã¯ã解æŸãããã®ãåŸ ã€ä»£ããã«ãäœæ¥ã䞊ååããããšãã§ããŸãã
ç¹å¥ãªå·¥å€«ããªããšIRISã§ã¯å€ãããŒãžã§ã³ã®ããŒã¿ãèŠãããšãã§ããªãã®ã§ãããã¯ã§å¯Ÿå¿ããããšã«ãªããŸãã
ãããã£ãŠãå ±æããã¯ã䜿çšããŠãæŽåæ§ãä¿ãããæç¹ã§ã®ã¿ããŒã¿ãèªã¿åãããšãã§ããããã«ããå¿ èŠããããŸãã
çžäºã«ééãè¡ããŠãŒã¶ãŒ ããŒã¹ ^人ããããšããŸãã
äººç© 123 ããäººç© 242 ãžã®è»¢éã®ç¬é:
LOCK +^person(123), +^person(242)
Set ^person(123, amount) = ^person(123, amount) - amount
Set ^person(242, amount) = ^person(242, amount) + amount
LOCK -^person(123), -^person(242)
åŒãèœãšãåã«å人 123 ããéé¡ãèŠæ±ããç¬éã«ã¯ãæä»çãããã¯ã䌎ãå¿ èŠããããŸã (ããã©ã«ã)ã
LOCK +^person(123)
Write ^person(123)
ãŸããå人ã¢ã«ãŠã³ãã®ã¢ã«ãŠã³ã ã¹ããŒã¿ã¹ã衚瀺ããå¿ èŠãããå Žåã¯ãå ±æããã¯ã䜿çšããããšãããŸã£ãã䜿çšããªãããšãã§ããŸãã
LOCK +^person(123)#âSâ
Write ^person(123)
ãã ããããŒã¿ããŒã¹æäœãã»ãŒç¬æã«å®è¡ããããšä»®å®ãããš (ã°ããŒãã«ã¯ãªã¬ãŒã·ã§ãã« ããŒãã«ãããã¯ããã«äœã¬ãã«ã®æ§é ã§ããããšãæãåºããŠãã ãã)ããã®ã¬ãã«ã®å¿ èŠæ§ã¯æžå°ããŸãã
å埩èªã¿åã - ãã®åé¢ã¬ãã«ã§ã¯ãåæãã©ã³ã¶ã¯ã·ã§ã³ã«ãã£ãŠå€æŽã§ããããŒã¿ã®è€æ°ã®èªã¿åããå¯èœã«ãªããŸãã
ãããã£ãŠãå€æŽããããŒã¿ã®èªã¿åãã«ã¯å ±æããã¯ãèšå®ããå€æŽããããŒã¿ã«ã¯æä»ããã¯ãèšå®ããå¿ èŠããããŸãã
幞ããªããšã«ãLOCK æŒç®åã䜿çšãããšãå€æ°ããå¯èœæ§ãããå¿ èŠãªããã¯ããã¹ãŠ XNUMX ã€ã®ã¹ããŒãã¡ã³ãã§è©³çŽ°ã«ãªã¹ãã§ããŸãã
LOCK +^person(123, amount)#âSâ
ÑÑеМОе ^person(123, amount)
ä»ã®æäœ (çŸæç¹ã§ã¯ã䞊åã¹ã¬ãã㯠^person(123, amount) ãå€æŽããããšããŸãããå€æŽã§ããŸãã)
LOCK +^person(123, amount)
ОзЌеМеМОе ^person(123, amount)
LOCK -^person(123, amount)
ÑÑеМОе ^person(123, amount)
LOCK -^person(123, amount)#âSâ
ããã¯ãã«ã³ãã§åºåã£ãŠãªã¹ããããšãããã¯ã¯é çªã«ååŸãããŸããããããè¡ããšæ¬¡ã®ããã«ãªããŸãã
LOCK +(^person(123),^person(242))
ãã®åŸããããã¯äžåºŠã«ååçã«ååŸãããŸãã
ã·ãªã¢ã©ã€ãº â æçµçã«å ±éããŒã¿ãæã€ãã¹ãŠã®ãã©ã³ã¶ã¯ã·ã§ã³ãé çªã«å®è¡ãããããã«ãããã¯ãèšå®ããå¿ èŠããããŸãã ãã®ã¢ãããŒãã§ã¯ãã»ãšãã©ã®ããã¯ã¯æä»çã§ãããããã©ãŒãã³ã¹ã®ããã«ã°ããŒãã«ã®æå°é åã§ååŸãããå¿ èŠããããŸãã
ã°ããŒãã« ^person ã§è³éã®åæ¹èšå ¥ã«ã€ããŠè©±ãå Žåããéã¯å³å¯ã«é çªã«äœ¿çšããå¿ èŠããããããSERIALIZE åé¢ã¬ãã«ã®ã¿ã蚱容ãããŸããããã§ãªãå Žåã¯ãåãéé¡ãè€æ°å䜿çšããå¯èœæ§ããããŸãã
4. èä¹ æ§
ã䜿çšããŠå®¹åšãããŒãã«ãããããã¹ããå®æœããŸãã
docker kill my-iris
åºå°ã¯åœŒãã«ããèããã åé¡ã¯ç¢ºèªãããŸããã§ããã
ãŸãšã
ã°ããŒãã«ã®å ŽåãInterSystems IRIS ã¯ãã©ã³ã¶ã¯ã·ã§ã³ããµããŒãããŸãã ãããã¯æ¬åœã«ã¢ãããã¯ã§ä¿¡é Œæ§ããããŸãã ã°ããŒãã«ã«åºã¥ãããŒã¿ããŒã¹ã®äžè²«æ§ã確ä¿ããã«ã¯ãå€éšããŒãªã©ã®è€éãªçµã¿èŸŒã¿æ§é ããªããããããã°ã©ãã®åªåãšãã©ã³ã¶ã¯ã·ã§ã³ã®äœ¿çšãå¿ èŠã§ãã
ããã¯ã䜿çšããªãã°ããŒãã«ã®åé¢ã¬ãã«ã¯ READ UNCOMMITED ã§ãããããã¯ã䜿çšããå Žå㯠SERIALIZE ã¬ãã«ãŸã§ç¢ºä¿ã§ããŸãã
ã°ããŒãã«ã§ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®æ£ç¢ºããšé床ã¯ãããã°ã©ããŒã®ã¹ãã«ã«å€§ããäŸåããŸããèªã¿åãæã«äœ¿çšãããå
±æããã¯ãåºããªãã»ã©ãåé¢ã¬ãã«ãé«ããªããããçãæä»ããã¯ãååŸãããã»ã©ãããã©ãŒãã³ã¹ãåäžããŸãã
åºæïŒ habr.com