A procedure and underlying algorithm for extracting knowledge from production and inventory databases to support engineering management activities is described. The process searches for, detects and isolates behaviour patterns inherent in the data. It relates these patterns to production irregularities, suggests connections with specific causes and helps propose possible corrective or preventive actions. The approach is based on a four-phase procedure: (1) the decision-maker focuses on the subject or difficulty at issue, represented by a target concept; (2) the KEDB algorithm, based on a machine learning approach, processes the relevant database and provides knowledge characterizing and classifying the target concept; (3) the output is interpreted in Pareto fashion as a series of possible circumstances explaining the target concept behaviour; and (4) based on these causes, the decision-maker decides on possible corrective actions to improve the situation, or preventive actions to forestall unfavourable conditions. A case study based on an actual quality control database is detailed.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
Cai, Y., Cercone, N. and Han, J. (1989) Attribute-oriented induction in relational databases, in IJCAI-89 First Workshop on Knowledge Discovery in Databases, Piatetsky- Shapiro, G. and Frawley, W. (eds), Detroit, MI, pp. 26–36.
Clark, P. and Niblett, T. (1989) The CN2 induction algorithm. Machine Learning, 3(4), 261–283.
Dietterich, T. G. and Michalski, R. S. (1983) A comparative review of selected methods for learning from examples, in Machine Learning: An Artificial Intelligence Approach, Michalsky, R. S., Carbonell, J. G. and Mitchell, T. M. (eds), Tioga Publishing Company, Palo Alto, CA, 1, pp. 41–81.
Fournier, F. (1992) Knowledge extraction from databases, Unpublished M.Sc. Dissertation (Hebrew); Faculty of Industrial Engineering and Management, Technion, Israel.
Fournier, F. and Karni, R. (1992) Knowledge extraction from production data, in Seventh Israel Conference of Industrial Engineers, Haifa, Israel.
Frawley, W. J., Piatetsky-Shapiro, G. and Matheus, C. J. (1992) Knowledge discovery in databases: an overview, AI Magazine, 13(3), 57–70.
Gallaire, H., Minker, J. and Nicolas, J. (1984) Logic and databases: deductive approach. Computing Surveys, 16(2), 153–181.
Han, J., Cai, Y. and Cercone, N. (1990) Discovery of quantitative rules from large databases, in Methodologies for Intelligent Systems, 5, Ras, Z. W. and Zemankova, M. (eds), North Holland, pp. 157–165.
Han, J., Cai, Y. and Cercone, N. (1991) Concept-based data classification in relational databases, in IJCAI-91 Second Workshop on Knowledge Discovery in Databases, Piatetsky-Shapiro, G. and Frawley, W. (eds), Anaheim, CA, pp. 77–94.
Kane, V. E. (1989) Defect Prevention: Use of Simple Statistical Tools, Marcel Dekker, pp. 344–380.
Michalski, R. S. (1983) A theory and methodology of inductive learning, in Machine Learning: An Artificial Intelligence Approach, 1, Michalsky, R. S., Carbonell, J. G. and Mitchell, T. M. (eds), Tioga Publishing Company, Palo Alto, CA, pp. 82–129.
Piatetsky-Shapiro, G. and Frawley, W. (1989) IJCAI-89 First Workshop on Knowledge Discovery in Databases, Anaheim, CA.
Piatetsky-Shapiro, G. and Frawley, W. (1991) IJCAI-91 Second Workshop on Knowledge Discovery in Databases, Anaheim, CA.
Quinlan, J. R. (1986) Induction of decision trees. Machine Learning, 1(1), 81–106.
Quinlan, J. R. (1987) Simplifying decision trees. International Journal of Man-Machine Studies, 27(3), 221–234.
Steiner, G. A. (1982) Management Policy and Strategy, Macmillan, New York, p. 10.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Karni, R., Fournier, F. Knowledge extraction for production management. J Intell Manuf 5, 165–176 (1994). https://doi.org/10.1007/BF00123921
Issue Date:
DOI: https://doi.org/10.1007/BF00123921