OLTP (Online Transaction Processing)
They are relational databases for frequent read and writes. They are optimized for fast queries, which are regular and predictable. They require memory for keeping frequently access data.
OLAP (Online Analytic Processing)
They are relational databases, suitable for complex queries against large data sets. They have heavy compute and storage requirements.