| |
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
|
| March 03, 2006 09:13:07 |
#4 |
| Shadrach Rathinaraj |
Database Expert Member Since: December 2005 Total Comments: 3 |
RE: What is the Difference between OLTP and OLAP
|
Hey add this point also, Index OLTP : FEW OLAP : MANY JOINS OLTP : MANY OLAP : FEW Deepa |
| |
Back To Question | |
