A university stores its students relation as heap file in 111 pages. The DBMS that the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
a Between LRU Least Recently Used and MRU Most Recently Used replacement policies the DBMS should us... View the full answer
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date:
Students also viewed these programming questions
-
Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
You want to launch a business internationally, and you need to choose 3 countries1 in the Middle East, 1 in Asia, and 1 in Latin America. What are some of the components of these cultures that you...
-
Financial data for Redstone Company for last year appear below: The company paid dividends of $155,000 last year. The "Investment in Balsam Company" on the statement of financial position represents...
-
Cindy takes a Club Med vacation, the cost of which includes unlimited sports activities. With no extra charge for golf and tennis, Cindy allocates a total of 4 hours a day to these activities. a. How...
-
One of the many wonderful things about studying statistics is that graduate programs in statistics often pay their graduate students, which means that many graduate students in statistics are able to...
-
Selected financial data from the September 30 year-end statements of Kosanka Company are given below: Total assets . . . . . . . . . . . . . . . . . . . . . . . . . $5,000,000 Long-term debt (12%...
-
Show that cos 0 dw = , and deduce that E = B, where Eb is the black body radiation density in terms of frequency emitted normally from a surface, per unit area. Use Planck's law 2hv B(T) = c...
-
Is the error involved in using the Chvorinov approximation for solidification times greater for a sphere or for a cylinder of the same radius? For large castings or small? For metals of high or low...
-
Emma loans Austin $25,000 with interest compounded at a rate of 8 percent per year. How much will Austin owe Emma if he repays the loan at the end of 5 years?
-
A cranberry juice drink mix must contain at least 15.5 percent cranberry juice by volume for proper taste. Juice Company A sells an unprocessed juice that is 12.5 percent cranberry juice and 87.5...
-
What deposit today is required for it to be worth $150,000 in 25 years if the deposit earns 5 percent annual compound interest?
-
Vector Manufacturing (VM) makes replacement parts for the automotive industry. One particular part can be manufactured at a unit cost of \($0.75\) for material and \($0.25\) for direct labor....
-
On August 1, 1958, first-class postage for a 1-ounce envelope was 4. On August 1, 2007, a first-class stamp for the same envelope cost 41. What was the annual compound increase in the cost of...
-
After viewing the case study "Partnerships: You Sunk My Partnership" in You Be the Judge, complete the exercise there and determine whether you find for the plaintiff or the defendant. After you...
-
Marc Company assembles products from a group of interconnecting parts. The company produces some of the parts and buys some from outside vendors. The vendor for Part X has just increased its price by...
-
Consider the B+ tree index of order d = 2 shown in Figure 10.1. 1. Show the tree that would result from inserting a data entry with key 9 into this tree. 2. Show the B+ tree that would result from...
-
Consider the instance of the Sailors relation shown in Figure 5.1. 1. Write SQL queries to compute the average rating, using AVG; the sum of the ratings, using SUM; and the number of ratings, using...
-
Consider the following collection of relations and dependencies. Assume that each relation is obtained through decomposition from a relation with attributes ABCDEFGHI and that all the known...
-
An economist believes that the median income of lawyers who recently graduated from law school is more than \(\$ 64,000\). He queries a random sample of 12 lawyers and obtains the accompanying data....
-
One important variable to consider in trading stock is the daily volume. Volume is measured in number of shares traded in the stock. Stocks with lower volume tend to have more variability in the...
-
The median is different from 120. An analysis of the data reveals that there are 35 minus signs and 28 plus signs. Use the sign test to test the given alternative hypothesis at the \(\alpha=0.05\)...
Study smarter with the SolutionInn App