DBMS Notes

Serial Vs. Non-Serial Schedules

Serial schedules always holds the following properties

  • Consistent
  • Recoverable
  • Cascadeless
  • Strict

But Non- Serial schedules are NOT always holds the following properties

  • Consistent
  • Recoverable
  • Cascadeless
  • Strict

As in Serial schedule execution of transaction is very slow because on one transaction can execute at a time. So, we did not prefer the use of serial schedule because time is the money.

 But In Non-Serial schedule,  parallel execution of multiple transaction is possible at a time. So, non-serial schedules are fast in execution but there may exist concurrency problem in Non-serial which leads toward

  • Non-Consistency
  • Non-Recoverability
  • Non-Cascadeless
  • Non-Strict

We use different methods to remove concurrency problems and make sure that the Non-serial schedule will always be

  • Consistent
  • Recoverable
  • Cascadeless
  • Strict

Conclusion: Non-serial schedules are used in such a way that concurrency problem is eliminated through different approaches.

Help Other’s By Sharing…

Contact Us

Burewala, Vehari, Punjab, Pakistan

cstaleem1@gmail.com

Website: CStaleem.com

Pin It on Pinterest