åæ£ã€ã³ããªãžã§ã³ã¹ã®ãããªãã®ã圢æããããã«ãã¢ãã®ã€ã³ã¿ãŒãããã®ããã€ã¹ã«ã¯ãéäžç®¡çãåéãããããŒã¿ãæ§æãä¿åã解éããããã®ã·ã¹ãã ãŸãã¯ãµãŒãã¹ãå¿ èŠã§ãã ããã€ã¹ã¯ã©ãŠãã€ã³ãã©ã¹ãã©ã¯ãã£ã®äžå¿çãªãé è³ãã§ããå¶åŸ¡ã·ã¹ãã ã¯ãæ¥ç¶ãããããã€ã¹ã®ãã·ã³ãã¬ããžããŒã¹ãè£å ãããœãããŠã§ã¢ãæŽæ°ããŸãã
ãªãã¬ãŒã¿ãŒã¯ãããã€ã¹ã°ã«ãŒããšæéããšã«éèšãããããŒã¿ã調æ»ããããŸããŸãªã»ã¯ã·ã§ã³ã§èŠèŠåããŸãã ãã詳现ãªåæã®ããã«ãåãããŒã¿ãBusiness Intelligenceã¯ã©ã¹ã®ããŸããŸãªã·ã¹ãã ã«è»¢éãããŸãã å人çšããã€ã¹ïŒãã£ãããã¹ãã©ãã«ãŒãªã©ïŒã«ã€ããŠããåéãããããŒã¿ã®äœ¿çšãšäœ¿çšã«é¢ããçµ±èšã®å¿ååæã®å¯èœæ§ãåŠå®ããŠãããã€ã¹ãšãµãŒãã¹ãããã«æ¹åããã¯ã©ãŠããµãŒãã¹ãªãã¬ãŒã¿ãŒã¯ã»ãšãã©ãããŸããã
ã¢ãã®ã€ã³ã¿ãŒãããçšã®ããã€ã¹ã®éçºã¯åžžã«ç°¡çŽ åãããå®äŸ¡ã«ãªããäžå°äŒæ¥ããã®åžå Žã«åå ¥ã§ããããã«ãªã£ãŠããŸãã 管çã·ã¹ãã ãäœæããå¿ èŠæ§ãèªèããå€ãã®äŒæ¥ã¯ãã®éçºã®è€éããéå°è©äŸ¡ããŠãããç£æ¥çšãµãŒããŒãã¯ãããžãŒïŒãã©ãŒã«ããã¬ã©ã³ã¹ã®ããã®ã¯ã©ã¹ã¿ãªã³ã°ããã«ããµãŒããŒåæ£ã¢ãŒããã¯ãã£ãªã©ïŒã䜿çšããå¿ èŠæ§ãèæ ®ããŠããŸããã å€ãã®å Žåãéçºã¯ããèªäœã§ãã瀟å ãã§éå§ãããŸãã åžå Žã§ã®IoTããã€ã¹ã®æåã¯ããŠãŒã¶ãŒæ°ã®æ¥éãªå¢å ã«ã€ãªããããµãŒãã¹ã®ã¹ã±ãŒãªã³ã°ãšãã®ããã©ãŒãã³ã¹ã®ç¢ºä¿ã«é¢ãã解決äžå¯èœãªåé¡ãè¿ éã«äœæããŸãã
ãããªãåé¡ãæããŠããµãŒããŒãœãããŠã§ã¢éçºéšéãè¿ éã«äœæã§ããªããããIoTãªãã¬ãŒã¿ãŒã¯å€ãã®å Žåãããã€ã¹èªäœã«éäžããŠäžå€®ã·ã¹ãã ã®éçºãå€éšå§èšããŸãã ããããããã¯åé¡ã解決ããŸãã-ãµãŒãããŒãã£ã®éçºè ã¯ãåãæ¹æ³ã§ã·ã¹ãã ããŒãããäœæãå§ããåºç€ã«æ·±å»ãªæè¡ãå°å ¥ããã®ã«ååãªãªãœãŒã¹ãšæéããããŸããã
ãã©ãããã©ãŒã AggreGateã¯2002幎ã«èªçããŸããã ãã®éãç§ãã¡ã¯Serial-over-IPã³ã³ããŒã¿ãŒã®çç£ã«ç©æ¥µçã«æºãã£ãŠããããã¡ã€ã¢ãŠã©ãŒã«ãNATã®èåŸã«é ããŠçŽæ¥éä¿¡ã§ããªãã³ã³ããŒã¿ãŒéã§ããŒã¿ãéä¿¡ããäžå€®ãµãŒããŒãå¿ èŠã§ããã LinkServerãšåŒã°ãã補åã®æåã®ããŒãžã§ã³ã¯C ++ã§èšè¿°ãããŠããããµãŒãã¹ãšããŠã®ã¿å©çšå¯èœã§ãã LinkServerã¯ãåŠçããã«ããŒã¿ã¹ããªãŒã ãããèªäœã«ãã³ãã§éããŸãã
å°ãåŸã«ãåœç€Ÿã®ã³ã³ããŒã¿ãŒã¯èªç±ã«ããã°ã©ã å¯èœãªã³ã³ãããŒã©ãŒã«å€ãããŸããã 圌ãã¯ééããããŒã¿ããç解ããå§ããäžå€®ãµãŒããŒã«åãããšãæãããšããè«ççãªæ¬²æ±ãçããŸããã ã»ãŒåæã«ãããããç£æ¥åãã®ç£èŠããã³ããã€ã¹ç®¡çã·ã¹ãã ã®äœæäœæ¥ã®90ïŒ ããèªè»¢è»ã®çºæãã§ãããç¹å®ã®ããžãã¹ã«åºæã®ã¿ã¹ã¯ã«è²»ããåŽåã¯ãããããã§ããããšãããããŸããã
2004幎ãã·ã¹ãã ã¯Javaã«ç§»æ€ããããã®ç¬éãããããã€ã¹ç®¡çãã¬ãŒã ã¯ãŒã¯ããšããŠéçºãããŸããã æ°å¹Žéãç§ãã¡ã¯ã»ãšãã©ç²ç®çã«åããŠãçµæãšããŠåŸãããã®ãå®å šã«ç解ããŠããŸããã§ããã 幞ããªããšã«ãç¹å®ã®æ¥çã«ãé ãæ±ããŠãé¢ããããšãªããã·ã¹ãã ã®æ®éæ§ãç¶æããããã«ãã¢ãã®é¡§å®¢ãé¿ããããšãã§ããŸããã
çŸåšããã®ãã©ãããã©ãŒã ã¯ããªã¢ãŒãç£èŠãšã¡ã³ããã³ã¹ãITã€ã³ãã©ã¹ãã©ã¯ãã£ç®¡çãšãããã¯ãŒã¯ç£èŠãSCADAãšããã»ã¹èªååãç©ççã¢ã¯ã»ã¹å¶åŸ¡ããã«èªååãè»äž¡ç®¡çãèªå販売æ©ããã³æ¯æãæ©ç®¡çãã»ã³ãµãŒãããã¯ãŒã¯ç£èŠãã«ãŠã³ããªã©ãããŸããŸãªåéã§äœ¿çšãããŠããŸã蚪åè ãšè»ãã€ãã³ããšã€ã³ã·ãã³ãã®éäžç®¡çãåºåãšæ å ±ããã«ã®ç®¡çãã¢ãã€ã«ããã€ã¹ç®¡çã
ãã©ãããã©ãŒã ã®äž»ãªç®ç
æ¯urçã«èšãã°ãAggreGateã¯ãããã€ã¹ã¯ã©ãŠããžã®ã€ã³ã¿ãŒãã§ã€ã¹ããã°ããäœæããããã®ã¬ãŽã³ã³ã¹ãã©ã¯ã¿ãŒã§ãã IoTãœãªã¥ãŒã·ã§ã³ã®ã¢ãŒããã¯ããæ©åšãšããžãã¹ããžãã¯ã«éäžã§ããããã«ããŠãã€ã³ãã©ã¹ãã©ã¯ãã£ã®åé¡ã解決ããŸãã
- ä¿¡é Œæ§ã®äœãã»ã«ã©ãŒããã³è¡æãã£ãã«ãä»ããŠäœæ¥ããå Žåã®ãµãŒããŒãšããã€ã¹éã®éä¿¡ã®ç¶æ
- ç©ççãªæå³ã«é¢ä¿ãªãããããã®ããã€ã¹ã§ã®äœæ¥ã®çµ±å
- ããŸããŸãªçš®é¡ã®ããŒã¿ããŒã¹ïŒãªã¬ãŒã·ã§ãã«ããªã³ã°ãNoSQLïŒã«åéããã倧éã®ã€ãã³ããšå±¥æŽããŒã¿ã®ã¹ãã¬ãŒãž
- ãœãŒã¹ããŒã¿åæãšã€ãã³ãçžé¢ã®è€éãªãã§ãŒã³ã®èŠèŠçæ§ç¯
- è€æ°ã®ããã€ã¹ããã®ããŒã¿ãçµåããã€ã³ãã©ã¹ãã©ã¯ãã£å šäœã®KPIãèšç®ããããã»ã¹ã®ã¢ããªã³ã°
- ããã°ã©ãã³ã°ãªãã§ãæ¢æã®ãã¥ãŒããããªãã¬ãŒã¿ãŒãšã·ã¹ãã ãšã³ãžãã¢ã®ã€ã³ã¿ãŒãã§ã€ã¹ãè¿ éã«æ§ç¯
- æ¢è£œã®ãŠãããŒãµã«ã³ãã¯ã¿ïŒSQLãHTTP / HTTPSãSOAPãCORBAãSNMPãªã©ïŒã䜿çšããçµ±åã¹ã¯ãªããã®å®è£
ã·ã¹ãã çµ±å
ãã®ãã©ãããã©ãŒã ã¯æ®éçã§ãããããããŸããŸãªç£èŠããã³å¶åŸ¡ã·ã¹ãã ã®çµ±åã«åœ¹ç«ã¡ãŸãã ããã«ãããäžå¿ èŠãªçµ±åãã€ã³ããåé¿ãããçµ±åã·ããªãªã®æ°ãåæžãããŸãã ããšãã°ãçµ±åç£èŠã·ã¹ãã ã«ã¯ãã€ã³ã·ãã³ãïŒã¢ã©ãŒã ïŒãé ä¿¡ããããã®ãµãŒãã¹ãã¹ã¯/ ITSM /ã¡ã³ããã³ã¹ç®¡çã·ã¹ãã ãšã®åäžã®çµ±åãã€ã³ãããããåšåº«/è³ç£ç®¡çã·ã¹ãã ãšã®åäžã®çµ±åã«ãããå©çšå¯èœãªç©çè³ç£ãšããžãã¹ãµãŒãã¹ãžã®åœ±é¿ã®çšåºŠã«é¢ããæ å ±ãååŸããŸãã
ãã®ãããªå ŽåãããŒã«ã¢ã¯ã»ã¹ãç·šæããããšã§ãã·ã¹ãã ã䜿çšããããã®åã ã®ã·ããªãªãšãªãã¬ãŒã¿ãŒã€ã³ã¿ãŒãã§ã€ã¹ã®äžææ§ãããŸããŸãªéšéã«æäŸã§ããŸãã
ãã©ãããã©ãŒã ã¢ãŒããã¯ãã£
ãã©ãããã©ãŒã ã®äž»ãªã³ã³ããŒãã³ãã¯æ¬¡ã®ãšããã§ãã
- ãµãŒããŒã¯ãããã€ã¹ãããŒã¿ã¹ãã¬ãŒãžãããã³ãããã®èªååŠçãšã®éä¿¡ãæäŸããJavaã¢ããªã±ãŒã·ã§ã³ã§ãã ãµãŒããŒãã¯ã©ã¹ã¿ãŒåããŠãé«å¯çšæ§ãæäŸããåæ£ã€ã³ã¹ããŒã«ã§çžäºã®ãã¢ããŒãã¢é¢ä¿ãç¶æã§ããŸãã AggreGateãµãŒããŒã¯ãWebã€ã³ã¿ãŒãã§ãŒã¹ãµããŒããæäŸããçµã¿èŸŒã¿WebãµãŒããŒã管çããŸãã
- åäžã®ã³ã³ãœãŒã«ã¯ã管çè ã¢ãŒããã·ã¹ãã ãšã³ãžãã¢ã¢ãŒãããŸãã¯ãªãã¬ãŒã¿ã¢ãŒãã§1ã€ãŸãã¯è€æ°ã®ãµãŒããŒãšã®åæäœæ¥ãæäŸããã¯ãã¹ãã©ãããã©ãŒã ã®ãã¹ã¯ãããã¯ã©ã€ã¢ã³ããœãããŠã§ã¢ã§ãã
- ãšãŒãžã§ã³ã -ãµãŒããŒãšã®éä¿¡ãæäŸããããã€ã¹èšå®ãçµ±åããããã䜿çšããŠæäœãå®è¡ããã€ãã³ããéåæçã«éä¿¡ããããã«ãããã€ã¹ã®IoTãã¡ãŒã ãŠã§ã¢ã«åã蟌ãããšãã§ããã©ã€ãã©ãªã å€ãã®ã©ã€ãã©ãªãŒå®è£ ïŒJavaã.NETãC / C ++ãAndroid Javaãªã©ïŒããããŸããæšæºãŸãã¯ç¬èªã®ãããã³ã«ã䜿çšããŠãµãŒããŒãšã®éä¿¡ãå®è¡ãããå ŽåããšãŒãžã§ã³ãå®è£ ã¯å¿ èŠãããŸãããåŸè ã®å ŽåããµãŒããŒçšã«åå¥ã®ããã€ã¹ãã©ã€ããŒãéçºãããŸãã ãšãŒãžã§ã³ãã¯ãåå¥ã®ããŒããŠã§ã¢ããã€ã¹ïŒã²ãŒããŠã§ã€ïŒãšããŠæ§æããããšãã§ããŸãã
- ä»ã®ãã¹ãŠã®ã³ã³ããŒãã³ãã®æ©èœãæ¡åŒµããè€éãªçµ±åã·ããªãªãå®è£ ããããã®ãªãŒãã³ãœãŒã¹API
ãµãŒããŒã¯ãããã€ã¹ããã®ããŒã¿ã®èªã¿åããšå€æŽã®èšé²ã管çããŸãããã®ããã»ã¹ã¯åæ¹ååæãšåŒã°ããŸãã ãµãŒããŒåŽã§ã¯ãããããããã€ã¹ã¹ãããã·ã§ãããäœæãããŸããããã«ã¯ãææ°ã®ããã€ã¹ã¡ããªãã¯ã®ã³ããŒãšããªãã¬ãŒã¿ãŒããã³ã·ã¹ãã ã¢ãžã¥ãŒã«ã«ãã£ãŠè¡ãããå€æŽãå«ãŸããéä¿¡äžè¶³ã®ããããã€ã¹ã«æžã蟌ãŸããŸããã æ§æã®å€æŽã¯ãæåã®æ©äŒã®ååã«åŸã£ãŠããã€ã¹ã«é ä¿¡ãããããã€ã¹ã®æ§æãåæã«ãªã³ã©ã€ã³ã«ãªãã®ãåŸ ããã«ãã°ã«ãŒãã®å€æŽãããã€ã¹æ§æã«å ããããšãã§ããŸãã
ãµãŒããŒã¯ãéçãªããã¯ã€ããIPã¢ãã¬ã¹ãæããªãããã€ã¹ã®çä¿¡æ¥ç¶ã®åä¿¡ãšä¿å®ãæäŸããŸãã ãã®æ©èœã¯ãIoTãã©ãããã©ãŒã ã«ãšã£ãŠéèŠã§ãã
ããã€ã¹ããŒã¿ãšã€ãã³ãã¯ã åäžã®ããŒã¿ã¢ãã«ã®äžéšã«ãªããŸãã ãã®ã¢ãã«å ã§ã¯ãåããã€ã¹ã¯ãã³ã³ããã¹ãã®éå±€æ§é ã®äžéšã§ããããããã³ã³ããã¹ãã«ãã£ãŠè¡šãããŸãã åã³ã³ããã¹ãã«ã¯ãå€æ°ïŒããããã£ãèšå®ãå±æ§ïŒãé¢æ°ïŒã¡ãœãããæäœïŒãã€ãã³ãïŒã¢ã©ãŒãïŒã®3çš®é¡ã®åœ¢åŒåãããããŒã¿èŠçŽ ãå«ãŸããŸãã ã³ã³ããã¹ãã«ã¯ã䜿çšå¯èœãªãã¹ãŠã®èŠçŽ ãèšè¿°ããã¡ã¿ããŒã¿ãå«ãŸããŸãã ãããã£ãŠããã¹ãŠã®ããŒã¿ãšã³ã³ããã¹ãã¡ã¿ããŒã¿ã¯ãããèªäœã«å®å šã«éäžããŠããŸãã ãã®æè¡ã¯ã ããã€ã¹ã®æ£èŠåãšåŒã°ããŸã ã ããŸããŸãªã¿ã€ãã®ããã€ã¹ã®æ£èŠåããããã¬ãŒã³ããŒã·ã§ã³ã¯ãããã€ã¹ãã©ã€ããŒãšãšãŒãžã§ã³ãã«ãã£ãŠäœæãããŸãã
ãªããžã§ã¯ãæåã®ããã°ã©ãã³ã°ã§ã¯ããªããžã§ã¯ããããããã£ãã¡ãœãããã€ãã³ããæäŸãããŸãã ããããã£ã¯ããã€ã¹ã®å éšå€æ°ãã¡ãœããã¯å®è¡å¯èœãªæäœãã€ãã³ãã¯ããã€ã¹ãå éšããŒã¿ãŸãã¯å€éšç°å¢ã®å€æŽã«ã€ããŠãµãŒããŒã«éç¥ããæ¹æ³ã§ãã
ã»ãŒãã¹ãŠã®ããã€ã¹ã¯ãããããã£ãã¡ãœãããããã³ã€ãã³ãã®ã»ããã§èšè¿°ã§ããŸãã ããšãã°ããªã¢ãŒãå¶åŸ¡ã®æ°Žã¿ã³ã¯ã«ã¯ããæ°Žäœãããããã£ãšãããã«ããéããããã³ããã«ããéããããšããæ¹æ³ã䜿çšããŠæ¶²äœã®æµããå¶åŸ¡ã§ããŸãã ã¹ããŒãã¿ã³ã¯ã¯ããã»ãŒç©ºãããã»ãŒæºæ¯ããããªãŒããŒãããŒããªã©ã®ã¢ã©ãŒããçæããããšãã§ããŸãã Javaã§100以äžã®éä¿¡ãããã³ã«ãã©ã€ããŒãéçºããæ£èŠåã®ã¢ã€ãã¢ããã®äŸ¡å€ã蚌æããŸããã ããã«ãå€ãã®ææ°ã®ããŠãããŒãµã«ããããã³ã«ïŒOPC UAãJMXãWMIãªã©ïŒã¯ãéåžžã«é¡äŒŒããããŒã¿ã¢ãã«ã䜿çšããŠããŸãã
ãã¹ãŠã®ãµãŒããŒã³ã³ããã¹ãã¯ãã³ã³ããã¹ãããªãŒãšåŒã°ããéå±€æ§é ã«é 眮ãããŸãã ã³ã³ããã¹ãã¯ããŸããŸãªãªããžã§ã¯ãïŒããã€ã¹ããŠãŒã¶ãŒãã¬ããŒããã¢ã©ãŒã ãªã©ïŒã«å¯Ÿå¿ãããšããäºå®ã«ããããããããããã¯ãã¹ãŠå ±éã®ã€ã³ã¿ãŒãã§ãŒã¹ãæã¡ããµãŒããŒã®ã³ã³ããã¹ãããªãŒå ã§çžäºäœçšã§ãããããé«åºŠãªæè»æ§ãæäŸããŸãã åãååã«ãããç°ãªããµãŒããŒãåæ£ã€ã³ã¹ããŒã«ã§çžäºã«å¯Ÿè©±ã§ããããã«ãªããŸãã
æ¥ç¶ãããåããã€ã¹ã«ããããªãã¬ãŒã¿ãŒã¯çŽæ¥æ§æïŒããã€ã¹æ§æã®èªã¿åããšç·šéïŒãçŽæ¥å¶åŸ¡ïŒæåã§ããã€ã¹ã«ããŸããŸãªæäœã匷å¶çã«å®è¡ïŒãããã³çŽæ¥ç£èŠïŒããã€ã¹ããã®ã€ãã³ããæ¬äŒŒãªã¢ã«ã¿ã€ã ã¢ãŒãã§è¡šç€ºïŒãå®è¡ã§ããŸãã
ããã€ã¹ã¡ããªãã¯ã®ã€ãã³ããšå€æŽã¯ããµãŒããŒã¹ãã¬ãŒãžã«ä¿åãããŸãã ã·ã¹ãã ã®ã¿ã¹ã¯ã«å¿ããŠãããã¯ããŸããŸãªã¿ã€ãã®ã¹ãã¬ãŒãžã«ãªããŸãã ããšãã°ãRaspberry Piå ã§å®è¡ãããŠãããã€ã¯ããµãŒããŒã®å ŽåãæãåçŽãªãã¡ã€ã«ã¹ãã¬ãŒãžã䜿çšããã倧èŠæš¡ãªåæ£ã€ã³ã¹ããŒã«ã®äžå€®ãµãŒããŒã¯ãApache Cassandra NoSQLããŒã¿ããŒã¹ã®ã¯ã©ã¹ã¿ãŒã䜿çšã§ããŸãã
ãã ããã»ãšãã©ã®å Žåãéåžžã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãã¹ãã¬ãŒãžãšããŠäœ¿çšãããŸãã ORMã¬ã€ã€ãŒïŒHibernateïŒã䜿çšãããšãMySQLãOracleãMicrosoft SQL ServerãPostgreSQLããã®ä»ã®DBMSãšã®äºææ§ãæäŸãããŸãã
ããã€ã¹ããåä¿¡ããããŒã¿ãšã€ãã³ãã¯ããã¢ã¯ãã£ããªããµãŒããŒãªããžã§ã¯ãã®ã©ã€ããµã€ã¯ã«ã«åœ±é¿ãäžããå€éšç°å¢ã®å€åã«å¯Ÿå¿ã§ããããã«ããŸãã ã¢ã¯ãã£ããªãªããžã§ã¯ãã¯æ¬¡ã®ãšããã§ãã
- ãªããžã§ã¯ãã®ç¹å®ã®è€éãªç¶æ ãŸãã¯ã€ãã³ãã®ç¹å®ã®ãã§ãŒã³ãæ°ããã¿ã€ãã®ã€ãã³ãã«å€æããã¢ã©ãŒã -ã€ã³ã·ãã³ã
- ããžãã¹ã«ãŒã«ããœãŒã¹ã€ãã³ããšå€ããŠãŒã¶ãŒå®çŸ©ã®ã€ãã³ãã¿ã€ããšå€ã«å€æã§ããããã«ããã¢ãã«
- äžæçãªãµãŒããŒã®ã·ã£ããããŠã³ã®å Žåã§ããã¹ã±ãžã¥ãŒã«ãããã¿ã¹ã¯ãšãã®å®è¡ãä¿èšŒããã¹ã±ãžã¥ãŒã©ãŒ
- ã»ã³ãµãŒããã³ãã®ä»ã®çš®é¡ã®ãªããžã§ã¯ã
ã¢ã¯ãã£ããªããžã§ã¯ãã¯ãæ°ããã¿ã€ãã®å€æ°ãé¢æ°ãã€ãã³ããåäžã®ããŒã¿ã¢ãã«ã«è¿œå ãããŠãŒã¶ãŒå€æ°ãšã€ãã³ããžã®å€æŽããªããžããªã«éä¿¡ããããã€ã¹ããã®ä»ã®ãªããžã§ã¯ãã®èªåæäœãããªã¬ãŒã§ããŸãã
ããŒã¿å ¥åãã©ãŒã ãããŒãã«ãåçããããã°ã©ããããŒã¢ããã¯å³ãäœæããããã®ãŠã£ãžã§ããããããŸãã ãããã¯ãã€ã³ãã©ã¹ãã©ã¯ãã£å šäœã®ç¶æ ãšéçŽãããKPIã«åºã¥ãã°ããŒãã«ãããã³ã€ã³ãã©ã¹ãã©ã¯ãã£ã®1ã€ã®ããã€ã¹ãŸãã¯ã³ã³ããŒãã³ãã®ã¹ããŒã¿ã¹ã瀺ãããªããžã§ã¯ãããŒã¹ãã®äž¡æ¹ã®ããã·ã¥ããŒãã«çµåã§ããŸãã
ãŠã£ãžã§ãããšã¬ããŒããã³ãã¬ãŒãã¯ããã©ãããã©ãŒã ã®äžéšã§ããããã®ãšã³ã·ã¹ãã ã«å¯æ¥ã«çµ±åãããŠããå°çšã®ããžã¥ã¢ã«ãšãã£ã¿ãŒã§ç·šéãããŸãã ãŠã£ãžã§ãããšãã£ã¿ãŒã䜿çšãããšãå€æ°ã®å ¥ãåã«ãªã£ãã³ã³ãããŒããã«ã§æ§æãããè€éãªã€ã³ã¿ãŒãã§ã€ã¹ãæ§ç¯ããããã«èŠèŠçãªã³ã³ããŒãã³ããé 眮ã§ããŸãã SCADAã·ã¹ãã ã§äœ¿çšããããšãã£ã¿ãŒã«äžè¬çãªçµ¶å¯Ÿé 眮ã«å ããŠãHTMLããŒãžå ã®ããŒãã«ã®ç·šéã«ééãã人ãªã誰ã§ãç¥ã£ãŠããã°ãªããã¬ã€ã¢ãŠãã䜿çšã§ããŸãã ã°ãªããã¬ã€ã¢ãŠãã䜿çšãããšãããããç»é¢ãµã€ãºã«åãããŠé©åã«ã¹ã±ãŒã©ãã«ãªããŒã¿å ¥åãã©ãŒã ãšããŒãã«ãäœæã§ããŸãã
ãã®çµæãããŒã¿ãèŠèŠåããããŒã«ã䜿çšããŠèŠèŠçã«éçºããã1è¡ç®ãŸãã¯2è¡ç®ã®ãªãã¬ãŒã¿ãŒã€ã³ã¿ãŒãã§ã€ã¹ã¯ããŠã£ãžã§ããããã©ãŒã ãããŒãã«ããã£ãŒããã¬ããŒããããŒã¢ããã¯å³ãããã³ãããã®éã®ããã²ãŒã·ã§ã³ãåããããã·ã¥ããŒãã§æ§æãããŸãã
ã€ã³ã¿ãŒãã§ã€ã¹ãšãã£ã¿ãŒã䜿çšãããšãã©ãã«ãããã¹ããã£ãŒã«ãããã¿ã³ããã§ãã¯ããã¯ã¹ãã¹ã©ã€ããŒãšã¹ãããŒããªã¹ããæ¥ä»/æå»ã»ã¬ã¯ã¿ãŒãã¹ã±ãŒã«ããã€ã³ã¿ãŒãªã©ãå€æ°ã®æ¢è£œã®ã³ã³ããŒãã³ãã䜿çšã§ããŸãã ããªãŒããããªãŠã£ã³ããŠãåçãã¯ãã«SVGç»åãGoogleããã/ Bing / Yandex / OpenStreetMapã«åºã¥ãå°ççããããªã©ãããè€éãªã³ã³ããŒãã³ãããããŸãã ãµããŒããããŠãããã£ãŒãã¿ã€ãã®ãªã¹ãã«ã¯ãå€å žçãªãã£ãŒãã¿ã€ãã®ã»ããããŸããŸãªçµ±èšãã£ãŒããã¬ã³ããã£ãŒãã極座æšãã£ãŒããå«ãŸããŸãã
ãšãã£ã¿ãŒã§æç»ããããã¹ãŠã®ãŠã£ãžã§ããã¯ãJavaãµããŒãã®ãªããã©ãŠã¶ãŒãå«ããWebããŒãžã§ã³ã®ã€ã³ã¿ãŒãã§ãŒã¹ã§åäœããŸãã ã¢ãã€ã«ããã€ã¹ã§ã HTML5ããã³JavaScriptã®ãµããŒãã®ã¿ãå¿ èŠã§ãã
ãµãŒããŒãªããžã§ã¯ãïŒããã€ã¹ãã¢ãã«ãã¢ã©ãŒã ïŒãšãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ã€ã¹ã³ã³ããŒãã³ãã®ããããã£ã¯ãããŒã¿ãååŸããã¿ã€ãã³ã°ãšå ŽæãããŒã¿ã®åŠçæ¹æ³ãçµæã®é çœ®å Žæã決å®ãããã€ã³ãã£ã³ã°ã䜿çšããŠçžäºã«æ¥ç¶ãããŸãã ããŒã¿ãåŠçãããšãããã€ã³ãã£ã³ã°ã¯åŒèšèªãšã¯ãšãªèšèªã䜿çšããŸãã
åŒããŒã¹ã®ãã€ã³ãã£ã³ã°ã¯ãMicrosoft Excelã®åŒã«äŒŒãŠããŸãã æ°åŒã¯è€æ°ã®ã»ã«ããããŒã¿ãååŸãããããã«æ°åŠæŒç®ãŸãã¯ããŸããŸãªããŒã¿åŠçé¢æ°ãé©çšããçµæãçŸåšã®ã»ã«ã«å ¥ããŸãã åŒã¯ãããŒã¿ãååŸããå ŽæãšããŒã¿ã«é©çšããå¿ èŠãããå€æãèšè¿°ããåŒã§ããããŸãã
ã¯ãšãªèšèªã¯éåžžã®SQLã«éåžžã«äŒŒãŠããŸãã ãŸããããŸããŸãªããŒãã«ã®ããŒã¿ã1ã€ã«çµåãããã£ã«ã¿ãªã³ã°ã䞊ã¹æ¿ããã°ã«ãŒãåãªã©ãé©çšã§ããŸãã çµã¿èŸŒã¿ã¯ãšãªèšèªãšåŸæ¥ã®SQLã®éãã¯ãéåžžã®ããŒãã«ã§ã¯ãªããããŒã¿ãœãŒã¹ãåäžã®ã¢ãã«ã®ããŸããŸãªããŒã¿ãããªã³ã¶ãã©ã€ã§çæãããä»®æ³ããŒãã«ã§ããããšã§ãã ãŸãããã¹ãŠã®ã¯ãšãªã¯ããããå®è¡ãããªãã¬ãŒã¿ãŸãã¯ã·ã¹ãã ãªããžã§ã¯ãã®ã¢ã¯ã»ã¹æš©ãèªåçã«èæ ®ããŸããããã¯ããµãŒããŒããŒã¿ããŒã¹ãžã®çŽæ¥SQLã¯ãšãªãšæ¯èŒããŠæå©ã§ãã
æãè€éãªããŒã¿åŠçã¿ã¹ã¯ã解決ããããã«ãJavaã¹ã¯ãªãããŸãã¯å¥åã®ãã©ã°ã€ã³ãäœæã§ããŸãã ãã ããããŒãããŒã®ããããã«ãã£ãŠäœæãããããŒã¿åŠççšã®åã¹ã¯ãªããã¯ãç§ãã¡ã«ãšã£ãŠé©ãã¹ãéã§ã-å€å žçãªéçºãå¿ èŠãªå Žåããéåžžã®ç°å¢ïŒEclipseãIdeaãªã©ïŒä»¥å€ã§ããã©ãããã©ãŒã ãå¿ èŠãªã®ã¯ãªãã§ãã
ãŸããåæ£ã¢ãŒããã¯ãã£ã®æè¡çãªããã€ã¹ã«ã€ããŠã話ããããšæããŸãã ãã®æŠå¿µã®ãã¬ãŒã ã¯ãŒã¯å ã§ããµãŒããŒéã®ãã¢ããŒãã¢é¢ä¿ã¯ã1ã€ã®ãµãŒããŒïŒããããã€ããŒãïŒããã®åäžããŒã¿ã¢ãã«ã®äžéšãå¥ã®ãµãŒããŒïŒãæ¶è²»è ãïŒã«ã¢ã¿ããããããã«èšå®ãããŸãã ããã«ãããã³ã³ã·ã¥ãŒããµãŒããŒãªããžã§ã¯ãã¯ãç¬èªã®ãããã€ããŒãµãŒããŒãªããžã§ã¯ããšåçã«ããåãã§ããŸãã 1ã€ã®ãµãŒããŒã®æ¥ç¶æ°ã«å¶éã¯ãªããé£æ¥ãµãŒããŒãšã®é¢ä¿ã§åæã«ãµãã©ã€ã€ãŒããã³ã³ã³ã·ã¥ãŒããŒãšããŠæ©èœã§ããŸãã
åæ£ã¢ãŒããã¯ãã£ã«ããã倧èŠæš¡ã·ã¹ãã ã®å€ãã®åé¡ã解決ã§ããŸãã
- æ°Žå¹³ã·ã¹ãã ã®ã¹ã±ãŒãªã³ã°
- ããŒã«ã«ç£èŠãµãŒããŒãšãªã¢ãŒããµã€ãã§ã®äžéããŒã¿ã¹ãã¬ãŒãžã®ã€ã³ã¹ããŒã«ã«ããåæ£ç£èŠ
- åçŽã¹ã±ãŒãªã³ã°ãè€æ°ã®è«çã¬ãã«ã§ã®ãµãŒããŒéã®æ©èœã®åæ£
ãã®æçš¿ã¯ãHabréã§ã®ããã¥ãŒã§ãã 次ã®èšäºã§ã¯ããã©ãããã©ãŒã ã®å éšæ§é ãããã«åºã¥ããç¬èªã®ãœãªã¥ãŒã·ã§ã³ãããã³ãéãPCãœãããŠã§ã¢ããã¢ãã®ã€ã³ã¿ãŒãããã®çµã¿èŸŒã¿ã·ã¹ãã ãããã€ã¹ã«ã©ã®ããã«æµžéãããã«ã€ããŠã®ç解ã«ã€ããŠè©³ãã説æããäºå®ã§ãã
PSã¢ãã®ã€ã³ã¿ãŒãããçšã®ãµãŒããŒãœãããŠã§ã¢ãéçºããŠããå Žåã¯ã以äžã®è³ªåã«çããŠãã ããã