Aggregate Queries Over Conditional Tables |
| |
Authors: | Jens Lechtenbörger Hua Shu Gottfried Vossen |
| |
Affiliation: | (1) Department of Information Systems, University of Münster, Leonardo-Campus 3, D-48149 Münster, Germany;(2) IBM Silicon Valley Lab, 555 Bailey Avenue, San Jose, CA 95141, USA |
| |
Abstract: | Conditional tables have been identified long ago as a way to capture unknown or incomplete information. However, queries over conditional tables have never been allowed to involve column functions such as aggregates. In this paper, the theory of conditional tables is extended in this direction, and it is shown that a strong representation system exists which has the closure property that the result of an aggregate query over a conditional table can be again represented by a conditional table. It turns out, however, that the number of tuples in a conditional table representing the result of an aggregate query may grow exponentially in the number of variables in the table. This phenomenon is analyzed in detail, and tight upper and lower bounds concerning the number of tuples contained in the result of an aggregate query are given. Finally, representation techniques are sketched that approximate aggregation results in tables of reasonable size. |
| |
Keywords: | database incomplete information aggregate query data warehouse |
本文献已被 SpringerLink 等数据库收录! |
|