Database Systems: Design, Implementation, and Management 12th Edition – Chapter 10 Study Guide

Database Systems_ Design,
DatabaseImplementation,
Systems_ Design,
Database
and Management
Implementation,
Systems_ Design,
12th
and
Edition
Management
Implementation,
– Chapter
12th
and
10
Edition
Study
Management
–
Guide.pdf
Chapter
12th10
Edition
Study–
Guide.pdf
Chapter 10 Study Guide.pdf




Database Systems: Design, Implementation, and
Management 12th Edition – Chapter 10 Study Guide




Page 1 of 29 Page 1 of 29 Page 1

,Chapter 10, Database Systems_ Design, Implementation, andChapter
Management
10, Database
12e.pdfSystems_ Design, Implementation, andChapter
Management
10, Database
12e.pdfSystems_ Design, Implementation, and Management 12e.pdf




Atomicity


The transaction property that requires all parts of a transaction
to be treated as a single, indivisible logical unit of work All
parts of a transaction must be completed or the entire
transaction is aborted.


Atomic Transaction Property


A property that required all parts of a transaction to be treated
as a single, logical unit of work in which all operations must be
completed(committed) to produce a consistent database.


Page 2 of 29 Page 2 of 29 Page 2

, Chapter 10, Database Systems_ Design, Implementation, andChapter
Management
10, Database
12e.pdfSystems_ Design, Implementation, andChapter
Management
10, Database
12e.pdfSystems_ Design, Implementation, and Management 12e.pdf




Binary Lock


A lock that has only two states: locked(1) and unlocked(0). If a
data item is locked by a transaction, no other transaction can
use that data item.




Page 3 of 29 Page 3 of 29 Page 3