OLAP vs OLTP
OLTP servers handle mission-critical production data accessed through simple queries
- usually handles queries of an automated nature
- OLTP applications consist of a large number of relatively simple transactions.
- Most often contains data organised on the basis of logical relations between normalised tables
-
OLAP servers handle management-critical data accessed through an iterative analytical investigation
- usually handles queries of an ad-hoc nature
- supports more complex and demanding transactions
- contains logically organised data in multiple dimensions