ICICLES: Self-Tuning Samples for Approximate Query Answering

Approximate query answering systems provide very fast alternatives to OLAP systems when applications are tolerant to small errors in query answers. Current sampling-based approaches to approximately answer aggregate queries over foreign key joins suffer from the following drawback. All tuples in relations are deemed equally important for answering queries even though, in reality, OLAP queries exhibit locality in their data access. Consequently, they may waste precious real estate by sampling tuples that are not required at all or required very rarely. In this paper, we introduce icicles, a new class of samples that tune themselves to a dynamic workload. Intuitively, the probability of a tuple being present in an icicle is proportional to its importance for answering queries in the workload. Therefore, an icicle consists of more tuples from a subset of the relation that is required to answer more queries in the workload. Consequently, the accuracy of approximate answers obtained by usi...

• Type: Conference
• Year: 2000
• Where: VLDB
• Authors: Venkatesh Ganti, Mong-Li Lee, Raghu Ramakrishnan
• Keywords: Database, Icicles, Queries Exhibit Locality, Query Answering Systems, VLDB 2000