| Online Transactional System or OLTP DEALS with a huge number of short online transactions. | Online Analysis and DATA retrieving Process or OLAP deals with large data volume. |
| Makes USE of traditional DMBS. | Makes use of huge data warehouses. |
| Tables in the databases are normalized. | Tables are not normalized here. |
| The RESPONSE time is in the range of milliseconds. | Takes seconds to minutes to usually get a response. |
| Designed for real-time business applications. | Designed for data analysis measured using category and ATTRIBUTES. |