åºç« : ETLãšã¯äœãïŒ
æ å ±ç®¡çãšåæãäžå¯æ¬ ãªçŸä»£ããžãã¹ã®äžçã«ãããŠãETLã¯ãã®éèŠãªåœ¹å²ãæãããŠããŸããããããETLãšã¯äœã§ããããïŒæ¬èšäºã§ã¯ããã®åºæ¬çãªæå³ãšæŽå²ãæãäžããŸãã
ETLã®å®çŸ©
ETLãšã¯ã”Extract, Transform, Load”ã®é æåãåã£ãèšèã§ãããããäžã€ã®ããã»ã¹ãéããŠãããŒã¿ã¯ç°ãªãããŒã¿ãœãŒã¹ããæœåºïŒExtractïŒãããå¿ èŠã«å¿ããŠå€æïŒTransformïŒããããããŠæçµçã«ããŒã¿ãŠã§ã¢ããŠã¹ãžãšããŒãïŒLoadïŒãããŸãã
æœåºãã§ãŒãºã§ã¯ãããŒã¿ã¯æ§ã ãªãœãŒã¹ããååŸãããŸãããããã®ãœãŒã¹ã¯ãããŒã¿ããŒã¹ããšã¯ã»ã«ãã¡ã€ã«ãCSVãã¡ã€ã«ãªã©æ§ã ãªåœ¢ããšãããšãã§ããŸãã次ã«ãå€æãã§ãŒãºã§ã¯ãååŸããããŒã¿ã¯ããžãã¹ã®èŠä»¶ã«å¿ããŠã¯ã¬ã³ãžã³ã°ãæšæºåãéçŽãªã©ã®æäœãè¡ããããŒã¿ãŠã§ã¢ããŠã¹ã«é©ãã圢åŒã«å€æãããŸããæåŸã«ãããŒããã§ãŒãºã§ã¯ãå€æãããããŒã¿ãããŒã¿ãŠã§ã¢ããŠã¹ã«æ ŒçŽãããŸãããã®äžé£ã®ããã»ã¹ã«ãããç°ãªããœãŒã¹ããã®ããŒã¿ãäžè²«æ§ãæã¡ãå¹ççã«åæã§ãã圢ã«æŽçãããŸãã
ETLã®æŽå²ãšãã®é²å
ETLã¯ãããŒã¿ãŠã§ã¢ããŠã¹ãäŒæ¥ã®ããžãã¹ã€ã³ããªãžã§ã³ã¹ã«å¿ èŠäžå¯æ¬ ãšãªã£ã1980幎代ããååšããŠããŸãããã®åæ段éã§ã¯ãETLããã»ã¹ã¯äž»ã«æäœæ¥ã§è¡ãããŠããŸãããããŒã¿ã¯æåã§æœåºãããå€æããžãã¯ã¯ã³ãŒãã£ã³ã°ãããããŒãããŸãæåã§è¡ãããŠããŸããããããããã®ã¢ãããŒãã¯æéããããããšã©ãŒãçºçãããããã¹ã±ãŒã«ã¢ãããå°é£ã§ããã
ãã®åŸã1990幎代ã«å ¥ããšãæåã®ETLããŒã«ãéçºãããããŒã¿æœåºãå€æãããŒãã®ããã»ã¹ãèªååãããŸãããããã«ãããETLããã»ã¹ã¯ããå¹ççãã€æ£ç¢ºã«ãªãã倧éã®ããŒã¿ãæ±ãããšãå¯èœã«ãªããŸãã
ãŸããèªååãããETLããŒã«ã®ç»å Žã«ãããããŒã¿ãŠã§ã¢ããŠã¹ãžã®ããŒã¿ã®ããŒãã¯ãããè¿ éã§å¹æçã«ãªããäŒæ¥ã¯èšå€§ãªéã®ããŒã¿ãåŠçããããžãã¹ã®æŽå¯ãåŸãããã«ãããå©çšããããšãã§ããŸããã
2000幎代ã«å ¥ããšãããã°ããŒã¿ãšã¯ã©ãŠãã³ã³ãã¥ãŒãã£ã³ã°ã®å°é ã«ãããETLããã»ã¹ãšããŒã«ã¯ããã«é²åããŸããã倧éã®éæ§é åããŒã¿ãæ±ãããã®æ°ããETLæè¡ãéçºãããã¯ã©ãŠãããŒã¹ã®ETLããŒã«ãç»å ŽããŸãããããã«ãããäŒæ¥ã¯å€§èŠæš¡ãªããŒã¿ã»ããããªã¢ã«ã¿ã€ã ã§åŠçããããžãã¹ã®ææ決å®ãããè¿ éãã€æ å ±ã«åºã¥ããŠè¡ãããšãå¯èœã«ãªããŸããã
çŸåšã§ã¯ãETLããã»ã¹ã¯AIïŒäººå·¥ç¥èœïŒãšMLïŒæ©æ¢°åŠç¿ïŒã®é²æ©ã«ããããããªãèªååãšæé©åãé²ãã§ããŸãããããã®æè¡ã¯ãããŒã¿ã®ã¯ã¬ã³ãžã³ã°ãå€æãªã©ã®ã¿ã¹ã¯ãèªååããããŒã¿ã®å質ãåäžãããäžæ¹ã§ãæéãšã³ã¹ããå€§å¹ ã«åæžããŸãã
ãŸãšãããšãETLã¯ããŒã¿é§åã®äžçã§éèŠãªåœ¹å²ãæãããŠããŸããããããŠãã®åœ¹å²ã¯ãæè¡ã®é²åãšãšãã«é²åãç¶ããŠããŸãã次ã®ã»ã¯ã·ã§ã³ã§ã¯ããã®ETLããã»ã¹ã®åã³ã³ããŒãã³ãã«ã€ããŠè©³ããèŠãŠãããŸãããã
第1éš: ETLã®ã³ã³ããŒãã³ã
ETLããã»ã¹ã¯äžã€ã®äž»èŠãªã¹ããããæœåºïŒExtractionïŒãå€æïŒTransformationïŒãããŒãïŒLoadïŒããæãç«ã£ãŠããŸããããããã®ã³ã³ããŒãã³ããããŒã¿ãŠã§ã¢ããŠã¹ã®æåã«ã©ã®ããã«å¯äžããŠãããã詳ããèŠãŠãããŸãããã
æœåºïŒExtractionïŒã®åœ¹å²ãšããã»ã¹
æœåºã¯ETLããã»ã¹ã®ç¬¬äžæ®µéã§ãããããã§ã¯ããŒã¿ããã®ãœãŒã¹ããåãåºãããŸããããŒã¿ã®ãœãŒã¹ã¯å€å²ã«ãããããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ããã©ãããã¡ã€ã«ããšã¯ã»ã«ãã¡ã€ã«ãä»ã®ããŒã¿ãŠã§ã¢ããŠã¹ãªã©ããããŸãã
æœåºããã»ã¹ã§ã¯ãå¿ èŠãªããŒã¿ãéžæããããœãŒã¹ã·ã¹ãã ããååŸãããŸãããã®æ®µéã§ã¯ã倧éã®ããŒã¿ããå¿ èŠãªæ å ±ãæ£ç¢ºã«æœåºããããšãéèŠã§ããæœåºã¯å šäœã®ETLããã»ã¹ã«ãããéèŠãªã¹ãããã§ãããæ£ç¢ºã§ãªããã°ãªããŸãããééã£ãããŒã¿ãæœåºããããšããã®åŸã®ããã»ã¹ã§åé¡ãçºçããå¯èœæ§ããããŸãã
å€æïŒTransformationïŒã®éèŠæ§ãšæ¹æ³
æœåºããããŒã¿ã¯ãå¿ ãããç®çã®åœ¢åŒãæ§é ã§ãããšã¯éããŸããããããã¯å€æãã§ãŒãºã§é©åãªåœ¢ã«å€ããããŸãããã®å€æããã»ã¹ã«ã¯ãã¯ã¬ã³ãžã³ã°ããã£ã«ã¿ãªã³ã°ããããã³ã°ãéçŽãªã©ãå€æ°ã®æé ãå«ãŸããŸãã
äŸãã°ãç°ãªãããŒã¿ãœãŒã¹ããååŸãããããŒã¿ã¯ãæ¥ä»ã®ãã©ãŒããããé貚ã®åœ¢åŒãªã©ãããŸããŸãªåœ¢åŒã§è¡šãããããšããããŸããå€æããã»ã¹ã§ã¯ããããã®ããŒã¿ãçµ±äžããã圢åŒã«å€æããŸããããã«ãã¯ã¬ã³ãžã³ã°ããã»ã¹ã§ã¯ãæ¬ æããŒã¿ã®è£å®ãéè€ããŒã¿ã®åé€ãªã©ãããŒã¿ã®å質ãæ¹åããæé ãè¡ãããŸãã
å€æã¯ETLã®äžæ žçãªéšåã§ãããããã§åœ¢æãããããŒã¿ã®å質ããã®åŸã®åæã®ç²ŸåºŠã«çŽçµããŸãã
ããŒãïŒLoadïŒã®æ®µéãšãã®è©³çŽ°
ããŒãã¯ETLããã»ã¹ã®æçµæ®µéã§ãããããã§ã¯å€æããããŒã¿ãããŒã¿ãŠã§ã¢ããŠã¹ã«åã蟌ãŸããŸããããŒãããã»ã¹ã¯éåžžãæ°ããªããŒã¿ãè¿œå ããããã®æ¿å ¥æäœãæ¢åã®ããŒã¿ãæŽæ°ããããã®æŽæ°æäœããããŠäžèŠãªããŒã¿ãåé€ããããã®åé€æäœãã®äžã€ã®æäœãå«ã¿ãŸãã
ããŒã¿ãŠã§ã¢ããŠã¹ã¯éåžžã倧éã®ããŒã¿ãä¿ç®¡ããé »ç¹ã«ããŒã¿ãæŽæ°ãããŸãããããã£ãŠãããŒãããã»ã¹ã¯å¹ççã§ãªããã°ãªããŸãããå€ãã®å Žåããã®ããã»ã¹ã¯äžæ¬åŠçãšããŠè¡ãããäžå®ã®æéééïŒäŸãã°æ¯å€ãæ¯é±ïŒã§å®è¡ãããŸãããããããªã¢ã«ã¿ã€ã ETLãååšãããã¡ãã¯ããŒã¿ãå©çšå¯èœã«ãªããã³ã«æœåºãå€æãããŒãã®ããã»ã¹ãè¡ãããŸãã
ããŒãããã»ã¹ã¯ãé©åãªããã©ãŒãã³ã¹ãšããŒã¿ã®æŽåæ§ã確ä¿ããããã«æ³šææ·±ãèšèšã»å®æœãããå¿ èŠããããŸããããŒã¿ã®éãå€ãå Žåãè€æ°ã®ãœãŒã¹ããããŒã¿ãååŸãããå Žåããã®ããã»ã¹ã¯ç¹ã«è€éã«ãªãããšããããŸãã
ãããã®äžã€ã®ã³ã³ããŒãã³ããé£æºããŠåäœããETLããã»ã¹å šäœãåæ»ã«é²è¡ããŸãããããããããŒã¿ãŠã§ã¢ããŠã¹æ§ç¯ã«ãããéèŠãªåœ¹å²ãæãããŠãããããŒã¿ã®å質ãšå©çšå¯èœæ§ã確ä¿ããŸãã
第2éš: ETLãšããŒã¿ãŠã§ã¢ããŠã¹
ETLããã»ã¹ãšããŒã¿ãŠã§ã¢ããŠã¹ã¯å¯æ¥ã«é¢é£ããŠããŸããããŒã¿ãŠã§ã¢ããŠã¹ã¯ETLã«ãã£ãŠåã蟌ãŸããããŒã¿ã®éç©å°ã§ãããETLã¯ããŒã¿ãŠã§ã¢ããŠã¹ãå¹æçã«æ©èœãããããã®éèŠãªå·¥çšã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãããŒã¿ãŠã§ã¢ããŠã¹ã®åœ¹å²ãšãETLãããã«ã©ã®ããã«å¯äžããŠããã®ãã«ã€ããŠè©³ãã解説ããŸãã
ããŒã¿ãŠã§ã¢ããŠã¹ãšã¯äœãïŒ
ããŒã¿ãŠã§ã¢ããŠã¹ã¯ãäŒæ¥å å€ã®ããŸããŸãªãœãŒã¹ããååŸãããããŒã¿ãäžç®æã§çµ±åãã管çããã·ã¹ãã ã®ããšãæããŸãããããã®ããŒã¿ã¯æ§é åãããåæãã¬ããŒãäœæãææ決å®ãæ¯æŽããããã«å©çšãããŸãã
ããŒã¿ãŠã§ã¢ããŠã¹ã¯ãæ å ±ãå¹ççã«æ ŒçŽããåãåºãããã®ç¬èªã®ã¹ããŒãã䜿çšããŠããŸãããŸããæéçãªå€åã远跡ããèœåãã倧éã®ããŒã¿ãå¹ççã«ã¯ãšãªããæ©èœãæã€ãªã©ãäžè¬çãªããŒã¿ããŒã¹ãšã¯ããã€ãã®éèŠãªç¹ã§ç°ãªããŸãã
ETLãããŒã¿ãŠã§ã¢ããŠã¹ã«äžãã圱é¿
ETLã¯ããŒã¿ãŠã§ã¢ããŠã¹ã®æ§ç¯ãšç®¡çã«ãšã£ãŠéèŠãªåœ¹å²ãæãããŠããŸããããã¯ããŒã¿ãŠã§ã¢ããŠã¹ã«åã蟌ãŸããããŒã¿ãæœåºãå€æãããŒãããããã»ã¹ã§ãããããŒã¿ãŠã§ã¢ããŠã¹ãæã€ããŒã¿ã®è³ªãšäžè²«æ§ã«çŽæ¥åœ±é¿ããŸãã
è¯å¥œãªETLããã»ã¹ã¯ãæ£ç¢ºã§ä¿¡é Œæ§ã®é«ãããŒã¿ãæäŸããããŒã¿ãŠã§ã¢ããŠã¹ãæçšãªæŽå¯ãæäŸããããã®åºç€ã圢æããŸããããã¯ããŒã¿ã®ã¯ã¬ã³ãžã³ã°ãšæšæºåãè¡ããç°ãªããœãŒã¹ããã®ããŒã¿ãçµ±åããããŒã¿ã®ççŸã解æ¶ããŸãããã®çµæãããŒã¿ãŠã§ã¢ããŠã¹ã¯ãå šç€Ÿçãªãã¥ãŒãæäŸããææ決å®è ãæ å ±ã«åºã¥ãã決å®ãäžãããã®ä¿¡é Œæ§ã®é«ãæ å ±æºãšãªããŸãã
ããŒã¿ãŠã§ã¢ããŠã¹ã®æ§ç¯ãšETL
ããŒã¿ãŠã§ã¢ããŠã¹ã®æ§ç¯ã¯ããã®æåãå·Šå³ããå€ãã®èŠçŽ ãå«ãã§ããŸããããã®äžã§ãETLããã»ã¹ã¯éåžžã«éèŠãªåœ¹å²ãæãããŸããETLããã»ã¹ãéããŠãç°ãªããœãŒã¹ããã®ããŒã¿ãçµ±äžããã圢åŒã«å€æãããäžè²«æ§ãšå®å šæ§ãä¿èšŒããããããããŒã¿ãŠã§ã¢ããŠã¹ã¯ãã®ç䟡ãçºæ®ããããšãã§ããŸãã
ETLããã»ã¹ã¯ããŒã¿ãŠã§ã¢ããŠã¹ã®æ§ç¯åæãã掻çšããããã®å¹çæ§ãšæçšæ§ã確ä¿ããŸããããã¯ããŒã¿ã®ãšã©ãŒãæ¬ èœãççŸãæ€åºããããããä¿®æ£ãŸãã¯æé€ããããšã§ããŒã¿ã®å質ãé«ããŸãããã®çµæãããŒã¿ãŠã§ã¢ããŠã¹ã¯åçš®ã®ããžãã¹åæãã¬ããŒãäœæãæŠç¥çææ決å®ãæ¯æŽããããã®æ£ç¢ºãªããŒã¿ãæäŸããããšãå¯èœãšãªããŸãã
ãŸããETLããã»ã¹ã¯ããŒã¿ãŠã§ã¢ããŠã¹ã®éçšäžãç¶è¡ãããŸããæ°ãã«è¿œå ãŸãã¯æŽæ°ãããããŒã¿ã¯ãETLããã»ã¹ãçµãŠããŒã¿ãŠã§ã¢ããŠã¹ã«åã蟌ãŸããããã«ããããŒã¿ãŠã§ã¢ããŠã¹ã¯åžžã«ææ°ã®æ å ±ãåæ ããç¶æ ãä¿ã€ããšãã§ããŸããã€ãŸããETLããã»ã¹ã¯ããŒã¿ãŠã§ã¢ããŠã¹ã®æ§ç¯ã ãã§ãªãããã®æç¶çãªéçšã«ãäžå¯æ¬ ãªèŠçŽ ãªã®ã§ãã
以äžããETLãšããŒã¿ãŠã§ã¢ããŠã¹ã®é¢ä¿æ§ã«ã€ããŠã®åºæ¬çãªèª¬æã§ãã次ã®ã»ã¯ã·ã§ã³ã§ã¯ãETLã®ããŒã«ãšãã®éžã³æ¹ã«ã€ããŠè©³ããèŠãŠãããŸãããã
第3éš: ETLã®ããŒã«ãšãã®éžã³æ¹
ETLããã»ã¹ã¯ããŒã¿ãŠã§ã¢ããŠã¹ã®æåã«ãšã£ãŠæ¬ ãããªãèŠçŽ ã§ããããã®ããã»ã¹ãå¹ççã«è¡ãããã«ã¯é©åãªããŒã«ã®éžå®ãéèŠãšãªããŸãããã®ã»ã¯ã·ã§ã³ã§ã¯ãETLããŒã«ã«ã€ããŠè§£èª¬ãããã®éžå®ã®ãã€ã³ãã瀺ãããŸããäž»èŠãªETLããŒã«ã«ã€ããŠæ¯èŒããããããã®ç¹æ§ã玹ä»ããŸãã
ETLããŒã«ã®æŠèŠãšãã®çš®é¡
ETLããŒã«ã¯ãETLããã»ã¹ãèªååãã管çããããã®ãœãããŠã§ã¢è£œåã®ããšãæããŸãããããã®ããŒã«ã¯ã倧éã®ããŒã¿ãå¹ççã«æœåºãå€æãããŒãããããã®å€æ§ãªæ©èœãæäŸããæåã§ã®ããã»ã¹ã«æ¯ã¹ãŠæéãšã³ã¹ãã®åæžãããŒã¿ã®å質åäžããšã©ãŒã®æžå°ãªã©ãå®çŸããŸãã
ETLããŒã«ã«ã¯ããŸããŸãªçš®é¡ããããäŸãã°ãåçšè£œåãšããŠã¯InformaticaãIBM DataStageãMicrosoft SSISãªã©ããããŸãããŸãããªãŒãã³ãœãŒã¹ã®ETLããŒã«ãšããŠã¯TalendãPentaho Data Integrationãªã©ãç¥ãããŠããŸããåããŒã«ã¯ããã®æ©èœãããã©ãŒãã³ã¹ãäŸ¡æ ŒããµããŒãäœå¶ãªã©ã®ç¹ã§ç°ãªãç¹æ§ãæã¡ãäŒæ¥ã®ããŒãºã«å¿ããŠéžå®ãããŸãã
ETLããŒã«éžå®ã®ãã€ã³ã
ETLããŒã«ãéžå®ããéã«ã¯ã以äžã®ãããªèŠçŽ ãèæ ®ããããšãéèŠã§ãããŸããããŒã«ã®æ©èœæ§ãè©äŸ¡ããèªç€Ÿã®ETLããã»ã¹ã«å¿ èŠãªæ©èœãç¶²çŸ ããŠãããã確èªããŸãããã®æ©èœã«ã¯ãããŒã¿ã®æœåºãå€æãããŒãã®èœåã®ã»ããããŒã¿ã®ã¯ã¬ã³ãžã³ã°ãå質管çããšã©ãŒãã³ããªã³ã°ãããã©ãŒãã³ã¹æé©åãªã©ãå«ãŸããŸãã
次ã«ãããŒã«ã®äœ¿çšæ§ãèæ ®ããŸããäŸãã°ãèŠèŠçãªã€ã³ã¿ãŒãã§ãŒã¹ããã©ãã°ã¢ã³ãããããæ©èœããã³ãã¬ãŒããªã©ãæäŸããŠããããŒã«ã¯ãETLããã»ã¹ã®èšèšãšç®¡çã容æã«ããŸãããŸããããŒã«ã®ã¹ã±ãŒã©ããªãã£ãéèŠãªãã€ã³ãã§ããããŒã¿éãå¢ããå Žåããæ°ããªããŒã¿ãœãŒã¹ãè¿œå ãããå Žåã«ããæè»ã«å¯Ÿå¿ã§ããããŒã«ãæ±ããããŸãã
ããã«ãããŒã«ã®ã³ã¹ããéžå®ã®éèŠãªèŠçŽ ã§ããã©ã€ã»ã³ã¹æãä¿å®è²»çšããã¬ãŒãã³ã°è²»çšãªã©ãèæ ®ããç·ææã³ã¹ãïŒTCOïŒãææ¡ããããšãå¿ èŠã§ãããŸãããªãŒãã³ãœãŒã¹ã®ããŒã«ã¯åæã³ã¹ããäœãåé¢ããµããŒãäœå¶ãåçšè£œåã«æ¯ã¹ãŠå£ãå Žåãããããã®ç¹ãè©äŸ¡ã«å«ããã¹ãã§ãã
æåŸã«ããã³ããŒã®ä¿¡é Œæ§ãšãµããŒãäœå¶ãéèŠããŸããä¿¡é Œæ§ã®ãããã³ããŒããæäŸãããååãªãµããŒãäœå¶ãæŽã£ãŠããããŒã«ãéžå®ããããšã§ããã©ãã«çºçæã®ãªã¹ã¯ã軜æžã§ããŸãã
äž»èŠãªETLããŒã«ã®æ¯èŒãšç¹æ§
ããŠãäž»èŠãªETLããŒã«ã«ã€ããŠæ¯èŒããããããã®ç¹æ§ãèŠãŠã¿ãŸããããããã§ã¯ãåçšã®InformaticaãšMicrosoft SSISããªãŒãã³ãœãŒã¹ã®TalendãšPentaho Data Integrationã®4ã€ãåãäžããŸãã
Informaticaã¯ããã®åŒ·åãªæ©èœæ§ãšã¹ã±ãŒã©ããªãã£ã§ç¥ãããŠããŸããåºç¯ã§è€éãªããŒã¿ãœãŒã¹ã«å¯Ÿå¿ãã倧éã®ããŒã¿ãé«éã«åŠçããèœåãæã¡ãŸãããŸããããŒã¿ã®å質管çãã¡ã¿ããŒã¿ç®¡çãããŒã¿ã¬ããã³ã¹ãªã©ã®é«åºŠãªæ©èœãæäŸããŠããŸãããã ãããã®ã³ã¹ãã¯é«ãã§ãç¹ã«å°èŠæš¡äŒæ¥ã«ãšã£ãŠã¯è² æ ãšãªãå¯èœæ§ããããŸãã
Microsoft SSISã¯ããã®èŠªåæ§ãšã³ã¹ãããã©ãŒãã³ã¹ã§è©äŸ¡ãããŸããèŠèŠçãªã€ã³ã¿ãŒãã§ãŒã¹ãšãã©ãã°ã¢ã³ãããããæ©èœãåãããŠãŒã¶ãŒãã¬ã³ããªãŒãªæäœæ§ãæäŸããŸãããŸããMicrosoft補åãšã®çµ±åæ§ãé«ããç¹ã«Microsoftç°å¢ãæã€äŒæ¥ã«ãšã£ãŠã¯é©ããŠããŸãããã ããä»ã®ããŒã¿ãœãŒã¹ãšã®é£æºæ§ãã¹ã±ãŒã©ããªãã£ã¯ãäžéšã®ä»ã®ããŒã«ã«æ¯ã¹ãŠå£ãå ŽåããããŸãã
Talendã¯ããªãŒãã³ãœãŒã¹ã®ETLããŒã«ãšããŠåºã䜿çšãããŠããŸãããã®å€§ããªç¹åŸŽã¯ãåæã³ã¹ããäœãããšãšãã³ãã¥ããã£ã«ããåºç¯ãªãµããŒããååšããããšã§ãããŸããJavaããŒã¹ã®ãã©ãããã©ãŒã ã§ãããããã«ã¹ã¿ãã€ãºã®èªç±åºŠãé«ãããŠãŒã¶ãŒã®ããŒãºã«åãããŠæ©èœãè¿œå ããããšãå¯èœã§ããããããåçšè£œåã«æ¯ã¹ãŠãµããŒãäœå¶ãå£ãç¹ããäžéšã®é«åºŠãªæ©èœãæäŸãããŠããªãç¹ã¯æ³šæãå¿ èŠã§ãã
æåŸã«ãPentaho Data IntegrationããªãŒãã³ãœãŒã¹ã®ETLããŒã«ãšããŠäººæ°ããããŸãããã®åªããããŒã¿çµ±åèœåãšåºç¯ãªããŒã¿æ¥ç¶æ§ãè©äŸ¡ãããŠããŸãããŸããèŠèŠçãªã€ã³ã¿ãŒãã§ãŒã¹ã«ããããŠãŒã¶ãŒãã¬ã³ããªãŒãªæäœæ§ãå®çŸããŠããŸãããã ãã倧èŠæš¡ãªããŒã¿ã»ãããè€éãªETLããã»ã¹ã«å¯Ÿå¿ããèœåã¯ãäžéšã®ä»ã®ããŒã«ã«æ¯ã¹ãŠå£ãå¯èœæ§ããããŸãã
以äžã®ããã«ãåETLããŒã«ã¯ããããç°ãªãç¹æ§ãæã£ãŠããŸããäŒæ¥ã¯èªç€Ÿã®ããŒãºãäºç®ãã¹ãã«ã»ãããããŒã¿ã®èŠæš¡ãšè€éããªã©ãèæ ®ã«å ¥ããŠãæé©ãªããŒã«ãéžå®ããããšãæ±ããããŸãã
第4éš: ETLã®å®è·µãšãã®éèŠæ§
æã ã®æ¥åžžç掻ãç¹ã«ããžãã¹ãã£ãŒã«ãã«ãããŠãETLã¯ãŸããŸãéèŠãªåœ¹å²ãæãããŠããŸãããã®ã»ã¯ã·ã§ã³ã§ã¯ãETLãå®éã«ã©ã®ããã«äœ¿çšãããããžãã¹ã«ã©ã®ãããªåœ±é¿ãäžãããã詳ããèŠãŠãããŸãããã
ETLã®å®éã®é©çšäŸ
ETLã¯ãããŸããŸãªç£æ¥ã§å€çš®å€æ§ãªçšéã«äœ¿çšãããŠããŸããäŸãã°ã補é æ¥ã§ã¯ãç°ãªãçç£ã©ã€ã³ããåŸãããããŒã¿ãéçŽããçç£å¹çãåæããããã«ETLã䜿çšãããŸãããŸããéèæ¥çã§ã¯ãè€æ°ã®ååŒã·ã¹ãã ããããŒã¿ãæœåºããäžå åãããªã¹ã¯åæãå®è¡ããããã«ETLãå¿ èŠãšãããŸãã
ãŸããETLã¯ãå ¬å ±ã»ã¯ã¿ãŒã§ã䜿çšãããŠããŸããäŸãã°ãå ¬å ±è¡çæ©é¢ã¯ãç°ãªãç é¢ã蚺çæããã®ããŒã¿ãäžå åããå ¬è¡è¡çã®ååã远跡ããããã«ETLã䜿çšããŸãããã®ããã«ãETLã¯å€ãã®åéã§å¹ åºã掻çšããããã®å©çšç¯å²ã¯ä»åŸããã«æ¡å€§ããŠããããšã§ãããã
ETLã®éèŠæ§ãšããžãã¹ãžã®åœ±é¿
ETLã¯ãäŒæ¥ãããŒã¿ãå¹æçã«ç®¡çãã掻çšããããã®äžå¯æ¬ ãªããŒã«ã§ããããã¯ããŒã¿ãããžãã¹ã®å段éã§éèŠãªåœ¹å²ãæãããææ決å®ããã»ã¹ã«ãããŠãäžå¿çãªèŠçŽ ãšãªã£ãŠããããã§ããETLããã»ã¹ãéããŠããŒã¿ãé©åã«æŽçãå€æãçµ±åãããããšã§ãäŒæ¥ã¯ãããã®ããŒã¿ããæå³ããæ å ±ãæœåºããããè¯ãããžãã¹æ±ºå®ãäžãããšãå¯èœã«ãªããŸãã
ããããETLã®å®æœã«ã¯äžå®ã®æè¡çãªèª²é¡ããããŸããããŒã¿ãœãŒã¹ã®å¢å ãããŒã¿ã®å質ãšäžè²«æ§ãåŠçæéãšããã©ãŒãã³ã¹ãªã©ãæ§ã ãªåé¡ãååšããŸãããããã£ãŠããããã®èª²é¡ãå æããETLããã»ã¹ãé©åã«èšèšã»ç®¡çããããšãããžãã¹ã®æåã«çŽçµããŸãã
ETLã®åé¡ç¹ãšè§£æ±ºç
ETLããã»ã¹ã¯å€ãã®å©ç¹ããããããŸãããäžæ¹ã§ããã€ãã®èª²é¡ããããŸããæãäžè¬çãªåé¡ã®äžã€ã¯ãããŒã¿ã®å質ã§ããå ã®ããŒã¿ãœãŒã¹ãäžå®å šãããã¯èª€ã£ãæ å ±ãå«ãã§ããå ŽåããããETLããã»ã¹å šäœã«åœ±é¿ãåãŒããŸãããã®åé¡ã解決ããããã«ã¯ãããŒã¿ã¯ã¬ã³ãžã³ã°ãããŒã¿æ€èšŒãšãã£ãæè¡ã䜿çšããŠãããŒã¿ã®å質ã確ä¿ããããšãéèŠã§ãã
ãŸããETLããã»ã¹ã®ããã©ãŒãã³ã¹ã倧ããªåé¡ã§ãã倧éã®ããŒã¿ãåŠçããå¿ èŠãããå Žåããã®ããã»ã¹ã¯æéããããããªãœãŒã¹ã倧éã«æ¶è²»ããå¯èœæ§ããããŸããããã«å¯Ÿããäžã€ã®è§£æ±ºçã¯ããã©ã¬ã«åŠçãã€ã³ã¯ãªã¡ã³ã¿ã«ããŒããšãã£ãæè¡ã䜿çšããŠãETLããã»ã¹ã®å¹çãæ¹åããããšã§ãã
æåŸã«ãETLã®è€éæ§ã倧ããªèª²é¡ã§ããç°ãªãããŒã¿ãœãŒã¹ããã®ããŒã¿ãçµ±åãããããå€æããæçµçã«ã¯äžã€ã®ããŒã¿ãŠã§ã¢ããŠã¹ã«ããŒããããšããããã»ã¹ã¯ãéåžžã«è€éã§ããšã©ãŒãçºçããããã§ãããã®åé¡ã解決ããããã«ã¯ãETLããŒã«ã®éžå®ãšãã®å¹æçãªäœ¿çšãéèŠã§ããé©åãªããŒã«ãçšããããšã§ãETLããã»ã¹ã®è€éãã管çãããšã©ãŒãæå°éã«æããããšãã§ããŸãã
çµè«
ãã®èšäºã§ã¯ãETLã®åºæ¬çãªæŠå¿µããããã®ã³ã³ããŒãã³ããããŒã¿ãŠã§ã¢ããŠã¹ãšã®é¢ä¿ãããŒã«ã®éžæããããŠå®éã®é©çšäŸãšåé¡ç¹ã«ã€ããŠãŸã§ãå¹ åºãæ·±ãæãäžããŠããŸãããããŒã¿ãããžãã¹ã®éèŠãªè³æºãšãªã£ãŠããçŸä»£ã«ãããŠãETLã®ç解ãšãã®é©çšã¯ãããžãã¹ã®æåã«ãšã£ãŠå¿ é ãšèšããã§ãããã
ETLã¯ãåçŽãªããŒã¿åŠçãè¶ ããŠãããŒã¿ããæçšãªæ å ±ãæœåºããããžãã¹ã®ææ決å®ã«æŽ»çšããããã®éèŠãªæ段ã§ãããã®éçšã¯è€éã§ãããåé¡ã䌎ããŸãããé©åãªããŒã«ãšææ³ã䜿çšããããšã§ããããã®åé¡ãå æããããŒã¿ã®çã®äŸ¡å€ãåŒãåºãããšãå¯èœã§ãã
ETLããã»ã¹ã¯ããŒã¿ãæ±ããã¹ãŠã®äººã ã«ãšã£ãŠéèŠãªã¹ãã«ã§ããããŸããããŒã¿ã掻çšããããšã®éèŠæ§ããŸããŸãèªèãããä»æ¥ããã®éèŠæ§ã¯ããã«é«ãŸã£ãŠããŸããETLã«ã€ããŠåŠã¶ããšã§ãããªãèªèº«ã®ãã£ãªã¢ãããžãã¹ã«å¯Ÿããç解ãæ·±ããããšãã§ããããå¹æçãªããŒã¿ç®¡çãšæŽ»çšãå¯èœã«ãªããŸãã
æã ãæ¥ã ç®ã®åœããã«ããæ å ±ã®æŽªæ°Žãã©ã®ããã«ç®¡çãã䟡å€ããç¥èã«å€ãããã¯ãä»åŸã®ããžãã¹ã®æåãå·Šå³ããéèŠãªèŠçŽ ã§ãããã®éçšã§ETLã¯ããã®å·šå€§ãªããŒã¿ã®æµ·ãåŠçããçµç¹å šäœã§æŽ»çšå¯èœãªæçšãªæ å ±ã«å€ããããã®éµãšãªããŸãããã®èšäºããETLã®ç解ãšãã®é©çšã«å¯Ÿããããªãã®æ ã«ãããæçšãªã¬ã€ããšãªãããšãé¡ã£ãŠããŸãã
çµè«: ETLã®æªæ¥
ææ°ã®ETLãã¬ã³ããšãã®åœ±é¿
ããŒã¿ã®åãæ±ããããžãã¹ã®äžéšãšããŠãŸããŸãäžè¬çã«ãªãã«ã€ããŠãETLã®ããã»ã¹ãšããŒã«ãé²åãç¶ããŠããŸããäŸãã°ãAIïŒäººå·¥ç¥èœïŒãMLïŒæ©æ¢°åŠç¿ïŒãETLããã»ã¹ã«çµã¿èŸŒãŸããããæŽç·ŽãããèªååãããããŒã¿æäœãå¯èœã«ãªã£ãŠããŸããããã«ããããã¥ãŒãã³ãšã©ãŒãæžãããããè¿ éãã€å¹ççãªããŒã¿åŠçãå®çŸããããšãå¯èœã«ãªããŸããã
ãŸãããªã¢ã«ã¿ã€ã ETLãå¢ããŠããŠããŸããããã¯ãããŒã¿ãçæããããšããã«ãã®ããŒã¿ãæœåºãå€æãããŒãããããã»ã¹ãæããŸããããã«ãããäŒæ¥ã¯ãªã¢ã«ã¿ã€ã ã§ããŒã¿ãå©çšããè¿ éãªææ決å®ãå¯èœã«ãªããŸãã
ETLã®æªæ¥äºæž¬ãšå¯èœæ§
ETLã®æªæ¥ã¯æãããšèšããŸããããŒã¿ãäŒæ¥æŠç¥ã®äžå¿ã«äœçœ®ããã«ã€ããŠããã®äŸ¡å€ãåŒãåºããç解ããããã®ããŒã«ãšããã»ã¹ã®éèŠã¯é«ãŸãäžæ¹ã§ããETLã¯ãã®ããŒã¿ãšã³ã·ã¹ãã ã®éèŠãªäžéšã§ããããã®éèŠæ§ã¯å¢ãã°ããã§ãã
å é²çãªæè¡ãäŸãã°AIãMLã®ãããªãã®ãçµã¿èŸŒãŸããããšã§ãETLããã»ã¹ã¯ãŸããŸãé«åºŠã«ãªãã粟床ãåäžããŸãããŸããã¯ã©ãŠãããŒã¹ã®ETLããŒã«ã®æ®åã«ãããããå€ãã®äŒæ¥ã倧éã®ããŒã¿ãå¹ççã«åŠçãããããæå³ã®ããæŽå¯ã«å€ããèœåãåŸãã§ãããã
ETLã¯ãããŒã¿é§ååã®äžçã§æã ãçŽé¢ããææŠã解決ããéµãšãªããŸãããã®é²åãšæ®åã¯ãæã ãæ å ±ãã©ã®ããã«ç解ãããããå©çšããããæ ¹æ¬çã«å€ããå¯èœæ§ãç§ããŠããŸãã
æåŸã«ãETLã®æªæ¥ã¯æç¶å¯èœãªããŒã¿ã¬ããã³ã¹ãšå¯æ¥ã«çµã³ã€ããŠããŸããããžãã¹ãçµç¹ãããŒã¿ãä¿ç®¡ããã¢ã¯ã»ã¹ããå ±æããæ¹æ³ã¯ããã®ããŒã¿ã®ä¿¡é Œæ§ãšæçšæ§ã«çŽæ¥åœ±é¿ãäžããŸããETLããã»ã¹ãé²åãç¶ããããšã§ãããŒã¿ã®å質ãå®å šæ§ãã¢ã¯ã»ã·ããªãã£ã®ç¢ºä¿ãå¯èœã«ãªããçµæçã«ã¯åŒ·åºãªããŒã¿ã¬ããã³ã¹ããµããŒãããŸãã
ãããå šãŠããETLãæã ã®ããžãã¹ãç§åŠãæè²ãæ¿æ²»ãªã©ãæ§ã ãªé åã§ã®ææ決å®ã«éèŠãªåœ¹å²ãæããçç±ã§ããããŒã¿ããæ°ããç³æ²¹ããšèšãããä»æ¥ããã®ç²Ÿè£œãšå©çšãå¯èœã«ããETLã®ååšãšéèŠæ§ã¯ãããããã®ç€ŸäŒã«ãããŠãŸããŸã倧ããªæå³ãæã€ã§ãããã
以äžããETLã«ã€ããŠã®äžé£ã®è§£èª¬ã§ããããããããªããETLã®äžçã«è¶³ãèžã¿å ¥ãã第äžæ©ãšãªãããšãé¡ã£ãŠããŸãã