Advertisement

Managing Transactions

  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

Abstract

A single update or insert to a database table is often part of several other updates, deletes, or inserts (DML statements) within a unit of work for a particular task. Those inserts, updates, or deletes that must all succeed to maintain the integrity of the data must occur as a database transaction. Every modern RDBMS supports the concept of transactions by encapsulating one or more DML statements and treating them as an atomic unit of work.

Keywords

Integrity Constraint Select Statement Update Statement Managing Transaction Recipe Solution 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Grant Allen, Bob Bryla, and Darl Kuhn 2009

Authors and Affiliations

  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

There are no affiliations available

Personalised recommendations