| |
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, 2007 12:18:53 |
#10 |
| mrudula |
Member Since: Visitor Total Comments: N/A |
RE: What is the Difference between OLTP and OLAP
|
oltp:
1.current data only
2.insert,update,delete operations are possible
3.continous changing of data
4.1 year data is present
5.only one record is processed at a time
6.data is present in 2d format
olap:
1.current+historical data
2.used for reprting and analysis
3.non volatile in nature
4.5-30 yrs of data is stored
5.group of records processed at a time
6.data is present in muti dim format
|
| |
Back To Question | |
