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