Conflict and view equivalence

Question

If two schedules are conflict equivalent then can we definitely say that they are also view equivalent?

Answer 1

Yes, all conflict serializable schedules are also view serializable but reverse is not true.

Comments

I meant that suppose there are two schedules S1 and S2 which are conflict equivalent to each other (Note: I am not mentioning that they are conflict serializable) now since we know that they are conflict equivalent can we directly conclude that they will be view equivalent also?

---

Actually to make(non-overlapping) transactions we use some concepts but first, we have to confirm that is it a serial schedule equivalent or not…

if it is serial then we can use the concept of view serializable equivalent and conflict serializable equivalent..

if we already know that it is not serial or only equivalent schedule there is no use of finding view and conflict equivalent..

So, there is no such relation of conflict equivalent dependency on view equivalent. It must be serializable.

---

i think this is  not true always .

Answer 2

$Conflict$ $equivalent$ $Schedules$ should be $Serial$ $Schedule$, &

$View$ $equivalent$ $Schedules$ should be $Serial$ $Schedule$

then we can conclude that

$All$ $Conflict$ $serializable$ $schedules$ $are$ $also$ $view$ $serializable$

We cannot directly determine

$View$ $equivalent$ schedule from $Conflict$ $equivalent$ Schedules, It MUST be  $Serial$ $Schedule$, 

Two schedules are said to be conflict equivalent if all the conflicting operations in both the schedule get executed in the same order

If a schedule is a conflict equivalent to its serial schedule then it is called Conflict Serializable Schedule

Conflict schedule should be serial schedule then we can conclude that is it View serializable equivalent or not.

A schedule is said to be View-Serializable if it is view equivalent to a Serial Schedule (where no interleaving of transactions is possible)