Integration of a group technology classification and coding system with an engineering database

Richard E. Billo, Rob Rucker, Dan Shunk

Research output: Contribution to journalArticle

14 Citations (Scopus)

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.

Original languageEnglish (US)
Pages (from-to)37-45
Number of pages9
JournalJournal of Manufacturing Systems
Volume6
Issue number1
DOIs
StatePublished - 1987

Fingerprint

Group technology
Software packages
Data base
Costs
Aircraft
Relational database
Composite materials

Keywords

  • Engineering Database
  • Group Technology
  • Integration
  • Relational Database

ASJC Scopus subject areas

  • Management Science and Operations Research
  • Industrial and Manufacturing Engineering

Cite this

Integration of a group technology classification and coding system with an engineering database. / Billo, Richard E.; Rucker, Rob; Shunk, Dan.

In: Journal of Manufacturing Systems, Vol. 6, No. 1, 1987, p. 37-45.

Research output: Contribution to journalArticle

Billo, Richard E. ; Rucker, Rob ; Shunk, Dan. / Integration of a group technology classification and coding system with an engineering database. In: Journal of Manufacturing Systems. 1987 ; Vol. 6, No. 1. pp. 37-45.
@article{851a9db8c68e45679c7e49b6edb2eb8e,
title = "Integration of a group technology classification and coding system with an engineering database",
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.",
keywords = "Engineering Database, Group Technology, Integration, Relational Database",
author = "Billo, {Richard E.} and Rob Rucker and Dan Shunk",
year = "1987",
doi = "10.1016/0278-6125(87)90048-3",
language = "English (US)",
volume = "6",
pages = "37--45",
journal = "Journal of Manufacturing Systems",
issn = "0278-6125",
publisher = "Elsevier",
number = "1",

}

TY - JOUR

T1 - Integration of a group technology classification and coding system with an engineering database

AU - Billo, Richard E.

AU - Rucker, Rob

AU - Shunk, Dan

PY - 1987

Y1 - 1987

N2 - 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.

AB - 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.

KW - Engineering Database

KW - Group Technology

KW - Integration

KW - Relational Database

UR - http://www.scopus.com/inward/record.url?scp=0023168267&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0023168267&partnerID=8YFLogxK

U2 - 10.1016/0278-6125(87)90048-3

DO - 10.1016/0278-6125(87)90048-3

M3 - Article

VL - 6

SP - 37

EP - 45

JO - Journal of Manufacturing Systems

JF - Journal of Manufacturing Systems

SN - 0278-6125

IS - 1

ER -