OLTP vs OLAP

• OLTP
• On-Line Transaction Processing
• Daily/Real Time Processing
• OLAP
• On-Line Analytical Processing
• Data Warehouses
• Post Processing

Transaction vs Analytical

Transaction

Analytical

https://www.youtube.com/watch?v=-v3PhEtOuxw