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.

4 comments:

Arbeej12 said...

Hello,
We facilitate the provision of independent analysis to support expert testimony, regulatory or legislative engagements. Frequently, this work includes economic, financial and statistical studies of varying data analysis, technical and http://www.palmerleasing.com.

benslin kard said...

Data warehousing creates one database, the number of sources can be nearly limitless, provided the system can handle the volume.

Negi said...

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


Refrigerated transportation Canada

sathya said...

Now it is known to me that articles is nothing but inspiring is everything to do something great. This is a great article for the people who want to come in freelancing.


Data warehousing Training in Chennai