Efficiency evaluation of data warehouse operations

  • Authors:
  • Michael Mannino;Sa Neung Hong;In Jun Choi

  • Affiliations:
  • The Business School, University of Colorado Denver, Denver, CO 80217, USA;University of Seoul, Seoul, South Korea;Department of Industrial Engineering, Pohang University of Science and Technology, Pohang, South Korea

  • Venue:
  • Decision Support Systems
  • Year:
  • 2008

Quantified Score

Hi-index 0.01

Visualization

Abstract

We evaluate an efficiency model for data warehouse operations using data from USA and non-USA-based (mostly Korean) organizations. The analysis indicates wide dispersions in operational efficiency, industry and region differences, large differences in labor budgets between efficient and inefficient firms, few organizations efficient in both refresh processing and query production, and difficulty of providing some variables. Follow-up interviews provide insights about the value of efficiency comparisons of information technology organizations and suggestions to improve the model. Using this analysis, we propose a framework containing data warehouse characteristics and firm characteristics to explain IT operational efficiency at the subfirm level.