OLTP vs OLAP

OLTP: Online Transaction Processing

Focused on optimized for processing a large number of short, fast transactions, simple & repetitive transactions.

Focused on optimized for quering and aggregating large datasets to support decision-making.