Wednesday, November 30, 2011

Difference between OLTP and DWH/DS/OLAP


OLTP
DWH/DSS/OLAP
OLTP maintains only current information.
OLAP contains full history.
It is a normalized structure.
It is a de-normalized structure.
Its volatile system.
Its non-volatile system.
It cannot be used for reporting purpose.
It’s a pure reporting system.
Since it is normalized structure so here it requires multiple joins to fetch the data.
Here it does not require much joins to fetch the data.
It’s not time variant.
Its time variant.
It’s a pure relational model.
It’s a dimensional model.

No comments:

Post a Comment