Pedro Arantesrose
ArticlesContactNow

ACID (Database Systems)

ACID (database systems) stands for atomicity, consistency, isolation, durability.
#andreas-reuter
Zettelkasten, April 26, 2021 (changes)

Notes

  • ACID (database systems) stands for atomicity, consistency, isolation, durability.

  • Andreas Reuter and Theo Härder coined the acronym ACID in 1983.

  • They're a set of database transactions intended to guarantee data validity.

    • Data validity is guaranteed even if errors or power failures happen.
  • Transaction is a sequence of database operations that satisfies the ACID properties.

  • The four properties:

    • Atomicity: guarantees that each transaction (multiple operations) is considered a single "unit." A transaction succeeds if all operations also succeed. If only one operation fails, the whole transaction also fails.

      • An atomic system must guarantee this property in all scenarios, including power failures, errors, and crashes.
    • Consistency: ensures that transactions can only bring the database from a valid state to another.

      • It maintains the database invariants and constraints. For example, only numbers can be written in a property that is a number.
    • Isolation: ensures that concurrent execution of transactions leaves the database as if the same transactions were executed sequentially.

      • The effects of an incomplete transaction cannot be visible by other transactions.
    • Durability: once the transaction is committed, it will remain even in the case of a system failure.

References

RecommendationsDo you want to see all posts instead?
Key-Value Database
Key-value database, or key-value store, is a data storage paradigm that allows you to store opaque data collection with an associated key.
Zettelkasten, July 06, 2021
Pareto Principle
The Pareto Principle states that roughly 80% of the consequences come from 20% of the causes for many outcomes.
Zettelkasten, July 02, 2021
Accountability Psychological Trigger
You need accountability to build up credibility. So you have to do things under your name as much as possible, with risky.
Zettelkasten, August 18, 2021
Mental Models
Mental models are frameworks, worldviews, representations, or explanations of how something works. They're how we understand the world.
Zettelkasten, April 06, 2021
Purposeful Stupidity
"Citizen-saboteurs" learned those instructions to sabotage organizations or governments institutions.
Zettelkasten, September 19, 2021
Asymmetric Opportunity
An asymmetric opportunity is one in which the upside is much more significant than the downside.
Zettelkasten, July 22, 2021

Newsletter

Every Tuesday, I publish my most recent readings and thoughts. Subscribe to my newsletter if you want to follow topics about #startups, #mental-models, #cryptocurrencies, and more. You can also check my past issues on Revue.

By subscribing, you agree with Revue’s Terms and Privacy Policy