Consider the following query. (The user is trying to read P1 from disk, then read P2,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following query. (The user is trying to read P1 from disk, then read P2, Write P3, ..., commit at the end.) Read P1, Read P2, Write P3, Write P4, Write P5, Read P5, Read P2, Read P4, Commit. Every time when reading or writing a page that is not in the buffer pool, the page needs to be fetched from the disk first. Assume that writing a page follows the same rule as reading a page. The only difference is, if a page that has been written in the buffer pool is going to be replaced, then it has to be written to disk before replacement. Each fetch from disk or write to disk is considered as an equal-cost disk access. Assume there are 3 buffers in the buffer pool. 1. Sketch the process of how blocks are replaced in the Least Recently Used (LRU) policv. What is the number of page fault and disk access? Justify your answer. 2. Sketch the process of how blocks are replaced in the Most Recently Used (MRU) policy. What is the number of page fault and disk access? Justify your answer. 3. Between the LRU and MRU policies above, which one performs better in the given query? Justify you answer. Consider the following query. (The user is trying to read P1 from disk, then read P2, Write P3, ..., commit at the end.) Read P1, Read P2, Write P3, Write P4, Write P5, Read P5, Read P2, Read P4, Commit. Every time when reading or writing a page that is not in the buffer pool, the page needs to be fetched from the disk first. Assume that writing a page follows the same rule as reading a page. The only difference is, if a page that has been written in the buffer pool is going to be replaced, then it has to be written to disk before replacement. Each fetch from disk or write to disk is considered as an equal-cost disk access. Assume there are 3 buffers in the buffer pool. 1. Sketch the process of how blocks are replaced in the Least Recently Used (LRU) policv. What is the number of page fault and disk access? Justify your answer. 2. Sketch the process of how blocks are replaced in the Most Recently Used (MRU) policy. What is the number of page fault and disk access? Justify your answer. 3. Between the LRU and MRU policies above, which one performs better in the given query? Justify you answer.
Expert Answer:
Answer rating: 100% (QA)
To analyze the LRU Least Recently Used and MRU Most Recently Used buffer replacement policies well simulate the process step by step for the given que... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
The Exotic Bites Restaurant is a high-end dining establishment specialising in exotic cuisine worldwide. The restaurant has two main menus, the International Menu and the Local Menu. Each menu has...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
What are the energies of the two longest-wavelength lines in the Paschen series for hydrogen? What are the corresponding wavelengths? Give your answers to two significant figures.
-
(a) If a thin liquid film floating on water has an index of refraction less than that of water, will the film appear bright or dark in reflected light as its thickness goes to zero? (b) Choose the...
-
A suitcase (mass m = 16 kg) is resting on the floor of an elevator. The part of the suitcase in contact with the floor measures 0.50 m 0.15 m. The elevator is moving upward with an acceleration of...
-
Which of the following is a characteristic of auditing? a. Auditing is a systematic, step-by-step process. b. Auditing involves the collection and review of evidence. c. Auditing involves the use of...
-
In mid-February 2016, European-style options on the S&P 100 index (OEX) expiring in December 2017 were priced as follows: Dec 2017 OEX Index Options Strike Price..........Call Price..............Put...
-
Identify the tasks below with the public accounting job area [Auditing, Taxation or Management Consulting] with which it is best associated. a. b. C. d. e. Tasks Installing accounting software....
-
Presented below are annual coupon rates, yield rates, and expected duration for a series of debentures. Calculate the issuance price for each debenture assuming that the face value of each bond is...
-
Question 19 ArrayList - Coding Goal: Given the following ArrayList class, which is an ArrayList with a backingArray and a size variable (the same as your homework), implement the addAll(T[] arr, int...
-
https://youtu.be/Dy9EqjHf2zw ( Nike's Rise of the Kids | Sport Is Never Done | Nike) Commercial. 1) Discuss what makes this advertisement special, and why did you choose it? 2)How does it connect...
-
The historical background of the term human resource in the last 80 years of the twentieth century, both the scientific management and the human relation approach have appeared and declined." Provide...
-
Briefly differentiate between a tradeshow and consumer show. Provide an example of each that you or a family member may have attended. Exhibiting in a tradeshow can be very costly. Over and above the...
-
An RC circuit is powered by an alternating voltage source oscillating with angular frequency 7.4 rad/s. It is connected in series to a 8.4 ohm resistor and a 5.8 CF capacitor. In degrees, what is the...
-
The following data pertain to Lawn Master Corporation's top-of-the-line lawn mower. Variable manufacturing cost Applied fixed manufacturing cost $279 59 Variable selling and administrative cost 62...
-
what ways do cultural hegemony and power dynamics influence the production, dissemination, and consumption of cultural artifacts, including literature, art, music, and media?
-
What recommendations would you make to Big Four firms to help them (1) avoid confrontations with governmental officials in an authoritarian society and (2) deal effectively with such confrontations...
-
Show that any two rows of a matrix can be interchanged by elementary row transformations of the other two types.
-
Find the general solution to f + f = 2.
-
Let A denote an n à n upper triangular matrix. (a) If all the main diagonal entries of A are distinct, show that A is diagonalizable. (b) if all the main diagonal entries of A are equal, show...
-
Richard, Inc., which closes its books on December 31, is authorized to issue \(\$ 600,000\) of six percent, 20 -year bonds dated March 1, with interest payments on September 1 and March 1. Required...
-
The following data are from the current accounting records of Crest Company: The president of the company is concerned that the company may be in violation of a debt covenant that requires the...
-
On December 31, 2018, Edmand, Inc., issued \(\$ 750,000\) of 11 percent, five-year bonds for \(\$ 722,400\), yielding an effective interest rate of 12 percent. Semiannual interest is payable on June...
Study smarter with the SolutionInn App