ããã¯ã9æã«Webãµã€ãNomagic.ruã§å ¬éãããIvan Nikitinã«ããèšäºã®åçã§ãã ãã®èšäºã«ã¯ãåé¡ã®èª¬æãšå¯èœãªè§£æ±ºçã®èª¬æã®ã¿ãå«ãŸããŠããŸãã ASPããã³PHPã§ã®LiveSearch APIã®åé¡ã®è§£æ±ºçã説æããèšäºãžã®ãªã³ã¯ã¯ãèšäºã®æåŸã«ãããŸãã
ã³ã³ãã³ããå«ã5ã10ããŒãžãè¶ ããææ°ã®ãµã€ãã«ã¯ãæ€çŽ¢ãšã³ãžã³ãå¿ èŠã§ãã ãšã«ãããããã²ãŒã·ã§ã³ããŒããµã€ãã®è£œå/ã»ã¯ã·ã§ã³ã®ã«ã¿ãã°ãã©ã®ããã«èšç»ãããšããŠããæçµçã«ã¯ããµã€ãã®101çªç®ã®ãŠãŒã¶ãŒã«ãšã£ãŠçŽæçã«äœç³»åããããšããè©Šã¿ã¯ç解ã§ããŸãã ã
ãããããã§ããããšã確èªãããã§ããïŒ ããã«ããã€ãã®ç°¡åãªã¿ã¹ã¯ããããŸãããããã«æ°åãè²»ãããŠã¿ãŠãã ããïŒãã¹ãŠã®äŸã¯ãç§ãå人çã«ç¥ã£ãŠèšªåãããµã€ãã®ãªã¹ãããå¶ç¶ã«æ®åœ±ããããã®ã§ãã
- ãµã€ãïŒ http://www.specialist.ru/ ïŒã§æ€çŽ¢ïŒæ€çŽ¢ã䜿çšããã«ïŒïŒMicrosoft SharePoint 2007ã®2ïŒ2ïŒã³ãŒã¹ãããã«è²»ãããæéãèšé²ããŸãã
- ãµã€ãhttp://www.sipnet.ruã§ãVoIP D-Link DVG-2001Sã²ãŒããŠã§ã€ãSipnetãµãŒãã¹ã§åäœããããšã®ç¢ºèªãšããã®ç°¡åãªèª¬æãèŠã€ããŸãã ããªããããã«è²»ãããæéãæžãçããŠãã ããã
- ãµã€ãwww.megafon.ru㧠ã2006幎ã®äœæ¥çµæã«é¢ããå¹Žæ¬¡å ±åæžãMicrosoft Word圢åŒã§ïŒæ€çŽ¢ã䜿çšããã«ïŒæ€çŽ¢ããŸãã æåããŸãããïŒ
ç¶è¡ããå¿ èŠããããŸããïŒ ããªãã¯ãã§ã«ç§ã«åæããŠãããšæããŸãã ãããŠããµã€ãã®éçºè ãçã«ããªã£ãŠããããã«ãæ€çŽ¢ãšã³ãžã³ãäœæãããšããåé¡ã«çŽé¢ãããšãã§ãã æ®å¿µãªãããã»ãšãã©ã®éçºè ã¯ãã®ãœãªã¥ãŒã·ã§ã³ã®è€éããéå°è©äŸ¡ããŠãããæ€çŽ¢ãSQLã¯ãšãªã«æžããïŒåçŽåããïŒããšãã§ãããšèããŠããŸãã
SELECT * FROM products WHERE
title LIKE '%-%'
OR description LIKE '%-%'
ãã®ããããã®ãããªæ€çŽ¢ã®å€ã®ã¿ããŒãã«ãªããŸãã ãã¡ãããè€éã«ããããåèªãšãã®çµã¿åããã§æ€çŽ¢ãè¿œå ãããããããšãã§ããŸãïŒãµã€ãã§ããèŠããããã¬ãŒãºã«å¿ãæãããŸãïŒã ANDãORãNOTã䜿çšã§ããŸã ããããïŒããŒã«ä»£æ°ããŠãŒã¶ãŒã«èª¬æããŸãïŒã ãããããã®ãããªæ€çŽ¢ã®åé¡ã¯ãéçºè ããŠãŒã¶ãŒã補ååããã¥ãŒã¹ã®èŠåºãããµã€ãã«è¡šç€ºãããŠãããšããã«å ¥åãã ãšä¿¡ããŠããããŠãŒã¶ãŒãçŸåšå¿ èŠãªãã®ãå®å šã«ä»»æã®åœ¢åŒã§å ¥åããããšã§ãããŠãŒã¶ãŒã§ãã圌ã¯ãååãšããŠã1ã€ãŸãã¯2ã€ã®åèªã§æ§æãããçãã¯ãšãªãå ¥åããŸãã ã€ãŸãããŠãŒã¶ãŒã¯SharePoint 2007ã®ã³ãŒã¹ãæ¢ããŠããã®ã§ããWindows SharePoint Services v3ãã§ã¯ãªããSharePoint 2007ããšèšè¿°ããŸãã ãã®çµæããã®ãããªæ€çŽ¢ã¯çµæãšããŠæ°çŸã®ãªã³ã¯ããã³ãããæ€çŽ¢ã®çµæãšããŠäœããèŠã€ããããšãäžå¯èœã«ãªãããäœãè¿ããªããããå®å šã«åäœããªãæ€çŽ¢ãšã³ãžã³ãååŸããŸãã 確èªãããã§ããïŒ å€§ããªéçºäºç®ãæã€2ã€ã®åŒ·åãªãªãœãŒã¹ã䜿çšããŠããããã®æ€çŽ¢ããã¹ãããŠã¿ãŠãã ããã
- ãµã€ãwww.mts.ruã§ãæ€çŽ¢ã䜿çšããŠãé話æéãæ¯æãããã®ã¯ã¬ãžãããã©ãŒã ãèŠã€ããŸããã€ãŸãããããã©ã®ããã«æé
ããé話æéãæ¯æãã...ã©ã®ãããªãªã¯ãšã¹ããå
¥åããŸããïŒ ã ãæ¯æãæ¹æ³ ã çµæã¯æ¬¡ã®ããã«ãªããŸãã
- ãŠã§ããµã€ãwww.alfabank.ruã§æµåœè²žä»ã«é¢ããæ
å ±ãèŠã€ããŠãã ããã ã©ã®ã¯ãšãªãå
¥åããŸããïŒ ã äœå®
ããŒã³ ãã çµæã¯æ¬¡ã®ãšããã§ãã
ã©ã¡ãã®å ŽåãåŠå®çãªçµæãåŸãããããšã¯ç°¡åã«çœ®ãæããããšãã§ããŸãã æåã®ã±ãŒã¹ã§ã¯ãäœãåãåããŸããã§ãããã2çªç®ã®ã±ãŒã¹ã§ã¯-ãŸã£ããäžèŠãªæ å ±ïŒäœå® ããŒã³ã«é¢ãããããŒãžã®ãªã³ã¯ãã©ãã§ãããïŒïŒ ã©ã¡ãã®å Žåã§ãã æ€çŽ¢ã«å€±æ ãããšãã¯ã©ã€ã¢ã³ãã¯æ°žä¹ ã«éå»ããããšããããŸã ãé話æéãæ¯æãããã®ã¯ã¬ãžãããã©ãŒã ããªãããïŒå®éã«ã¯ãããŸãïŒïŒãMCTã«åãæ¿ããŸãããäœå® ããŒã³ã®æ¡ä»¶ãèŠã€ããŸãïŒãããåãªãäŸã§ãïŒå人çãªãã®ã¯ãããŸããïŒïŒã
ãã®åé¡ã解決ããã«ã¯ïŒ
å¹æçãªæ€çŽ¢ã®å®è£
第äžã«ãåªããæ€çŽ¢ã¯äºçŽ°ãªäœæ¥ããã»ã©é ãããšãèªèããå¿ èŠããããŸãã ããã«èšãã°ãè¯ãæ€çŽ¢ãå®è£ ããè€éãã¯ããµã€ãå šäœã®æ©èœãå®è£ ããè€éããã¯ããã«è¶ ããŠããŸãã ãããã£ãŠããã®ãããªã¿ã¹ã¯ãèšå®ããåã«ã100åèããå¿ èŠããããŸãã 圢æ åŠçåæã·ã¹ãã ãããã¥ã¡ã³ãã®é¢é£æ§ã®è©äŸ¡ãçµæã®ã©ã³ã¯ä»ãã®ã¢ã«ãŽãªãºã ã®äœæãéå§ããæºåã¯ã§ããŠããŸããïŒ ãããŠæãéèŠãªããšã¯ããããäœæéãäœåè¡ãã®ã³ãŒãã§å®è¡ããæºåãã§ããŠãããšããããšã§ãã
ããããããã§ããã®åé¡ã¯è§£æ±ºã§ããŸãïŒ è§£æ±ºããæ¹æ³ã¯å°ãªããšã3ã€ãããŸãã
- æ€çŽ¢ãšã³ãžã³ãã©ãŒã ã®äœ¿çš
- å©çšå¯èœãªWebãµãŒãã¹ã䜿çšãã
- ãµãŒãããŒãã£ã®ãœãªã¥ãŒã·ã§ã³ã䜿çšãã
ãããã®æ¹æ³ã¯ãã¹ãŠã人件費ãã³ã¹ããããã³åŸãããçµæãç°ãªããŸããã3ã€ã®æ¹æ³ã¯ãã¹ãŠãäžèšã®äŸãããæ¡éãã«é«ãå質ã®çµæããããããŸãã
æ€çŽ¢ãšã³ãžã³ãã©ãŒã ã®äœ¿çš
ããã¯æãå®äŸ¡ã§å®è£ ãç°¡åã§ãã çã®äœå質ã®æ€çŽ¢ã³ãŒããèšè¿°ãã代ããã«ããµã€ãã®ããŒãžã«ãã©ãŒã ãåã蟌ãã§ãæ€çŽ¢ãšã³ãžã³ã«ãªã¯ãšã¹ããéä¿¡ããŸãã ãã®ãããªã·ã¹ãã ãšããŠãGoogleã®äœ¿çšæ¹æ³ã瀺ããŸãããä»ã®æ¹æ³ã䜿çšã§ããŸããããšãã°ãYandexã®åœ¢åŒã¯æ¬¡ã®ãšããã§ãïŒ http : //company.yandex.ru/forms/ ã ç§ã®æèŠã§ã¯ããã®æ€çŽ¢å質ã¯ä»ã®æ€çŽ¢ãšã³ãžã³ãããã¯ããã«é«ããããGoogleã®ã»ãã奜ãã§ãã
ãããã£ãŠã次ã®ããã«æç»ããŸãã
<form method="get" action="http://www.google.com/search">
<input type="hidden" name="ie"
value="windows-1251" />
<input type="hidden" name="domains"
value=" www.specialist.ru " />
<input type="hidden" name="sitesearch"
value=" www.specialist.ru " />
<input id="searchBarInput" type="text" name="q"
value="" />
<input id="searchBarSubmit" type="submit"
value="!" />
<div>
<a id="extendedSearchLink" href="http://google.com/">
<span>Powered by <span style="color:blue">G</span>
<span style="color:red">o</span>
<span style="color:olive">o</span>
<span style="color:blue">g</span>
<span style="color:green">l</span>
<span style="color:red">e</span></span></a>
</div>
</form>
Googleãæ€çŽ¢ãæäŸããŠããããšã瀺ãããšã¯å¿ é ã§ãã 以äžã§ãïŒ é衚瀺ãã£ãŒã«ãã®ãããæå®ããããµã€ãã§ã®ã¿æ€çŽ¢ããããGoogleã«äŸé ŒããŸãã ããã«ãæ€çŽ¢ã®å質ã¯ãäžèšã®äŸãããæããã«é«ããªããŸãã 確èªããŸãããïŒ

