[postgis-users] Compare SQL Server 2008 Spatial, PostGIS, MySQL functionality
pramsey at cleverelephant.ca
Thu Jul 17 17:31:13 PDT 2008
I'm not that any of the databases use the hipparchus mesh.
IBM Informix Geodetic might, but I think someone told me they
*didn't*, as it wasn't "all that".
IBM Informix Spatial has an R-Tree
IBM DB2 Spatial I think uses a quadtree
IBM DB2 Geodetic I think *does* use the hipparchus mesh
PostGIS uses an R-Tree, that happens to be implemented on the GiST
infrastructure, but it's still an R-Tree: same picksplit algorithms,
same tree structure. Just call it an R-Tree and leave it at that.
On Thu, Jul 17, 2008 at 5:23 PM, Martin Davis <mbdavis at refractions.net> wrote:
> 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.
> Paragon wrote:
>> 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
>> 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
> Martin Davis
> Senior Technical Architect
> Refractions Research, Inc.
> (250) 383-3022
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users