Use of multiple-granularity locking may require more or fewer locks than an equivalent system with a single lock granularity. Provide examples of both situations, and compare the relative amount of concurrency allowed.
Answer to relevant QuestionsConsider the validation-based concurrency-control scheme of Section 16.3. Show that by choosing Validation (Ti), rather than Start (Ti), as the timestamp of transaction Ti, we can expect better response time provided that ...If deadlock is avoided by deadlock avoidance schemes, is starvation still possible? Explain your answer.Assume that immediate modification is used in a system. Show, by an example, how an inconsistent database state could result if log records for a transaction are not output to stable storage prior to data updated by the ...Sometimes a transaction has to be undone after it has commited, because it was erroneously executed, for example because of erroneous input by a bank teller.a. Give an example to show that using the normal transaction undo ...What is lock de-escalation, and under what conditions is it required why is it not required if the unit of data shipping is an item?
Post your question