EnjoY | Database Research And Development: SQL Server : Difference between OLAP and OLTP

Tuesday, October 13, 2020

SQL Server : Difference between OLAP and OLTP

This article is half-done without your Comment! *** Please share your thoughts via Comment ***


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.

No comments:

Post a Comment

It’s all about friendly conversation here at small review :) I’d love to be hear your thoughts!

Be sure to check back again because I do make every effort to reply to your comments here.

Featured Post

SQL Server : SELECT all columns to be good or bad in database system

This article is half-done without your Comment! *** Please share your thoughts via Comment *** In this post, I am going to write about one o...

Popular Posts