[postgis-users] Compare SQL Server 2008 Spatial, PostGIS, MySQL functionality

Paul Ramsey 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
>> MySQL.
>> 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.
>> http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_pos
>> tgis_mysql_compare
>> Thanks,
>> Regina and Leo
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> --
> Martin Davis
> Senior Technical Architect
> Refractions Research, Inc.
> (250) 383-3022
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list