Skip to main content
Article
Integration of a group technology classification and coding system with an engineering database
Journal of Manufacturing Systems
  • Richard E. Billo, Missouri University of Science and Technology
  • Rob Rucker
  • Dan L. Shunk
Abstract

Five tools that apply group technology concepts to an engineering database were investigated and compared. The purpose of the investigation was to select the tools with the best ranking in the areas of cost, flexibility, and ease of use. These tools were applied to engineering data from an aircraft structural composites classification and coding schema. The tools include (1) a vendor supplied GT software package, (2) a GT classification schema mapped onto a relational database, (3) a GT classification and coding schema mapped onto a relational database, (4) a vendor supplied GT software package interfaced with a relational database, and (5) a custom developed GT package which directly accesses a relational database. It was concluded from a comparison of five GT design tools that the custom developed GT package was the most advantageous design tool based on evaluation factors which included cost, flexibility, and user-friendliness. © 1987.

Department(s)
Mechanical and Aerospace Engineering
Keywords and Phrases
  • Engineering Database,
  • Group Technology,
  • Integration,
  • Relational Database
Document Type
Article - Journal
Document Version
Citation
File Type
text
Language(s)
English
Rights
© 2023 Elsevier, All rights reserved.
Publication Date
1-1-1987
Publication Date
01 Jan 1987
Citation Information
Richard E. Billo, Rob Rucker and Dan L. Shunk. "Integration of a group technology classification and coding system with an engineering database" Journal of Manufacturing Systems Vol. 6 Iss. 1 (1987) p. 37 - 45 ISSN: 0278-6125
Available at: http://works.bepress.com/richard-billo/33/