| 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. |
Wednesday, November 30, 2011
Difference between OLTP and DWH/DS/OLAP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment