Affiliation:
1. INRIA and University of Paris VI
Abstract
This paper presents and analyzes algorithms for computing joins and semijoins of relations in a multiprocessor database machine. First, a model of the multiprocessor architecture is described, incorporating parameters defining I/O, CPU, and message transmission times that permit calculation of the execution times of these algorithms. Then, three join algorithms are presented and compared. It is shown that, for a given configuration, each algorithm has an application domain defined by the characteristics of the operand and result relations. Since a semijoin operator is useful for decreasing I/O and transmission times in a multiprocessor system, we present and compare two equi-semijoin algorithms and one non-equi-semijoin algorithm. The execution times of these algorithms are generally linearly proportional to the size of the operand and result relations, and inversely proportional to the number of processors. We then compare a method which consists of joining two relations to a method whereby one joins their semijoins. Finally, it is shown that the latter method, using semijoins, is generally better. The various algorithms presented are implemented in the SABRE database system; an evaluation model selects the best algorithm for performing a join according to the results presented here. A first version of the SABRE system is currently operational at INRIA.
Publisher
Association for Computing Machinery (ACM)
Cited by
119 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis;Proceedings of the VLDB Endowment;2023-07
2. Bitvector-aware Query Optimization for Decision Support Queries;Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data;2020-06-11
3. Data Search Using Hash Join Query and Nested Join Query;Journal of Physics: Conference Series;2019-11-01
4. Distributed Spatial and Spatio-Temporal Join on Apache Spark;ACM Transactions on Spatial Algorithms and Systems;2019-06-28
5. Semijoin Program;Encyclopedia of Database Systems;2018