The Community for Technology Leaders
Green Image
Issue No. 08 - August (2010 vol. 22)
ISSN: 1041-4347
pp: 1110-1125
Mihaela A. Bornea , Athens University of Economics and Business, Athens, Greece
Vasilis Vassalos , Athens University of Economics and Business, Athens, Greece
Yannis Kotidis , Athens University of Economics and Business, Athens, Greece
Antonios Deligiannakis , Technical University of Crete, Chania, Greece
Adaptive join algorithms have recently attracted a lot of attention in emerging applications where data are provided by autonomous data sources through heterogeneous network environments. Their main advantage over traditional join techniques is that they can start producing join results as soon as the first input tuples are available, thus, improving pipelining by smoothing join result production and by masking source or network delays. In this paper, we first propose Double Index NEsted-loops Reactive join (DINER), a new adaptive two-way join algorithm for result rate maximization. DINER combines two key elements: an intuitive flushing policy that aims to increase the productivity of in-memory tuples in producing results during the online phase of the join, and a novel reentrant join technique that allows the algorithm to rapidly switch between processing in-memory and disk-resident tuples, thus, better exploiting temporary delays when new data are not available. We then extend the applicability of the proposed technique for a more challenging setup: handling more than two inputs. Multiple Index NEsted-loop Reactive join (MINER) is a multiway join operator that inherits its principles from DINER. Our experiments using real and synthetic data sets demonstrate that DINER outperforms previous adaptive join algorithms in producing result tuples at a significantly higher rate, while making better use of the available memory. Our experiments also shows that in the presence of multiple inputs, MINER manages to produce a high percentage of early results, outperforming existing techniques for adaptive multiway join.
Query processing, join, DINER, MINER, streams.

M. A. Bornea, V. Vassalos, Y. Kotidis and A. Deligiannakis, "Adaptive Join Operators for Result Rate Optimization on Streaming Inputs," in IEEE Transactions on Knowledge & Data Engineering, vol. 22, no. , pp. 1110-1125, 2010.
82 ms
(Ver 3.3 (11022016))