0
It depends. A serial schedule is one in which the operations of one transaction begins after the operation of another.. that is for example there are 5 operations in Ti(Oi1,Oi2,Oi3,Oi4,Oi5) and 4 operations in Tj(Oj1,Oj2,Oj3,Oj4) the schedule is :
Oi1,Oi2,Oi3,Oi4,Oi5,Oj1,Oj2,Oj3,Oj4 OR Oj1,Oj2,Oj3,Oj4,Oi1,Oi2,Oi3,Oi4,Oi5
But to check if a schedule is recoverable we need to check whether for each pair of transactions ,Ti and Tj - such that Tj reads a dataItem previously written by Ti - Ti commits before Tj. If so it is recoverable.
All cascadeless Schedules are also recoverable Schedules
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
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
Serial schedule differs serializable schedule in dbms?
Serial schedules are the schedules during which all statements in a transaction are executed consecutively. Serializable schedule is a schedule that is equivalent to a serial schedule
What is cascadeless schedule?
One where every transaction reads only the items that are written by committed transactions.
Is depreciation on carpet pad recoverable or non-recoverable for insurance claim purposes?
Recoverable altho you were foolish not to have "replacement cost". Then you are covered at 100%
What is tax recoverable?
A recoverable tax is exactly how it sounds. It is money that can be recovered from the sales of your merchandise.
What is the prefix for retrievable?
recoverable
Is the Costa Concordia recoverable?
yes.
What is the prefix of reparable?
Did you mean, "What is the Prefix of Recoverable?" If so, the prefix in the word "Recoverable" is "Re" which means "back" or "again".
Is there non recoverable coal?
Yes. Yes.
Is deleted Firefox private data recoverable using a file recovery program?
Your Private Data is recoverable using a File Recovery Program...such as Pixo_Rescue.
What is a formula for calculating recoverable and in place well reserves?
Recoverable reserves= Volume of hydrocarbon * recovery factor Recoverable reserves= [7758* Vf*P*((1-Sw)/FvF)] * R.F Vf:Volume of producing formation(acre-feet) P: Porosity Sw: Water Saturation FvF: Formation Volume Factor R.F: Recovery Factor(Percentage of oil in place thats recoverable)
If something is fried by a power surge is it's data recoverable?
If the data storage unit of the piece of technology you are using is not harmed, it's most likely ok and recoverable.
