PostgreSQL- A good choice of object-relational database management system (ORDBMS).
PostgreSQL is an open source object-relational database management system (ORDBMS). It provides functions that could meet the requirements of modern software development. Some of its characteristics are described as follows:
- Has its built-in PL/pgSQL, which is closed to the PL/SQL of Oracle database.
- Supports well data accessing from various programming languages including Java, PHP, Pearl, Python, Ruby, etc.
- Has built-in index support.
- Has built-in trigger support.
- Has MVCC (Multi-Version Concurrency Control) feature, which permit users to make changes of the database without the need to lock any reading procedures.
- Permits users to create additional objects such as functions, operators, data types, etc.
PostgreSQL still has its own limitation, as no tools can be the best choice in all programming scenarios. PostgreSQL does not run well in Windows environment, and also not have good support for .net. However, with its advantages, especially as a free database solution; PostgreSQL has been used in many applications of large successful businesses including Yahoo, MySpace, Sony Online, hi5.com, etc., and still a good choice for developing robust applications.
Tags:object relationaloracle databasepostgresql
