Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Self doubt on 2PL protocol
ashunimbz
asked
in
Databases
Mar 30, 2019
570
views
0
votes
0
votes
How can 2PL protocol ( simple one ) ensure conflict serializability even though it cannot ensure freedom from deadlock ?
I mean ,if a schedule is conflict serializable it has a conflict equivalent to a serial schedule and serial schedules won't have deadlocks .Right ?
-2phaselocking
conflict-serializable
transaction-and-concurrency
databases
ashunimbz
asked
in
Databases
Mar 30, 2019
by
ashunimbz
570
views
answer
comment
Follow
share this
share
1 comment
by
prashant jha 1
commented
Apr 2, 2019
reply
Follow
share this
equivalent is same as equal?The effect is equivalent , schedules are not equal. :)
1
1
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
2
Answers
0
votes
0
votes
Conflict equivalent to serial schedule means final result of a given non serial schedule and corresponding serial schedule will be same.
Deadlock occurs while execution of transaction but if it is executed completely then result will be identical to serial schedule.
tp21
answered
Oct 20, 2019
by
tp21
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
0
votes
0
votes
In 2-Phase-Locking, if you are able to avoid deadlock, then whatever schedule you get, will be Conflict Serializable.
And if you run into a deadlock, then you won’t be able to come up with a Conflict Seralizable schedule.
Dexter Mandark
answered
Jun 22, 2022
by
Dexter Mandark
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
0
answers
1
Parimal Paritosh
asked
in
Databases
Sep 2, 2018
406
views
2pl protocol
Can someone explain how transactions can be serialized in order of their lock points (the point where the transactions acquire their final lock)?
Parimal Paritosh
asked
in
Databases
Sep 2, 2018
by
Parimal Paritosh
406
views
databases
transaction-and-concurrency
2phaselocking
conflict-serializable
2
votes
2
votes
1
answer
2
KISHALAY DAS
asked
in
Databases
Dec 22, 2016
721
views
ACE TEST SERIES:-Transaction 2pl and Time stamp based protocol
KISHALAY DAS
asked
in
Databases
Dec 22, 2016
by
KISHALAY DAS
721
views
databases
transaction-and-concurrency
conflict-serializable
test-series
2
votes
2
votes
1
answer
3
Rahul Jain25
asked
in
Databases
Feb 4, 2017
2,369
views
Database 2PL and Timestamp doubt
I)All schedules that are allowed under 2PL are also allowed under Timestamp?? Is vice versa true?? II)Plz explain by giving example. I have read that there are schedules that are allowed under 2PL but not under Timestamp and vice versa, ... ?? IV) Are all view serializable allowed under Timestamp(Thomas write rule)??? Explanation along with example would be helpful.
Rahul Jain25
asked
in
Databases
Feb 4, 2017
by
Rahul Jain25
2.4k
views
databases
conflict-serializable
concurrency
transaction-and-concurrency
0
votes
0
votes
0
answers
4
aditi19
asked
in
Databases
Nov 11, 2018
437
views
2 Phase Locking
https://gateoverflow.in/1484/gate1999-2-6 in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to acquire exclusive lock on B? and if T2 continues to acquire lock on B followed by T1 requesting for read and write lock on B successively, is it deadlock situation here? And is that why it is not 2PL?
aditi19
asked
in
Databases
Nov 11, 2018
by
aditi19
437
views
-2phaselocking
databases
serializability
transaction-and-concurrency
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
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
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy