Evaluation of Indexing Strategies for Possibilistic Queries Based on Indexing Techniques Available in Traditional RDBMS

A common way to implement a fuzzy database is on top of a classical relational database management systems (RDBMS). Given that almost all RDBMS provide indexing mechanisms to enhance classical query processing performance, finding ways to use these mechanisms to enhance the performance of flexible query processing is of enormous interest. This work proposes and evaluates a set of indexing strategies, implemented exclusively on top of classical RDBMS indexing structures, designed to improve flexible query processing performance, focusing in the case of possibilities queries. Results show the best indexing strategies for different data a query scenarios, offering effective ways to implement fuzzy data indexes on top of a classical RDBMS.

[1]  Rita De Caluwe Fuzzy And Uncertain Object-Oriented Databases: Concepts And Models , 1997 .

[2]  Claudia Testemale,et al.  Fuzzy relational databases - a key to expert systems , 1986, J. Am. Soc. Inf. Sci..

[3]  J. Kacprzyk,et al.  Fquery for Access: Fuzzy Querying for a Windows-Based DBMS , 1995 .

[4]  Troels Andreasen,et al.  Flexible Query Answering Systems , 2017, Lecture Notes in Computer Science.

[5]  Juan Miguel Medina,et al.  A B+-tree based indexing technique for fuzzy numerical data , 2008, Fuzzy Sets Syst..

[6]  Hans-Peter Kriegel,et al.  Managing Intervals Efficiently in Object-Relational Databases , 2000, VLDB.

[7]  Abraham Kandel,et al.  Fuzzy relational data bases : a key to expert systems , 1984 .

[8]  Jing Wu,et al.  Performance evaluation of G-tree and its application in fuzzy databases , 1996, CIKM '96.

[9]  M. Gupta,et al.  FUZZY INFORMATION AND DECISION PROCESSES , 1981 .

[10]  Patrick Bosc,et al.  Indexing principles for a fuzzy data base , 1989, Inf. Syst..

[11]  Sven Helmer,et al.  An impact ordering approach for indexing fuzzy sets , 2012, Fuzzy Sets Syst..

[12]  Juan Miguel Medina,et al.  Indexing Fuzzy numerical Data with a B+ Tree for Fast Retrieval Using Necessity-Measured Flexible conditions , 2009, Int. J. Uncertain. Fuzziness Knowl. Based Syst..

[13]  Patrick Bosc,et al.  SQLf: a relational database language for fuzzy querying , 1995, IEEE Trans. Fuzzy Syst..

[14]  Motohide Umano,et al.  FREEDOM-0: A FUZZY DATABASE SYSTEM , 1993 .

[15]  Adnan Yazici,et al.  FOOD Index: A Multidimensional Index Structure for Similarity-Based Fuzzy Object Oriented Database Models , 2008, IEEE Transactions on Fuzzy Systems.

[16]  H. Edelsbrunner A new approach to rectangle intersections part I , 1983 .

[17]  Henri Prade,et al.  Generalizing Database Relational Algebra for the Treatment of Incomplete/Uncertain Information and Vague Queries , 1984, Inf. Sci..

[18]  Juan Miguel Medina,et al.  Towards a Fuzzy Object-Relational Database Model , 2008, Handbook of Research on Fuzzy Information Processing in Databases.

[19]  H. Edelsbrunner A new approach to rectangle intersections , 2010 .

[20]  Olga Pons,et al.  GEFRED: A Generalized Model of Fuzzy Relational Databases , 1994, Inf. Sci..

[21]  Olga Pons,et al.  A Server for Fuzzy SQL Queries , 1998, FQAS.