Title :
Dynamic histograms for non-stationary updates
Author :
Lam, Elizabeth ; Salem, Kenneth
Author_Institution :
Equitrac, Waterloo, Ont., Canada
Abstract :
In this paper, we address the problem of incrementally maintaining a histogram in response to a non-stationary update process. In relational database systems, this problem can occur whenever relations model time-varying activities. We present a simple update model that is general enough to describe both stationary and non-stationary update processes, and we use it to show that existing histogram maintenance techniques can perform poorly when updates are non-stationary. We describe several techniques for solving this problem, and we use the update model to demonstrate that these techniques can effectively handle a broad range of update processes, including non-stationary ones.
Keywords :
relational databases; dynamic histograms; nonstationary updates; relational database systems; update model; Computer science; Data engineering; Database systems; Histograms; Query processing; Relational databases; Statistical distributions; Testing; Time varying systems;
Conference_Titel :
Database Engineering and Application Symposium, 2005. IDEAS 2005. 9th International
Print_ISBN :
0-7695-2404-4
DOI :
10.1109/IDEAS.2005.23