The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
0 votes
statement -1: concurrent schedule which is equivalent to some serial schedule is said to be concurrent serializable schedule.

statement 2:concurrent schedule which is not concurrent serializable schedule  may be consistent.

correct statement is ??

i know statement (1) is correct what about statement(2)???
asked in Databases by Active (2.2k points) | 32 views
We know that, only serial schedules are consistent... A concurrent serializable schedule means it is equivalent to some serial schedule. If concurrent schedule is not a concurrent serializable then it must be not equivalent to any serial schedule...
yes,i agree but my doubt is if concurrent schedule which is not concurrent serializable it will be consistent or not ???

in simple word

concurrent serializable ->consistency

but what about this

non concurrent serializable-> consistency???
Concurrent but not serializable is not consistent !
Can we  make concurrent but serializable schedule consistent by 2PL??
why not .we can make it serializable but sometimes it may  be leads to deadlock .
but mam my doubt is is there any transection which is executing concurrently but not equivalent to any serial schedule but it's result is consistent in nature.(without using any type of locking protocol).

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

43,963 questions
49,517 answers
65,759 users