Fuzzy querying with SQL: Extensions and implementation aspects

DOI10.1016/0165-0114(88)90039-5MaRDI QIDQ1114452zbMATH OpenOpenAlexFDO

Authors S. H. Smith

Publication date 1988

Published in Fuzzy Sets and Systems (Search for Journal in Brave)

Full work available at URL https://doi.org/10.1016/0165-0114(88)90039-5

zbMATH Keywords

filtering mechanismsfuzzy conditionsfuzzy queriesindexingnon-Boolean queriesquery processingrelational databaseSQL query language

Mathematics Subject Classification ID

Information storage and retrieval of data (68P20)

Review text

All the database management systems (DBMS) commercially available provide querying capabilities that are based on Boolean selection. Consequently, it is possible to express conditions applying to individual tuples or sets of tuples. However, this characteristic turns out to be a severe limitation when some types of applications are under consideration. Especially, we have been led to deal with an application, called HAVANE, that gave rise to two main constraints: the number of answers has to be controlled and some parts of queries are not Boolean conditions. So, we turn towards an extension of DBMS querying capabilities in order to allow fuzzy queries against a usual database, i.e., composed of precise facts. Thus an extension of the well known language SQL is presented along with some considerations about how such fuzzy queries can be processed to get acceptable performances.

Recommendations

• Fuzzy improvement of the SQL
• Fuzzy improvement of SQL
• Some issues of fuzzy querying in relational databases.
• scientific article; zbMATH DE number 1107531
• scientific article; zbMATH DE number 1487591

Cites work

• A conceptual framework for fuzzy query processing - a step toward very intelligent database systems
• A relational model of data for large shared data banks
• Fuzzy sets as a basis for a theory of possibility
• Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries
• scientific article; zbMATH DE number 3890769 (Why is no real title available?)
• scientific article; zbMATH DE number 3900196 (Why is no real title available?)
• scientific article; zbMATH DE number 3905875 (Why is no real title available?)
• scientific article; zbMATH DE number 3963224 (Why is no real title available?)
• scientific article; zbMATH DE number 3473265 (Why is no real title available?)
• SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control

Cited in

(16)

• Finding fuzzy and gradual functional dependencies with Summary SQL
• Evaluating flexible criteria on uncertain data
• Towards the implementation of a generalized fuzzy relational database model
• Fuzzy improvement of the SQL
• Formalising PFSQL queries using Ł\( \Pi \frac 12\) fuzzy logic
• Fuzzy improvement of SQL
• scientific article; zbMATH DE number 1735864 (Why is no real title available?)
• scientific article; zbMATH DE number 1107534 (Why is no real title available?)
• A natural language user interface for fuzzy scope queries
• scientific article; zbMATH DE number 1487591 (Why is no real title available?)
• A NEW METHOD FOR FUZZY QUERY PROCESSING IN RELATIONAL DATABASE SYSTEMS
• Data grouping process in extended SQL language containing fuzzy elements
• Mining time series data by a fuzzy linguistic summary system
• Computing with words in intelligent database querying: Standalone and internet-based applications
• Flexible queries in relational databases -- The example of the division operator
• Measuring properties of fuzzy sets: A general technique and its use in fuzzy query evaluation

This page was built for publication: Fuzzy querying with SQL: Extensions and implementation aspects

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q1114452)