Breaking down ACID and transactions in Databases

Simple practices to make your database more reliable.

A database is simply a collection of organized data. For e.g. your mobile bills, salary statements, balance sheets etc. are simple example of databases. They store your data in an organized and consistent manner. All of the aforementioned examples contain critical information. If any of these collections become inconsistent or unreliable, it’s bad news, right ?

Databases comprises of small units of actions, performed by single user or a program which reads or updates the database, these are referred as transactions. A simple example of a transaction can be: Transferring an amount X from the account of user A to user B. Therefore for any database to ensure reliability and consistency, it’s transactions needs to support ACID properties, which are namely :

Life cycle of a transaction.

So to wrap it up, ACID property helps in establishing the correctness of the database and making sure that your data never become inconsistent.

Thank you for your time. If you like my writing, you can find my previous article here. Do these concepts make sense to you? If you have 12 seconds, I’d love to read your comment below..If this post was helpful, please click the clap 👏button below a few times to show your support!⬇⬇

PolyMath | MultiPotentialite — LinkedIn: https://www.linkedin.com/in/amogh-singhal

PolyMath | MultiPotentialite — LinkedIn: https://www.linkedin.com/in/amogh-singhal