Application of the Analytic Hierarchy Process on Data Warehouse System Selection Decisions for Small and Large Enterprises in Taiwan

The study investigates the practice of data warehouse system selection decisions for small and medium-sized enterprises (SMEs) and large enterprises (LEs) in Taiwan. The increasing number of companies looking for data warehousing solutions to gain a significant business advantage has created a need for systematic method for choosing appropriate data warehouse system. The aim of this study is to determine the significant factors that influenced data warehouse system selection of LEs and SMEs. In this paper, both technical and managerial factors are considered to structure an evaluation hierarchy based on the Analytic Hierarchy Process (AHP). The AHP is used to examine the relative importance of data warehouse system selection criteria and subcriteria. The results indicate that SMEs selecting data warehouse systems mainly concentrate on cost and vendor criteria, and LEs focus on technical criteria.

[1]  Siriginidi Subba Rao.  Enterprise resource planning: business needs and technologies , 2000, Ind. Manag. Data Syst..

[2]  Marinos Themistocleous,et al.  Evaluating and adopting application integration: the case of a multinational petroleum company , 2002, Proceedings of the 35th Annual Hawaii International Conference on System Sciences.

[3]  Cs Yap,et al.  Information systems success factors in small business , 1992 .

[4]  Abraham Seidmann,et al.  An analytic approach for planning computerized office systems , 1983 .

[5]  Torben Bach Pedersen,et al.  Multidimensional Database Technology , 2001, Computer.

[6]  Michael L. Gibson,et al.  Perceived Influences on Implementing Data Warehousing , 2003, IEEE Trans. Software Eng..

[7]  James Y. L. Thong,et al.  An Integrated Model of Information Systems Adoption in Small Businesses , 1999, J. Manag. Inf. Syst..

[8]  Lakshmi S. Iyer,et al.  Knowledge warehouse: an architectural integration of knowledge management, decision support, artificial intelligence and data warehousing , 2002, Decis. Support Syst..

[9]  J. Thong.  Resource Constraints and Information Systems Implementation in Singaporean Small Businesses , 2001 .

[10]  V. M. Rao Tummala,et al.  An application of the AHP in vendor selection of a telecommunications system , 2001 .

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

[12]  Lesley Davis,et al.  Evaluating and Selecting Simulation Software Using the Analytic Hierarchy Process , 1994 .

[13]  Ali H. Murtaza,et al.  A Framework for Developing Enterprise Data Warehouses , 1998, Inf. Syst. Manag..

[14]  George Zagelow,et al.  The IBM data warehouse architecture , 1998, CACM.

[15]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[16]  Hokey Min,et al.  Selection of Software: The Analytic Hierarchy Process , 1992 .

[17]  Benjamin W. Lin,et al.  Selection of automated office systems: a case study , 1981 .

[18]  Frank Bannister,et al.  The effective measurement and management of ICT costs and benefits. 3rd edition. , 2007 .

[19]  N. K. Kwak,et al.  Information resource planning for a health-care system using an AHP-based goal programming method , 1999, J. Oper. Res. Soc..

[20]  Linda A. Brown,et al.  The evolving approval plan: how academic librarians evaluate services for vendor selection and performance , 1999 .

[21]  W. H. Inmon,et al.  Data Warehouse Performance , 1998 .

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

[23]  Barbara Wixom,et al.  The benefits of data warehousing: why some organizations realize exceptional payoffs , 2002, Inf. Manag..

[24]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[25]  Jinwoo Kim,et al.  An AHP & Survey for Selecting Workflow Management Systems , 1997, Intell. Syst. Account. Finance Manag..

[26]  Victoria Y. Yoon,et al.  Selection of a good expert system shell for instructional purposes in business , 1992, Inf. Manag..

[27]  Surajit Chaudhuri,et al.  Database Technology for Decision Support Systems , 2001, Computer.

