From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
ACID properties
From the course: Database Foundations: Database Management
ACID properties
- [Instructor] In order to make sure that transactions maintain the consistency of your data, they need to follow a group of properties that go by the wonderful acronym ACID. Transactions must adhere to the following properties. First, they must be atomic. Transactions either fully complete or entirely fail. There is no middle ground where some actions within a transaction are made to the database and others are not. It's all or nothing. Transactions must also be consistent. This refers to the correctness or the trustworthiness of the data. In a bank's financial system for example, when transferring money from one account to another, the total amount of money needs to be the same before and after. If extra money suddenly appears or money went missing then that would certainly be a problem for the bank. A consistent transaction would mean that there would be no net gain or net loss of funds across all of the accounts involved. Transactions also must be isolated from other transactions.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.