Abstract
This paper presents an approach to realize a case retrieval engine on top of a relational database. In a nutshell the core idea is to approximate a similarity-based retrieval with SQL-queries. The approach avoids duplicating the case data or compiling index structures and is therefore ideal for huge case bases which are often subject to changes. The presented approach is fully implemented as part of the commercial CBR toolbox orenge and the experimental evaluation demonstrates impressive retrieval behaviour.
This is a preview of subscription content, log in via an institution to check access.
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
S. Berchtold, B. Ertl, D. A. Keim, H.-P. Kriegel, and T. Seidl. Fast nearest neighbor search in high-dimensional space. In Proc. 14th Int. Conf. on Data Engineering (ICDE’98), pages 209–218, 1998.
S. Berchtold, D. A. Keim, and H.-P. Kriegel. The x-tree: An index structure for high-dimensional data. In Proc. 22nd Int. Conf. on Very Large Data Bases, pages 28–39, 1996.
R. Bergmann, S. Breen, M. Göker, M. Manago, and S. Wess. Developing Industrial Case-Based Reasoning Applications: The INRECA Methodology. Lecture Notes in Artificial Intelligence, State-of-the-Art-Survey, LNAI 1612. Springer Verlag, 1999.
M. Donner and T. Roth-Berghofer. Architectures for integration CBR-systems with databases for e-commerce. In 7th German Workshop on Case Based Reasoning (GWCBR’99), 1999.
H. Schimazu, H. Kitano, and A. Shibata. Retrieving cases from relational databases: Another strike toward coporate-wide case-based systems. In Proceedings of the 13th International Joint Conference in Artificial Intelligence (IJCAI’93), 1993.
S. Schmitt and R. Bergmann. Applying case-based reasoning technology for product selection and customization in electronic commerce environments. In 12th Bled Electronic Commerce Conference., 1999.
T. Seidl and H.-P. Kriegel. Optimal multi-step k-nearest neighbor search. In Proc. ACM SIGMOD Int. Conf. on Management of Data, pages 154–165, 1998.
W. Wilke. Knowledge Management for Intelligent Sales Support in Electronic Commerce. DISKI 213. Infix Verlag, 1999.
W. Wilke, M. Lenz, and S. Wess. Intelligent sales support with CBR. In M. Lenz, B. Bartsch-Spörl, H.-D. Burkhard, and S. Wess, editors, Case-Based Reasoning Technology: From Foundations to Applications, pages 91–113. Springer Verlag, 1998.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Schumacher, J., Bergmann, R. (2000). An Efficient Approach to Similarity-Based Retrieval on Top of Relational Databases. In: Blanzieri, E., Portinale, L. (eds) Advances in Case-Based Reasoning. EWCBR 2000. Lecture Notes in Computer Science, vol 1898. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44527-7_24
Download citation
DOI: https://doi.org/10.1007/3-540-44527-7_24
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67933-2
Online ISBN: 978-3-540-44527-2
eBook Packages: Springer Book Archive