DEV Community

Cover image for Valid Database properties(ACID).
Adeyemi Racheal
Adeyemi Racheal

Posted on

Valid Database properties(ACID).

ACID

  • Atomicity
  • Consistency
  • Isolation
  • Durability Are a set of properties of database transactions that guarantee data validity despite errors, power failure, and other catastrophe and are processed reliably.

Atomicity:- A transaction is treated as a single, indivisible unit. Either all operations within the transaction are completed successfully, or none of them are. This prevents a transaction from leaving the database in an inconsistent state.

Consistency: A transaction must only bring the database from one consistent state to another. This means that the database must adhere to all defined rules and constraints before and after the transaction.

Isolation: Multiple transactions can occur concurrently without interfering with each other. Each transaction operates as if it were the only one accessing the database, preventing conflicts and ensuring data integrity.

Durability: Once a transaction is committed, its changes are permanent and will survive system failures or crashes. The database will recover the committed changes even if it needs to be restarted.

  • By adhering to ACID principles, databases can ensure that:
    • Data remains accurate and reliable.
    • Transactions are processed correctly and efficiently.
    • The database system is resilient to failures and can recover gracefully.

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (0)

Billboard image

Try REST API Generation for Snowflake

DevOps for Private APIs. Automate the building, securing, and documenting of internal/private REST APIs with built-in enterprise security on bare-metal, VMs, or containers.

  • Auto-generated live APIs mapped from Snowflake database schema
  • Interactive Swagger API documentation
  • Scripting engine to customize your API
  • Built-in role-based access control

Learn more

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay