Transactions and Concurrency Control

The relational model describes the logical unit of processing data as the transaction; transactions can be defined as a set of operations performed in sequence. Relational databases provide a locking mechanism to ensure the integrity of transactions.

In this chapter, we focus on the basic concepts that guarantee the correct execution of transactions. Also, we will discuss the concurrency control problems, locking systems, dead locks, and advisory locks.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset