Content-Based Routing for Continuous Query-Optimization

Pedro Bizarro, Shivnath Babu, David J. DeWitt, Jennifer Widom · 2004

Current Data Stream Management Systems do not fully exploit their adaptive nature to handle complex queries. To date, such systems route stream tuples to operators or operator paths based only on operator-level statistics. Their optimizers ignore non-independent distributions, at-tribute correlations, and tuple content. In this paper, we propose a content-based tuple routing approach which, to-gether with histogram-like statistics, allows a stream query processing system to exploit non-independent distributions and correlations instead of being hurt by them. We present a framework for content-based routing in a stream query processing system and an algorithm for learning content-based routes automatically and efficiently. We present an extensive experimental evaluation of content-based routing based on a prototype implementation in TelegraphCQ. Our results clearly indicate that good content-based routes can be learned quickly and efficiently to improve query perfor-mance significantly. We believe that any system that pro-cesses complex queries over possibly non-uniform data, even in a non-stream environment, can profit by being si-multaneously adaptive and content-aware. 1.

Read the paper · More papers on PaperTik