What Is Concurrency Control And Locking Mechanism In Distributed Database System?
Concurrency control and locking mechanisms comes into play when more than one person accesses the same set(say record) simultaneously in the database.Consider if one persons edits(updates) a particular record and another fellow also updates the same record simultaneously,then necessary mechanisms are needed to ensure this problem.These mechanisms are Concurrency control and locking mechanism..like lock the record while writing,etc.