What is the difference between OLTP and OLAP?
SQLLevel: IntermediateDatabase Design
What is the difference between OLTP and OLAP?
Hints
- Define one output row and the source-table keys.
- Check duplicates, NULLs and the order of filtering and aggregation.
Answer
OLTP (Online Transaction Processing): optimized for many small, fast read/write transactions. Think a web application writing orders. Normalized schema, indexed for point lookups.
OLAP (Online Analytical Processing): optimized for complex analytical queries over large amounts of data. Think monthly sales reports. Denormalized, often uses star/snowflake schemas, column-oriented storage.
The query patterns are fundamentally different, which is why databases like Redshift, BigQuery, and Snowflake exist alongside transactional databases like PostgreSQL and MySQL.
Source and licence: SQL Interview Questions — Arda Kocadoru · MIT