Write down the difference between OLTP and OLAP?

Answer»

OLTP	OLAP
This is an ONLINE TRANSACTIONAL System.	This is an online analysis and data retrieving process.
It comprises of a large NUMBER of short online transactions.	It comprises of a large volume of data.
This USES a TRADITIONAL DBMS.	This uses a Data Warehouse.
Here the tables are normalized	Here, the tables are not normalized.
It is designed for real-time business operations due to its fast response rate.	It is designed for the analysis of business measures via attributes and categories.

Discussion