Nothing Special   »   [go: up one dir, main page]

skip to main content
article

An empirical investigation of the key determinants of data warehouse adoption

Published: 01 March 2008 Publication History

Abstract

Data warehousing (DW) has emerged as one of the most powerful decision support technologies during the last decade. However, despite the fact that it has been around for some time, DW has experienced limited spread/use and relatively high failure rates. Treating DW as a major IT infrastructural innovation, we propose a comprehensive research model - grounded in IT adoption and organizational theories - that examines the impact of various organizational and technological (innovation) factors on DW adoption. Seven factors - five organizational and two technological - are tested in the model. The study employed rigorous measurement scales of the research variables to develop a survey instrument and targeted 2500 organizations in both manufacturing and services segments within two major states in the United States. A total of 196 firms (276 executives), of which nearly 55% were adopters, responded to the survey. The results from a logistic regression model, initially conceptualizing a direct effect of each of the seven variables on adoption, indicate that five of the seven variables (three organizational factors - commitment, size, and absorptive capacity - and two innovation characteristics - relative advantage and low complexity) are key determinants of DW adoption. Although scope for DW and preexisting data environment within the organization were favorable for adopter firms, they did not emerge as key determinants. However, the study provided an opportunity to explore a more complex set of relationships. This alternative structural model (using LISREL) provides a much richer explanation of the relationships among the antecedent variables and with adoption, the dependent variable. The study, especially the revised conceptualization, contributes to existing research by proposing and empirically testing a fairly comprehensive model of organizational adoption of an information technology (IT) innovation, more specifically a DSS technology. The findings of the study have interesting implications with respect to IT/DW adoption, both for researchers and practitioners.

References

