ACID - The Properties of Database Transactions

Here we discuss database updates known as Transactions.

A Database Transaction can be made up of several operations. However, a transaction is considered to be a single logical operation on a database. For example, a funds transfer transaction consists of two account update operations.

In order to guarantee the reliability of database transactions they must have a specific set of properties denoted by the acronym ACID (Atomicity, Consistency, Isolation and Durability).

The Atomicity property means that all the operations of the transaction must take place as a whole. Either all operations take place or none of them do. If the transaction terminates early, for any reason, then the data is not changed.

The DBMS ensures that the data is consistent after each transaction. By this we mean that the database maintains referential integrity and all of the constraints defined for the database.

A database transaction takes place in Isolation. Other processes within the system will not see the effect of transactions in progress. This ensures that the other processes will not be confused by partially complete transaction. It also ensures that the operations of concurrent transactions are not interleaved.

Once a transaction has completed then its data is secured. The updates will not be lost even after system failure.

More by this Author


No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.

    Click to Rate This Article