Question: Assume you have a distributed database system, The data base is partitioned in different sites. You have a query that select students name, and department

Assume you have a distributed database system, The data base is partitioned in different sites. You have a query that select students name, and department name. The students table is stored in site1, and the department name is stored in site2. The query is fired from site2. The result of this query will contain 100 entries, and each entry is 30 bytes. Therefore, the result size is [A] bytes. There are 20 rows in the department table, and each row is 1000 bytes. Therefore, the department table size is [B] bytes. There are 100 entries in the students table, and each entry is 1000 bytes. Therefore, the students table size is [C] bytes. There are 2 strategies to process the query: Send department table to site1, process the query in site 1 and send the result back to site2. The cost is department table + result, which is =[D] bytes. Send students table from site1 to site2 and process the query there. The cost will be [E] bytes. Better strategy is [F], because it costs less data to transfer through the network.

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!