OLTP vs OLAP in database
In this tutorial we will learn the concept of OLTP vs OLAP in database. Every dba should know the concept of OLTP and OLAP.
What does OLTP stand for:-
OLTP stands for online transaction processing. Normally we create OLTP database for ongoing transaction environment and OLTP database is used for day to day transaction activity for business need. As day to day transaction activities are happening therefore data always up-to-date.OLTP database stores current data for day to day activity. Database size of OLTP database normally calculated in GB.OLTP database is handled by large no of people .
We can found details data in OLTP database for business requirements.Datas in the OLTP database found in normalized manner as many small tables are linked with each other using join function.OLTP database normally used by DBA.Normally OLTP database supports read and write both operation .
OLTP Example:-
Any e-commerce sites use OLTP database for day to day business transaction.
What does OLAP stand for :-
OLAP stands online analytical processing.Normally we create OLAP database for create report as well as dashboard for decision making and trending analysis. It stores historical summarised data to create report and dashboard. Data comes from OLTP database for that data is not frquently updated and data stores in OLAP database in denormalized Mannar.OLAP Database normally used by MD ,CEO for decision making purpose.
OLAP database normally use to analysis data to make bussiness decision so that OLAP database stores historical data to analysis data for results which is necessary to make decisions.Database size of OLAP database normally calculated in TB as large no of records is stored into OLAP database .OLAP database is handled by few no of people .Normally OLAP databse supports only read operation.
OLAP Example:-
If we need any report for decision making for past 15 years we need OLAP database to make dashboard using OLAP summarised data.
In this tutorial we have learned the concept of OLTP vs OLAP in database.
0 comments:
Post a Comment