
JRA-VAN Data Lab.ã®ããŒã¿æ§é ãšçš®é¡ã解説ïŒ25幎åã®ç«¶éЬããŒã¿ãSQL Serverã«åã蟌ãçç±ãAIãšç«¶éЬç ç©¶ #04ã
ååã®èšäºã§ã¯ãåã®ç«¶éЬç ç©¶ã®çžæ£ã§ããAIããµã¬ã ãã玹ä»ããŸããã
ããŠãçžæ£ã決ãŸããç ç©¶ãããããšãå°ããã€èŠããŠããŸãããæ¬¡ã«å¿ èŠãªã®ã¯ãç ç©¶ã®ææãšãªããããŒã¿ãã§ãã
第2åã§ã¯ãããŸããŸãªç«¶éŠ¬äºæ³çè«ãæ€èšããçµæãJRA-VANã®ãData Lab.ããéžãã ããšãæžããŸããã
ä»åã¯ãJRA-VANã§ã©ã®ãããªããŒã¿ãååŸã§ããã®ãããããŠãããã䜿ã£ãŠäœã調ã¹ãããšããŠããã®ããã玹ä»ããããšæããŸãã
â JRA-VANã¯ã¹ããã¢ããªã ããããªãââéçºè åããData Lab.ããšãJV-Linkãã®å¯èœæ§
åã¯ä»¥åãããJRA-VANã®ã¹ããŒããã©ã³ã¢ããªãå©çšããŠããŸãããåºéŠ¬è¡šãéå»ã®æçžŸãèª¿ææ å ±ãããŒã¿ãã€ãã³ã°ã«ããè©äŸ¡ãªã©ãç«¶éŠ¬äºæ³ã«å¿ èŠãªæ å ±ã確èªã§ãã䟿å©ãªãµãŒãã¹ã§ãã
ããããä»å泚ç®ããã®ã¯ããã®è£åŽã«ããèšå€§ãªç«¶éЬããŒã¿ã§ããã
JRA-VANã«ã¯ãWindowsããœã³ã³åãã®ãData Lab.ïŒããŒã¿ã©ãïŒããšãããµãŒãã¹ããããŸãã察å¿ãã競銬ãœãããå©çšã§ããã ãã§ãªãã**ãJV-Linkã**ãšããä»çµã¿ã䜿ãã°ãèªåã§ããã°ã©ã ãäœãã競銬ããŒã¿ãååŸããããšãã§ããŸãã
ãããåã«ãšã£ãŠã¯å€§ããªé åã§ããã
誰ããäœã£ãäºæ³çµæãèŠãã ãã§ã¯ãªããèªåã§ããŒã¿ãèç©ãã奜ããªæ¡ä»¶ã§éèšããç¬èªã®ä»®èª¬ãæ€èšŒã§ããããããããããããããšãå®çŸã§ããããªæ°ãããŠããŸããã
â JRA-VAN Data Lab.ã§ååŸã§ããäž»èŠããŒã¿äžèЧïŒã¬ãŒã¹ã»ã©ããã»ãªããºã»èª¿æïŒ
JRA-VAN Data Lab.ãæ±ãããŒã¿ã¯éåžžã«å€å²ã«ããããŸããåãã¡ã®ç ç©¶ã«é¢ä¿ããäž»ãªæ å ±ãæŽçããŠã¿ãŸãã
â ã¬ãŒã¹ã®åºæ¬æ å ±ãšåºèµ°éЬã®èµ°ç ŽæçžŸ
ãŸãã¯ãç«¶éŠ¬äºæ³ã®åºæ¬ãšãªãæ å ±ã§ããç«¶éŠ¬å Žãé嬿¥ãã¬ãŒã¹çªå·ãèã»ããŒããè·é¢ãéŠ¬å Žç¶æ ãåºèµ°éЬãéšæãæ€éãªã©ããããŠãã¬ãŒã¹çµäºåŸã«ã¯ç¢ºå®çé ãèµ°ç Žæèšãçå·®ãªã©ã®æçžŸãèšé²ãããŸãã
ãããã®ããŒã¿ã䜿ãã°ããæ±äº¬ã®è1600mããè¯éŠ¬å Žããç¹å®ã®ã¯ã©ã¹ããšãã£ãæ¡ä»¶ã§éå»ã®ã¬ãŒã¹ãæœåºã»æ¯èŒã§ããŸããäžèŠãããšåœããåã®æ å ±ã§ãããäœäžãã®ã¬ãŒã¹ãåãåºæºã§åæããããã«ã¯æ¬ ãããªãäžæ¬¡ããŒã¿ã§ãã
â¡ ã¬ãŒã¹å šäœã®åºéã©ããã¿ã€ã ïŒâ»ãåäœã©ããããšã®éãã«æ³šæïŒ
åãç¹ã«éèŠããŠããã®ããã©ããã¿ã€ã ã§ããããšãã°2000mã®ã¬ãŒã¹ãã2å00ç§ãã§æ±ºçãããšããŸããããããããã ãã§ã¯ã©ã®ãããªã¬ãŒã¹ã ã£ãã®ãåãããŸããã
ååãããã€ããŒã¹ã ã£ãã®ãïŒ
äžç€ã§ããŒã¹ãã¬ã¯ããšèœã¡çããã®ãïŒ
æåŸã®600mã ãäžæ°ã«å éããæ¥µç«¯ãªç¬çºååè² ã ã£ãã®ãïŒ
åãèµ°ç Žæèšã§ãããã®éçšïŒå±éïŒã¯ãŸã£ããç°ãªããŸããJRA-VANã§ã¯ã¬ãŒã¹å šäœã®åºéã©ãããååŸã§ããããããã©ã®åºéã§éããªããã©ãã§è² è·ãããã£ãã¬ãŒã¹ãªã®ãããšããæ·±ãåæãžé²ããŸãã
â»ããŒã¿åæäžã®æ³šæç¹
ååŸã§ããã¬ãŒã¹ã©ããã¯ãã¬ãŒã¹å šäœã®ééã¿ã€ã ãã§ããããå銬ã200mããšã«äœç§ã§èµ°ã£ããïŒåäœã©ããïŒãã瀺ããã®ã§ã¯ãããŸããããããåéããããšãããŒã¿ãã誀ã£ãçµè«ãå°ãå±éºããããŸãã
⢠ã³ãŒããŒééé äœãšäžãã3FïŒäœçœ®åããšå±éã®çžé¢ïŒ
次ã«éèŠãªã®ããå銬ã®äœçœ®åããšäžãã3FïŒæåŸã®600mã®æèšïŒã§ããçé ã ãã§ã¯ãã®éЬãã©ããã競銬ãããã®ãã¯èŠããŠããªããããã³ãŒããŒééé äœãšäžããã¿ã€ã ãçµã¿åãããŠåæããŸãã
4ã³ãŒããŒã§å é ã«ãã銬ãäœçã«æ®ã£ãã®ãïŒ
åŸæ¹ãã远ã蟌ãã 銬ã¯ãã©ãã ãé äœãäžããã®ãïŒ
ããã¯ã¬ãŒã¹å šäœã®ããŒã¹ïŒã©ããïŒãšã©ãé¢ä¿ããŠããã®ãïŒ
ããããçåããéå»ã®å€§éã®ã¬ãŒã¹ã§æ€èšŒã§ããŸãããã ããã³ãŒããŒé äœã¯éЬå士ã®ååŸé¢ä¿ã瀺ããã®ã§ãããæ£ç¢ºãªäœèº«å·®ãã³ãŒã¹ã®è·é¢ãã¹ãŸã§å€æããããã§ã¯ãªãç¹ã«ã¯æ³šæãå¿ èŠã§ãã
⣠èªåèšæž¬ã®èª¿æã¿ã€ã ïŒåè·¯ã»ãŠãããããïŒ
ç«¶éŠ¬äºæ³ã§ã¯èª¿æãéèŠãªå€æææã§ããJRA-VANã§ã¯ãåè·¯ããŠãããããã³ãŒã¹ã§ã®èª¿ææèšããŒã¿ïŒåºéã©ããïŒãæäŸãããŠããŸãã
åã«éãæèšãåºãããã©ããã ãã§ãªããéå»ã®èª¿æãã¿ãŒã³ãšæ¯èŒããããçµç€1Fã®äŒžã³èã®å€åãèŠããããããšã§ãç¶æ ã®è¯ãæªãã®åŸåãèŠã€ãããããããŸããããã ãã調æã¯éЬã«ãã£ãŠããã£ãã远ãããè»œãæµãããªã©ç®çãç°ãªããããåçŽãªæèšæ¯èŒä»¥äžã®æ€èšŒãå¿ èŠã§ãã
†æç³»åãªããºããŒã¿ïŒåžå Žè©äŸ¡ã®æšç§»ïŒ
ååãªããºã«ã¯ãå€ãã®ãã¡ã³ã®å€æïŒåžå Žè©äŸ¡ïŒãåæ ãããŠããŸãããŸããJRA-VANã«ã¯æç³»åã®ãªããºæ å ±ããããŸããæéã®çµéã«ãã£ãŠäººæ°ãã©ãå€åããã®ãããšãã£ãåæã«ãå©çšã§ãããã§ãã
ããã§ããšã³ãžãã¢ãšããŠã®å³æ Œããå¿ èŠã§ãã**ãã¬ãŒã¹çµäºåŸã®æçµãªããºããšãçºèµ°åã«ç¢ºèªã§ãããªããºã**ã¯å¥ç©ã§ããäºæž¬ã¢ãã«ãäœããªãããã®äºæ³ãè¡ã£ãæç¹ã§å©çšå¯èœã ã£ãæ å ±ã ãã䜿ããªããã°ãªããŸããã
⥠ã¿ã€ã åã»å¯ŸæŠåããŒã¿ãã€ãã³ã°äºæ³å€
JRA-VANã«ã¯ãã¿ã€ã åãšå¯ŸæŠåã®ããŒã¿ãã€ãã³ã°äºæ³å€ãååšããŸããåãã¢ããªã䜿ã£ãŠããé ãåèã«ããŠããæ°å€ã§ãããæãããŠ**ããã®æ°å€ã¯å®éã«ã©ã®çšåºŠäºæž¬ã«åœ¹ç«ã£ãŠããã®ãïŒãããªããºãšã¯éãç¬èªã®æ å ±ãã©ãã ãå«ãã§ããã®ãïŒã**ãšããçåãæ¹§ããŠããŸããã
ãã®åãã¯ãåŸã«åãšãµã¬ã ãå®éã®ããŒã¿ã䜿ã£ãŠæ€èšŒããéèŠããŒãã«ãªããŸããïŒâ»çµæã«ã€ããŠã¯ä»åŸã®èšäºã§è©³ãã玹ä»ããŸãïŒ
â ããŒã¿ã®ã確å®å€ããšãåºèµ°åããŒã¿ããå³»å¥ããââããŒã¿ãªãŒã¯ã®é²æ¢
ãããŸã§ç޹ä»ããæ å ±ã«ã¯ã倧ããåããŠäºã€ã®åœ¹å²ããããŸãã
éå»ã®ã¬ãŒã¹ã調ã¹ãããã®ããŒã¿ïŒçµæããã¹ãŠç¢ºå®ããŠããïŒ
ããããè¡ãããã¬ãŒã¹ãäºæ³ããããã®ããŒã¿ïŒåºéŠ¬è¡šãåœæ¥ã®éЬäœéãçŽåã®ãªããºãªã©æéãšãšãã«å€åããïŒ
ããŒã¿ããŒã¹ãæ§ç¯ããããã§ããäºæž¬ç²ŸåºŠãæ€èšŒããããã§ãããã®2ã€ã®æ±ãåãã¯æ¥µããŠéèŠã§ããã
çµæãåãã£ãŠããããŒã¿ã䜿ã£ãŠãããããåºèµ°åã«äºæž¬ãããã®ããã«åæããŠããŸã£ãŠã¯ïŒïŒããŒã¿ãªãŒã¯ïŒäœã®æå³ããããŸãããç¢ºå®æžã¿ã®ããŒã¿ãšåºèµ°åã®ããŒã¿ãæç¢ºã«åºå¥ããŠæ±ãä»çµã¿ãå¿ èŠã«ãªããŸãã
â ãããŒã¿ãååšããããšããšãåæã§ããç¶æ ïŒæ£èŠåïŒãã¯ãŸã£ããå¥ç©
ãããŸã§èª¿ã¹ãŠãJRA-VANã«ã¯æ³å以äžã«å€ãã®æ å ±ãããããšãåãããŸãããããããããŒã¿ãååšããŠãããããšãã£ãŠãããã«åæã«äœ¿ããããã§ã¯ãããŸããã
1ã€ã®ã¬ãŒã¹ã«ã¯è€æ°ã®åºèµ°éЬããã
1é ã®éЬã«ã¯éå»ã«èµ°ã£ãå¥ã®ã¬ãŒã¹ããã
ããããã«ã©ãããéŠ¬å Žç¶æ ããªããºãªã©ãçŽä»ããŠãã
ããããæ£ããçµã³ã€ãïŒãªã¬ãŒã·ã§ã³ã貌ãïŒãåæã§ããæ§é ã«æŽããªããã°ãªããŸããã
ããã«ãååŸããŒã¿ã®äžã«ã¯æ°åã§ã¯ãªããã³ãŒãå€ãã§èšé²ãããŠãããã®ããããŒã¿æŽæ°ã«ãã£ãŠåãã¬ãŒã¹ã®æ å ±ãè€æ°åç»å Žãããã®ããããŸãããããŒã¿ãååŸããããšããšãåæã«äœ¿ããåœ¢ã«æŽããããšãã¯ããŸã£ããå¥ã®äœæ¥ãªã®ã§ãã
â SQL ServerÃJV-Linkã§ç¬èªã®ç«¶éЬããŒã¿ããŒã¹ç°å¢ãæ§ç¯ãã
ããã§é·å¹ŽããŒã¿ããŒã¹ãæ±ã£ãŠããçµéšã掻ããŠããŸããååŸããæ å ±ãSQL Serverã«èç©ããå¿ èŠãªããŒã¿ãèªç±èªåšã«æœåºã§ããç°å¢ãäœãããšã«ããŸããã
JV-Linkã§ããŒã¿ãååŸããCSVãã¡ã€ã«ã«åºåãã
CSVãSQL Serverã«åã蟌ã¿ãè€æ°ã®ããŒãã«å士ãé¢é£ä»ãã
SQLã§å¿ èŠãªæ¡ä»¶ãæå®ããéå»ã®ã¬ãŒã¹ãåæãã
ãã¡ãããäœæ¥ã¯çžæ£ãµã¬ã ãšã®å ±åäœæ¥ã§ãã
åãããããæ§é ã説æãããµã¬ã ãååŸããã°ã©ã ãSQLãäœæãããå®è¡ããŠãšã©ãŒãåºãã°åå ã調ã¹ãŠä¿®æ£ãããããŸããã£ããšæã£ããååŸä»¶æ°ãåã£ãŠããªãã£ãããäºæãã¬æ¬ æå€ãèŠã€ãã£ããããâŠâŠããªããªãæãéãã«ã¯é²ã¿ãŸããã§ããã
ããã§ããä¹ ãã¶ãã«ããŒã¿ããŒã¹ã®æ§é ããŒãããèããããSQLã®æåã確èªãããããäœæ¥ã¯ãæ¬åœã«æ¥œããæéã§ããã競銬ã®ç ç©¶ãå§ããã¯ãããæ°ãã€ãã°ã·ã¹ãã éçºãã®ãã®ãã²ãšã€ã®å€§ããªããŒãã«ãªã£ãŠããã®ã§ãã
â ãããŠãããããããŒã¿æ§ç¯ã®æ¬åœã®èŠåŽãå§ãŸã
JRA-VANãå©çšããã°å¿ èŠãªããŒã¿ãããæã«å ¥ããããšã¯åæããã ãââæåã¯ãããªé¢šã«çãèããŠããéšåããããŸããã
ãããçŸå®ã¯ããã»ã©ç°¡åã§ã¯ãããŸããã
ããŒã¿ã®ååŸä»æ§ïŒJV-Link APIïŒãæ·±ãçè§£ããããš
èšå€§ãªã³ãŒãäœç³»ãèªã¿è§£ãããš
ããŒã¿ããŒã¹ã«æ ŒçŽããããŒãã«åå£«ãæ£ããçµåããããš
ååŸããããŒã¿ã«äžæŽåããªããæ€èšŒããããš
æã£ãŠãã以äžã«å°éã§æ³¥èãäœæ¥ãåŸ ã£ãŠããŸããã
ãã£ãšããããã¯åã«ãšã£ãŠå«ãªäœæ¥ã§ã¯ãããŸãããããããä¹ ãã¶ãã«ããšã³ãžãã¢ãããæå¿ãããæ¥œããã§ããæèŠã§ããã
次åã¯ãçžæ£ãµã¬ã ãšäžç·ã«JRA-VANããããŒã¿ãååŸããSQL Serverã«æ ŒçŽããç°å¢ãã©ã®ããã«æ§ç¯ããŠãã£ãã®ãããã®è©Šè¡é¯èª€ãšãã©ãã«ã®èšé²ãã玹ä»ããããšæããŸãã
ãã³ã©ã ãããžã¿ã«ããŒã¿ïŒJRA-VANïŒãšå®æ§è©äŸ¡ïŒãã©ãã¯ãã³ïŒã®éã
ç«¶éŠ¬äºæ³ã§ã¯èª¿æãéèŠãªå€æææã§ãã
JRA-VANã§ã¯ãåè·¯ããŠãããããã³ãŒã¹ã«èšçœ®ãããã»ã³ãµãŒã«ããèªåèšæž¬ã®èª¿æã¿ã€ã ïŒåºéã©ããïŒãæäŸãããŠããŸããã¹ã¿ãŒããããŽãŒã«ãŸã§ã®æèšãç¡æ©è³ªãªããžã¿ã«æ°å€ãšããŠæ£ç¢ºã«èšé²ããããããããŒã¿ã®æ¯èŒãéèšã«ã¯éåžžã«åããŠããŸãã
ããããããã«ã倧åãªç²ç¹ããããŸããã
JRA-VANã®ããŒã¿ã ãã§ã¯**ããã®éЬãã©ããããã®è² è·ã§èµ°ã£ãŠããã®ãã**ãšããæå¿ãïŒèè²ïŒãŸã§ã¯åãããªãã®ã§ãã
äžæ¹ã§ãNetkeibaã競銬æ°èã®èª¿ææ¬ãèŠããšããã©ãã¯ãã³ã®æ¹ã ãåçŒé¡ãçæã«ã¹ããããŠã©ãããå©ããã銬ãªããã匷ãããäžæ¯ããšãã£ãè©äŸ¡ãã³ã¡ã³ããæ·»ããŠãããŠããŸãã
åã«æèšãéããŠããäžæ¯ã«è¿œãããŠã®ãªã®ãªåºããæèšããªã®ã
ã¿ã€ã ã¯å¹³å¡ã§ããæç¶±ãæã£ããŸãŸæ¥œãªæå¿ãïŒéЬãªãïŒã§åºããæèšããªã®ã
ãããã¯ããžã¿ã«ããŒã¿ã ãã§ã¯æããããŸããããã©ãã¯ãã³ã®é·å¹Žã®çµéšãšèгå¯çŒã«ãã£ãŠç©ã¿äžãããã宿§è©äŸ¡ã¯ããŸãã«ã人éç§åŠã®çµæ¶ããšãåŒã¶ã¹ã貎éãªæ å ±ã§ãã
ãããŸã§ã®èšäºã«ã€ããŠ
èšäºãå¢ããŠããã®ã§ãããŒãããšã«æ¢ããæ¡å
ãäœããŸããã
æ°ã«ãªãããŒãããèªã¿ããæ¹ã¯ããã¡ãããã©ããã
ã¯ãããŠã®æ¹ãžââAIãšç«¶éЬç ç©¶ã®ç·åæ¡å ã鿿޿°ã
ãããã«
æåŸãŸã§èªãã§ããã ããããããšãããããŸããã
æ¬èšäºã¯ãJRA-VAN Data-Lab.ã®å šããŒã¿ãSQL Serverã«åã蟌ã¿ãAIç ç©¶å¡ã®ãµã¬ã ïŒChatGPTïŒãšè¿è€ããïŒClaude / MCPåæïŒãšå ±ã«è©Šè¡é¯èª€ããŠããããŒã¿åæã®éäžçµéã§ãã競銬ãã¡ã³ãããŒã¿æŽŸã®çæ§ããã®ãæèŠã»ã質åãã³ã¡ã³ãã§ããã ãããšå€§å€å±ã¿ã«ãªããŸãã
å 容ãåèã«ãªããŸããããã¹ãããSNSã§ã®ã·ã§ã¢ãããŠããã ãããšå¬ããã§ãã
â»æ¬èšäºã¯å人ã®ããŒã¿ç ç©¶èšé²ã§ããã銬åžã®çäžãååçåäžãä¿èšŒãããã®ã§ã¯ãããŸããã銬åžè³Œå
¥ã¯ãèªèº«ã®å€æïŒèªå·±è²¬ä»»ïŒã§ã楜ãã¿ãã ããã
åèè³æ
æ¬èšäºã¯ãå
Œ΋nj
¬éãããŠãããµãŒãã¹æ
å ±ãåèã«ãå人ã®ç ç©¶çµéšãšç¬èªã®åæã«ã€ããŠç޹ä»ãããã®ã§ãã
ãŸãæ²èŒã«ããã£ãŠã¯JRA-VANæçš¿ã¬ã€ãã©ã€ã³ã«æ²¿ã£ãåœ¢ã§æçš¿ããŸã