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
相关论文
共 50 条
  • [1] Evaluating Trajectory Queries over Imprecise Location Data
    Xie, Xike
    Cheng, Reynold
    Yiu, Man Lung
    [J]. SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT, SSDBM 2012, 2012, 7338 : 56 - 74
  • [2] Evaluating Continuous Probabilistic Queries Over Imprecise Sensor Data
    Zhang, Yinuo
    Cheng, Reynold
    Chen, Jinchuan
    [J]. DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PT I, PROCEEDINGS, 2010, 5981 : 535 - +
  • [3] A Model of Aggregate Operations for Data Analytics over Spatiotemporal Objects
    Maughan, Logan
    McKenney, Mark
    Benchley, Zachary
    [J]. ADVANCES IN CONCEPTUAL MODELING, 2014, 8823 : 234 - 240
  • [4] Probabilistic Measures and Integrals: How to Aggregate Imprecise Data
    Boczek, Michal
    Halcinova, Lenka
    Hutnik, Ondrej
    Kaluszka, Marek
    [J]. MODELING DECISIONS FOR ARTIFICIAL INTELLIGENCE (MDAI 2020), 2020, 12256 : 78 - 91
  • [5] OLAP over uncertain and imprecise data
    Burdick, Doug
    Deshpande, Prasad M.
    Jayram, T. S.
    Ramakrishnan, Raghu
    Vaithyanathan, Shivakumar
    [J]. VLDB JOURNAL, 2007, 16 (01): : 123 - 144
  • [6] OLAP over uncertain and imprecise data
    Doug Burdick
    Prasad M. Deshpande
    T. S. Jayram
    Raghu Ramakrishnan
    Shivakumar Vaithyanathan
    [J]. The VLDB Journal, 2007, 16 : 123 - 144
  • [7] Evaluating Imprecise Forecasts
    Konek, Jason
    [J]. INTERNATIONAL SYMPOSIUM ON IMPRECISE PROBABILITY: THEORIES AND APPLICATIONS, VOL 215, 2023, 215 : 270 - 279
  • [8] Capturing uncertainty in spatial queries over imprecise data
    Yu, XB
    Mehrotra, S
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2003, 2736 : 192 - 201
  • [9] CONTROLLING AND EVALUATING DATA PROCESSING OPERATIONS
    MCDERMOT, GJ
    [J]. JOURNAL OF INDUSTRIAL ENGINEERING, 1966, 17 (01): : 22 - &
  • [10] Evaluating and reporting astigmatism for individual and aggregate data
    Holladay, JT
    Dudeja, DR
    Koch, DD
    [J]. JOURNAL OF CATARACT AND REFRACTIVE SURGERY, 1998, 24 (01): : 57 - 65