To optimize disk /O cost, if you frequently have to access the pages of a file in sequential order. How would you lay those pages on disk? Consider the architecture of a typical modern disk consisting of platters, tracks, cylinders e
To optimize disk /O cost, if you frequently have to access the pages of a file in sequential order. How would you lay those pages on disk? Consider the architecture of a typical modern disk consisting of platters, tracks, cylinders e
Chapter12: Secondary Storage Management
Section: Chapter Questions
Problem 6RQ
Related questions
Question
Problem 27: a- To optimize disk /O cost, if you frequently have to access the pages of a file in sequential order. How would you lay those pages on disk? Consider the architecture of a typical modern disk consisting of platters, tracks, cylinders etc. b- In terms of what the disk has to do for each, what is the difference ‘between random and sequential /O? - To improve the performance of the query, choose an index configuration? Briefly justify your answer. SELECT * FROM employee WHERE Name = ‘Julien’ AND workingHours > 10 > Choose one and explain briefly why . - A hash index on < workingHours > . - An unclustered tree index on < workingHours > . -An unclustered tre index on . A clustered tree index on < workingHours, Name>
![Problem 27:
a- To optimize disk I/O cost, if you frequently have to access the
pages of a file in sequential order. How would you lay those pages
on disk? Consider the architecture of a typical modern disk
consisting of platters, tracks, cylinders etc.
b- In terms of what the disk has to do for each, what is the difference
between random and sequential I/O?
c- To improve the performance of the query, choose an index
configuration? Briefly justify your answer.
SELECT *
FROM employee
WHERE Name = 'Julien' AND workingHours > 10
Choose one and explain briefly why
.- A hash index on < workingHours >
- An unclustered tree index on < workingHours >
-An unclustered tree index on <Name>
A clustered tree index on < workingHours, Name>](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3e3fafef-f29b-4fe8-8b84-154d4084b786%2Fbe492cf2-29ee-4059-b1ab-a94ccc212301%2Fok86mq2_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Problem 27:
a- To optimize disk I/O cost, if you frequently have to access the
pages of a file in sequential order. How would you lay those pages
on disk? Consider the architecture of a typical modern disk
consisting of platters, tracks, cylinders etc.
b- In terms of what the disk has to do for each, what is the difference
between random and sequential I/O?
c- To improve the performance of the query, choose an index
configuration? Briefly justify your answer.
SELECT *
FROM employee
WHERE Name = 'Julien' AND workingHours > 10
Choose one and explain briefly why
.- A hash index on < workingHours >
- An unclustered tree index on < workingHours >
-An unclustered tree index on <Name>
A clustered tree index on < workingHours, Name>
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![C++ Programming: From Problem Analysis to Program…](https://www.bartleby.com/isbn_cover_images/9781337102087/9781337102087_smallCoverImage.gif)
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning