These days when we talk about databases in the wild, we are mostly talking about two types of databases

• Analytic Database
• Operational Database

Analytic Database

Analytic database (aka OLAP) On-line Analytical Processing are primarily static, read only database which stored archived and historical data used for analysis.

Ex: A company might store their sales information over some year in an analytic database and use that database to analyze their strategies to take an appropriate decision.

Operational Database

Operational database (aka OLTP) On-line Transactional Processing are usually track real time information.