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
|
