
JRA-VANããŒã¿ãSQL Server ExpressãžïŒC#ÃChatGPTã§çéæ§ç¯ãã競銬DBã®èšèšãšè©Šè¡é¯èª€ãAIãšç«¶éЬç ç©¶ #05ã
ååã®èšäºã§ã¯ãJRA-VAN Data Lab.ããååŸã§ãã競銬ããŒã¿ã«ã€ããŠç޹ä»ããŸããã
â»ã¯ããã«ïŒæ³šæç¹ïŒ
æ£çŽä»åã®èšäºã¯ããã°ã©ãã³ã°ãããŒã¿ããŒã¹æ§ç¯ã®è©±ãäžå¿ã«ãªããŸãããããã°ã©ã ã«ã¯å šãèå³ããªãããšããæ¹ã¯ã次åã®åææ¬ç·šãããèªã¿ããã ããŠã倧äžå€«ã§ãïŒ
ã¬ãŒã¹çµæãã©ããã¿ã€ã ãåéŠ¬ã®æçžŸã調æããŒã¿ããªããºãªã©ãç ç©¶ã«äœ¿ããããªæ å ±ãããããæããŸããã
ã§ã¯ããããã䜿ã£ãŠæ©éåæãå§ãããïŒ
âŠâŠãšæã£ãã®ã§ãããåœç¶ãªãããããªã«ç°¡åãªè©±ã§ã¯ãããŸããã§ãããä»åã¯ãçžæ£ã®ãµã¬ã ãšäžç·ã«ç«¶éЬããŒã¿ãåæã§ããç°å¢ãäœããŸã§ã®æ³¥èã詊è¡é¯èª€ã®ã話ã§ãã
â 1. ããŒã¿ããŒã¹ã®éžå®ââSQL Server Expressã®å®¹éå¶éã50GBæ¡åŒµããšããå¬ãããµãã©ã€ãº
åã¯ä»¥åããããŒã¿ããŒã¹ãæ±ãä»äºãããŠããŸããããã®ããã倧éã®ããŒã¿ãåæãããªãè¿·ãããSQL Server Expressãã䜿ãããšèããŸããã
SQL Server Expressã¯ãMicrosoftãæäŸããŠããç¡åïŒç¡æïŒã®ãšãã£ã·ã§ã³ã§ããäŒæ¥åãã®æ¬æ ŒçãªRDBMSã®æ©èœããå人ã®ç ç©¶ãåŠç¿çšéãªãäžåã³ã¹ãããããã«å©çšã§ããã®ãæå€§ã®é åã§ãã
ãã ãããã§äžã€å€§ããªæžå¿µããããŸãããåã®é ã«ãã£ãæã®ç¥èã§ã¯ãSQL Server Expressã®1ããŒã¿ããŒã¹ãããã®äžé容éã¯ã10GBãã ã£ãã®ã§ãã
å®éã«JRA-VANããé廿°å¹Žåãåæ°å¹Žåã®ããŒã¿ãèç©ããŠãããšãããŒã¿ããŒã¹ã®ãµã€ãºã¯ãã£ãšããéã«çŽ15GBïŒ15,073,568 KBïŒã«å°éããŠããŸããã
ãããâŠâŠïŒ 10GBãè¶ ããããšã©ãŒã§æ¢ãŸã£ãŠããŸãã®ã§ã¯ïŒã
äžç¬ãã€ãã€ããªããææ°ã®ä»æ§ã確èªããŠã¿ããšãããæé«ã«å¬ãããµãã©ã€ãºããããŸãããææ°ã®SQL Server Expressã§ã¯äžé容éãåŸæ¥ã®10GBããã50GBããžãšå€§å¹ ã«æ¡åŒµãããŠããã®ã§ãã
15GBã®ç«¶éЬããŒã¿ãã50GBã®äžéãããã°ãŸã ãŸã äœè£ãã£ã·ãã«æ ŒçŽã§ããŸããå人ã®è¶£å³ãç ç©¶éçºã§ããã»ã©æ¬æ Œçãªç°å¢ãç¡æã§äœ¿ãããŠããããªããŠãMicrosoftã®å€ªã£è ¹ãã«ã¯æ¬åœã«æè¬ãããããŸããã
ããã䜿ãã°ãæ±äº¬ç«¶éŠ¬å Žã®è1600mã§è¡ãããã¬ãŒã¹ã ããæœåºããããç¹å®ã®éЬã®éå»10èµ°ã調ã¹ãããšãã£ãåŠçããé«åºŠãªSQLèšèªã§é«éã«å®è¡ã§ããŸãã
ä»åäœæããããŒã¿ããŒã¹ã®åå㯠`HorseRacing` ãååã¯ããã£ãŠæ®éã§ãïŒç¬ïŒã
â 2. C#ãšJV-Link飿ºããã°ã©ã ããµã¬ã ãšçééçºããããã»ã¹
ããŒã¿ã®ä¿ç®¡å Žæãæ±ºãŸã£ãããæ¬¡ã¯JRA-VANã®ãJV-Linkãã䜿ã£ãŠããŒã¿ãååŸïŒããŠã³ããŒãïŒããããã°ã©ã ãçšæããªããã°ãªããŸããã
ä»åã¯C#ã䜿ã£ãŠããã°ã©ã ãæžãããšã«ããã®ã§ããâŠâŠãªã«ãC#ãæžãã®ã¯æ¬åœã«ä¹ ãã¶ãã®ããšã§ããããã§ãéçºããã»ã¹ãã®ãã®ããµã¬ã ã«å€§ããé Œãããšã«ããŸããã
仿§ã®èªã¿èŸŒã¿: JRA-VANãå ¬éããŠããSDKã®ä»æ§æžããµã³ãã«ã³ãŒãããµã¬ã ã«èªã¿èŸŒãŸãã
ã³ãŒãçæ: ãµã¬ã ãJV-Linkãšéä¿¡ããå®éã®C#ã³ãŒããæžãèµ·ãã
仿§åºãã»æ¡ä»¶æå®: ãäžéãã¡ã€ã«ãšããŠCSVãæã¿ãããããšã©ãŒæã®å詊è¡ããžãã¯ãå ¥ããŠã»ããããšãã£ã现ããªæç€ºãåãåºã
ãããã°ã»ãã¹ã: ãµã¬ã ãæžããã³ãŒããåãå®è¡ãããšã©ãŒãåºããåå ãçªãæ¢ããããããã¬ãŒïŒãã¹ãä¿ïŒãã«å°å¿µãã
çŽæ¥ããŒã¿ããŒã¹ãžæµã蟌ãã®ã§ã¯ãªãããããŠéã«CSVãã¡ã€ã«ãæãæ¹åŒã«ããã®ãåã®ãã ããã§ããååŸããçã®ããã¹ãå 容ã確èªãããããäžãäžåã蟌ã¿ãšã©ãŒãèµ·ããéãåå è¿œç©¶ãæ Œæ®µã«å®¹æã«ãªãããã§ãã
ãã€ãŠã®éçºããã»ã¹ã§ããã°ã仿§æžãèªã¿èŸŒãã§C#ã®ã³ãŒããæã§æžãããã©ãã«å¯Ÿå¿ãŸã§äžäººã§ãã£ãŠããããããã1ãæä»¥äžã¯ããã£ãŠãããšæããŸããããããµã¬ã ãšã®å ±åäœæ¥ã«ããããªããš1æ¥è¶³ããã§å®æããŠããŸããŸããã
ããªããŠçŽ æŽãããæä»£ã«ãªã£ããã ããšãAIã®é²åã«å¿ããæè¬ããç¬éã§ããã
â 3. éçºçŸå Žã§çºçãããã©ãã«ãšãããŒã¿ãªãŒã¯é²æ¢ãã®ä»çµã¿
ããã°ã©ã ã®ããŒã¹ã1æ¥ã§åºæ¥äžãã£ããšã¯ãããå®éã®ããŒã¿ããŠã³ããŒããéå§ãããšçŸå Žãªãã§ã¯ã®ãã©ãã«ã«ãééããŸããã
æ³å®ãšéããã©ãŒãããã®ããŒã¿ãéã£ãŠãã
JV-Linkããæå³äžæãªãšã©ãŒå€ãè¿ã£ãŠãã
倧éã®ããŒã¿ãåŠçãããã¡ã«ããŠã³ããŒãæéãççºãã
ããããåã蟌ãããšæã£ãããåãã¬ãŒã¹ã®ããŒã¿ãè€æ°ååšããŠããâŠâŠ
åãçŸå Žã®ãšã©ãŒãã°ãç¶æ³ãäŒãããšããµã¬ã ãåå ãæšæž¬ããC#ããã°ã©ã ã®ä¿®æ£æ¡ãSQLã¯ãšãªãåºããŠããŸãããããåãå®è¡ããŠç¢ºèªãããŸãæ°ããªåé¡ãèŠã€ããããã®ç¹°ãè¿ãã§ããã
é£ããã£ãã®ãããåãã¬ãŒã¹ã®æ å ±ã§ããååŸããã¿ã€ãã³ã°ã«ãã£ãŠå 容ãå€ããããšããåé¡ã§ããåºèµ°åã®åºéŠ¬è¡šæ å ±ãããã°ãçŽåã®éЬäœéã»ãªããºããããŠã¬ãŒã¹çµäºåŸã®ç¢ºå®æçžŸããããŸãã
ããããåºå¥ããã«ãã¡ãæ··ãã§åæããŠããŸããšããåºèµ°åã«ã¯ç¥ãåŸãªãã£ã確å®ããŒã¿ã䜿ã£ãŠæªæ¥ãäºæž¬ããããšãããããããããŒã¿ãªãŒã¯ãåŒãèµ·ãããŠããŸããŸãã
ããã§ãç¢ºå®æžã¿ã®ããŒã¿ãšããããè¡ãããã¬ãŒã¹ã®ããŒã¿ãæç¢ºã«åºå¥ããŠåãæ±ãä»çµã¿ãçšæããŸãããããã¯ã·ã¹ãã ã®éœåã ãã§ãªããåŸããäºæž¬ç²ŸåºŠã峿 Œã«æ€èšŒããããã®äžå¯æ¬ ãªå·¥å€«ã§ãã
â 4. ã¬ãŒã¹ãäžæã«ç¹å®ããäž»ããŒãRaceIDããšããŒãã«èšèš
ããã²ãšã€éèŠã ã£ãã®ããããŒã¿ãé¢é£ä»ããäž»ããŒã®èšèšã§ãã
ç«¶éŠ¬å Žãéå¬å¹Žã忬¡ãæ¥æ¬¡ãã¬ãŒã¹çªå·ãªã©ãçµã¿åãããåãã¡ã¯äžã€ã®ã¬ãŒã¹ãäžæã«ç¹å®ãã `RaceID` ãšããããŒã§ç®¡çããããšã«ããŸããã
ãã® `RaceID` ã軞ã«ããããšã§ããã¬ãŒã¹åºæ¬æ å ±ããåºèµ°éЬæ å ±ããã©ããæ å ±ãããªããºæ å ±ããå ±éã®èå¥çªå·ã䜿ã£ãŠé¢é£ä»ããããŸãã
åæ§ã«ã競走銬äžé äžé ã«å¯ŸããŠãèå¥ã³ãŒããèšå®ããéå»ã®åºèµ°å±¥æŽã瞊æããŠè¿œè·¡ã§ããããã«ããŸãããããã«ãããããã®ã¬ãŒã¹ã«åºèµ°ãã銬ããéå»ã©ã®ãããªã©ããã®ã¬ãŒã¹ã§å¥œèµ°ããŠãããããç¬æã«åŒããããã«ãªããŸãã
ããŒã¿ããŒã¹ãæ±ã£ãããšã®ãã人ã«ã¯ããåœããåã®èšèšãããããŸãããã§ããããã®åºæ¬æ§é ãæ£ããã§ããŠããªããã°ããã®åŸã®ã©ããªé«åºŠãªAIåæããã¹ãŠç äžã®æ¥Œé£ã«ãªã£ãŠããŸãã®ã§ãã
â 5. çããŒã¿ãšåæçšããŒã¿ãåé¢ãããViewïŒãã¥ãŒïŒãã®æŽ»çš
SQL Serverã®ããŒãã«ã«ã¯ãååŸããããŒã¿ãã§ããã ãå ã®åœ¢åŒïŒçã®ããŒã¿ïŒã«è¿ã圢ã§ä¿æãããŠããŸãã
ãã®ããã§ãåæã«å¿ èŠãªé ç®ãæœåºã»å€æããæ±ããããæŽçãã ãViewïŒãã¥ãŒïŒã ãšããä»çµã¿ã被ããŸããã
å倿: æååãšããŠä¿åãããŠããèµ°ç Žæèšããèšç®å¯èœãªãç§æ°ïŒfloat/decimalïŒãã«å€æãã
ã³ãŒãå€ã®åç§°å: ã01ããšãã£ãéŠ¬å Žç¶æ ã³ãŒãããè¯ããçšéããšãã£ãåãããããåç§°ã§çµåãã
ããŒãã«çµå: å¿ èŠãªé ç®ïŒã¬ãŒã¹æ å ±ïŒéЬæçžŸïŒãã²ãšã€ã®SELECTæã§ååŸã§ããããã«ãããããå®çŸ©ããŠãã
ããããå°å³ãªäžæºåãã²ãšã€ã²ãšã€ç©ã¿éããŠãããŸããã
â 6. 25幎åã®ããŒã¿ãéèšã§ããæåŒ·ã®ã競銬ç ç©¶DBãã宿ïŒ
ããããŠãã¬ãŒã¹æ å ±ã銬å¥ã®æçžŸãã©ããã¿ã€ã ãªã©ãããŒã¿ããŒã¹ã«èç©ããSQLã§èªåšã«åæã§ããç°å¢ãæŽããŸãããããŒã¿ã®ååŸããåã蟌ã¿ãŸã§ãèªååããã¹ã¯ãªããã宿ããŠããŸãã
ãã¡ãããããã§100%宿ãšããããã§ã¯ãããŸãããååŸå¯Ÿè±¡ã®è¿œå ãããŒã¿å質ã®ãã§ãã¯ã¯ä»åŸãç¶ããŠãããŸãã
ããã§ãã以åã¯æ°èãã¹ããã§äžã€ãã€éЬæ±ã確èªããŠããæ å ±ããSQLã«ãã£ãŠæ°äžä»¶åäœã§äžæ¬éèšã§ããããã«ãªã£ãã®ã¯å·šå€§ãªé²æ©ã§ããã
ã·ã¹ãã æ§ç¯ãã®ãã®ãç®çã§ã¯ãããŸããã
äœã£ããã®ç°å¢ã䜿ã£ãŠããããŸã§æèŠçã«èªãããŠãã競銬ã®åžžèããæ¬åœã«ããŒã¿ã§èšŒæã»æ€èšŒã§ããã®ãã
ããããæ¬¡åãããç ç©¶ã®æ¬é¡ãžãšèžã¿èŸŒãã§ãããŸãã
ãããŸã§ã®èšäºã«ã€ããŠ
èšäºãå¢ããŠããã®ã§ãããŒãããšã«æ¢ããæ¡å
ãäœããŸããã
æ°ã«ãªãããŒãããèªã¿ããæ¹ã¯ããã¡ãããã©ããã
ã¯ãããŠã®æ¹ãžââAIãšç«¶éЬç ç©¶ã®ç·åæ¡å ã鿿޿°ã
ãããã«
æåŸãŸã§èªãã§ããã ããããããšãããããŸããã
æ¬èšäºã¯ãJRA-VAN Data-Lab.ã®å šããŒã¿ãSQL Serverã«åã蟌ã¿ãAIç ç©¶å¡ã®ãµã¬ã ïŒChatGPTïŒãšè¿è€ããïŒClaude / MCPåæïŒãšå ±ã«è©Šè¡é¯èª€ããŠããããŒã¿åæã®éäžçµéã§ãã競銬ãã¡ã³ãããŒã¿æŽŸã®çæ§ããã®ãæèŠã»ã質åãã³ã¡ã³ãã§ããã ãããšå€§å€å±ã¿ã«ãªããŸãã
å 容ãåèã«ãªããŸããããã¹ãããSNSã§ã®ã·ã§ã¢ãããŠããã ãããšå¬ããã§ãã
â»æ¬èšäºã¯å人ã®ããŒã¿ç ç©¶èšé²ã§ããã銬åžã®çäžãååçåäžãä¿èšŒãããã®ã§ã¯ãããŸããã銬åžè³Œå ¥ã¯ãèªèº«ã®å€æïŒèªå·±è²¬ä»»ïŒã§ã楜ãã¿ãã ããã