æåã®ãªã³ã¯ã¯ãMTS Webãµã€ãã§ã®ã¯ã¬ãžãã決æžåœ¢åŒã®èšèšã瀺ããŠããŸãã
ã¢ã«ãã¡éè¡ã®äŸïŒ

æåã®çµæã¯ãã¢ã«ãã¡ãã³ã¯ã®äœå® ããŒã³ã«é¢ãããã¹ãŠã®æ å ±ã§ãã
ãã¡ããããã®æ¹æ³ã®ãã¹ãŠã®åçŽãã§ããã®æ¬ ç¹ã¯ããã«ç®ãåŒããŸãïŒãŠãŒã¶ãŒã¯ããªãã®ãµã€ãããæ€çŽ¢ãšã³ãžã³ã«è¡ããŸãã å®éãããèªäœã¯ããã»ã©æããã®ã§ã¯ãããŸãããæ€çŽ¢ãšã³ãžã³ããããªããšããªãã ãã«æ»ããã¹ãŠã®ãªã³ã¯ãããããã§ãããã ããããã«ã³ã³ããã¹ãåºåããããŸãã ã¢ã«ãã¡éè¡ã¯ãåæ§ã®ã¹ããŒã ã䜿çšããåæ§ã®ææ¡ã«åæãããšã¯æããªãã :-)
ããã§ãããã®æ¹æ³ã¯ãäœäºç®ãŸãã¯éå¶å©ã®ãµã€ãã«åŒ·ããå§ãã§ããŸããããã¯ãæ€çŽ¢ã®å質ãã³ã³ããã¹ãåºåãšãã圢ã§ã®ãã¬ãã£ããªåŽé¢ãã¯ããã«äžåãããã§ãã
å©çšå¯èœãªWebãµãŒãã¹ã®äœ¿çš
ãã®æ¹æ³ã§ã¯ãæ€çŽ¢çµæã«ä»ã®äººã®åºåã衚瀺ããããšãæåŠããããšããŸãã å€ãã®æ€çŽ¢ãšã³ãžã³ã¯ãèªåæ€çŽ¢ã®ãµãŒãã¹ãæäŸããŸãã ããã¯Yandex.XMLïŒ http://xml.yandex.ru/ ïŒãããã³GoogleãµãŒãã¹ãªã©ã§ãã äžè¬çãªæå³ã¯ããŠãŒã¶ãŒã®ãªã¯ãšã¹ãããµãŒããŒã«éä¿¡ããæ€çŽ¢ãã©ãŒã ãæäŸããããšã§ãããµãŒããŒã¯ãŠãŒã¶ãŒã®ãªã¯ãšã¹ããæ€çŽ¢ãšã³ãžã³ã«æž¡ããŸãã çµæãåãåã£ãåœç€Ÿã®ãµãŒããŒã¯ãåœç€Ÿã®ãŠã§ããµã€ãäžã§ããããããã¶ã€ã³ã圢åŒã§ãããã衚瀺ããŸãã ãŠãŒã¶ãŒã¯ãç§ãã¡ã®ãµã€ãã®ãã¶ã€ã³ã§çµæãèŠããããæ€çŽ¢ãå€éšã·ã¹ãã ã«ãã£ãŠå®è¡ãããããšã«ããæ°ä»ããŸããã 確ãã«ãYandex.XMLã«ã¯å®å šã«ç解ã§ããªãã©ã€ã»ã³ã¹ã·ã¹ãã ïŒYandex.Directåºåã䞊è¡ããŠè¡šç€ºããããã®èŠä»¶ïŒããããGoogleã¯çŽ1幎åã«åæ§ã®ãµãŒãã¹ãéãã«ééããŸããã ã
ããããããã§è§£æ±ºçãèŠã€ããããšãã§ããŸãã Microsoftã«ã¯ãLive.comæ€çŽ¢ïŒ http://dev.live.com/livesearch/ ïŒãæäœããããã®APIããããããã«ããïŒAPIã¯ãitãã§ãïŒåæ§ã®ã·ã¹ãã ãå®è£ ã§ããŸãã 確ãã«ããã®APIã¯1æ¥ãããã®ãªã¯ãšã¹ãæ°ãçŽ1000ã3000ãªã¯ãšã¹ãã«å¶éããŠããŸãããããã¯äžèŠæš¡ãµã€ãã«ã¯ååã§ãã
ãã®ãããªæ€çŽ¢ãå®è£ ããããšã¯ãç¹ã«Live Search APIãXML WebãµãŒãã¹ãžã®SOAPåŒã³åºããæäŸããããããããã®åŒã³åºããä»»æã®ãã©ãããã©ãŒã ããã³ãµã€ãéçºããŒã«ïŒPHPãASP.Netãªã©ïŒããå®è¡ã§ãããããå®å šã«è€éã§ã¯ãããŸããã
å°ãåã«ããµã€ãSpecialit.ruã®æ€çŽ¢ãäœæããå¿ èŠãçãããšãã«ããã®ãããªæ€çŽ¢ã®å®è£ ãè¡ããŸããã http://search.specialist.ruã§åäœã確èªã§ããŸãã
ãã®ãããã¯ãèå³æ·±ããšæãããå Žåã¯ãåºçç©ãžã®ã³ã¡ã³ãã«ãã£ãŒãããã¯ãææ¡ãæ®ããŠãã ããã次ã®èšäºã§ã¯ãLive Search APIã«åºã¥ãæ€çŽ¢ãšã³ãžã³ã®å®è£ ã³ãŒãã®è©³çŽ°ãªäŸã瀺ããŸãã ç§ãä¿¡ããŠããã¹ãŠãäžèŠæãããããããã£ãšç°¡åã§ãã :-)
ãµãŒãããŒãã£ã®ãœãªã¥ãŒã·ã§ã³ã䜿çšãã
ãã ããLive Search APIãªã©ã®å©çšå¯èœãªWebãµãŒãã¹ã䜿çšããæ¹æ³ã«ã¯ã2ã€ã®å€§ããªæ¬ ç¹ããããŸãã
- ãªãœãŒã¹ã®åã€ã³ããã¯ã¹ä»ããè¿ éã«ç®¡çã§ããªã
- ãµã€ãã®éããã»ã¯ã·ã§ã³ã§ã®ã€ã³ããã¯ã¹äœæã®äžå¯èœæ§ïŒããã³æ€çŽ¢ã®çµæïŒ
æåã®æ¬ ç¹ã¯ãæ€çŽ¢ãšã³ãžã³ããããããµã€ãèªäœã®æŽæ°ã¹ã±ãžã¥ãŒã«ãã€ã³ããã¯ã¹èªäœã«èšå®ããããšãã°ããµã€ããæ£ããHTTP Last-Modifiedå¿çããããŒïŒã€ã³ã¿ãŒãããäžã®ãµã€ãã®90ïŒ ã®ç æ°ã§ãïŒïŒãæäŸããªãå Žåã§ããéèŠã§ããã ã€ãŸãããµã€ãã«æ°ããè³æã衚瀺ãããŠãããæ€çŽ¢çµæã«è¡šç€ºããããŸã§ã«æ°æ¥ãå Žåã«ãã£ãŠã¯æ°é±éãããå ŽåããããŸãã
2çªç®ã®æ¬ é¥ã¯äžè¬ã«èŽåœçã§ãã æ€çŽ¢ãšã³ãžã³ããããã¯ããµã€ãã®ãã©ã€ããŒãã»ã¯ã·ã§ã³ïŒããšãã°ãæ¿èªãå¿ èŠãªãã©ã€ããŒããã©ãŒã©ã ïŒã«ã¢ã¯ã»ã¹ã§ããªãããããã©ã€ããŒãã»ã¯ã·ã§ã³ã®æ å ±ãæ€çŽ¢çµæã«è¡šç€ºãããããšã¯ãããŸããã ãã¡ãããéããã»ã¯ã·ã§ã³ã®æ å ±ãèŠãé ããŠå¿åã§å ¬éããããšãã§ããŸãïŒããšãã°ããŠãŒã¶ãŒã«é¢ããæ å ±ãªãã§ã¡ãã»ãŒãžãéãã圢åŒã§è¡šç€ºããïŒããããã¯åžžã«çºçãããšã¯éããŸããã ããšãã°ãäŒç€Ÿã®ã¡ãŒã«ã§ã®æ€çŽ¢ã¯ã©ãã§ããïŒ
ããã§ã¯ãYandex.ServerïŒ http://company.yandex.ru/technology/products/yandex-server.xml ïŒãäŒæ¥ã®Microsoft Office SharePoint ServerïŒ http://office.microsoft.comãªã©ïŒã®ãµãŒãããŒãã£ã®æ€çŽ¢ãšã³ãžã³ã圹ç«ã¡ãŸãã /ru-ru/sharepointserver/FX100492001049.aspx ïŒã 2çªç®ã®æ¹æ³ã¯Yandexã®ãµãŒããŒãããã¯ããã«åªããŠããããµã€ãã®æ€çŽ¢ãªã©ã«äœ¿çšã§ããéåžžã«åŒ·åãªæ€çŽ¢ãšã³ãžã³ãåããŠããŸãã
ãããã次ã®ããããã®èšäºã§ãå¹æçãªæ€çŽ¢ãšã³ãžã³ãæ§ç¯ããããã«Microsoft Office SharePoint Server 2007ãšWebãµã€ããçµ±åããããšãæ€èšããŸãã
é¢é£ãªã³ã¯
-ASP.NETã§LiveSearch APIã䜿çšãããµã€ãæ€çŽ¢ã®å®è£ ã«é¢ããèšäº
-PHP5ã®LiveSearch APIã䜿çšãããµã€ãæ€çŽ¢ã®å®è£ ã«é¢ããèšäº