The combination of PostgreSQL and PostGIS provides a robust database platform that supports the integrated management of both geospatial data and attributes associated with those data in a database system that is supported by a large number of client applications, including GIS and mapping applications. PostgreSQL is an open source object-relational database server that implements the Structured Query Language (SQL) for database design, management, and use. PostGIS is an implementation of the Open Geospatial Consortium’s “Simple Features Specification for SQL” standard which defines data types and functions that may be implemented in a SQL database for the storage and management of geospatial data within the database.

TLA-team: A freely available relational database system that can be used to store and retrieve all kinds of structured data. It offers more functinality compared to mySQL. Some peope also use it for linguistics tasks such as storing lexica and annotations. In that case Postgres is used as a big container which covers all sorts of data in encapsulated form, i.e. any function to be carried out on the data is dependent on the availablity of the Postgres code and on additional code on top of the relationla database. This is the reason why we believe that the system has severe drawbacks as container for data, however it could be used due to efficient query mechanisms for storing indexes etc.

http://www.postgresql.org/

Facebooktwittergoogle_pluslinkedin