[28]  Jan Olhager,et al.  Enterprise resource planning survey of Swedish manufacturing firms , 2003, Eur. J. Oper. Res..

[29]  Jos van Hillegersberg,et al.  ERP Adoption by European Midsize Companies. , 2000 .

[30]  Ioannis Stamelos,et al.  Knowledge based evaluation of software systems: a case study , 2000, Inf. Softw. Technol..

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

[32]  David C. Yen,et al.  Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan , 2004, Decis. Support Syst..

[33]  Giri Kumar Tayi,et al.  Enhancing data quality in data warehouse environments , 1999, CACM.

[34]  Thomas L. Saaty,et al.  Decision Making for Leaders: The Analytical Hierarchy Process for Decisions in a Complex World , 1982 .

[35]  Xavier Burgués Illa,et al.  Formalising ERP selection criteria , 2000, Tenth International Workshop on Software Specification and Design. IWSSD-10 2000.

[36]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[37]  Joachim Griese,et al.  Investigating the buying process for the introduction of data processing in small and medium-sized firms , 1985, Inf. Manag..

[38]  中華經濟研究院.  White paper on small and medium enterprises in Taiwan , 1998 .

[39]  Vinod Kumar,et al.  ERP systems implementation: best practices in Canadian government organizations , 2002, Gov. Inf. Q..

[40]  Bongsik Shin.  A case of data warehousing project management , 2002, Inf. Manag..

[41]  Izak Benbasat,et al.  Electronic Data Interchange and Small Organizations: Adoption and Impact of Technology , 1995, MIS Q..

[42]  T. Saaty.  Axiomatic foundation of the analytic hierarchy process , 1986 .

[43]  Themis Palpanas,et al.  Knowledge discovery in data warehouses , 2000, SGMD.

[44]  Georgios I. Doukidis,et al.  Trends in information technology in small businesses , 1994 .

