Share on Facebook Tweet on Twitter Share on LinkedIn Share by email
STHoles: A Multidimensional Workload-Aware Histogram

Nicolas Bruno, Surajit Chaudhuri, and Luis Gravano

Abstract

Attributes of a relation are not typically independent. Multidimensional histograms can be an effective tool for accurate multiattribute query selectivity estimation. In this paper, we introduce STHoles , a "workload-aware" histogram that allows bucket nesting to capture data regions with reasonably uniform tuple density. STHoles histograms are built without examining the data sets, but rather by just analyzing query results. Buckets are allocated where needed the most as indicated by the workload, which leads to accurate query selectivity estimations. Our extensive experiments demonstrate that STHoles histograms consistently produce good selectivity estimates across synthetic and real-world data sets and across query workloads, and, in many cases, outperform the best multidimensional histogram techniques that require access to and processing of the full data sets during histogram construction.

Details

Publication typeTechReport
NumberMSR-TR-2001-36
Pages27
InstitutionMicrosoft Research
> Publications > STHoles: A Multidimensional Workload-Aware Histogram