|Table of Contents|
|ERP & Data Warehousing in Organizations—Issues and Challenges|
|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|
|List of Figures|
|List of Tables|
|List of Boxes|
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
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
1331 E. Chocolate Avenue, Suite 200
Hershey PA 17033-1117
Web site: http://www.irm-press.com
and in the United Kingdom by
IRM Press (an imprint of Idea Group Inc.)
3 Henrietta Street
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.
British Cataloguing in Publication Data
A Cataloguing in Publication record for this book is available from the British Library.
About the Authors
is an assistant
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 finance projects
in Marketing Management from the University of St. Thomas in Minneapolis/St. Paul, Minnesota in 1998, and is currently
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
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
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
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-
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.
is a senior lecturer in Information Systems at Victoria University, Melbourne, Australia. He has
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.
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,
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
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).
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 <email@example.com>.
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,
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-
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
This book would not have been possible without the help of a large number of people. I would like to
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
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.
Carleton University, Canada
March 4, 2003