Dynamic Histograms: Capturing Evolving Data Sets

In this paper, we introduce dynamic histograms, which are constructed and maintained incrementally. We develop several dynamic histogram construction algorithms and show that they come close to static histograms in quality. Our experimental study covers a wide range of datasets and update patterns, including histogram maintenance in a shared-nothing environment. Building upon the insights offered by the dynamic algorithms, we also propose a new static histogram construction algorithm that is very fast and generates histograms that are close in quality to the highly accurate (but expensive to construct!) V-Optimal histograms.

• Type: Conference
• Year: 2000
• Where: ICDE
• Authors: Donko Donjerkovic, Yannis E. Ioannidis, Raghu Ramakrishnan
• Keywords: Database, Dynamic Histogram Construction, Dynamic Histograms, ICDE 2000, Static Histogram Construction