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 …
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
… 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. …
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
… semijoin, and join processing algorithms based on a new cluster-based join index. We focus
on three new R-join/R-semijoin … semijoin discussed in this work is different from the semijoin …
on three new R-join/R-semijoin … semijoin 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 …
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 …
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
… 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 …
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 …
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
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 …
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
… 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 …
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 …
R1 by … In other words, the semijoin retrieves all tuples of R that join with anytuple of R2. While …