Table of Contents

erp & data warehousing in organizations: issues and challenges
ERP & Data Warehousing in Organizations: Issues and Challenges
byGerald Grant (ed) ISBN:1931777497
Idea Group Publishing 2003 (262 pages)

Offering ERP deployment strategies for information as diverse as patient records, police and community relations, and geospatial services, this text addresses the complex issues that IT and communication technologies pose for organizations of all sizes.

Table of Contents
ERP & Data Warehousing in Organizations—Issues and Challenges
Preface
Part I - ERP Systems and Enterprise Integration
Chapter 1 - ERP Systems Impact on Organizations
Chapter 2 - Challenging the Unpredictable: Changeable Order Management Systems
Chapter 3 - ERP System Acquisition: A Process Model and Results From an Austrian Survey
Chapter 4 - The Second Wave ERP Market: An Australian Viewpoint
Chapter 5 - Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Chapter 6 - The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
Chapter 7 - Context Management of ERP Processes in Virtual Communities
Part II - Data Warehousing and Data Utilization
Chapter 8 - Distributed Data Warehouse for Geo-spatial Services
Chapter 9 - Data Mining for Business Process Reengineering
Chapter 10 - Intrinsic and Contextual Data Quality: The Effect of Media and Personal Involvement
Chapter 11 - Healthcare Information: From Administrative to Practice Databases
Chapter 12 - A Hybrid Clustering Technique to Improve Patient Data Quality
Chapter 13 - Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
Chapter 14 - Development of Interactive Web Sites to Enhance Police/Community Relations
Index
List of Figures
List of Tables
List of Boxes

Back Cover

The successful implementation and deployment of enterprise resource planning depends on organizations’ understanding of the complex and challenging issues involved in the process. And, the further development of information and communication technologies is presenting more challenges to organizations. ERP & Data Warehousing in Organizations: Issues and Challenges attempts to provide the most recent research and findings concerning these issues, in order to provide practical assessments and suggestions for managers in the process of developing such systems.

About the Editor

Gerald Grant is an assistant professor of Information Systems at the Eric Sprott School of Business, Carelton University in Ottawa, Canada. He is a coordinator of the Information Systems Area and serves as chair of the Enterprise Systems/e-Business Committee in the school. He previously taught at McGill University, and in the Department of Computer Science and Information Systems at Brunel University, Uxbridge, UK. He serves on the advisory board of the Ottawa Manufacturers Network, and is editor of the book, Managing Telecommunications and Networking Technologies in the 21st Century: Issues and Trends, published in March 2001 by Idea Group Publishing.

ERP & Data Warehousing in Organizations—Issues and Challenges

Gerald Grant Carleton University,

Canada

IRM Press Publisher of innovative scholarly and professional information technology titles in the cyberage

Hershey London Melbourne Singapore Beijing

Acquisitions Editor: Mehdi Khosrow-Pour

Senior Managing Editor: Jan Travers

Managing Editor: Amanda Appicello

Development Editor: Michele Rossi

Copy Editor: Ingrid Widitz

Typesetter: Amanda Appicello

Cover Design: Michelle Waters

Printed at: Integrated Book Technology

Published in the United States of America by

  • IRM Press (an imprint of Idea Group Inc.)
    1331 E. Chocolate Avenue, Suite 200
    Hershey PA 17033-1117
    Tel: 717-533-8845
    Fax: 717-533-8661
    E-mail: <cust@idea-group.com>
    Web site: http://www.irm-press.com

and in the United Kingdom by

  • IRM Press (an imprint of Idea Group Inc.)
    3 Henrietta Street
    Covent Garden
    London WC2E 8LU
    Tel: 44 20 7240 0856
    Fax: 44 20 7379 3313
    Web site: http://www.eurospan.co.uk

Copyright © 2003 by IRM Press.

All rights reserved. No part of this book may be reproduced in any form or by any means, electronic or mechanical, including photocopying, without written permission from the publisher.

Library of Congress Cataloging-in-Publication Data

Grant, Gerald G.
 ERP & data warehousing in organizations:issues and challenges /
Gerald Grant.
       p.cm.
Also available in electronic form.
 

ISBN 1-931777-49-7 (soft-cover)

ISBN 1-931777-65-9 (e-book)


1. Management information systems. 2. Data warehousing. I. Title: ERP and data warehousing in organizations. II. Title.

HD30.213.G73 2003

658.4'012--dc21

2002156235

British Cataloguing in Publication Data

A Cataloguing in Publication record for this book is available from the British Library.

