Tuesday, December 20, 2016

Database Design in OLAP

Database Design in OLAP :-
-------------------------
* MDM:- Multi dimensional model.
* We can analyze data from multiple angles/dimensions by slicing and dicing the Info Cube.

*Star Schema:-
-------------- 
* Fact Table/Transaction data table at the center surrounded by Dimension tables/Master data tables connected with Primary Key - Foreign Key and all these tables existing inside the cube.

* Fact Table?
-------------
* any data what is stored in this table cannot be changed.

* Transaction data Table ?
-------------------------
* We store Transaction data in this table.

* Master data Tables ?
----------------------
* These tables store Master data(Detailed information about an entity).

* Dimension Tables ?
---------------------
* Each Master data table is acting as a side of a cube.

* Transaction Data Table / Fact Table will have 2 types of Coloumns:-

 a) Characteristics : on what basis we  analyze a keyfigure.

 b) Keyfigures : What we are   Analyzing.

* Each Characteristics coloumn in the fact table/transaction data table will connect to one Dimension table/Master data Table.

Labels: ,

Types of ODS

Types of ODS:-
--------------
1) Standard
2) Transactional

1) Standard:-
--------------
* Data Target and Info Provider

2) Transactional:-
--------------------
* Used only for Planning. 
* Not available for Reporting.
* Only Active Data Table.
* Loading Data into Sebsequent data targets is possible.

Labels: