VAULT
73 NOTES2024.10.15
DATABASES

ACID Principles

ADESH TAMRAKAR01 MIN READ47 WORDS
databasesacidtransactions

Set of principles that ensure data integrity and consistency leveraging transactions.

  1. Atomicity - Transaction is all-or-nothing
  2. Consistency - Transactions are predictable and predefined always
  3. Isolation - Concurrent transactions are isolated
  4. Durability - A successful transaction is saved in event of failure or reboot
Adesh Tamrakar
SOFTWARE ENGINEER · VAULT

Notes, insights and random discoveries from a working engineer's vault - written for future me, published for you.

RELATED

DATABASES / 01 MINConstraintsConstraints are of 5 Types, these set rules for data integrity, reliability and compliance to standard requirements. - Valid value, data type or data in a range - Applied to one or more columns2024.09.15DATABASES / 02 MINHow to Query Hierarchical Data in SQL: Self Joins, Recursive CTEs, Nested QueriesThree approaches to fetching hierarchical data from a self-referencing table: multiple merged queries, recursive CTEs, and nested queries.2024.09.06DATABASES / 02 MINJoinsIn DBMS, Joins are used to use the relation between the tables to create a combined result.2024.09.15