0
42kviews
Describe conflict serializability and view serializability with examples.

Mumbai University > Computer Engineering > Sem 4 > Database Management System

Marks: 10 M

Year: Dec 2014, May 2014

3

Conflict Equivalence and Conflict Serializable Schedule

Conflict Equivalence :

Schedules are conflict equivalent if they can be transformed one into other by a sequence of non conflicting interchanges adjacent actions.

Conflict Serializable Schedule :

A Schedule is conflict serializable if it is conflict equivalent to any of serial schedule.

View Equivalent Schedule and View serializable schedule

View Equivalent Schedule :

Consider two schedules S1 and S2, they are said to be view equivalent if following conditions are true :

Initial read must be same. There are two transactions say Ti and Tj, The schedule S1 and S2 are view equivalent if in schedule S1, Ti reads A that has been updated by Tj, and in schedule S2, Ti must read A from Tj. i.e. write-read(WR) sequence must be same between S1 and S2. Final write operations should be same between S1 and S2. View serializable schedule :

A Schedule is view serializable if it is view equivalent to any serial schedule. The following two examples will illustrate how to find view equivalent schedule.


1 Answer
1
1.2kviews

A schedule is serializable if it is equivalent to a serial schedule.

  • Conflict serializability:

    • Instructions Ii and Ij, of transactions Ti and Tj respectively, conflict if and only if there exists some item P accessed by both Ii and Ij, and atleast one of these instructions wrote P.
    • Consider the …

Create a free account to keep reading this post.

and 4 others joined a min ago.

Please log in to add an answer.