Database System Concepts
Database System Concepts
7th Edition
ISBN: 9781260084504
Author: Abraham Silberschatz, S. Sudarshan, Abraham, Henry Korth, Silberschatz Abraham, Silberschatz Professor
Publisher: McGraw-Hill Education
Expert Solution & Answer
Book Icon
Chapter 23, Problem 3PE

Explanation of Solution

2PC ensuring transaction atomicity:

  • Consider two PC’s for which a failure occurs during the transmission of data, which can guarantee commit and abort instead of site and link failure.
  • Only the coordinator of a transaction can perform commit and abort operations.
  • This transaction can happen only on coordinator's decision either directly or indirectly from the site.
  • Consider two cases, one for site aborting and other for site committing.

Case-1:

Under following circumstance, the transaction T can be aborted by using the message:

  • If a log does not contain ready or commit message, then only the coordinator can make a decision to abort the transaction...

Blurred answer
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education