19-physical

19-physical - Announcements (Tue. Nov. 15) Physical Data...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Physical Data Organization CPS 116 Introduction to Database Systems 2 Announcements (Tue. Nov. 15) ± Homework #3 sample solution available ± Homework #4 will not be officially assigned until next Tuesday ² But you can already start with 4.1 on Gradiance 3 Outline ± It’s all about disks! ² That’s why we always draw databases as ² And why the single most important metric in database processing is (oftentimes) the number of disk I/O’s performed ± Storing data on a disk ² Record layout ² Block layout 4 Storage hierarchy Registers Cache Memory Disk Tapes Why a hierarchy? 5 How far away is data? Location Cycles Registers 1 On-chip cache 2 On-board cache 10 Memory 100 Disk 10 6 Tape 10 9 Location Time My head 1 min. This room 2 min. Duke campus 10 min. Washington D.C. 1.5 hr. Pluto 2 yr. Andromeda 2000 yr. ) I/O dominates—design your algorithms to reduce I/O! (Source: AlphaSort paper, 1995) The gap has been widening! 6 A typical disk Spindle rotation Platter Platter Spindle Platter Tracks Arm movement Disk arm Disk head Cylinders “Moving parts” are slow
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 7 Top view Track Sectors “Zoning”: more sectors/data on outer tracks A block is a logical unit of transfer consisting of one or more sectors 8 Disk access time Sum of: ± Seek time: time for disk heads to move to the correct cylinder ± Rotational delay: time for the desired block to rotate under the disk head ± Transfer time: time to read/write data in the block
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 01/17/2012.

Page1 / 4

19-physical - Announcements (Tue. Nov. 15) Physical Data...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online