Lock-based protocols in DBMS Theory - Mini Project: Build & Apply

Understanding Lock-Based Protocols in Databases

📖 Scenario: You are managing a small library database where multiple users can borrow and return books. To keep the data consistent, you need to control how users access the records using lock-based protocols.

🎯 Goal: Build a simple step-by-step example that shows how lock-based protocols work to prevent conflicts when multiple users access the library database.

📋 What You'll Learn

Create a dictionary called locks to represent the current locks on books

Add a variable called lock_type to specify the type of lock requested

Use a loop with for book, status in locks.items() to check lock compatibility

Add a final step to update the locks dictionary with the new lock

💡 Why This Matters

🌍 Real World

Lock-based protocols are used in databases to prevent multiple users from changing the same data at the same time, which keeps data accurate and consistent.

💼 Career

Understanding lock-based protocols is important for database administrators and developers to design systems that handle multiple users safely without data errors.

1

Create the initial locks dictionary

Create a dictionary called locks with these exact entries: 'Book1': 'Unlocked', 'Book2': 'Unlocked', 'Book3': 'Unlocked' to represent the current lock status of each book.

DBMS Theory

# Create the locks dictionary with initial statuses
# Your code here

Need a hint?

Use a dictionary with book names as keys and 'Unlocked' as the initial value for each.

2

Add the lock_type variable

Add a variable called lock_type and set it to the string 'Shared' to represent the type of lock a user wants to acquire.

DBMS Theory

locks = {'Book1': 'Unlocked', 'Book2': 'Unlocked', 'Book3': 'Unlocked'}
# Set the lock_type variable
# Your code here

Need a hint?

Just assign the string 'Shared' to the variable lock_type.

3

Check lock compatibility with a loop

Use a for loop with variables book and status in locks.items() to check if the current lock status is compatible with the requested lock_type. For simplicity, assume that if a book is 'Unlocked', it is compatible.

DBMS Theory

locks = {'Book1': 'Unlocked', 'Book2': 'Unlocked', 'Book3': 'Unlocked'}
lock_type = 'Shared'
# Check lock compatibility
# Your code here

Need a hint?

Use for book, status in locks.items(): and check if status == 'Unlocked'.

4

Update the locks dictionary with the new lock

Update the locks dictionary to set the lock on 'Book1' to the value of lock_type, simulating that the user has acquired a shared lock on Book1.

DBMS Theory

locks = {'Book1': 'Unlocked', 'Book2': 'Unlocked', 'Book3': 'Unlocked'}
lock_type = 'Shared'
for book, status in locks.items():
    if status == 'Unlocked':
        compatible = True
    else:
        compatible = False
# Update the lock on 'Book1'
# Your code here

Need a hint?

Assign lock_type to locks['Book1'] to update the lock.