Adaptive caching for continuous queries

Journal Article

We address the problem of executing continuous multiway join queries in unpredictable and volatile environments. Our query class captures windowed join queries in data stream systems as well as conventional maintenance of materialized join views. Our adaptive approach handles streams of updates whose rates and data characteristics may change over time, as well as changes in system conditions such as memory availability. In this paper we focus specifically on the problem of adaptive placement and removal of caches to optimize join performance. Our approach automatically considers conventional tree-shaped join plans with materialized subresults at every intermediate node, subresult-free MJoins, and the entire spectrum between them. We provide algorithms for selecting caches, monitoring their cost and benefits in current conditions, allocating memory to caches, and adapting as conditions change. All of our algorithms are implemented in the STREAM prototype Data Stream Management System and a thorough experimental evaluation is included. © 2005 IEEE.

Full Text

Duke Authors

Cited Authors

  • Babu, S; Munagala, K; Widom, J; Motwani, R

Published Date

  • December 12, 2005

Published In

Start / End Page

  • 118 - 129

International Standard Serial Number (ISSN)

  • 1084-4627

Digital Object Identifier (DOI)

  • 10.1109/ICDE.2005.15

Citation Source

  • Scopus