Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482



Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 10, Problem 4P
Textbook Problem

Using a simple example, explain the use of binary and shared/exclusive locks in a DBMS.

Program Plan Intro


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

Explanation of Solution

Types of lock:

The process of locking system can be divided into two types. They are: binary lock and shared/exclusive lock.

Binary locks:

  • The binary locking system has only two states. They are,
    • Locked (1) state
    • Unlocked (0) state
  • If the process occurred in database, table, or row is locked by the transaction, the other transaction cannot use the objects until the object is unlocked.
  • The lost update problem can occurred in binary lock. Because, the lock is not released until the transaction finished. So, updating the transaction can takes time and it is considered as too restrictive lock type.  The concurrency problems never occurs this locking system because DBMS does not allow two transactions of single object at same time.

Shared/exclusive locks:

Exclusive locks:

It is a lock type which is used to enforce the concurrency control of the transaction. Exclusive lock is issued when the data item want to update and not processed by any of the transaction. It does not allow other transactions to access the database.

Circumstances of exclusive lock to be granted:

  • The exclusive lock is exists in the object when the access of data item specifically reserved for a transaction...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 10 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What are the two basic types of keys?

Precision Machining Technology (MindTap Course List)

VocabularyState the meaning of the following terms: Ampere _____ Direct current _____ Alternating current _____...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Explain the relationship between logical and physical design.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

How does longitudinal recording differ from perpendicular recording? (374)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

List some applications that use low-pressure piping.

Welding: Principles and Applications (MindTap Course List)