PostgreSQL
*It was first released in 1989 as a project at the University of California, Berkeley.
*PostgreSQL is an advanced relational database system.
*PostgreSQL supports both relational (SQL) and non-relational (JSON) queries.
*PostgreSQL is free and open-source.
5. Data Storage
Data is stored in tables (rows & columns).
Each table belongs to a schema.
Schemas belong to a database.
Data files are stored in the data directory on disk.
Indexes improve query performance (B-tree, Hash, GIN, GiST, BRIN).
(1)PostgreSQL as Object-Relational Database (ORDBMS)
Unlike a normal RDBMS (like MySQL), PostgreSQL supports object features inside relational tables. That’s why it’s called object-relational.
Examples of ORDBMS:
PostgreSQL (most popular open-source ORDBMS)
Oracle (from version 8 onwards)
IBM Db2
Informix
Examples of RDBMS:
MySQL
Microsoft SQL Server
Oracle (basic relational features)
PostgreSQL (can also act as pure RDBMS)
Top comments (0)