Need for concurrency control - 10 Minutes lectures in computer science скачать в хорошем качестве

Need for concurrency control - 10 Minutes lectures in computer science

For more information please visit: http://www.exploredatabase.com/ This video discusses about the purpose of concurrency control mechanism in database management systems. Basically we need to execute multiple transactions simultaneously to increase transaction throughput. The major problem here is that the execution of interleaved instructions. They are harmful to the database consistency if they are trying to execute incompatible instructions. In this lecture we discusses the problems caused by interleaved execution of instructions. Here discussed the lost update problem, dirty read problem, inconsistent analysis problem and repeatable read problem. Each problem is discussed with necessary examples. For more information please visit: http://www.exploredatabase.com/