âAIãã©ã使ããâã§ã¯ãªãâä½ãæ¹åãããâTRENDOãèªããAIã¨ã¼ã¸ã§ã³ãæä»£ã®æ¬è³ª 2025å¹´12æ26æ¥ 6:30
ãã®è¨äºã¯å ¨ææ¤ç´¢ã¨ã³ã¸ã³ãElasticsearchãã®å ¥éãã¥ã¼ããªã¢ã«ã§ãã Elasticsearch ã¨ã¯ Elasticsearch 㯠Elastic 社ãéçºãã¦ãããªã¼ãã³ã½ã¼ã¹ã®å ¨ææ¤ç´¢ã¨ã³ã¸ã³ã§ãã 大éã®ããã¥ã¡ã³ãããç®çã®åèªãå«ãããã¥ã¡ã³ããé«éã«æ½åºãããã¨ãã§ãã¾ãã Elasticsearch ã§ã¯ RESTful ã¤ã³ã¿ã¼ãã§ã¼ã¹ã使ã£ã¦æä½ãã¾ããããElasticsearch SQLãã使ã£ã¦ SQL æã§ã¯ã¨ãªãè¨è¿°ãããã¨ãã§ãã¾ãã Oracle ã MySQL ãªã©ã®ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã«æ £ãã¦ãã人ã«ã¨ã£ã¦ã¯ãæåã¯ã¨ã£ã¤ãã«ããã¨æããããããã¾ããã ããããElasticsearch ã® API ã¯ã¨ã¦ãã·ã³ãã«ãªã®ã§ãå¿é ããªãã¦ã大ä¸å¤«ã§ãã Elastic Stack ã¨ã¯ Elastic Stack 㯠Elasti
Photo by Samuel Mann ããã«ã¡ã¯ãè°·å£ã§ãã ãSQLã¯ä½ã¨ãªãæ¸ãããã©ãDBè¨è¨ã¯ãããã¨ãªãâ¦ããDBè¨è¨ã«ã¤ãã¦ä¸åº¦ã¡ããã¨å¦ãã§ããããâ¦ãã¨ãã人ã¯å¤ãã§ãããã DBè¨è¨ã¨ã¯ãDBã®ãã¼ã¿ã¢ãã«ï¼DBã®æ§æãªã©ï¼ã使ãã使¥ã§ãã DBãä¸ããä½ã£ããããã¼ãã«ã追å ãããããéã¯ãå½ç¶ã§ãããä»ãããã¼ã¿ãä½ã¨ãªãæ ¼ç´ã§ããã°ããã§OKãã§ã¯ããã¾ããã ãã¼ãã«ã¯æ£è¦åã§ãã¦ããªãã¨ããã¾ãããããã¼ã¿ã®æ´åæ§ãåããªãã¨ããã¾ãããã¾ããå¹çãããã¼ã¿ãåããæ§é ã«ãªã£ã¦ãããã©ãããéè¦ã§ãã ä¸ããè¨è¨ã«åãããããããªã±ã¼ã¹ã¯å°ãªãããããã¾ããããDBãåãæ±ããã¨ããããªããããããDBè¨è¨ã®åºæ¬ã¯ç¥ã£ã¦ããã¦æã¯ããã¾ããããããèªåãæ±ãDBã®æ§é ã¯ãã¡ãã¨ç¥ã£ã¦ãããªãã¨ãããªããé©å½ã«SQLæããããã¼ã¿åãããã©ãæ£ããåãã¦ã
æå¤ã«æ¥æ¬ã§ã¯ç¥ããã¦ããªãã®ã§ãããYahoo! Inc.ã®ä¾¿å©ãªYQLã使ãã¨ãWebãµã¤ãã®ã¹ã¯ã¬ã¤ãã³ã°ãWebãµã¼ãã¹ãSQL風ãªã·ã³ã¿ãã¯ã¹ã§ã¯ã¨ãªãããã¨ãã§ãã¾ãã YQL YQLã¯Yahoo! Query Languageã®abç¥èªã«ãªãã¾ããYQLã使ãã¨Webãéãã¦ãã¼ã¿ã®ã¯ã¨ãªããã£ã«ã¿ã¼ãçµåãªã©ã1ã¤ã®ã¤ã³ã¿ãã§ã¼ã¹ããè¡ããã¨ãã§ãã¾ããSQL風ãªã·ã³ã¿ãã¯ã¹ãªã®ã§ãéçºè ã«é¦´æã¿ãããããã¼ã¿ãæ£ç¢ºã«æ½åºãããå ´åã«é©ãã¦ãã¾ãã çºæ¿ã¬ã¼ããåå¾ãã YQLããYahoo! Financeã®yahoo.finance.xchangeãã¼ãã«ã使ãã¾ãã 以ä¸ã®URLãHTTP GETããã¨JSONå½¢å¼ã§çºæ¿ã¬ã¼ããåå¾ãããã¨ãã§ãã¾ããURIã¨ã³ã³ã¼ããã¦ãã¾ãã ãã®ä¾ã§ã¯ãUSD/JPYãEUR/JPYãJPY/JPYã®çºæ¿ã¬ã¼ããåå¾ãã¦ãã¾ãã
ãã®ãããªã¯ã¨ãªã«ã¯ã2ã¤ã®åææ¡ä»¶ãå¿ è¦ å¤ãåãåã«æ ¼ç´ããã¦ããã㨠ä¾: Bugs.date_reported GROUP BY ã§æ£ç¢ºã«æ¥ä»ãã°ã«ã¼ãåããããã«ãå¤ãæ¯è¼ã§ããã㨠Bugs.date_reported ã®ãã©ã¼ããããæã£ã¦ããå¿ è¦ããã EAV (ã¨ã³ãã£ãã£ã»ã¢ããªãã¥ã¼ãã»ããªã¥ã¼) ã¨å¼ã°ããã¢ã³ããã¿ã¼ã³ãç¨ãã¦ããã¨ãä¸è¨ã®åææ¡ä»¶ãæç«ããªãåé¡ã«ééãã æ¥ä»ãè¡ã«ãã£ã¦éãåã«æ ¼ç´ããã¦ãã ä¾: date_reported, report_date æ¥ä»ã®ãã©ã¼ããããç°ãªããç°¡åã«ã¯æ¯è¼ã§ããªã 5.1 ç®ç: å¯å¤å±æ§ããµãã¼ããã ãã°ãã¼ã¿ãã¼ã¹ã®ä¾ Issue (åé¡) ãåºåºåã¨ãã¦ãBug 㨠FeatureRequest (æ©è½è¦æ) ã®ãªãã¸ã§ã¯ãã管çãã Issue åºåºå - å ±éã®å±æ§ Date_reported:
追è¨ï¼2017å¹´7æï¼ ãã¡ãã®ã¹ãã«è¦ä»¶ã§ããã2017å¹´çãæ°ãã«æ¸ãã¾ããã®ã§æ¯éãã¡ããã覧ãã ããã ããã¼ã¿ãµã¤ã¨ã³ãã£ã¹ãã¨ããããã¼ã¿åæè·ã«å°±ãããã®ã¹ãã«è¦ä»¶ãã¨ãã話é¡ãææã§ãã£ããã§ãããåã«ã¨ã£ã¦é¦´æã¿ã®ããTokyoRçéã§å®éã«ä¼æ¥ã®ãã¼ã¿åæè·ã§æ´»èºãã¦ãã人ãã¡ã®ã¹ãã«ãçºãã¦ã¿ãã«ã ã¿ã©ãã¼ãç¨åº¦ã®çµ±è¨å¦ã®ç¥è ã¯ããã¿ç¨åº¦ã®æ©æ¢°å¦ç¿ã®ç¥è RãPythonã§ã³ã¼ããçµãã SQLãæ¸ãã ã¨ããã®ãå ¨å¡ã®æå¤§å ¬ç´æ°ï¼ä¸éã©ã¤ã³ããªãã¨ããããªããã§ãã¡ããã£ã¨è²ã ä¸å¤ªè©±ãæ¸ãã¦ã¿ã¾ãããªãåã®å¨ãã®åå¾5mã«éã£ãçå®ããããã¾ããã®ã§ãçããèªèº«ãã©ããã®ãã¼ã¿ãµã¤ã¨ã³ãã£ã¹ãï¼ï¼åéã«å¿åãã¦è¹´ãããã¨ãã¦ãä½ã®ä¿è¨¼ããããããã¾ãã®ã§æªããããã çµ±è¨å¦ã®ç¥èã¯ãã¿ã©ãã¼ã以ä¸ã ãã¼ã¿è§£æã®ããã®çµ±è¨ã¢ããªã³ã°å ¥éââä¸è¬åç·å½¢ã¢ãã«ã»é層
è¨äºã®ã¿ã¤ãã«éãã競馬ã§ååç100%ãè¶ ããæ¹æ³ãè¦ã¤ããã®ã§ããã®å ±åãããã ã¡ãªã¿ã«ããã®è¨äºã§ã¯æ ¸å¿é¨åã¯ã¼ããã¦æ¸ãã¦ãããããèªã¿é²ããã¨ãã¦ãã競馬ã§ååç100%ãè¶ ããæ¹æ³ããå ·ä½çã«ä½ãªã®ããç¥ããã¨ã¯ã§ããªããï¼ç§ã¯æ¬å½ã«æå¹ãªææ³ãä½ãã¡ãªãããç¡ãã®ã«å ¬éããã»ã©ã人好ãã§ã¯ãªãã®ã§ï¼ æ¬å½ã«æå¹ãªææ³ãè¦ã¤ãããã®ã§ããã°ãããªãèªèº«ããã¼ã¿ã¨åãåã以å¤ã®éã¯ç¡ãã ãã ãã大ã¾ããªä»çµã¿ï¼ãã¨å¤å°ã®ãã³ããï¼ã ãã¯æ¸ãã¦ããã®ã§ãããããªããç¬åã§ãã¼ã¿è§£æãè¡ããã¨ããæ°æ¦ã®ãã人ç©ãªã®ã§ããã°ããã®è¨äºã¯ããªãã®å©ãã¨ãªãã ããã ã¡ãªã¿ã«ãããã¯ååã®è¨äºã®ç¶ããªã®ã§ãèªãã§ãªãæ¹ã¯ãã¡ãããã©ããã stockedge.hatenablog.com ãªããºã®æªã¿ãæ¢ã ãã¦ãååããã®ç¶ãã§ããã ååã®è¨äºã®ãã³ã¡ã§ãååçãä¸ããããªããªããº
ã¿ãªãã¾ããããããï¼ åå¼èã§ãããã¾ãï¼ ä¸æ¨æ¥amazonã¢ã½ã·ã¨ã¤ãã®å¯©æ»ãç¡äºééãããã¨ãç¥ã£ã¦ãé²éª¨ãªã¢ãã£ç®çè¨äºãæ¸ãã¦ã¿ã¾ããã 仿¥ã¯ãã¼ã¿ãã¼ã¹ã®æä½ãè¡ãè¨èªãSQLããå®è·µçã«å¦ç¿ã§ãããµã¤ããçºè¦ããã®ã§ãããã«ã¤ãã¦æ¸ãã¦ãããã¨æãã¾ãã SQLã£ã¦ãªã«ï¼ ãã©ã¦ã¶ä¸ã§SQLã®å¦ç¿ãã§ãããµã¤ã æ¥æ¬èªã§ã®SQLå¦ç¿ SQLã£ã¦ãªã«ï¼ SQLãç¥ããªãæ¹ã®ããã«SQLã«ã¤ãã¦ç°¡åã«èª¬æãã¦ããã¨ãä¾ãã°ãããã·ã§ããã§è²·ãç©ãããæã«ãããªæãã§ãä¼å¡æ å ±ããéä»å ãããè³¼å ¥åããç»é²ãã¾ãããã ãä¼å¡æ å ±ã ãéä»å ã ãè³¼å ¥åã ããã¨ããã©ã¦ã¶ããå ¥åãããæ å ±ã¯ãSQLã使ã£ã¦ãããªæãã§ãã¼ã¿ãã¼ã¹ã«æ¸ãè¾¼ã¾ãã¾ãã ãä¼å¡ãã¼ãã«ã ãéä»å ãã¼ãã ã売ä¸ãã¼ãã«ã ãããªé¢¨ã«ãã©ã¦ã¶ããéãããæ å ±ããã¼ã¿ãã¼ã¹ã«æ¸ãè¾¼ãã ããèç©ããã
MySQLï¼ãã¤ã¨ã¹ãã¥ã¼ã¨ã«ï¼ã¯ãTCX DataKonsultAB社ãªã©ãéçºããRDBMSï¼ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã®ç®¡çã·ã¹ãã )ã§ããä¸çã§æã人æ°ã®é«ãã·ã¹ãã ã§ããªã¼ãã³ã½ã¼ã¹ã§éçºããã¦ãã¾ããMySQLãã¼ã¿ãã¼ã¹ãµã¼ãã¯ãé«éæ§ã¨ä¿¡é ¼æ§ããããLinuxãUNIXãWindowsãªã©ã®è¤æ°ã®ãã©ãããã©ã¼ã ã§åä½ãããã¨ãã§ãã¾ãã PHPã¯ãWebãµã¤ãæ§ç¯ã«ç¹åãã¦éçºãããããã°ã©ãã³ã°è¨èªã§ãã大ããªç¹å¾´ã®ã²ã¨ã¤ã¯ãHTMLã«ç´æ¥ããã°ã©ã ãåãè¾¼ããã¨ãã§ããã¨ããç¹ã§ããPHPãç¨ãããã¨ã§ãHTMLãåçã³ã³ãã³ãã¨ãã¦åºåã§ãã¾ããHTMLããã®ã¾ã¾ãã©ã¦ã¶ã«è¡¨ç¤ºãããã®ã«å¯¾ããPHPããã°ã©ã ã¯ãµã¼ãå´ã§å®è¡ãããçµæããã©ã¦ã¶ã«è¡¨ç¤ºããããããPHPã¹ã¯ãªããã¯ããµã¼ããµã¤ãã¹ã¯ãªãããã¨å¼ã°ãã¦ãã¾ãã
ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã話é¡ã«æããã¨ããç§ã¯ä½ããè¶³ããªãã¨æããã«ã¯ãããã¾ããããã¼ã¿ãã¼ã¹ã¯ããããã¨ããã§ä½¿ããã¦ããããã®ç¨®é¡ããå°è¦æ¨¡ã§ä¾¿å©ãªSQLiteãããã¯ãã«ãªTeradataã¾ã§æ§ã ã§ãããããããããã©ãããä»çµã¿ã§æ©è½ãã¦ãããã説æãããã®ã¨ãªãã¨ããã®æ°ã¯ãããããã§ã¯ãªãã§ãããããä¾ãã°ããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ ä»çµã¿ããªã©ã§æ¤ç´¢ãã¦ã¿ã¦ãã ããããããæ°ã®å°ãªãã宿ã§ããã¨æãã¾ããããã«ãããã®è¨äºã¯çããã®ãã»ã¨ãã©ã§ããéã«ãè¿å¹´æµè¡ãã¦ããæè¡ï¼ããã°ãã¼ã¿ãNoSQLãJavaScriptãªã©ï¼ãæ¤ç´¢ããå ´åããããã®æ©è½ã詳ãã説æããè¨äºã¯ããããè¦ã¤ããã¨æãã¾ãã ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã¯ããã¯ã大å¦ã®ææ¥ãç ç©¶è«æãå°éæ¸ãªã©ã§ããæ±ãããªããããªå¤ãã¦éå±ãªæè¡ãªã®ã§ããããï¼ ç§ã¯éçºè ã¨ãã¦ãçè§£ãã¦ããªããã®ã
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã¡ã³ããã³ã¹
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}