168,291 views
5 votes
5 votes
Why concurrency control is needed in transaction.

And why Acid properties in transaction is important.

User Igor Bendrup
by
2.9k points

1 Answer

1 vote
1 vote

Step-by-step explanation:

Concurrency Control in Database Management System is a procedure of managing simultaneous operations without conflicting with each other. It ensures that Database transactions are performed concurrently and accurately to produce correct results without violating data integrity of the respective Database.And The ACID properties, in totality, provide a mechanism to ensure correctness and consistency of a database in a way such that each transaction is a group of operations that acts a single unit, produces consistent results, acts in isolation from other operations and updates that it makes are durably stored.

User Jeff Widman
by
3.4k points