6ã¯ãŒã¯ããŒã ããŒã¿ã¬ã€ã¯ç·š ã2ãã¯ã©ã¹ã¡ãœãã
DXã声é«ã«å«ã°ããæšä»ãããžã¿ã«åãããæ¥åã®çµæãçæãããããŒã¿ãããã«ããŠæŽ»çšããããäŒæ¥ã®åœéãåããããã«ãªã£ãŠãããããåæ°å¹Žãæ¯ãè¿ããšãçªåŠãšããŠéã圢åŒãå¢ããããŒã¿ã«ç¿»åŒãããããšãå°ãªããªãã£ããããã®éã«ããã°ããŒã¿ã峿¹ã«ã€ããããšå·¥å€«ããããããæè¡ã®äžã€ãããŒã¿ã¬ã€ã¯ã§ãããä»åã¯ãSnowflakeã®ãµãŒãã¹ããŒãããŒã§ãããåçš®å
端æè¡ããã°ã§ãæåãªã¯ã©ã¹ã¡ãœããæ ªåŒäŒç€Ÿã§ããŒã¿ã¢ããªãã£ã¯ã¹äºæ¥æ¬éš ããªã»ãŒã«ã¹ã¢ãŒããã¯ããšããŠæŽ»èºããŠãããå人ãšããŠããã®ãã¯ãããžãŒã®æŽå²ãã€ã¶ãã«èŠã€ããŠããç²æš æŽä»æ°ã«ãéå»ããçŽè§£ãããŒã¿ã¬ã€ã¯ãšãæªæ¥ãæ
ãSnowflakeã®åœ¹å²ãã玹ä»ããã ããã
解説è
ïŒã¯ã©ã¹ã¡ãœããæ ªåŒäŒç€Ÿ ããŒã¿ã¢ããªãã£ã¯ã¹äºæ¥æ¬éš ããªã»ãŒã«ã¹ã¢ãŒããã¯ã
ç²æš æŽä»æ°
TwitterïŒ@yokatsuki
ã¯ããã«
ããŒã¿åæã®äžçã«ãããŠãããŒã¿ã¬ã€ã¯ããšããæŠå¿µãç»å ŽããŠãã10幎çšã«ãªããŸããåŒç€Ÿã¯ã©ã¹ã¡ãœããã®ããŒã¿ã¢ããªãã£ã¯ã¹äºæ¥æ¬éšã¯ãäŒæ¥æ§ãæã€ããŒã¿åæã®ããã®ã¯ã©ãŠãåºç€äœããæ©æ¢°åŠç¿ã®æšé²ãªã©ãããžãã¹å éã®æ¯æŽã«åãçµãã§ããŸãã第5åç®ã®ä»åã¯ãããŒã¿åæåºç€ãæ§ç¯ããããªã»ãŒã«ã¹æŽ»åã®äžã§ãå人çèŠéã§æããããŒã¿ã¬ã€ã¯ã®ç»å Žãšé²åã®æŽå²çãªæµãããŸãšããããŒã¿ã¬ã€ã¯ã®æªæ¥ã®å§¿ãèããŸãã
ããŒã¿ã¬ã€ã¯ã®ã¯ããŸã
æ¢åããŒã¿ãŠã§ã¢ããŠã¹ã«å¯Ÿãã課é¡
ããŒã¿ã¬ã€ã¯ç»å Žãããåã1990幎代ã«ã¯ããŒã¿ãŠã§ã¢ããŠã¹ãšããæŠå¿µãæ¢ã«å®è£ ããã補åãšå ±ã«ååšããŠããŸãããæ¥ã çºçããæ¥åããŒã¿ã管çããŠããåºå¹¹ã·ã¹ãã ãããæ¥ååæã«å¿ èŠãªããŒã¿ãæœåºããåæã«é©ãã圢ã«å å·¥ã»éçŽãããããŒã¿ã®å šäœãããã³ãã®ããŒã¿ã管çããã·ã¹ãã ã®ããšãåœæãããããŒã¿ãŠã§ã¢ããŠã¹ïŒDWHïŒããšåŒãã§ããŸãã ããŒã¿ãŠã§ã¢ããŠã¹ïŒããã§ã¯åæçšããŒã¿å šäœã®æå³ïŒãããåºå®ã¬ããŒããããã·ã¥ããŒã衚瀺ã®ããã«ããããã¯åææäœãé«éåããç®çã§ãåæçšéããšã®éçŽã»éèšããŒã¿ãäœæããããšããããŸãããã®éçŽã»éèšããŒã¿ããããŒã¿ããŒãããããã¯ããã¥ãŒãããšåŒãã§ããŸãã ããããããŒã¿ãŠã§ã¢ããŠã¹ããããŒã¿ããŒããããã¥ãŒããçã®ããŒã¿ããåæã®ããã®ãœãããŠã§ã¢ãExcelã®åææ©èœã䜿ã£ãŠåæããããšã§ãçµå¶å€æã®ããã«å¿ èŠãªæ å ±ãåŸãããšããæµãã¯çŸåšãå€ãã®äŒæ¥ã«æ¡çšãããŠããŸãã
ãããããŒã¿ãŠã§ã¢ããŠã¹ã«ã¯ãããã€ãã®è§£æ±ºãã¹ã課é¡ããããŸããã
課é¡1ïŒå€§éã®ããŒã¿ãæ±ããªã
æ¢åã®ããŒã¿ãŠã§ã¢ããŠã¹ã¯ããµãŒããŒã«ãŒã ãããŒã¿ã»ã³ã¿ãŒã«é 眮ãããµãŒããã·ã³ããããããªã³ãã¬ç°å¢ã«æ§ç¯ããããšãæ®éã§ããããã®ããã¹ãã¬ãŒãžãµã€ãºå€æŽã«æè»æ§ããªãããéå»13ã«æã®ããŒã¿ã§åæããŠãããšããã3幎ã«ãããããŸãæ°èŠã«æ§ç¯ãããå¥ã·ã¹ãã ã§çºçããããŒã¿ãåæå¯Ÿè±¡ã«ãããããªã©ã®åæèšèšæä»¥éã«è¿œå ãããèŠä»¶ã«å¯Ÿå¿ããããšãã§ããŸããã§ããããã¡ãããæè¿æ±ãããããã«ãªã£ãŠããã»ã³ãµãŒããŒã¿çãéãèšå€§ã«ãªãã®ã§ãåŸæ¥ã®ããŒã¿ãŠã§ã¢ããŠã¹ã§ã¯åãæ±ããé£ãããã®ã§ããã åœæã®å¯Ÿå¿çãšããŠãåæå¯Ÿè±¡ã®ã·ã¹ãã ã管çå¯èœãªèŠæš¡ã«ã°ã«ãŒãåãããŠããããã«ããŒã¿ãŠã§ã¢ããŠã¹ãç«ãŠãçã®ææ®µãåãããã®ã§ãããããã¯ã·ã¹ãã ãããŒã¿ã®åæïŒãµã€ãåïŒãé¿ããããªãããšããããšãæå³ããŠããŸããã課é¡2ïŒåæå¯Ÿè±¡ã®ããŒã¿ãéå®ããã
ããŒã¿åæã®äžã€ã®çæ³çãªæµãã¯ã以äžã®ãµã€ã¯ã«ãã§ããã ãéãå€ãåãããšã§ããâ 仮説ãç«ãŠã
â æ€èšŒã®ããã®ããŒã¿ãéãã
â éããããŒã¿ã䜿ã£ãŠæ€èšŒãã
â æ€èšŒçµæããæ°ããªä»®èª¬ãç«ãŠã
ãããå®çŸããããã«ã¯ã仮説ãç«ãŠãŠããåæã«å¿ èŠãšãªãããŒã¿ãæãããŸã§ã®æéãã§ããã ãççž®ããå¿ èŠããããŸãããããæ¢åã®ããŒã¿ãŠã§ã¢ããŠã¹ã§æ°ããªããŒã¿ãæ ŒçŽããããã«ã¯ããããããããŒã¿ã®èšèšãå¿ èŠã§ããããã®ãããããŒã¿ãæ ŒçŽãããŸã§ã«æéãããããåæãµã€ã¯ã«ã®ã¹ããŒããäžããããšãã§ããŸããã§ããã
ãã®èª²é¡ã®è§£æ±ºã®ããã«ãå®ãã³ã¹ãã§æè»ã«å®¹é確ä¿ãå¯èœããã€ãäºåèšèšäžèŠã§ããã«ä¿åéå§ãå¯èœããªããŒã¿ã®èç©å Žæãå¿ èŠãšãªã£ãŠããŸããããã®å¿ èŠæ§ãæºããããŒã¿ã®èç©å Žæãå®çŸã§ããã°ã諞è¬ã®äºæ ã§ä»ãŸã§ã¯å»æ£ããŠãããããããããåæã«äœ¿ãããããããªããã¬ãã«ã®ããŒã¿ããããããèç©ã§ããããã«ãªãã®ã§ã¯ããšã®æåŸ ãçãŸããŸããã
ããŒã¿ã¬ã€ã¯ã®ç»å Ž
ãããŒã¿ã¬ã€ã¯ããšããèšèãç»å Žããã®ã¯2010幎é ã®ããã§ãã2010幎10æãããŒã¿çµ±åããŒã«çã®ãã³ããŒPentaho瀟ã®CTOã§ããJames Dixonæ°ããèªèº«ã®ããã°ã«ãããŠããŒã¿ããŒããšæ¯èŒãã圢ã§ããŒã¿ã¬ã€ã¯ã®æŠå¿µã«ã€ããŠèšåããŠããŸãã
åèïŒPentaho, Hadoop, and Data Lakes | James Dixonâs Blog
ãã®é ã®ããŒã¿ã¬ã€ã¯ã®å®çŸã€ã¡ãŒãžã¯ãçŸåšã®ããŒã¿ã¬ã€ã¯ã®ãããªãªããžã§ã¯ãã¹ãã¬ãŒãžã§ã¯ãªããåœæãããã°ããŒã¿ãããNoSQLããšããåèªãšå ±ã«æ³šç®ãããŠããããŒã¿åæ£åŠçæè¡âHadoopâã䜿ã£ãåºç€ã§æ§æãããšãããã®ã§ãããããŒã¿ãè€æ°ã®ãµãŒããã·ã³ã§åŠçããããšã§ã1å°ã§ã¯æ±ããããªãã£ãèšå€§ãªããŒã¿ãé«éã§åŠçã§ããããã«ãªããŸããããŸãJSONãªã©ã®åæ§é åããŒã¿ãæè»ã«æ±ãããšãã§ãããããããŒã¿ã¬ã€ã¯ã®åºç€ãšããŠæ³šç®ãããããã«ãªããŸããã
ãããããã®Hadoopåºç€ã䜿ã£ãããŒã¿ã¬ã€ã¯ã¯ãççºçãªæ®åãŸã§ã«ã¯è³ããŸããã§ããããªããªãã°ã2010幎代ã¯Google CloudãAmazon Web ServicesãMicrosoft Azureãªã©ã®ãããªãã¯ã¯ã©ãŠããµãŒãã¹ãåºãæ®åãå§ããææã§ããããã§æäŸãããããã«ãªã£ãGoogle Cloud Storage(GCS)ãAmazon Simple Storage Service(S3)ãAzure Blob Storageãªã©ã®ãªããžã§ã¯ãã¹ãã¬ãŒãžãµãŒãã¹ããããŒã¿ã¬ã€ã¯å®çŸã®ææ®µãšããŠåºãããèŠããã®ã§ãã ãããªãã¯ã¯ã©ãŠãã®ãªããžã§ã¯ãã¹ãã¬ãŒãžãµãŒãã¹ã¯ãå ã«è¿°ã¹ããå®ãã³ã¹ãã§æè»ã«å®¹é確ä¿ãå¯èœããã€ãäºåèšèšäžèŠã§ããã«ä¿åéå§ãå¯èœããªããŒã¿ã®èç©å ŽæããŸãã«å®çŸã§ãããã®ã§ããããŸããããªããžã§ã¯ããã¹ãã¬ãŒãžãµãŒãã¹ã¯ãæ§é åããŒã¿ãæ ŒçŽããCSVãã¡ã€ã«ãåæ§é åããŒã¿ãæ ŒçŽããJSONãXMLãã¡ã€ã«ã«å ããŠåç»ãé³å£°ãªã©ã®éæ§é åããŒã¿ãæ ŒçŽã§ããŸããããã§ããããªãã¯ã¯ã©ãŠãã®ãªããžã§ã¯ãã¹ãã¬ãŒãžãµãŒãã¹ã§ããŒã¿ã¬ã€ã¯ãäœãããšã«ããäœã§ãããŒã¿ã¬ã€ã¯ã«å ¥ããã°ãããŒã¿åæã®åé¡ã¯å šãŠè§£æ±ºããããšèããããããã«ãªããŸããã
ããããŠãAmazon S3ãªã©ã®ãããªãã¯ã¯ã©ãŠãã®ãªããžã§ã¯ãã¹ãã¬ãŒãžãµãŒãã¹ã«ããããããŒã¿ãæ ŒçŽã»èç©ããæ©éãçãŸããŸããã
â æ§é åããŒã¿ä»¥å€ã®åæ§é åããŒã¿ãéæ§é åããŒã¿
â 幎åäœã®é·æéã«ãããå±¥æŽããŒã¿
â å°æ¥åæã«äœ¿çšããå¯èœæ§ã®ããããŒã¿
â æªå å·¥ãæªéèšã®çããŒã¿
ããã仿¥ãç¶ãããŒã¿ã¬ã€ã¯æ®åã®ãã£ããã«ãªããŸãã
åæã®ããŒã¿ã¬ã€ã¯ã«å¯Ÿããåçãšãæ¹åã®åãçµã¿
ããŒã¿ã¬ã€ã¯ãã§ããããšã§ãããŸããŸãªã¡ãªãããåŸãããããã«ãªããŸããã
â åæå¯Ÿè±¡ã®ããŒã¿ã®è¿œå ã容æã«ãªã£ã
â éšé暪æçãªããŒã¿æŽ»çšãã§ããããã«ãªã£ã
â 幎åäœã¬ãã«ã®é·æéããŒã¿ãåæã§ããããã«ãªã£ã
â æ¥åã·ã¹ãã åŽã§é·æéã®ããŒã¿ãæ±ã蟌ãŸãªããŠæžãããã«ãªã£ã
â åæã®ç²åºŠãããŒã¿çºçå ã®çããŒã¿ãŸã§èŸ¿ããããã«ãªã£ã
ãããå®éã«ããŒã¿ã¬ã€ã¯ãéçšããŠã¿ããšãæ°ããªèª²é¡ãèŠããŠããŸãããæ°ãã«çºçãã代衚çãªèª²é¡ãïŒã€æããŠã¿ãŸãã
課é¡3ïŒ
çããŒã¿ãçæããããŸãŸã®åœ¢ã§æ ŒçŽããŠãããããæåããã³æ¹è¡ã³ãŒããæ¥æã®è¡šçŸåœ¢åŒãã·ã¹ãã ããšã«ãã©ãã©ããã®ããåæã«äœ¿çšããããã«éœåºŠåœ¢åŒãæããããã®ããŒã¿å å·¥ãå¿ èŠãšãããåæäœæ¥ã®é床ã»å¹çãäžãããªãã課é¡4ïŒ
åºå€§ãªã¹ãã¬ãŒãžã«ç¡èšç»ã«ããŒã¿ãæ ŒçŽãç¶ãããããã©ãã«äœãæ ŒçŽãããŠãããããããªããªã£ãŠããŸã£ãããŸããç»åãé³å£°ãªã©ã®éæ§é åããŒã¿ãæ ŒçŽããŠã¿ãã¯ãããã®ã®ãã©ã®ããã«åæã«æããã°è¯ãã®ãé©åãªæè¡ãé©çšã§ããã«ãããçµæãæŽ»çšãããªãããŒã¿ã倧éã«è²¯ãŸããæ¹ïŒããŒã¿ã¬ã€ã¯ïŒã§ã¯ãªã沌ïŒããŒã¿ã¹ã¯ã³ãïŒã«ãªã£ãŠããŸã£ãããã®ãããªç¶æ³ãåããŠããããã³ãŒãŒã¯2017幎ã«ãããŒã¿ã¬ã€ã¯ã«é£ã³èŸŒãããã®ããã¹ããŒããªæ¹æ³ããšããã¿ã€ãã«ã®è«æãçºè¡šããŠããŸãã
åèïŒA smarter way to jump into data lakes | McKinsey Digital
ãã®è«æã§ã¯ãããŒã¿ã¬ã€ã¯ã¯ããèªèº«ã§ç¬ç«ããŠäœ¿ããã®ã§ã¯ãªããããŒã¿åæåºç€ã®éèŠãªèŠçŽ ãšããŠæŽ»çšãããã®ã§ããããšã®äž»åŒµããªãããŠããŸããããããã®ã¹ããŒãžã®èª¬æè©³çްã«ã€ããŠã¯ãåæããåç §ãã ããã
çŸåšã®ããŒã¿ã¬ã€ã¯
ãã®ããã«ä»ãŸã§çºè¡šãããè«æããå®éã«ããŒã¿ã¬ã€ã¯ãæ§ç¯ããäŒæ¥ãçµéšããå®çžŸãå ã«ãããŒã¿ã¬ã€ã¯ã¯å°ããã€é²åããŠããŸãã2021幎ã®çŸåšã«ãããŠã¯ãããŒã¿ã¬ã€ã¯ã«ããã課é¡ïŒã解決ããããã«ãåç§°ã¯çµ±äžãããŠããªããã®ã®ãããŒã¿ã¬ã€ã¯ã«æ ŒçŽããããŒã¿ã段éçãªETLåŠçãæœããŠå éšçã«è€æ°ã®éå±€ã«åããŠæ§æããæ¹æ³ãæ€èšã»æ¡çšãããŠããŠããŸãã
第äžéå±€ïŒãã©ã³ãã£ã³ã°å±€ããã¹ããŒãžã³ã°å±€ããã€ã³ã¿ãŒãã§ãŒã¹å±€ããªã©ïŒ
â çããŒã¿ããã®ãŸãŸã®åœ¢ã§åãåããä¿åããŠããéå±€â é·æä¿åãšãæã现ããã¬ãã«ã§ã®ããŒã¿æ€èšŒç®çã§äœ¿çšãã
第äºéå±€ïŒãäžæ¬¡åŠçå±€ããäžéå±€ããã¢ãŒã«ã€ãå±€ããªã©ïŒ
â ããã«æ€çŽ¢ãå®è¡ã§ããã¬ãã«ã®æäœéã®å å·¥ãè¡ã£ãããŒã¿ãä¿åããéå±€ãã»äžæ£ããŒã¿ã空çœããŒã¿ã®é€å»
ãã»æåãæ¹è¡ã³ãŒãçµ±äž
ãã»ã¿ã€ã ã¹ã¿ã³ã圢åŒçµ±äž
ãã»ãã¡ã€ã«å§çž®åœ¢åŒçµ±äž
ãã»ãã©ã«ãæ§é æŽå-ããŒãã£ã·ã§ã³å
ãã»ããŒã¿ãã¹ãã³ã°
ãã»éæ§é åããŒã¿ã®ã¡ã¿ããŒã¿ïŒã¿ã°ïŒä»äž
â ããŒã¿ã®å 容ã詳ããç¥ãäººãæ¢çŽ¢çããŒã¿åæã®ç®çã§äœ¿çšãã
â æ©æ¢°åŠç¿ã®ããã®åŠç¿ããŒã¿ããã³æ€èšŒããŒã¿ãšããŠã䜿çšãã
第äžéå±€ïŒãæ§é åå±€ããåæå±€ããªã©ïŒ
â 人éãå 容ãããçè§£ããããæ§é ã«å å·¥ããããŒã¿ãä¿åããéå±€ãã»ã³ãŒãçªå·ã®å®ããŒã¿å€æïŒâ1âââç·æ§âãªã©ïŒ
ãã»èŠªåããŒãã«ã®çµå
ãã»æããã«äžèŠãªèŠçŽ ãã«ã©ã ã®åé€
ãã»è©³çްéããããŒã¿ã®éèšïŒã³ã³ãç§åäœâæéåäœãªã©ïŒ
â ããžãã¹å¯ãã®ããŒã¿åæè ããããŒã¿ãŠã§ã¢ããŠã¹ããã詳现ãªããŒã¿ã§åæãããå Žåã«äœ¿çšãã
â ããŒã¿ãŠã§ã¢ããŠã¹ã®ããŒã¿æ§é ãšè¿ãããªããããããŒã¿ãŠã§ã¢ããŠã¹ã®ãªãããŒãå ïŒæ®æ®µåæã«äœ¿ããªãããå Žåã«ãã£ãŠã¯å¿ èŠã«ãªãéå»ããŒã¿çœ®ãå ŽïŒãšããŠã®æå³åãããã
â éã«ããã®å±€ã®ããŒã¿ãå®å šã«ããŒã¿ãŠã§ã¢ããŠã¹ã«ããŒãããŠããŸãããã®å±€èªäœäœããªããšããèãæ¹ããã
â çšéã«ãã£ãŠã¯ãAPIãæäŸããŠãå€éšé¢é£ã·ã¹ãã ã«ããŒã¿ãæäŸããç®çã§äœ¿çšããå Žåããã
ãŸã課é¡ïŒã«ãããŠã¯ãããŒã¿ã¬ã€ã¯ã«èç©ãããããŒã¿ã«é¢ããã以äžã®ã¡ã¿æ å ±ãææ¡ããå¿ èŠããããŸãã
ãã»ãã©ã«ãããã¡ã€ã«ããã¡ã€ã«å ã®èŠçŽ ãã«ã©ã çã®ç©çå
ãã»èŠçŽ ãã«ã©ã ã®ããŒã¿å
â ããžãã¹èŠç¹ã®ã¡ã¿æ å ±
ãã»ãã©ã«ãããã¡ã€ã«ãèŠçŽ ãã«ã©ã ã®è«çå
ãã»ããŒã¿ã®èªã¿æ¹ãæ¥åäžã®çšé
ãã»ããŒã¿ã®åºèªïŒçºçå æ å ±ïŒ
ãã»ããŒã¿ã®ç³»çµ±ïŒçºçå ããã®ããŒã¿å å·¥å€é·ãããªããŒãžããšãåŒã°ããïŒ
â ã¬ããã³ã¹é¢é£æ å ±
ãã»ãã©ã«ãããã¡ã€ã«ãèŠçŽ ãã«ã©ã ããšã®ã¢ã¯ã»ã¹æš©
ãã®ã¡ã¿æ å ±ç®¡çãå®çŸããããã«ãããŒã¿ã«ã¿ãã°ããšåŒã°ããåçš®ç®¡çæ å ±ãä¿æããä»çµã¿ãå°å ¥ãããŸãããããŒã¿ã«ã¿ãã°æ©èœãæäŸãã補åã»ãµãŒãã¹ã¯ããŒã¿ã¬ã€ã¯ãšã¯ç°ãªããŸããåŸã£ãŠããŒã¿ã«ã¿ãã°ã¯ããŒã¿ã¬ã€ã¯æ§ç¯ãšã¯å¥ã«ãèŠä»¶ãäºç®èŠæš¡ã«å¿ããŠæ€èšã»å°å ¥ããå¿ èŠããããŸãã
ãããŸã§ã§ããŒã¿ã¬ã€ã¯ãã©ã®ããã«ç»å Žããé²åããŠããããèŠãŠããŸãããããããã¯ãæªæ¥ã®ããŒã¿ã¬ã€ã¯ã®å§¿ã«ã€ããŠèå¯ããŠãããŸãã
