Question

What is ACID ? Why acid property is important in dbms ?

Explain Commit and Lock in distributed database with the

help of example.​

Answer 1

ΔACID Properties are used for maintaining the integrity of database during transaction processing. ACID in DBMS stands for Atomicity, Consistency, Isolation, and Durability. Atomicity: A transaction is a single unit of operation. You either execute it entirely or do not execute it at all.

In Distributed Systems(referred to as DS from now on), lock is a mechanism that allows only one of the innumerable nodes(or process) to access and modify a resource or data that is being shared commonly to prevent execution of same task twice and also maintain data integrity.

An example of help is what you are asking for when you ask your neighbor to get your mail. An example of help is someone who goes out of his way to aid you.