English

Proof: Accelerating Approximate Aggregation Queries with Expensive Predicates

Statistics Theory 2021-07-30 v2 Databases Machine Learning Machine Learning Statistics Theory

Abstract

Given a dataset D\mathcal{D}, we are interested in computing the mean of a subset of D\mathcal{D} which matches a predicate. ABae leverages stratified sampling and proxy models to efficiently compute this statistic given a sampling budget NN. In this document, we theoretically analyze ABae and show that the MSE of the estimate decays at rate O(N11+N21+N11/2N23/2)O(N_1^{-1} + N_2^{-1} + N_1^{1/2}N_2^{-3/2}), where N=KN1+N2N=K \cdot N_1+N_2 for some integer constant KK and KN1K \cdot N_1 and N2N_2 represent the number of samples used in Stage 1 and Stage 2 of ABae respectively. Hence, if a constant fraction of the total sample budget NN is allocated to each stage, we will achieve a mean squared error of O(N1)O(N^{-1}) which matches the rate of mean squared error of the optimal stratified sampling algorithm given a priori knowledge of the predicate positive rate and standard deviation per stratum.

Cite

@article{arxiv.2107.12525,
  title  = {Proof: Accelerating Approximate Aggregation Queries with Expensive Predicates},
  author = {Daniel Kang and John Guibas and Peter Bailis and Tatsunori Hashimoto and Yi Sun and Matei Zaharia},
  journal= {arXiv preprint arXiv:2107.12525},
  year   = {2021}
}
R2 v1 2026-06-24T04:32:48.025Z