Parallel Processing of Temporal Anti-Joins in Memory

被引:0
|
作者
Reppas, Ioannis [1 ]
Mirabi, Meghdad [1 ,2 ]
Fathi, Leila [1 ]
Binnig, Carsten [1 ,2 ]
Dignos, Anton [3 ]
Gamper, Johann [3 ]
机构
[1] Tech Univ Darmstadt, Darmstadt, Germany
[2] German Res Ctr Artificial Intelligence DFKI, Darmstadt, Germany
[3] Free Univ Bozen Bolzano, Bolzano, Italy
来源
DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PT I, DASFAA 2024 | 2024年 / 14850卷
关键词
Temporal Anti-Join; Main Memory; Parallel Processing;
D O I
10.1007/978-981-97-5552-3_6
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Efficient and scalable processing of temporal anti-joins remains a significant research challenge in temporal databases. To address this issue, this paper introduces a novel temporal primitive designed for transforming a temporal anti-join, including conjunctive equality predicates on non-temporal attributes, into an equivalent algebraic expression involving a temporal inner join. The rationale behind this transformation is that the new expression can be decomposed into subtasks, allowing for parallel execution across multiple CPUs. Experimental results using real-world datasets demonstrate the superior efficiency and scalability of our solution for in-memory processing compared to existing solutions.
引用
收藏
页码:86 / 102
页数:17
相关论文
共 50 条
  • [1] OVI-3: A NoSQL visual query system supporting efficient anti-joins
    El-Mahgary, Sami
    Soisalon-Soininen, Eljas
    Orponen, Pekka
    Ronnholm, Petri
    Hyyppa, Hannu
    JOURNAL OF INTELLIGENT INFORMATION SYSTEMS, 2023, 60 (03) : 777 - 801
  • [2] OVI-3: A NoSQL visual query system supporting efficient anti-joins
    Sami El-Mahgary
    Eljas Soisalon-Soininen
    Pekka Orponen
    Petri Rönnholm
    Hannu Hyyppä
    Journal of Intelligent Information Systems, 2023, 60 : 777 - 801
  • [3] FAST PARALLEL ALGORITHMS FOR PROCESSING OF JOINS
    SHASHA, D
    SPIRAKIS, P
    LECTURE NOTES IN COMPUTER SCIENCE, 1988, 297 : 939 - 953
  • [4] A New Primitive for Processing Temporal Joins
    Mirabi, Meghdad
    Fathi, Leila
    Dignos, Anton
    Gamper, Johann
    Binnig, Carsten
    PROCEEDINGS OF 2023 18TH INTERNATIONAL SYMPOSIUM ON SPATIAL AND TEMPORAL DATA, SSTD 2023, 2023, : 106 - 109
  • [5] Parallel In-Memory Evaluation of Spatial Joins
    Tsitsigkos, Dimitrios
    Bouros, Panagiotis
    Mamoulis, Nikos
    Terrovitis, Manolis
    27TH ACM SIGSPATIAL INTERNATIONAL CONFERENCE ON ADVANCES IN GEOGRAPHIC INFORMATION SYSTEMS (ACM SIGSPATIAL GIS 2019), 2019, : 516 - 519
  • [6] Efficient Parallel Processing of Semantic Trajectory Similarity Joins
    Shang, Shuo
    Huang, Chengrui
    Chen, Lisi
    IEEE INTERNET OF THINGS JOURNAL, 2025, 12 (04): : 3534 - 3548
  • [7] Outer and Anti Joins in Temporal-Probabilistic Databases
    Papaioannou, Katerina
    Theobald, Martin
    Bohlen, Michael
    2019 IEEE 35TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2019), 2019, : 1742 - 1745
  • [8] Parallel processing of spatial joins using R-trees
    Brinkhoff, T
    Kriegel, HP
    Seeger, B
    PROCEEDINGS OF THE TWELFTH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, 1996, : 258 - 265
  • [9] Processing temporal aggregates in parallel
    Ye, XF
    Keane, JA
    SMC '97 CONFERENCE PROCEEDINGS - 1997 IEEE INTERNATIONAL CONFERENCE ON SYSTEMS, MAN, AND CYBERNETICS, VOLS 1-5: CONFERENCE THEME: COMPUTATIONAL CYBERNETICS AND SIMULATION, 1997, : 1373 - 1378
  • [10] Efficient Processing of Spatio-Temporal Joins on IoT Data
    Lee, Ki Yong
    Seo, Minji
    Lee, Ryong
    Park, Minwoo
    Lee, Sang-Hwan
    IEEE ACCESS, 2020, 8 : 108371 - 108386