Data Warehousing: Inmon Style and Kimball Style{2}


The article I chose for this week is titled “Best Practices in Data Warehousing to Support Business Initiatives and Needs”. The article talks about two different styles used in data warehousing and lists when you would use one versus the other. The first style is the “Bill Inmon Style” which uses a top-down approach. In contrast, the “Ralph Kimball Style” uses a bottom-up approach. The article uses a major U.S. retail company as an example. This company uses the Inmon style simply because it is what fits well for that particular business. This style of data warehousing demands that you have a third-normal form relational format for your data. The Kimball style, on the other hand, requires that you use a multidimensional style arrangement. In the case of this retail company, the application neutral aspect of the Inmon style made it an easy pick.

I picked this article mainly because it delved deeper into data warehousing styles. The comparisons of the Inmon and Kimball style in a real world situation made it seem like a really important topic. The company chose to use the Inmon style because it is what worked best for it. That doesn’t mean it’s perfect for everyone, but it does help give an idea why you would choose one over the other.

I enjoyed reading about this topic because it helped me understand a few older concepts that we talked about in class. Third normal form, for instance, was something that was very important to this retail store. Having data in 3NF helped the business get the summarized reports they were looking for. I liked being able to see all these concepts in use by an actual business.

 

Lawyer, J.; Chowdhury, S. (2004). Best practices in data warehousing to support business initiatives and needs. Proceedings of the 37th Annual Hawaii International Conference on System Sciences, 2004.
URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=1265515