[DWH] Difference Between OLTP And OLAP

Difference between OLTP & OLAP

Online Transaction Processing (OLTP)	Online Analytical Processing (OLAP)
Application Oriented	Used to analyze and forecast business needs
Up to date and consistent at all times	Data is consistent only up to the last update
Detailed data	Summarized data
Isolated data	Integrated data
Queries touch small amount of data	Queries touch large amounts of data
Fast response time	Slow response time
Updates are frequent	Updates are less frequent
Concurrency is the biggest performance concern	Each report or query requires lot of resources
Clerical Users	Managerial/Business Users
OLTP targets specific process like ordering from an online store	OLAP integrates data from different processes like (Ordering, processing, inventory, sales etc.,)
Performance sensitive	Performance relaxed
Few accessed records per time	Large volumes accessed at a time
Read/Update access	Mostly read and occasional update
No redundancy	Redundancy cannot be avoided
Databases size is usually around 100 MB to 100 GB	Databases size is usually around 100 GB to a few TB