OLAP vs OLTP - Techment

Data warehouse for BI (OLAP) vs ERP system (OLTP).

Synonyms:

Analytical vs transactional systems, BI vs operational databases

Defnition:
OLAP supports analytical workloads; OLTP supports transactional operations. Both require different architecture optimizations.

Variations:
OLAP architecture, OLTP architecture