notes-shivam

SYLLABUS

1 min read

  1. Transaction management:
    1. Definition of transaction
    2. State of Transaction
    3. ACID properties
    4. Schedules
    5. Serializability of schedules
  2. Concurrency control
    1. Lock based concurrency control (2PL), Strict 2PL, Time stamping method
  3. Deadlock and its handling:
    1. Definition
    2. Wait-Die and Wound-Wait methods.
  4. Database Recovery:
    1. Log Based Recovery
    2. Check points
    3. Shadow Paging

Graph View