21-04-2012, 12:34 PM
DATA WAREHOUSING
data_warehousing_basic_concepts.ppt (Size: 198.5 KB / Downloads: 36)
Evolution of DWH
Not optimized for analysis and reporting
Company wide reporting couldn’t be supported from a single system
For developing reports often required writing specific computer programs which was slow and expensive
Why should we consider Data Warehousing solutions ?
When users are requesting access to a large amount of historical information for reporting purposes, you should strongly consider a warehouse or mart. The user will benefit when the information is organized in an efficient manner for this type of access.
Characteristics of DWH
Subject Oriented
Non Volatile
Integrated
Time Variant
Dimensional Data Modeling
To develop a Star Schema design a Data Modeler follows dimensional modeling design aspect.
Dimensional modeling is a 3 stage process
Conceptual modeling
Logical Modeling
Physical Modeling