Difference Between OLTP And OLAP

Share

OLTP and OLAP are very common systems for online processing. The OLTP one is completely transactional-based processing and when it comes to the OLAP one is completely analytically based processing.

OLTP

OLTP stands for Online Transactional Processing system, which completely means that the core of this processing system is to have some transactions which could then inserted, deleted or updated depending upon the requirements. Now, this scenario clearly indicates that these transactional queries are quite short and much simpler. Thus makes the process very less time consuming as well as low in memory usage.

Some examples of OLTP system are as follows:

(1) Airplane ticket booking

(2) Online banking

OLAP

OLAP stands for Online Analytical Processing system, which in layman’s terms means that it stores the old/previous data which was taken as an input from the OLTP system. The OLAP gives you the privilege to have a multi-dimensional summary of the historical data, and then this derived information can be used for the final decision-making process.

Some examples of OLAP system are as follows:

(1) Financial reporting

(2) Sales and marketing

OLTP Vs OLAP

[wpsm_comparison_table id=”34″ class=”center-table-align”]

 

Rupesh Rawat

Published by
Rupesh Rawat
Tags: database DATABASE WAREHOUSE AND DATA MINING dbms DWDM OLAP OLTP