Assume a schedule consists of consistent transactions that execute in an isolated fashion except for one transaction that performs a single update that is lost (as in Figure 18.2). Showthat the final state of the database satisfies all integrity constraints but nevertheless is incorrect.

What will be an ideal response?


The values in the final database are the same as if T had never executed. Since all the other transactions are consistent and executed in an isolated fashion, the final database satisfies all integrity constraints. The database might nevertheless be incorrect because the update that was lost might be important for the application, for example as in the schedule of Figure 18.2.

Computer Science & Information Technology

You might also like to view...

The advantages of using typedef do not include:

a. Making programs more portable by allowing data types to be easily changed to meet system specifications. b. Making type names shorter. c. Making programs more readable. d. Increasing the efficiency of accessing struct member variables.

Computer Science & Information Technology

Based on Part C of the Systems Analyst’s Toolkit, what financial analysis tools should you use to evaluate the software acquisition options for Atrium? Explain how you would apply each of the tools.

What will be an ideal response?

Computer Science & Information Technology

Which of the following best describes the licensing-model used by Windows Server 2016 Standard and Datacenter editions?

A. User-based B. Server-based C. core-based D. processor-based

Computer Science & Information Technology

Which of the following is not true about instant messaging?

A. It only requires an Internet connection. B. It does not use cellular data. C. Because of security concerns, businesses do not use it. D. It can often be real-time communication.

Computer Science & Information Technology