[45]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[46]  John A. Welsh,et al.  A Small Business is not a Little Big Business Harvard Business Review, Vol. 59, No. 4, July/August, 1981, pp.18 (9 pages , 1982 .

[47]  P. Powell,et al.  Evaluating information systems in small and medium-sized enterprises: issues and evidence , 1998 .

[48]  Wolfgang Ossadnik,et al.  AHP-based evaluation of AHP-Software , 1999, Eur. J. Oper. Res..

[49]  Panos Vassiliadis,et al.  Towards Quality-oriented Data Warehouse Usage and Evolution , 2000, Inf. Syst..

[50]  Ernest H. Forman,et al.  Group decision support with the Analytic Hierarchy Process , 1992, Decis. Support Syst..

[51]  Abraham Seidmann,et al.  Microcomputer selection process for organizational information management , 1984, Inf. Manag..

[52]  Luigi Palopoli,et al.  Experiences using DIKE, a system for supporting cooperative information system and data warehouse design , 2003, Inf. Syst..

[53]  Sanjay L. Ahire,et al.  Quality Management in Large vs Small Firms , 1996 .

[54]  Paul Ati ' Ewell.  TECHNOLOGY DIFFUSION AND ORGANIZATIONAL LEARNING: THE CASE OF BUSINESS COMPUTING* , 1992 .

[55]  T. Saaty,et al.  The Analytic Hierarchy Process , 1985 .

[56]  Anand Teltumbde,et al.  A framework for evaluating ERP projects , 2000 .

[57]  Laks V. S. Lakshmanan,et al.  Constraint-Based Multidimensional Data Mining , 1999, Computer.

[58]  Steven Tolkin.  Aggregation everywhere: data reduction and transformation in the Phoenix data warehouse , 1999, DOLAP '99.

[59]  Louis Raymond,et al.  Information technology: Threats and opportunities for small and medium-sized enterprises , 1993 .

[60]  Chee-Sing Yap,et al.  Top Management Support, External Expertise and Information Systems Implementation in Small Businesses , 1996, Inf. Syst. Res..

[61]  Bo K. Wong,et al.  Software selection: a case study of the application of the analytical hierarchical process to the selection of a multimedia authoring system , 1999, Inf. Manag..

[62]  Dimitri Theodoratos,et al.  Data Currency Quality Satisfaction in the Design of a Data Warehouse , 2001, Int. J. Cooperative Inf. Syst..

[63]  Jinwoo Kim,et al.  An AHP & Survey for Selecting Workflow Management Systems , 1997 .

[64]  John M. Ward,et al.  Using resource-based theory to interpret the successful adoption and use of information systems and technology in manufacturing small and medium-sized enterprises , 2003, Eur. J. Inf. Syst..

[65]  Timo Saarinen,et al.  Success of software packages in small businesses: an exploratory study , 1991 .

[66]  Bo K. Wong,et al.  Group decision making in a multiple criteria environment: A case using the AHP in software selection , 2002, Eur. J. Oper. Res..

[67]  John van den Hoven.  Data Warehousing: Bringing it All Together , 1998, Inf. Syst. Manag..

[68]  Zeger Degraeve,et al.  Improving the efficiency of the purchasing process using total cost of ownership information: The case of heating electrodes at Cockerill Sambre S.A , 1999, Eur. J. Oper. Res..

[69]  Jonathan Burton,et al.  Application of Analytical Hierarchy Process in Operations Management , 1990 .

[70]  Kai Lung Hui,et al.  A Choice Model for the Selection of Computer Vendors and Its Empirical Estimation , 2001, J. Manag. Inf. Syst..

[71]  J. A. Sharp,et al.  The Analytic Hierarchy Process and its Application to an Information Technology Decision , 1990 .

[72]  Patrick Y. K. Chau,et al.  Factors used in the selection of packaged software in small businesses: Views of owners and managers , 1995, Inf. Manag..

[73]  Saul I. Gass,et al.  The Analytic Hierarchy Process - An Exposition , 2001, Oper. Res..

[74]  Robert D. Smith,et al.  Selection criteria for expert system shells: a socio-technical framework , 1992, CACM.

[75]  Margi Levy,et al.  Information systems strategy for small and medium sized enterprises: an organisational perspective , 2000, J. Strateg. Inf. Syst..

[76]  Paul Gray,et al.  Present and future directions in data warehousing , 1998, DATB.

[77]  Louis Raymond,et al.  Organizational Context and Information Systems Success: A Contingency Approach , 1990, J. Manag. Inf. Syst..

[78]  Gary A. Knight,et al.  Entrepreneurship and strategy in the international SME , 2001 .

[79]  William E. Souder,et al.  A Scoring Methodology for Assessing the Suitability of Management Science Models , 1972 .

[80]  Zone-Ching Lin,et al.  Evaluation of machine selection by the AHP method , 1996 .

[81]  Luis G. Vargas.  An overview of the analytic hierarchy process and its applications , 1990 .

[82]  Khurrum S. Bhutta,et al.  Supplier selection problem: a comparison of the total cost of ownership and analytic hierarchy process approaches , 2002 .

[83]  Fatemeh Zahedi,et al.  Applications and Implementation DATA‐BASE MANAGEMENT SYSTEM EVALUATION AND SELECTION DECISIONS* , 1985 .

[84]  R. P. Mohanty,et al.  Use of the Analytic Hierarchy Process for Selecting Automated Manufacturing Systems , 1993 .

[85]  Zahir Irani,et al.  An exploratory study of information technology evaluation and benefits management practices of SMEs in the construction industry , 2004, Inf. Manag..

[86]  Fatemeh Zahedi,et al.  A method for quantitative evaluation of expert systems , 1990 .

[87]  Fatemeh Zahedi,et al.  The Analytic Hierarchy Process—A Survey of the Method and its Applications , 1986 .

[88]  D. Fink,et al.  Guidelines for the Successful Adoption of Information Technology in Small and Medium Enterprises , 1998 .