DMCA
Join synopses for approximate query answering (1999)
Cached
Download Links
| Venue: | In SIGMOD |
| Citations: | 169 - 9 self |
BibTeX
@INPROCEEDINGS{Acharya99joinsynopses,
author = {Swarup Acharya and Phillip B. Gibbons and Viswanath Poosala and Sridhar Ramaswamy},
title = {Join synopses for approximate query answering},
booktitle = {In SIGMOD},
year = {1999},
pages = {275--286}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
In large data warehousing environments, it is often advantageous to provide fast, approximate answers to complex aggregate queries based on statistical summaries of the full data. In this paper, we demonstrate the difficulty of providing good approximate answers for join-queries using only statistics (in particular, samples) from the base relations. We propose join synopses (join samples) as an effective solution for this problem and show how precomputing just one join synopsis for each relation suffices to significantly improve the quality of approximate answers for arbitrary queries with foreign key joins. We present optimal strategies for allocating the available space among the various join synopses when the query work load is known and identify heuristics for the common case when the work load is not known. We also present efficient algorithms for incrementally maintaining join synopses in the presence of updates to the base relations. One of our key contributions is a detailed analysis of the error bounds obtained for approximate answers that demonstrates the trade-offs in various methods, as well as the advantages in certain scenarios of a new subsampling method we propose. Our extensive set of experiments on the TPC-D benchmark database show the effectiveness of join synopses and various other techniques proposed in this paper. 1
Keyphrases
join synopsis approximate query answering approximate answer base relation certain scenario various method available space present efficient algorithm full data good approximate answer large data query work load arbitrary query tpc-d benchmark database key contribution complex aggregate query various technique effective solution common case work load present optimal strategy detailed analysis statistical summary foreign key join various join synopsis extensive set
