Discuss Inmon’s and Kimball’s Models for Data warehouse development in detail. Also, highlight their differences.

Inmon’s approach is the top-down one. The whole database works in a centralized manner, and no information is developed separately by a single entity. According to Inuwa:

“Inmon’s idea of the data warehouse is to construct an atomic data warehouse which will later help in the creation of any number of departmental data marts.”

Kimball’s approach is the bottom-up one. Any department of a company designs its own database freely, and those data storage can be integrated at any time, in any manner. The structure of the data warehouse is flexible and decentralized.

The main difference between those systems is in the rigidity of the structure. As Aziz noted in his studies:

“Contrary to Inmon, Kimball views data warehouse as a collection of departmental individual data marts.”

Those methods are also particularly different in terms of building and management. Inmon’s system, due to its solid structure, is harder to build, but it is easier to maintain. Kimball’s system is easier to produce because of the local approach to data storage, yet it is harder to analyze and filter for redundant information.

Answer by Academic.tip's expert
An answer to this question is provided by one of our experts who specializes in technology & it. Let us know how much you liked it and give it a rating.

Cite this page

Select a citation style:

References

Academic.Tips. (2022) 'Discuss Inmon's and Kimball's Models for Data warehouse development in detail. Also, highlight their differences'. 21 January.

Reference

Academic.Tips. (2022, January 21). Discuss Inmon's and Kimball's Models for Data warehouse development in detail. Also, highlight their differences. https://academic.tips/question/discuss-inmons-and-kimballs-models-for-data-warehouse-development-in-detail-also-highlight-their-differences/

References

Academic.Tips. 2022. "Discuss Inmon's and Kimball's Models for Data warehouse development in detail. Also, highlight their differences." January 21, 2022. https://academic.tips/question/discuss-inmons-and-kimballs-models-for-data-warehouse-development-in-detail-also-highlight-their-differences/.

1. Academic.Tips. "Discuss Inmon's and Kimball's Models for Data warehouse development in detail. Also, highlight their differences." January 21, 2022. https://academic.tips/question/discuss-inmons-and-kimballs-models-for-data-warehouse-development-in-detail-also-highlight-their-differences/.


Bibliography


Academic.Tips. "Discuss Inmon's and Kimball's Models for Data warehouse development in detail. Also, highlight their differences." January 21, 2022. https://academic.tips/question/discuss-inmons-and-kimballs-models-for-data-warehouse-development-in-detail-also-highlight-their-differences/.

Work Cited

"Discuss Inmon's and Kimball's Models for Data warehouse development in detail. Also, highlight their differences." Academic.Tips, 21 Jan. 2022, academic.tips/question/discuss-inmons-and-kimballs-models-for-data-warehouse-development-in-detail-also-highlight-their-differences/.

Copy