
å°æ¬ã§ãã人ãåãéšçœ²ã«2人ããããææ¡ã®ä»æ¹ã管çã®ä»æ¹ãä»äºã®é²ãæ¹ããã¹ãŠåžåããŠããããã
æ°åã§ã¡ã³ããŒãºã®ç€Ÿå ã«ã³ãããŒã§ãããã€ã¬ã¯ãã°ããŒã¹ã«ã³ãããŒã«å ¥ç€ŸããããŒã¿ã¢ããªã¹ããšããŠæŽ»èºããŠããé«ãããåããŠæ åœããæ¡ä»¶ã§ã¯ã©ã€ã¢ã³ãã®å£²äžæé«çãèšé²ãå°æ¬ã§ããäžåž2人ã®ããšãæ¥ã åžåããŠåŠãã§ããããã§ããä»äºã®åãçµã¿æ¹ãå§¿å¢ããŸãäžåžéã®ã©ããªé¢ãå°æ¬ããŠããã®ããã話ã䌺ããŸããã


åžžã«æ°ããç¥èŠãå¿ èŠãªWebæ¥çã«èŠªåæ§ãæããã
äžåœã§çãŸãè²ã¡ãŸããããæ¥æ¬ã®ã¢ãã¡ã奜ãã ã£ãããšããã£ããã§ã倧åŠã§ã¯æ¥æ¬èªãå°æ»ããŠããŸãããæåã¯æåž«ã«ãªãããšèããŠããŸããããããå°±è·ãèãããšãã«ãæ¥æ¬èªãæãããããæ¥æ¬èªã䜿ã£ãä»äºããããããšæãããã«ãªã£ãã®ã§ãããŸã倧åŠã®ãµãŒã¯ã«ã§ããŒã ã§ååãããã察çãªç«å Žã§ååãããããšã®æ¥œãããæããŠããã®ã§ãæããç«å Žã®æåž«ããããåšãã®äººã ãšå¯Ÿçãªç«å Žã§ä»äºãããã»ããè¯ããšèããã®ã§ãã
æè²æ¥ç以å€ã®å¥ã®æ¥çãæ€èšãããšãã«ããäœãå°éã¹ãã«ã身ã«ã€ãä»äºããããããšããèãããã£ãã®ã§Webæ¥çã«çµãããšã«æ±ºããŸãããç§ã¯ã«ãŒãã£ã³ã¯ãŒã¯ã§åãããšãç¹°ãè¿ãããããæ°ããããšããããã¿ã€ãã§ãããã®ãããæ¥ã æ°ãããã®ãæŽæ°ãããããã€ã³ããããå¿ èŠãªWebæ¥çã¯ããã¿ãªãããããªããšæããŸããã

