Abstract
It is very important to provide analysts with guaranteed error bounds for approximate aggregate queries in many current enterprise applications such as the decision support systems. In this paper, we propose a general technique to provide tight error bounds for approximate results to OLAP range-sum queries. We perform an extensive experiment on diverse data sets, and examine the effectiveness of our proposed method with respect to various dimensions of the data cube and query sizes.
Preview
Unable to display preview. Download preview PDF.
References
N. Beckmann, H. Kriegel, R. Schneider, and B. Seeger: The R*-tree: an efficient and robust access method for points and rectangles. Proc. of ACM SIGMOD Conference (1990) 322–331
Seok-Ju Chun, Chin-Wan Chung, Ju-Hong Lee, and Seok-Lyong Lee: Dynamic Update Cube for Range-Sum Queries. Proc. of VLDB Conference (2001) 521–530
C. Ho, R. Agrawal, N. Megido, R. Srikant: Range queries in OLAP Data Cubes. Proc. of ACM SIGMOD Conference (1997) 73–88
L. Lazaridis, and S. Mehrotra: Progressive Approximate Aggregate Queries with a Multi-Resolution Tree Structure. Proc. of ACM SIGMOD Conference (2001) 401–412
M. Riedewald, D. Agrawal, and A. E. Abbadi: pCube: Update-Efficient Online Aggregation with Progressive Feedback and Error Bounds. Proc. of SSDBM Conference (2000) 95–108
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chun, SJ., Lee, JH., Lee, SL. (2003). Approximate Aggregate Queries with Guaranteed Error Bounds. In: Wang, G., Liu, Q., Yao, Y., Skowron, A. (eds) Rough Sets, Fuzzy Sets, Data Mining, and Granular Computing. RSFDGrC 2003. Lecture Notes in Computer Science(), vol 2639. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-39205-X_104
Download citation
DOI: https://doi.org/10.1007/3-540-39205-X_104
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-14040-5
Online ISBN: 978-3-540-39205-7
eBook Packages: Springer Book Archive