OLTP - Online transaction processing , these workloads are heavily focused on writes, updates and transactions. Typical relational databases such MySQL etc. OLAP - Online analytical processing , these workloads are heavily focused on reads, used for analytical processing as the names suggests for example number of x model car sales in year yy. Read heavy.