Difference between OLAP and OLTP

BusinessSales & MarketingDatabase

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.KeyOLAPOLTP
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.
raja
Published on 27-Jan-2020 15:08:41
Advertisements