- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Explain the concept of recoverability in DBMS
The characteristics of non-serializable schedules are as follows −
The transactions may or may not be consistent.
The transactions may or may not be recoverable.
So, now let’s talk about recoverability schedules.
We all know that recoverable and irrecoverable are non-serializable techniques,
If a transaction does a dirty read operation from an uncommitted transaction and commits before the transaction from where it has read the value, then such a schedule is called an irrecoverable schedule.
Let us consider a two transaction schedules as shown below −
|-||Read(A) ///Dirty Read|
The above schedule is a irrecoverable because of the reasons mentioned below −
The transaction T2 which is performing a dirty read operation on A.
The transaction T2 is also committed before the completion of transaction T2.
The transaction T1 fails later and there are rollbacks.
The transaction T2 reads an incorrect value.
Finally, the transaction T2 cannot recover because it is already committed.
If any transaction that performs a dirty read operation from an uncommitted transaction and also its committed operation becomes delayed till the uncommitted transaction is either committed or rollback such type of schedules is called as Recoverable Schedules.
Let us consider two transaction schedules as given below −
|-||Read(A) ///Dirty Read|
|Commit // delayed|
The above schedule is a recoverable schedule because of the reasons mentioned below −
The transaction T2 performs dirty read operation on A.
The commit operation of transaction T2 is delayed until transaction T1 commits or rollback.
Transaction commits later.
In the above schedule transaction T2 is now allowed to commit whereas T1 is not yet committed.
In this case transaction T1 is failed, and transaction T2 still has a chance to recover by rollback.
- Explain the concept of Normalization in DBMS?
- Explain the concept of indexing in DBMS
- Explain the cardinality concept in DBMS?
- Explain the concept of secondary index in DBMS
- Explain the concept of DBMS schema with examples?
- Explain the concept of the traditional file system in DBMS?
- Explain the concept of foreign keys with examples(DBMS)?
- Explain the concept of primary key with an example (DBMS)?
- Explain the concept of key attributes with an example in DBMS?
- What are different types of recoverability of schedules(DBMS)?
- Explain the concept of magnetic disk with the help of a diagram(DBMS)
- Explain the concept of amalgamation
- Explain the concept of Regular expression.
- Explain the concept of trial balance
- Explain the characteristics of DBMS?