OLTP vs OLAP: how do the workloads, schemas, and storage differ?

Answer preview

OLTP (online transaction processing) runs the business — many short, concurrent, write-heavy transactions touching a few rows each, on a normalised schema. OLAP (online analytical processing) analyses the business — few long, read-only queries scanning millions of rows to aggrega…