Monday, May 14, 2012

Ingres Db adds spatial capability

The latest version of Ingres relational database now also includes support for geospatial data. GIS functions and spatial data types are included out-of-the-box (i.e. do not require additional plug-ins) and make it easy to enable web mapping. Ingres 10S supports spatial applications, such as Esri’s ArcGIS for Desktop and FME but also MapServer and GeoServer.

Ingres 10S is supported by other programming libraries including GDAL/OGR and GeoTools, allowing import, export and manipulation of vector data. Ingres 10S leverages the GEOS geometry and PROJ cartographic projection libraries for manipulating and transforming spatial data between dozens of geographic and planar co-ordinate systems.

Ingres 10S is an open source, enterprise grade database, not as popular as MySQL or PostgesSQL but, as the other options, can be downloaded and used for free. Ingres was first created as a research project at the University of California, Berkeley in the early 1970s. Since the mid-1980s, Ingres has spawned a number of commercial database applications, including Sybase, Microsoft SQL Server, NonStop SQL, but also open source PostgreSQL (which with PostGIS extension is the most popular open source spatial database).

No comments: