 - ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor). These attributes are:
Atomicity. In a transaction involving two or more discrete pieces of information, either all of the pieces are committed or none are.
Consistency. A transaction either creates a new and valid state of data, or, if any failure occurs, returns all data to its state before the transaction was started.
Isolation. A transaction in process and not yet committed must remain isolated
from any other transaction.
Durability. Committed data is saved by the system such that, even in the event of a failure and system restart, the data is available in its correct state.
The ACID concept is described in ISO/IEC 10026-1:1992 Section 4. Each of these attributes can be measured against a benchmark. In general, however, a transaction manager or monitor is designed to realize the ACID concept. In a distributed system, one way to achieve ACID is to use a two-phase commit (2PC), which ensures that all involved sites must commit to transaction completion or none do, and the transaction is rolled back (see rollback).
 |
Learn more about Microsoft SQL Server Tools and Utilities |
| Microsoft SQL Server Tools Guide: Whichever SQL Server hammer or nail you may be looking for, there's a good chance you'll find the tool or utility you need in this guide. |
| Microsoft SQL Server Tools Guide: Whichever SQL Server hammer or nail you may be looking for, there's a good chance you'll find the tool or utility you need in this guide. |
| Microsoft SQL Server 2008 Resource Governor primer: In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn how Resource Governor can improve SQL Server performance. |
| Fast Guide: Free SQL Server tools: This list of free SQL Server tools will help reduce your workload, streamline maintenance and improve the performance of your databases. |
| System monitor alerts: Learn what system monitor alerts can do from within SQL Server in this excerpt from "SQL Server 2000 for experienced DBAs" by Brian Knight. |
| System monitor logging: Learn what system monitor logging can do from within SQL Server in this excerpt from "SQL Server 2000 for experienced DBAs" by Brian Knight. |
| CONTRIBUTORS: |
Jose C. Elias |
| LAST UPDATED: |
10 Jul 2006
|
 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
|
More resources from around the web:
|
|
Show me everything on 
