Factors Affecting the Implementation Success and Benefits of Data Warehousing Systems

데이터 웨어하우징 시스템의 구현성공과 효과에 영향을 미치는 요인

  • 김병곤 (남서울대학교 경영학과)
  • Published : 2009.03.31


The IT implementation literature suggests that various implementation factors play critical roles in the success of an information system; however, there is little empirical research about the implementation of data warehousing systems has unique characteristics that may impact the importance of factors that apply to it. In this study, a cross-sectional survey investigated a model of data warehousing success. Data warehousing managers and data suppliers from 51 organizations completed paired mail questionnaires on implementation factors and the success of the warehouse. The purpose of this study is to identify which factors have a positive impact on the successful implementation of DW among organizational implementation success, project implementation success, and technical implementation success which are selected as implementation factors of DW. To do so, this study comprehensively analyze the previous studies on the success factors of the information system and DW to develop the study model and set the hypothesized. Then, it verified the hypothesis via the empirical analysis after collecting the materials through the survey. Finally, the discussion of the study's results, offered the implications of the findings, and the conclusions of the findings followed.


  1. 김병곤, 박순창, "데이터 웨어하우징의 성공적 구현에 영향을 미치는 요인", 정보시스템연구, 제17권, 제4호(2008), pp.51-77 https://doi.org/10.5859/KAIS.2008.17.4.051
  2. 박세정, "성공적인 BI 시스템 구축을 위한 초석, 데이터 웨어하우징", 경영과컴퓨터 2008년 3월호, pp.134-137
  3. 박종모, 조경산, "데이터 웹 하우스의 성공적인 구축 전략", 한국경영정보학회, 2004추계학술대회, pp.766-772
  4. 이영숙, 이동만, 서창교, "최종사용자 집단특성을 조절변수로 도입하는 경우 데이터 웨어하우징 성공요인에 관한 연구", 경영정보학연구, 제11권, 제1호(2001)
  5. 정원진, 박용태, "Data Warehousing, Contextual Data Quality, Problem Solving Performance", 한국정보시스템학회 정보시스템연구, 제14권, 제2호(2005), pp.237-256
  6. 홍순구, 차윤숙, 홍석기, "웹 웨어하우스의 성공요인에 관한 실증 연구", 지식연구, 제4권, 제1호(2006), pp.70-98
  7. Adelman, S., and L. Moss, "Indicators of Succes", DM Direct, July 1999
  8. Ancona, D. G., and D. F. Caldwell, "Bridging the Boundary", Administrative Science Quarterly, Vol.37, No.4(1992), pp.634-666 https://doi.org/10.2307/2393475
  9. Banker, R. D., and R. J. Kauffman, "Reuse and Productivity in Integrated Computer-Aided Software", MIS Quarterly, Vol.15, No.3(1991), pp.375-402 https://doi.org/10.2307/249649
  10. Barquin, R. C., and H. Edelstein, "Planning and Designing the Data Warehouse", Prentice Hall, Upper Saddle River, NJ, 1997
  11. Beitler, S. S., and R. Leary, "Sears' EPIC Transformation:Converting from Mainframe Legacy Systems to On-Line Analytical Processing(OLAP)", Journal of Data Warehousing, Vol.2, No.2(1997), pp.5-16
  12. Bergeron, F., and L. Raymond, "Managing EDI for Competitive Advantage:A Longitudinal Study", Information and Management, No.31(1997), pp.319-333 https://doi.org/10.1016/S0378-7206(97)00007-4
  13. Bischoff, J., and T. Alexander, Data Warehouse: Practical Advice from the Experts, Prentice Hall, Upper Saddle River, NJ, 1997
  14. Brooks, F. P. The Mythical Man-month: Essays on Software Engineering, Addison Wesley, Reading, MA, 1975
  15. Chen Lei-da, and K. S. Soliman, "Exploring Information Center's Roles in the Use of Data Warehouses", Proceedings of the Fourth Americas Conference on Information Systems Maryland, August Vol.14-16, 1998, pp.3-5
  16. Chen, L., Soliman, K., Mao, E., and M. Frolic, "Measuring User Satisfaction with Data Warehouse:An Exploratory Study", Information and Management, Vol.37, No.3(2000), pp.103-110 https://doi.org/10.1016/S0378-7206(99)00042-7
  17. Constantine, L. L. "Work Organizations: Paradigms for Project Management and Organization", Communications of the ACM, Vol.36, No.10(1993), pp.35-42 https://doi.org/10.1145/163430.163435
  18. Curtis, M. B., and Joshi, K. "Lessons Learned from the Implementation of a Data Warehouse", Journal of Data Warehousing, Vol.3, No.2(1998), pp.12-18
  19. Davis, F. "Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Information Technology", MIS Quarterly, Vol.13, No.3(1989), pp.319-339 https://doi.org/10.2307/249008
  20. DeLone, W. H., and E. R. McLean, "Information Systems Success:The Quest for the Dependent Variable", Information Systems Research, Vol.3, No.1(1992), pp.60-95 https://doi.org/10.1287/isre.3.1.60
  21. Ein-Dor, P., and Segev, E. "Organizational Context and the Success of Management Information Systems", Management Science, Vol.24, No.10(1978), pp.1064-1077 https://doi.org/10.1287/mnsc.24.10.1064
  22. Finlay, P. N., and A. C. Mitchell, "Perceptions of the Benefits from the Introduction of CAS E:An Empirical Study", MIS Quarterly, Vol.18, No.4(1994), pp.353-371 https://doi.org/10.2307/249520
  23. Fraser, S. G., and G. Salter, "A Motivational View of Information Systems Success:A Reinterpretation of DeLone and McLean's Model", working paper, Department of Accounting and Finance, The University of Melbourne, Australia, 1995
  24. Garrity, E. J., and G. L. Sanders, Information Success Measurement, Idea Group Publishing, Hershey, PA, 1998
  25. Goodhue, D. L., Quillard, J. A., and J. F. Rockart, "Managing the Data Resource:A Contingency Perspective", MIS Quarterly, Vol.12, No.3(1988), pp.373-392 https://doi.org/10.2307/249204
  26. Goodhue, D. L., Wybo, M. D., and L. J. Kirsch, "The Impact of Data Integration on the Costs and Benefits of Information Systems", MIS Quarterly, Vol.16, No.3(1992), pp.293-311 https://doi.org/10.2307/249530
  27. Gray, P., and H. J. Watson, "Decision Support in the Data Warehouse", Prentice Hall, Upper Saddle River, 1998
  28. Grim, R., and P. Thorton, "A Customer for Life: The Warehouse MCI Approach", Journal of Data Warehousing, Vol.2, No.1(1997), pp.73-79
  29. Guimares, T, Igbaria, M., and M. Lu, "The Determinants of DSS Success:An Integrated Model", Decision Sciences, No.23(1992), pp.409-430 https://doi.org/10.1111/j.1540-5915.1992.tb00397
  30. Haley, B. J., Implementing the Decision Support Infrastructure:Key Success Factors in Data Warehousing, Unpublished Ph. D. Dissertation, The University of Georgia, 1997
  31. Harker, S., "User Participation in Prototyping", Communications of the ACM, Vol.36, No.6(1993), p.77. https://doi.org/10.1145/153571.214822
  32. Hartwick, J., and H. Barki, "Explaining the Role of User Participation in Information System Use", Management Science, Vol.40, No.4(1994), pp.440-465 https://doi.org/10.1287/mnsc.40.4.440
  33. Igbaria, M., Zinatelli, N., Cragg, P., and Cavaye, A. L. "Personal Computing Acceptance Factors in Small Firms:A Structural Equation Model", MIS Quarterly, Vol.21, No.3(1997), pp.279-302 https://doi.org/10.2307/249498
  34. Karahanna, E., Straub, D. W., and N. L. Chervany, “"nformation Technology Adoption Across Time:Cross-Sectional Comparison of Pre-Adoption and Post-Adoption Beliers", MIS Quarterly, Vol.23, No.2(1999), pp.183-213 https://doi.org/10.2307/249751
  35. Kelly, S. Data Warehousing in Action, John Wiley and Sons, Chichester, 1997
  36. Kerlinger, F. N., Foundation of Behavior Research, Holt, Rinehart and Wsydon, 1986
  37. Kraemer, K. L., Danzinger, J. N., Dunkle, D. E., and J. L. King, "The Usefulness of Computer-Based Information to Public Managers", MIS Quarterly, Vol.17, No.2(1993), pp.129-148 https://doi.org/10.2307/249798
  38. Little, R. G. Jr., Identification of Factors Affecting the Implementation of Data Warehousing, Unpublished Ph. D. Dissertation, The Auburn University, 1998
  39. Little, R. G., and M. L. Gibson, "Identification of Factors Affecting the Implementation of Data Warehousing", Proceedings of the Thirty Second Annual Hawaii International Conference on System Sciences, Maui, Hawaii, 1999 https://doi.org/10.1109/HICSS.1999.10019
  40. Markus, M. L. "Power, Politics and MIS Implementation", Communications of the ACM, Vol.26, No.6(1983), pp.430-444 https://doi.org/10.1145/358141.358148
  41. McConnell, S.(1996), Rapid Development, Microsoft Press, Redmond, WA
  42. Mcgee, K. R., The Bottlenecks of Implementing a Successful Data Warehouse, Unpublished Degree of Master Dissertation, The University of Texas at Arlington, 1997
  43. Melone, N. "A Theoretical Assessment of the User-Satisfaction Construct in Information Systems Research", Management Science, Vol.36, No.1(1990), pp.76-91 https://doi.org/10.1287/mnsc.36.1.76
  44. Moore, G., and I. Benbasat, "Development of an Instrument to Measure the Perceptions of Adopting and Information Technology Innovation", Information Systems Research, Vol.2, No.3(1991), pp.192-222 https://doi.org/10.1287/isre.2.3.192
  45. Park Y. T., "Justification of Data Warehousing for DSS:A Competitive Advantage Point of View", Proceedings of the Fourth Americas Conference on Information Systems, Baltimore, Maryland, August Vol.14-16, 1998, pp.39-41
  46. Park, Y. T., The Effect of Data Warehousing as a DSS Database Component on Decision Performance:An Experimental Study of DW in DSS Contexts, Unpublished Ph. D. Dissertation, Claremont Graduate University, 1999
  47. Pitt. L., Watson, R. T. and Kavan, C. B. "Service Quality:A Measure of Information Systems Effectiveness", MIS Quarterly, Vol.19, No.2(1995), pp.173-185 https://doi.org/10.2307/249687
  48. Poe, V., Klauer, P., and S. Brobst, Building a Data Warehouse for Decision Support, Prentice Hall, 1998
  49. Rist, R. "Challenges Faced by the Data Warehousing Pioneers", Journal of Data Warehousing, Vol.2, No.1(1997), pp.63-72
  50. Rudra, A., and E. Yeo, "Key Issues in Achieving Data Quality and Consistency in Data Warehousing among Large Organizations in Australia", Proceedings of the Thirty-Second Annual Hawaii International Conference on System Sciences, Maui, Hawaii, January Vol.5-9, 1999
  51. Schardt, J. A., "The Enterprise Intersection Model:A Unifying Framework for Data Warehouse Development", Journal of Data Warehousing, Vol.2, No.2(1997), pp.51-61
  52. Seddon, P., "A Respecification and Extension of the DeLone and McLean Model of IS Success", Information Systems Research, Vol.8, No.3(1997), pp.240-253 https://doi.org/10.1287/isre.8.3.240
  53. Seddon, P. B., and M-Y. Kiew, "A Partial Test and Development of the DeLone and McLean Model of IS Success", in Proceedings of the International Conference on Information Systems, J. I. DeGross, S. L. Huff, and M. C. Munro(eds.), Vancouver, Canada, 1994, pp.99-110
  54. Shin, B., "An Exploratory Investigation of System Success Factors in Data Warehousing", Journal of the Association for Information Systems, Vol.4, No.6(2003), pp.141-170 https://doi.org/10.17705/1jais.00033
  55. Tait, P., and I. Vessey, "The Effect of User Involvement on System Success:A Contingency Approach", MIS Quarterly, Vol.12, No.1(1988), pp.91-108 https://doi.org/10.2307/248809
  56. Vatanasombut, B., and P. Gray, "Factors for Success in Data Warehousing:What the Literature Tells Us", Journal of Data Warehousing, Vol.4, No.3(1999), pp.25-33
  57. Watson, H. J., Gerard, J. G. Gonzalez, L. E., Haywood, M. E., and D. Fenton, "Data Warehousing Failures:Case Studies and Findings", Journal of Data Warehousing, Vol.4, No.1(1999), pp.44-55
  58. Watson, H. J., Haines, M., and E. T. Loiacono, "The Approval of Data Warehousing Projects: Findings from Ten Case Studies", Journal of Data Warehousing, Vol.3, No.3(1998), pp.29-37
  59. Watson, H. J., and B. J. Haley, "Data Warehousing : A Framework and Survey of Current Practices", Journal of Data Warehousing, Vol.2, No.1(1997), pp.10-17
  60. Weilbach, J. F., and H. L. Viktor, "A Data Warehouse for Policy Making:A Case Study", Proceedings of the Thirty-Second Annual Hawaii International Conference on System Sciences, Maui, Hawaii, January Vol.5-9, 1999
  61. Wixom, B. H., and H. J. Watson, "An Empirical Investigation of the Factors Affecting Data Warehousing Success", MIS Quarterly, Vol.25, No.1(2001), pp.17-41 https://doi.org/10.2307/3250957