Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

25 Vba Macros For Data Analysis In Microsoft Excel

Authors: Klemens Nguyen

1st Edition

B0CNSXYMTC, 979-8868455629

More Books

Students also viewed these Databases questions

Question

How project success is usually assessed?

Answered: 1 week ago

Question

Compute the derivative of f(x)cos(-4/5x)

Answered: 1 week ago

Question

Discuss the process involved in selection.

Answered: 1 week ago

Question

Differentiate tan(7x+9x-2.5)

Answered: 1 week ago

Question

Explain the sources of recruitment.

Answered: 1 week ago

Question

Differentiate sin(5x+2)

Answered: 1 week ago