Friday, March 6, 2015

Properties of SQL Transactions

Transactions have the following four standard properties, usually referred to by the acronym ACID:

  1. Atomicity: ensures that all operations within the work unit are completed successfully; otherwise, the transaction is aborted at the point of failure, and previous operations are rolled back to their former state.
  2. Consistency: ensures that the database properly changes states upon a successfully committed transaction.
  3. Isolation: enables transactions to operate independently of and transparent to each other.
  4. Durability: ensures that the result or effect of a committed transaction persists in case of a system failure.

Popular Posts

Labels

ad ( 3 ) Amazon ( 47 ) Answer ( 1 ) API ( 22 ) automation ( 1 ) blog ( 21 ) book ( 2 ) career ( 12 ) cdn ( 2 ) centos ( 1 ) cloud ( 120 ) CRM ( 24 ) current ( 9 ) data ( 14 ) database ( 62 ) design patterns ( 14 ) development ( 3 ) eCommerce ( 23 ) email ( 92 ) ETL ( 2 ) framework ( 3 ) git ( 7 ) google ( 176 ) IDE ( 10 ) Integration ( 1 ) interview ( 15 ) Java ( 360 ) Java EE ( 101 ) javascript ( 40 ) Jboss ( 4 ) JPA ( 48 ) JSF ( 44 ) linux ( 324 ) Marketing ( 19 ) mobile ( 43 ) model ( 1 ) MySQL ( 192 ) online money ( 12 ) OOP ( 7 ) open source ( 26 ) performance ( 71 ) php ( 50 ) python ( 47 ) quality ( 5 ) referral ( 3 ) restful ( 22 ) security ( 126 ) SEO ( 17 ) social ( 26 ) software ( 72 ) spam ( 4 ) Spring ( 1 ) SQL ( 22 ) system ( 29 ) testing ( 14 ) tool ( 77 ) UML ( 8 ) virtual ( 10 ) web ( 218 ) web services ( 14 ) WildFly ( 3 ) wordpress ( 8 )