Question: Although SIX mode is useful in multiple granularity locking 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?
Answer to relevant QuestionsUse 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.Under what conditions is it less expensive to avoid deadlock than to allow deadlocks to occur and then to detect them?Compare the deferred- and immediate-modification versions of the log-based recovery scheme in terms of ease of implementation and overhead cost. Explain the reasons why recovery of interactive transactions is more difficult to deal with than is recovery of batch transactions. Is there a simple way to deal with this difficulty? Consider an object-oriented database system based on a client-server architecture, with the server acting as a data server.a. What is the effect of the speed of the interconnection between the client and the server on the ...
Post your question