Optimizing State-Intensive Non-Blocking Queries Using Run-time Adaptation

  • Authors:
  • Bin Liu;Mariana Jbantova;Elke A. Rundensteiner

  • Affiliations:
  • Worcester Polytechnic Institute, Worcester, MA 01609. E-mail: binliu@alum.wpi.edu;Worcester Polytechnic Institute, Worcester, MA 01609. E-mail: jbantova@cs.wpi.edu;Worcester Polytechnic Institute, Worcester, MA 01609. E-mail: rundenst@cs.wpi.edu

  • Venue:
  • ICDEW '07 Proceedings of the 2007 IEEE 23rd International Conference on Data Engineering Workshop
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

Main memory is a critical resource when processing non-blocking queries with state intensive operators that require real-time responses. While partitioned parallel processing can alleviate the stringent memory demands in some cases, in general even in a distributed system main memory remains bounded. In this work, we thus investigate the integration of two run-time adaptation techniques, namely, state spill to disk and state relocation to an alternate machine, to handle this memory shortage problem. We analyze the tradeoffs regarding key factors affecting these two runtime operator state adaptation techniques in a modern compute-cluster environment. Two strategies, lazy-disk and active-disk, are then proposed that integrate both state spill and state relocation adaptations with different emphasis on local versus global decision making. Extensive experiments of the proposed query processing system conducted on a compute-cluster (not merely a simulation) confirm the effectiveness of these strategies.