Some algorithms for evaluating fuzzy relational queries
An important issue in extending DBMS functionnalities is to allow the expression and execution of flexible queries in order to make these systems able to satisfy user needs more closely. To deal with this problem it is necessary to define new evaluation methods since standard (crisp) algorithms and access paths have proved to be inappropriate. A challenge in solving this problem is to keep the additional costs entailed by these new querying capabilities at a reasonable level. For this purpose we propose a set of query evaluation algorithms based on techniques expected on the one hand to restrict the amount of tuples to be transferred from disk to main memory and on the other hand to limit the computations which apply to these tuples. This work only concerns the evaluation of basic extended relational operators and may be seen as a first step towards the design of a fuzzy query optimizor. For each of the proposed methods, we suggest some useful measures for determining to what extent the corresponding algorithms are acceptable. Finally, we present an experimental framework for measuring the performance of these algorithms.
KeywordsDBMS imprecise queries query processing
Unable to display preview. Download preview PDF.
- Bitton D., Dewitt D.J., Turbyfill C. (1983) Benchmarking database systems: a systematic approach, Proc. VLDB Conference, pp 8–19.Google Scholar
- Blasgen M.W., Eswaran K.P. (1976) On the evaluation of queries in a relational database system, IBM Systems Journal, vol 16, pp 363–377.Google Scholar
- Bosc P., Galibourg M. (1988a) Flexible selection among objects: a framework based on fuzzy sets, Proc. SIGIR Conference, pp 433–449.Google Scholar
- Bosc P, Pivert O. (1989) Algorithms for flexible selection in relational databases, Proc 10th ASLIB Conference (G-B), pp 211–226.Google Scholar
- Bosc P., Pivert O. (1991) Fuzzy querying in conventional databases, to appear in "Fuzzy logic for the management of uncertainty" (L. Zadeh & J. Kacprzyk eds).Google Scholar
- Dubois D., Prade H. (1982) A unifying view of comparison indices in a fuzzy set theoritic framework, in "Fuzzy set and possibility theory" (R. Yager ed.).Google Scholar
- Radecki T. (1982) Generalized boolean methods of information retrieval, International Journal of Man-Machine Studies, vol 18.Google Scholar
- Selinger P.G. et al. (1979) Access path selection in a relational database management system, Proc. of ACM SIGMOD Conference, pp 23–34.Google Scholar
- Tahani V. (1976) A fuzzy model of document retrieval systems, Information Processing & Management, vol 12, pp 177–187.Google Scholar