Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Donner, M. and Roth-Berghofer, T.,: “Architectures for Integrating CBR-systems with Databases for E-commerce”, Proceedings of the 7th German Workshop on Case-Based Reasoning, GWCBR’ 99
Kitano, H. and Shimazu, H.,: “The Experience Sharing Architecture: A Case Study in Corporate-Wide Case-Based Software Quality Control”, Case-Based Reasoning: Experiences, Lessons and Future Directions, Leake, D.B. (Ed), AAAI Press
Watson, I. and Gardingen, D.,: A Distributed Case-Based Reasoning Application for Engineering Sales Support, Proceedings 16th International Conference on Artificial Intelligence (IJCAI-99), Vol. 1: pp. 600–605.
Hayes, C., Doyle, M., Cunningham, P.,: Distributed CBR Using XML, Internal Report Trinity College Dublin, (1998), TCD—CS-1998-06.
Schumacher, J. and Bergmann, R.,: “An Efficient Approach to Similarity-Based Retrieval on Top of Relational Databases”, 5th European Workshop on Case-Based Reasoning, 2000
Ventura, D and Martinez, T. R.,: “An Empirical Comparison of Discretization Methods”, Proceedings of the Tenth International Symposium on Computer and Information Science, 1995
Watson, I.,: Applying Case-Based Reasoning: Techniques for Enterprise Systems, Morgan Kaufmann, (1997) p182
SQLyog v2.51, MySQL front end, downloaded from http://www.webyog.com/
West, G. M, Strachan, S. M., Moyes, A., McDonald, J. R., Gwyn, B., Farrell, J.,: Knowledge management and decision support for electrical power utilities, Knowledge and Process Management, Volume 8, Issue 4, (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
West, G.M., McDonald, J.R. (2003). An SQL-Based Approach to Similarity Assessment within a Relational Database. In: Ashley, K.D., Bridge, D.G. (eds) Case-Based Reasoning Research and Development. ICCBR 2003. Lecture Notes in Computer Science(), vol 2689. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45006-8_46
Download citation
DOI: https://doi.org/10.1007/3-540-45006-8_46
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40433-0
Online ISBN: 978-3-540-45006-1
eBook Packages: Springer Book Archive