Site 1 Site 2 Site 3 Relation Card Tuple Stze Rel Size 40 4000 100 R2 50 15000 300 500 30 Q11283625

– Semijoin Exercise

I. Site 1 Site 2 Site 3 Relation Card Tuple stze R

I. Site 1 Site 2 Site 3 Relation Card Tuple stze Rel Size 40 4000 100 R2 50 15000 300 500 30 150 00 Attribute SFs Size (proj a) List all possible semijoins 04 500 R1.A b) Calculate the benefit of each possible semijoin R2.A 0.7 900 0.3 600 R2.B c) Which is the most beneficial semijoin 1.0 1000 R3.B Show transcribed image text I. Site 1 Site 2 Site 3 Relation Card Tuple stze Rel Size 40 4000 100 R2 50 15000 300 500 30 150 00 Attribute SFs Size (proj a) List all possible semijoins 04 500 R1.A b) Calculate the benefit of each possible semijoin R2.A 0.7 900 0.3 600 R2.B c) Which is the most beneficial semijoin 1.0 1000 R3.B

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *