Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A university stores its students relation as heap file in 111 pages. The DBMS that the university uses has a total of 110 buffer

 

A university stores its students relation as heap file in 111 pages. The DBMS that the university uses has a total of 110 buffer pages and all buffer pages are initially empty. Consider the following query: SELECT FROM Student; which is executed frequently by the administrator and this is the only query that is executed in the DBMS. * a. (5 Points) Between LRU and MRU, which replacement policy should be used by the DBMS in order to minimize the number of I/Os? Explain why. b. (5 Points) Should the database administrator creates an index to speed up the query execution? If yes, which index structure should be used and why? If no, why not?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

a Between LRU Least Recently Used and MRU Most Recently Used replacement policies the DBMS should us... 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

Database management systems

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

3rd edition

72465638, 978-0072465631

More Books

Students also viewed these Programming questions

Question

S xsin ( x ) cos ( x ) dx

Answered: 1 week ago

Question

List four equivalent forms for the rational expression. x-2 x+9

Answered: 1 week ago