Peter Frank's Chapter 10

Cards cover Chapter 10 out of "Database Systems: Design, Implementataion and Managment"

11 cards·by frankpa

database systemschapter 10

Any action that reads from and/or writes to a database.

Transaction

All operations of a transaction must be completed or the transaction is aborted.

Atomicity

Data used during the execution of a transcation cannot be used by a second transaction until the first is complete.

Isolation

Indicates the permanence of the database consistent state.

Consistency

Ensures that once transaction changes are dobe they cannot be undone.

Durability

Used to keep track of all transactions that update the database.

Transaction Log

The coordination of the simultaneous execution of transactions in a multiuser database system.

Concurrency Control

List Three Main Problens in Concurrency Control.

Lost Update, Uncommitted Data, Inconsistent Retrievals

This guarantees exclusive use of a data item to a current transaction.

Lock

A problem in which two or more transactions wait for eachother to unlock data.

Deadlock

Name the two-phases of locking protocol.

Growing Phase, Shrinking Phase.