Browse > Article
http://dx.doi.org/10.7472/jksii.2012.13.3.93

Preprocessing Method for Handling Multi-Way Join Continuous Queries over Data Streams  

Seo, Ki-Yeon (삼성전자 DMC 연구소)
Lee, Joo-Il (연세대학교 대학원 컴퓨터과학과)
Lee, Won-Suk (연세대학교 컴퓨터과학과)
Publication Information
Journal of Internet Computing and Services / v.13, no.3, 2012 , pp. 93-105 More about this Journal
Abstract
A data stream is a series of tuples which are generated in real-time, incessant, immense, and volatile manner. As new information technologies are actively emerging, stream processing methods are being needed to efficiently handle data streams. Especially, finding out an efficient evaluation for a multi-way join would make outstanding contributions toward improving the performance of a data stream management system because a join operation is one of the most resource-consuming operators for evaluating queries. In this paper, in order to evaluate efficiently a multi-way join continuous query, we propose a novel method to decrease the cost of a query by eliminating unsuccessful intermediate results. For this, we propose a matrix-based structure for monitoring data streams and estimate the number of final result tuples of the query and find out unsuccessful tuples by matrix multiplication operations. And then using these information, we process efficiently a multi-way join continuous query by filtering out the unsuccessful tuples in advance before actual evaluation of the query.
Keywords
data stream; query processing; join operation;
Citations & Related Records
연도 인용수 순위
  • Reference
1 D. J. Abadi, D. Carney, U. Centintemel, M. Cherniack, C. Convey, S. Lee, M. Stonebraker, N. Tatbul, S. Zdonik, "Aurora: A New Model and Architecture for Data Stream Management", VLDB Journal, vol.12, No.2, pp.120-139, 2003.   DOI   ScienceOn
2 B. Babcock, S. Babu, M. Datar, R. Motwani, "Chain: Operator Scheduling for Memory Minimization in Data Stream Systems", SIGMOD '03, June 2003.
3 The STREAM groups, "STREAM: The Stanford Stream Data Manager (short overview paper)", IEEE Data Engineering Bulletin, March 2003.
4 S. Chandrasekaran, O. Cooper, A. Deshpande, M. J. Franklin, J. M. Hellerstein, W. Hong, S. Krishnamurthy, S. Madden, V. Raman, V. Reiss, and M. Shah, "TelegraphCQ: Continuous Dataflow Processing for an Uncertain World", CIDR '03, Jan. 2003.
5 J.-H. Hwang, U. Cetintemel, and Stan Zdonik, "Fast and Highly-available Stream Processing over Wide Area Networks", ICDE '08, April 2008
6 S. Babu and J. Widom, "Continuous Queries over Data Streams", SIGMOD Record, vol.30, No.3, pp.109-120, 2001.   DOI
7 S. Madden, M. Shah, J. M. Hellerstein, and V. Raman, "Continuously Adaptive Continuous Queries over Streams", SIGMOD '02, June 2002.
8 R. Avnur and J. M. Hellerstein. "Eddies: Continuously Adaptive Query Processing", SIGMOD Record, vol.29, No.2, pp.261-272. 2000.   DOI
9 Babcock, S. Babu, M. Datar, R. Motwani, and J. Widom, "Models and Issue in Data Stream Systems", PODS '02, June 2002.
10 Y. Yang, D. Papadias, "Just-In Time Processing of Continuous Queries", ICDE '08, April 2008.
11 Y. Zhu, E. A. Rundensteiner, and G. T. Heineman, "Dynamic Plan Migration for Continuous Queries over Data Streams", SIGMOD '04, June 2004.
12 S. Viglas, J. F. Naughton, and J. Burger, "Maximizing the Output Rate of Multi-way Join Queries over Streaming Information Sources", VLDB '02, pp.285-296, Aug. 2003.
13 S. Babu, K. Munagala, J. Widom, and R. Motwani, "Adaptive Caching for Continuous Queries", ICDE '05, pp.118-129, April 2005.
14 L. Golab and M. T. Ozsu, "Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams", VLDB '03, Sep. 2003.
15 T. Urhan and M. J. Franklin. "XJoin: A Reactively-Scheduled Pipelined Join Operator", IEEE Data Engineering Bulletin, vol.23, No.2, pp.27-33, June 2000.
16 H.-S. Lim, J.-G. Lee, M.-J. Lee, K.-Y. Whang, "Continuous Query Processing in Data Streams using Duality of Data and Queries", SIGMOD '06, June 2006.
17 P. Bizarro, S. Babu, D. DeWitt, and J. Widom, "Content-based Routing: Different Plans for Different Data", VLDB '05, pp.757-768. Aug. 2005.
18 H.-H. Lee, E.-W. Yun, W.-S. Lee, "Attribute-based Evaluation of Multiple Continuous Queries for Filtering Incoming Tuples of a Data Stream", Information Sciences, vol.178, No.11 pp.2416-2432, June 2008   DOI