颿¥ã§ããŒã¿åæã®é©æ§ãèŠåºãããã
ã¡ã³ããŒãºãç¥ã£ãã®ã¯åéã®ç޹ä»ããã£ãããã¡ã³ããŒãºãWebããŒã±ãã£ã³ã°é åã§ã®è±å¯ãªå®çžŸãæã£ãŠããããšã«èå³ãæã¡ãŸããã瀟å¡ã€ã³ã¿ãã¥ãŒã®èšäºãèŠããšãè¥æç€Ÿå¡ãããããæ²èŒãããŠããããšãããè¥æãæŽ»èºã§ããç°å¢ã§ããããšãå°è±¡ã«æ®ããŸããã
颿¥ã§ã¯æ§ã
ãªè©±ãããŸããããç¹ã«å€§åŠé¢ã§äœãå匷ããŠããã®ããèãããããšãå°è±¡ã«æ®ã£ãŠããŸããç ç©¶ã§ã¯ã©ããã£ãç ç©¶æ¹æ³ã䜿ã£ãã®ããã©ãããããŒã¿ãæ±ã£ãã®ããææãããéã现ããèãããŸãããããšããšç§ã¯ããŒã¿ã奜ãã§ããã®æ°åãã©ããªæå³ãæã£ãŠããã®ããæšè«ããã®ã楜ãããšæããŠããã®ã§ã質åãããã®ã¯èŠã§ã¯ãããŸããã§ããã
ç¹ã«ããŒã¿åæã®éšçœ²ãåžæããŠããããã§ã¯ãªãã®ã§ããã颿¥ã§ã®åãçãã§é©æ§ãèŠåºãããã®ãããããŸãããå
¥ç€ŸåŸã¯ããã€ãã®è²æã®ããŒã ããã£ãã®ã§ãããããŒã¿åæã®ããŒã ã«å
¥ãããšãã§ãããã€ã¬ã¯ãã°ããŒã¹ã«ã³ãããŒã«é
å±ã決ãŸããŸããã
詊è¡é¯èª€ããªããã¯ã©ã€ã¢ã³ãã®èª²é¡è§£æ±ºã®ããã«å°œåããã
å ¥ç€ŸåŸã«æåã«æ åœããæ¡ä»¶ã¯ãèèçŸè²šåºã®ãããžã§ã¯ããWebãµã€ãéçšãããŒã±ãã£ã³ã°ã®æ¯æŽãåææ¥åãªã©å€å²ã«æž¡ãæ¥åãæ åœããŸãããã·ã¹ãã ã®å±äººåã課é¡ãšãªã£ãŠããŠãã¯ã©ã€ã¢ã³ãã®äžã§ãäžéšã®äººããã·ã¹ãã ã®ããšãåããããã»ãšãã©ãã©ãã¯ããã¯ã¹ã«ãªã£ãŠããã®ã§ãã
ã¡ã³ããŒãºããã¯2人ã®å 茩ãç§ãšããäžäººã®åæã®åèš4人ãã¢ãµã€ã³ãããŠããŠãæåã¯ãµã€ãéçšãšããŠå ¥ããŸãããã¢ããã°ãªé¢ãå€ããµã€ãã ã£ãã®ã§ãéçšããã®ã«ç²Ÿäžæ¯ã§æ £ããªããã¡ã¯åšããèŠããŠããªãã£ããšæããŸããåŸã ã«å 茩ãšãäž»å°æš©ãæ¡ã£ãŠãããªããã°çŸç¶ã¯å€ãããªãããšããèãã«è³ããBIã®ããã·ã¥ããŒããèšèšãæ§ç¯ãåæããããšã«ç©æ¥µçã«é¢ãããŸãããæ¡ä»¶ã®ãã£ã¬ã¯ã·ã§ã³ããµã€ãéçšã¯ç§ã®ãªãŒããŒãæ åœããŠãã ãã£ãŠãããäºäººã¯ããã³ãé åãæ åœãç§ã¯ååã®åšåº«ç®¡çãšããŒã¿åæãé 匵ã£ãŠããŸãããæ¬ãèªãã ããããŒã¿å匷äŒãªã©ç€Ÿå å匷äŒã«åå ãããããããã§æ€çŽ¢ããããšèªåã§è©Šããªããã客ããŸã«ã¢ãŠãããããæåºããŠããããããäœåãç¹°ãè¿ãããšã«ãã£ãŠããããããµã€ãéçšã®åœ¢ãã§ãããã£ãŠãã£ãã®ã§ãã
å¬ããã£ãã®ã¯ãèªåã®ã¢ãŠãããããããã®ãã客ããŸãããã²äœ¿ãããããšæ¡çšããŠãããããšãã·ã¹ãã ã¯ä»¥åã®ç°å¢ãããã¢ã¯ã»ã¹ãããããªããæ§ã
ãªããŒã¿ã®ã°ã©ãã®èŠãç®ãè¯ããªããŸããããŸãããŒã¿åæãã衚é¢çãªéšåã§æ¢ãŸã£ãŠããã®ãæ·±ã¿ãå¢ãããã«ãªã£ããšæããŸãã
人æ°ãåŸã
ã«å¢ããããŒã¿ã¢ããªã¹ãã®å
茩ããžã§ã€ã³ããŠ10åè¿ãã®ããŒã ã«è²ã£ãŠãããŸããã
ã¡ã³ããŒãºã§ã®ç€Ÿå 衚地ããã客ããŸãäžç·ã«åãã§ãããã
ãããžã§ã¯ãã§ã¯é«ã売äžç®æšãæ²ããŠããã®ã§ãæ¥ã å 茩ãšäžç·ã«ããŒã¿ãèŠãªãã調æŽãããæœçãå€ãããããŠç®æšãå®çŸã§ãããšãã¯ã倧ããªéææãæããŸãããã客ããŸãç§ãã¡ãšäžç·ã«æ°ããåãçµã¿ã«ãã£ã¬ã³ãžããŠãããã®ã§ãä¿¡é Œé¢ä¿ã¯ããåããªã£ããšæããŸãããããžã§ã¯ãã¯é廿é«ã®å£²äžç®æšãéæããããšãã§ããŸãããã¡ã³ããŒãºã®ç€Ÿå ã§è¡šåœ°ãããããšã決ãŸã£ããšããã客ããŸã®è²¬ä»»è ãäžç·ã«åãã§èšå¿µæ®åœ±ããŠãããããšã¯ãä»ã§ãããæãåºã«ãªã£ãŠããŸãã
ã客ããŸãšã¯ãã©ãããªé¢ä¿ããšãŠããã人ã°ããã§ãåºç€Ÿãããšãã¯ãã€ãã¿ããªã§ã©ã³ãã«è¡ã£ãŠããŸãããã©ã€ããŒãã§ã仲è¯ããããŠããã£ãŠããæ¹ãããŠããã³ã¹ãäŒæ¥ã«æ¥œããã§ãããã§ãã
å°æ¬ããå 茩éã®è¯ããšãããåžåããèªåãé«ããŠããããã
ãã€ã¬ã¯ãã°ããŒã¹ã«ã³ãããŒã¯äžéå ¥ç€Ÿã®æ¹ãå€ãã§ããçããã®ããã¯ããŒã³ã¯æ§ã ã§ãä»ç€Ÿã®çµéšãè±å¯ãªäººãå€ãããŸããç§ãå ¥ç€Ÿããåœæã®ã«ã³ãããŒç€Ÿé·ã¯ãå¶æ¥çµéšãããŒã¿åæçµéšãè±å¯ãªæ¹ã ã£ãã®ã§ãããããå©ããŠããã ããŸãããå°éæ§ã®é«ã人ãå€ãããšã匷ã¿ã ãšæããŸãã
ç§ã«ã¯å°æ¬ããäºäººã®äžé·ããããã§ããæåã®ãããžã§ã¯ãã«å
¥ã£ããšãã®ãªãŒããŒã§ããã£ã¬ã¯ã¿ãŒãšããŒã¿åæãæ
åœããŠãããŠããæ¹éã§ãããã£ã¬ã¯ã¿ãŒã®å
èŒ©ã¯ææ¡ãããšãã¯å€§èã§è¿«åãããã®ã§ãããå®éã«è¡åãããšãã¯ã¿ã¹ã¯ãåè§£ãã絶察ã«ãã¹ãã§ãªãããã«ç®¡çããŠããç¹çްãããããŸãã
ããŒã¿åæãæ
åœããŠããå
茩ã¯ãç¡é§ãªäœæ¥ããªãã¹ãããªãæ¹ã§ããå¹ççã«åãã®ãšåæã«ãã¡ã³ããŒäžäººã²ãšãã®ããã©ãŒãã³ã¹ã®æå€§åãèããŠããããããããŒã ãåãããã«ãªããŸãã2人ãšããããåªç§ã§ãåŠãã§åžåããããšããããããããããã§ãããããã£ãç°å¢ã«èº«ã眮ããããšã¯ããšãŠã幞ãã ãšæã£ãŠããŸãã
ãŸãã¯ç§ãSQLã身ã«ã€ããŠã欲ããããŒã¿ãçç¢ºã«æ¢ãåºããããã«ãªãããã§ããã¹ãã«ã磚ããŠä»æ¡ä»¶ã«æšªå±éã§ãããããªååšã«ãªãããã§ããã
ããããããã£ãšãåžåããå§¿å¢ãæã¡ç¶ãããã£ã¬ã³ãžã§ãã人ã§ããããããããã®å ãéãã¹ãã«ãéããžã£ã³ã«ã«è¡ãããšããã£ããšããŠããååãã«èªåãé«ããŠããå§¿å¢ã¯å¿ããã«æã¡ç¶ããããšæããŸãã

