answersLogoWhite

0


Best Answer

--guarantees serializability

--The protocol utilizes locks that block other transactions from accessing the

same data during a transaction's life.

by

Raja Done M.Tech

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the advantages of two phase locking?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

What are the advantages of three phase to two phase electric power distribution systems?

Polyphase systems are used because they allow the efficient transmission of electric power, in terms of power transmitted per kilogram of wire. Polyphase systems with more than three phases are very uncommon.


Why Scott connection is used to convert three phase to two phase why cant you take two lines from three phase circuit?

In a two-phase connection, the phases are displaced by 90 degrees. Two lines (not 'phases') of a three-phase system will provide a single-phase supply, not a two-phase supply.


Is 3 phase induction motor is self starting?

Yes, that is one of the major advantages of a three-phase induction motor.


What is the voltage level of two phase machine in three phase?

From one phase to the next you should see 208 Volts.From any phase to ground you should see 121 Volts.AnswerYou are very unlikely to come across a two-phase machine, as two-phase a.c. systems are archaic. A two-phase system has two phase voltages that are 90 degrees out of phase with each other, and was used many years' ago. These days, you have either single phase or three phase. So it's probably safe to say that there are no two-phase motors about, these days!


Explain the strict two-phase locking protocal in dbms?

The strict two-phase locking (S2PL) class of schedules is the intersection of the 2PL class with the class of schedules possessing the Strictness property. To comply with the S2PL protocol a transaction needs to comply with 2PL, and release its write (exclusive) locks only after it has ended, i.e., being either committed or aborted. On the other hand, read (shared) locks are released regularly during phase 2. Implementing general S2PL requires explicit support of phase-1 end, separate from transaction end, and no such widely utilized product implementation is known. S2PL is a special case of 2PL, i.e., the S2PL class is a proper subclass of 2PL

Related questions

Advantages of two phase locking protocol?

Two Phase locking protocol prevent deadlock. This protocol maintain the schedule which lock should be granted or not. For more information I think this link help you. http://www.databaseidea.com/2012/03/two-phase-locking-protocol.html


What is two phase protocol in a dbms?

In two phase locking there are two phases. The first phase is known as Expanding Phase and locks are issued in this phase. No lock is released. Then after change all changes are committed and the second phase starts that is the Shrinking Phase in which all the changes are noted and the locks are released. No locks are issued in this phase


Advantages of scott connection?

to convert three phase to two phase and vice versa


What benefits does strict two phase locking provide and What disadvantages result?

ADVANTAGE: It produces only cascadeless schedules, recovery is very easy.DISADVANTAGE: The set of schedules obtainable is a subset of those obtainable from plaintwo phase locking, thus concurrency is reduced


Advantages and disadvantages of phase diagrams?

the first limitation is understanding phase diagrams


What are the advantages of poly phase over single phase?

The primary advantage is that, for a given load, a three-phase system requires less copper for tranmission/distribution than an equivalent single-phase system would require. Other advantages include the fact that three-phase machines are smaller than single-phase machines of similar rating.


What is the advantages and disadvantages of single phase and three phase?

Single phase inherently requires less equipment (it's cheaper). Three phase motors are more efficient than single phase.


Two phase instruments?

There is no such thing as a two phase instrument. There is only single phase and three phase. You can only have: single phase/ one pole single phase/ two pole three phase/ three pole


Why there is not four phase in electrical system?

Because its advantages over three phase are outweighed by the cost of additional conductors.


Can you list the Advantages of delta system over star system?

If one phase becomes damaged or open, the remaining two phases can still deliver three-phase power but at a reduced capacity. It is refered to as an open delta.


What are the advantages of three phase to two phase electric power distribution systems?

Polyphase systems are used because they allow the efficient transmission of electric power, in terms of power transmitted per kilogram of wire. Polyphase systems with more than three phases are very uncommon.


What are the advantages and disadvantages of RC phase shift oscillator?

Advantages: it improves frequency stability. phase modulation n demodulation is easy as compared to frequency modulation.