Skip to main content

Input-sensitive scalable continuous join query processing

Publication ,  Journal Article
Agarwal, PK; Xie, J; Yang, J; Yu, H
Published in: ACM Transactions on Database Systems
August 1, 2009

This article considers the problem of scalably processing a large number of continuous queries. Our approach, consisting of novel data structures and algorithms and a flexible processing framework, advances the state-of-the-art in several ways. First, our approach is query sensitive in the sense that it exploits potential overlaps in query predicates for efficient group processing. We partition the collection of continuous queries into groups based on the clustering patterns of the query predicates, and apply specialized processing strategies to heavily clustered groups (or hotspots). We show how to maintain the hotspots efficiently, and use them to scalably process continuous select-join, band-join, and window-join queries. Second, our approach is also data sensitive, in the sense that it makes cost-based decisions on how to process each incoming tuple based on its characteristics. Experiments demonstrate that our approach can improve the processing throughput by orders of magnitude. © 2009 ACM.

Duke Scholars

Published In

ACM Transactions on Database Systems

DOI

EISSN

1557-4644

ISSN

0362-5915

Publication Date

August 1, 2009

Volume

34

Issue

3

Related Subject Headings

  • Information Systems
  • 4609 Information systems
  • 4605 Data management and data science
  • 4009 Electronics, sensors and digital hardware
  • 0806 Information Systems
  • 0804 Data Format
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Agarwal, P. K., Xie, J., Yang, J., & Yu, H. (2009). Input-sensitive scalable continuous join query processing. ACM Transactions on Database Systems, 34(3). https://doi.org/10.1145/1567274.1567275
Agarwal, P. K., J. Xie, J. Yang, and H. Yu. “Input-sensitive scalable continuous join query processing.” ACM Transactions on Database Systems 34, no. 3 (August 1, 2009). https://doi.org/10.1145/1567274.1567275.
Agarwal PK, Xie J, Yang J, Yu H. Input-sensitive scalable continuous join query processing. ACM Transactions on Database Systems. 2009 Aug 1;34(3).
Agarwal, P. K., et al. “Input-sensitive scalable continuous join query processing.” ACM Transactions on Database Systems, vol. 34, no. 3, Aug. 2009. Scopus, doi:10.1145/1567274.1567275.
Agarwal PK, Xie J, Yang J, Yu H. Input-sensitive scalable continuous join query processing. ACM Transactions on Database Systems. 2009 Aug 1;34(3).

Published In

ACM Transactions on Database Systems

DOI

EISSN

1557-4644

ISSN

0362-5915

Publication Date

August 1, 2009

Volume

34

Issue

3

Related Subject Headings

  • Information Systems
  • 4609 Information systems
  • 4605 Data management and data science
  • 4009 Electronics, sensors and digital hardware
  • 0806 Information Systems
  • 0804 Data Format