About the Authors

Gerald Grant is an assistant professor of Information Systems at the Eric Sprott School of Business, Carleton University in Ottawa, Canada. He is a coordinator of the Information Systems Area and serves as chair of the Enterprise Systems/ e-Business Committee in the school. He previously taught at McGill University, Montreal, Canada, and in the Department of Computer Science and Information Systems at Brunel University, Uxbridge, UK. He also served as vice-principal for Financial Administration at Solusi University, Bulawayo, Zimbabwe. Dr. Grant obtained his Ph.D. in Information Systems from the London School of Economics and Political Science, University of London, UK. He has consulted for the Commonwealth Secretariat in the UK and the COMNET-IT Foundation in Malta on projects related to e-business and e-government strategies, institutional networking and IT capability building, national and sectoral IT strategies. He served as a program coordinator for the Commonwealth-sponsored "Regional Initiative for Informatics Strategies." He serves on the advisory board of the Ottawa Manufacturers Network. He is editor of the book, Managing Telecommunications and Networking Technologies in the 21st Century: Issues and Trends, published in March 2001 by Idea Group Publishing.

I. Androwich is a professor of Community and Administrative Nursing at the Marcella Niehoff School of Nursing, Loyola University, Chicago, USA. She has an A.D. from Morton College, a B.S.N. Magna Cum Laud from Loyola, a M.S. in Public Health Nursing from the University of Illinois and a Ph.D. in Public Health from the University of Illinois. She is a fellow in the American Academy of Nursing.

Susan A. Baim is an assistant professor of Business Technology (BTE) on the Miami University, Middletown campus, USA. She joined the faculty in August 1999, teaching Marketing, Internet Marketing, Economics, Online Economics, Finance and Management courses in the University's two-year BTE program. She earned her MBA in Marketing Management from the University of St. Thomas in Minneapolis/St. Paul, Minnesota in 1998, and is currently studying for her Ph.D. in E-Business through Capella University, also in Minneapolis. She was named a Service Learning Ambassador at Miami University in 2000. She has a strong interest in distance education programs and how they may be applied to two-year academic programs. She and her students in the BTE program are also known for their customer satisfaction survey work for police departments and other governmental agencies in Southwestern Ohio.

Joachim Berlak finished his Master of Science in Mechanical Engineering from the Technische Universtitaet Muenchen, Germany, in 1999. He was the recipient of the first price for his master thesis on supply chain management by the German Gesellschaft fuer Produktionsmanagement (GfPM) in 2000. In the same year, he became a research assistant at the Institute for Machine Tools and Industrial Management (iwb) and manager of the research project CHANGESYS from the Bavarian Network for Software Engineering (FORSOFT). He has published papers at several conferences, like the OESSEO2001, OOPLSA2001, IRMA2002, ICSTM2002, ICSE2002, and in international journals, like the Journal for Production Planning and Control or the Journal for Business Process Management.

Edward W. N. Bernroider is assistant professor at the Vienna University of Economics and Business Administration, Institute of Information Processing in Austria. He holds a Master of Science degree in applied informatics from the University of Salzburg and a Ph.D. in business administration from the Vienna University of Economics and B.A., where he teaches in the undergraduate and MBA programs. His current research and industry projects focus on the international software industry, ERP systems and the evaluation of IT costs and benefits.

Andrew S. Borchers, DBA, serves as an associate professor of Information Systems at Kettering University (formerly, GMI Engineering and Management Institute) in Flint, Michigan, USA. Prior to entering full-time academic life, Andy spent 21 years working as an IT professional and manager for General Motors and Electronic Data Systems. His professional and academic interests are broad and include data management, e-commerce, networking and IT management topics. Andy holds academic degrees from Kettering, Vanderbilt and Nova Southeastern.

Andreas Borell is a master student at the School of Economics, Department of Informatics, Lund University, Sweden. He is a former employee of the dot.com world working for an old world enterprise. He has been jointly published in international conferences as well as books.

Farhad Daneshgar is a senior lecturer of Information Systems at the University of New South Wales, Australia. Prior to joining academia in 1994, he was an IT consultant in the building and telecommunications industries. He received his Ph.D. in Computer Science from the University of Technology, Sydney, and his current research interests include data mining, design of collaborative support systems and collaboration patterns in organizational processes. More recently he has been playing an important role in the design and commercialization of a new generation of Internet server appliance for SMEs that is based on virtually infinite word length processor.

