SQLf: a relational database language for fuzzy querying

Bosc, Patrick; Pivert, Olivier

doi:10.1109/91.366566

Cited by 434 publications

(178 citation statements)

References 26 publications

Supporting

Mentioning

171

Contrasting

Unclassified

Order By: Relevance

“…As future work, we aim at integrating of these forms of division operation into the bipolar SQLf language, which is an extension of the SQLf language [3,2] to fuzzy bipolar conditions.…”

Section: Resultsmentioning

confidence: 99%

Bipolarity and the relational division

Tamani¹,

Liétard²,

Rocacher³

2011

Proceedings of the 7th Conference of the European Society for Fuzzy Logic and Technology (EUSFLAT-2011)

View full text Add to dashboard Cite

A fuzzy bipolar relation is a relation defined by a fuzzy bipolar condition, which could be interpreted as an association of a constraint and a wish. In this context, the extension of the relational division operation to bipolarity is studied in this paper. Firstly, we define a bipolar division when the involved relations are crisp. Then, we define, from the semantic point of view, several forms of bipolar division when the involved relations are defined by fuzzy bipolar conditions. These forms of division can be related to the general model of fuzzy bipolar division introduced in [4,5].

show abstract

“…As future work, we aim at integrating of these forms of division operation into the bipolar SQLf language, which is an extension of the SQLf language [3,2] to fuzzy bipolar conditions.…”

Section: Resultsmentioning

confidence: 99%

Bipolarity and the relational division

Tamani¹,

Liétard²,

Rocacher³

2011

Proceedings of the 7th Conference of the European Society for Fuzzy Logic and Technology (EUSFLAT-2011)

View full text Add to dashboard Cite

show abstract

“…Researchers have been working extensively on developing algorithms that can handle this task. Moreover, many approaches have been proposed to include fuzziness in SQL, e.g., [32,4,8,39,6,9]. The work described in this thesis focuses on translating users' requests into valid SQL queries, regardless whether the requests are fuzzy or not.…”

Section: Related Workmentioning

confidence: 99%

Integrating flexibility and fuzziness into a question driven query model

Sarhan

Rokne

Alhajj

2018

Information Sciences

View full text Add to dashboard Cite

Data plays an important role in our daily life. Thus, data collection, storage, maintenance and processing continue to attract considerable attention. Data may exist in various formats, ranging from unstructured to structured as the two extremes. Traditionally, researchers and practitioners cooperated and developed various data models which form the main foundation for existing database management systems. The relational data model is still dominating despite the rapid development in the techniques used for data collection, storage and processing. Further, a relational database management system supports a structured query language (SQL) for data processing, and it is not possible to access and retrieve data from a relational database without knowing how to use SQL. However, the wide usage of relational databases motivated researchers to develop more user friendly interfaces which would allow a larger population of users to access relational databases. Such interfaces range from visual to natural language based. This thesis contributes a question driven query model which falls under the natural language based category. The target is to make databases reachable by a larger population, especially after the Internet increased database availability. The proposed model supports fuzziness where every user is given the freedom to define his/her own understanding of fuzzy terms. The developed system absorbs the fuzzy understanding of each user to utilize it while deciding on the result to be communicated back as answer to the raised question. Data mining techniques are employed to guide users in defining their fuzzy understanding. The developed model is intended to help users to retrieve the data they want from a relational database without expecting them to know SQL. In the current version only questions written in English are allowed. The system handles different types of questions, such as (1) simple questions, (2) complex questions with inner joins and where conditions, (3) questions that involves the usage of aggregate functions (e.g., min, max, etc.), and (4) questions with fuzzy i terms. The reported test results demonstrate the effectiveness of the developed system in handling various types of questions raised by a heterogeneous set of users ranging from professionals to naive.

show abstract

“…To support fuzzy queries, a language called SQLf is proposed in 16 . The general principle consists in introducing gradual predicates wherever it makes sense.…”

Section: Fuzzy Queriesmentioning

confidence: 99%

A Fuzzy-Rule-Based Model for Handling Contextual Preference Queries

Hadjali¹,

Mokhtari²,

Pivert³

2012

IJCIS

View full text Add to dashboard Cite

Users' preferences have traditionally been exploited in query personalization to better serve their information needs. Most of the time, user preferences depend on context, that is, they may have different values depending on the situation of the user. In this paper, we propose a fuzzy-rule-based model for the representation of contextual preferences in a database querying framework. We discuss the augmentation of a query with preferences deduced from information regarding the current context of the user. To this end, we make use of an appropriate inference pattern, called generalized modus ponens, able to deal with data and knowledge when they are described in a fuzzy way.

show abstract

SQLf: a relational database language for fuzzy querying

Cited by 434 publications

References 26 publications

Bipolarity and the relational division

Bipolarity and the relational division

Integrating flexibility and fuzziness into a question driven query model

A Fuzzy-Rule-Based Model for Handling Contextual Preference Queries

Contact Info

Product

Resources

About