ACID properties

ACID properties are an important concept for databases. The acronym stands for Atomicity, Consistency, Isolation, and Durability. 

The ACID properties of a DBMS allow safe sharing of data. Without these ACID properties, everyday occurrences such using computer systems to buy products would be difficult and the potential for inaccuracy would be huge. Imagine more than one person trying to buy the same size and color of a sweater at the same time -- a regular occurrence. The ACID properties make it possible for the merchant to keep these sweater purchasing transactions from overlapping each other -- saving the merchant from erroneous inventory and account balances.

Also see concurrency control and locking (new window).

More detail for the current topic: ACID properties
	Atomicity
	Consistency
	Isolation
	Durability

More on the general topic: Basic concepts for using a DBMS
	Concurrency control and locking

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: ACID properties.

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

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 »

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 »

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 »

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 »

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: 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: 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 "acid properties" consistency

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