Oracle中查找最短路径的查询
我正在开始研究 Oracle 11g 空间数据库，我想知道是否有一个查询可以返回两点之间或点与线串之间的最短路径（或路径）。
我有一张带有一些线串（远足路线）和多边形（地理事故）的地图，我想找到我现在所在位置和最近的路线之间的最短路线，同时避免事故。我已经有一个查询可以返回最近的踪迹，但不会显示事故的轮廓。
非常感谢。
I'm starting studies in Oracle 11g Spatial Databases and I want to know if is there a query that returns the shortest route (or path) between two points, or between a point and a linestring.
I have a map with some linestring (hiking trails) and Polygons (geographic accidents) and I want to find the shortest route between where I am now and the nearest trail while avoiding the accidents. I already have a query that returns me the nearest trail, but does not contours the accidents.
Thank you very much.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
用这样的请求给 oracle 服务器增加负担并不是一个好主意。
优化、决策和组合算法应在 Lingo、Lindo、Fortran 或其他专业应用程序上运行。
Oracle 应该只关心存储和检索数据，而不关心优化问题。
正如弗洛伊德曾经说过的：“有时，数据库只是数据库”。我一想到可能是别的东西就疯了，但现在，多亏了这种弗洛伊德的洞察力，我神志清醒。
It is a bad idea to burden the oracle server at all with requests like this.
Optimization, decision and combinatorial algorithms should be run on Lingo, Lindo, Fortran or another specialist application.
Oracle should bother only with storing and retrieving data, not with otimization problems.
As Freud once said: "sometimes, a database is just a database". I was crazy upon thinking it could be something else, but now, thanks to this freudian insight, I'm sane.