0
One major problem in databases is concurrency. Concurrency problems arise when multiple processes try to update or insert data into a database table at the same time. Such concurrent updates can cause data to become corrupt.
Locking is a strategy that is used to prevent such concurrent updates to data.
When a database system modifies data in one of its tables it first acquires a lock. When a table is locked, only the process the acquired the lock is allowed to modify the data in the table. Other processes will have to wait until the lock is released before they can make their changes. Now, this is a simple representation of how locking works. In reality databases can use different locking strategies.
Depending on the database system, locks can be acquired on entire tables (table-level locking) or on individual rows (row-level locking).
Jalen Gislason
Wiki User
∙ 11y agoMost locks are simply mechanical puzzles. A lock within a lock is a secondary lock which is intended to increase the difficulty of solving the puzzle. It has the intention of increasing the security of the lock.
Add your answer:
Earn +20 pts
What part is speech is lock?
Lock: It depends on how it is used.When it is an object, it is a noun.He held the lock in his hand.Put the lock on the table.Did the lock fall off of the gate?When it is an action, it is a verb.I did not lock the door.Does your computer lock up?I cannot lock my suitcase.
What part of speech is lock?
Lock: It depends on how it is used.When it is an object, it is a noun.He held the lock in his hand.Put the lock on the table.Did the lock fall off of the gate?When it is an action, it is a verb.I did not lock the door.Does your computer lock up?I cannot lock my suitcase.
How do you lock lg rumor?
u lock it by pressing lock.
What is the present tense of lock?
The present tense of "lock" is "locks" for third person singular (he/she/it) and "lock" for all other pronouns (I/you/we/they).
How did they make the lock?
It all depends on what kind of lock. It could be a lock in a canal, a door lock, an ignition lock on a vehicle, a lock of hair, a padlock, or any of many kinds of locks.
Can not lock my protege 3-dial lock?
Problems resetting and lock 3-dial combo lock
What is a crook-lock?
a crook-lock? everyone knows what a crook-lock is, its one of them things that lock away crooks.
How do you lock flip notes on DSi?
when you post your flipnotes on the Hatena website it says lock or don't lock and you press lock or when you send your flip notes to someone it asked you if you wanted to lock or don't lock and you choose and that is how you lock your flip notes on the dsi have fun!!!
Is a combination lock a padlock?
A combination lock is not the same as a padlock. A combination lock could be in a padlock. A padlock can use different lock mechanisms, including a combination lock.
How do you replace the lock on the trunk?
how do i replace a trunk lock with another lock that has a key
How do you lock the keys on my Motorola i465?
Menu, Setting security keypad lock Auto lock on-off Set lock You're set. Puch menu and * to lock or unlock
What was a lock-presser?
what was a lock-presser
