ã¯ããã«
Autonomous AI DatabaseïŒä»¥äžãADBïŒã¯Oracleã®ã¯ã©ãŠãDBã§ãã
衚ãžã®ããŒã¿ä¿åã«å ããäœçœ®ãè·é¢ãæ±ãSpatialãã€ãªããã調ã¹ãã°ã©ããåŠçã®å®æå®è¡ãå€éšAPIãåŒã³åºãæ©èœããŸãšãŸã£ãŠããŸãã
ãã£ãããªã®ã§ãããããçµã¿åãããŠäœãäœããªãããšèããŠããŸããã
ããã§ããªãŒãã³ããŒã¿ã掻çšãã顿ãšããŠéžãã ã®ãéœãã¹ã§ãã
åçæã«ã¯äœçœ®ããããè·¯ç·ã«ã¯ã€ãªããããããæå»è¡šãšå®éã®éè¡ã«ã¯æéã®æ
å ±ããããŸãã
éè¡ããŒã¿ã宿çã«éããã°ãä¿åããããŒã¿ãããšããåçããããäºå®ãšæ¯ã¹ããããããšãã§ããŸãã
ä»åã¯ãããAPEXlangã§ã¢ããªã«ããŠã¿ãŸããã
ã§ãããã£ãã®ã¯ãã¡ã
éœãã¹ã®åããå°å³ã§æ©éãåçããã¢ããªã§ãã
ã¢ããªåã¯ãéœãã¹ã»ã¿ã€ã ã©ãã¹ããšããŠããŸãã
ãã®GIFã¯æå»è¡šãããšã«ããåçã§ãã
æå»ãé²ãããšããã®æéã«èµ°ãäºå®ã®ãã¹ãå°å³äžãåããŸãã
åçæã®æ€çŽ¢ãã系統ãçµã蟌ãã 衚瀺ãã§ããŸãã
å¥éåéããéè¡å®çžŸãéããŠãæå»è¡šãšæ¯ã¹ãããšãã§ããŸãã
ä»åä¿åããŠããå®çžŸã¯2026幎11æ3æ¥ã«ååŸããçŽ1æéåã§ãã
ä¹ãæãããšãã©ããŸã§è¡ããã
åçæãéžã¶ãšãä¹ãæããªãããŸãã¯1åã®ä¹ãæãã§ã€ãªããåçæãè²åãã§ããŸãã
äžéæŸåå±åãèµ·ç¹ã«ããç»é¢ããã¡ãã§ãã
ããã¯ãåçæãšç³»çµ±ã®ã€ãªãããã°ã©ããšããŠèª¿ã¹ãçµæã§ãã
è¿ãã®å¥ã®åçæãžæ©ããŠä¹ãæããé¢ä¿ãå«ããŠããŸãã
çºè»æå»ãæèŠæéãèæ ®ããçµè·¯æ¡å ã§ã¯ãªããè·¯ç·ç¶²ãšããŠã©ããŸã§ã€ãªãã£ãŠããããèŠãæ©èœã§ãã
æå»è¡šãšå®çžŸãæ¯ã¹ã
å°å³ãšã¯å¥ã«ã暪軞ãæå»ã瞊軞ãåçæã«ãããã€ã€ã°ã©ã ãäœããŸããã
äºå®ãšå®çžŸãåãå³ã«éãããšããã¹å士ã®ééãè©°ãŸã£ãŠããåºéã確èªã§ããŸãã
ç¹ç·ãäºå®ãéãå®çžŸãèµ€ãå£åé転ã®åºéã§ãã
äž58ã®äŸã§ã¯ãæå»è¡šã§ã¯9åééã®2䟿ã17å°ç¹ã®èŠ³æž¬ã§å¹³å36ç§ã®å·®ã«ãªã£ãŠããŸããã
åã系統ã®ãã¹ãè¿ãééã§ç¶ããŠèµ°ãããããããå£åé転ãã§ãã
APEXlangãšä»åã®ç°å¢
ADBäžã§Webã¢ããªãäœã£ãŠåããä»çµã¿ãšããŠãOracle APEXããããŸãã
APEXlangã¯ãã®APEXã¢ããªãããã¹ãã§å®çŸ©ãã圢åŒã§ãã
ä»åã®éçºã«ã¯Claude Codeã䜿ããŸããã
Claude Codeã«ã¢ããªå®çŸ©ãSQLãJavaScriptãªã©ãç·šéããŠããããSQLclã§æ€èšŒããŠAPEXãžåãèŸŒãæµãã§äœã£ãŠããŸãã
åã蟌ãã ã¢ããªã¯APEXã§åããç»é¢ã®ãã°ã€ã³ãADBã«ä¿åããããŒã¿ã䜿ããŸãã
APEXlangãéçºç°å¢ã«ã€ããŠã¯ã以åã®Todoã¢ããªã®èšäºãåç §ããŠãã ããã
ADBããå€éšã®APIãåŒã¶ãšããã¯ãååã®Jevã²ãŒã ã§ã詊ããŸããã
ä»åã¯APIããããŒã¿ãéããäœçœ®ãã€ãªããã調ã¹ããšãããŸã§åºããŠããŸãã
Claude Codeã«çžè«ããããš
ããŒã¿ãåãããã®ç¢ºèªããå§ããç»é¢ãèŠãªããæ©èœãè©°ããŠãããŸããã
å®éã®ããåããããäžéšãæãåºããšãããªæãã§ãã
ãŸãã¯ADBããããŒã¿ãåããã
ãŸããéœãã¹ã®ããŒã¿ãADBããçŽæ¥ååŸã§ãããã確èªãé Œã¿ãŸããã
ãããADBããåããã確èªããŠ
䜿ãããããŒã¿ãADBããååŸã§ããã確ããããã®çµæãããšã«åéãä¿åã®åŠçãäœã£ãŠãããŸããã
ãã®ããšç޹ä»ããAPIã®åŒã³åºãã宿ãžã§ãã¯ããã®éšåã§ãã
å šè·¯ç·ãçºãããšãããããæ¢ããç»é¢ãž
ç¹å®ã®è·¯ç·ã ãã§çµã蟌ãã ããåçæã®æ€çŽ¢ããã®åçæã«åãŸãè·¯ç·ã ãã®çµã蟌ã¿ã
åçæåã®è¡šç€ºã®Onã»Offãªã©ã§ããïŒ
æåã¯å
šè·¯ç·ã®ããŒã¿ãçºããç»é¢ããå§ãŸããåçæã®æ€çŽ¢ã系統ã®çµã蟌ã¿ã远å ããŸããã
å®éã®ç»é¢ãèŠãªãããæ¬²ããæäœãçžè«ããŠããŸãã
ã°ã©ãã¯ãä¹ãæãåæ°ã§ãã©ããšãããã
ã°ã©ãã远å ããéãããŸãã¯ä¹ãæãåæ°ã§ã€ãªããã調ã¹ãç¯å²ã«çµããŸããã
倧å€ãªå®è£ ã¯çç¥ããŠãä¹ãæãåæ°ã ãã§OKã
å ã»ã©ã®ãä¹ãæãããšãã©ããŸã§è¡ããããã¯ããã®äŸé Œããäœã£ãæ©èœã§ãã
ã¢ããªã®æ§æãšä¿åã®æµã
åã蟌ã¿ããç»é¢è¡šç€ºãŸã§ã®åºæ¬éšåã¯ãæ¬¡ã®æ§æã§ãã
äžå€®ã®ADBã«ãããŒã¿ã®è¡šãåéããåŠçãæ€çŽ¢ããåŠçãAPEXã®ã¢ããªããŸãšããŠããŸãã
ãã©ãŠã¶ãšã®éä¿¡ã¯Oracle管çã®ORDSã仲ä»ããå°å³ããã€ã€ã°ã©ã ã®æç»ã¯ãã©ãŠã¶åŽã®JavaScriptãæ
åœããŸãã
å ããŒã¿ã®APIãæå»è¡šCSVã眮ãObject Storageãèæ¯å°å³ãé ä¿¡ããåœåå°çé¢ã®å°å³ã¿ã€ã«ã¯ADBã®å€ã§ãã
å
ã®äœçœ®æ
å ±ã¯ãæåŸã«éã£ãåçæãã®åº§æšã§ãé£ç¶ããGPSã®è»è·¡ã§ã¯ãããŸããã
åçæã®éã¯ãã©ãŠã¶åŽã§çµè·¯ã«æ²¿ã£ãŠè£éããæ»ããã«åãããŠããŸãã
APIã®ååŸãšå®æå®è¡ãDBã«çœ®ã
䜿ã£ãŠããããŒã¿ã¯å€§ããäºã€ãããŸãã
| ããŒã¿ | äžèº« | åãèŸŒã¿æ¹ |
|---|---|---|
| æå»è¡šïŒGTFSïŒ | åçæã系統ã䟿ãééäºå®æå»ãçµè·¯ã®åœ¢ç¶ | CSVãObject Storageã«çœ®ããADBã®å€éšè¡šã§èªã¿èŸŒãã§ä¿å |
| éè¡å®çžŸïŒGTFS-RTãªã©ïŒ | ãã¹ã®äœçœ®ãåçæã®ééæ å ± | PL/SQLããå€éšAPIãåŒã³ãååŸããå 容ã衚ãžä¿å |
GTFSã¯å
Œ
±äº€éã®æå»è¡šãªã©ãæ±ãããŒã¿åœ¢åŒã§ãGTFS-RTã¯éè¡äžã®æ
å ±ãæ±ã圢åŒã§ãã
ä»åã®ããŒã¿ã¯ãæ±äº¬éœäº€éå±ãšå
Œ
±äº€éãªãŒãã³ããŒã¿åè°äŒãæäŸããããŒã¿ãå å·¥ããŠäœ¿ã£ãŠããŸãã
APIã®åŒã³åºãã«ã¯ADBã® DBMS_CLOUD.SEND_REQUEST ã䜿ã£ãŠããŸãã
ã¬ã¹ãã³ã¹ãèªã¿åããåçãæ¯èŒã«äœ¿ã衚ãžä¿åããåŠçãŸã§PL/SQLã§æžããŠããŸãã
PL/SQLã¯ããŒã¿ããŒã¹å
ã§SQLãšåŠçã®æé ããŸãšããŠæžããèšèªã§ãã
ãã®åéåŠçã宿çã«èµ·åããã®ããDBMS_SCHEDULER ã§ãã
ãžã§ãã¯1åééã®èšå®ã§å®çŸ©ããåéããæéã«åãããŠæå¹ã«ããæ§æã«ããŸããã
ä»å玹ä»ããŠããç»é¢ã§ã¯ãäºåã«åéããŠä¿åããããŒã¿ãåçããŠããŸãã
ããŒã¿ãåãã«è¡ãããã®ãµãŒããŒãšããã®äžã§åãã宿ãããã®ç°å¢ããå¥ã«çšæããŠããªãã®ããã€ã³ãã§ãã
åŠçãã®ãã®ã¯æžããŸãããAPIãåŒã¶å Žæãã宿å®è¡ããå Žæããä¿åå
ãADBã«ãŸãšããŠããŸãã
ADBããã®WebãµãŒãã¹åŒã³åºããšã¹ã±ãžã¥ãŒãªã³ã°ã¯ãæ¥æ¬èªã®å ¬åŒããã¥ã¡ã³ãã«ã説æããããŸãã
Spatialã§ãè¿ãã®åçæãã€ãªã
åçæã®ç·¯åºŠãšçµåºŠã¯ãSpatialã®äœçœ®æ
å ±ã衚ãå SDO_GEOMETRY ã§ãä¿åããŠããŸãã
ããã䜿ã£ãŠãåçæå士ã®è·é¢ããè¿ãã«ããåçæã調ã¹ãããŸãã
ä»åã®ä¹ãæãæ¢çŽ¢ã§ã¯200m以å
ã«ããååã®éãåçæãæ¢ããæ©ããŠä¹ãæããããåè£ãšããŠçµãã§ããŸãã
ãå°å³äžã§è¿ãã«èŠãããããšããDBã®è·é¢èšç®ã§åŠçããŠããããã§ãã
å®è£ ã®ãã¡ã200m以å ããå€å®ããŠããæ¡ä»¶ã¯ãã®1è¡ã§ãïŒSQLã®æç²ïŒã
sdo_within_distance(b.geom, a.geom, 'distance=200 unit=M') = 'TRUE'
åãåçæã®è¡šã a ãš b ãšããå¥åã§åç
§ãã2ã€ã®åçæãæ¯èŒããŠããŸãã
å³ã¯èª¬æçšã®æ¶ç©ºã®åçæã§ãã
åçæBãã160mã®Cã¯åè£ã«å
¥ãã310mã®Eã¯ç¯å²å€ã«ãªããŸãã
ããããŠèŠã€ããBãšCã®é¢ä¿ããæ¬¡ã®ã°ã©ãã®æ€çŽ¢ã«ã䜿ããŸãã
ãã®200mã¯ã¢ããªã§çœ®ããæ¡ä»¶ã§ãã
éè·¯ãæšªææ©éããã©ã£ãåŸæ©çµè·¯ãèšç®ããŠããããã§ã¯ãããŸããã
Oracle Spatialã¯ADBã«å«ãŸããŠããŸãã
以åã®å°å³ã¢ããªã®èšäºã§ã¯ãè¿ãã®ã«ãã§ãæ¢ãåŠçã§ã䜿ããŸããã
ã°ã©ãã§ãä¹ãæãå ããã©ã
次ã¯è¿ãã«å ããŠãã€ãªãããã䜿ããŸãã
ããã§ã®ã°ã©ãã¯ãæ£ã°ã©ããæãç·ã°ã©ãã§ã¯ãªããç¹ãšç·ã§é¢ä¿ã衚ãã°ã©ãã§ãã
ä»åãªãç¹ã¯åçæãšç³»çµ±ãç·ã¯ããã®ç³»çµ±ããã®åçæã«åãŸãããšããé¢ä¿ã§ãã
ãããžãSpatialã§æ±ããåŸæ©ä¹ãæãã®é¢ä¿ãå ããŠããŸãã
ãã®é¢ä¿ããã©ããšã次ã®ãããªæ€çŽ¢ãã§ããŸãã
- éžãã åçæãšåã系統ã§ã€ãªããåçæãæ¢ã
- éäžã®åçæã§å¥ã®ç³»çµ±ãžä¹ãæããå ãæ¢ã
- è¿ãã®å¥ã®åçæãžæ©ããŠãããå¥ã®ç³»çµ±ãžä¹ãæããå ãæ¢ã
åãæ¶ç©ºã®åçæã䜿ããšãSpatialã§çµãã BãšCãçµç±ããŠãåçæAããå¥ã®ç³»çµ±ã®åçæDãŸã§ã€ãªãããŸãã
äžžãåçæãåè§ã系統ããªã¬ã³ãžã®ç Žç·ãåŸæ©ä¹ãæãã®é¢ä¿ã§ãã
å®è£
ã§ã¯ADBã®è¡šãããšã«ããããã£ã°ã©ããå®çŸ©ããSQLããã°ã©ããåãåãããSQL/PGQã® GRAPH_TABLE ã䜿ã£ãŠããŸãã
ä¹ãæãæ¢çŽ¢ã®ããã«ãå¥ã®ã°ã©ãå°çšDBãžããŒã¿ãç§»ãæ§æã«ã¯ããŠããŸããã
åãåçæã®ããŒã¿ããäœçœ®ã§èª¿ã¹ããšãã¯Spatialãè·¯ç·ã®ã€ãªããã§èª¿ã¹ããšãã¯ã°ã©ããšããŠæ±ã£ãŠããŸãã
éããå®çžŸãSQLã§èª¿ã¹ã
æå»è¡šãšééå®çžŸãä¿åããŠããã®ã§ãåã系統ã®ååŸã®äŸ¿ã«ã€ããŠãäºå®ã®ééãšå®éã®ééééãæ¯èŒã§ããŸãã
å£åéè»¢ã®æ€åºã«ã¯ãSQLã§é£ç¶ããè¡ã®ãã¿ãŒã³ãæ¢ã MATCH_RECOGNIZE ã䜿ã£ãŠããŸãã
ãã®ã¢ããªã§ã¯ãäºå®ã§ã¯6å以äžé¢ããŠãã2䟿ããå®çžŸã§ã¯90ç§ä»¥å
ã®å·®ãšãªã芳枬ãåçæé ã«5件以äžç¶ãåºéãåè£ã«ããŠããŸãã
ä»åã®äœäŸã®ããã«çœ®ããæ¡ä»¶ã§ãã
æ¡ä»¶ã«åœãŠã¯ãŸã芳枬ã®ç¹°ãè¿ãã¯ã次ã®2è¡ã§æå®ããŠããŸãïŒSQLã®æç²ïŒã
pattern (close{5,})
define close as gap_sec <= 90 and plan_gap_sec >= 360
gap_sec ãå®çžŸã®ééééãplan_gap_sec ãäºå®ã®ééã§ãåäœã¯ç§ã§ãã
å
ã»ã©ã®äž58ã§å¯Ÿè±¡ã«ãªã£ãåºéã¯2026幎11æ3æ¥ã®13:46ã14:18ã§ãééã¯æå°7ç§ãæå€§90ç§ã§ããã
ãããã«
ããŒã¿ã®åéããäœçœ®ã®æ€çŽ¢ããã€ãªããã®æ¢çŽ¢ããåãADBã«ãŸãšããŠã¢ããªã«ããã
ããããæ©èœã®çµã¿åããã詊ããŠã¿ãããŠãä»åã¯éœãã¹ã®ãªãŒãã³ããŒã¿ã顿ã«ããŠã¿ãŸããã
ããŒã¿ã®åºå žãšåèãªã³ã¯
- ããŒã¿ïŒæ±äº¬éœäº€éå±ãå ¬å ±äº€éãªãŒãã³ããŒã¿åè°äŒã®ããŒã¿ãå å·¥ããŠäœæ
- å ¬å ±äº€éãªãŒãã³ããŒã¿ã»ã³ã¿ãŒ éçºè ãµã€ã
- èæ¯å°å³ïŒå°çé¢ã¿ã€ã«ãå å·¥ããŠå©çš
- Oracle APEXã«ã€ããŠ
- Autonomous AI Databaseã§ã®Oracle Graphã®äœ¿çš







