What is OLTP and OLAP?
OLTP stands for OnLine Transaction Processing. It is designed for business transaction process. It is designed for fast storing of data. The data here is in normalized form without data duplicates
OLAP stands for OnLine Analytical Processing. It is designed for analyzing the business. It is designed for fast retrieving of data. The data here is in de-normalized form with data duplicates
OLTP-------------------------> ETL--------------------> OLAP
OLTP OLAP
To support business transaction processing To support decision making process
Volatile data Non volatile data
Current data Historical data
Detailed data Summary data
Designed for running the business Designed for analyzing the business
Normalization De-normalization
Application oriented data Subject oriented data
ER modelling Dimensional modelling
NOTE: ETL stands for extract transform and load
Useful information thank you for sharing this. Know more about OBIEE Online Training
ReplyDeleteIf you are looking for Best PMP Training and Certification in Bengaluru? Check and enroll for project management professional course - PMP Training in Bengaluru
ReplyDelete