Skip to main content
SpringerLink
Log in

Design and implementation of a CIM information system

  • Published:
Engineering with Computers Aims and scope Submit manuscript

Abstract

Information integration is vital for keeping manufacturing operations competitive. A case study approach has been adopted to better understand the role of informatio in integrated manufacturing. Information is now considered a corporate asset. The creation, processing, movement and security of information is therefore as important as the products/services of an enterprise. The case studies have helped in identifying the requirements and issues involved in developing an information system and supporting software framework for a manufacturing enterprise. This paper deseribes a case study dealing with the integrated manufacture of optical fiber products. A phased development and implementation approach was adopted where a small, manageable slice of the system is considered for the case study followed by functional modeling (IDEFO) and data flow modeling (data flow diagrams). This identifies the pieces of information of interest. The information relationships are modeled using extended entity relationship (EER) diagrams which are then mapped to a relational model. The relational tables thus obtained were implemented on a commercial Database Management System (DBMS). The functional constraints and application interfaces were then built using Structured Query Languages (SQL) and commercial application interface tools. Subsequent sections describe the functional models, data flow diagrams (DFDs), EER diagrams, relational database design and user/application interfaces developed for the system. Implementation experiences and observations are discussed along with the applications of the implemented system. The case study has helped in developing a preliminary data model (i.e., a model about data by which a reasonable interpretation of the data can be obtained) for material handling (MH) functions.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. White, J.A. (1988) Material handling in integrated manufacturing system, Design and Analysis of Integrated Manufacturing Systems, National Academy Press, Washington, D.C.

    Google Scholar 

  2. Chadha, B.; Rangan, R.M.; Fulton, R.E. (1989) An intelligent information driven approach to integrate design and manufacturing environments, Fourth International Conf. on CAD/CAM, Robotics and Factories of the Future

  3. White, J.A. (1979) Identifying the materials handling research needs for discrete parts in the automated factory, NSF Workshop held at Georgia Tech

  4. Cohen, G. (1988) Main components of a computer-integrated manufacturing reference model, CIM Review, Winter

  5. Chadha, B.; Fulton, R.E. (1990) Issues involving informationintegration of material handling, ASME-WAM, November

  6. Hall, K. (1990) A framework for change propagation in a design database, ASME-WAM, November

  7. Eastman, R.M.; (1987) Material Handling, Marcel Dekker, New York

    Google Scholar 

  8. Chadha, B.; Jazbutis, G.; Wang, C.Y.; Fulton, R.E. (1991) Modeling tools and methodologies for integrated manufacturing information systems, ASME-CIE, August

  9. IDEF—Modeling Course for Authors, Bernier and Associates, Inc.

  10. Gane, C. (1989) Rapid System Development using Structured Techniques and Relational Technologies, Prentice-Hall, Englewood Cliffs, NJ

    Google Scholar 

  11. Chen, P.P. (1976) The entity relationship model—toward a unified view of data. ACM Trans. Database Systems, 1, 1

    Google Scholar 

  12. Teory, T.J., et al. (1986) A logical design methodology for relational database using the extended entity-relationship model, Computing Survey, 18, 2 (June)

    Google Scholar 

  13. Date, C.J. (1983) An Introduction to Database Systems, Vol. I, Addison-Wesley, Reading, MA

    Google Scholar 

  14. Chadha, B.; Gourishankar, Y. (1991) Integration of information for facilities layout: integration of material management and machine foundation aspects, ASME-WAM, December

  15. Chadha, B.; Jazbutis, G.; Wang, C.Y.; Fulton, R.E. (1991) Software framework for integrated material handling in a plant, MHRC, Fall Monitors Meeting, November

Download references

Author information

Authors and Affiliations

  1. School of Mechanical Engineering and Material Handling Research Center, Georgia Institute of Technology, GA 30332, Atlanta, Georgia, USA

    Bipin Chadha & R. E. Fulton

  2. AT & T, Atlanta Works, Norcross, Georgia, USA

    J. C. Calhoun

Authors
  1. Bipin Chadha
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. R. E. Fulton
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. J. C. Calhoun
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Chadha, B., Fulton, R.E. & Calhoun, J.C. Design and implementation of a CIM information system. Engineering with Computers 10, 1–11 (1994). https://doi.org/10.1007/BF01206535

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF01206535

Keywords

Search

Navigation