[1]
Adams, D.A., Ryan, N.R. and Todd, P.A., Perceived usefulness, ease of use, and usage of information. MIS Quarterly. v16 i2. 227-247.
[2]
Agarwal, R. and Prasad, J., The role of innovation characteristics and perceived voluntariness in the acceptance of information technologies. Decision Sciences. v28 i3. 557-582.
[3]
Alavi, M. and Leidner, D.E., Knowledge management and knowledge management systems: conceptual foundations and research issues. MIS Quarterly. v25 i1. 107-136.
[4]
Ang, J. and Teo, T.S.H., Management issues in data warehousing: insights from the housing and development board. Decision Support Systems. v29 i1. 11-20.
[5]
Applegate, L.M., Austin, R.D. and McFarlan, W.F., Corporate Information Strategy and Management. 2003. McGraw-Hill.
[6]
Attewell, P., Technology diffusion and organizational learning: the case of business computing. Organization Science. v3 i1. 1-19.
[7]
Bajaj, A., The adoption of computing architectures. Journal of the Association for Information Systems. v1 i2. 1-57.
[8]
Bentler, P.M., Comparative fit indexes in structural equation models. Psychological Bulletin. v107 i2. 238-246.
[9]
Bentler, P.M. and Bonnet, D.G., Significance tests and goodness of fit in the analysis of covariance structures. Psychological Bulletin. v88. 588-606.
[10]
Berndt, D.J., Hevner, A.R. and Studnicki, J., The Catch data warehouse: support for community health care decision-making. Decision Support Systems. v35 i3. 367-384.
[11]
Bhattacherjee, A., Understanding information systems continuance: an expectation-confirmation model. MIS Quarterly. v25 i3. 351-370.
[12]
Bourgeois, L.J., On the measurement of organizational slack. Academy of Management Review. v6 i1. 29-39.
[13]
Boynton, A.C., Zmud, R.W. and Jacobs, G.C., The influence of it management practice on it use in large organizations. MIS Quarterly. v18 i3. 299-318.
[14]
Brancheau, J.C. and Wetherbe, J.C., The adoption of spreadsheet software: testing innovation diffusion theory in the context of end-user computing. Information Systems Research. v1 i2. 115-143.
[15]
Buvik, A. and John, G., When does vertical coordination improve industrial purchasing relationships?. Journal of Marketing. v64. 52-64.
[16]
Chau, P.Y. and Tam, K.Y., Factors affecting the adoption of open systems: an exploratory study. MIS Quarterly. v21 i1. 1-24.
[17]
Churchill Jr., G.A., A paradigm for developing better measures of marketing constructs. Journal of Marketing Research. v16. 64-73.
[18]
Clemons, E., Evaluations of strategic investments in information technology. Communications of the ACM. v34 i1. 22-34.
[19]
Cohen, J., Statistical Power Analysis for the Behavioral Science. 1988. Academic Press, New York.
[20]
Cohen, W.M. and Levinthal, D.A., Absorptive capacity: a new perspective on learning an innovation. Administrative Science Quarterly. v35 i1. 128-152.
[21]
Cooper, R.B. and Zmud, R.W., Information technology implementation research: a technological diffusion approach. Management Science. v36 i2. 123-139.
[22]
Cooper, B.L., Watson, H.J., Wixom, B.H. and Goodhue, D.L., Data warehousing supports corporate strategy at First American Corporation. MIS Quarterly. v24 i4. 547-567.
[23]
Daft, R.L., A dual-core model of organizational innovation. Academy of Management Journal. v21 i2. 193-210.
[24]
Damanpour, F., Organizational complexity and innovation: developing and testing multiple contingency models. Management Science. v42 i5. 693-716.
[25]
Damanpour, F., Organizational innovation: a meta-analysis of effects of determinants and moderators. Academy of Management Journal. v34 i3. 555-590.
[26]
Davis, F., Perceived usefulness, perceived ease of use and user acceptance of technology. MIS Quarterly. v13 i3. 319-339.
[27]
http://www.noumenal.com/marc/dwpol.html
[28]
Dewar, R. and Dutton, J., The adoption of radical and incremental innovation: an empirical analysis. Management Science. v32 i11. 1422-1433.
[29]
Dillman, D.A., Mail and Telephone Surveys: The Total design Method. 1978. Wiley, New York.
[30]
Duncan, N.B., Capturing the flexibility of information technology infrastructure: a study of resource characteristics and their measure. Journal of Management Information Systems. v12 i2. 37-57.
[31]
J.E. Ettlie, Implementing manufacturing technologies: lessons from experience, in: D.D. Davis and Associates, (Eds.), Managing Technological Innovation, Jossey-Bass, San Francisco, 1986, pp. 72-104.
[32]
Fichman, R.G., Information technology diffusion: a review of empirical research. In: Proceedings of the 13th International Conference on Information Systems, pp. 195-206.
[33]
Finlay, P.N. and Mitchell, A.C., Perceptions of the benefits from CASE: an empirical study. MIS Quarterly. v18 i4. 353-371.
[34]
Gerbing, D.W. and Anderson, J.C., An updated paradigm for scale development incorporating unidimensionality and its assessment. Journal of Marketing Research. v25 i2. 186-192.
[35]
Goodhue, D.L., Quillard, J.A. and Rockart, J.F., Managing the data resource: a contingency perspective. MIS Quarterly. v12 i3. 373-391.
[36]
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. v16 i3. 293-311.
[37]
Gopalakrishnan, S. and Damanpour, F., The impact of organizational context on innovation adoption in commercial banks. IEEE Transactions on Engineering Management. v47 i1. 14-25.
[38]
http://www.dwinfocenter.org
[39]
Griffith, T.L., Sawyer, J.E. and Neale, M.A., Virtualness and knowledge in teams: managing the love triangle of organizations, individuals, and information technology. MIS Quarterly. v27 i2. 265-287.
[40]
Grover, V., An empirically derived model for the adoption of customer-based inter-organizational systems. Decision Sciences. v24 i3. 603-640.
[41]
Grover, V., Fiedler, K. and Teng, J., Empirical Evidence on Swanson's Tri-Core Model of information systems innovation. Information Systems Research. v8 i3. 273-288.
[42]
Hair Jr., J.F., Anderson, R.E., Tatham, R.L. and Black, W.C., Multivariate Data Analysis with Readings. 1998. 5th Edition. Prentice Hall, Englewood Cliffs, N.J.
[43]
Hall, C., Corporate use of Data Warehousing and Enterprise Analytic Technologies. 2003. Arlington, Massachusetts.
[44]
Hambrick, D.C. and Mason, P., Upper echelons: the organization as a reflection of its top managers. Academy of Management Review. v9 i2. 193-206.
[45]
2002. Harris InfoSource, Twinsburg, OH.
[46]
Hart, P. and Estrin, D., Inter-organization networks, computer integration, and shifts in interdependence: the case of the semiconductor industry. ACM Transactions on Information Systems. v9 i4. 370-398.
[47]
Hartwick, J. and Barki, H., Explaining the role of user participation in information systems use. Management Science. v40 i4. 440-465.
[48]
Hu, L.-T. and Bentler, P., Cutoff criteria for fit indexes in covariance structure analysis: conventional criteria versus new alternatives. Structural Equation Modeling. v6 i1. 1-55.
[49]
Humphrey, W.S., Characterizing the software process: a maturity framework. IEEE Software. v5 i2. 73-79.
[50]
Hwang, H.-G., Ku, C.-Y., Yen, D.C. and Cheng, C.-C., Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan. Decision Support Systems. v37 i1. 1-21.
[51]
Iacovou, C.L., Benbasat, I. and Dexter, A.S., Electronic data interchange and small organizations: adoption and impact of technology. MIS Quarterly. v19 i4. 465-485.
[52]
Inmon, W.H., Building the Data Warehouse. 2002. 3rd Edition. John Wiley, New York.
[53]
http://billinmon.com/library/articles/artdweb.asp
[54]
http://billinmon.com/library/articles/artissue.asp
[55]
Jain, H., Ramamurthy, K., Ryu, H.S. and Yasai-Ardekani, M., Success of data resource management in distributed environments: an empirical investigation. MIS Quarterly. v22 i1. 1-23.
[56]
Jiang, J.J., Klein, G. and Carr, C.L., Measuring information system service quality: SERVQUAL from the other side. MIS Quarterly. v26 i2. 145-166.
[57]
J öreskog, K. and Sörbom, D., LISREL 8: User's Reference Guide. 1993. Scientific Software International, Inc., Chicago, IL.
[58]
Keen, P.G.W., Information systems and organizational change. Communications of the ACM. v24 i1. 24-33.
[59]
Kettinger, W.J., Grover, V., Guha, S. and Segars, A.H., Strategic information systems revisited: a study of sustainability and performance. MIS Quarterly. v18 i1. 31-58.
[60]
www.intelligententerprise.com/020726/512 warehouse1_1.shtml
[61]
Kimball, R., Reeves, L., Ross, M. and Thronthwaite, W., The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses. 1998. John Wiley, New York, NY.
[62]
Kimberly, J. and Evanisko, M., Organizational innovation: the influence of individual, organizational and contextual factors on hospital adoption of technological and administrative innovations. Academy of Management Journal. v24 i4. 689-713.
[63]
Kotler, S., When enterprises hit the open road: move beyond the silos and let the ideas roll. Teradata Magazine. v3 i3.
[64]
Kuitunen, K., Innovative behavior and organizational slack of a firm. 1993. The Helsinki School of Economics and Business Administration, Helsinki.
[65]
Kwon, T.H. and Zmud, R.W., Unifying the fragmented models of information systems implementation. In: Boland, R.J., Hirschheim, R.A. (Eds.), Critical Issues in Information Systems Research, Wiley, New York. pp. 227-251.
[66]
Lucas Jr., H.C., Empirical evidence for a descriptive model of implementation. MIS Quarterly. v2 i2. 27-41.
[67]
March, S.T. and Hevner, A.R., Integrated decision support systems: a data warehousing perspective. Decision Support Systems. v43 i3. 1031-1043.
[68]
Markus, M.L., Power, politics, and implementation. Communications of the ACM. v26 i6. 430-444.
[69]
Massey, A.P., Montoya-Weiss, M.M. and Brown, S.A., Reaping the benefits of innovative IT: the long and winding road. IEEE Transactions on Engineering Management. v48 i3. 348-357.
[70]
Munro, H. and Noori, H., Measuring commitment to new manufacturing technology: integrating technological push and marketing pull concepts. IEEE Transactions on Engineering Management. v35 i2. 63-70.
[71]
Nambisan, S., Agarwal, R. and Tanniru, M., Organizational mechanisms for enhancing user innovation in information technology. MIS Quarterly. v23 i3. 365-395.
[72]
www.intelligententerprise.com/010507/webhouse1_1.shtml
[73]
Nonaka, I., The knowledge-creating company. Harvard Business Review. v69 i6. 96-104.
[74]
Nunnally, J.C., Psychometric Theory. 1978. McGraw-Hill, New York.
[75]
Parr, A. and Shanks, G., A model of ERP project implementation. Journal of Information Technology. v15. 289-303.
[76]
Paulk, M.C., Weber, C.V., Curtis, B. and Chrissis, M.B., The Capability Maturity Model: Guidelines for Improving the Software Process. 1995. Addison-Wesley, Reading, MA.
[77]
Premkumar, G. and Ramamurthy, K., The role of interorganizational and organizational factors on the decision mode for adoption of interorganizational systems. Decision Sciences. v26 i3. 303-336.
[78]
Premkumar, G., Ramamurthy, K. and Nilakanta, S., Implementation of electronic data interchange. Journal of Management Information Systems. v11 i2. 157-186.
[79]
Premkumar, G., Ramamurthy, K. and Crum, M., Determinants of EDI adoption in the transportation industry. European Journal of Information Systems. v6 i2. 107-121.
[80]
Quaddus, M. and Intrapairot, A., Management policies and the diffusion of data warehouse: a case study using dynamics-based decision support system. Decision Support Systems. v31 i2. 223-240.
[81]
Ramamurthy, K. and Premkumar, G., Determinants and outcomes of electronic data interchange diffusion. IEEE Transactions on Engineering Management. v42 i4. 332-351.
[82]
Rogers, E.M., Diffusion of Innovation. 1995. 5th Edition. The Free Press, New York.
[83]
Ross, J.W., Beath, C.W. and Goodhue, D.L., Developing long-term competitiveness through IT assets. Sloan Management Review. v38 i1. 31-42.
[84]
Sambamurthy, V. and Zmud, R.W., Arrangements for information technology governance: a theory of multiple contingencies. MIS Quarterly. v23 i2. 261-290.
[85]
Sanders, G.L. and Courtney, J.F., A field study of organizational factors influencing DSS success. MIS Quarterly. v9 i1. 77-93.
[86]
Schubart, J.R. and Einbinder, J.S., Evaluation of a data warehouse in an academic health sciences center. International Journal of Medical Informatics. v60 i3. 319-333.
[87]
Shim, J.P., Warkentin, M., Courtney, J.F., Power, D.J., Sharda, R. and Carlsson, C., Past, present, and future of decision support technology. Decision Support Systems. v33 i2. 111-126.
[88]
Singh, J.V., Performance, slack, and risk-taking in organizational decision-making. Academy of Management Journal. v29 i2. 562-585.
[89]
http://www.survey.com
[90]
Swanson, B.E., Information systems innovation among organization. Management Science. v40 i9. 1069-1092.
[91]
Szulanski, G., Exploring internal stickiness: impediments to the transfer of best practice within the firm. Strategic Management Journal. v17. 27-43.
[92]
Thong, J.Y.L., Yap, C.S. and Raman, K.S., Top management support, external expertise, and information systems implementation in small businesses. Information Systems Research. v7 i2. 248-267.
[93]
Tornatzky, L.G. and Fleischer, M., The Process of Technological Innovations. 1990. Lexington Books, Lexington, MA.
[94]
Tornatzky, L.G. and Klein, K.J., Innovation characteristics and innovation adoption-implementation: a meta-analysis of findings. IEEE Transactions on Engineering Management. v29 i11. 28-45.
[95]
Venkatesh, V., Morris, M.G., Davis, G.B. and Davis, F.D., User acceptance of information technology: toward a unified view. MIS Quarterly. v27 i3. 425-478.
[96]
Watson, J.J., Gerard, J.G., Gonzalez, L.E., Haywood, M.E. and Fenton, D., Data warehousing failures: case studies and findings. Journal of Data Warehousing. v4 i1. 44-55.
[97]
Weill, P. and Broadbent, M., Leveraging the New Infrastructure. 1998. Harvard Business School Press, Boston, MA.
[98]
Wixom, B.J. and Watson, H.J., An empirical investigation of the factors affecting data warehousing success. MIS Quarterly. v25 i1. 17-41.
[99]
Yeaple, R.N., Why are small R&D organizations more productive?. IEEE Transactions on Engineering Management. v39 i4. 332-346.
[100]
Zeller, R.A. and Carmines, E.G., Measurement in Social Sciences: The Link between Theory and Data. 1980. Cambridge University Press, New York.
[101]
Zmud, R.W., An examination of push-pull theory applied to process innovation in knowledge work. Management Science. v30 i6. 727-738.

