Nov 20, 2009

Data Warehouse Design

Data Warehouse can be designed in two different ways based on Ralph Kimball and Bill Inmon's model.
In Inmon's architecture data from OLTP databse is stored in a warehouse before it is transferred to the data marts. In Inmon's view the data warehouse is a real database.

According to Kimball's architecture data is transferred directly from OLTP database to the data mart. In Kimball's model the data warehouse is actually a collection of integrated data marts.

8 comments:

Negi said...

Thanks for great information you write it very clean. I am very lucky to get this tips from you


Refrigerated transportation Canada

Ancy merina said...
This comment has been removed by the author.
Valentino thomas said...

When it has to do with selecting the correct conveyor belt, if unsure, it's ideal to consult a specialist on the area. To know more about chain conveyor, browse this site.

Unknown said...


Thanks for sharing.
Data Mining software service providers

data solution provider said...
This comment has been removed by the author.
data solution provider said...
This comment has been removed by the author.
data solution provider said...
This comment has been removed by the author.
data solution provider said...

Data mining ! ! is the process of analyzing hidden patterns of data according to different perspectives for categorization into useful information, which is collected and assembled in common areas, such as data warehouses, for efficient analysis, Data mining servicesalgorithms, facilitating business decision making and give youB2B LEADS! and quality data .skip tracing services are also same as data mining