Sept. 4, 2006 to Sept. 8, 2006
N. Hachani , Faculty of Sciences of Bizerte, Tunisia
H. Ounelli , Faculty of Sciences of Tunis, Tunisia
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/DEXA.2006.10
People have often insufficient knowledge about database structure and contents, thus frequently obtaining empty answers or having to reformulate the queries several times. This paper describes an approach extending the search criteria ranges in order to provide approximate answers to the user. This approach takes into account the user preferences. It is based on a knowledge base (KB) related to the application domain. The initial SQL query is transformed into a flexible query based on KB and fuzzy set theory. This flexible query is then rewritten into a boolean query called envelope. The envelope is evaluated with a traditional DBMS to take advantage of its full optimization capabilities. The tuples satisfying the envelope are finally ranked according to their satisfaction degree. Unlike other approaches, this one require to modify neither SQL language nor the database engine.
N. Hachani, H. Ounelli, "A Knowledge-Based Approach For Database Flexible Querying", DEXA, 2006, 2012 23rd International Workshop on Database and Expert Systems Applications, 2012 23rd International Workshop on Database and Expert Systems Applications 2006, pp. 420-424, doi:10.1109/DEXA.2006.10