Transaction Locks, Two-Phase Commit and Deadlocks

  • Dimitris N. Chorafas

Abstract

Access to the database occurs within the framework of short and long transactions. As we have seen, each transaction consists of a sequence of operations on the database, with practically no pre-established limits to the time spent in a transaction or number of operations performed for its execution.

Keywords

Database consistency commit abort read/write log-out root page transaction complexity serialization locking conflict resolution global level local level data consistency two-phase commit atomicity fault tolerance optimistic protocol prudent protocol hash function deadly embrace linear commit tree commit decentralized commit central-site commit communications failure site failure blocking time complexity message complexity concurrency control lock manager primary copy contention deadlock rollback metalayer metalevel deadlock-free livelock-free savepoints flexible transaction prepared-to-commit locking protocol root object directory node directory shared transaction object-level locking aggregatelevel locking. 

Acronyms

ACP

Atomic commitment protocol

TIB

Teknekron information bus

DBA

Database administrator

PBX

Private branch exchange

2PL

Two-phase locking

2PC

Two-phase commitment

DXT

Data extract

2LPL

Two-level, two-phase locking

SDDL

Stored data definition language

DSCL

Data specification and conversion language

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Dimitris N. Chorafas 1998

Authors and Affiliations

  • Dimitris N. Chorafas

There are no affiliations available

Personalised recommendations