开发者

What is an efficient way to store georeferenced information for web services?

开发者 https://www.devze.com 2023-02-20 23:21 出处:网络
I am specifically thinking about Ovi Maps or any other similar georeferenced web service. What is an efficient way to partition data so to scale properly? How do these services store data so to reduce

I am specifically thinking about Ovi Maps or any other similar georeferenced web service. What is an efficient way to partition data so to scale properly? How do these services store data so to reduce the effort necessary to lookup a street in a city of nation s开发者_如何学Gotarting from a pair of coordinates? How do they also store the "shape" of geographical entities? P.S: This was an interview question.


OpenGIS is a good reference/standard for location based entities/services: http://www.opengeospatial.org/

MySQL, the commonly used RDBMS has some geospatial support. http://dev.mysql.com/doc/refman/5.5/en/spatial-extensions.html

I don't have experience of sharding/partitioning data like this but guess you could do so by country or by creating "tiles".

0

精彩评论

暂无评论...
验证码 换一张
取 消