where Emp21 is stored at site B and Emp22 is stored at site C. A query at site A wants the names of all managers in the accounting department whose salary is greater than their age. Design a plan for this query, using the assumptions on page 704 for table and attribute sizes. Assume that the items in the Age column are two bytes long.

Suppose that we have a relation
Employee2 (SSnum, Name, Salary, Age, Title, Location)
which is partitioned as
Emp21 (SSnum, Name, Salary)
Emp22 (SSnum, Title, Age, Location)

What will be an ideal response?


1. At site C performs a SELECT statement that returns the SSnum and Age of all
employees for which Title = ‘Manager’. Call this table T1
2. Send T1 to site B. Since there are 50 managers, the total amount of information that must be sent is 50 ? (9 + 6) or 750 bytes
3. At site B, perform the join of T1 with Emp21, select those names whose salary is greater than their age, and send the result to site A.
Since we do not knowhowmany managers have a salary greater than their age we cannot estimate the communication costs for the third step.

Computer Science & Information Technology

You might also like to view...

Prototypes for the character-handling functions are included in the ____ header file.

A. iostream B. cctype C. cstdlib D. iomanip

Computer Science & Information Technology

Why is it important to maintain the link to the original file after you import a

graphic? What will be an ideal response?

Computer Science & Information Technology

The capacity of UPS devices is measured using the voltage output rating.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which of the following is an example of tacit knowledge?

a. A teacher dictating the process of photosynthesis from a book to her students b. The contacts of the logistics and network service providers of an organization c. The list of electrical and electronics patents of scientists from South America. d. An engineer drawing on past experience to simplify a piece of code

Computer Science & Information Technology