OLAP: Designed for analytics, a lot of reads and aggregation of data. Data warehouse systems belong to OLAP. Examples are Clickhouse and DuckDB
OLTP: Handles large number of transactions, normalization of data, handles operative tasks. Examples are Postgresql, MySQL