What is OLAP vs OLTP

« Back to Glossary Index

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

Hello popup window