Description

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), with an accompanying website containing usable sample databases

Readership

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 2.5.2.1 INSERT Keyword 2.5.2.2 SELECT Keyword 2.5.2.3 UPDATE Keyword 2.5.2.4 DELETE Keyword 2.5.3 SQL: Converting Data into Information 2.5.3.1 Aggregate Functions in SQL 2.5.3.2 Grouping Data 2.5.3.3 Subqueries in SQL 2.5.3.4 Appending Tables Using Joins 2.6 Summary Review Exercises Appendix 2A Query by Example Chapter 3 Data Modeling 3.1 Introduction

Details

No. of pages:
496
Language:
English
Copyright:
© 2006
Published:
Imprint:
Academic Press
Print ISBN:
9780123704924
Electronic ISBN:
9780080465531

About the authors

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