Backend & systems·Data modelling and storage engines
your query reads three columns across two billion rows and nobody minds if it takes forty seconds.
OLAP
Also calledonline analytical processing, analytical workload, columnar storage
The workload shape of analytics: few columns, enormous row counts, aggregation rather than point lookup. Columnar storage serves it because it reads only the columns referenced and compresses each one well. Mixing it onto the transactional database is the most common cause of an unexplained latency spike on the write path.