What is the difference between OLTP and OLAP?

What is the difference between OLTP and OLAP?

Approach: Compare transaction processing with analytical processing.

OLTP (Online Transactional Processing) manages operational data with high volumes of short, fast transactions. OLAP (Online Analytical Processing) manages historical data for complex queries and multi-dimensional analysis.

Follow-up: Which is better for a data warehouse?

Key concepts: row storage, columnar storage, latency.