arrow
返回

Stream-aware indexing for distributed inequality join processing

delete2024-11-01
delete0
PRE
AI
A
Adeel Aslam *
G
Giovanni Simonini
L
Luca Gagliardelli
L
Luca Zecchini
S
Sonia Bergamaschi
DOI:10.1016/j.is.2024.102425delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
Inequality join is an operator to join data on inequality conditions and it is a fundamental building block for applications. While methods and optimizations exist for efficient inequality join in batch processing, little attention has been given to its streaming version, particularly to large-scale data-intensive applications that run on Distributed Stream Processing Systems (DSPSs). Designing an inequality join in streaming and distributed settings is not an easy task: (i) indexes have to be employed to efficiently support inequality-based comparisons, but the continuous stream of data imposes continuous insertions, updates, and deletions of elements in the indexes-hence a huge overhead for the DSPSs; (ii) oftentimes real data is skewed, which makes indexing even more challenging. To address these challenges, we propose the Stream-Aware inequality join (STA), an indexing method that can reduce redundancy and index update overhead. STA builds a separate in-memory index structure for hotkeys, i.e., the most frequently used keys, which are automatically identified with an efficient data sketch. On the other hand, the cold keys are treated using a linked set of index structures. In this way, STA avoids many superfluous index updates for frequent items. Finally, we implement four state-of-the-art inequality join solutions for a widely employed DSPS (Apache Storm) and compare their performance with STA on four realworld data sets and a synthetic one. The results of our experimental evaluation reveal that our stream-aware approach outperforms existing solutions.
Keyword:
Distributed stream processing system
Inequality join
B plus tree indexing
Augmented sketch
Skewed data distribution

期刊

Enterprise Information Systems 封面图
Enterprise Information Systems
IF:
3.9
论文数:
2.8K
被引数:
1.8K

机构

U
universita di modena e reggio emilia
学者数:
1.6W
论文数: 1.2W
被引数: 12
引用论文

引用论文

Plasma kisspeptin levels are elevated in cord blood and present sexual dimorphism in the adult population: Relation with leptin, gonadotropins and anthropometrical data
err2011-05-01
err0
PREAI
errJimena Pita; Sandra Rado-Peralta; Teresa Gavela-Pérez; Isabel Aragón; Vicente Barrios; Adela Rovira; Jesús Argente; Leandro Soriano-Guillén
err分享
err收藏
Clinically Meaningful Use of Blood Tumor Markers in Oncology
err2016-01-01
err0
errOAAI
errStefan Holdenrieder; Lance Pagliaro; David Morgenstern; Farshid Dayyani
err分享
err收藏
ScaleJoin: A Deterministic, Disjoint-Parallel and Skew-Resilient Stream Join
err2021-06-01
err16
PREAI
errGulisano, Vincenzo; Nikolakopoulos, Yiannis; Papatriantafilou, Marina; Tsigas, Philippas
err分享
err收藏
A Fully Integrated 32 Gbps 2x2 LoS MIMO Wireless Link with UWB Analog Processing for Point-to-Point Backhaul Applications
err2020-08-01
err0
PREAI
errMahmoud Sawaby; Baptiste Grave; Clement Jany; Cheng Chen; Siavash Kananian; Pierino Calascibetta; Frederic Gianesello; Amin Arbabian
err分享
err收藏
学者 查看更多内容