Parameters | OLTP | OLAP |
---|---|---|
Stands for | Online Transactional Processing | Online Analytical Processing |
Process | A transactional mechanism for controlling database modifications. | Online analysis and data retrieving process. |
Characteristic | Large numbers of online transactions characterize it. | A large volume of data characterizes it. |
Method | Traditional DBMS. | Data warehouse. |
Database normalization | Normalized | Unnormalized or denormalized |
Operation | INSERT , DELETE and UPDATE commands. | Mostly SELECT operations. |
Response Time | Milliseconds | Seconds to minutes (It depends on the data amount that has to be processed) |
Storage size | Small database | Large database |
Response | It offers quick results for frequently utilized data. | It offers a consistently faster response to requests. |
Audience | Market-oriented information. | Customer-oriented information. |