PostgreSQL can also be used in the field of Business Intelligence as a data warehouse, in conjunction with reporting tools (BusinessObjects, Pentaho, etc). It supports JSON format data, consisting of key-value pairs, allowing it to also satisfy the use cases of NoSQL-like solutions. There is a PostgreSQL extension for geographic objects (PostGIS 3) that conforms to the Open Geospatial Consortium (OGC) Standards. PostgreSQL is an SQL compliant database management system, typically used in transactional applications to ensure data persistence, much like similar commercial products (Oracle, DB2, Informix, MS SQL, Sybase, etc). \pagebreak Satisfying requirements Use cases The initial document was authored collaboratively by Mimprod 1 and PGGTIE 2. This guide aims, without going too deep into the details of the technical implementation, to demonstrate the benefits of PostgreSQL by describing the integration, security and robustness mechanisms. Its objective is to answer the questions of project owners and project managers for the implementation of PostgreSQL as a replacement for a commercial solution. This guide presents the implementation of PostgreSQL compared to commercial solutions. This guide was produced within the framework of the "Ayrault" circular of Septemon the use of free software in the French administration, which led to the creation of the inter-ministerial "Socle Interministériel du Logiciel Libre" (SILL). This document is released under the ( PostgreSQL license). Publication of the first version in French History of this document versions: Version
0 Comments
Leave a Reply. |