Backend & systems·Data modelling and storage engines
your queries touch a handful of rows by key, thousands of times a second, and each one has to come back in milliseconds.
OLTP
Also calledonline transaction processing, transactional workload
The workload shape of an application database: small reads and writes by primary key, high concurrency, low latency per statement. Row-oriented storage and B-tree indexes exist for this shape. Running a analytical scan against the same instance is how one report takes the product down.