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.
- 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.
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 18.104.22.168 INSERT Keyword 22.214.171.124 SELECT Keyword 126.96.36.199 UPDATE Keyword 188.8.131.52 DELETE Keyword 2.5.3 SQL: Converting Data into Information 184.108.40.206 Aggregate Functions in SQL 220.127.116.11 Grouping Data 18.104.22.168 Subqueries in SQL 22.214.171.124 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
- 25th October 2006
- Academic Press
- eBook ISBN:
- Hardcover ISBN:
Professor Industrial & Systems Engineering,Rutgers University, New Brunswick, New Jersey
Associate Professor Industrial & Management Systems Engineering,University of South Florida,Tampa, Florida