Cited By

View all
  • (2019)Examining the Moderating Effects of Time-Since-Adoption on the Nexus Between Business Intelligence Systems and Organisational PerformanceInternational Journal of Technology Diffusion10.4018/IJTD.201907010410:3(49-68)Online publication date: 1-Jul-2019
  • (2018)Business Intelligence Systems Adoption ModelJournal of Organizational and End User Computing10.4018/JOEUC.201804010330:2(43-70)Online publication date: 1-Apr-2018
  • (2018)Designing a Model for Implementation of Business Intelligence in the Banking IndustryInternational Journal of Enterprise Information Systems10.4018/IJEIS.201801010514:1(77-103)Online publication date: 1-Jan-2018
  • Show More Cited By

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image Decision Support Systems
Decision Support Systems  Volume 44, Issue 4
March, 2008
303 pages

Publisher

Elsevier Science Publishers B. V.

Netherlands

Publication History

Published: 01 March 2008

Author Tags

  1. Absorptive capacity
  2. Adoption
  3. Data warehousing
  4. Decision-support technology
  5. Innovation factors
  6. Organizational factors

Qualifiers

  • Article

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)0
  • Downloads (Last 6 weeks)0
Reflects downloads up to 26 Nov 2024

Other Metrics

Citations

Cited By

