Justify the following statement: Concurrent execution of transactions is more important when data must be fetched from (slow) disk or when transactions are long, and is less important when data is in memory and transactions are very short.
Answer to relevant QuestionsExplain the distinction between the terms serial schedule and serializable schedule.What is a cascade less schedule? Why is cascadelessness of schedules desirable? Are there any circumstances under which it would be desirable to allow non-cascadeless schedules? Explain your answer.Consider the following extension to the tree-locking protocol, which allows both shared and exclusive locks:• A transaction can be either a read-only transaction, in which case it can request only shared locks, or an ...Although SIX mode is useful in multiple-granularity locking, an exclusive and intend-shared (XIS) mode is of no use. Why is it useless?Devise a timestamp-based protocol that avoids the phantom phenomenon.
Post your question