Concurrency Control, Locking and Serializability

Start with transactions

Begin with the Databases Topic 7 flashcards for an introduction to transactions, their properties and concurrency control. The deck includes examples of transactions as well as cards on transaction support. You can work through the cards first, then return to individual prompts as you study.

For a visual overview, open the Transactions mind map. It brings together transaction definitions, ACID properties, database architecture and concurrency control. Use it alongside the flashcards to see how the terms in the deck fit into the wider picture presented by the map.

Explore concurrency control

The Concurrency Control mind map covering lost updates, uncommitted data and inconsistent retrievals is a useful next step. It also introduces pessimistic and optimistic techniques. Another mind map on concurrency control sets out the problem and the objective of allowing transaction throughput while preventing interference among users.

Compare the ideas in the maps with the concurrency control cards in Databases Topic 7. You can use the maps to organize the terms, then use the cards to recall them without looking at the overview.

Practice with quizzes

The Transactions quiz asks about transaction properties and locks. Try it after the flashcards and maps, then return to those resources to review terms you found difficult. Data Concurrency and Locking offers another set of questions about transactions and executing statements outside a transaction.

For another way to check the material, the C192 Transaction Management quiz also asks about transaction properties and locks. Compare its questions with those in Transactions as you practice.

Continue through the unit

This topic is one section of Storage, Query Processing and Transactions in Databases and data science. The resources here give you a way to explore transactions and concurrency control within that unit. Choose a map and a quiz to use together as you study.