[OSGeo-Discuss] any spatial databases for high performance geo-computing

[Schuyler Erle]

Two options for distributed spatial databasing, based on Solr's spatial types:

  ElasticSearch: http://www.elasticsearchtutorial.com/spatial-search-tutorial.html

  Riak: http://www.christopherbiscardi.com/2014/02/07/geospatial-indexing-with-riak-search-2-0-yokozunasolr/

I've had great success with ElasticSearch and spatial search, but not in a clustered configuration. Riak is designed from the ground up to be a distributed database, but its Solr support is quite new and still in beta. Neither one support particularly complex geometric operations AFAIK, so YMMV. Good luck!

SDE

On May 19, 2014, at 3:04 PM, "Zhang, Shuai" <shuai at illinois.edu> wrote:

> Hi All,
> 
> sorry for asking, but what do you think is a good choice of spatial database for high performance geo-computing?
> 
> In some high performance computing scenarios, data size tends to be huge, and a bunch of computer clusters work together with high throughput and tense computation. sometimes we use parallel filesystems like lustre, gfs, hdfs to handle specific problems but what if a spatial database?
> 
> I explored some of postgresql cluster solutions, such as streaming replication, pgpool, slony and so on. I think most of them are designed for failover, and they might not be able to stand up with the huge data size and high performance demands. the case is quite alike in oracle and db2 spatial, i think.
> 
> so any suggestions for projects aiming to build a distributed and parallel spatial database running on a cluster?
> 
> Thanks,
> shuai
> _______________________________________________
> Discuss mailing list
> Discuss at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss