Flexible queries in relational databases - The example of the division operator

被引:34
作者
Bosc, P [1 ]
Dubois, D [1 ]
Pivert, O [1 ]
Prade, H [1 ]
机构
[1] UNIV TOULOUSE 3,IRIT,F-31062 TOULOUSE,FRANCE
关键词
D O I
10.1016/S0304-3975(96)00132-6
中图分类号
TP301 [理论、方法];
学科分类号
081202 [计算机软件与理论];
摘要
Allowing for flexible queries enables database users to express preferences inside minimal requirements, and, if necessary, priorities inside compound queries. In other words, clear-cat properties can be refined by ordering the interpretations compatible with them, according to user's preferences. Often the representation of these preferences can be viewed as modelling linguistic-like terms in requests. In this paper, the theoretical issues raised by the introduction of flexible queries are studied in the case of the division operator, in the framework of fuzzy sets and possibility theory. The notion of division is well-known in the context of regular relations and the extension of this operation to fuzzy relations (induced by the flexible queries) is investigated. Several types of extended divisions can be envisaged, depending on the meaning of the grades attached to the tuples of the fuzzy relations (degree of fulfillment of gradual properties, level of importance of components in a query, or uncertainty pervading data). We focus on the first two meanings which are associated with different multiple-valued logic implications and we examine their properties and their expression in the framework of an extended SQL-like language where no specific construct for the division is available.
引用
收藏
页码:281 / 302
页数:22
相关论文
共 26 条
[1]
[Anonymous], FUZZY INFORM DECISIO
[2]
[Anonymous], 1988, POSSIBILITY THEORY
[3]
[Anonymous], J INTELL INF SYST
[4]
Bandler W., 1980, Fuzzy Sets. Theory and Applications to Policy Analysis and Information Systems. Proceedings of the Symposium on Policy Analysis and Information Systems, P341
[5]
THE MANAGEMENT OF PROBABILISTIC DATA [J].
BARBARA, D ;
GARCIAMOLINA, H ;
PORTER, D .
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1992, 4 (05) :487-502
[6]
SQLF - A RELATIONAL DATABASE LANGUAGE FOR FUZZY QUERYING [J].
BOSC, P ;
PIVERT, O .
IEEE TRANSACTIONS ON FUZZY SYSTEMS, 1995, 3 (01) :1-17
[7]
FUZZY QUERYING WITH SQL - EXTENSIONS AND IMPLEMENTATION ASPECTS [J].
BOSC, P ;
GALIBOURG, M ;
HAMON, G .
FUZZY SETS AND SYSTEMS, 1988, 28 (03) :333-349
[8]
BOSC P, 1992, J INTELL INF SYST, V1, P323
[9]
A FUZZY REPRESENTATION OF DATA FOR RELATIONAL DATABASES [J].
BUCKLES, BP ;
PETRY, FE .
FUZZY SETS AND SYSTEMS, 1982, 7 (03) :213-226
[10]
SEQUEL 2 - UNIFIED APPROACH TO DATA DEFINITION, MANIPULATION, AND CONTROL [J].
CHAMBERLIN, DD ;
ASTRAHAN, MM ;
ESWARAN, KP ;
GRIFFITHS, PP ;
LORIE, RA ;
MEHL, JW ;
REISNER, P ;
WADE, BW .
IBM JOURNAL OF RESEARCH AND DEVELOPMENT, 1976, 20 (06) :560-575