What are the differences between OLTP and OLAP?

Answer»

OLTP	OLAP
Online Transactional System or OLTP DEALS with a huge number of short online transactions.	Online Analysis and DATA retrieving Process or OLAP deals with large data volume.
Makes USE of traditional DMBS.	Makes use of huge data warehouses.
Tables in the databases are normalized.	Tables are not normalized here.
The RESPONSE time is in the range of milliseconds.	Takes seconds to minutes to usually get a response.
Designed for real-time business applications.	Designed for data analysis measured using category and ATTRIBUTES.

Discussion