Tutorialspoint.dev
Welcome To Tutorialspoint.dev
Officially launched 18th May 2019
DBMS DBMS-Normalization DBMS

DBMS How to find the highest normal form of a relation

To understand this topic, you should have basic idea about Functional Dependency & Candidate keys Normal forms Steps to find the highest normal form of a relation...
DBMS DBMS

DBMS Data Replication

Data Replication is the process of storing data in more than one site or node. It is useful in improving the availability of data. It is simply copying data from a d...
DBMS GATE CS DBMS-Transactions and Concurrency Control

ACID Properties in DBMS

A transaction is a single logical unit of work which accesses and possibly modifies the contents of a database. Transactions access data using read and write operati...
DBMS GATE CS Technical Scripter

Implementation of Locking in DBMS

Locking protocols are used in database management systems as a means of concurrency control. Multiple transactions may request a lock on a data item simultaneously. H...
DBMS GATE CS DBMS

DBMS Concurrency Control Protocols – Lock Based Protocol

First things first, I hope you are familiar to some of the concepts relating to Transactions. What is a Recoverable Schedule? What are Cascading Rollbacks and Casca...
DBMS GATE CS DBMS-Normalization

DBMS Introduction of 4th and 5th Normal form

Prerequisite – Functional Dependency, Database Normalization, Normal Forms If two or more independent relation are kept in a single relation or we can say mult...
DBMS GATE CS DBMS

DBMS Concurrency Control Protocol Graph Based Protocol

Graph Based Protocols are yet another way of implementing Lock Based Protocols. As we know the prime problems with Lock Based Protocol has been avoiding Deadlocks an...
DBMS GATE CS DBMS

DBMS Concurrency Control Protocol Two Phase Locking (2-PL)-I

I think you are now familiar with Concurrency Control Protocols. We have discussed briefly about the first type of Concurrency Control Protocol, i.e., Lock based Prot...
DBMS GATE CS DBMS

DBMS Concurrency Control Protocol Two Phase Locking (2-PL)-II

Now that we are familiar with what is Two Phase Locking (2-PL) and the basic rules which should be followed which ensures serializablity. Moreover we came across the ...
DBMS GATE CS DBMS

DBMS Concurrency Control Protocol Two Phase Locking (2-PL)-III

Prerequisite – Basics of Two Phase Locking protocol(2-PL), Types of 2-PL. Now, we know both Strict 2-PL and Rigorous 2-PL avoids Cascading Rollbacks and ensur...

Subscribe to Our Newsletter