Monday 9 May 2016

Difference between OLTP (Online transactional processing) and OLAP (Online Analytical processing)

Below are the differences in OLTP and OLAP

S no.

OLTP

OLAP

1
Transactional processing
Query processing
2
Time sensitive
History Oriented
3
Operational data
Historical data
4
Relatively Small Data Base
Large data base size
5
Volatile Data
Non- volatile Data
6
Store all data
Stores relevant Data
7
Not Flexible
Flexible

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts