Explain the impact on the disks cache of several queries

Reference no: EM13934238

I. Explain the term prefetching. Why is it important?

II. Modern disks often have their own main memory caches, typically about one MB, and use this to do prefetching of pages. The rationale for this technique is the empirical observation that if a disk page is requested by some (not necessarily database!) application, 80 percent of the time the next page is requested as well. So the disk gambles by reading ahead.

1. Give a nontechnical reason that a DBMS may not want to rely on prefetching controlled by the disk.

2. Explain the impact on the disk's cache of several queries running concurrently, each scanning a different file.

3. Can the above problem be addressed by the DBMS buffer manager doing its own prefetching? Explain.

4. Modern disks support segmented caches, with about four to six segments, each of which is used to cache pages from a different file. Does this technique help, with respect to the above problem? Given this technique, does it matter whether the DBMS buffer manager also does prefetching?

Reference no: EM13934238

Questions Cloud

What is sequential flooding of the buffer pool : What is sequential flooding of the buffer pool? Name an important capability of a DBMS buffer manager that is not supported by a typical operating system's buffer manager.

Determine the force required to open the valve : Determine the force required to open the valve - What length of cable CD is required for static equilibrium in the position shown? What is the tension T in cable CD?

Met the majority of criteria from critical appraisal tools : Describe if each of the sources according to the category (e.g. primary research studies, systematic reviews, and/or practice guidelines) met the majority of criteria from the Critical Appraisal Tools.

Does that make the practice ok : Does that make the practice OK? Should we just accept it as a nuisance and a necessary evil like solicitation calls during dinner?

Explain the impact on the disks cache of several queries : Explain the impact on the disk's cache of several queries running concurrently, each scanning a different file. Can the above problem be addressed by the DBMS buffer manager doing its own prefetching? Explain.

Importance of employee communication : The importance of employee communication today and its sources.

Goal programming approach to make decision : Given the information stated in Table 1 and your own criteria preferences, apply AHP to determine a priority ranking to make a decision which placement to take. Report the decision problem hierarchy, the pairwise comparison matrix, the priority ra..

What skills did the practitioner use to develop rapport : What skills did the practitioner use to develop rapport? Describe the behaviors of the interviewer that established or did not establish rapport.

If the majority of consumers are already skeptical : If the majority of consumers are already skeptical about most advertising they are exposed to, how do you think the general public would feel about such marketing campaigns?

User Account

All Pages