View all
  • (2019)Examining the Moderating Effects of Time-Since-Adoption on the Nexus Between Business Intelligence Systems and Organisational PerformanceInternational Journal of Technology Diffusion10.4018/IJTD.201907010410:3(49-68)Online publication date: 1-Jul-2019
  • (2018)Business Intelligence Systems Adoption ModelJournal of Organizational and End User Computing10.4018/JOEUC.201804010330:2(43-70)Online publication date: 1-Apr-2018
  • (2018)Designing a Model for Implementation of Business Intelligence in the Banking IndustryInternational Journal of Enterprise Information Systems10.4018/IJEIS.201801010514:1(77-103)Online publication date: 1-Jan-2018
  • (2018)Business Intelligence is No 'Free Lunch'International Journal of Business Intelligence Research10.4018/IJBIR.20180101019:1(1-15)Online publication date: 1-Jan-2018
  • (2017)Investigating the Factors Affecting Business Intelligence Systems AdoptionInternational Journal of Technology Diffusion10.4018/IJTD.20170401018:2(1-25)Online publication date: 1-Apr-2017
  • (2017)User acceptance of business intelligence applicationInternational Journal of Business Information Systems10.1504/IJBIS.2017.08774726:4(432-450)Online publication date: 1-Jan-2017
  • (2017)Business intelligence and organizational learningInformation and Management10.1016/j.im.2016.03.00954:1(38-56)Online publication date: 1-Jan-2017
  • (2017)Getting value from Business Intelligence systemsDecision Support Systems10.1016/j.dss.2016.09.01993:C(111-124)Online publication date: 1-Jan-2017
  • (2016)SQL Scorecard for Improved Stability and Performance of Data WarehousesInternational Journal of Software Innovation10.4018/IJSI.20160701024:3(22-37)Online publication date: 1-Jul-2016
  • (2016)Enterprise Data Warehouse Governance Best PracticesInternational Journal of Knowledge-Based Organizations10.4018/IJKBO.20160401026:2(21-37)Online publication date: 1-Apr-2016
  • Show More Cited By

View Options

View options

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media