Please disable adblock to view this page.

← Go home

ACID properties of transaction

September 13, 2016
Published By : Pratik Kataria
Categorised in:

acid_properties

Source: sqlserverhelpdotcom

  • Atomicity : Either all operations are executed or none of the operations are executed.
  • Consistency : All the data must be in a consistent state. There should be no transaction that has adverse effect on data residing in database.
  • Isolation : If more than 1 transactions are executing simulataneously then every transaction should be executed as if no other transaction is running.
  • Durability: The database system should be able to sustain the updates. Even if the system fails or restarts, the updates should be applied.

Pratik Kataria is currently learning Springboot and Hibernate.
Technologies known and worked on: C/C++, Java, Python, JavaScript, HTML, CSS, WordPress, Angular, Ionic, MongoDB, SQL and Android.
Softwares known and worked on: Adobe Photoshop, Adobe Illustrator and Adobe After Effects.