Modern disks often have their own main memory caches, typically about 1 MB, and use this to prefetch pages. The rationale for this technique is the em- pirical observation that, if a disk page is requested by some (not necessarily database!) application, 80% 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. Is this problem addressed by the DBMS buffer manager prefetching pages? Ex- plain.

Modern disks often have their own main memory caches, typically about 1 MB, and use this to prefetch pages. The rationale for this technique is the em- pirical observation that, if a disk page is requested by some (not necessarily database!) application, 80% 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. Is this problem addressed by the DBMS buffer manager prefetching pages? Ex- plain.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A database administrator can choose how many disks are organized into a single RAID 5 array. What are the trade-offs between having fewer disks versus more disks, in terms of cost, reliability, performance during failure, and performance during rebuild?
The number of disks that are clustered together in a single RAID 5 array may be specified by the database administrator. Is it better to have fewer disks or more disks? What are the trade-offs between having fewer disks and having more disks in terms of cost, durability, performance during failure, and performance during rebuild?
The database administrator may choose the number of disks to cluster in a RAID 5 array. More disks are better, or vice versa. What are the tradeoffs between having fewer drives and having more disks in terms of cost, durability, performance after a failure, and performance during a rebuild?
Your database uses a slotted page architecture. Each page is 4096 bytes and has a page header of 96 bytes, and each slot pointer in the page needs 2 bytes. Assuming an average record length of 100 bytes, estimate the number of pages required to store 10000 records, stating any assumptions and showing your calculation.
The number of disks that are put together in a single RAID 5 array may be specified by a database administrator. What are the trade-offs between having fewer disks vs having more disks in terms of cost, longevity, performance after failure, and performance during rebuilding?
The database administrator has the ability to choose the number of disks that will be clustered together in a single RAID 5 array to be used. Having more or fewer disks is preferable, or vice versa. When it comes to cost, durability, performance after a failure, and performance during a rebuild, what are the tradeoffs between having fewer drives and having more disks?
The number of disks that will be used in a single RAID 5 array may be specified by the database administrator. When it comes to cost, lifespan, performance after failure, and performance during rebuild, what are the trade-offs between having fewer discs vs. having more discs?
Suppose a file with 65536 records is organized using multi-level indexing as the file is ordered on a non-key field. Each record is 48 bytes long and the size of its key field is 4 bytes. The indexing is built on the key field of the file. The size of the disk block is 2 KB, and the block pointer size is 12 bytes. The file organization is unspanned. How many blocks will be required for the inner and outer index respectively in a multi-level index? 512 and 2 b) 512 and 4 e) 1024 and 4 d) 1024 and 8
In certain cases, databases may function well using just the outside tracks of magnetic disks. This kind of arrangement is known as "hot spots." Why would you want to do that, exactly?
To what end does it make more sense to store passwords in a hashed file as opposed to an encrypted database?
The database administrator may specify the number of disks in a single RAID 5 array. What are the trade-offs between having fewer discs vs having more discs in terms of cost, longevity, performance after failure, and performance during rebuild?
What would happen if the integrity of the references in a database were compromised? What are some of the most frequent errors that you make?