Design of the data warehouse: Kimball Vs Inmon
This tutorial covers the basic design concepts, The top down approach, The Bottom-Up Approach , Hybrid Approach and Federated approach.Ralph Kimball and Inmon, the co-founders of the data warehouse, significantly had their own differences in the design and architecture of the data warehouse. Inmon advocated a “dependent data mart structure” whereas Kimball advocated the “data warehouse bus structure”. The Dependent Data Mart structure:The top down approachBill Inmon saw a need to transfer data from diverse OLTP systems into a centralized place where the data could be used for analysis. He…
Read More