Join and semijoin algorithms for a multiprocessor database machine

P Valduriez, G Gardarin - ACM Transactions on Database Systems …, 1984 - dl.acm.org
… 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

Combining joint and semi-join operations for distributed query processing

MS Chen, PS Yu - IEEE Transactions on Knowledge and Data …, 2002 - ieeexplore.ieee.org
… and RI is called the reducee of the semi-join. To simplify the notation, we use R, + RI to
mean a semi-join from R, to RI in the case the semi-join attribute does not have to be specified. …

Graph pattern matching: A join/semijoin approach

J Cheng, JX Yu, SY Philip - IEEE Transactions on Knowledge …, 2010 - ieeexplore.ieee.org
semijoin, and join processing algorithms based on a new cluster-based join index. We focus
on three new R-join/R-semijoinsemijoin discussed in this work is different from the semijoin

[PDF][PDF] Using semi-joins to solve relational queries

PA Bernstein, DMW Chiu - Journal of the ACM (JACM), 1981 - dl.acm.org
… by which S is reduced by the semi-join. The SDD-I algorithm uses a … have provided a
hardware semi-join instruction that they … In this paper we examine the question of which semi-join

Semi-join algorithms for multiprocessor systems

P Valduriez - Proceedings of the 1982 ACM SIGMOD international …, 1982 - dl.acm.org
semi-join operator in improving the performance of joins by replacing the join of two relations
by the join of their semi-join … In the following, we assume that a semi-join or join operation is …

[PDF][PDF] A methodology for interpreting tree queries into optimal semi-join expressions

DM Chiu, YC Ho - Proceedings of the 1980 ACM SIGMOD international …, 1980 - dl.acm.org
… We shall call any sequence of semi-join operations a program (or strategy). Our problem
then is to study semi-join programs that help solve relational queries in an "optimal" fashion …

From relation algebra to semi-join algebra: An approach for graph query optimization

J Hellings, CL Pilachowski, D Van Gucht… - Proceedings of the 16th …, 2017 - dl.acm.org
… Using the semi-join operators we can rewrite the above expression … semi-join has also been
studied in the context of the multiset relational algebra [23]. This focus on using the semi-join

Using combination of join and semijoin operations for distributed query processing

MS Chen, PS Yu - Proceedings., 10th International Conference on …, 1990 - computer.org
A combination of join and semijoin operations is applied to minimize the communication
cost for distributed query processing. A formula is developed to estimate the cardinality of a …

[PDF][PDF] Interleaving a join sequence with semijoins in distributed query processing

MS Chen, PS Yu - IEEE Transactions on Parallel and Distributed …, 1992 - academia.edu
… Thus, as in most prior work 1] 3], we assume in this paper the cardinality of a non-semijoin
attribute remains the same after a semijoin operation to simplify our discussion. In addition, to …

Power of natural semijoins

PA Bernstein, N Goodman - SIAM Journal on Computing, 1981 - SIAM
… a relational operator called a semijoin. A semijoin is "half ofa join’’2" the semijoin of relation
R1 by … In other words, the semijoin retrieves all tuples of R that join with anytuple of R2. While …