SPECIAL ISSUE
AUGUST 2008
GIS Databases For Spatial Storage
Introduction PostGIS More information: http:// www.oracle.com/technology/ PostGIS is an open source geoIf you are looking into products/spatial/index.html graphic information system softdatabases that can support ware program that adds support spatial data storage, there are MS SQL Server 2008 for geographic objects to the Post3 good databases that you can Microsoft has upgraded its greSQL object-relational database. use: SQL server to MS SQL Server PostGIS follows the Simple Fea2008. This new upgrade of • Oracle Spatial tures for SQL specification from MS SQL Server 2008 promthe Open Geospatial Consortium. • MS SQL Server 2008 ises to be boon to the use of There is a number of software business intelligence in the • PostGIS products that can use PostGIS as a business world. Oracle Spatial & In addition to the above, MS database backend: Oracle Locator SQL Server 2008 can also • Manifold System The location features in assist in the following areas: Oracle Database 11g provide • ArcSDE 9.3 • Reporting Service a platform that supports a More information: http:// wide range of applications • Data mining en.wikipedia.org/wiki/PostGIS such as GIS, location-enabled • Data warehousing business intelligence, etc. Other notable Oracle tools: • Oracle MapViewer • Analysis services
“…………. there are 3 good databases that you can use…….. Oracle Spatial… MS SQL Server 2008……. PostGIS…..”
It is an Oracle Application Server Java component and JDeveloper extension used for map rendering and viewing geospatial data managed by Oracle Spatial or Locator.
More information: http:// www.microsoft.com/ sqlserver/2008/en/us/ default.aspx