ç·šéåŸèš
倧åŠã§æ¥æ¬èªãå°æ»ããæ°åã§Webæ¥çãžãšé£ã³èŸŒãã é«ãããã€ã³ã¿ãã¥ãŒãéããŠãçŸç¶ã«æºè¶³ããããšãªããå°æ¬ããå
茩æ¹ã®è¯ããšãããæ°ããç¥èãæ¥ã
貪欲ã«åžåããããšãããŸã£ãããªå§¿å¢ããšãŠãå°è±¡çã§ãããèªã詊è¡é¯èª€ãéããŠã¯ã©ã€ã¢ã³ãã®èª²é¡è§£æ±ºã«å°œåããé廿é«ã®å£²äžç®æšéæãšãã倧ããªææã«çµã³ã€ãããšããœãŒãããã¯ãé«ããã®å
ã«ç§ããç±æãšè¡ååãæããããŸãã
ã奜å¥å¿ãæã¡ç¶ããŠãã£ã¬ã³ãžã§ãã人ããšãããèªèº«ã®çæ³åã®éããä»åŸãæ§ã
ãªé åã§èªåãé«ããæŽ»èºããŠããé«ããã®å§¿ãç®ã«æµ®ãã¶ã€ã³ã¿ãã¥ãŒã§ããã
åæã»åçïŒè°·è² ç²
æïŒé è€ äºåžå