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.
Nov 20, 2009
Data Warehouse Design
Posted by
Sarfaraz M Manik
Labels:
Data Warehouse,
Data Warehousing,
OLAP,
OLTP
Subscribe to:
Post Comments (Atom)
8 comments:
Thanks for great information you write it very clean. I am very lucky to get this tips from you
Refrigerated transportation Canada
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.
Thanks for sharing.
Data Mining software service providers
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
Post a Comment