Organizing principles for the design of classification and coding software

Abstract This paper describes several organizing principles useful in designing classification and coding (C&C) software in a relational database management system (DBMS) environment. Specifically, these software design principles include the usage of Operational Constructors, Meta Models, Dynamic Binding, and Associative Naming to aid the design of full-purpose classification and coding software that can take as input a classification model of part families. These principles aid the software development effort in the following ways. Operational Constructors are universal programming concepts that allow the programmer to take advantage of the graphical user interface (GUI) features of the DBMS, such as list boxes, scroll boxes, subforms, and the like. Meta models represent the structure of the classification model. By implementing any classification model as a meta model, it can easily be instantiated into the software without the need for custom development. Dynamic Binding provides a general mechanism to query the database for part information by dynamically stitching user selections to a general structured query language (SQL) query. Finally, Associative Naming allows the user to retrieve data in a general manner through an innovative table-naming scheme and traversal process. A case study is presented showing application of these principles in support of a C&C system for a purchasing application used for procurement of raw materials, electronic components, and consumable supplies.

[1]  Diane C. P. Smith,et al.  Database abstractions: aggregation , 1977, CACM.

[2]  John L. Burbidge,et al.  The introduction of group technology , 1975 .

[3]  John McAuley,et al.  Machine grouping for efficient production , 1972 .

[4]  C. H. Cheng,et al.  Algorithms for grouping machine groups in group technology , 1992 .

[5]  Andrew Kusiak,et al.  Group technology , 1987 .

[6]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[7]  D. A. Milner,et al.  Direct clustering algorithm for group formation in cellular manufacture , 1982 .

[8]  John L. Burbidge,et al.  Production flow analysis for planning group technology , 1991 .

[9]  Dan L. Shunk,et al.  Integration of a group technology classification and coding system with an engineering database , 1987 .

[10]  Asoo J. Vakharia,et al.  Methods of Cell Formation in Group Technology: A Framework for Evaluation , 1986 .

[11]  James MacGregor Apple.  Plant Layout and Materials Handling , 1977 .

[12]  Dan L. Shunk,et al.  Enhancing group technology modeling with database abstractions , 1988 .

[13]  Andrew Kusiak.  Intelligent Design and Manufacturing , 1992 .

[14]  Sunderesh S. Heragu,et al.  Group Technology and Cellular Manufacturing , 1994, IEEE Trans. Syst. Man Cybern. Syst..

[15]  Diane C. P. Smith,et al.  Database abstractions: aggregation and generalization , 1977, TODS.

[16]  Michael L. Brodie.  On conceptual modelling - perspectives from artificial intelligence, databases and programming languages , 1984, Topics in information systems.

[17]  Nancy Lea Hyer,et al.  Cellular manufacturing in the U.S. industry: a survey of users , 1989 .

[18]  Bopaya Bidanda,et al.  Representing group technology classification and coding techniques with object oriented modeling principles , 1995 .

[19]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.