Fuzzy Analytical Queries: A New Approach to Flexible Fuzzy Queries
Sławomir Zadrożny, Janusz Kacprzyk · 2020
A new approach to the use of fuzzy terms in analytic functions which constitute a standard part of the SQL syntax is proposed. The motivation is that though extensions of the SQL queries including linguistic (fuzzy) terms have been widely used as they have made it possible to better and more directly represent complex requirements of a human user searching a relational database, notably for generating linguistic summaries, there has been little attention paid so far to the use of analytic functions in this context. Analytic functions can provide for an attractive way of analysing data in a relational database and may be possibly adopted as a tool to generate even more sophisticated linguistic summaries. In this paper we study a basic structure of standard (crisp) analytic functions use and point out some opportunities to extend it using linguistic terms. A starting point for our discussion is the mechanism of grouping rows in SQL as it is one of the most important components of the application of analytic functions.