Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last updated: Jan 24, 2022

Transaction and Concurrency Control

The transaction is a set of logically related operations. Concurrency Control is the process of managing the simultaneous execution of transactions in shared memory space.
Concurrency Control in DBMS EASY
Concurrency control in Database Management System (DBMS) is a procedure of managing simultaneous transactions without conflict.
MOSS Concurrency Control Protocol EASY
This article covers the Nested Transaction Model and the MOSS Concurrency Control Protocol concept with its locking schemes, locking rules, and extensions.
Lock Based Protocol in DBMS MEDIUM
Locking protocol in database management system is like a set of rules for managing access to data in databases.
Checkpoint in DBMS MEDIUM
In this article, we will learn about the checkpoints in DBMS and their types. We will also cover the advantages of using a checkpoint in DBMS.
Implementation of Locking
In database management systems, locking techniques control concurrency. In this article, you will learn about locking and the implementation of locking in DBMS.
Graph-based protocol
The gist behind the text is to let you know more about the Graph-based protocol method. We will be learning about its type and advantages, and drawbacks.
Two-Phase Locking
This blog introduces lock-based protocols and their types. This blog is about two-phase locking in DBMS with their types.
Timestamp Based Protocol in DBMS
This blog will discuss Time-stamp Based Protocol in DBMS.
Conservative 2-Phase Locking
The gist behind the text is to let you know more about the Conservative 2-Phase Locking (C2PL) method. Read the blog to learn more.
Multiple Granularity Locking in DBMS EASY
Multiple Granularity in DBMS involves organizing data at various levels of detail, enhancing efficiency and flexibility in information retrieval and management.
Multiple Granularity in DBMS EASY
Multiple Granularity in DBMS involves organizing data at various levels of detail, enhancing efficiency and flexibility in information retrieval and management.
Thomas Write Rule in DBMS EASY
In this blog, we'll learn what Thomas write rule is. The three conditions we need to check in it. Then we will look at examples of its implementation, its advantages, and disadvantages.
Serializability in DBMS MEDIUM
Learn about Serializability in DBMS with its types i.e conflict and view serializability. Read in detail about testing serializability in DBMS with examples.
States of Transaction in DBMS EASY
The states of transaction in DBMS control the processes determining whether a transaction will proceed or be terminated.
Log Based recovery in DBMS EASY
Log-based recovery in DBMS ensures data preservation and recovery during system failures. The DBMS records every transaction on stable storage for easy data access during failures.
Starvation in DBMS EASY
This article discusses starvation in DBMS with its reasons, solutions, preventions and advantages of starvation.