Bernhard Deifel is scientist and the chair for Software and Systems Engineering at the Institut fuer Informatik of the Technische Universtitaet Muenchen (Germany) since 1996. Until 1995, he studied informatics at the University of Passau. Afterwards, he worked on concepts for rapid prototyping of embedded systems within BMW. He currently works within interdisciplinary research projects on Software Engineering in close cooperation with industry companies. His main focus is Requirements Engineering and Software Architectures. In Summer, 2001, he finished his Ph.D. on Requirements Engineering of complex commercial off-the-shelf software.

K. C. Desouza is a doctoral candidate and research associate at the Center for Research in Information Management at the University of Illinois at Chicago, USA. He has over a dozen papers published or forthcoming in journals such as Communications of the ACM, Competitive Intelligence Review, Business Horizons, International Journal of Healthcare Technology Management, and in various conference proceedings. His recent book, Managing Knowledge with Artificial Intelligence, was published by Quorum Books. He has a B.Sc. with distinctions in Accounting, and Information & Decision Sciences from the University of Illinois at Chicago, and an MBA with distinction in Information Management from the Stuart Graduate School of Business, Illinois Institute of Technology.

Aryya Gangopadhyay is an assistant professor of Information Systems at the University of Maryland, Baltimore County (UMBC), USA. He has a Ph.D. in Computer Information Systems from Rutgers University. His research interests include electronic commerce, data warehousing and mining, and geographic information systems. He has co-authored and edited three books, many book chapters, numerous papers in journals, such as AI in Engineering, Decision Support Systems, Quarterly Journal of Electronic Commerce, IEEE Computer, IEEE Transactions on Knowledge and Data Engineering, Journal of Management Information Systems, as well as presented papers in many national and international conferences. He can be reached at <gangopad@umbc.edu>.

Narasimhaiah Gorla is an associate professor of Information Systems at Wayne State University, USA. He obtained his Ph.D. from University of Iowa, Iowa City. He obtained his MBA from Indian Institute of Management, Calcutta. He has over 28 years of experience in Information Systems - nine years in industry and 19 years in academia. His research interests include database/data warehouse design, data mining, software metrics, IS outsourcing, etc.

Paul Hawking is a senior lecturer in Information Systems at Victoria University, Melbourne, Australia. He has contributed to the Journal of ERP Implementation and Management, Management Research News and contributed many conference papers on IS theory and practice. He is responsible for managing the university's strategic alliance with SAP and is coordinator of the university's ERP Research Group. Dr. Hawking is the immediate past Chairperson of the SAP Australian User Group.

Jonas Hedman is a Ph.D. candidate at the School of Economics, Department of Informatics, Lund Universitym Sweden. He has been responsible for the development of their e-business management program and SAP university alliance program. He has been published in international conferences, accepted for publication in European Journal of Information Systems, recently co-published a book entitled IT and Business Models: Concepts and Theories, and has been an invited guest speaker at SAP University Alliance Congress.

Bonn-Oh Kim is an associate professor in the Department of Management and Director of the Center for Electronic Commerce and Information Systems at the Seattle University, USA. He holds Ph.D. and MBA degrees from the University of Minnesota and the University of Washington, respectively. His research interests include strategic and technical issues in corporate information systems.

Stefan Koch is an assistant professor of Information Business at the Vienna University of Economics and Business Administration, Austria. He received a MBA in Management Information Systems from Vienna University and Vienna Technical University, and a Ph.D. from Vienna University of Economics and Business Administration. Currently he is involved in the undergraduate and graduate teaching programs, especially in software project management and ERP packages. His research interests include cost estimation for software projects, the open source development model, software process improvement, the evaluation of benefits from information systems and ERP systems.

M. R. Kraft has a diploma from the George F. Geisinger School of Nursing at the Geisinger Medical Center in Danville, Pennsylvania. Her Baccalaureate in Nursing is from the Frances Payne Bolton School of Nursing at Case Western Reserve University in Cleveland, Ohio. Her Master of Science is from the School of Nursing at Northern Illinois University in DeKalb, Illinois. She has a Ph.D. in Nursing from Loyola University, Chicago. Her areas of clinical practice include rehabilitation, geriatrics, spinal cord injury, and informatics. She is currently the Clinical Coordinator of the Decision Support System at the Edward Hines Jr. Veterans' Administration Hospital, USA.

Ted E. Lee is an assistant professor of MIS at The University of Memphis, USA. He received a M.S. in Computer Science from the Pennsylvania State University, and a Ph.D. in MIS from University of Nebraska. His research interests include knowledge engineering/management, database systems, and data warehousing/mining.

