Abstract
This paper describes a software tool called MUKCA (Multi-User Knowledge Capture Administrator). This tool incorporates case-based reasoning for supporting the reuse of past SQL queries. The tool has been targeted at users in the marketing domain. This domain is characterised by very large databases containing many Gigabytes of customer related information. Large systems such as these require careful management of the queries being submitted to optimise the use of processing and storage resources. The CBR approach encourages consistent and best practices, supports training of novice users and dampens the effect of employee turnover. An early prototype has been built and is currently being used for experimental purposes.
Preview
Unable to display preview. Download preview PDF.
References
Aamodt, A., Plaza, E.: Case-Based Reasoning: Foundational Issues, methodological Variations, and System Approaches. AI Communications 7(1), 39–52, 1994
Leake, D.: Case-Based Reasoning: Experiences, Lessons, & Future Directions. AAAI Press, ISBN 0-262-62110-X LEACP, 1997
Schank, R. C., Abelson, R.: Scripts, Plans, Goals and Understanding: An Inquiry into Human Knowledge Structures. Hillsdale, N.J.: Lawrence Erlbaum, 1977
Fouque, G., Chu, W., Yau, H.: A case-based reasoning approach for associative query answering. Proceedings of the 8th International Symposium on Methodologies for Intelligent Systems (ISMIS94). Charlotte, NC, USA, 183–192, 1994
Brightware Inc. http://www.brightware.com/www_home.html
Brightware Inc.: ARTScript Programming Guide 3, Rules & CBR, 1996
Liu, L., Pu, C.: A Metadata Based Approach to Improving Query Responsiveness. http://computer.org/conferen/proceed/meta97/papers/lliu/lingliu-full.html, 1997
Kitano, H., Shimazo, H.: The Experience-Sharing Architecture: A Case Study in Corporate-Wide Case-Based Software Quality Control, pp 235–268, in [1]
Ould-Brahim, H., Matwin, S.: Reusing Database Queries in Analogical Domains IEEE, April 1992
Raghavan, V. V., Sever, H.: On the reuse of past optimal queries. 18th Int. ACM SIGIR Conf. on Research and Development in Information Retrieval, 9–13 July, special issue, 344–50, 1995
Duda, R.O., Hart, P.E.: Pattern Classification and Scene Analysis. John Wiley and Sons, 1973
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Fagan, M., Corley, S. (1998). CBR for the reuse of corporate SQL knowledge. In: Smyth, B., Cunningham, P. (eds) Advances in Case-Based Reasoning. EWCBR 1998. Lecture Notes in Computer Science, vol 1488. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0056349
Download citation
DOI: https://doi.org/10.1007/BFb0056349
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64990-8
Online ISBN: 978-3-540-49797-4
eBook Packages: Springer Book Archive