Google interview question
What are the differences between OLAP and OLTP?
Interview Answer
Anonymous
1 Dec 2019
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.