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

August 08, 2006 05:37:44	#7
Krishna Chowdary	Member Since: Visitor Total Comments: N/A
RE: What is the Difference between OLTP and OLAP
In Oltp's, Data Can be insert,update and Delete.Follows ER Modeling In OLap's Data cannot be insert,update and Detete. Follows Dimensional Modeling.

Back To Question