Data Mgmt Lab_Part_59 - Concurrency Control 175...

Info iconThis preview shows pages 1–3. 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 Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Concurrency Control 175 Serializable Conservative 2PL Strict 2PL 2PL Timestamp W/O TWR Timestamp With TWR Optimistic Multiversion Conflict-serializable Figure 17.3 and on the following update command: replace (salary = 1.1 * EMP.salary) where EMP.ename = ‘Santa’ 1. Give an example of a query that would conflict with this command (in a concur- rency control sense) if both were run at the same time. Explain what could go wrong, and how locking tuples would solve the problem. 2. Give an example of a query or a command that would conflict with this command, such that the conflict could not be resolved by just locking individual tuples or pages but requires index locking. 3. Explain what index locking is and how it resolves the preceding conflict. Answer 17.8 Answer omitted. Exercise 17.9 SQL supports four isolation-levels and two access-modes, for a total of eight combinations of isolation-level and access-mode. Each combination implicitly defines a class of transactions; the following questions refer to these eight classes: 1. For each of the eight classes, describe a locking protocol that allows only transac- tions in this class. Does the locking protocol for a given class make any assump- tions about the locking protocols used for other classes? Explain briefly. 176 Chapter 17 2. Consider a schedule generated by the execution of several SQL transactions. Is it guaranteed to be conflict-serializable? to be serializable? to be recoverable?guaranteed to be conflict-serializable?...
View Full Document

{[ snackBarMessage ]}

Page1 / 3

Data Mgmt Lab_Part_59 - Concurrency Control 175...

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