Database issues for a veterinary medical expert system

  • Mary McLeish
  • Matthew Cecile
  • Alex Lopez-Suarez
Contributed Papers
Part of the Lecture Notes in Computer Science book series (LNCS, volume 339)


A large project to build an expert system for veterinary medicine was recently begun at the University of Guelph in collaboration with the Ontario Veterinary College. The hospital data-base system has been collecting on-line medical data for almost ten years. The prototype being developed is comparing several knowledge acquisition techniques from data which limit the number of rules used for diagnosis. Along with this approach, a fuzzy relational system involving all test results is being implemented. This paper shows how a combination of INGRES and the ‘C’ programming language can be used as a knowledge base to support these different methodologies.


Membership Function Relational Database Composition Operator Fuzzy Subset Symptom Group 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Adlassnig, K. P., "Fuzzy Set Theory in Medical Diagnosis", IEEE Transactions on Systems, Man and Cybernetics, vol 16, 1986, pp. 260–265.Google Scholar
  2. 2.
    Adlassnig, K. P., "A Survey on Medical Diagnosis and Fuzzy Subsets", Approximate Reasoning in Decision Analysis, North Holland Press, 1982, pp. 203–217.Google Scholar
  3. 3.
    Anvari, M. and Rose, G. F., "Fuzzy Relational Databases", Proceedings of the First International Conference on Fuzzy Information Processing", Kuaui, Hawaii, 1984, B-6-3.Google Scholar
  4. 4.
    Buchanan, B. and Shortliffe, E., "Rule-Based Expert Systems: The MYCIN Experiments of the Stanford Heuristic Programming Project", Addison-Wesley, 1986.Google Scholar
  5. 5.
    Buckles, B. P. and Petry, F. E., "A Fuzzy Representation for Relational Databases", Fuzzy Sets and Systems 7, (1982), pp. 213–226.Google Scholar
  6. 6.
    Chiu, D. K. Y. and Wong, A. K. C., "Synthesizing Knowledge: A Cluster Analysis Approach Using Event-Covering", IEEE Transactions on Systems, Man and Cybernetics, vol. SMC-16, no. 2, March/April 1986, pp. 251–259.Google Scholar
  7. 7.
    Date, C. J., "An Introduction to Database Systems", Addison-Wesley, 1987.Google Scholar
  8. 8.
    Date, C. J., "A Guide to Ingres", Addison-Wesley, 1987.Google Scholar
  9. 9.
    Dubois, D. and Prade, H., "Fuzzy Sets and Systems: Theory and Applications", Academic Press, 1980.Google Scholar
  10. 10.
    Ducharme, N., Pascoe, P. J., Ducharme, G. and Lumsden, T., "A Computer-Derived Protocol to Aid in Deciding Medical or Surgical Treatment of Horses with Abdominal Pain", private communication.Google Scholar
  11. 11.
    Ducharme, N., Ducharme G., Pascoe, P. J. and Horney, F. D., "Positive Predictive Value of Clinical Explanation in Selecting Medical or Surgical Treatment of Horses with Abdominal Pain", Proc. Eq. Colic. Res., pp. 200–230, 1986.Google Scholar
  12. 12.
    Grundy, "Cluster-Analysis–A Series of Database Views", Proceedings of the Third International Workshop on Statistical and Scientific Database Management, July, 1986, pp. 208–211.Google Scholar
  13. 13.
    Held, J. and Carlis, J., "Match: A New High-Level Relational Operator for Pattern Matching", Comm. ACM, 30, 1(January 1987), pp. 62–75.Google Scholar
  14. 14.
    Kandel, A., "Fuzzy Mathematical Techniques with Applications", Addison-Wesley, 1986.Google Scholar
  15. 15.
    Kung, R., Hanson, E., Lonnidis, Y., Sellis, T., Shapiro, L. and Stonebraker, M., "Heuristic Search in Database Systems", In Expert Database Systems, edited by Kerschberg, L., Addison-Wesley, 1987.Google Scholar
  16. 16.
    Kung, R., "A Database Management System Base on an Object-Oriented Model", In Expert Database Systems, edited by Kerschberg, L., Addison-Wesley, 1987.Google Scholar
  17. 17.
    Lewis J. W., "B-Fuzzy Sets", submitted to Uncertainty in Artificial Intelligence, edited by Tod Levitt, North Holland Press.Google Scholar
  18. 18.
    McLeish, M., Cecile, M., "Induction and Uncertainty Management Techniques Applied to Veterinary Medical Diagnoses", submitted to AAAI Uncertainty Management Workshop, August 1988.Google Scholar
  19. 19.
    McLeish, M., "Exploring Knowledge Aquisition Tools for a Veterinary Medical Expert System", First International Conference on A.I. and Expert Systems, IEA/AIE-88.Google Scholar
  20. 20.
    Nau, D. and Reggia, J., "Relationship Between Deductive and Abductive Inference in Knowledge-Based Diagnostic Problem Solving", In Expert Database Systems, edited by Kerschberg, L., Addison-Wesley, 1987.Google Scholar
  21. 21.
    Quinlan, U. Ross, "Learning Efficient Classification Procedures and Their Application to Chess End Games", 1983, In Machine Learning: An Artificial Intelligence Approach, edited by Ryszard Michalski, Tioga, pp. 463–482.Google Scholar
  22. 22.
    Raju, K. and Majumdar A., "Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems", accepted for publication in ACMTODS.Google Scholar
  23. 23.
    Rendell, L., "A General Framework for Induction and a Study of Selective Induction", Machine Learning, Kluwar Pub., 1986, vol. 1, pp. 177–226.Google Scholar
  24. 24.
    Snodgrass, R. and Ilsoo, A., "Temporal Databases", IEEE Computer 19(9), September 1986, pp. 35–42.Google Scholar
  25. 25.
    Stonebraker, M., Woodfill, J. and Anderson, E., "Implementation of Rules in Relational Database Systems", Database Engineering, 6,4(December 1983).Google Scholar
  26. 26.
    Stonebraker, M. (Editor), "The Ingres Papers: Anatomy of a Relational Database System", Addison-Wesley, 1986.Google Scholar
  27. 27.
    Weiderhold, G., Blum, R. L. and Walker, M., "An Integration of Knowledge and Data Representation", in On Knowledge Base Management Systems, edited by Brodie, M. L. and Mylopoulos, J., Springer-Verlag, 1986.Google Scholar
  28. 28.
    Yager, R.R., "A Note on Probabilities of Fuzzy Events", Information Sciences 18, 1979, pp. 113–129Google Scholar
  29. 29.
    Zadeh, L. A., "Fuzzy Logic and Approximate Reasoning", Synthese 30, (1975), pp. 407–428.Google Scholar
  30. 30.
    Zvieli, A. and Chen, P. P., "Entity-relationship Modeling and Fuzzy Databases", Proceedings of the Second International Conference on Data Engineering, Los Angeles, California, 1986, pp. 320–327.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • Mary McLeish
    • 1
  • Matthew Cecile
    • 1
  • Alex Lopez-Suarez
    • 1
  1. 1.Department of Computing and Information ScienceUniversity of GuelphGuelphCanada

Personalised recommendations