Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
home
Naukri Code 360
expand-more
Library
expand-more
Database Management System
expand-more
Transaction and Concurrency Control
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.
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.
Author Purswani Dineshkumar
5 upvotes
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.
Author Nidhi Kumari
2 upvotes
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.
Author Shivani Kumari
3 upvotes
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.
Author Ankit Kumar
1 upvote
Two-Phase Locking
This blog introduces lock-based protocols and their types. This blog is about two-phase locking in DBMS with their types.
Author PRASHANT SINGH
1 upvote
Timestamp Based Protocol in DBMS
This blog will discuss Time-stamp Based Protocol in DBMS.
Author Aditya_2bc4
0 upvotes
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.
Author Ankit Kumar
1 upvote
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.
Author Akshay Parashar
0 upvotes
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.
Author Shivani Kumari
0 upvotes
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.
Author Purswani Dineshkumar
2 upvotes
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.
Author Pallavi singh
1 upvote
States of Transaction in DBMS EASY
The states of transaction in DBMS control the processes determining whether a transaction will proceed or be terminated.
Author Nidhi Kumari
1 upvote
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.
Author Sanjana Yadav
1 upvote
Starvation in DBMS EASY
Explore starvation in DBMS: uncover its causes, discover effective solutions and prevention methods, and understand the surprising advantages of managing starvation
Author Divyansh Jain
1 upvote

Scheduling

Scheduling is executing the transactions in a particular sequence. Introducing the idea of scheduling and explaining in the Database Management System what a schedule is. Later we will explain various types of schedules such as serial, non-serial, and serializable schedules in DBMS. Further moving towards the middle we will be introducing the concept of recoverability of schedule in DBMS. What is recoverability in DBMS and how can we implement it will be the key areas of focus. Towards the end, we would be wrapping up with the conditions of schedules to view equivalent.
Introduction to Scheduling in DBMS
In this blog, we’ll learn what scheduling is and different types of schedules, and how a schedule is used to preserve the order of the operation in each individual transaction.
Author Purswani Dineshkumar
1 upvote
Recoverability in DBMS EASY
This blog is about the Recoverability of schedules , types of schedules in database management systems with their suitable examples.
Author PRASHANT SINGH
1 upvote
Condition of Schedules to be View-Equivalent
The article aims to teach you about the conditions when two given schedules are view-equivalent.
Author Ankit Kumar
1 upvote