Design of Industrial Information Systems

1st Edition

Authors: Thomas Boucher Ali Yalcin
Hardcover ISBN: 9780123704924
eBook ISBN: 9780080465531
Imprint: Academic Press
Published Date: 25th October 2006
Page Count: 496
107.00 + applicable tax
64.99 + applicable tax
80.95 + applicable tax
99.95 + applicable tax
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Design of Industrial Information Systems presents a body of knowledge applicable to many aspects of industrial and manufacturing systems. New software systems, such as Enterprise Resource Planning, and new hardware technologies, such as RFID, have made it possible to integrate what were separate IT databases and operations into one system to realize the greatest possible operational efficiencies. This text provides a background in, and an introduction to, the relevant information technologies and shows how they are used to model and implement integrated IT systems.

With the growth of courses in information technology offered in industrial engineering and engineering management programs, the authors have written this book to show how such computer-based knowledge systems are designed and used in modern manufacturing and industrial companies.

Key Features

  • Introduces Data Modeling and Functional Architecture Design, with a focus on integration for overall system design
  • Encompasses hands-on approach, employing many in-chapter exercises and end-of-chapter problem sets with case studies in manufacturing and service industries
  • Shows the reader how Information Systems can be integrated into a wider E-business/Web-Enabled Database business model
  • Offers applications in Enterprise Resource Planning (ERP) and Manufacturing Execution Systems (MES)


upper level undergraduate and lower level graduate courses in industrial engineering and industrial management programs.

Table of Contents

Chapter 1 Introduction 1.1 Introduction 1.2 ERP/MES/Control: A Hierarchy of Information 1.3 Network Architecture 1.4 Some Key Application Areas of an Industrial Information System (IIS) 1.4.1 Customer Relationship Management 1.4.2 Order Fulfi llment Management 1.4.3 Warehouse Management System 1.4.4 Quality Management 1.4.5 Human Resource Management 1.4.6 Accounting and Financial Management 1.4.7 Distribution System and Supply Chain Management 1.5 Information Systems and Decision Support Systems 1.6 Production System Classifi cations and Information Requirements 1.6.1 Mechanical Fabrication Industries 1.6.2 Process Industries 1.6.3 Service Industries 1.7 About This Book 1.8 Summary Chapter 2 The Relational Database Model 2.1 Introduction 2.2 The Database Management System (DBMS) 2.3 The Relationship Database Viewed as a Set of Tables 2.4 Key Attributes and Linking Tables 2.5 Structured Query Language (SQL) Contents 2.5.1 SQL: Creating the Database and Table Structure 2.5.2 SQL: Managing the Data in the Database Table INSERT Keyword SELECT Keyword UPDATE Keyword DELETE Keyword 2.5.3 SQL: Converting Data into Information Aggregate Functions in SQL Grouping Data Subqueries in SQL Appending Tables Using Joins 2.6 Summary Review Exercises Appendix 2A Query by Example Chapter 3 Data Modeling 3.1 Introduction <BR


No. of pages:
© Academic Press 2006
Academic Press
eBook ISBN:
Hardcover ISBN:

About the Author

Thomas Boucher

Affiliations and Expertise

Professor Industrial & Systems Engineering,Rutgers University, New Brunswick, New Jersey

Ali Yalcin

Affiliations and Expertise

Associate Professor Industrial & Management Systems Engineering,University of South Florida,Tampa, Florida