2014 · 38 citations · 19 references
EngineeringComputer EngineeringComputer ScienceComputer ArchitectureParallel ComputingSystem-on-chip DesignCachingHardware AccelerationLatency OptimizationMemory HierarchyMemory Hierarchy DesignMemory Subsystem DesignCache ManagementData PrefetchingLast-level Cache BehaviorMemory BandwidthMulticore ArchitecturesMulticore SystemsPrefetchingPrefetching Mechanisms
Approximate Query Processing (AQP) based on sampling is critical for supporting timely and cost-effective analytics over big data. To be applied successfully, AQP must be accompanied by reliable estimates on the quality of sample-produced approximate answers; the two main techniques used in the past for this purpose are (i) closed-form analytic error estimation, and (ii) the bootstrap method. Approach (i) is extremely efficient but lacks generality, whereas (ii) is general but suffers from high computational overhead. Our recently introduced Analytical Bootstrap method combines the strengths of both approaches and provides the basis for our ABS system, which will be demonstrated at the conference. The ABS system models bootstrap by a probabilistic relational model, and extends relational algebra with operations on probabilistic relations to predict the distributions of the AQP results. Thus, ABS entails a very fast computation of bootstrap-based quality measures for a general class of SQL queries, which is several orders of magnitude faster than the standard simulation-based bootstrap. In this demo, we will demonstrate the generality, automaticity, and ease of use of the ABS system, and its superior performance over the traditional approaches described above.
19
Joseph M. Hellerstein, Peter J. Haas, Helen J. Wang · 1997 · 928 citations · Full text
Sameer Agarwal, Barzan Mozafari, Aurojit Panda et al. · 2013 · 709 citations
Load shedding for aggregation queries over data streams
Brian Babcock, Mayur Datar, R. Motwani · 2004 · 313 citations
Dynamic sample selection for approximate query processing
Brian Babcock, Surajit Chaudhuri, Gautam Das · 2003 · 259 citations
Towards estimation error guarantees for distinct values
Moses Charikar, Surajit Chaudhuri, Rajeev Motwani et al. · 2000 · 233 citations · Full text