Question: Let relations r1 (A, B, C), r2 (C, D, E), output= r1 r2 have the following properties: r1 has 20,000 tuples, r2 has 45,000 tuples,

Let relations r1 (A, B, C), r2 (C, D, E), output= r1 r2 have the following properties: r1 has 20,000 tuples, r2 has 45,000 tuples, 25 tuples of r1 fit on one page, and 30 tuples of r 2 fit on one page. Each tuple of r1 joins with exactly with 1 tuple of r2 and 10 tuples of output fit on one page. Estimate the number of page transfers required, using an index nested loop join.

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 Databases Questions!

Consider the relations r1 (A, B, C), r2 (C, D, E), and r3 (E, F) of Exercise. Assume that there are no primary keys, except the entire schema. Let V (C, r1) be 900, V (C, r2) be 1100, V (E, r2) be...

Let relations r1 (A, B, C) and r2 (C, D, E) have the following properties: r1 has 20,000 tuples, r2 has 45,000 tuples, 25 tuples of r1 fit on one block, and 30 tuples of r2 fit on one block. Estimate...

Let the relations r_1(A, B, C) and r_2(C, D, E) have the following properties: r_1 has 20,000 tuples, r_2 has 45,000 tuples, 25 tuples of r_1 fit on one block, and 30 tuples of r_2 fit on one block....

4 . ( 1 0 pts ) Let relations r 1 ( A , B , C ) and r 2 ( C , D , E ) have the following properties: r 1 has 2 0 , 0 0 0 tuples, r 2 has 4 5 , 0 0 0 tuples, 2 5 tuples of r 1 fit on one block, and 3...

(Query Processing) Let relation r1(A,B,C) and r2(C,D,E) have the following properties: r1 has 40000 tuples, r2 has 30000 tuples, 20 tuples of r1 fit on one block, and 10 tuples of r2 fit on one...

Let relations r 1 ( A , B , C ) and r 2 ( C , D , E ) have the following properties: r 1 has 2 0 , 0 0 0 tuples, r 2 has 4 5 , 0 0 0 tuples, 2 5 tuples of r 1 fit on one block, and 3 0 tuples of r 2...

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

Ethical and responsible decision-making is necessary for risk management and to avoid lawsuits. What does this reference to corporate governance imply? A. Disclosure and transparency B. Integrity and...

00:13 CS353 Spring 2019 Homework 2 Due: 6 March, Wednesday till 17:00 Q.1 (36 points) Consider the university database schema below STUDENT(s id, s name, address, status) PROFESSOR(p_id. p_name,...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

The following data are the distances between 20 retall stores and a large distribution center. The distances are in miles. 29; 31; 39; 40; 58; 67; 68; 69; 76; 87; 89; 95; 96; 96; 99; 106; 112; 127;...

CASH FLOWS FROM INVESTING AND FINANCING ACTIVITIES Hansen Company's comparative balance sheets as of December 31, 20-2 and 20-1, showed the following with regard to investing and financing...

5 points Item 2 6 Which taxpayer would not be considered a material participant of an activity? Multiple Choice Taxpayer materially participated in the activity for any five of the preceding 1 0...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What are the Variable columns settings available in the Mining Models Tab?

What does the Mining Content Viewer in Visual Studio show in terms of Probabilities?

How are continuous variables normally handled in Decision Tree Algorithms?