Answer Detail: RE: What is the Difference between OLTP and OLAP

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: What is the Difference between OLTP and OLAP

Answer:
Answered by swetha on 2005-03-30 12:00:33: OLTP

Current data
Short database transactions
Online update/insert/delete
Normalization is promoted
High volume transactions
Transaction recovery is necessary

OLAP
Current and historical data
Long database transactions
Batch update/insert/delete
Denormalization is promoted
Low volume transactions
Transaction recovery is not necessary

October 10, 2005 01:40:39	#3
senthil kumar.B	CRM Expert Member Since: October 2005 Total Comments: 15
RE: What is the Difference between OLTP and OLAP
OLTP is nothing but OnLine Transaction Processing ,which contains a normalised tables and online data,which have frequent insert/updates/delete. But OLAP(Online Analtical Programming) contains the history of OLTP data, which is, non-volatile ,acts as a Decisions Support System and is used for creating forecasting reports.

Back To Question