Friday, February 16, 2018

MongoDB Transactions and ACID compliance

MongoDB is a most popular NoSql database amongst all other NoSql databases. There is a main difference between SQL and NoSQL is that SQL supports transactions and NoSQL do not. Databases are selected depending upon the business requirements, development feasibility, scalability, and agility.

Transactions are important. Any database needs to offer transactional guarantees to enforce data integrity. But they don’t all do it in the same way – different database technologies follow different mechanism.Transactions in a database is a sequence of operations performed as a single logical unit of work. A logical unit of work must conforms  four properties of ACID to qualify as a transaction. The properties are called the atomicity, consistency, isolation, and durability.