ããŒã¿ãä¿åããïŒæ£ç¢ºã«èšé²ããïŒå¿ èŠæ§ãçããç¬éããã人ã ã¯ããããçš®é¡ã®ããŒã«ã䜿çšããŠããã®åŸã®äœ¿çšã«å¿ èŠãªæ å ±ãããŸããŸãªã¡ãã£ã¢ã«åã蟌ã¿ïŒãŸãã¯ä¿åïŒãŸããã äœå幎ãã®éã圌ã¯å²©ã«çµµãå»ã¿ããããçŸç®çŽã«æžãçããå°æ¥ã®äœ¿çšãç®çãšããŠããŸããïŒãã€ãœã³ã®ç®ã«ã ãåœãŠãããïŒã
éå» XNUMX 幎ã®éã«ãæåèšèªãã€ãŸããæžããã§æ
å ±ãèšé²ããããšãæ®åããŸããã äžæ¹ãæžã蟌ã¿ã«ã¯ãåŠå®ã§ããªãå©ç¹ (æ®åçãæ
å ±ã®èªã¿æžãã®æ¯èŒç容æããªã©) ããããŸãããããŒã¿ç®¡çã®èŠ³ç¹ããã¯ãååã«æŽ»çšããããšã¯ã§ããŸããã æžãããããŒã¿ã管çããããã«æãã€ãæè¯ã®ãã®ã¯ãã©ã€ãã©ãª (ã¢ãŒã«ã€ã) ã§ãã ãããããã®ã©ã€ãã©ãªã«ã¯ãç¹å¥ãªæ€çŽ¢ (ã€ã³ããã¯ã¹äœæ) ããã³ããŒã¿ç®¡çããŒã«ã§ããã«ãŒã ã€ã³ããã¯ã¹ãè¿œå ããå¿
èŠããããŸããã ã«ãŒã ã€ã³ããã¯ã¹ã¯æ¬è³ªçã«ã¯å³æžé€šã®ã«ã¿ãã° ã¬ãžã¹ããªã§ãã å³æžé€šïŒã¢ãŒã«ã€ãïŒãšããçšèªã¯ãç§ãã¡ãæ
£ã芪ããã§ããå³æžé€šã ãã§ãªããä»ã®çµç¹åããæ§é åãããææžããŒã¿ïŒäŸãã°ãç»èšæã®ãã¡ã€ã«ãå
åçãå·çšåå±ãªã©ïŒãå«ããŠç解ãããã¹ãã§ãããšèŠå®ããå¿
èŠããããŸãã ïŒã
ã«ãŒãæåºã·ã¹ãã ãæ¿åºã®ç»é²ã·ã¹ãã ã«ã©ãã»ã©ã®åœ±é¿ãäžããŠããããéå°è©äŸ¡ããããšã¯å°é£ã§ãã ããšãã°ãå±
äœå°äœæãåœæ°ã«é¢ããä¿åããŒã¿ã®ç©ççãªå Žæã§ãã人å£ç»é²æ©é¢ã§ãã ãããã£ãŠãç¹å®ã®éããå°åã«äœãäœæ°ã®ãã¹ãŠã®ããŒã¿ã¯ããã®å°åã«ãã£ãŠæå®ããã XNUMX ã€ã®ç»é²éšéã«ä¿ç®¡ãããŸãã ããã¯ããã®æ¹æ³ã䜿çšãããšãæ
å ±ã XNUMX ãæã«ä¿åããå Žåããããçµ±èšããŒã¿ãåæããŒã¿ãè¿
éã«æ€çŽ¢ãæŽæ°ãã«ãŠã³ããçæã§ããããã§ãã ããšãã°ãããªããæå±ããæ
åžå±ãçšå眲ã¯ãããªãã®æŽ»åã«é¢ããæžé¢ããã³ç©ççãªããŒã¿ (çšåå ±åæžãæ°äºèšé²) ãä¿ç®¡ããŸãã ãã¹ãŠã®å人ãŸãã¯æ¿åºæ©é¢ã¯ãç»é²äœæã«åºã¥ããŠãææžãã©ã®ç»èšæã«ä¿ç®¡ãããŠãããããŸãæåŸç³åãã©ã®çšå眲ã«æåºãããŠããããç°¡åã«å€æã§ããŸãã
ãã®ã«ãŒãäŒèšæ©èœã®åºç€ã«åºã¥ããŠãããŒã¿ç»é²ã·ã¹ãã å šäœãæ§ç¯ãããŸãããããŒã¿ç»é²ã·ã¹ãã ã¯ãåœæ°ã«é¢ãããã® (ç»èšæããã¹ããŒã管çå±)ãçµæžæŽ»åã«é¢ãããã® (å°æ¹ã®çšåãµãŒãã¹éšé)ãäžåç£ã«é¢ãããã® (å°æ¹ã®äžåç£ç»é²éšé)ãè»äž¡ã«é¢ãããã®ã§ã (ç»é²ã»è©ŠéšéšéïŒïŒãåŸŽå µå¶ïŒè»äºå§å¡ïŒã«ã€ããŠãªã©ã
ã«ãŒãäŒèšã§ã¯ãå°åæå®ä»ãã®å·ç»é²ããŒã¯ã®äœ¿çšïŒS227NA69-ããŽã§ãªå°åïŒãå°åã®ç¹æ§ã«å¿ããŠããŸããŸãªéšéã®ååãä»ããããšïŒãã«ããã€ã¹ããŒå°åºå åå±ïŒãããŒã¿ã®ç©ççãªç§»åãªã©ã匷å¶ãããŸãã
ç§ã¯ãã«ãŒã ãã¡ã€ãªã³ã° ã·ã¹ãã å ã®ããŒã¿åäœããããã«ãŒã ã€ã³ããã¯ã¹ããå¥ã®ã«ãŒã ã€ã³ããã¯ã¹ã«ç§»åããããšãæ€èšããããšãææ¡ããŸãã ããããããäŸãšããŠãåã®ææè ã®ç»é²å°ïŒç»é²å°ïŒãç°ãªãå人ã«è»ã販売ããå Žåã®ãèªåè»ç»é²ã·ã¹ãã ãžã®åç»é²ã®ããã»ã¹ãèããŠã¿ãŸãããã èŠå®ã«ããã°ã売䞻ãšè²·äž»ã¯ã売䞻ãæå±ããREOãAãã«æ¥ãŠãè»ã®åç»é²ãããªããã°ãªããŸããã 売買å¥çŽæžã«çœ²åããé¢é£æžé¡ã«èšå ¥ãããšãæ°ããææè ã¯äžå®æéæå¹ãªãã©ã³ãžããçªå·ãåãåããŸãã æ°ããææè ã¯ãééçªå·ã®æå¹æéå ã«ãç»é²ïŒç»é²ïŒã«ãã£ãŠèªåãæå±ãã REOãBãã«å°çãã矩åããããŸãã REOãBãã«å°çåŸã圌ã®éè¡çªå·ããã³ãã®ä»ã®ç»é²æžé¡ã¯æ²¡åãããè»ã¯æ°ããææè ã«ç»é²ãããŸãã
æ å ±åäœã®ç§»åãå®å šã«ç解ããããã«ã以äžã§ã¯ãç»é²ã¢ã¯ã·ã§ã³ã®å段éã§ã®ããŒã¿åäœã®ç§»åãé¡æšããŸãã
æäœ 1
売ãæãšè²·ãæãè»ã売買ããããã« REOãAãã«å°çãããªãã¬ãŒã¿ãŒã«é£çµ¡ããŸãã ãªãã¬ãŒã¿ãŒã¯ç»é²ã«ãŒã ãã¡ã€ã«å ã§ç»é²ã«ãŒããèŠã€ããŸããã€ãŸããããŒã¿ãç©ççã«æ€çŽ¢ããŸãããããã«ã¯æéãããããŸãã ã«ãŒããèŠã€ãããšãè»ã«é®æè ãå åç¹æš©ã®æç¡ããã§ãã¯ãããŸã (ããŒã¿ã¯è»ã®ç»é²ã«ãŒãã«èšé²ãããŸã)ã
æäœ 2
ãªãã¬ãŒã¿ãŒã¯ãå¿ èŠãªç»é²ã¢ã¯ã·ã§ã³ãå®è¡ããåŸãäžå®æéããã©ã³ãžããçªå·ãšç»é²æžé¡ãçºè¡ããŸãã æ°ããææè ã«é¢ããããŒã¿ã¯ REO "B" ã«ä¿åããå¿ èŠããããã (ããŒã¿ããŒã¹ã¯ã«ãŒãããŒã¹ã§ããŒã«ã«ã§ãããã)ãæ å ±ã REO "A" ãã REO "B" ã«è»¢éããããã«æ¬¡ã®ããã»ã¹ãéçºãããŸããã æ°ããææè ãšãã®è»ã«é¢ããããŒã¿ã¯åœŒãšäžç·ã«ç§»åããããã®ææè ã«ã¯ä¹ãç¶ãçªå·ãçºè¡ãããŸãã æ¹æ¶ç»é²ã«é¢ããç¹å¥ãªããŒã¯ãä»ããç»é²ã«ãŒãã¯ãè»äž¡å±¥æŽã®æ å ±ã®åäœãšã㊠REOãAãã«æ®ããŸãã ãã®å Žåã®ç»é²æ¹æ¶ã¯ãREOãAãããŒã¿ããŒã¹å ã§ãã®æ å ±åäœãéã¢ã¯ãã£ãã«ãªããäžèšã®ç©çããŒã¿æ€çŽ¢ã®ãªã¹ãã«å«ãŸããªããªãããšãæå³ããŸãïŒç»é²æ¹æ¶ãããè»ã®ç»é²ã«ãŒãã¯ãåã«ä»ã®è»ãšã¯å¥ã«ç§»åãããŸãïŒã¢ã¯ãã£ãããŒã©ãŒïŒã éä¿¡ãããæ å ±èªäœã¯ãééçªå·ããã³ç»é²æžé¡ã«è¡šç€ºãããŸãã
æäœ 3
REOãAãããã®è»ã®ç»é²æ¹æ¶ã®çµæãšããŠééçªå·ãåãåã£ãæ°ããææè ã¯ãREOãBãã«åããŠåºçºããŸãã çªå·ã¿ã€ãã®ååãtransitãèªäœããããŒã¿ã®ç§»åã«ãã®çªå·ãå¿ èŠã§ããããšã瀺ããŠããŸãã æ å ±ã¯ REOãAããã REOãBãã«è»¢éãããæ°ããææè ãããŒã¿ãã£ãªã¢ãšããŠæ©èœããŸãã æ å ±ã®ç§»è»¢ã確å®ã«å®äºããããã«ãäžå®ã®æå¹æéã®ãã©ã³ãžããçªå·ãçºè¡ããããã®æéå ã«æ°ããææè 㯠REOãBãã«ç»é²ããå¿ èŠããããŸãã ãã®ããã»ã¹ã®ç®¡çã¯é¢é£æ¿åºæ©é¢ã«å§ããããŠããŸãã äžèšã®ããšãããããŒã¿ç§»åããã»ã¹ã®å®è¡ãå¶åŸ¡ããããã«èšå€§ãªæ³çèŠç¯ãšäººçè³æºãé¢äžãã䜿çšãããããšãããããŸãã
æäœ 4
è»ã REO "B" ã«å°çãããšãç»é²ãããŸããããã¯ãè»ã«é¢ããããŒã¿ã REO "B" ã®ãã¡ã€ã« ãã£ããããã«èšé²ããããšãæå³ããŸãã ãªãã¬ãŒã¿ãŒã¯ãç»é²ã«ãŒããå°å·ããŠã«ãŒã ã€ã³ããã¯ã¹ã«å ¥åããªããã亀éæ©é¢çªå·ãåŒãåºããæ°ããå·çªå·ãçºè¡ããŸãã ãã®ç»é²ã«ãŒãã«ã¯ãREOãBããã転éããããã¹ãŠã®ããŒã¿ã衚瀺ãããŸãã
ããã§ãREOãAããã REOãBããžã®ãã¢ããã°ãããŒã¿è»¢éããã»ã¹ãå®äºããŸãã ééããªããæ å ±ã移åããããã®ãã®ã¢ã«ãŽãªãºã ã¯è€éã§ããã人çè³æºãšèº«äœæŽ»åã®äž¡æ¹ã«å€å€§ãªã³ã¹ããå¿ èŠãšããŸãã 転éãããèªåè»ããŒã¿ã®å®¹é㯠3 ãããã€ããè¶ ããŸããããæ¢åã®æè¡ã䜿çšã㊠1024 ãããã€ãã®æ å ±ã転éããåžå Žã³ã¹ã㯠3 ãœã ã§ã (æºåž¯é»è©±äºæ¥è ã®æ倧æéã«ãã)ã
DBMS-ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã䜿çšããæ代
ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã䜿çšãããšã倧èŠæš¡ãªç»é²ããã»ã¹ã«ãããããŒã¿å€æŽããã»ã¹ãå€§å¹ ã«ç°¡çŽ åã§ããŸãã ããŒã¿ã¯ãšãªãèªååããä¿èšŒãããçµæãæäŸããŸãã
æ確ãªäŸãšããŠãDBMS ã䜿çšãããå Žåã®äžèšã®è»ã®åç»é²ããã»ã¹ãšé¡äŒŒãããã®ãèããŠã¿ãŸãããã
æäœ 1
売ãæãšè²·ãæãè»ã売買ããããã« REOãAãã«å°çãããªãã¬ãŒã¿ãŒã«é£çµ¡ããŸãã ãªãã¬ãŒã¿ãŒã¯ç»é²ã«ãŒã ãã¡ã€ã«å ã§ç»é²ã«ãŒããèŠã€ããŸããã€ãŸããããŒã¿ãç©ççã«æ€çŽ¢ããŸãããããã«ã¯æéãããããŸãã ã«ãŒããèŠã€ãããšãè»ã«é®æè ãå åç¹æš©ã®æç¡ããã§ãã¯ãããŸã (ããŒã¿ã¯è»ã®ç»é²ã«ãŒãã«èšé²ãããŸã)ã ãªãã¬ãŒã¿ãŒã¯è»äž¡ããŒã¿ã DBMS ã«å ¥åãããšãé®æãŸãã¯å·®ãæŒããã®æç¡ã«é¢ããå³æå¿çãåãåããŸãã
æäœ 2
ãªãã¬ãŒã¿ãŒã¯ãå¿ èŠãªç»é²ã¢ã¯ã·ã§ã³ãå®è¡ããåŸãäžå®æéããã©ã³ãžããçªå·ãšç»é²æžé¡ãçºè¡ããŸãã æ°ããææè ã«é¢ããããŒã¿ã¯ REO "B" ã«ä¿åããå¿ èŠããããã (ããŒã¿ããŒã¹ã¯ã«ãŒãããŒã¹ã§ããŒã«ã«ã§ãããã)ãæ å ±ã REO "A" ãã REO "B" ã«è»¢éããããã«æ¬¡ã®ããã»ã¹ãéçºãããŸããã ãªãã¬ãŒã¿ãŒã¯ãæ°ããææè ã«é¢ããããŒã¿ã DBMS ã«å ¥åããŸãã
ããã§åç»é²æç¶ãã¯å®äºã§ãã ããŒã¿ããŒã¹ã¯éäžåãããŠãããããä»ã®ãã¹ãŠã®æäœã¯é¢ä¿ãããŸããã æ°ããææè ã¯ãä¹ãç¶ãçªå·ãååŸïŒæ¯æãïŒããå¿ èŠã¯ãããŸããã è»äž¡ç»é²ã®åã«äžŠã³ïŒã¹ããŒãžã³ã°ïŒãèšå ¥æžã¿ã®ç³è«æžã®æ¯æããªã©ãè¡ããŸãã åæã«ãè€éãªåç»é²å¶åºŠãäžèŠãšãªããããREOåŸæ¥å¡ã®è² æ ã軜æžãããŸãã
ãŸããå·ã®ãã³ããŒãã¬ãŒãã«å°åã®ç¹åŸŽã䜿çšããããšïŒå°åæå®ã¯å¿ èŠãªããããã©ã® REO ã«ãè»ãç»é²ã§ããããã«ãªãïŒãææè ã®äœæãç»é²æžé¡ã«èšé²ããããšãªã©ãå€ãã®å¶éãå¿ èŠãããŸãããå± äœå°ãå€æŽããå Žåã®åç»é²ãªã©ãèšå€§ãªãªã¹ãããããŸãã
è»äž¡ã«é¢ããæ å ±ã¯ããŒã¿ããŒã¹ããæäŸããããããç»é²æžé¡ãæ¹ãããããå¯èœæ§ã¯å®è³ªçã«æé€ãããŸãã
æ¿åºæ©é¢ã§ããŒã¿ãååŸããããã®æ¢åã®ããã»ã¹ã¯ãã«ãŒãã®ãã¡ã€ãªã³ã°ãšããŒã¿ ã¹ãã¬ãŒãžã®æ©èœã«åºã¥ããŠããŸãã
äžèšã«åºã¥ããŠãèªåæ å ±ã·ã¹ãã (AIS) ã䜿çšããäž»ãªå©ç¹ã¯æ¬¡ã®ãšããã§ãã
- AIS ã¯ç»é²ããã»ã¹ã®ã¢ãããŒããå€§å¹ ã«ç°¡çŽ åããæ ¹æ¬çã«å€æŽããŸãã
- ç»é²ããã»ã¹ã§ã¯ãDBMS èšèšã®ååãšã«ãŒã«ã䜿çšããå¿ èŠããããŸãã
- AIS ã®æ©èœãæ倧éã«æŽ»çšããã«ã¯ã確ç«ãããç»é²æé ãå€æŽããå¿ èŠããããŸãã
- ä»ã®ã·ã¹ãã (éè¡æ¥åãªã©) ãšçŽæ¥ã·ã¹ãã ãçµ±åããå¹ åºãå¯èœæ§ã
- 人çèŠå ã«é¢é£ãããšã©ãŒãæå°éã«æããŸãã
- åœæ°ãæ å ±ãåãåããŸã§ã«ãããæéãççž®ããŸãã
åºæïŒ habr.com