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)
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.
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 know how many managers have a salary greater than their age we cannot estimate the communication costs for the third step.
You might also like to view...
Issues relating to minimum password length, password complexity, and password history are defined in which of the following?
A) Administrative policies B) User policies C) Computer policies D) Technical policies
Before publishing your final project, clear the ____ of unused items.
a. glossary b. index c. library d. baseline
Line charts typically display ________ on the vertical axis
Fill in the blank(s) with correct word
What social-engineering technique involves telling an employee that you're calling from the CEO's office and need certain information ASAP? (Choose all that apply.)
a. Urgency b. Status quo c. Position of authority d. Quid pro quo