Explain the concept of a semi-join using an example

3.5kviews

written 7.7 years ago by

teamques10 ★ 67k

• modified 2.7 years ago

distributed databases

ADD COMMENT EDIT

1 Answer

26views

written 7.7 years ago by

teamques10 ★ 67k

The semi-Join of two relations R and S is denoted as R SJ_FS, where F is a formula which specifies a join predicate. A semi-join is derived from projection and join as follows:

enter image description here

where Attr(R) denotes the set of all attributes of R. Thus, the result of the semi-join is …

Create a free account to keep reading this post.

and 3 others joined a min ago.

ADD COMMENT EDIT

Please log in to add an answer.