An SQL-based approach to similarity assessment within a relational database

Research output: Chapter in Book/Report/Conference proceedingConference contribution book

10 Citations (Scopus)


A common issue with case-based reasoning (CBR) systems, particularly those that are distributed over a network, is the time required to determine the closest match to the current case. Research has been carried out in this area to try to improve the situation by distributing some of the calculation to the client side thereby reducing the burden on the server. In CBR applications, the case library is stored in some format such as a relational database or flat files that the software interprets in order to perform similarity assessment between the current case and each case in the database. In this paper a novel approach is proposed where the retrieval of the case information and the calculation of the similarity values are performed in one action. This does not incur the same burden upon the server in terms of calculation, as all that is required is a larger database lookup via SQL. As the case base needs to be queried regardless of the CBR technique used to obtain the case information, it is proposed that a combined similarity assessment and case retrieval would provide a fast method of case retrieval.
Original languageEnglish
Title of host publicationCase-Based Reasoning Research and Development
EditorsKD Ashley, DG Bridge
Number of pages11
ISBN (Print)3540404333
Publication statusPublished - 2003
Event5th International Conference on Case-Bases Reasoning (ICCBR 2003) - Trondheim, Norway
Duration: 23 Jun 200326 Jun 2003

Publication series

ISSN (Print)0302-9743


Conference5th International Conference on Case-Bases Reasoning (ICCBR 2003)


  • computer science
  • artificial intelligence

Fingerprint Dive into the research topics of 'An SQL-based approach to similarity assessment within a relational database'. Together they form a unique fingerprint.

  • Cite this

    West, G., & Mcdonald, J. (2003). An SQL-based approach to similarity assessment within a relational database. In KD. Ashley, & DG. Bridge (Eds.), Case-Based Reasoning Research and Development (pp. 610-621 ). (LECTURE NOTES IN ARTIFICIAL INTELLIGENCE; Vol. 2689). Springer.