Optimized processing of multiple aggregate continuous queries

  • Authors:
  • Shenoda Guirguis;Mohamed A. Sharaf;Panos K. Chrysanthis;Alexandros Labrinidis

  • Affiliations:
  • University of Pittsburgh, Pittsburgh, PA, USA;The University of Queensland, Brisbane, Australia;University of Pittsburgh, Pittsburgh, USA;University of Pittsburgh, Pittsburgh, USA

  • Venue:
  • Proceedings of the 20th ACM international conference on Information and knowledge management
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data Streams Management Systems are designed to support monitoring applications, which require the processing of hundreds of Aggregate Continuous Queries (ACQs). These ACQs typically have different time granularities, with possibly different selection predicates and group-by attributes. In order to achieve scalability in the presence of heavy workloads, in this paper, we introduce the concept of 'Weaveability' as an indicator of the potential gains of sharing the processing of ACQs. We then propose Weave Share, a cost-based optimizer that exploits weaveability to optimize the shared processing of ACQs. Our experimental analysis shows that Weave Share outperforms the alternative sharing schemes generating up to four orders of magnitude better quality plans. Finally, we describe a practical implementation of the Weave Share optimizer.