Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 1999, Pages 193-204

  Vitter, Jeffrey Scott ^a   Wang, Min ^a  

^a Duke University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

AGGREGATES; CLUSTERING ALGORITHMS; DATA MINING; DIGITAL STORAGE; GEOMETRY; QUERY PROCESSING; REFINING; WAVELET DECOMPOSITION;

AGGREGATION QUERIES; APPROXIMATE COMPUTATION; DATA CUBE; HIGH-DIMENSIONAL; HIGHER DIMENSIONS; HIGHER-DIMENSIONAL; MULTI-DIMENSIONAL AGGREGATES; PERFORMANCE BOTTLENECKS; SPACE EFFICIENT; SPARSE DATA;

DATA WAREHOUSES;

EID: 20444453663     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/304182.304199     Document Type: Conference Paper

References (25)

1. S. Agarwal, R. Agrawal, P. Deshpande, J. Naughton, S. Sarawagi, and R. Ramakrishnan. On the compu-tation of multidimensional aggregates. In Proceedings of the 1996 International Conference on Very Large Databases, Mumbai, India, 1996.
2. A. Aggarwal and J. S. Vitter. The input/output complexity of sorting and related problems. Commnications of the ACM, 31(9):1116-1127, 1988.
3. D. Barbara, W. DuMouchel, C. Faloutsos, P. J. Haas, J. M. Hellerstein, Y. Ioannidis, H. V. Jagadish, T. Johnson, R. Ng, , V. Poosala, K. A. Ross, and K. C. Sevcik. The New Jersey data reduction report. Bulletin of the Technical Committee on Data Engineering, 20(4), 1997.
4. U.S. Census Bureau. C!ensus bureau databases. The online data are available on the web at http://www.census.gov/.
5. C. baloutsos, H. V. Jagadish, and N. D. Sidiropoulos. Recovering information from summary data. In Proceedings of Ihe 1997 International Conference on Very Large Databases, Athens, Greece, August 1997.
6. J. Gray, A. Bosworth, A. Layman, and H. Pirahesh. Data cube: A relational aggregation operator generalizing group-by, cross-tabs &d subtotals. In Proceedings of the 12th Annual IEEE Conference on Data Enqihering (ICDE '96), pages 1311139, 1996.
7. P. B. Gibbons and Y. Matias. New sampling-based summary statistics for improving approximate query answers. In Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, Seattle, WA, June 1998.
8. C.-T. Ho, R. Agrawal, N. Megiddo, and R. Srikant. Range queries in OLAP data cubes. In Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data, Tucson, AZ, May 1997.
9. J. M. Hellerstein, P. J. Haas, and H. J. Wang. Online aggregation. In Proceedings of the 1997 ACM SIGMOD Inl:ernational Conference on Management of Data, Tucson, AZ, May 1997.
10. V. Harinarayan, A. Rajaraman, and J. D. Ullman. Implementing Data cube; efficiently. In Proceedings of the 1996 AC-M SIGMOD International Conference on Management of Data, Montreal, Canada, Gay 1996.
11. B. Jawerth and W. Sweldens. An overview of wavelet based multiresolution analyses. SIAM Rev., 36(3):377-412, 1994.
12. Y. Mat&, J. S. Vitter, and M. Wang. Wavelet-based histograms for selectivity estimation. In Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, pages 448-459, Seattle, WA, June 1998.
13. N. Pendse and R. Creeth. The OLAP report, 1998. The online report is available on the web at http://wwu.olapreport.com/Analyses.htm/
14. V. Poosala and Y. E. Ioannidis. Estimation of queryresult distribution and its application in parallel-join load balancing. In Proceedings of the 1996 International Conference on Very Large Databases, Bombay, India, September 1996.
15. V. Poosala and Y. E. Ioannidis. Selectivity estimation without the attribute value independence assumption. In Proceeding:: Of the 1997 International Conference on Very Large Databases, Athens, Greece, August 1997.
16. V. Poosala, Y. E. Ioannidis, P. J. Baas, and E. Shekita. Improved histograms for selectivity estimation of range predicates. In Proceedings of the 1996 ACM SIGMOD In.ternational Conference on Management of Data, Montreal, Canada, May 1996.
17. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price. Access path selection in a relational da.tabase management system. In Proceedings of the 1979 ACM SIGMOD International Conferen. ce on Management of Data, pages 23-34, 1979.
18. E. J. Stollnitz, T. D. Derose, and D. H. Salesin. Wavelets for Computer Graphics. Morgan Kaufmann, 1996.
19. D. E. Vengroff. A transparent parallel I/O environment. In Proceedings of the 1994 DAGS Symposium on Parallel Computa tion, July 1994.
20. D. E. Vengroff. TPIE User Manual and Reference. Duke University, 1997. The manual and software distribution are available on the web at http://www.cs.duke.edu/TPIE/.
21. J. S. Vitter. External memory algorithms and data structures. In J. Abello and J. S. Vitter, editors, External Memory Algorithms and Visualization, DIMACS series. American Mathematical Society, to appear 1999. Available via the author's web l:bage http://vvw.cs.duke.edu/-jsv/.
22. J. S. Vitter and E. A. M. Shriver. Algorithms for parallel memory I: Two-level memories. Algorithmica, 12(2-3):110-147, 1994. Special double issue on Large-Scale Memories.
23. D. E. Vengroff and J. S. Vitter. I/O-efficient scient.ific computation using TPIE. In Proceedinqs of the G'oddard Conference on Mass Storage Systems-and Technoloqies, NASA Conference Publication 3340. Volume II, pages 553-570, College Park, MD, September 1996.
24. J. S. Vitter, M. Wang, and B. Iyer. Data cube approximation and histograms via wavelets. In Proceedings of Seventh International Conference on Information and Knowledge Management, pages 96-104, Washington D.C., November 1998.
25. Y. Zhao, P. M. Deshpande, and J. F. Naughton. An array-based algorithm for simultaneous multidimensional aggregates. In Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data, Tucson, AZ, May 1997.