Concurrency Control Protocols in DBMS
Introduction Concurrency Control in management System is a procedure of managing simultaneous operations without conflicting with one another. It ensures that Database transactions are performed concurrently and accurately to supply correct results without violating data integrity of the respective Database. Concurrent access is sort of easy if all users are just reading data. There is no way they will interfere with each other. Though for any practical Database, it might have a mixture of READ and WRITE operations and hence the concurrency may be a challenge. DBMS Concurrency Control is employed to deal with such conflicts, which mostly occur with a multi-user system. Therefore, Concurrency Control is that the most vital element for correct functioning of a management System where two or more database transactions are executed simultaneously, which require access to the same data. Concurrent Execution in DBMS In a multi-user system, multiple users can access and use an equivalent data...