Durability in Databases

Durability is the process of persisting the writes that clients make to the database to a non-volatile storage disk. Caveat is that the writes should also be committed. This means once the commit has succeeded and right after that our system loses power or the system crashes and we need to restart, then our changes ...

Atomicity

Atomicity is one of the four ACID properties that define a database system. While ACID properties are usually referenced in Relational DBMS, they are still an applicable concept for nearly any database system out there. Let’s see what it is… All queries in a transaction must succeed. Like an atom (something which can’t be split)If ...

Database Transaction

Database Transaction
In this article we discuss about what is a Database Transaction, what are its intricacies and why it’s needed? A transaction is simply “a collection of SQL queries which are treated as a single unit of work.“ What is the need of a db transaction? Let’s think about the scenario where transactions were not possible, ...