OLAP stands for On-Line Analytical Processing. It is used for analysis of database information from multiple database systems at one time such as sales analysis and forecasting, market research, budgeting and etc. Data Warehouse is the example of OLAP system.
OLTP stands for On-Line Transactional processing. It is used for maintaining the online transaction and record integrity in multiple access environments. OLTP is a system that manages very large number of short online transactions for example, ATM.
| Sr. No. | Key | OLAP | OLTP |
|---|---|---|---|
| 1 | Basic | It is used for data analysis | It is used to manage very large number of online short transactions |
| 2 | Database Type | It uses data warehouse | It uses traditional DBMS |
| 3 | Data Modification | It manages all insert, update and delete transaction | It is mainly used for data reading |
| 4 | Response time | Processing is little slow | In Milliseconds |
| 5 | Normalization | Tables in OLAP database are not normalized. | Tables in OLTP database are normalized. |