A Comparative Study of Data Warehouse Architectures: Top Down Vs Bottom Up

Author(s):

Joseph George , Noorul Islam Centre for Higher Education Kumaracoil, Tamilnadu, India; Dr. M. K Jeyakumar, Noorul Islam Centre for Higher Education Kumaracoil, Tamilnadu, India

Keywords:

Data Warehouse, Inmon Vs Kimball, Data Warehouse Architecture, Business Intelligence, Data Marts

Abstract:

Analysis Paralysis or Information Crisis is one of the strategic challenges of most of the organizations today. Organizations’ greatest wealth is their data and the success depends on how they harness their data wealth, in an effective manner. Here comes the importance of Business Intelligence (BI). The core of any BI project is the Data Warehouse (DW). There exist two prominent doctrines on the approach towards a DW development. They are Ralph Kimball’s Bottom Up or Dimensional Modelling approach and Bill Inmon’s Top Down approach. Of course there are other approaches as well, but they all follow these giants or combine their styles with few modifications. For example, in the Data Vault approach, Daniel Linstedt works very close with Inmon. Inmon Vs Kimball is one of the hottest topics ever in Data Warehouse domain since its inception. Debates on which one is better or effective over the other never comes to an end. Both have their own pros and cons. This paper is not yet another conventional comparison. Here the authors try to analyze the usability and prominence of both approaches, based on scenarios where they are implemented, project management perspective and the development lifecycle.

Other Details:

Manuscript Id	:	IJSTEV5I9024
Published in	:	Volume : 5, Issue : 9
Publication Date	:	01/04/2019
Page(s)	:	43-46

Download Article