Sunday 22 June 2014

MSBI OLTP and OLAP

MSBI OLTP and OLAP

OLTP: Online transnational processing
It is a database
It is 2 dimensional database, mean it is a table structure.
We can do Data manipulation. Ex: Insert, Update, delete, select operations
Here execution is slow
OLAP: Online Analytic processing
It is a database
It is multidimensional
We can do only select operation
Here execution is very fast
Raw data (OLTP)-->SSIS-->Database(OLTP) (it is also called as Data Warehouse)
Database(OLTP)-->SSAS-->Cube(OLAP)
Database(OLAP) which is output of SSAS --->SSRS-->Reports  Or
Database(OLTP) which is output of SSIS--->SSRS-->Reports
SSRS input: we can give SSRS input 2 ways.
1.SSAS output (If your database is huge)
2.SSIS output (If your database is small)
When we need SSAS?
If your data base is (O/p of SSIS is slow then we will go for SSAS. in SSAS, we will convert 2 dimensional data base in to multidimensional cube.
So that performance will be high.
If you are having less data then no need of SSAS.
We can using Excel to show the reports using SSAS, instead of SSRS.