ããŒã¿ç§»è¡ããã³ã¢ããã€ãŒãŒã·ã§ã³ãµãŒãã¹ãããŒã¿ããŒã¹ããã©ãããã©ãŒã éã§ç§»è¡ããã¬ã¬ã·ãŒããŒã¿ã·ã¹ãã ãã¢ããã€ãºããããã»ã¹å šäœã§ããŒã¿æå€±ãŒããä¿èšŒããŸãã
å§ãã
ããŒã¿ç§»è¡ã¯ã倱æãããŒã¿æå€±ãããŠã³ã¿ã€ã ããŸãã¯ç Žæãæå³ãããªã¹ã¯ã®é«ãæäœã§ããåœç€Ÿã¯ãå æ¬çãªãã¹ãã䞊è¡å®è¡ã段éçãªã«ãããªãŒããŒãããã³ããããæ®µéã§ã®ããŒã«ããã¯èšç»ã«ãããå€ç§çãªç²ŸåºŠã§ç§»è¡ãèšç»ããã³å®è¡ããŸãã100GBãã10TBã®ããŒã¿ããŒã¹ãã1ã¬ã³ãŒãã倱ãããšãªãç§»è¡ããŠããŸããã
ã¯ã©ãŠãç§»è¡ã«ã¯AWS DMSãPostgreSQLç§»è¡ã«ã¯pgLoaderãè€éãªå€æã«ã¯ã«ã¹ã¿ã ETLã¹ã¯ãªãããã«ãããªãŒããŒäžã®ãªã¢ã«ã¿ã€ã ã¬ããªã±ãŒã·ã§ã³ã«ã¯CDCããŒã«ïŒDebezium, AWS DMSïŒã䜿çšããŸãããã¹ãŠã®ç§»è¡ã«ã¯ãèªååãããæ€èšŒã¹ã€ãŒããšããŒã«ããã¯æé ãå«ãŸããŠããŸãã
ããŒã¿ããŒã¹ãã©ãããã©ãŒã éã§ç§»è¡ããäŒæ¥ãã¯ã©ãŠããããŒãžãããŒã¿ããŒã¹ãžç§»è¡ããäŒæ¥ããŸãã¯ã¬ã¬ã·ãŒããŒã¿ã·ã¹ãã ãã¢ããã€ãºããäŒæ¥ãããŒã¿æå€±ãé·æçãªããŠã³ã¿ã€ã ã®ãªã¹ã¯ãªãããŒã¿ããŒã¹ã倿Žããå¿ èŠãããå Žåãåœç€Ÿã®äœç³»çãªã¢ãããŒãã«ãããå®å šã§æ€èšŒãããç§»è¡ãä¿èšŒãããŸãã
ãœãŒã¹ããŒã¿ã®ã€ã³ãã³ããªäœæãã¹ããŒãå·®ç°ã®ãããã³ã°ã倿ããŒãºã®ç¹å®ãç§»è¡ãã§ãŒãºã®èšç»ã
ã¹ããŒãã®å€æãããŒã¿åã®é©åãã¹ãã¢ãããã·ãŒãžã£ã®å€æãäºææ§ã®æ€èšŒã
åæããŒã¿ããŒãã®å®è¡ãç¶ç¶çãªã¬ããªã±ãŒã·ã§ã³ã®ããã®CDCã®ã»ããã¢ãããããŒã¿æŽåæ§ã®æ€èšŒã
äž¡ã·ã¹ãã ã䞊è¡ããŠçšŒåãããçµæãæ¯èŒããã¢ããªã±ãŒã·ã§ã³ã®åäœãæ€èšŒããäžäžèŽã解決ããŸãã
æçµã«ãããªãŒããŒã®å®è¡ãå šããŒã¿ã®æ€èšŒãã¢ããªã±ãŒã·ã§ã³ã®ãªãã€ã¬ã¯ãããœãŒã¹ã®å®å šãªå»æ¢ã
ããããæ®µéã§ã客æ§ã®ããŒã¿ãä¿è·ãããå®å šã§æ€èšŒæžã¿ã®ããŒã¿ããŒã¹ç§»è¡ãèšç»ããŸãããã
ãŒãããŠã³ã¿ã€ã ã§ããŒã¿ããŒã¹ãç§»è¡ããããã«ããã¥ã¢ã«ã©ã€ããã¿ãŒã³ãDebeziumã䜿çšãããã§ã³ãžããŒã¿ãã£ããã£ãããã³ã·ã£ããŠãã©ã³ã¶ãã£ãã¯æ€èšŒã䜿çšããŠããŸããããŒã¿ã¯ã«ãããªãŒããŒãŸã§ç¶ç¶çã«åæãããåã¹ããŒãžã§ããŒã«ããã¯èšç»ãæäŸããŸãã
MicrocosmWorksã®ããŒã¿ç§»è¡ãããžã§ã¯ãã¯ã1æéããã$20ïœ$45ã§è«æ±ãããŸããå šäœè²»çšã¯ãããŒã¿éãç§»è¡å ã·ã¹ãã ã®æ°ãã¹ããŒãã®è€éããããã³ç§»è¡äžã«ãªã¢ã«ã¿ã€ã åæãå¿ èŠãã©ããã«äŸåããŸãã
ã¯ããåŒç€Ÿã¯ãªã³ãã¬ãã¹ããŒã¿ããŒã¹ãAWS RDSãAzure SQLãGoogle Cloud SQLããã®ä»ã®ãããŒãžããµãŒãã¹ãžç§»è¡ããããšãå°éãšããŠãããã¹ããŒãã®é©å¿ãã¯ã©ãŠãç°å¢ã§ã®ããã©ãŒãã³ã¹ãã¥ãŒãã³ã°ãããã³ããã»ã¹å šäœã§ã®ããŒã¿æ€èšŒã«å¯Ÿå¿ããŠããŸãã
ç§»è¡ããããã¹ãŠã®ããŒãã«ã«å¯ŸããŠãèªååãããè¡æ°æ¯èŒããã§ãã¯ãµã æ€èšŒãåç §æŽåæ§ãã§ãã¯ãããã³ã¢ããªã±ãŒã·ã§ã³ã¬ãã«ã®ã¹ã¢ãŒã¯ãã¹ããå®è¡ããŸãããŸãããœãŒã¹ã·ã¹ãã ãšã¿ãŒã²ããã·ã¹ãã éã§çµæãäžèŽããããšã確èªããããã«ã䞊è¡ã¯ãšãªæ€èšŒã宿œããŸãã
ã¯ããåœç€Ÿã¯COBOLããŒã¹ã®ã¢ããªã±ãŒã·ã§ã³ãIMSã®ãããªéå±€åããŒã¿ããŒã¹ãå«ãã¬ã¬ã·ãŒ mainframe ã·ã¹ãã ããã®ããŒã¿ç§»è¡çµéšããããflat files ã VSAM datasets ãææ°ã® relational ãŸã㯠NoSQL ããŒã¿ããŒã¹ã«å€æããŸãã