Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/1989323.1989388acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

Changing flights in mid-air: a model for safely modifying continuous queries

Published: 12 June 2011 Publication History

Abstract

Continuous queries can run for unpredictably long periods of time. During their lifetime, these queries may need to be adapted either due to changes in application semantics (e.g., the implementation of a new alert detection policy), or due to changes in the system's behavior (e.g., adapting performance to a changing load). While in previous works query modification has been implicitly utilized to serve specific purposes (e.g., load management), to date no research has been done that defines a general-purpose, reliable, and efficiently implementable model for modifying continuous queries at run-time. In this paper, we introduce a punctuation-based framework that can formally express arbitrary lifecycle operations on the basis of input-output mappings and basic control elements such as start or stop of queries. On top of this foundation, we derive all possible query change methods, each providing different levels of correctness guarantees and performance. We further show how these models can be efficiently realized in a state-of-the-art stream processing engine; we also provide experimental results demonstrating the key performance tradeoffs of the change methods.

References

[1]
IBM InfoSphere Streams. http://www-01.ibm.com/software/data/infosphere/streams/.
[2]
Master: Managing Assurance, Security and Trust for sERvices. http://www.master-fp7.eu/.
[3]
MXQuery: A Light-weight, Full-featured XQuery Engine. http://mxquery.org/?page_id=2.
[4]
StreamBase Systems, Inc. http://www.streambase.com/.
[5]
Truviso, Inc. http://www.truviso.com/.
[6]
D. Abadi et al. The Design of the Borealis Stream Processing Engine. In CIDR Conference, 2005.
[7]
M. H. Ali et al. Microsoft CEP Server and Online Behavioral Targeting. PVLDB, 2(2), 2009.
[8]
R. Alur and D. L. Dill. A theory of timed automata. Theoretical Computer Science, 126(2), 1994.
[9]
A. Arasu et al. Linear Road: A Stream Data Management Benchmark. In VLDB Conference, 2004.
[10]
I. Botan et al. Extending XQuery with Window Functions. In VLDB Conference, 2007.
[11]
B. Chandramouli et al. Query Suspend and Resume. In ACM SIGMOD Conference, 2007.
[12]
S. Chandrasekaran et al. TelegraphCQ: Continuous Dataflow Processing for an Uncertain World. In CIDR Conference, 2003.
[13]
S. Chaudhuri et al. Stop-and-Restart Style Execution for Long Running Decision Support Queries. In VLDB Conference, 2007.
[14]
A. Deshpande, Z. Ives, and V. Raman. Adaptive Query Processing. Found. Trends databases, 1:1--140, January 2007.
[15]
K. S. Esmaili, T. Sanamrad, P. M. Fischer, and N. Tatbul. Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries. Technical Report 722, ETH Zurich, 2011. ftp://ftp.inf.ethz.ch/pub/publications/tech-reports/7xx/722.pdf.
[16]
J.-H. Hwang et al. High-Availability Algorithms for Distributed Stream Processing. In IEEE ICDE Conference, 2005.
[17]
W. J. Labio et al. Efficient Resumption of Interrupted Warehouse Loads. In ACM SIGMOD Conference, 2000.
[18]
L. Lamport. Proving the Correctness of Multiprocess Programs. IEEE TSE Journal, 3(2), 1977.
[19]
Y. Law, H. Wang, and C. Zaniolo. Query languages and data models for database sequences and data streams. In VLDB, 2004.
[20]
M. Lindeberg et al. Adaptive-sized Windows to Improve Real-time Health Monitoring: A Case Study on Heart Attack Prediction. In ACM MIR Conference, 2010.
[21]
R. Motwani et al. Query Processing, Approximation, and Resource Management in a Data Stream Management System. In CIDR Conference, 2003.
[22]
N. Tatbul et al. Load Shedding in a Data Stream Manager. In VLDB Conference, 2003.
[23]
N. Tatbul and S. Zdonik. Window-aware Load Shedding for Aggregation Queries over Data Streams. In VLDB Conference, 2006.
[24]
P. A. Tucker et al. Exploiting Punctuation Semantics in Continuous Data Streams. IEEE TKDE Journal, 15(3), 2003.
[25]
Y. Yang et al. HybMig: A Hybrid Approach to Dynamic Plan Migration for Continuous Queries. IEEE TKDE Journal, 19(3), 2007.
[26]
Y. Zhu et al. Dynamic Plan Migration for Continuous Queries over Data Streams. In ACM SIGMOD Conference, 2004.

Cited By

View all
  • (2018)ChiProceedings of the VLDB Endowment10.14778/3231751.323176511:10(1303-1316)Online publication date: 1-Jun-2018
  • (2018)Efficient Massive Medical Rules Parallel Processing AlgorithmsSmart Health10.1007/978-3-030-03649-2_17(179-184)Online publication date: 26-Oct-2018
  • (2017)Reflections on Almost Two Decades of Research into Stream ProcessingProceedings of the 11th ACM International Conference on Distributed and Event-based Systems10.1145/3093742.3095110(21-23)Online publication date: 8-Jun-2017
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '11: Proceedings of the 2011 ACM SIGMOD International Conference on Management of data
June 2011
1364 pages
ISBN:9781450306614
DOI:10.1145/1989323
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 12 June 2011

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. continuous query
  2. query lifecycle
  3. query modification

Qualifiers

  • Research-article

Conference

SIGMOD/PODS '11
Sponsor:

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)7
  • Downloads (Last 6 weeks)4
Reflects downloads up to 11 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2018)ChiProceedings of the VLDB Endowment10.14778/3231751.323176511:10(1303-1316)Online publication date: 1-Jun-2018
  • (2018)Efficient Massive Medical Rules Parallel Processing AlgorithmsSmart Health10.1007/978-3-030-03649-2_17(179-184)Online publication date: 26-Oct-2018
  • (2017)Reflections on Almost Two Decades of Research into Stream ProcessingProceedings of the 11th ACM International Conference on Distributed and Event-based Systems10.1145/3093742.3095110(21-23)Online publication date: 8-Jun-2017
  • (2017)Kafka versus RabbitMQProceedings of the 11th ACM International Conference on Distributed and Event-based Systems10.1145/3093742.3093908(227-238)Online publication date: 8-Jun-2017
  • (2014)MCEPACM Transactions on Internet Technology10.1145/263368814:1(1-24)Online publication date: 7-Aug-2014
  • (2013)Adaptive input admission and management for parallel stream processingProceedings of the 7th ACM international conference on Distributed event-based systems10.1145/2488222.2488258(15-26)Online publication date: 29-Jun-2013
  • (2012)Moving range queries in distributed complex event processingProceedings of the 6th ACM International Conference on Distributed Event-Based Systems10.1145/2335484.2335507(201-212)Online publication date: 16-Jul-2012
  • (2012)Scalable complex event processing on top of mapreduceProceedings of the 14th Asia-Pacific international conference on Web Technologies and Applications10.1007/978-3-642-29253-8_46(529-536)Online publication date: 11-Apr-2012

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media