[postgis-users] Compare SQL Server 2008 Spatial, PostGIS, MySQLfunctionality
lr at pcorp.us
Thu Jul 17 17:34:00 PDT 2008
Never mind my last comment about Mapserver. I see there is one mentioned
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Martin
Sent: Thursday, July 17, 2008 8:24 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Compare SQL Server 2008 Spatial, PostGIS,
A couple of comments:
Web Mapping Toolkits - the latest release of MapServer claims to support
SQLServer (although with what actual functionality I don't know)
Spatial Indexes - SQLServer does use a multi-level grid hierarchy as stated,
but Oracle and IBM do not. Oracle supports an R-tree index, and recommends
using it for spatial indexing. IBM I think uses the somewhat bizarre
Hipparchus index (although they may also support something more orthodox).
A key difference between R-trees and grid indexes is that R-trees are
self-tuning and do not require any magic configuration parameters.
> As part of our due diligence work, we are formulating a comparison of
> the spatial functionality offered by SQL Server 2008 Spatial, PostGIS and
> Its currently in draft, but we hope to release within the next week.
> We would appreciate if people could take a quick look at it and let us
> know if you see any gross errors or important things we left out.
> Most of this information we curled from reading the help docs of each
> product and from our general familiarity with the databases and GIS
> products out there. We tried to be as fair as possible.
> Regina and Leo
> postgis-users mailing list
> postgis-users at postgis.refractions.net
Senior Technical Architect
Refractions Research, Inc.
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users