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 will focus on the basic concepts that guarantee the correct execution of transactions. Also, we will discuss concurrency control problems, locking systems, dead locks, and advisory locks.
In this chapter, we will be covering the following topics:
- Transactions
- Explicit locking
- Transaction in functions and procedure
The chapter will enable the developer to debug locking issues, thereby raising performance and increasing user satisfaction. Also, it will help developers to understand the difference between explicit locking and implicit locking, and it will allow them to create...