Insert and Delete Operations | Database Management System

Insert and Delete Operations | Database Management System

In addition to read/write operations, must handle delete and insert operations to the database.
Deletion with two-phase locking:

  • May only be performed if the transaction deleting the tuple has an exclusive lock on the tuple to be deleted.

Insertion with two-phase locking:

  • A transaction that inserts a new tuple into the database is given an X-mode lock on the tuple.