Data Warehousing Best Practices {1}

by Rudy P
The Journal I decided to blog about this week is Titled, “Best Practices in Data Warehousing to Support Business Initiatives and Needs” by Jeff Lawyer and Shamsul Chowdhury. This journal follows a “diverse U. S. retailing company was experiencing the usual growing pains of the middle 1990’s” (Lawyer 2004). The company with faced with many technological and database problems including accessing data from their legacy systems, and the data contained little or no history. The company then decided in 1995 “that data warehousing could be used to release their data from its ‘data jailhouse'”(lawyer 2004). The journal speaks of two data warehousing styles, the “Bill Inmon Style” and the “Ralph Kimball Style”. The styles have many similarities  however where they differ is how the data is arranged in the data warehouse itself. The Inmon style used an “atomic-level, third-normal form (3NF) relational format in which to store extracted and transformed data”(Lawyer 2004), while the Kimball style uses a “multidimensional style ‘dimension and fact’ arrangement in which to store extracted and transformed data”(Lawyer 2004). In the case of the US retailing company, they chose to go the route of the Inmon style for various reasons. read more...