ãããã¯ãŒã¯ã«ã¯ãæ°åŠçµ±èšã¢ã«ãŽãªãºã ã®äœ¿çšæ¹æ³ããã¥ãŒã©ã«ãããã¯ãŒã¯ãããã³äžè¬çãªæ©æ¢°åŠç¿ã®å©ç¹ã«é¢ããããŸããŸãªèšäºãå€æ°ãããŸãã ãããã®åéã¯ã人éã®ç掻ã®å€§å¹
ãªæ¹åãšããããã®æããæªæ¥ã«è²¢ç®ããŠããŸãã ããšãã°ã人éã®ä»å
¥ãèªåæ瞊è£
眮ãªãã§å®å
šãŸãã¯éšåçã«æ©èœã§ããæ°äžä»£ã®ãã©ã³ãã
éçºè
ã¯ããããã®ã¢ãããŒããšæ©æ¢°åŠç¿æ¹æ³ã®çµã¿åãããããŸããŸãªæ¹åã«çµã¿åãããŸãã ãããã®ãšãªã¢ã«ã¯ããã®åŸããªãªãžãã«ã§ã¯ãªãéåžžã«ååãä»ããããŸããããšãã°ãIOTïŒã¢ãã®ã€ã³ã¿ãŒãããïŒãWOTïŒã¢ãã®ãŠã§ãïŒãã€ã³ãã¹ããªãŒ4.0ïŒã€ã³ãã¹ããªãŒ4.0ïŒã人工ç¥èœïŒAIïŒãªã©ã§ãã ãããã®æŠå¿µã¯ããã®èª¬æããããã¬ãã«ã§ãããšããäºå®ãã€ãŸããç¹å®ã®ããŒã«ããã¯ãããžãŒãèæ
®ãããŠããããã·ã¹ãã ãå®è£
ããæºåãã§ããŠããªããšããäºå®ã«ãã£ãŠçµã°ããŠããŸããäž»ãªç®æšã¯ãç®çã®çµæãèŠèŠåããããšã§ãã ãããããã¯ãããžãŒã¯ãã§ã«ååšããŸãããå€ãã®å Žåãåäžã®ãã©ãããã©ãŒã ã¯ãããŸããã
ãã®ãœãªã¥ãŒã·ã§ã³ã¯ãSASãSAPãOracleãIBMãªã©ã®å€§æãœãããŠã§ã¢ãã³ããŒãšã倧äŒæ¥ãšã®ç«¶äºãæ¿ããå°èŠæš¡ãªæ°èäŒæ¥ãããã³ãªãŒãã³ãœãŒã¹ãœãªã¥ãŒã·ã§ã³ïŒãªãŒãã³ãœãŒã¹ãœãªã¥ãŒã·ã§ã³ïŒã®äž¡æ¹ã«ãã£ãŠæäŸãããŸãã ãã®å€æ§æ§ã¯ãã¹ãŠãã¿ã¹ã¯ã®è¿
éãã€å¹æçãªå®è£
ã倧å¹
ã«è€éåããŸããããã¯ãããŸããŸãªã·ã¹ãã å士ã®é¢åãªçµ±åãæ©æ¢°åŠç¿ã®åªããã¢ãã«ãäœæããéçºè
ã®å€å€§ãªåªåãããã³ãããã®ãœãªã¥ãŒã·ã§ã³ã®çç£çãªæ¹æ³ã§ã®å°æ¥ã®å®è£
ãå¿
èŠãšããããã§ã ãããåæã«ãããžãã¹ãè¡ãããã®äŒç€Ÿã®ã¢ãããŒããå€ããã€ãããŒã·ã§ã³ãããžã§ã¯ãã®æåã®äž»ãªåºæºã¯ããã°ãã°æåãšãœã«ãã³ã·ãŒã®è¿
éãªèšŒæãå¿
èŠãšããŸãããããªããã°ã誰ããããç«ã¡äžããããšãæ¢ããŠããŸããã ãããŠãããã¯åäžã®ãã©ãããã©ãŒã ã䜿çšããªããšäžå¯èœã§ãããããŒã¿ã®æºåïŒæ€çŽ¢ãåéãã¯ãªãŒãã³ã°ãçµ±åïŒã®å
šãµã€ã¯ã«ãè¿
éã«å®äºããé«å質ã®åæïŒæ©æ¢°åŠç¿ã¢ã«ãŽãªãºã ã®äœ¿çšãå«ãïŒã®åœ¢ã§æçµçµæãååŸããçµæãšããŠå©çãåŸãããšãã§ããŸãäŒç€Ÿã®ããã«ã
SASã«ã€ããŠ
SASã¯ãé«åºŠãªåæãœãªã¥ãŒã·ã§ã³ã®åžå Žã§é«ãå°äœã«ããããšã«å€ãã®äººãåæãããããããŸãã ã SASãœãªã¥ãŒã·ã§ã³ã®ã¬ãã¥ãŒã¯ç°ãªãå ŽåããããŸãããç¡é¢å¿ãªäººã¯ããŸãããããã¯ããã·ã¢ããã³äžçã®å€æ°ã®é¡§å®¢ã®ååšã«ãã£ãŠç¢ºèªãããŠããŸãã 瀟å
ã§ç°¡åãã€è¿
éã«å®è£
ããããã«çµæãåŸãããšãã§ããæ¢è£œã®ã¢ã«ãŽãªãºã ãšã¢ãã«ã®ãããã§ãã ããã«ã€ããŠã¯ãSASã®ããã°ã®æåã®èšäºã§å€ãã®ããšãæžãããŠããŸã ã ããã§èªãããšãã§ããŸã ã ãã®èšäºã§ã¯ãSASã®æåã®èæ¯ãšãã®æŽå²ã«ã€ããŠèª¬æããŸãã ããããITãšããžãã¹ã³ãã¥ããã£ã¯æ¥éã«çºå±ããŠãããããŒã«ã«å¯ŸããèŠæ±ãå³ãããªã£ãŠãããããSASã¯æ°ããåæãã©ãããã©ãŒã ã§ããSAS ViyaããªãªãŒã¹ããŸããã ãã®ãã©ãããã©ãŒã ã«ã¯ãé«åºŠãªåæã®ããã®ãœãªã¥ãŒã·ã§ã³ã®ã¯ã©ã¹ã®çŸåšã®åŸåãå€æããããã«ãSASãçŸåšã«è³ããŸã§ã«SASã«ãã£ãŠäœæããããã¹ãŠã®ãã¹ããå«ãŸããŠããŸãã çŸããååãšå®çŸ©ã«æ»ããšãSAS Viyaã¯ãåæ£ïŒã¯ã©ãŠãïŒã³ã³ãã¥ãŒãã£ã³ã°ãšãã€ã¯ããµãŒãã¹ã¢ãŒããã¯ãã£ã®ã¢ãããŒãã䜿çšããŠéçºããããã€ã³ã¡ã¢ãªæ©èœã䜿çšããã»ã«ããµãŒãã¹ããŒã¿ãµã€ãšã³ã¹ãªã©ã®æ¹åæ§ã®ããã®çµ±åãã©ãããã©ãŒã ãæäŸããŸãã ãã®ããããã®èšäºã§ã¯SAS Viyaãã©ãããã©ãŒã ã«é¢ããäžé£ã®èšäºãéããViyaãäœã§ããããäœãã§ãããããããŠã©ã®ããã«äœ¿çšããããæŽçããŸãã
é£ããéžæ
åžå Žã«ã¯ãæåãªãã³ããŒãå°èŠæš¡ãªãã¬ãŒã€ãŒã®è£œåãéåžžã«å€ããããããžãã¹ã®ããããåéã§ããŸããŸãªåæäžã®åé¡ã解決ã§ãããªãŒãã³ãœãŒã¹ãããããšããã§ã«ããã£ãŠããŸãã ç¹å®ã®ãã©ãããã©ãŒã ã®éžæã決å®ããéã«ãäŸ¡æ Œã«å ããŠã©ã®ãããªåºæºãèæ
®ããå¿
èŠããããŸããïŒ
ãããããããžãã¹ãŠãŒã¶ãŒã¯åæãµã€ã¯ã«å
šäœã«ãŸããŸãé¢äžããããã«ãªããITããã®ãã倧ããªç¬ç«æ§ãå¿
èŠã«ãªã£ãŠããŸãã ãããã®ãŠãŒã¶ãŒãç解ã§ããåºæº-䜿ããããïŒåäžã®ã€ã³ã¿ãŒãã§ã€ã¹ïŒãæ°ããã·ã¹ãã ã®åŠç¿ã®æå°åïŒã³ãŒããå°ãªããã°ã©ãã£ãã¯ã¹ãå€ãïŒãããã©ãŒãã³ã¹ïŒåæã®èŠ³ç¹-ããã¯å€§èŠæš¡ãªããŒã¿ã»ããã§è¿
éã«çµæãååŸã§ããæ©èœïŒãæ¢æã®ã¢ã«ãŽãªãºã ãšã¢ãã«ã®å¯çšæ§ä»äºã®ããã é»ãç»é¢ã®æéããªããªãã端æ«ãŠã£ã³ããŠã¯å¥ã®åœ¢åŒã§ããããŸã å©çšå¯èœã§ãããå€åºå
ã§ã³ãŒããèšè¿°ããŠãããã°ããããšãã§ããŸãããã»ãšãã©ã®æ©èœã¯ã°ã©ãã£ã«ã«ã€ã³ã¿ãŒãã§ã€ã¹ã®ãããã¯ãšããŠæ¢ã«å®è£
ã§ãããã¹ãŠã®ãŠãŒã¶ãŒã«éæžãéããŸãé«åºŠãªåæã䜿çšããããã®ã¬ãã«ïŒæ°åŠãç解ããããšã¯äŸç¶ãšããŠæãŸããã§ããïŒã
å¿
ç¶çã«åžå ŽãåŸæãã2çªç®ã®åŸåã¯ãã¯ã©ãŠããã¯ãããžãŒã§ãã äŒæ¥ã®èŠ³ç¹ããèŠããšãããã¯ãããããããžã§ã¯ãã§å©çšå¯èœãªãªãœãŒã¹ãæè»ã«ç®¡çããæ©äŒã§ãã ã¯ã©ãŠããã¯ãããžãŒãåŸæ¥ã®ãœãªã¥ãŒã·ã§ã³ã«å®å
šã«åã£ãŠä»£ãã£ãææã«ã€ããŠã¯ãå€ãã®ç 究ããããŸãã ãã ããããã§éèŠãªã®ã¯ãã¯ã©ãŠãã³ã³ãã¥ãŒãã£ã³ã°ã¯å€éšããŒã¿ã»ã³ã¿ãŒã®ã©ããé ãã«ããããŒããŠã§ã¢ã§ããã ãã§ãªããè€éãªITã€ã³ãã©ã¹ãã©ã¯ãã£ãæ§ç¯ãŸãã¯åæ§ç¯ããå¿
èŠãªããè¿
éã«ååŸã§ãããµãŒãã¹ã®åœ¢ã§ããããçš®é¡ã®ãµãŒãã¹ãæè»ã«æäŸãããšããã¢ãããŒãã§ãããããšãç解ããããšã§ãã
ãã1ã€ã®åŸåã¯ãããã°ããŒã¿ãã¯ãããžãŒã®äœ¿çšã§ãã ãŸããç¬èªã®èšèªãšãã¯ãããžãŒãåããHadoopãšã³ã·ã¹ãã å
šäœã®äœ¿çšãããã³RãPythonãªã©ã®ããŒã¿ãæäœããããã®ã€ã³ã¿ãŒãã§ã€ã¹ãæäŸããä»ã®å©çšå¯èœãªãªãŒãã³ãœãŒã¹ã·ã¹ãã ã ãã®åéã§ç«¶äºããæå³ã¯ãããŸãããããã®ãšã³ã·ã¹ãã ãšçµ±åããããã®æè¡ãããããšã¯çã«ããªã£ãŠããŸãã ãŸãã¯ãåã«çµ±åããã ãã§ãªããSAS Hadoop Embedded Processã®å Žåã®ããã«ãã®ãšã³ã·ã¹ãã ã®æ©èœã䜿çšããããKafkaã䜿çšããŠESPïŒSAS Event Stream ProcessingïŒã·ã¹ãã ã®é«å¯çšæ§ãæ§ç¯ããŸãã ãŸããSAS Viyaã®CASãšã³ãžã³ã§Rã³ãŒããå®è¡ããæ©èœãªã©ãæ¹åããã³é«éåããããšããããŸãã
ãŠãããŒãµã«ãã©ãããã©ãŒã
éèŠã¯äŸçµŠãçã¿åºããSAS Viyaããã®ã«ãŒã«ã®äŸå€ã§ã¯ãããŸããã 2016幎ã®ã°ããŒãã«SASãã©ãŒã©ã ã§ã®çºè¡šã®éã«Jim Goodnightã«ãã£ãŠäžããããSAS Viyaã®å
¬åŒå®çŸ©ãåç
§ãããšïŒéåžžã«çž®å°ãããŸãããæå³ã¯ä¿æãããŸãïŒãSAS Viyaã¯æ¬¡ã®ããã«ãªããŸãïŒã åæ£ã³ã³ãã¥ãŒãã£ã³ã°ã¢ãããŒãã䜿çšããã¯ã©ãŠãã·ã¹ãã ...çµ±ååæãã©ãããã©ãŒã
SAS Viyaãã©ãããã©ãŒã ã®ã¢ã€ãã¢ãšç®æšãç°¡åã«èª¬æãããšãããã¯ãããŒã¿æºåããè€éãªæ©æ¢°åŠç¿ã¢ã«ãŽãªãºã ã®äœ¿çšãŸã§ããããžã§ã¯ãã®ãã¹ãŠã®æ®µéã§ããããã¿ã€ãã®åæãè¡ãããã®æ®éçãªãã©ãããã©ãŒã ã§ãã 4ã€ã®ã¿ã¹ã¯ãããã¯ããããŸãã
1.ããŒã¿ã®æºå
2.ããŒã¿ã®èŠèŠåãšç 究
3.äºæž¬åæ
4.æ©æ¢°åŠç¿ã¢ã«ãŽãªãºã ã®åœ¢åŒã®é«åºŠãªåæ
èªè
åãã®æ
å ±
éèŠãªãã¥ã¢ã³ã¹ãæãªãããšãªãã1ã€ã®èšäºã®ãã¬ãŒã ã¯ãŒã¯å
ã§ãã¹ãŠãäŒããããšã¯ããªãé£ããããããããã®æé ã¯ãäŸã«ãã£ãŠä»¥äžã®èšäºã§æ€èšãããŸãã ãã®èšäºã§ã¯ãåæããŒã«ã®è¿
éãªäœæ¥ãæäŸããSAS Viyaãšã³ãžã³ã®éèŠãªãããã¯ãæ€èšããŸãã 次ã«ãã¢ãã³ã§çŸããã€ã³ã¿ãŒãã§ãŒã¹ã«é¢ããèšäºãç¶ããŸãã
SAS Viyaãã©ãããã©ãŒã ã®åºç€
SAS Viyaã«ã¯ãéå§ããããã®ããã€ãã®éèŠãªæ©èœããããŸãã SASãœãªã¥ãŒã·ã§ã³ã䜿çšããããšããã人ã¯ãSASããšã³ãžã³ã§åæã¿ã¹ã¯ãå®è¡ããç¹å¥ãªåæèšèªSAS Baseã«åºã¥ããŠããããšãç¥ã£ãŠããŸãã ã¯ã©ã¹ã¿ãŸãã¯1å°ã®åŒ·åãªã³ã³ãã¥ãŒãã£ã³ã°ãã·ã³äžã®ã°ãªããæ§æã§äœ¿çšã§ããŸãã SAS ViyaãšåŸæ¥ã®SAS 9åæãœãªã¥ãŒã·ã§ã³ã®äž»ãªéãã¯ãSAS Viyaã¯æ°ããç¬èªã®
CASïŒã¯ã©ãŠãåæãµãŒãã¹ïŒããŒã¿åŠçãšã³ãžã³ã«åºã¥ããŠããŸãã 2ã€ã®éèŠãªæ©èœïŒ1ã€ç®ã¯ãRAMå
ã®ããŒã¿ã䜿çšããŠãã¹ãŠã®æäœãå®è¡ããã€ã³ã¡ã¢ãªãã¯ãããžãŒã§ããã2ã€ç®ã¯åæ£ã³ã³ãã¥ãŒãã£ã³ã°ã¢ãããŒãã§ãã CASã¯åäžã®ãã¹ãã§å®è¡ã§ããŸããããã·ã³ã®ã¯ã©ã¹ã¿ãŒïŒã³ã³ãããŒã©ãŒãšããŒã¿åŠçãµãŒããŒïŒã§ã®äœæ¥ã«æé©åãããŠãããã¯ã©ã¹ã¿ãŒã®ç°ãªãããŒãã§ããŒã¿ãä¿åããã³åŠçããŠè² è·ã䞊ååã§ããŸãïŒæŠå¿µçãªã¢ãããŒãã¯Hadoopã·ã¹ãã ã®æŠå¿µã«éåžžã«è¿ãïŒã å³ã«CASã¢ãŒããã¯ãã£ã衚瀺ãããšãMPPãŸãã¯SMPã®ã€ã³ã¹ããŒã«ã«ã€ããŠæ¬¡ã®å³ã衚瀺ãããŸãã
ãªãã¯ã©ãŠããªã®ãïŒ
SASã¯ãViyaãã©ãããã©ãŒã ãç¹ã«CASã®éçºæã«ãã¯ã©ãŠãã³ã³ãã¥ãŒãã£ã³ã°ã®æŠå¿µã掻çšããŸããã ãããã¯4ã€ã®ã°ã«ãŒãã«åããããšãã§ããŸãïŒ
1.ããŸããŸãªã¯ã©ã€ã¢ã³ãã®å€æ°ã®APIã»ãããä»ããã¢ã¯ã»ã·ããªãã£ã SASã«ãšã£ãŠãããã¯å€§ããªåé²ã§ãã åæã«SAS Baseèšèªã®ã¿ã䜿çšããããšã«å¯Ÿããå¶éã¯ãããŸããã PythonïŒããšãã°ãJupiter NotebookããïŒãRãLuaãªã©ã䜿çšã§ããŸãããããã¯ãSAS Viyaãã©ãããã©ãŒã äžã®CASã§å®è¡ãããŸãã
2.匟åæ§ã CASã¯ã©ã¹ã¿ãŒã®ããŒããæ¥ç¶/åæããããšã«ãããã·ã¹ãã ãç°¡åã«æ¡åŒµã§ããŸãã ã¢ããªã±ãŒã·ã§ã³ã¯Webçµç±ã§ã¢ã¯ã»ã¹ã§ãããã€ã¯ããµãŒãã¹ãšããŠç·šæãããŸãã ãããã¯ãã€ã³ã¹ããŒã«ãæŽæ°ãããã³æäœã®ç¹ã§äºãã«ç¬ç«ããŠããŸãã
3.é«å¯çšæ§ã CASã¯ãã¯ã©ã¹ã¿ãŒããŒãéã§ããŒã¿ãã©ãŒãªã³ã°ã·ã¹ãã ã䜿çšããŸãã 1ã€ã®ããŒã¿ã»ãããè€æ°ã®ããŒãã«ä¿åããããããããŒã¿æ倱ã®ãªã¹ã¯ã軜æžãããŸãã ããŒãã®1ã€ã«é害ãçºçããå Žåã®åãæ¿ãã¯ãã¿ã¹ã¯ã®ã¹ããŒã¿ã¹ãç¶æããªããèªåçã«è¡ãããŸããããã¯ãå€ãã®å Žåã倧éã®åæèšç®ã«ãšã£ãŠéèŠã§ãã
4.ã»ãã¥ãªãã£ã®åäžã ã¯ã©ãŠãã¯å
Œ
±ãããã€ããŒããååŸã§ãããããå®è£
ã¯ããŒã¿äŒéãã£ãã«ã®ä¿¡é Œæ§ã«é¢ããããå³ããèŠä»¶ãæºããå¿
èŠããããŸãã
Viyaãã©ãããã©ãŒã ã¯ãã¯ã©ãŠãå
ãç¬èªã®ããŒã¿ã»ã³ã¿ãŒå
ã®å°çšãã·ã³ãä»»æã®æ°ã®ãã·ã³ã®ã¯ã©ã¹ã¿ãŒãªã©ãã©ãã«ã§ãå±éã§ããŸãã ãœãªã¥ãŒã·ã§ã³ã®ãã©ãŒã«ããã¬ã©ã³ã¹ã¯èªåçã«æäŸãããŸãã
CASã¯ã©ã®ããã«æ©èœããŸããïŒ
MPPã€ã³ã¹ããŒã«ã®äŸã䜿çšããŠãCASã®åäœãåæããŸãã SMPã¯ç°¡çŽ ââåããŸãããCASã®ååãç¶æããŸãã å®éã«ã¯ãSMPã¯ã¢ãã«ããã¹ãããããã®ããŒã«ã«ç°å¢ã®ãã¹ããšããŠäœ¿çšã§ããããã©ãŒãã³ã¹ãåäžãããããã«MPPãã©ãããã©ãŒã ã«éçºã移è¡ã§ããŸãã
SAS Viyaã®ãããã¬ãã«CASã¢ãŒããã¯ãã£ãããäžåºŠèŠãŠã¿ãŸãããã
CASã«ã€ããŠè©±ããšãã³ã³ãããŒã©ãŒãå¥ã®æ¹æ³ã§ãã¹ã¿ãŒããŒãïŒããã«ããã¯ã¢ããã³ã³ãããŒã©ãŒããŒãã«å¥ã®ããŒããå²ãåœãŠãããšãå¯èœïŒãšäœæ¥ããŒãã§æ§æãããŸãã ãã¹ã¿ãŒããŒãã¯ãã¯ã©ã¹ã¿ãŒããŒãã«ããããŒã¿ã«é¢ããã¡ã¿æ
å ±ãä¿åããããŒã¿ãåŠçããã³ä¿åãããããã®ããŒãïŒCASã¯ãŒã«ãŒïŒã«èŠæ±ãé
ä¿¡ããŸãã å¥ã«ããã©ãããã©ãŒã ãåäœããããã«å¿
èŠãªåæãµãŒãã¹ãšè¿œå ã¢ãžã¥ãŒã«ããããµãŒããŒãå²ãåœãŠãããŸãã ãŸããã¿ã¹ã¯ã«å¿ããŠããã€ããããŸãã ããšãã°ãSPREïŒSAS Programming Runtime EnvironmentïŒçšã®ãµãŒããŒã䜿çšã§ããŸããããã«ãããCASãšSPREã®äž¡æ¹ã䜿çšããViyaãã©ãããã©ãŒã ã§ãViyaã€ã³ã¹ããŒã«ã®äžéšãšããŠå¥ã®ãã·ã³ã§åŸæ¥ã®SAS 9ã¿ã¹ã¯ãå®è¡ã§ããŸãã
Viyaãã©ãããã©ãŒã ã§CASã䜿çšããå¯èœæ§ãæ¡å€§ããCloudãšããååã®æåã®æåãæ£åœåããèå³æ·±ãæ§æããããŸãã
ãã«ãããã³ã·ãŒã¯ãéšééã§ãªãœãŒã¹ãšããŒã¿ãå
±æããæ©èœãæäŸããŸãã åæã«ããããã³ããã«ã¯ããã©ãããã©ãŒã ã«ã¢ã¯ã»ã¹ããViyaãã©ãããã©ãŒã ã®ããŸããŸãªæ©èœãè«ççã«åé¢ããããã®åäžã®ã€ã³ã¿ãŒãã§ãŒã¹ãæäŸãããŸãã å€ãã®ãªãã·ã§ã³ããããŸãã ããããããã®åé¡ã¯å¥ã®èšäºã§æ€èšãããã§ãããã
RAMã®ä¿¡é Œæ§ãšCASã«ããŒã¿ãããŒãããæ¹æ³ã¯ã©ãã§ããïŒ
åæãç¹ã«é«åºŠãªåæã®ããã®é«åºŠãªãœãªã¥ãŒã·ã§ã³ã«ã€ããŠè©±ããŠããã®ã§ã倧éã®ããŒã¿ã«ã€ããŠè©±ããŠããããšã¯æããã§ãã ããã»ã¹ã®éèŠãªéšåã¯ãRAMã«ããŒã¿ããã°ããããŒãããŠæäœãå®è¡ãããã®ããŒã¿ã®é«å¯çšæ§ã確ä¿ããããšã§ãã
ä¿¡é Œæ§ã®ããã®ã¡ã¢ãªå
ã·ã¹ãã ã§ã¯ãRAMã«ããããŒã¿ã®ããã¯ã¢ãããå¿
èŠã§ãã RAMã¯ãé»æºããªãã«ãªã£ããšãã«ç¶æ
ãç¶æããæ¹æ³ãç¥ããŸããããŸãããã¹ãŠã®ããŒã¿ãRAMã®é åã«åãŸããªãå ŽåããããRAMã®ããŒã¿ããã°ãããªããŒãããã¡ã«ããºã ãå¿
èŠã§ãã ãããã£ãŠãåæã®ããã«CASã«ããŒããããããŒãã«ã®å Žåãã³ããŒã¯ç¹å¥ãªSASHDAT圢åŒã®èªã¿åãå°çšã¡ã¢ãªé åã«äœæãããŸãã é«å¯çšæ§ã確ä¿ããããã«ããããã®ãã¡ã€ã«ã¯ã¯ã©ã¹ã¿ãŒå
ã®è€æ°ã®ããŒãéã§ãã©ãŒãªã³ã°ãããŸãã ãã®ãã©ã¡ãŒã¿ãŒã¯æ§æã§ããŸãã ããã¯ãããŒãã倱ããããšãSASHDATãã¡ã€ã«ã®ã³ããŒããé£æ¥ããŒãã®RAMã«ããŒã¿ãèªåçã«ããŒãããããšããèãæ¹ã§ãã CASæ§é å
ã®ãããã®ã³ããŒã®ã¹ãã¬ãŒãžé åã¯CAS_DISK_CACHEãšåŒã°ããŸã ã
CAS_DISK_CACHEã¯CASã®éèŠãªéšåã§ããããã©ãŒã«ããã¬ã©ã³ã¹ã確ä¿ããããã ãã§ãªããã¡ã¢ãªäœ¿çšéãæé©åããããã«ãå¿
èŠã§ãã 以äžã®å³ã¯ãSASHDATãä¿åããããŸããŸãªæ¹æ³ãšãããŒã¿ãRAMã«ããŒãããåçã瀺ããŠããŸãã ããšãã°ãããŒã¿ã»ããAã¯OracleããŒã¿ããŒã¹ããååŸãããRAMããã³ãã£ã¹ã¯äžã®åäžã®CASããŒãã«ä¿åãããŸãã ããã«ããã®ããŒã¿ã»ããAã¯å¥ã®ããŒãã§ããŒããã©ã€ãã«ã®ã¿è€è£œãããŸãã å€ãã®ãªãã·ã§ã³ããããŸãïŒäžéšã¯è¿œå ã®ããã¯ã¢ãããå¿
èŠãšããŸãã-ããã«ã€ããŠã¯ä»¥äžã§èª¬æããŸãïŒããäž»ãªã¢ã€ãã¢ã¯ã以åã«ããŠã³ããŒãããããŒã¿ãRAMã«ãã°ããå埩ããããã®ã³ããŒãåžžã«ä¿æããããšã§ãã ãšããã§ã2ã€ã®ãã©ã¡ãŒã¿ãŒãèšå®ãããŠããå ŽåïŒã»ãã·ã§ã³ã¬ãã«ã§MAXTABLEMEM = 0ããã³COPIES = 0ã®å ŽåãããŒã¿ã¯RAMã«ã®ã¿ååšããŸãã
ãŸããHadoopã䜿çšããCASã®èå³æ·±ãæ§æãæ€èšããããšæããŸãã ãã®CASæ§æãHadoopã·ã¹ãã ã§äœ¿çšããã«ã¯ãHadoopçšã®SASãã©ã°ã€ã³ãã€ã³ã¹ããŒã«ããå¿
èŠããããŸãã ãã®ã¢ãããŒãã®äž»ãªã¢ã€ãã¢ã¯ãHadoopã¯ã©ã¹ã¿ãŒã®ããŒããæ©èœããCASããŒãã«ãªãããšã§ãã ããŒã¿ã¯ããããã¯ãŒã¯è² è·ãªãã§hdfsã®ãã¡ã€ã«ããçŽæ¥RAMã«åã蟌ãŸããŸãã ããã¯ãããã©ãŒãã³ã¹ã®é¢ã§æé©ãªãªãã·ã§ã³ã§ãã Hadoopã¯ãSASHDATãã¡ã€ã«ïŒã¯ã©ã¹ã¿ãŒäžã®HDFSãCAS_DISK_CACHEã®åœ¹å²ãæãããŸã-HDFSã¬ãã«ã§ã®äºçŽïŒã®ã¿ããŸãã¯ä»ã®ããŒã¿ãšäžç·ã«äœ¿çšã§ããŸãã Hadoopã¯ã©ã¹ã¿ãŒã®ãªãœãŒã¹å²ãåœãŠã¯ãYARNãä»ããŠè¡ãããŸãã CASãHadoopã¯ã©ã¹ã¿ãŒã«ã€ã³ã¹ããŒã«ããã¹ããŒã ïŒ
èªã¿èŸŒã¿äž
ããŒã¿ã®ããŒãã¯ç°¡åã§ãã CASãžã®å
¥åã®ããŸããŸãªãœãŒã¹ã瀺ãããšãã§ããŸãã ãããã¯ãåäžã®ã¹ããªãŒã ãŸãã¯äžŠè¡ããŠããŒãã§ããŸãã ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã¯ãœãŒã¹ãšããŠéåžžã«é »ç¹ã«äœ¿çšããããããRDBMSããCASã«ããŒã¿ãããŒããããããã¯ãæ€èšããŸãã CASã¯ã©ã¹ã¿ãŒãžã®ããŒã¿ã®èªã¿èŸŒã¿ãæé©åããã«ã¯ãã¯ã©ã¹ã¿ãŒã®åããŒãã«ãœãŒã¹ããŒã¿ããŒã¹ã®ã¯ã©ã€ã¢ã³ããœãããŠã§ã¢ãã€ã³ã¹ããŒã«ããããšãæãŸããã§ãã ãã®å ŽåãCASã¯ã©ã¹ã¿ãŒã®åããŒãã¯ãããŒã¿ã®äžéšã䞊è¡ããŠåä¿¡ããŸãã ã¯ã©ã€ã¢ã³ããã³ã³ãããŒã©ãŒã«ã®ã¿ã€ã³ã¹ããŒã«ããå Žåããã¹ãŠã®ããŒã¿ã¯CASã³ã³ãããŒã©ãŒãä»ããŠéä¿¡ãããŸãã
ããšãã°ããã©ã¡ãŒã¿numreadnodes = 3ãèšå®ãããšãããŒãã«ã¯ç°ãªãCASããŒãã«ããŒãããããã«ããŒã¿ã®3ã€ã®ãã£ã³ã¯ã«èªåçã«åå²ãããŸã-ãã®å ŽåãããŒã¿ååžã¯mod 3æäœã䜿çšããæåã®æ°å€åã«ããã°ã«ãŒãåã«åºã¥ããŸãã
HadoopãŸãã¯TeradataããœãŒã¹ãšããŠäœ¿çšããHadoopãŸãã¯Teradataã®Embedded Processã䜿çšãããšãHadoopãŸãã¯Teradataã¯ã©ã¹ã¿ãŒã®åããŒãããçŽæ¥ããŒããå®è¡ãããŸãã Hadoopã¯ã©ã¹ã¿ãŒãåå¥ã«ã€ã³ã¹ããŒã«ããå ŽåïŒHadoopããŒãã«CASã¯ã€ã³ã¹ããŒã«ãããªãïŒãCASã¯ã©ã¹ã¿ãŒã«CAS_DISK_CACHEãšãªã¢ãäœæãããããšã«æ³šæããŠãã ããã
CASãéå§ããæ¹æ³ã¯ïŒ
CASã®äœæ¥ã«ãããéèŠãªçšèªã¯ãã©ã€ãã©ãªãšã»ãã·ã§ã³ã§ãã CASã§ã®äœæ¥ãéå§ãããšãæåã«äœæãããã®ã¯ã»ãã·ã§ã³ã§ãã SAS Studioã䜿çšããŠäœæ¥ããå Žåã¯æåã§å®çŸ©ã§ããŸãããŸãã¯ãCASã«æ¥ç¶ãããšãSAS Viyaã®äœ¿çšå¯èœãªã°ã©ãã£ã«ã«ã€ã³ã¿ãŒãã§ã€ã¹ãä»ããŠèªåçã«äœæãããŸãã ã»ãã·ã§ã³å
ã§ã¯ãæ°ããã©ã€ãã©ãªã§å®çŸ©ãããŠãããã¹ãŠã®ããŒã¿ãšå€æã¯ãããã©ã«ãã§ããŒã«ã«ã¹ã³ãŒãã§äœæãããŸãã ããŒã¿ïŒcaslibã§å®çŸ©ïŒããã³ããŒã«ã«ã»ãã·ã§ã³ã®ã¹ãããã®çµæã¯ããã®ã»ãã·ã§ã³ã§ã®ã¿è¡šç€ºãããŸãã çµæãå
¬éããå¿
èŠãããå Žåãcaslibãã°ããŒãã«ãã©ã¡ãŒã¿ãšããã¢ãŒãæŒç®åã§ãªãŒããŒã©ã€ãã§ããŸããããŒã¿ã¯ä»ã®ã»ãã·ã§ã³ããå©çšã§ããŸãã ã°ããŒãã«ãã©ã¡ãŒã¿ã§ãã§ã«å®çŸ©ãããŠããã©ã€ãã©ãªã¯ãã©ã®ã»ãã·ã§ã³ãããå©çšã§ããŸãã ããã¯ããªãœãŒã¹ãæé©ã«å
±æããããŒã¿ã¢ã¯ã»ã¹æš©ã管çããããã«è¡ãããŸãã ããŒã«ã«ã»ãã·ã§ã³ããåæããåŸãcaslibãã°ããŒãã«ã§åå®çŸ©ãããŠããªãå Žåããã¹ãŠã®äžæããŒã¿ã¯åé€ãããŸãã TIMEOUTãã©ã¡ãŒã¿ãŒãèšå®ããŠãã»ãã·ã§ã³ããåæãããšãã«ããŒã¿ãåé€ããããçæçãªãããã¯ãŒã¯é害äžã®æ倱ãåé¿ãããããããªãåæã®ããã«ãã®ã»ãã·ã§ã³ã«æ»ãããšãã§ããŸãïŒããšãã°ãTIMEOUTãã©ã¡ãŒã¿ãŒã3600ç§ã«èšå®ãããšã60å以å
ã«æ»ããŸãïŒã»ãã·ã§ã³ïŒã ããã«ãããŒã¿ã¯ãå€æã®ä»»æã®ã¹ãããã§ãç¹å¥ãªSASHDAT圢åŒãŸãã¯ã¢ã¯ã»ã¹ãç°¡åãªããŒã¿ããŒã¹ã«ä¿åã§ããåçŽãªSAVEãªãã¬ãŒã¿ã«ãã£ãŠæ¥ç¶ãèšå®ãããŸãã
caslibsã©ã€ãã©ãªã¯ãCASã§å©çšã§ããããŒã¿ã»ãããèšè¿°ããŠããŸãã caslibã®äœææã«ãæ¥ç¶ã¿ã€ããšæ¥ç¶ãã©ã¡ãŒã¿ãŒã瀺ãããŸãã caslibã®å®çŸ©ã§ã¯ãã¡ã¢ãªå
ã®ããŒã¿ãœãŒã¹ãšã¿ãŒã²ããé åãããã«æããŠããŸãã ãŸããcaslibã¬ãã«ã§ã¯ãcaslibã§èª¬æãããŠããããŒã¿ãžã®ãŠãŒã¶ãŒã°ã«ãŒãã®ã¢ã¯ã»ã¹æš©ãèšå®ãããšäŸ¿å©ã§ãã ããã¯ãã°ã©ãã£ã«ã«ã€ã³ã¿ãŒãã§ã€ã¹ã§è¡ãããŸãã
ããŸããŸãªã¿ã€ãã®ãœãŒã¹ã®caslibèšè¿°ã®äŸïŒ
caslib caspth path="/data/cust/" type=path; caspth â , path - caslib pgdvd datasource=( srctype="postgres", username="casdm", password="xxxxxx", server="sasdb.race.sas.com", database="dvdrental", schema="public", numreadnodes=3) ; caslib hivelib desc="HIVE Caslib" datasource=(SRCTYPE="HIVE",SERVER="gatekrbhdp01.gatehadoop.com", HADOOPCONFIGDIR="/opt/sas/hadoop/client_conf/", HADOOPJARPATH="/opt/sas/hadoop/client_jar/", schema="default",dfDebug=sqlinfo) GLOBAL ;
caslibã決å®ããããããã«åŠçããããã«ããŒã¿ãRAMã«ããŒãã§ããŸãã caslib hivelibããŒã¿ãããŒãããäŸïŒ
proc casutil; load casdata="stocks" casout="stocks" outcaslib="hivelib" incaslib="hivelib" PROMOTE ; quit; /* casdata â ( hive), casout â CAS, outcaslib â caslib, , incaslib â caslib, .*/ /* in/out caslib , */
åã»ãã·ã§ã³å
ã§ããªã¯ãšã¹ãã¯é çªã«å®è¡ãããŸãã ããã¯ãã³ãŒããæåã§äœæããå Žåã«éèŠã§ãããViyaã§äœ¿çšå¯èœãªã°ã©ãã£ã«ã«ã€ã³ã¿ãŒãã§ã€ã¹ã䜿çšããå Žåã¯èããããŸããã GUIã¯ã©ã€ã¢ã³ãã¢ããªã±ãŒã·ã§ã³èªäœã¯ãã¹ãããã䞊è¡ããŠå®äºããããã®åå¥ã®ã»ãã·ã§ã³ãäœæããŸãã
ããããæäœããããã®å®å
šã«ã°ã©ãã£ã«ã«ãªã€ã³ã¿ãŒãã§ãŒã¹ãšã¢ãããŒãã¯ã以äžã®èšäºã§æ€èšããŸãã ããã§ãcaslib DM_ORAHRãäœæããGUIãä»ããŠããŒã¿ãRAMã«ããŒãããæé ã®ã¹ã¯ãªãŒã³ã·ã§ãããè¿œå ããŸãã
ããã¯ã»ãã®å§ãŸãã«éããŸããã
ããã§ãCASã«é¢ããããŒããçµäºããViyaãã©ãããã©ãŒã ã«æ»ããŸãã Viyaã¯ããžãã¹ãŠãŒã¶ãŒåãã«äœæãããŠãããããäœæ¥ã®éçšã§CASã®è©³çŽ°ãæ·±ãç解ããå¿
èŠã¯ãããŸããã ãã¹ãŠã®æäœã«äŸ¿å©ãªã°ã©ãã£ã«ã«ã€ã³ã¿ãŒãã§ã€ã¹ããããCASã¯ã¡ã¢ãªå
ããã³åæ£ã³ã³ãã¥ãŒãã£ã³ã°ã«ãããã¹ãŠã®åææé ã®é«éæäœãä¿èšŒããŸãã
ããã§ãViyaã§äœ¿çšå¯èœãªãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ã€ã¹ã«ç§»åã§ããŸãã çŸåšããããã®å€ããããã補åã®æ°ã¯çµ¶ããå¢å ããŠããŸãã èšäºã®åé ã§ããããã¯å®å
šãªåæãµã€ã¯ã«ã«å¿
èŠãª4ã€ã®ã°ã«ãŒãã«å²ãåœãŠãããŸããã äž»ãªèãæ¹ã«æ»ããšãViyaã¯ããŒã¿ãã€ãã³ã°ãšé«åºŠãªåæã®ããã®åäžã®ãã©ãããã©ãŒã ã§ãã ãããŠãäœæ¥ã¯ãã®ããŒã¿ã®æºåãšæ€çŽ¢ããå§ãŸããŸãã ãŸããViyaã«é¢ããäžé£ã®èšäºã®æ¬¡ã®éšåã§ã¯ãã¢ããªã¹ããå©çšã§ããããŒã¿æºåããŒã«ã«ã€ããŠèª¬æããŸãã
çµè«ã®ä»£ããã«ãViyaãšããååã¯Viaãšããåèªã«ç±æ¥ããŠããŸãïŒè±èªã®ãã¹ã«ãŒããŸãã¯ãã¹ã«ãŒãããïŒã ãã®ååã®äž»ãªã¢ã€ãã¢ã¯ãåŸæ¥ã®SAS 9ãœãªã¥ãŒã·ã§ã³ãããåæãæ°ããã¬ãã«ã«åŒãäžããããã«äœæãããæ°ãããã©ãããã©ãŒã ãžã®åçŽãªç§»è¡ã§ãã