Wednesday, August 24, 2016

Data Protection - Lecture Note V (The ACID Properties)


Transaction has four- important properties


  • Atomicity - Transactions are atomic (all or nothing)
  • Consistency - Transactions preserve database consistency. Which means a transaction transforms a consistent state of a database into another consistent state, without necessarily preserving consistency at all immediate points.
  • Isolation - Transactions are isolated from one another. That is, even though in general there will be many 'transactions' running concurrently, any given transaction's updates are concealed from all the rest, until that transaction commits.
  • Durability - Once transaction commits its updates survive in the database, even if there is a subsequent system crash.

No comments:

Post a Comment

Important Notice!

Dear students and friends. When you commenting please do not mention your email address. Because your email address will be publicly available and visible to all. Soon, it will start sending tons of spams because email crawlers can extract your email from feed text.

To contact me directly regarding any inquiry you may send an email to info@bcslectures.website and I will reply accordingly.