DOI QR코드

DOI QR Code

Factors Affecting the Implementation Success of Data Warehousing Systems

데이터 웨어하우징의 성공적 구현에 영향을 미치는 요인

  • Published : 2008.12.30

Abstract

Empirical studies on the implementation of data warehousing systems(DWS) are few while there exist a number of researches on the implementation of IS. This article intends to examine the factors affecting the implementation success. of DWS. It adopts the empirical analysis of a sample of 112 responses from DWS practitioners. The study results suggest several implications for researchers and practitioners. When the support from top management becomes great, the implementation success of DWS in organizational aspects is more likely. The support of resources increases the implementation success of DWS in project aspects, while it is not significantly related to the implementation success of DWS in organizational aspects. The user involvement in systems implementation, however, affects the implementation success of DWS in organizational and project aspects. Prototyping for the DWS implementation positively affects the implementation success of DWS. This indicates that the extent of understanding the requirements and the communication among project members increases also the implementation success of DWS. The extent of consulting activities in DWS projects increases the implementation success of DWS in project aspects. The continuous support of consulting activities and technology transfers enhances the adherence to the project schedule, preventing the exceeding of the project budget and ensuring the implementation of the intended system functions.

References

  1. 박세정, "성공적인 BI 시스템 구축을 위한 초석, 데이터웨어하우징," 경영과컴퓨터 2008 년 3월호, pp. 134-137.
  2. 박종모, 조경산, "데이터웹하우스의 성공적인 구축 전략," 한국경영정보학회 2004추계학술대회, pp. 766-772.
  3. 이영숙, 이동만, 서창교, "최종사용자 집단특성을 조절변수로 도입하는 경우 데이터 웨어하우징 성공요인에 관한 연구," 경영정보학연구, 제11권, 제1호, 2001, pp. 175-203.
  4. 정원진, 박용태, "Data Warehousing, Contextual Data Quality, Problem Solving Performance," 정보시스템연구, 제14권, 제2호, 2005, pp. 237-256.
  5. 홍순구, 차윤숙, 홍석기, "웹웨어하우스의 성공 요인에 관한 실증 연구," 지식연구, 제4권, 제1호, 2006, pp. 70-98.
  6. Adelman, S. and Moss, L., "Indicators of Succes," DM Direct, July 1999.
  7. Ancona, D. G. and Caldwell, D. F., "Bridging the Boundary," Administrative Science Quarterly, Vol. 37, No. 4, 1992, pp. 634-666. https://doi.org/10.2307/2393475
  8. Banker, R. D. and Kauffman, R. J., "Reuse and Productivity in Integrated Computer-Aided Software," MIS Quarterly, Vol. 15, No. 3, 1991, pp. 375-402. https://doi.org/10.2307/249649
  9. Barquin, R. C. and Edelstein, H., "Planning and Designing the Data Warehouse, Prentice Hall, Upper Saddle River, NJ, 1997.
  10. Beitler, S. S. and Leary, R., "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.
  11. Bergeron, F. and Raymond, L., "Managing EDI for Competitive Advantage: A Longitudinal Study," Information & Management, Vol. 31, 1997, pp. 319-333. https://doi.org/10.1016/S0378-7206(97)00007-4
  12. Bischoff, J. and Alexander, T., Data Warehouse: Practical Advice from the Experts, Prentice Hall, Upper Saddle River, NJ, 1997.
  13. Brooks, F. P., The Mythical Man-month: Essays on Software Engineering, Addison Wesley, Reading, MA, 1975.
  14. Chen Lei-da and Soliman, K. S., "Exploring Information Center's Roles in the Use of Data Warehouses," Proceedings of the Fourth Americas Conference on Information Systems, Maryland, August 14-16, 1998, pp. 3-5.
  15. Chen, L., Soliman, K., Mao, E., and Frolic, M., "Measuring User Satisfaction with Data Warehouse: An Exploratory Study", Information & Management, Vol. 37, No. 3, 2000, pp. 103-110. https://doi.org/10.1016/S0378-7206(99)00042-7
  16. Constantine, L. L., "Work Organizations: Paradigms for Project Management and Organization," Communications of the ACM, Vol. 36, No. 10, 1993, pp. 35-42.
  17. 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.
  18. Davis, F., "Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Technology," MIS Quarterly, Vol. 13, No. 3, 1989, pp. 319-339. https://doi.org/10.2307/249008
  19. DeLone, W. H. and McLean, E. R., "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
  20. 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
  21. Finlay, P. N. and Mitchell, A. C., "Perceptions of the Benefits from the Introduction of CASE: An Empirical Study," MIS Quarterly, Vol. 18, No. 4, 1994, pp. 353-371. https://doi.org/10.2307/249520
  22. Fraser, S. G. and Salter, G., "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.
  23. Garrity, E. J. and Sanders, G. L., Information Success Measurement, Idea Group Publishing, Hershey, PA, 1998.
  24. Goodhue, D. L., Quillard, J. A., and Rockart, J. F., "Managing the Data Resource: A Contingency Perspective," MIS Quarterly, Vol. 12, No. 3, 1988, pp. 373-392. https://doi.org/10.2307/249204
  25. Goodhue, D. L., Wybo, M. D., and Kirsch, L. J., "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
  26. Gray, P. and Watson, H. J., Decision Support in the Data Warehouse, Prentice Hall, Upper Saddle River, 1998.
  27. Grim, R. and Thorton, P., "A Customer for Life: The Warehouse MCI Approach," Journal of Data Warehousing, Vol. 2, No. 1, 1997, pp. 73-79.
  28. Guimares, T, Igbaria, M., and Lu, M., "The Determinants of DSS Success: An Integrated Model," Decision Sciences, Vol. 23, 1992, pp. 409-430. https://doi.org/10.1111/j.1540-5915.1992.tb00397.x
  29. Haley, B. J., Implementing the Decision Support Infrastructure : Key Success Factors in Data Warehousing, Unpublished Ph. D. Dissertation, The University of Georgia, 1997.
  30. Harker, S., "User Participation in Prototyping, "Communications of the ACM, Vol. 36, No. 6, 1993, p. 77. https://doi.org/10.1145/153571.214822
  31. Hartwick, J. and Barki, H., "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
  32. 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
  33. Karahanna, E., Straub, D. W., and Chervany, N. L., "Information 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
  34. Kelly, S., Data Warehousing in Action, John Wiley & Sons, Chichester, 1997.
  35. Kerlinger, F. N., Foundation of Behavior Research, Holt, Rinehart and Wsydon, 1986.
  36. Kraemer, K. L., Danzinger, J. N., Dunkle, D. E., and King, J. L., 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
  37. Little, R. G. Jr., Identification of Factors Affecting the Implementation of Data Warehousing, Unpublished Ph. D. Dissertation, The Auburn University, 1998.
  38. Little, R. G. and Gibson, M. L., "Identification of Factors Affecting the Implementation of Data Warehousing," Proceedings of the Thirty-Second Annual Hawaii International Conference on System Sciences, Maui, Hawaii, January 5-9, 1999.
  39. 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
  40. McConnell, S., Rapid Development, Microsoft Press, Redmond, WA, 1996.
  41. Mcgee, K. R., The Bottlenecks of Implementing a Successful Data Warehouse, Unpublished Degree of Master Dissertation, The University of Texas at Arlington, 1997.
  42. 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
  43. Moore, G. and Benbasat, I., "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
  44. 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 14-16, 1998, pp. 39-41.
  45. 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.
  46. 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
  47. Poe, V., Klauer, P., and Brobst, S., Building a Data Warehouse for Decision Support, Prentice Hall, 1998.
  48. Rist, R., "Challenges Faced by the Data Warehousing Pioneers," Journal of Data Warehousing, Vol. 2, No. 1, 1997, pp. 63-72.
  49. Rudra, A. and Yeo, E., "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 5-9, 1999.
  50. 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.
  51. 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
  52. Seddon, P. B. and Kiew, M-Y., "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.
  53. 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.
  54. Tait, P. and Vessey, I., "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
  55. Vatanasombut, B. and Gray, P., "Factors for Success in Data Warehousing: What the Literature Tells Us," Journal of Data Warehousing, Vol. 4, No. 3, 1999, pp. 25-33.
  56. Watson, H. J., Gerard, J. G. Gonzalez, L. E., Haywood, M. E., and Fenton, D., "Data Warehousing Failures: Case Studies and Findings," Journal of Data Warehousing, Vol. 4, No. 1, 1999, pp. 44-55.
  57. Watson, H. J., Haines, M., and Loiacono, E. T., "The Approval of Data Warehousing Projects: Findings from Ten Case Studies," Journal of Data Warehousing, Vol. 3, No. 3, 1998, pp. 29-37.
  58. Watson, H. J. and Haley, B. J., "Data Warehousing: A Framework and Survey of Current Practices," Journal of Data Warehousing, Vol. 2, No. 1, 1997, pp. 10-17.
  59. Weilbach, J. F. and Viktor, H. L., "A Data Warehouse for Policy Making : A Case Study," Proceedings of the Thirty-Second Annual Hawaii International Conference on System Sciences, Maui, Hawaii, January 5-9, 1999.
  60. Wixom, B. H. and Watson, H. J., "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

Cited by

  1. Automated Conceptual Data Modeling Using Association Rule Mining vol.18, pp.4, 2009, https://doi.org/10.5859/KAIS.2009.18.4.059