DBMS is a software that manages the data for efficient storage and fast retrievals of data from database. MySQL, IBM Db2, Oracle, PostgreSQL etc. are… [Read More]

Validation based protocol avoids the concurrency of the transactions and works based on the assumption that if no transactions are running concurrently then no interference… [Read More]

In the previous chapter, you learned lock based protocol in DBMS to maintain the integrity of database. In this chapter, you will learn Timestamp based… [Read More]

A lock is kind of a mechanism that ensures that the integrity of data is maintained. It does that, by locking the data while a… [Read More]

In the previous chapter, you learned how to recover a transaction using log based recovery method in DBMS. In this guide, you will learn how… [Read More]

In the previous chapters, you learned how to identify a recoverable schedule and what kind of failures can occur in DBMS. In this chapter, you… [Read More]

In DBMS there are several transactions running in a specified schedule. However sometimes these transactions fail due to several reasons. In previous tutorial, we learned… [Read More]

In this guide, you will learn a very important concept in DBMS: Recoverability of Schedule. There are times when few transactions in a schedule fail,… [Read More]

In this guide, you will learn the difference between DBMS (Database Management System) and RDBMS (Relational Database Management System). What is a DBMS (Database Management… [Read More]

INSERT statement is used to insert the data into the table in database. You can insert values of specified columns or an entire record containing… [Read More]