Skip to main content

Approximate Aggregate Queries with Guaranteed Error Bounds

  • Conference paper
  • First Online:
Rough Sets, Fuzzy Sets, Data Mining, and Granular Computing (RSFDGrC 2003)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 2639))

  • 740 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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

    Google Scholar 

  2. 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

    Google Scholar 

  3. C. Ho, R. Agrawal, N. Megido, R. Srikant: Range queries in OLAP Data Cubes. Proc. of ACM SIGMOD Conference (1997) 73–88

    Google Scholar 

  4. L. Lazaridis, and S. Mehrotra: Progressive Approximate Aggregate Queries with a Multi-Resolution Tree Structure. Proc. of ACM SIGMOD Conference (2001) 401–412

    Google Scholar 

  5. 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

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics