ã€ã³ã¿ãã¥ãŒãããªããã°ãªããªãã£ããšãããŠã§ãéçºã®åéã§æèœãªå°é家ãš
ãã®æçš¿ã¯ããã®ãããã¯ã«é¢ãã䞻芳çãªèãã®éãŸãã§ãããç¹å®ã®æè¡çãªåé¡ãšã¿ã¹ã¯ã®ã»ããã§ãããç§ã®æèŠã§ã¯ãåè£è ãé¢æ¥ã§èªåã®å°éçãªè³è³ªããããã瀺ãã®ã«åœ¹ç«ã¡ãŸãã
ãŸããç§ã«ãšã£ãŠãå¹çããšã¯äœããå€æããããšæããŸãã
å¹çæ§ãšã¯ã çžå¯Ÿçãªå¹çæ§ãæå³ããŸã ãã€ãŸããä»ã®å¿åè ãšæ¯èŒããŠããããžã§ã¯ãã§ç¹å®ã®åœ¹å²ãæ ã£ãŠãããšãã«åè£è ãããããæçµçãªäŸ¡å€ïŒããžãã¹äŸ¡å€ïŒã§ãã
ããšãåããããªããšãããŠããŠããåã人ãç°ãªããããžã§ã¯ãã§ç°ãªãå¹æãçºæ®ããŸãã ããšãã°ãã¢ãžã£ã€ã«ãããžã§ã¯ãã¯äžéšã®äººã«é©ããŠããŸãããä»ã®äººã«ã¯ããŸãé©ããŠããŸããã åè£è ã®çžå¯Ÿçãªæå¹æ§ã¯ã1ã€ã®ãããžã§ã¯ãã®éäžã§ãã£ãŠããããããæ¹åã«å€åããå¯èœæ§ããããŸãã
ãããã£ãŠãæçµçã«ã¯ãè©Šçšæéäžã®æŠéã§ã®ã¿æå¹æ§ãç解ã§ãããšäž»åŒµãã人ã ã«åæããŸãã ãã¹ãŠã®èŠå ãäºåã«æ€èšããã®ã¯é£ããããŸãã
ããããã€ã³ã¿ãã¥ãŒã¯ãŸã è¡ãããå¿ èŠããããŸãã 話ãããã«è©Šçšæéäžå šå¡ãé£ããŠè¡ãããšã¯ãããŸããã
人äºããã»ã¹ã®çŸå®ãšããŠãæè¡é¢æ¥ã¯äž»ã«é»è©±ã§è¡ãããŸãã åè£è ã¯ããŸããŸãªéœåžãããã«ã¯åœããæ¥ãŠãããããã€ã³ã¿ãã¥ã¢ãŒãæ°äººãããããããŸããŸãªåœãããåè£è ãèŠã€ããããšãã§ããŸãã 1ã€ã®å€§éœåžã®ç¶æ³ã§ããå人é¢æ¥ãžã®æ è¡ã¯åè£è ããå€ãã®æéãæ¶è²»ãã人ã ã¯é»è©±é¢æ¥ã«ç°¡åã«åæããŸãã
é»è©±ã€ã³ã¿ãã¥ãŒã¯çãããå¿ èŠããããŸã-1æéã§è³ãç²ãã2æéã§è³ãèœã¡ãŸãã
決å®ãäžãããã®è¿œå æ å ±ãå ¥æããããã«ãé»è©±ã€ã³ã¿ãã¥ãŒã®åã«ãã¹ãã¿ã¹ã¯ãæäŸããããšããŸããã ããŸããããŸããã§ããã ã€ã³ã¿ãã¥ãŒã«åå ãã人ãã¡ãããæ¡éãã«å°ãããªãããã®äžã®æ£æ°ãªå°é家ã¯ããã«å°ãªããªããŸããã å®éãæèœãªéçºè ãã€ã³ã¿ãã¥ãŒã®åã«è ãšè¶³ã§ãã§ã«åŒãè£ãããŠããã®ã«ããªãã¿ã¹ã¯ãå®äºããå¿ èŠãããã®ã§ããããïŒ ãããŠãç§ãã¡ã¯ãã®èããæŸæ£ããŸããã
æåã«ãç³è«è ãšã®é¢æ¥ãå®æœããŠãç§ã¯ãžã§ãšã«ã»ã¹ãã«ã¹ããŒã®ãã«ãŒã«çªå·1ããé å®ããŸãã
ã圹ã«ç«ããªãåŸæ¥å¡ãéã£ãŠèŠããããããæ¬åœã®ãããèŠéãæ¹ãè¯ããããããã£ãŠã圌ã¯çããããã¹ãŠã®ãçãããããæé€ããŸããã
ãã°ããããŠãçæ³çãªåè£è ãå°ãªãããããšã«æ°ã¥ããŸããïŒãŸãã¯ãç§ã®æ³åã§ããååšããªããããããŸããïŒã
次ã«ããçãããã第6æèŠã§ã¯ãªãããã客芳çãªå®éçæšå®å€ã«å°éããããã«ãåããã€ã³ãã«å¯Ÿããåçã«åŸã£ãŠåè£è ãæ¯èŒããããã®è³ªåã®äžè¬çãªãªã¹ããäœæããŸããã
é¢æ¥æéãçãã»ã©ã質åãéžæããã®ãé£ãããªããŸããããããã®è³ªåã¯ãåè£è ãé·ã説æãå¿ èŠãšããã«ãå¯èœãªéãããæèã瀺ãããšãã§ããããã«ããããã§ãã
å®å šãªãã©ã³ã¹ãèŠã€ããããã«ãããªãã¯æ±ºå®ããå¿ èŠããããŸã-ç§ãã¡ã®ãããžã§ã¯ãã®åè£è ã®å¹çã®åé¡ã§æ±ºå®çãªèŠå ã¯äœã§ããïŒ
ç§ãéžãã äž»ãªèŠå ã¯ã åé¡ãç解ããç§ã®åéã§ã®è§£æ±ºçïŒæªåé«ãåé¡è§£æ±ºã¹ãã« ïŒãèãåºãèœå ãèšãæããã°ãææ³å®¶ããã³ãã§ãã¿äžããããšã§ããã
ããã«ããããã°ã®åå ããã°ãããããã°ããŠèŠã€ããèããããåé¡ãæããè€éãªããžãã¹åé¡ã®åçŽãªè§£æ±ºçãèŠã€ãåºãïŒãŸãã¯ææ¡ãããåé¡ãæ¹å€çã«è©äŸ¡ããïŒãéå¹çæ§ã«æ°ã¥ããå®æçãªã¢ã¯ã·ã§ã³ãèªååããŠãæéãç¯çŽããå¹çã«åçã«åœ±é¿ãäžããããšãã§ããŸãã
2çªç®ã®èŠå ã¯ãèœã¡çãã瀟亀æ§ã責任ãªã©ãå人ã®å人çãªè³è³ªã§ã ã å€åãã£ãšéèŠãããããŸããããä»ã®äººãå¥ã®ã€ã³ã¿ãã¥ãŒã§è©äŸ¡ã«é¢äžããŠããã®ã§ããçãããããšããåºæºã§äž»èŠ³çã«ããè©äŸ¡ã§ããŸãããè¿œå ã®è³ªåã¯ããŸããã
3ã€ç®ã¯è·åãè¶ ããã¹ãã«ã§ãã ç§ãã¡ã«ãšã£ãŠãçæ³çãªãç·ã®ãªãŒã±ã¹ãã©ãã ãã®ããã圌ã¯1ã€ã®ããšãããç¥ã£ãŠããŸãããããã¹ããåæã®åéãã¯ã©ã€ã¢ã³ããšã®éä¿¡ãUIãšããã¯ãšã³ãã®å®è¡ãSQLã¯ãšãªã®äœæãããŒã¿ããŒã¹ã¹ããŒãã®éçºãã¢ãŒããã¯ãã£ãœãªã¥ãŒã·ã§ã³ã®æäŸæ¹æ³ãç¥ã£ãŠããŸããã
ãã¡ããããã¯çæ³çã§ãã ãã¹ãŠãç¥ããå®å šã«ç¥ãããšã¯äžå¯èœã§ãããããŸããŸãªæ¹åã®å¹ åºãçµéšãšã¹ãã«ã«ãããããŒã å šäœãããè¯ãã³ãã¥ãã±ãŒã·ã§ã³ãåãããäºããç解ããå©ãåããäžç·ã«è§£æ±ºçãèŠã€ããããšãã§ããã¯ãã§ãã ããã«ããã1人ã®åŸæ¥å¡ãçªç¶è§£éãããŠãããžã§ã¯ããåæ¢ãããããžã§ã¯ãã®æåã«éèŠãªåœ¹å²ãæããããšãã§ããŸãã
ãã®ãããç§ã¯ããŸããŸãªåéã§å°ãå°ããŠãåè£è ã®ãã¹ãŠã®çµéšãšæ¬²æ±ãããããã®æ¹åã§èŠåºãããšã«ããŸããã
ãããŠæåŸã«ãªã£ãŠåããŠãç§ãã¡ã䜿çšããŠããæè¡ã®ç¥èããã ãããã«ãã£ãŠç§ãã¡ã¯ããã«ãããžã§ã¯ãã«å ¥ãããšãã§ããŸãã ããããç§ã®æèŠã§ã¯ããã®ç¥èã¯é·æçã«ã¯å¹çã«åœ±é¿ããŸããã ãã¯ãããžãŒãããã«ã¯èšèªããããã€ã§ãå€æŽã§ããã ãã§ãªããç¹å®ã®ç¥èã«å¯ŸããèŠæ±ãç§ãã¡ã®éžæã倧ããæžãããŸãã ããã¯ãã¹ãŠã倱æããæ€çŽ¢ã«æéããããããããšããäºå®ã«ã€ãªããå¯èœæ§ããããŸãã ããã¯ã圌ããèšãããã«ãè ã§ç«ã¡äžããå°é家ã§ã¯ãªãåŸæ¥å¡ãéãããšãç§ãã¡ã«åŒ·å¶ããŸãã
ã ããïŒåé¡è§£æ±ºã¹ãã«ã ãããããã§ãã¯ããã«ã¯ïŒ
- ç©äºã®ç解ãããã³ãã®ç解ã説æããèœåã 人ãè€éãªãã®ãå解ããªããã°ãªããªãã»ã©ãããåªãããã·ã³ã«ãŒããèšç·Žããããšãã§ããŸãïŒããã§ãªããã°ãä»ã«äœãé«çæè²ãæäŸããŸããïŒïŒã ããªãã®èãã説æ/äŒéããèœåã¯ãåé¡ã®è§£æ±ºã«å¿
èŠãªæèã®æå¿«ããšèª¿åã瀺ããŸãã ãããã£ãŠãçãã¯ç§ã®è³ªåã®ã¡ãªããã§ã¯ãªããæ··ä¹±ããããæœè±¡çãªèª¬æãããããããšãã«ãŒã«1ã䜿çšããŠããã«æéãç¯çŽã§ããŸãã
- ç©äºã®èª€è§£ ã ããã¯ãåè£è
ãäœãã䜿çšããããããªããããŠã©ã®ããã«æ©èœããããæ³åããªããšãã§ãã ç§ã¯ãããä¿åããã¯ãªãã¯ããŸãããããã¯æ©èœããŠããããã«èŠããããããããã¯èœã¡ããã°ãåºãŠãããªãã¯ãªãå°çãªã®ãç解ããã§ãããã ããã¯ãåé¡ãç解ããããã®æ inessãç¡èœåãŸãã¯äžæ¬æã瀺ããŠããå¯èœæ§ããããŸãã äžè¬çã«ãèèªãã€ãã¹ã
- äžè¬çãªå€ç®çãªçµéš ã å°ããã»ã©ãç解ããå¿
èŠãå°ãªããªãããã·ã³ã«ãŒãããã³ãã³ã°ãããªãå¯èœæ§ããããŸãã ãŸããã¯ãã¹ãã¡ã³ã¯ã·ã§ãã«ã¹ãã«ãå°ãªããªããŸãããã®éèŠæ§ã¯äžèšã§èª¬æãããŠããŸãã ããã©ããããè±å¯ãªçµéšã«ãããçŽæã®ã¬ãã«ã§äºæãã¬å°é£ããã°ãã解決ã§ããŸãã
- åé¡è§£æ±º ã è€éãªã¿ã¹ã¯ãšãããºã«ããæ©èœããªãããšã«æ°ä»ããŸããã ããã€ã³ã¿ãã¥ãŒã§ããäžæ°Žéã®ãã³ããŒã«ã¯ãªãäžžãã®ã§ããïŒããšãã質åã«çããããšéåžžã«é·ãéè©Šã¿ãŸãããããèœã¡ãªãããã«ããšããèããæãæµ®ãã°ãªããªããŸããã ããã«ã¯æŽå¯ãå¿
èŠã§ãããããã¯å¹žéã«äŒŒãŠããããããšã«ãããç§ã®æèŠã§ã¯ã¹ãã«ã¯è¡šç€ºãããŸããã çµå±ãç§ã¯èšã£ãïŒã圌ãã¯äžžãããªããªããåãç·ãåè§ããããã®ããã«åœŒãã®äžããåããããå°ãªãéå±ã圌ãã«è¡ãããã ãã ããã¯åè£è
ã®å¿èåãæ€èšŒããããšããã§ããŸãããããã¯ãã¡ããéèŠã§ã¯ãããŸããããããã¯é·ãããŠé人éçãªæ¹æ³ã§ãã
ãã®ããã«ãç§ã¯éãšæŽå¯åã®ãªãåçŽã§å®è¡å¯èœãªã¿ã¹ã¯ãæ¢ããŠããŸããããããã«ã¯ããã€ãã®è§£æ±ºçãå¿çã®æ·±ãããããŸãã ããã¯ãã¹ãŠãéžæããããœãªã¥ãŒã·ã§ã³ãã¹ããŒããæèã®æ瀺ã®èª¿åã«ãã£ãŠãåçãå®éçã«è©äŸ¡ã§ããããã«ããããšãç®çãšããŠããŸãã
Joel Spolskyã«ã¯ã ãã¹ããŒãã§ç©äºãæãéããããšããã¹ããŒã¬ã³/æ¡çšåºæºããããŸã ïŒãã¹ããŒãã§å®çšçããšç¿»èš³ããŸãïŒã äžèšã®ãã¹ãŠãã¹ããŒãããŒãã«é©çšãããŸããGetsthings doneããŒãã¯ããçæ³çãªããœãªã¥ãŒã·ã§ã³ã ãã§ãªãã顧客ã®ããŒãºãšèœåãèæ ®ããŠå®çšçãªãœãªã¥ãŒã·ã§ã³ãéžæããèœåãæå³ããŸãã ãã®ããã«ã¯ãã¯ã©ã€ã¢ã³ãèªèº«ã®ç 究ãçºæãžã®é¢å¿ã§ã¯ãªããã¯ã©ã€ã¢ã³ãã®ããžãã¹äžã®åé¡ãšãããžã§ã¯ãã®ç®æšã«çŠç¹ãåããç¶ããå¿ èŠããããŸãã ãããã£ãŠãçæ³çãªè³ªå/ã¿ã¹ã¯ã¯ããã¹ããŒãããšãç©äºãæãéããããšããäž¡æ¹ã®åºæºã瀺ãå¿ èŠããããŸãã
ãããŠãç§ãèŠã€ãã質åã¯æ¬¡ã®ãšããã§ãã
- æè¡ããã°ã¯ãããŸããïŒ ããããæžããŸããã èšäºïŒäŸïŒããïŒãŸãã¯æ¬ïŒ äŒè°ãäŒè°ãã¯ãŒã¯ã·ã§ããã§è©±ããŸããïŒäŒæ¥å
ãèæ
®ãããŸãïŒïŒ ãªãŒãã³ãœãŒã¹ãããžã§ã¯ãã«åå ããŠããŸããïŒ
ãããã®ãã¹ãŠã®æŽ»åã«ã¯ãäž»é¡ã®æé«ã¬ãã«ã®ç解ãããã«éèŠãªããšã«ãç¥èãäŒããèœåãšæ¬²æ±ãå¿ èŠã§ãã ãããã£ãŠããã¯ãããšããåçã¯éåžžã«å€§ããªãã©ã¹ã«ãªããŸãã ããããããšããçãã¯ãã€ãã¹ã§ã¯ãããŸããã
- å人çãªæè¡ãããžã§ã¯ãã¯ãããŸããïŒ
ãã¯ãããšããçãã¯ãä»äºã§ãéãããã£ãŠãããšããçç±ã ãã§ãªãã人ãä»äºãæããŠãããšèšãããšãã§ããŸãã ããã«ãå人ã®ITãããžã§ã¯ãã§ã¯ã誰ããèªåã§ãããªããã°ãªããªãããšãå€ããããã¯éèŠãªè·åãè¶ ããçµéšã瀺ããŠããŸãã
ããããããšããçãã¯ãã€ãã¹ã§ã¯ãããŸããã
質å1ãš2ã¯ãNikos Maravitsasã®æçš¿ããåŒçšãããŠããŸããNikosMaravitsasã§ã¯ãåè£è ãè©äŸ¡ããããã®ç¬èªã®æ¹æ³è«ãæäŸããŠããŸãã
- äžããããïŒçŽ30ããŒãžã®ããã¹ããå°å·ããã300ã®åèªãŸãã¯ãã¬ãŒãºã倪åã§åŒ·èª¿è¡šç€ºãããŠããWebããŒãžã
å¿ é ïŒéžæãããã¹ãŠã®åèªãã³ã³ãã§åºåã£ãŠåå¥ã®ãã¡ã€ã«ã«ã³ããŒãããããããäºéåŒçšç¬Šã§å²ã¿ãŸãã
ã¿ã¹ã¯ã¯1åã ãå®è¡ããïŒç¹°ãè¿ãããŸããïŒãå¯èœãªéãè¿ éã«è§£æ±ºããå¿ èŠããããã©ã®ãããªæ¹æ³ã§ãããŸããŸããã ãŸããäºæ³ããããœãªã¥ãŒã·ã§ã³ã®æšå®ãæéåäœã§æäŸããå¿ èŠããããŸãã
çŸåšã®ãããžã§ã¯ãã§ã¯ãæéåäœã§èŠç©ãããåºãããšã¯ãããŸããïŒã¿ã¹ã¯ã®è€éãã®é åºã®ã¿ãè©äŸ¡ããŸãïŒãããã®è³ªåã§ã¯3ã5åãã4æéã®èŠç©ãããèããŸããã ããã«ãããŠããããã¹ããæžãå¿ èŠããããšããããããå¹çãšé åºã®éã®ççŸãçãŸããæ¹æ³ã§ãã
å¯èœãªè§£æ±ºçïŒ
â¢jQueryåŒãfirebugãŸãã¯ããã«çžåœãããã®ã§å®è¡ããå®æããçµæãååŸã§ããŸãã 2åããããŸãã jQueryã®ååãªç¥èããªããŠããã®ã¢ãããŒãã«ååãä»ããå Žåãããã«å€§ããªãã©ã¹ã«ãªããŸãã
â¢XPathåŒã Linuxã®xmllintã³ãã³ããªã©ããã®åŒãå ¥åããå Žæãããã£ãŠããå Žåãããæ°ã«å ¥ãã®IDEã®å¯Ÿå¿ããæ©èœãç¥ã£ãŠããå Žåã«äŸ¿å©ã§ãã ãã®åŒãå ¥åããå Žæãç¥ãïŒãŸãã¯ããã«èããïŒå¿ èŠããããšããäºå®ã«å ããŠãxmlãšhtmlã®å 容ãç°ãªãããšãç解ããå¿ èŠããããŸãã ãããç解ããããxmllint / IDEãhtmlã§åäœãããã©ãããç¥ãå¿ èŠããããŸããäžæãªå Žåã¯ãhtml-> xmlã«å€æããæ¹æ³ãèããããšãã§ããŸãã ã°ãŒã°ã«æ¹åŒã§ã¹ãã£ã³ããŸãããæŽé ã«ã€ããŠèããå Žåã¯éåžžã«äŸ¿å©ã§ãã ãããšã¯å¥ã«ãxpathåŒãã³ã³ãã€ã«ããã³ãããã°ããããã®æéã®èŠç©ããã®ââ劥åœæ§ããã§ãã¯ããŸãã
â¢RegExp-ãã¡ã€ã«äžã§æ£èŠè¡šçŸã調ã¹ãŠããã¹ãŠã®ã倪åãã¿ã°ãéžæããŸãã ããã§çç±ã確èªããŸã-æ£èŠè¡šçŸãå ¥åããå ŽæïŒã©ã®ããã°ã©ã /ã³ãã³ãïŒïŒ ç¡ç¥ã§ãç§ãã¡ã¯å¥œããªèšèªã§ãã®ããã®ããã°ã©ã ãæžãå§ããŸãã 次ã«ãæ£èŠè¡šçŸã®ã欲ãã«å¯Ÿããç解ã確èªããŸãã ãããŠæåŸã«ãåè£è ã®è©äŸ¡ãšæ±ºå®ã®è€éããæ¯èŒããŸãã ã€ãŸããåè£è ãïŒãã®å Žåã®åäœãã¹ãã§ãïŒjavaã§ããã°ã©ã ãäœæããäžè¬çã«æ£èŠè¡šçŸãç解ããããããªèŠç©ãããäžããããšãéžæããå Žåãããã¯ééããªããã€ãã¹ã«ãªããŸãã
â¢ãæ°ã«å ¥ãã®èšèªã§ããã°ã©ã ãäœæããŸããããã«ãããã倪åãã¿ã°ã®éã®ããã¹ãã匷調衚瀺ãããŸãã ãœãŒã¹ããŒã¿ãžã®ã¢ã¯ã»ã¹æ¹æ³ãªã©ããããè¡ãæ¹æ³ã®ã¢ã«ãŽãªãºã ãæããŠãã ããã ã¢ã«ãŽãªãºã ãè¿ éãã€æ確ã«äŒããããè©äŸ¡ãåè£è ã®ä¿¡é ŒåºŠã«å¯Ÿå¿ããå Žåãããã¯éåžžã«éåžžã®ãªãã·ã§ã³ã§ãã 人ãç¹å¥ãªç¥èãçµéšãå¿ èŠãšããªãåçŽãªããšã§æ··ä¹±ããå Žåãããã¯ãæçšããŠèŠãããããæçšããæ¹ãè¯ãããšããã«ãŒã«ãé©çšããæ©äŒã§ãã
â¢æåã§ã äžè¬çã«çŽ æŽããããªãã·ã§ã³ã§ãã æšå®å€ã¯ãä»ã®ãªãã·ã§ã³ã§ããè³ã«ããæšå®å€ãããå°ããäºæž¬å¯èœãªããã§ãã æ確ãªãã©ã¹ããã®ãªãã·ã§ã³ã®è©äŸ¡ãé©åãªå Žåã¯ãæ£èŠè¡šçŸã䜿çšããŠåŒçšç¬Šã§å²ã¿ãã³ã³ãã§åºåããšããã«è¯ããªããŸãã ãã³ããŒãããšãã®1æåã®ãšã©ãŒã¯ã©ãã»ã©é倧ã§ããïŒããšå°ããããå Žåã2ã€ã®ãã©ã¹ããããŸããããã¯ãèŠä»¶ã®ããããªæ¹è¯ã«ããããœãªã¥ãŒã·ã§ã³ã®ã³ã¹ããæ°ååæžã§ããå Žåã§ãã äžè¬ã«ãåè£è ããã®ããæ確ãªè³ªåãåççã«ããã°ããã»ã©è¯ãã§ãã
人ããã®ãããªãæåãäœæ¥ã®æéãé©åã«èŠç©ããããšãã§ããªãå ŽåããŸãã¯ãã®ãããªãªãã·ã§ã³ãå®å šã«èæ ®ããããšããæåŠããå Žå-æ確ãªãã€ãã¹ã
ç§ã®æèŠã§ã¯ããã¹ããŒãããšãç©äºãæãéããããšããåºæºã®äž¡æ¹ãæãããçŸããã®ã¯ãŸãã«ãã®ãããªè³ªåã§ãã
- æå®ïŒ4ã€ã®æ°å€åãš1000è¡ã®1ã€ã®ã·ãŒããå«ã.xlsïŒExcelïŒãã¡ã€ã«ã
å¿ é ïŒSQLããŒã¿ããŒã¹ã«ã¢ããããŒãããŸãã察å¿ããåãæã€ããŒãã«ã䜿çšå¯èœã§ãã ãŸãã解決ããæéãè©äŸ¡ããŸãã
â¢èªä¿¡ãæã£ãŠçã-ç§ã¯ãã®ãããªããŒã«ã䜿çšããŸãã ãã®ãããªçãã¯ç§ã«ã¯äœã®æå³ããããŸãããããŒã«ã®ç¥èãããã°å¹žéã§ããã
â¢csvã§ãšã³ãããŒããäœæãããã®ãããªããŒã«ã䜿çšããŸãã ãã§ã«ãã£ãšé¢çœããå€æãèããã å°ããªãã©ã¹ã
â¢CSVã§ãšã³ãããŒããäœæããCSVããããŠã³ããŒãããããã«çµã¿èŸŒã¿ã®SQLãµãŒããŒæ©èœã䜿çšããŸãã ããã«èå³æ·±ãã®ã¯ãããããDBMSããã¡ããšæ±ã£ããšæžãããŠããããã§ããããã¯ãã°ãã°å©ãã«ãªããŸãã ããã«å€ãã
â¢ããŒã«ãã°ãŒã°ã«ã§æ€çŽ¢ãããšããã®ããã«ãªãã¯ãã§ãã ããã«ããã®æèœãšãèªè»¢è»ã®çºæã®ããã«å€ãã®æéãè²»ãããªãã£ããšããäºå®ã®ããã«ã ãã°ãŒã°ã«ãã®è©äŸ¡ã®åŠ¥åœæ§ãèŠãŠãã ãã
â¢csvã®ãšã³ãããŒãã...ã«æ¿å ¥ããã·ã§ã«ã¹ã¯ãªãããèšè¿°ããŸãã åŒãå®è¡ããSQLãµãŒããŒã§å®è¡ããŸãã é©åãªè©äŸ¡ãããã°ããã©ã¹ã«ãªããŸãã
â¢Excelãã¡ã€ã«ã«åãè¿œå ããŸãããã¹ãŠã®ã»ã«ã«ãæ¿å ¥ãããã»ã«ãæ¿å ¥ïŒã¹ãã¬ããïŒããã«ã³ãã䜿çšããŠè¿œå ã®åãäœæããSQLã¹ã¯ãªãããååŸããŸãã ããã«ãã©ã¹ã«ãªããŸãããè©äŸ¡ããå¿ èŠãããŸããã
â¢ããã°ã©ã ã®äœæãéå§ããŸãã ããã¯éåžžæªãããšã§ãã CSVã«å€æããŠç°¡åãªåœ¢åŒã§äœæ¥ããããšãæšæž¬ããè©äŸ¡ãæ£ãããã°ãäœããããŸããã ãã ããExcelã§ã®äœæ¥ã«è€éãªã©ã€ãã©ãªã䜿çšãå§ããå ŽåããŠããããã¹ããäœæãã8æéã®çŽç²ãªæéã§ã¿ã¹ã¯ãè©äŸ¡ããŸãã
åãã«ãç§ã¯ãã€ã説æããŸã-質åã§ç¢ºèªãããããšã¯ã人ã ãç¹ã«ç°¡åãªãªãã·ã§ã³ãé®æããªãããã«ããããã§ãã
ãããããããã€ãã®ããã°ã©ãã³ã°ã¿ã¹ã¯ããããªãã§ã é»è©±ãè³ã«åœãŠãŠè§£æ±ºããå¿ èŠãããããšã«æ³šæããŠãã ããã
- æå®ïŒNåã®ä¹±æ°ã®é
åã
å¿ èŠïŒé åããæ倧ã®Kæ°ãèŠã€ããã¢ã«ãŽãªãºã ã®è€éããè©äŸ¡ããŸãã ç§ã¯ãK <ïŒN / 2ïŒãNã¯å€§ããªæ°ãé«éãªã¢ã«ãŽãªãºã ãéèŠã§ããããšãã¡ã¢ãªæ¶è²»ãæ°ã«ããªãããšãæå®ããŸãã
ãã®åé¡ã¯æãããªè§£æ±ºçãããã®ã§æ°ã«å ¥ã£ãŠããŸãïŒå®è·µã§ç¢ºèªãããŠããŸãïŒããæé©ã§ã¯ãããŸããã 人ãããèªäœã§ã¯æé©ã§ã¯ãªãããšãç解ã§ãããã©ããããããŠæé©ãªãœãªã¥ãŒã·ã§ã³ã«ã©ãã ãæ©ãå°éããããæ€èšããŸãã ã»ãšãã©ã®å Žåãç§ãã¡ãåŸãŠãåè£ã«ã€ããŠã®èãã¯ã圌ãã®èãã«ã³ã¡ã³ããã人ã ã®ããã«ãããªãããæããã«ãªããŸãã 次ã«ãã¢ã«ãŽãªãºã ã®è€éãã®æŠå¿µã«å°éããŸããéåžžã®çãã¯OïŒN * log KïŒã§ãã
ããããæ°åãæªãå Žåã¯ãæ°åãã©ã³ãã ã§ãããå€ãã®æ°åãããããšãæãåºããŠã確çè«ã«åºã¥ããŠåé¡ã解決ããããšãã§ããŸãã
ãã®å Žåãåçã¯å®è³ªçã«OïŒN * log KïŒãããå°ãããªããŸãã ã©ã£ã¡ïŒ ç§èªèº«ã¯ç¥ããŸããã
- æå®ïŒãå€ãã®é
åãšå¯Ÿå¿ããæ°å€ä¿æ°ã éžæã®ç¢ºçã察å¿ããä¿æ°ã«æ¯äŸããããã«ãå€ã®1ã€ãä»»æã«éžæããé¢æ°/ã¡ãœãããèšè¿°ããå¿
èŠããããŸãã ã€ãŸããä¿æ°ã倧ããã»ã©ã察å¿ããå€ãçºè¡ãããé »åºŠãé«ããªããéã®å Žåãåæ§ã§ãã
ãã®ãããªæçœãªã¿ã¹ã¯ã§ã¯ãããŸããããããªã解決å¯èœã§ãã 決å®ã®æéãšé²æãè©äŸ¡ããŸãã
- ããã§ã¯ã質åã§ãããWebããã°ã©ããŒïŒç§ã®å Žåã¯JavaïŒã®äžè¬çãªã¬ãã«ã®ç¥èãæããã«ããããã«ã誰ããèå³ãæã€ãããããŸããã
-
<span> <div>
ã®éãã説æããŸãã å€ãã®äººã¯ç¥ã£ãŠããŸãããå®éã«èª¬æããããšã¯ã§ãããæ··ä¹±ããŸããããã¯ãã€ãã¹ã§ãã - Javascriptã§ããããã¿ã€ããšã¯äœãã説æããŸãïŒãã¬ãŒã ã¯ãŒã¯ã®ååãæå³ããªãã®ã§ããïŒïŒ jQueryïŒïŒã¡ãœãããå¥å$ïŒïŒã«æž¡ãããšãã§ãããã®ã¯äœã§ããïŒ
- HTTPã§ã¯ãããŒãã¢ã©ã€ããšã¯äœã§ããïŒ
- åããµã€ãã®2ã€ã®ç°ãªãããŒãžïŒåããã¡ã€ã³ïŒã§ãåãããŒãæã€Cookieãç°ãªãæå³ãæã€ããšã¯ãããŸããïŒ ããïŒ ãããŠãç°ãªããµã€ãã§ïŒ
- TCPãšUDPã®éãã 銬鹿ãã質åã§ããã圌ãã¯éåžžãçããç¥ã£ãŠããããšãããããŸããã誰ããçããªãå Žåãç§ã«ãšã£ãŠããã¯çãããã§ãã ãŸãã圌ãã¯èªä¿¡ãæã£ãŠå®å šãªãã³ã»ã³ã¹ãèšãããšãèµ·ãããŸããããã¯ãããããªããã°ãŒã°ã«ã§æ€çŽ¢ããããããã¯ããã«æªãããšã§ãã
- base64ãšã¯äœã§ããïŒ
- ç°ãªããã¡ã€ã³éã§ajaxãªã¯ãšã¹ããè¡ãããšã¯å¯èœã§ããïŒ ã©ããã£ãŠïŒ
- SOAPãšRESTã®åºæ¬çãªéãã説æããŠãã ããã ç§ã¯çãã®æå¿«ããšç°¡æœããèŠãŠããŸãã ãããããªãããããã§ãã
- 2ã€ã®äžŠåã¹ã¬ããã䜿çšããŠçç£è /æ¶è²»è ãã¿ãŒã³ãå®è£ ããæ¹æ³ã ïŒãã¿ãŒã³ã®æ¬è³ªã説æããŸã
- xmlã®äœ¿çšçµéšã¯ãããŸããïŒ ãããããªããã©ã®ãããªæè¡ã䜿çšããŠãã©ã®ããã«ïŒ
- / path軞ããã®äžã«ããxpathãç¥ã£ãŠããŸããã
- Linuxã§ã®çµéšã¯äœã§ããïŒ Linuxãšãã®ã³ãã³ãã«é¢ããååãªç¥èãããã°ãéåžžã«è€éãªæ¥åžžã®ã¿ã¹ã¯ãè¿ éã«è§£æ±ºïŒãŸãã¯èªååïŒã§ãããããå¹çã«å€§ãã圱é¿ããŸãã å ¥åããã³ãã³ãã®å±¥æŽãæ€çŽ¢ããæ¹æ³ã¯ïŒ sedãawkãsudoãpsãtopãgrepã®ç¥èã¯ãããŸããïŒ ãã€ãã䜿çšããŠããŸããïŒ ã·ã§ã«ã¹ã¯ãªãããäœæããŸãããïŒ
- æ£èŠè¡šçŸã®ç¥èïŒ
- é »ç¹ã«äœ¿çšãããããããŒããæ¥åžžçãªã¿ã¹ã¯èªååã®äŸã¯äœã§ããïŒ ãã¹ãŠã®åºæ¬çãªã¢ã¯ã·ã§ã³ããããããŒã§è¡ãããã»ãšãã©ã®ã«ãŒãã³ãèªååãããŠãããšããçç±ã ãã§ãå¹çã¯åžžã«èããèœåã§ãããšã¯éããŸããã
SQLã«é¢ãã質åã
- å éšçµåãšå€éšçµåã®éãã¯ïŒ éããæ確ã«èª¬æããèœåãèŠãŠããŸãã
- ãã©ã³ã¶ã¯ã·ã§ã³åé¢ã¬ãã«ã 説æã§ããŸããïŒ æ¡ã®å®ãã¯ãã
- åAã«2å以äžè¡šç€ºããããã¹ãŠã®æ°åã衚瀺ããã«ã¯ã©ãããã°ããã§ããïŒ
- éãå¢ããæ¹æ³ã¯ïŒ ããšãã°ãåæ¥ä»ã®æ¥ä»ãšå£²äžé«ã®è¡šããããåæ¥ä»ã«ã€ããŠã幎ã®åããããã®æ¥ä»ãŸã§ã®å£²äžé«ã衚瀺ããå¿
èŠããããŸãã ïŒæã§èª¬æããæ¹ãç°¡åã§ãïŒ
ããã°ã©ãã³ã°ã§ã¯ãåé¡ã解決ããéçšã§ç¥èãèå¥ãããŸãããããã§ãåºæ¬ãå°ããŸãã
- ãã¡ã€ã«ã1è¡ãã€èªã¿åãæ¹æ³
- TreeMapãšHashMapã®ä»çµã¿ã説æããŸãã ç§ã®æèŠã§ã¯ããããã¯ããã°ã©ãã«ãšã£ãŠäžå¯æ¬ ãªåºç€ã§ãã
- ãŸããšArrayList察LinkedListã 100äžåã®åäžãªããžã§ã¯ããæåŸã«è¿œå ãããšãã©ããéããªããŸããïŒ ArrayListã¯æ¡åŒµäžã«å éšé åãæ°åã³ããŒãããããæ£ç¢ºã«èšãã®ã¯å°é£ã§ãïŒåæ容éã¯æ¡ä»¶ã«ãã16ã§ãïŒã LinkedListã¯ããªã³ã¯ãä¿åãããæ¿å ¥ãããèŠçŽ ããšã«è¿œå ã®ãªããžã§ã¯ããäœæããŸãã éåžžã圌ãã¯éåžžã«èªä¿¡ãæã£ãŠçããŸãïŒåœŒãã¯åœŒãããéããªããšèšããé åºã«ä»ã®äººãããéãã§ããçç±ã«çããããããŸããã
ããã§ã¯ãäžè¬ã«ãç§ã®æè¡é¢æ¥ã®ãã¹ãŠã®åºæ¬çãªè³ªåã¯1æéåããããŸãã æéãããå Žåã¯ãæ·±ãæãäžããŠã以åã®ãããžã§ã¯ãã«ã€ããŠå°ããŸãããéåžžããããã®è³ªåã¯ç§ã®ç¹å®ã®ç©ºåžã«ã€ããŠæ±ºå®ããã®ã«ååã§ãã ïŒ ãã¡ãããããªãã®å Žåããã¹ãŠãç°ãªããŸã ïŒã
Webããã°ã©ããŒã®æå¹æ§ãããããå®èšŒã§ãã質åã誰ããç¥ã£ãŠããå Žåã¯ãã³ã¡ã³ããæè¿ããŸãã
ã€ã³ã¿ãã¥ãŒã§é 匵ã£ãŠãã ããã