Data Mgmt Lab_Part_60 - 178 Chapter 17 3 Read all(records...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 178 Chapter 17 3. Read all (records on all) pages in file F 1. 4. Read pages P 500 through P 520. 5. Read pages P 10 through P 980. 6. Read all pages in F 1 and (based on the values read) modify 10 pages. 7. Delete record P 1200 : 98. (This is a blind write.) 8. Delete the first record from each page. (Again, these are blind writes.) 9. Delete all records. Answer 17.11 The answer to each question is given below. 1. IS on D; IS on F2; IS on P1200; S on P1200:5. 2. IS on D; IS on F2; IS on P1200, S on 1201 through 1204, IS on P1205; S on P1200:98/99/100, S on P1205:1/2. 3. IS on D; S on F1 4. IS on D; IS on F1; S on P500 through P520. 5. IS on D; S on F1 (performance hit of locking 970 pages is likely to be higher than other blocked transactions). 6. IS and IX on D; SIX on F1. 7. IX on D; IX on F2; X on P1200. (Locking the whole page is not necessary, but it would require some reorganization or compaction.) 8. IX on D; X on F1 and F2. (There are many ways to do this, there is a tradeoff between overhead and con- currency.) 9. IX on D; X on F1 and F2. Exercise 17.12 Suppose that we have only two types of transactions, T 1 and T 2....
View Full Document

This note was uploaded on 01/17/2012 for the course EGN 4302 taught by Professor Dr.vishak during the Fall '12 term at University of Central Florida.

Page1 / 3

Data Mgmt Lab_Part_60 - 178 Chapter 17 3 Read all(records...

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

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