Data Mart....

Well...
as i explained about the definitions of DWH., Now am going to tell you about a word "DATA MART"

We know that DWH is a also Database which will be designed with the information from Multiple
Operational Databases, Data Mart is a Sub-Set of DWH.
DataMart is used to maintain the business needful data of Department specific business users (or) Middle Management.
A DataMart is known as High Performance Query Structures(HPQS).
reason: Since the DataMart is a sub-set of a DWH database, the processing time for Execution of Query is very less as a DWH is a Huge Database.

Few differences btw DATA MART & DATA WARE HOUSING...

DM : Defines a Single subject.
DWH: Defines Integration of Multiple subjects.

DM : Designed for Middle Management Access.
DWH: Designed for Top Management Access.

DM : Stores dept. specific business information.
DWH: Used to store Enterprise-wise Business info.


There are two types of DataMarts...
(i) Dependent Data Mart.
(ii) Independent Data Mart.

To know these two types, we need to know two DWH approaches...

Will tell you in detail in my next post., as a bit tired for today.
I don't want this Blog to be IDLE for a while, so came here now with this topic...

Catch you soon... till then, keep rocking.

Enjoy The Joy.....