Reference no: EM131197451
Explain the term memory hierarchy. What are the differences between primary, secondary, and tertiary storage? Give examples of each. Which of these isvolatile, and which are persistent? Why is persistent storage more important for a DBMS than, say, a program that generates prime numbers? (Section 9.1)
Why are disks used so widely in a DBMS? What are their advantages over main memory and tapes? What are their relative disadvantages? (Section 9.1.1)
What is a disk block or page? How are blocks arranged in a disk? How does this affect the time to access a block? Discuss seek time, rotational delay, andtransfer time. (Section 9.1.1)
Explain how careful placement of pages on the disk to exploit the geometry of a disk can minimize the seek time and rotational delay when pages are read sequentially. (Section 9.1.2)
Explain what a RAID system is and how it improves performance and reliability. Discuss striping and its impact on performance and redundancy and its impact on reliability. What are the trade-offs between reliability Page 334and performance in the different RAID organizations called RAID levels?(Section 9.2)
What is the role of the DBMS disk space manager? Why do database systems not rely on the operating system instead? (Section 9.3)
Why does every page request in a DBMS go through the buffer manager? What is the buffer pool? What is the difference between a frame in a buffer pool, a page in a file, and a block on a disk? (Section 9.4)
What information does the buffer manager maintain for each page in the buffer pool? What information is maintained for each frame? What is the significance of pin_count and the dirty flag for a page? Under what conditions can a page in the pool be replaced? Under what conditions must a replaced page be written back to disk? (Section 9.4)
Why does the buffer manager have to replace pages in the buffer pool? How is a page chosen for replacement? What is sequential flooding, and what replacement policy causes it? (Section 9.4.1)
A DBMS buffer manager can often predict the access pattern for disk pages. How does it utilize this ability to minimize I/O costs? Discuss prefetching. What is forcing, and why is it required to support the write-ahead log protocol in a DBMS? In light of these points, explain why database systems reimplement many services provided by operating systems. (Section 9.4.2)
Computing the constant acceleration
: A balloon starts rising from ground from rest at some constant acceleration.After some time, a stone is dropped from it.If the stone reaches the ground in the same time in which balloonn reached the dropping point from ground,find yhe acceleration..
|
Probability that one specific firm gets at least one firm
: A corporation has two construction contracts that are to be assigned to one or more of three firms (say I, II, and III) bidding for these contracts. (One firm could receive both contracts.)
|
Velocity of the boat with respect to the ground
: The velocity of a boat with respect to the water is 4.0 m/s at an angle of 30.0 degrees NORTH of EAST. The velocity of the water with respect to the ground is 3.0 m/s at an angle of 90.0 degrees NORTH of EAST. What is the velocity of the boat with..
|
What is the value of petabytestorage
: ITECH 2201 Cloud Computing - What is the value of petabytestorage and what is the percent of the data in the world today that has been created in the past two years?
|
Explain the term memory hierarchy
: Explain the term memory hierarchy. What are the differences between primary, secondary, and tertiary storage? Give examples of each. Which of these isvolatile, and which are persistent? Why is persistent storage more important for a DBMS than, say..
|
What are your recommendations on choice of country
: What is the projected savings for the firm? What is the new cost of goods sold percent of sales for each of the countries? What are your recommendations on choice of country? How can your firm arrange the business to be most profitable?
|
What will you do to develop customer loyalty
: Customer relationship management (CRM) is the process of managing detailed information about individual customers and carefully managing all of the customer touch points to maximize customer loyalty. As the manager of a newly opened resort hotel, ..
|
State whether changes will affect supply or demand
: In an analysis of the market for paint, an economist discovers the facts listed below.- State whether each of these changes will affect supply or demand, and in what direction.
|
Find the probability that it came from line i
: If a motor is randomly selected from the stockroom and found to be defective, find the probability that it came from line I.
|