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. P. On Thu, Jul 17, 2008 at 5:23 PM, Martin Davis <[EMAIL PROTECTED]> 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 >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > > -- > Martin Davis > Senior Technical Architect > Refractions Research, Inc. > (250) 383-3022 > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
