|
Answer» The differences between OLAP and OTLP are given below. OLAP
| OLTP
| It is used for managing informational DATA
| It is used for managing operational data
| The size of database is 100 GB-TB
| The size of database is 100 MB-GB
| It contains large volume of data
| The volume of STORED data is not that much large
| It has mainly one ACCESS mode that is write mode
| It has both read and write access modes
| It is partially normalized
| It is completely normalized
| Its processing speed is DEPENDENT on lot of factors like the complex queries, number of files it contains etc
| It has very high processing speed
| It is market oriented and is mainly used by analysts, managers and executives
| It is customer oriented and is mainly used by clerks, clients and IT professionals
|
|
