Database Management Systems Course - 2nd Database Course - EduMeFree

123-456-7890

تابعنا علي:

دروس مباشرة نشرح فيها مقرر نظم إدارة قواعد البيانات – ويحدث تباعاً Database Management Systems Course

محتوى الكورس

Database Management Systems – Introduction to The course

Transaction Processing – Part 1 -01- Single User System VS Multi user Systems

Transaction Processing – Part 1 -02- Transaction Read and Write Operations

Transaction Processing – Part 1 -03- Steps of Read and Write Operations

Transaction Processing – Part 1 -04- Why Concurrency Control is needed?

Transaction Processing – Part 1 -05- Why Recovery is needed ?

Transaction Processing – Part 2 -01- Review on Part 1

Transaction Processing – Part 2 -02- Transaction States

Transaction Processing – Part 2 -03 – System Log

Transaction Processing – Part 2 -04 – Transaction Properties – ACID Properties

Transaction Processing – Part 2 -05- Schedules and conflict operations

Transaction Processing – Part 2 -06- Recoverable Schedules

Transaction Processing – Part 2 -07 – Cascading Rollback and Cascadless schedule

Transaction Processing – Part 2 -08 – Strict Schedules

Chapter 21,17-Transaction Processing – Part 3

Transaction Processing – Exercises On Strict , Cascadeless and Recoverable Schedules

Concurrency Control – Part 1 – 01 – What is Concurrency Control

Concurrency Control – Part 1 – 02 – Locking Based Protocols

Concurrency Control – Part 1 – 03 – lock Manager and Locks Conversion

Concurrency Control – Part 1 – 04 – Two Phase Locking – Basic Version

Concurrency Control – Part 1 – 05 – Deadlock and Starvation Problems

Concurrency Control – Part 2 – 01 – What is Transaction TimeStamp ?

Concurrency Control – Part 2 – 02 – The Idea Behind TimeStamp Ordering Protocl

Concurrency Control – Part 2 – 03 – Basic Timestamp Ordering Protocol

Concurrency Control – Part 2 – 04 – Strict Timestamp Ordering Protocol

Concurrency Control – Part 2 – 05 – Thoma’s Write Rule

Concurrency Control – Part 2 – 06 – Validation Concurrency Control Schema

Concurrency Control – Part 2 – 07 – Granularity Of Data Items

Concurrency Control – Part 2 – 08 – Lock-IS , Lock-IX and Lock-SIX Modes

Concurrency Control – Part 2 – 09- Mltiple Granularity locking

Exercise On Disk Storage and indexing

exercises on Concurrency control and Db Recovery

Exercises on distributed database