🟣 Terminology: OLAP vs OLTP

OLTP (Online Transaction Processing) - Optimized for fast individual transactions: INSERT, UPDATE, DELETE one row - Row-based storage - Used by applications (checkout page, banking transfer) - Think: "cash register"

OLAP (Online Analytical Processing) - Optimized for complex queries: aggregate millions of rows, GROUP BY, JOINs - Columnar storage (reads only needed columns → faster for analytics) - Used by analysts, dashboards, BI tools - Think: "business intelligence"