Providing probabilistically-bounded approximate answers to non-holistic aggregate range queries in OLAP

DOLAP 2005 - Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP, co-located with CIKM 2005

Volumn , Issue , 2005, Pages 97-106

  Cuzzocrea, Alfredo ^a  

^a UNIVERSITY OF CALABRIA   (Italy)

Author keywords

Approximate query answering; Error guarantees; OLAP; Probabilistic models; Synopsis data structures

Indexed keywords

AGGREGATES; DATA STRUCTURES; DIGITAL STORAGE; QUERY PROCESSING; WAREHOUSES;

ANSWERING QUERIES; APPROXIMATE QUERY ANSWERING; ERROR METRICS; OLAP; PROBABILISTIC MODELS; RANGE QUERY; STATE OF THE ART; STORAGE SPACE ALLOCATIONS;

DATA WAREHOUSES;

EID: 84887434916     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1097002.1097020     Document Type: Conference Paper

References (26)

1. S. Acharya, P.B. Gibbons, and V. Poosala, "AQUA: A Fast Decision Support System Using Approximate Query Answers", Proc. of VLDB, pp. 754-757, 1999.
2. S. Acharya, V. Poosala, and S. Ramaswamy, "Selectivity Estimation in Spatial Databases", Proc. of ACM SIGMOD, pp. 13-24, 1999.
3. B. Babcock, S. Chaudhuri, and G. Das, "Dynamic Sample Selection for Approximate Query Answers", Proc. of ACM SIGMOD, pp. 539-550, 2003.
4. D. Barbarà, and X. Wu, "Loglinear-Based Quasi Cubes", Journal of Intelligent Information Systems, Vol. 13, No. 3, pp. 255-276, 2001.
5. N. Bruno, S. Chaudhuri, and L. Gravano, "STHoles: A Multidimensional Workload-Aware Histogram", Proc. of ACM SIGMOD, pp. 211-222, 2001.
6. F. Buccafurri, F. Furfaro, D. Saccà, and C. Sirangelo, "A Quad-Tree Based Multiresolution Approach for Two-Dimensional Summary Data", Proc. of IEEE SSDBM, pp. 127-140, 2003.
7. S. Chaudhuri, G. Das, M. Datar, R. Motwani, and R. Rastogi, "Overcoming Limitations of Sampling for Aggregation Queries", Proc. of IEEE ICDE, pp. 534-542, 2001.
8. G. Colliat, "OLAP, Relational, and Multidimensional Database Systems", SIGMOD Record, Vol. 25, No. 3, pp. 64-69, 1996.
9. A. Cuzzocrea, "Overcoming Limitations of Approximate Query Answering in OLAP", Proc. of IEEE IDEAS, pp. 200-209, 2005.
10. A. Cuzzocrea, and U. Matrangolo, "Analytical Synopses for Approximate Query Answering in OLAP Environments", Proc. of DEXA, pp. 359-370, 2004.
11. A. Cuzzocrea, W. Wang, and U. Matrangolo, "Answering Approximate Range Aggregate Queries on OLAP Data Cubes with Probabilistic Guarantees", Proc. of DaWaK, pp. 97-107, 2004.
12. M.N. Garofalakis, and P.B. Gibbons, "Wavelet Synopses with Error Guarantees", Proc. of ACM SIGMOD, pp. 476-487, 2002.
13. M.N. Garofalakis, and A. Kumar, "Deterministic Wavelet Thresholding for Maximum-Error Metrics", Proc. of ACM PODS, pp. 166-176, 2004.
14. P.B. Gibbons, and Y. Matias, "New Sampling-Based Summary Statistics for Improving Approximate Query Answers", Proc. of ACM SIGMOD, pp. 331-342, 1998.
15. D. Gunopulos, G. Kollios, V.J. Tsotras, and C. Domeniconi, "Approximating Multi-Dimensional Aggregate Range Queries over Real Attributes", Proc. of ACM SIGMOD, pp. 463-474, 2000.
16. J. Han, and M. Kamber, Data Mining: Concepts and Techniques, Morgan Kauffmann Publishers, 2000.
17. J.M. Hellerstein, P.J. Haas, and H.J. Wang, "Online Aggregation", Proc. of ACM SIGMOD, pp. 171-182, 1997.
18. C.-T. Ho, R. Agrawal, N. Megiddo, and R. Srikant, "Range Queries in OLAP Data Cubes", Proc. of ACM SIGMOD, pp. 73-88, 1997.
19. W. Hoeffding, "Probability Inequalities for Sums of Bounded Random Variables", Journal of the American Statistical Association, Vol. 58, No. 301, pp. 13-30, 1963.
20. Y.E. Ioannidis, and V. Poosala, "Histogram-based Approximation of Set-Valued Query Answers", Proc. of VLDB, pp. 174-185, 1999.
21. A.K. Jain, Fundamentals of Digital Image Processing, Prentice Hall, 1989.
22. M. Muralikrishna, and D.J. DeWitt, "Equi-Depth Histograms for Estimating Selectivity Factors for Multi-Dimensional Queries", Proc. of ACM SIGMOD, pp. 28-36, 1988.
23. B.-U. Pagel, H.-W. Six, H. Toben, and P. Widmayer, "Towards an Analysis of Range Query Performance in Spatial Data Structures", Proc. of ACM PODS, pp. 214-221, 1993.
24. V. Poosala, and Y.E. Ioannidis, "Selectivity Estimation without the Attribute Value Independence Assumption", Proc. of VLDB, pp. 486-495, 1997.
25. J.S. Vitter, M. Wang, and B. Iyer, "Data Cube Approximation and Histograms via Wavelets", Proc. of ACM CIKM, pp. 96-104, 1998.
26. J.S. Vitter, and M. Wang, "Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets", Proc. of ACM SIGMOD, pp. 194-204, 1999.