Best Practices for Data Warehousing{2}


In the peer review article “Best Practices in Data Warehousing to Support Business Initiatives and Needs,” authored by Jeff Lawyer and Shamsul Chowdury, the two authors discuss the importance and decisions certain businesses would have to implement in order to run their business efficiently. The authors illustrate how many companies in the 1990s were having a difficult time adjusting to the success of the many computer applications as well as the blooming of internet use. What was most difficult, according to Chowdury and Lawyer, was choosing which architecture to implement. The two general types of architectures were the Bill Inmon Style and the Ralph Kimball Style. The Inmon Stlye is one that is considered to be application neutral and could be named an enterprise data warehouse. The Kimball Style, however, has data prearranged. The authors also mention that with the “stove-pipes” of data, the cross use of data between businesses was unknown. “Under the Kimball approach, data are arranged in an application- or data-view-specific manner [8]. Under the Inmon approach, data are arranged according to the rules of normalization and remain application-
and data-view-independent [13].”
As for data warehousing growth, most data warehousing initiatives have concluded that there is a continuous need for incremental updates to the data warehouse. The authors suggest to treat the warehouse as an ongoing application. “Keeping your data warehouse team intact after the initial build is very important in order to sustain the capability to react to this need. To paraphrase a popular saying, ‘Data warehousing is not a destination – it is a journey’”. The authors were studying the data warehouse journey of one U.S. retailing company in 1995. The company used their warehouse to store only 80 gigabytes of information. The
80 gigabyte Inmon-style data warehouse was used to select customers for a targeted creditstimulation marketing program. The database has grown to hold nearly 7 terabytes with two hundred tables and two-thousand seven hundred columns.

I found this article to be really interesting. Mostly because the authors were discussing the accomplishments of one U.S. retailing company in the 1990’s which was the dawn of available computer technology for a lot of people and the growth of e-businesses around the world. It just exposes one company’s decision in choosing the right warehousing architecture when many other companies had to have done the same thing and may not have been as successful.

Lawyer, J.; Chowdhury, S.; , “Best practices in data warehousing to support business initiatives and needs,” System Sciences, 2004. Proceedings of the 37th Annual Hawaii International Conference on , vol., no., pp. 9 pp., 5-8 Jan. 2004
doi: 10.1109/HICSS.2004.1265515
URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=1265515&isnumber=28293