Ernest L. Nichols, Jr., is the director of the Center for Supply Chain Management in the FedEx Technology Institute and Associate Professor of Supply Chain and Operations Management at The University of Memphis, USA. Dr. Nichols research interests include a range of integrated supply chain management issues.

Robert Otondo, Ph.D., is an assistant professor of MIS at The University of Memphis, USA. He earned his Ph.D. from Arizona State University. Dr. Otondo's research interests include knowledge management, system dynamics, and computer-mediated communication.

Pattarawan Prasarnphanich is a doctoral candidate in the Management Information Systems Department at The University of Memphis. She received her MBA from Virginia Commonwealth University. Her research interests include organizational learning, team learning, electronic commerce, and information technology diffusion.

Frederic Rowohl is an external doctoral student at the Institute of Information Management, University of St. Gallen, Switzerland. He received his diploma in business economics from the University of St. Gallen in 2000. During his studies he worked as a junior assistant in the research project "Data Warehouse Strategy" at the Institute of Information Management, University of St. Gallen. He is working at Bayer AG, Leverkusen, Germany. His research interests are in customer relationship management (CRM) and in enterprise application integration (EAI).

Joachim Schelp manages the research projects "Application Integration Management" and "Relationship Management Architecture" at the Institute of Information Management, University of St. Gallen, Switzerland. He is also working on his postdoctoral thesis ("Habilitation"). He holds a diploma in economics from the University of Bochum, Germany. He received his Ph.D. in economics, with a specialization in information management from the University of Bochum, Germany. His current research interests include strategic management of information technology, information technology architecture and infrastructure, relationship management, and the interfaces between business models, processes, and information systems.

Roel W. Schuring, Ph.D., is associate professor in the Management of Healthcare Organizations at the University of Twente, Enschede, The Netherlands since 2000. His particular research interest lies in the effective organization of healthcare processes and in the effective use of new technologies in these processes. He has a background in operations management. Various healthcare organizations cooperate in the research project of his team on both subjects. He did previous research projects on continuous improvement, autonomous work groups, innovation diffusion and organizational change.

Iftikhar U. Sikder is a doctoral candidate at the University of Maryland, Baltimore County, USA. His research interests include spatial database, probabilistic reasoning and machine learning. He has published in the Information Resources Management Journal and International Journal of Aerospace Survey and Earth Sciences. He has co-authored several book chapters. He can be reached at <isikde1@umbc.edu>.

Ton A. M. Spil, Ph.D., is assistant professor at the department of Technology & Management at the University of Twente, Enschede, The Netherlands. He is teaching in the area of Business Information Systems, mainly in project-based education. In 1988, he finished his master's in Computer Science and started his own company consulting big firms on strategic information systems planning. In 1996, he finished his Ph.D. thesis on the effectiveness of these plans, and after that he specialized in the application area healthcare and professional organizations. Since 2000, he has led various e-health research projects and he has been a track chair on HICSS.

Andrew Stein is a lecturer in the School of Information Systems in the Faculty of Business and Law at Victoria University, Melbourne, Australia. He has contributed to the International Journal of Management, Journal of Information Management, Journal of ERP Implementation and Management, Management Research News and contributed many conference papers on IS theory and practice. His research interests include enterprise systems, e-procurement applications, e-marketplace business models and reverse auction systems. He is a member of the university's ERP Research Group and the Australian SAP user group.

Aareni Uruthirapathy until recently worked as a policy analyst with the Department of Finance, Government of Canada. She previously taught Economics and Statistics at Methodist College, Sri Lanka. Aareni holds an MBA from Carlton University (Ottawa), as well as a B.Com from University of Colombo (Sri Lanka). Her area of concentration for the MBA program was Information Systems and Organizational Behavior. She intends to pursue a Ph.D. in the same area.

Acknowledgments

This book would not have been possible without the help of a large number of people. I would like to acknowledge those who were involved in collating the book and assisting with the review of the chapters. The authors who provided the chapters deserve particular mention. Thank you for the insights provided by your chapters and the contributions you've made to our understanding of two very important subjects.

Ultimately, the success of this book is possible mainly because of the professional support provided by Mehdi Khosrow-Pour and the Idea Group team. Special thanks to Amanda Appicello and other staff members at Idea Group, Inc. who guided this whole process. Thanks for their patience in working with me as editor.

Finally, I would like to thank Joan, my wife, and my sons, Julian and Jeremy, for their love and patient support while I spent time on this project.

Gerald Grant
Carleton University, Canada
March 4, 2003