1
SQLIntermediate#security
SQLIntermediate#architecture
OLTP vs OLAP?
OLTP systems handle many small concurrent transactions on normalized schemas (banking, e-commerce checkout). OLAP systems run large aggregate scans on denormalized star schemas for reporting.
Example
OLTP: INSERT INTO orders ... (thousands per second) OLAP: SELECT region, SUM(total) FROM fact_sales GROUP BY region;