Evaluating aggregate operations over imprecise data

被引:42
作者
Chen, ALP [1 ]
Chiu, JS [1 ]
Tseng, FSC [1 ]
机构
[1] YUAN ZE INST TECHNOL,DEPT INFORMAT MANAGEMENT,CHUNGLI 32026,TAIWAN
关键词
relational databases; null values; partial values; scalar aggregates; aggregate functions; graph theory;
D O I
10.1109/69.494166
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Imprecise data in databases were originally denoted as null values, which represent the meaning of ''values unknown at present.'' More generally, a partial value corresponds to a finite set of possible values for an attribute in which exactly one of the values is the ''true'' value. In this paper, we define a set of extended aggregate operations, namely sum, average, count, maximum, and minimum, which can be applied to an attribute containing partial values. Two types of aggregate operators are considered: scalar aggregates and aggregate functions. We study the properties of the aggregate operations and develop efficient algorithms for count, maximum and minimum. However, for sum and average, we point out that in general it takes exponential time complexity to do the computations.
引用
收藏
页码:273 / 284
页数:12
相关论文
共 33 条
  • [1] [Anonymous], 1979, Computers and Intractablity: A Guide to the Theoryof NP-Completeness
  • [2] THE MANAGEMENT OF PROBABILISTIC DATA
    BARBARA, D
    GARCIAMOLINA, H
    PORTER, D
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1992, 4 (05) : 487 - 502
  • [3] BONDY JA, 1976, GRAPH THEORY APPLICA
  • [4] FUZZY QUERYING WITH SQL - EXTENSIONS AND IMPLEMENTATION ASPECTS
    BOSC, P
    GALIBOURG, M
    HAMON, G
    [J]. FUZZY SETS AND SYSTEMS, 1988, 28 (03) : 333 - 349
  • [5] A FUZZY REPRESENTATION OF DATA FOR RELATIONAL DATABASES
    BUCKLES, BP
    PETRY, FE
    [J]. FUZZY SETS AND SYSTEMS, 1982, 7 (03) : 213 - 226
  • [6] CAVALLO R, 1987, 13TH P INT C VER LAR, P71
  • [7] Codd E. F., 1979, ACM Transactions on Database Systems, V4, P397, DOI 10.1145/320107.320109
  • [8] CODD EF, 1986, ACM SIGMOD RECORD, V15, P53
  • [9] Date C.J., 1989, A Guide to the SQL Standard, VSecond
  • [10] DeMichiel L. G., 1989, IEEE Transactions on Knowledge and Data Engineering, V1, P485, DOI 10.1109/69.43423