top of page
Database Management System
CAP Theorem
The CAP Theorem (Brewer's theorem), states that a distributed database system can only guarantee two out of the following three...
sumitnagle
Jul 64 min read
Distributed Database System
We have done a lot with single database, meaning there is only one server/node/machine (whatever you want to call it!) which serves our...
sumitnagle
Jul 54 min read
Durability Mechanisms
So we have discuss a lot things around data, buffering , indexing , transactions , concurrency control , but all of this doesn't make any...
sumitnagle
Jun 288 min read
Multi-Version Concurrency Control
We have discussed two main ways of managing concurrency control , optimistic locking and pessimistic locking ! and now we will go...
sumitnagle
Jun 275 min read
Optimistic Locking
Optimistic Locking is another way concurrency control mechanism that assumes conflicts are rare and allows multiple transactions to...
sumitnagle
Jun 274 min read
Pessimistic Locking
Pessimistic Locking is a concurrency control strategy where the database prevents other transactions from accessing or modifying...
sumitnagle
Jun 2612 min read
Concurrency Control
So far, we have discussed what a transaction means, and how does any database implements ACID principle for reliable and persistent...
sumitnagle
Jun 252 min read
ACID (atomicity, consistency, isolation, durability)
Database doesn’t just store data, they also needs to guarantee that the data stays consistent and reliable, even when multiple operations...
sumitnagle
Jun 246 min read
Transactions
So we have covered all the things, from the side of how modern database use multiple techniques to ensure faster read/writes of data. And...
sumitnagle
Jun 245 min read
Compression and Encoding
Compression techniques are essential in data storage and processing, as they reduce disk usage and enhance I/O performance . There...
sumitnagle
Jun 243 min read
bottom of page