• DocumentCode
    2534144
  • Title

    Dynamic histograms for non-stationary updates

  • Author

    Lam, Elizabeth ; Salem, Kenneth

  • Author_Institution
    Equitrac, Waterloo, Ont., Canada
  • fYear
    2005
  • fDate
    25-27 July 2005
  • Firstpage
    235
  • Lastpage
    243
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Database Engineering and Application Symposium, 2005. IDEAS 2005. 9th International
  • ISSN
    1098-8068
  • Print_ISBN
    0-7695-2404-4
  • Type

    conf

  • DOI
    10.1109/IDEAS.2005.23
  • Filename
    1540913