Contents 🔗︎
What is the difference between an OLTP and an OLAP database?
OLTP 🔗︎
OLTP stands for “Online Transation Processing”.
Examples
- PostgreSQL
- Google Cloud Spanner
- MariaDB
- MySQL
OLAP 🔗︎
OLAP is “Online Analytical Processing”.
Examples of OLAP databases
- Apache Druid
- DuckDB
- Clickhouse