Question: 1 - Consider the natural join between two relations R ( A , B ) and S ( B , C ) with the schema

1-Consider the natural join between two relations R(A, B) and S(B, C) with the schema and data as shown
below:
A B
a1 b1
a2 b1
a3 b2
a4 b3
R
B C
b2 c1
b2 c2
b3 c3
S
That is, relation R has two attributes A and B, while relation S has two attributes B and C. Suppose the
natural join query is such that the output schema and result is:
A C
a3 c1
a3 c2
a4 c3
If the system uses map reduce to implement this query execution. What would be the key for the reduce
function?
Attribute B
Attribute A
Attribute C
Either the primary key of R or the primary key of S

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!