Advanced Database Management System - Tutorials and Notes: Important properties a schedule of transactions must have to maintain a database in a consistent state

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Tuesday, 17 April 2018

Important properties a schedule of transactions must have to maintain a database in a consistent state



What are the important properties a schedule of transactions must have to maintain a database in a consistent state?


Properties of a schedule of transactions

We need a schedule which

  • is serializable 
    • a concurrent schedule which produces same result as a serial schedule is called serializable schedule

  • is recoverable 
    • a schedule with the ability to recover from failures

  • is cascadeless 
    • a schedule that avoids/eliminates cascading rollback in case of aborting of one or more transactions.

  • preserves the order of the operations in each of the individual transactions

*********




important properties of schedules in dbms

why a schedule need to be serializable

cascadeless schedules

preserving the consistency of a database

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents