ACIDProperties

Microsoft SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft that stores and retrieves data using Transact-SQL (T-SQL), an ex…

IBM Db2

IBM Db2 is a family of relational database management systems from IBM, historically rooted in mainframe computing, that supports transactional and analytical…

RavenDB

RavenDB is an open-source, ACID-compliant NoSQL Document Database built primarily for the .NET ecosystem, designed to combine document flexibility with transac…

FaunaDB

FaunaDB (also known as Fauna) was a serverless, globally distributed database combining document and relational data modeling, accessed via GraphQL or its own…

EdgeDB

EdgeDB is an open-source database built on top of PostgreSQL that adds a graph-relational data model and its own query language, EdgeQL, aiming to make complex…

Google Cloud Spanner

Google Cloud Spanner is a fully managed, horizontally scalable relational database service that combines strong relational consistency (SQL schemas, ACID trans…

Database Normalization

Database normalization is the process of organizing tables and columns in a relational database to reduce data redundancy and prevent update, insert, and delet…

ACID Properties

ACID is an acronym describing four guarantees — Atomicity, Consistency, Isolation, and Durability — that traditional relational database transactions provide t…

CAP Theorem

The CAP theorem states that a distributed data system can provide at most two of three guarantees simultaneously during a network partition: Consistency, Avail…

OLTP

OLTP (Online Transaction Processing) refers to database systems and workloads optimized for large numbers of short, concurrent read/write transactions, such as…

NewSQL

NewSQL is a class of database systems that aim to provide the horizontal scalability of NoSQL databases while retaining the ACID transactional guarantees and f…

ACID Properties

The four guarantees—Atomicity, Consistency, Isolation, Durability—that make database transactions reliable.

ACID Properties Cheat Sheet

The four ACID guarantees, SQL transaction isolation levels, and the concurrency anomalies each isolation level prevents or allows.

What are ACID Properties in DBMS?

ACID stands for Atomicity, Consistency, Isolation, and Durability — the four guarantees a database transaction must satisfy so that data stays correct even und…