Suppose that transactions T1 and T2 can be decomposed into the subtransactions T1 : T1,1, T1,2 and T2 : T2,1, T2,2 such that each subtransaction individually maintains the consistency constraints of the database. Instead of guaranteeing that all schedules involving T1 and T2 are serializable, suppose that a concurrency control guarantees that all subtransactions are always executed serializably.
a. Will T1 always be serializable with T2? Explain.
b. Will integrity constraints be maintained by all possible schedules?
c. What possible problems might arise if the concurrency control schedules transactions in this way?
a. No. See previous exercise.
b. Yes, because each subtransaction starts with a consistent database and hence
produces a consistent database.
c. The database states produced might not correspond to any serial schedule and hence might not be a correct model of the state of the world. However, this situation might be acceptable to some applications. A similar problem might arise with respect to the information returned to the transaction.
You might also like to view...
In the system requirements evaluation process, what must be done to ensure that requirements satisfy relevant functions of the proposed product?
Fill in the blank(s) with the appropriate word(s).
When creating a new PowerPoint presentation, the first slide PowerPoint displays is called the ________
Fill in the blank(s) with correct word
Which of the following psychographic characteristics explain why visitors might want to access your website?
a. income b. lifestyle choices c. social group affiliations d. political affiliations
Where is the largest element in a minheap found?
What will be an ideal response?