Multi-query optimization for sketch-based estimation

Information Systems

Volumn 34, Issue 2, 2009, Pages 209-230

  Dobra, Alin ^a   Garofalakis, Minos ^b   Gehrke, Johannes ^c   Rastogi, Rajeev ^d  

^a UNIVERSITY OF FLORIDA   (United States)

^b Cornell University Ithaca ^*  (United States)

^c Department of Obstetrics Gynecology   (United States)

^d LUCENT TECHNOLOGIES   (United States)

Author keywords

Approximate query processing; Data streaming; Multi query optimization; Sketches

Indexed keywords

BENCHMARKING; DATA PROCESSING; DATA REDUCTION; OPTIMIZATION; QUERY PROCESSING;

APPROXIMATE QUERY PROCESSING; APPROXIMATION ERRORS; DATA STREAMING; EFFECTIVE TOOLS; ERROR METRIC; ESTIMATION PROCESSES; EXPERIMENTAL STUDIES; MULTI-QUERY OPTIMIZATION; MULTIPLE QUERIES; NECESSARY AND SUFFICIENT CONDITIONS; NP-HARD; OPTIMIZATION PROBLEMS; QUERY EVALUATIONS; QUERY OPTIMIZATIONS; SKETCHES; SQL QUERIES; STREAMING DATUMS; SUBSTANTIAL IMPROVEMENTS;

HEURISTIC ALGORITHMS;

EID: 56949091096     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.is.2008.06.002     Document Type: Article

References (26)

1. M. Greenwald, S. Khanna, Space-efficient online computation of quantile summaries, in: Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data, Santa Barbara, California, May 2001.
2. A.C. Gilbert, Y. Kotidis, S. Muthukrishnan, M.J. Strauss, How to summarize the universe: dynamic maintenance of quantiles, in: Proceedings of the 28th International Conference on Very Large Data Bases, Hong Kong, China, August 2002.
3. Z. Bar-Yossef, T. Jayram, R. Kumar, D. Sivakumar, L. Trevisan, Counting distinct elements in a data stream, in: Proceedings of the 6th International Workshop on Randomization and Approximation Techniques in Computer Science (RANDOM'02), Cambridge, Massachusetts, September 2002.
4. P.B. Gibbons, S. Tirthapura, Estimating simple functions on the union of data streams, in: Proceedings of the Thirteenth Annual ACM Symposium on Parallel Algorithms and Architectures, Crete Island, Greece, July 2001.
5. P.B. Gibbons, Distinct sampling for highly-accurate answers to distinct values queries and event reports, in: Proceedings of the 27th International Conference on Very Large Data Bases, Rome, Italy, September 2001.
6. M. Charikar, K. Chen, F.-C. Martin, Finding frequent items in data streams, in: Proceedings of the International Colloquium on Automata, Languages, Programming, Malaga, Spain, July 2002.
7. G.S. Manku, R. Motwani, Approximate frequency counts over data streams, in: Proceedings of the 28th International Conference on Very Large Data Bases, Hong Kong, China, August 2002.
8. N. Alon, P.B. Gibbons, Y. Matias, M. Szegedy, Tracking join and self-join sizes in limited storage, in: Proceedings of the Eighteenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Philadelphia, Pennsylvania, May 1999.
9. N. Alon, Y. Matias, M. Szegedy, The space complexity of approximating the frequency moments, in: Proceedings of the 28th Annual ACM Symposium on the Theory of Computing, Philadelphia, Pennsylvania, May 1996, pp. 20-29.
10. 1-difference algorithm for massive data streams, in: Proceedings of the 40th Annual IEEE Symposium on Foundations of Computer Science, New York, NY, October 1999.
11. P. Indyk, Stable distributions, pseudorandom generators, embeddings and data stream computation, in: Proceedings of the 41st Annual IEEE Symposium on Foundations of Computer Science, Redondo Beach, California, November 2000, pp. 189-197.
12. P. Domingos, G. Hulten, Mining high-speed data streams, in: Proceedings of the Sixth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, Boston, Massachusetts, August 2000, pp. 71-80.
13. S. Guha, N. Mishra, R. Motwani, L. O'Callaghan, Clustering data streams, in: Proceedings of the 2000 Annual Symposium on Foundations of Computer Science (FOCS), November 2000.
14. J. Gehrke, F. Korn, D. Srivastava, On computing correlated aggregates over continual data streams, in: Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data, Santa Barbara, California, September 2001.
15. A.C. Gilbert, Y. Kotidis, S. Muthukrishnan, M.J. Strauss, Surfing wavelets on streams: one-pass summaries for approximate aggregate queries, in: Proceedings of the 27th International Conference on Very Large Data Bases, Rome, Italy, September 2000.
16. N. Thaper, S. Guha, P. Indyk, N. Koudas, Dynamic multidimensional histograms, in: Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, Madison, Wisconsin, June 2002.
17. A. Arasu, B. Babcock, S. Babu, J. McAlister, J. Widom, Characterizing memory requirements for queries over continuous data streams, in: Proceedings of the 21st ACM Symposium on Principles of Database Systems, Madison, Wisconsin, June 2002.
18. M. Garofalakis, J. Gehrke, R. Rastogi, Querying and mining data streams: you only get one look, Tutorial in 28th International Conference on Very Large Data Bases, Hong Kong, China, August 2002.
19. A. Dobra, M. Garofalakis, J. Gehrke, R. Rastogi, Processing complex aggregate queries over data streams, in: Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, Seattle, Washington, June 1998, pp. 448-459.
20. Sellis T.K. Multiple-query optimization. ACM Trans. Database Syst. 13 1 (1988) 23-52
21. P. Roy, S. Seshadri, S. Sudarshan, S. Bhobe, Efficient and extensible algorithms for multi query optimization, in: Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, Dallas, Texas, May 2000.
22. J. Chen, D. DeWitt, F. Tian, Y. Wang, NiagaraCQ: a scalable continuous query system for internet databases, in: Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, Dallas, Texas, May 2000.
23. S.M. Stefanov, Separable programming, in: Applied Optimization, vol. 53, Kluwer Academic Publishers, Dordrecht, 2001.
24. T. Ibaraki, N. Katoh, Resource Allocation Problems-Algorithmic Approaches, MIT Press Series in the Foundations of Computing, 1988.
25. Cormen T.H., Leiserson C.E., and Rivest R.L. Introduction to Algorithms (1990), The MIT Press, Massachusetts
26. J.S. Vitter, M. Wang, Approximate computation of multidimensional aggregates of sparse data using wavelets, in: Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data, Philadelphia, Pennsylvania, May 1999.