Modify article about Database

[sentenz]

Database

Category

Transaction Models

A database transaction is a sequence of operations performed as a single logical unit of work. Transactions are fundamental to ensuring data integrity and consistency in databases, especially in environments where multiple users access and manipulate data concurrently.

ACID

1. Components and Features

• Atomicity

  Ensures that all operations within a transaction are completed successfully; if any operation fails, the entire transaction is aborted, and the database remains unchanged.

• Consistency

  Guarantees that a transaction brings the database from one valid state to another, maintaining all predefined rules, such as integrity constraints.

• Isolation

  Ensures that concurrent transactions execute as if they were sequential, preventing them from interfering with each other.

• Durability

  Once a transaction has been committed, its effects persist in the database even in the event of a system failure.

BASE

References

• AWS ACID and BASE Database page.