A Structural Model of Data Warehousing Success

Data warehousing is an important area of practice and research, yet few studies have assessed its practices in general and critical success factors in particular. Although plenty of guidelines for implementation exist, few have been subjected to empirical testing. Furthermore, no model is available for comparing and evaluating the various claims made in different studies. In order to better understand the critical success factors and their effects on data warehousing success, a research model is developed in this paper. This model is useful for comparing findings across studies and for selecting variables for future research. The model is tested using data collected from a cross sectional survey of data warehousing professionals. Partial Least Square (PLS) is used to validate the structural relations identified in the model. The resulting model has three groups of success factors. Technical factor is found to positively influence information quality, whereas both operational and economic factors have a positive effect on system quality. Structural relations are also found among the dependent variables. System quality positively influences information quality, which in turn positively affects individual benefits. Individual benefits in turn has a positive relation with organizational benefits.

[1]  Dale Goodhue,et al.  Task-Technology Fit and Individual Performance , 1995, MIS Q..

[2]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[3]  David Sammon,et al.  The ten commandments of data warehousing , 2000, DATB.

[4]  Joe Nandhakumar,et al.  Design for success?: critical success factors in executive information systems development , 1996 .

[5]  Ken Orr.  Data Quality and System Theory. , 1998 .

[6]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[7]  Jaak Jurison,et al.  The temporal nature of IS benefits: A longitudinal study , 1996, Inf. Manag..

[8]  Ali F. Farhoomand,et al.  A structural model of end user computing satisfaction and user performance , 1996, Inf. Manag..

[9]  Lei-da Chen,et al.  Measuring user satisfaction with data warehouses: an exploratory study , 2000, Inf. Manag..

[10]  C. Fornell,et al.  Evaluating structural equation models with unobservable variables and measurement error. , 1981 .

[11]  Ephraim R. McLean,et al.  The DeLone and McLean Model of Information Systems Success: A Ten-Year Update , 2003, J. Manag. Inf. Syst..

[12]  Peter B. Seddon.  A Respecification and Extension of the DeLone and McLean Model of IS Success , 1997, Inf. Syst. Res..

[13]  J. Finn,et al.  Organization of Data , 1996 .

[14]  Barbara Wixom,et al.  An Empirical Investigation of the Factors Affecting Data Warehousing Success , 2001, MIS Q..

[15]  Christer Carlsson,et al.  Past, present, and future of decision support technology , 2002, Decis. Support Syst..

[16]  A. Desai,et al.  For pharmaceutical companies, a data warehouse can be just what the doctor ordered. , 1999, Health management technology.

[17]  Sunny Baker,et al.  THE BEST LITTLE WAREHOUSE IN BUSINESS , 1999 .

[18]  Lauren Keller Johnson.  Strategies for Data Warehousing , 2004 .

[19]  Jay F. Nunamaker,et al.  Special Issue: Information Systems Success , 2003, J. Manag. Inf. Syst..

[20]  Thompson S. H. Teo,et al.  An empirical study of the performance impact of computerization in the retail industry , 1998 .

[21]  Barbara Wixom,et al.  Antecedents of Information and System Quality: An Empirical Examination Within the Context of Data Warehousing , 2005, J. Manag. Inf. Syst..

[22]  Barbara Wixom,et al.  Current Practices in Data Warehousing , 2001, Inf. Syst. Manag..

[23]  Michael D. Myers,et al.  Executive information system failure: a New Zealand case study , 1997, PACIS.

[24]  Michael Sigal.  A common sense development strategy , 1998, CACM.

[25]  Z. Rubin,et al.  Slices of Lives. , 1978 .

[26]  Sean Kelly.  Data Warehousing in Action , 1997 .

[27]  K Bellenberg,et al.  Managerial considerations. , 1976, Quintessence of dental technology.

[28]  SammonDavid,et al.  The ten commandments of data warehousing , 2000 .

[29]  Hugh J. Watson,et al.  Critical Success Factors for Information Center Managers , 1988, MIS Q..

[30]  Thilini Ariyachandra,et al.  Data warehouse governance: best practices at Blue Cross and Blue Shield of North Carolina , 2004, Decis. Support Syst..

[31]  Wynne W. Chin.  Issues and Opinion on Structural Equation Modeling by , 2009 .

[32]  Narasimhaiah Gorla,et al.  Features to consider in a data warehousing system , 2003, CACM.

[33]  Ken Orr,et al.  Data quality and systems theory , 1998, CACM.

[34]  Debasish Mukherjee,et al.  Think Phased Implementation for Successful Data Warehousing , 2003, Inf. Syst. Manag..

[35]  Robert Winter,et al.  Organization of Data Warehousing in Large Service Companies - A Matrix Approach Based on Data Ownership and Competence Centers , 2001 .

[36]  Neil F. Doherty,et al.  An analysis of the anticipated cultural impacts of the implementation of data warehouses , 2003, IEEE Trans. Engineering Management.

[37]  Veda C. Storey,et al.  A Framework for Analysis of Data Quality Research , 1995, IEEE Trans. Knowl. Data Eng..

[38]  Barbara Wixom,et al.  Data Warehousing Supports Corporate Strategy At First American Corporation , 2000, MIS Q..

[39]  Mark I. Hwang,et al.  The effect of user engagement on system success: A meta-analytical integration of research findings , 1999, Inf. Manag..

[40]  Ephraim R. McLean,et al.  Information Systems Success: The Quest for the Independent Variables , 1992, J. Manag. Inf. Syst..

[41]  Diane M. Strong,et al.  Beyond Accuracy: What Data Quality Means to Data Consumers , 1996, J. Manag. Inf. Syst..

[42]  Bongsik Shin,et al.  An Exploratory Investigation of System Success Factors in Data Warehousing , 2003, J. Assoc. Inf. Syst..

[43]  Ann Blair,et al.  Too much information , 2007, Nature.

[44]  Nenad Jukic.  Modeling strategies and alternatives for data warehousing projects , 2006, CACM.