Is it guaranteed to be conflict-serializable

Assignment Help Basic Computer Science

Reference no: EM131210713

SQL-92 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 transactions in this class. Does the locking protocol for a given class make any assumptions about the locking protocols used for other classes? Explain briefly.

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?

3. Consider a schedule generated by the execution of several SQL transactions, each of which has READ ONLY access-mode. Is it guaranteed to be conflict-serializable? to be serializable? to be recoverable?

4. Consider a schedule generated by the execution of several SQL transactions, each of which has SERIALIZABLE isolation-level. Is it guaranteed to be conflict-serializable? to be serializable? to be recoverable?

5. Can you think of a timestamp-based concurrency control scheme that can support the eight classes of SQL transactions?

Reference no: EM131210713

Questions Cloud

How index locking resolves the preceding conflict : 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.

Determine total cost for each manufacturing special order : Set up the job cost sheets for Job No. J57 and Job No. K52. - Determine the total cost for each manufacturing special order for these jobs.

How would you monitor or evaluate process and progress : What would be the goals and objectives for some consultation or change effort? How would you facilitate goal setting and decision making in this organization? What are some possible interventions? How would you prioritize goals and interventions i..

Write an application that prompts a user for a month : Write an application that prompts a user for a month, day, and year. Display a message that specifies whether the entered date is not this year, in an earlier month this year, in a later month this year, or this month.

Is it guaranteed to be conflict-serializable : SQL-92 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.

Indicate if it is relevant or not to the related decision : Indicate if it is relevant or not to the related decision. For those costs determined to be irrelevant, briefly explain why.

What is the difference between stable storage and disk : How does the recovery manager ensure atomicity of transactions? How does it ensure durability?

Plot the run time of your bubblesort algorithm : CSE 310 - Data Structures and Algorithms - Plot the run time of your Bubblesort algorithm and your Quicksort algorithm on arrays of integers of size n = {101, 102, 103, 104, 105, 106} (

What are the properties required of lsns : What are the fields in an update log record? Explain the use of each field.

User Account

All Pages