Explain the method to find cost of sorting the relation

Assignment Help Computer Engineering

Reference no: EM132269

Question

Assume you want to sort a relation of 40 gigabytes,with 4 kilobyte blocks,using memory size of 40 megabytes. Assume cost of seek is 5 milliseconds, even as disk transfer rate is 40 megabytes per second.

a. Find cost of sorting the relation, in seconds, with bb = 1 and with bb = 100.

b. In each case, how many combine passes are required?

c. Assume a flash storage device is used instead of a disk, and it has a seek time of 1 microsecond, and a transfer rate of 40 megabytes per second.

Recomputed cost of sorting the relation, in seconds, with bb = 1 and with bb = 100, in the setting.

Reference no: EM132269

Questions Cloud

Explain what is meant by the term threshold limit values : Explain what is meant by the term Threshold Limit Values (TLVs). Describe briefly the different TLVs used by Industrial Hygienists. Outline the strengths and weaknesses of these occupational exposure limits and illustrate how they may best be u..

Determine technology which has changed cafe,coffee shop : Determine technology which has changed cafe,coffee shop? Think things such as marketing, food preparation, inventory ordering or re-ordering, customer tracking, and more.

What is the goal to exercises in the bluej textbook : What is the goal to exercises in the BlueJ textbook? For the remains of the course, you will answer the questions posed by BlueJ textbook-you will not require downloading an additional worksheet and filling it in as you did for first four units.

What are techniques for addressing security requirements : What are techniques for addressing security requirements? Which have a business relationship with the company?

Explain the method to find cost of sorting the relation : Explain the method to find cost of sorting the relation In each case, how many combine passes are required?

Analytical methods commonly used in industrial hygiene : Name two analytical methods commonly used in Industrial Hygiene. Illustrate your answer with two typical examples What are the four significant physical parameters that you would use to assess the thermal comfort of employees working in a hot and..

What is the specialization of Dottie's Tax facility : What is the specialization of Dottie's Tax facility At least 6 returns? (Round z-score computation to 2 decimal places and your final answer to 4 decimal places.)

What security measures required to address vulnerabilities : What security measures required to address vulnerabilities Illustrate threats and vulnerabilities that are possible after implementing "big data" technologies in online auctioning company.

How to set a rule that used by snort to detect an ack scan : How to set a rule that used by snort to detect an ACK scan What do you think Bro can do a better job detecting an ACK scan?

User Account

All Pages