In the text we state that if, in a distributed database system, each site uses a strict two-phase locking concurrency control (all locks are held until commit time) and the system uses a two-phase commit protocol, transactions will be globally serializable. Does the result also hold if the concurrency controls are not strict—read locks are released early—but are two phase?
What will be an ideal response?
No. T1A might release a read lock on x at site A and T2A might subsequently write x.
A similar situation might exist at site B on item y except that the subtransaction of
T1 and T2 might be ordered in the opposite way. Hence the serialization graph for T1
and T2 has a cycle, but do not delay each other. Both might complete, although their
subtransactions are ordered differently at the two sites.
You might also like to view...
In PHP it's considered good coding practice to implement _______ try blocks in your code.
a. comprehensive b. small c. branching d. large
Which of the following statements corresponds to the question below?Is the value of grade greater than or equal to 90?
A. grade > 90 B. grade <= 90 C. grade >= 90 D. grade != 90
Newer HTML 5 elements, such as
Answer the following statement true (T) or false (F)
You have a microprocessor chip with a 16?bit data bus. The computer accesses words; that is, it performs only 16?bit reads and writes. You are going to build a minimal computer which requires the processor and two 8? bit memory components. Unfortunately, you have only one 8?bit memory component which means that you can’t build a system. Or can you? Explain how you could construct a system with a 16?bit processor and an 8? bit memory.
What will be an ideal response?