Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
Expert Solution & Answer
Book Icon
Chapter 10, Problem 8RQ

Explanation of Solution

Lock:

Lock is the process that ensures the unique use of data item for particular transaction. If the data item is locked by one transaction, then the other transactions cannot use the data item until the first transaction unlocks the data item.

Working procedure of lock:

  • A transaction requires lock prior to lock and unlock the transactions. The lock prior is responsible for assigning and releasing locks. It is otherwise called as “lock manager”...

Blurred answer
Students have asked these similar questions
Why aren't spin-locks used in applications? Instead, what do they do?
What is a shared lock? What is an exclusive lock?
What are global locks ?
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Security (MindTap Cours...
Computer Science
ISBN:9781337102063
Author:Michael E. Whitman, Herbert J. Mattord
Publisher:Cengage Learning