Serializability

Question 1

When is a schedule Serializable?

Answer 1

when it is eqivalent to Serial Schedule
Serial schedule mai ek transaction khatm hone ke baad dusra shuru hota hai. (i.e no concurrency is allowed.)

Whereas in serializable schedules, multiple transactions can execute simultaneously i.e.
concurrency is allowed.

Question 2

Types of serializability

Answer 2

1.Conflict Serializibility.
2.View Serializibilty.

Question 3

conflict serializibility?

Answer 3

agar cycle/loop form nahi hora hai toh conflict serializable .
conflict pairs of r(x) is w(x) and conflict pair of w(x) are r(x) as well as w(x)

Question 4

View Serializibility?

Answer 4

Taking example and checking if it is serializable is sort of called view serializibilty.
also read L-25’s Database recovery topic

Question 5

Note:

Answer 5

1.Every conflict serializable is also view s