The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
39 views
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.4k points) | 39 views
0
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...
0
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???
0
Concurrent but not serializable is not consistent !
0
Can we  make concurrent but serializable schedule consistent by 2PL??
0
why not .we can make it serializable but sometimes it may  be leads to deadlock .
0
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.

Related questions

0 votes
1 answer
6
asked Sep 2, 2018 in Databases by mukul maurya (55 points) | 70 views
0 votes
0 answers
7
asked Sep 2, 2018 in Databases by mukul maurya (55 points) | 56 views
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
49,427 questions
53,611 answers
185,912 comments
70,885 users