Atomicity

The phrase "all or nothing" succinctly describes the first ACID property of atomicity. When an update occurs to a database, either all or none of the update becomes available to anyone beyond the user or application performing the update. This update to the database is called a transaction and it either commits or aborts. This means that only a fragment of the update cannot be placed into the database, should a problem occur with either the hardware or the software involved. Features to consider for atomicity:

bulleta transaction is a unit of operation - either all the transaction's actions are completed or none are
bulletatomicity is maintained in the presence of deadlocks
bulletatomicity is maintained in the presence of database software failures
bulletatomicity is maintained in the presence of application software failures
bulletatomicity is maintained in the presence of CPU failures
bulletatomicity is maintained in the presence of disk failures
bulletatomicity can be turned off at the system level
bulletatomicity can be turned off at the session level

Related content for: Atomicity ACID property

More on the general topic: ACID properties
Consistency
Isolation
Durability

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site.The arrows show the path to the current article: Atomicity ACID property.

Web Services and Service-Oriented Architectures
Online briefings
Search results
Online articles -->
Consulting
Mentoring
Speaking
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards -->
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Basic concepts for using a DBMS -->
Database models
DBMS standards
Article suggestions
ACID properties -->
Concurrency control and locking
Atomicity
Consistency
Isolation
Durability

Related recent articles from Google News


PowerBuilder 11.5 Top Feature Picks
Ulitzer.com
The O11g driver is actually set in the Transaction Object in the DBMS property as a plain "ORA" setting (see Figure 7). This may be confusing since in prior ...

and more »

No to SQL? Anti-database movement gains steam
Computerworld
They force you to twist your object data to fit a RDBMS [relational database management system]," said Jon Travis, principal engineer at Java toolmaker ...

and more »

SYS-CON Media (press release)

Cloud Computing Expo: Network-Centric Computing Model
SYS-CON Media (press release)
DDS technology is employed to enable a truly decentralized data structure for distributed database management while DBMS technology is used to provide ...

and more »

Access Synergy DBMS Databases from .NET Apps and VS2008
Softpedia
NET with support for the Entity Framework. The Synergy/DE Data Provider for .NET enables developers to access Synergy DBMS databases from . ...

and more »

ParAccel Introduces the Next Generation of Its Record-Breaking ...
Business Wire (press release)
... version of the company's high-speed, low-effort, massively parallel (MPP) columnar database management system (DBMS) for data warehousing and analytics. ...

and more »

More related news: data database-management-system OR DBMS - Google News

Related books at Amazon.com


Transaction Processing: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems)
by Jim Gray, Andreas Reuter
Average Customer Review: 5 stars based on 9 reviews.
Customer Review: For nearly a decade this book has been the definitive reference on transaction processing. Although the more recent, May 2001 book titled "Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control" by Gerhard Weikum and Gottfried Vossen will probably supplant this book as the standard reference, t...

Comprehensive Guide to the Use and Application of the Transaction Databases
by Nancy Fannon, Heidi Walker
Publisher: Business Valuation Resources
Publication Date: March 2008

Object-Process Methodology Applied to Modeling Credit Card Transactions.(Technology Information): An article from: Journal of Database Management
by Dov Dori
Publisher: Idea Group Publishing
Publication Date: January 2001

Database Transaction Models for Advanced Applications (The Morgan Kaufmann Series in Data Management Systems)
by Ahmed K. Elmagarmid
Publisher: Morgan Kaufmann
Publication Date: April 1992

The Benchmark Handbook for Database and Transaction Processing Systems (The Morgan Kaufmann series in data management systems)
by Jim Gray
Average Customer Review: 1 star based on 1 review.
Customer Review: This was a waste of money and is no wonder why it is out of print. Of course I may or may not even read the damn thing so this review is essentially usless and I have wasted your time. Mission Accomplished! THANX

More related books: Search Amazon.com for database atomicity

 

Copyright © 2000-2009 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 

Newletter Sign Up

 

 

Barry & Associates, Inc.