ACID Properties

Edit on GitHub

ACID properties refer to properties a database transaction must follow in order to maintain consistency in a database. Those properties are as follows:

  • Atomicity: The entire transaction must occur, or none of it does. There are no partial transactions.
  • Consistency: The database must remain consistent before and after the transaction.
  • Isolation: Transactions are independent of one another, and do not interfere with each other.
  • Durability: A transaction, once completed, is permanent and persists even if a system failure occurs.

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.
Edit on GitHub

Learn More on Codecademy

Career path

Data Scientist: Machine Learning Specialist

Machine Learning Data Scientists solve problems at scale, make predictions, find patterns, and more! They use Python, SQL, and algorithms.
Includes 27 Courses
With Professional Certification
Beginner Friendly
81 Lessons
Skill path

Analyze Data with SQL

Learn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
With Certificate
Beginner Friendly
15 Lessons
Edit on GitHub

Contributors