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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started