What is PostgreSQL?

This video defines what is a PostgreSQL database. Below is the notes used in this video:

***
Database: Data + Base
Respository of Data
Collection of data

In 1970, E.F.Codd: Relational Data model (Prior to this: File, Hierarchical, N/w)

Database DBMS
Relational Databases RDBMS
Object Relational Databases ORDBMS

Based upon business use cases:

Structured:
**********
1) Transactional (OLTP)
Transaction time is 1 or 2 minutes
Ex: Oracle, IBM DB2, Microsoft SQL Server, PostgreSQL
Closed source: Oracle, DB2, SQL Server
Open Source: MySQL, Postgresql

2) Data Warehousing/OLAP/DW/DSS
Transaction times are little longer
Ex: IBM Netezza, EMC Greenplum, Oracle Exadata, HP Vertica, etc

Unstructured:
**************
3) Bigdata/NoSQL: Unstructured
***

[jbaker]

I LOVE your format! It's like you're writing it into my mind. Great work!

[anandakumarsanthinathan]

Very insightful. I didn't know that many popular pure-play data warehouse products have been using Postgres engines.

[sivasaikiran]

Sir, please post all the postgresql dba videos.. ❤ thank you sir.

[nickamplified]

Thanks for posting. Simple but very informative.

[anantsaini]

Excellent video ....sir....it was really helpful

[varun]

sir do we have cluster postgres sql just like RAC in oracle ?

[bluekriptek]

Is it virus it’s on my pc for some reason

[mercylinaeyaofunudeh]

Can you start a class please....it will be of great help to us who is about to go into collagw