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 (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 (aka OLTP) On-line Transactional Processing are usually track real time information.